首先此操作需要自己增加调用的库有System.Data.SqlClient
调用好库后进行下一步操作:连接数据库
string datasource = "10.61.1.77,1433";//数据库服务器
string database = "database";//库名
string userid = "id";//数据库sqlserver身份验证登录id
string password = "";//数据库sqlserver身份验证登录密码
SqlConnection sql = new SqlConnection("data source="+datasource+";Database="+database+";user id="+userid+";password="+password);
sql.Open();
第三步操作:写sql server查询语句:
string command1 = "select Department from KS";
SqlCommand sqlCommand1 = new SqlCommand(command1 , sql);
第四步操作:将查询结果传入List<string> strings中:
SqlDataReader sqlDataReader = sqlCommand1.ExecuteReader();
List<string> strings = new List<string>();
while (sqlDataReader.Read())
{
string a=sqlDataReader.GetString(0);
if (! strings.Contains(a))
{
strings.Add(a);
}
}
第五步:向menustrip控件中添加items:
for (int i = 0; i < strings.Count; i++)
{
menuStrip1.Items.Add(strings[i]);
}
(menustrip2 同样使用上述方法添加item)
注意骚操作来了:去设计界面(Form1[设计])双击menustrip1
操作视频去我主页找《骚操作》
ps:其实没啥骚的很普通
注意关键步骤来了:(不知道该叫啥):
双击menustrip1后会出现
private void menuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
{
}
在这个方法中继续写代码(我菜的很所以没把数据库连接放在方法外导致每个方法都需要反复写同样的语句(但它简单啊,control+c,control+v就可以了基本不用改,出问题的可能性应该会低一点吧,谁知道呢,反正我这没毛病))
(数据库连接代码略)
string a;
a=e.ClickedItem.Text;//这个e是private void menuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)里的形参e
ClickedItem这个是关键这个类(我也不确定是不是类但八成是个类)中有很多方法自己摸索吧。
全部代码附上
using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using System.Data.SqlClient;using System.Reflection;using System.Collections;namespace FormForRegister{public partial class Form1 : Form{public Form1(){InitializeComponent();}private void Form1_Load(object sender, EventArgs e){string datasource = "";string database = "";string userid = "";string password = "";string command1 = "";SqlConnection sql = new SqlConnection("data source="+datasource+";Database="+database+";user id="+userid+";password="+password);sql.Open();SqlCommand sqlCommand1 = new SqlCommand(command1 , sql);SqlDataReader sqlDataReader = sqlCommand1.ExecuteReader();List<string> strings = new List<string>();while (sqlDataReader.Read()){string a=sqlDataReader.GetString(0);if (! strings.Contains(a)){strings.Add(a);}}for (int i = 0; i < strings.Count; i++){menuStrip1.Items.Add(strings[i]);}menuStrip1.Text = strings[0];sql.Close();string command2="select Kname from ks where Department=" +"\'"+ menuStrip1.Text+"\'";sql.Open();SqlCommand sqlCommand2 = new SqlCommand(command2, sql);SqlDataReader sqlDataReader2 = sqlCommand2.ExecuteReader();List<string> strings1 = new List<string>();while (sqlDataReader2.Read()){string a2 = sqlDataReader2.GetString(0);if (!strings1.Contains(a2)){strings1.Add(a2);}}for (int i = 0; i < strings1.Count; i++){menuStrip2.Items.Add(strings1[i]);}sql.Close();}private void menuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e){string a;a=e.ClickedItem.Text;string datasource = "";string database = "";string userid = "";string password = "";SqlConnection sql = new SqlConnection("data source=" + datasource + ";Database=" + database + ";user id=" + userid + ";password=" + password);sql.Open();string command = "select Kname From KS where Department=" + "\'" + a + "\'";SqlCommand cmd = new SqlCommand(command, sql);SqlDataReader sqlDataReader = cmd.ExecuteReader();List<string> strings = new List<string>();while (sqlDataReader.Read()){string b = sqlDataReader.GetString(0);if (!strings.Contains(a)){strings.Add(b);}}menuStrip2.Items.Clear();for (int i = 0; i < strings.Count; i++){menuStrip2.Items.Add(strings[i]);}sql.Close();}}}
最后 一曲歌词奉上“你快回来~”(纪念我为此掉落的67根头发)
C# 从SQL server 数据库中调取数据并将返回结果加入menustrip控件中 并对单击控件选项后变化进行编辑