private void btnClick(object sender, EventArgs e) { //Button btn = sender as Button; //Type type = Type.GetType("GesCS.Login"); //Form frm = (Form) Activator.CreateInstance(type); //frm.ShowDialog(); Utility.SqliteHelper sh = new Utility.SqliteHelper(); DataSet ds = sh.QueryBySQL("select * from sys_menu"); foreach (DataRow dr in ds.Tables[0].Rows) { //ToolStripMenuItem item = new ToolStripMenuItem() { Name=dr["name"].ToString(),Text=dr["text"].ToString(), Tag = dr["tag"].ToString() }; //if(Convert.ToInt32(dr["fid"])==0) // menuStrip1.Items.Add(item); //foreach (DataRow dr2 in ds.Tables[0].Rows) //{ // if (Convert.ToInt32(dr2["fid"]) == Convert.ToInt32(dr["id"])) // { // ToolStripMenuItem item2 = new ToolStripMenuItem() { Name = dr["name"].ToString(), Text = dr["text"].ToString(), Tag = dr["tag"].ToString() }; // item.DropDownItems.Add(item2); // } //} MenuAdd(dr); } }
private void button1_Click(object sender, EventArgs e) { Utility.SqliteHelper sh = new Utility.SqliteHelper(); DataSet ds = sh.QueryBySQL("select name from test where id=1"); textBox1.Text = ds.Tables[0].Rows[0][0].ToString(); }