Beispiel #1
0
        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);
            }
        }
Beispiel #2
0
        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();
        }