先做连接如SqlConnection _SqlConn = new SqlConnection("Server=.;Database=Test;UID=sa;PWD=123"); 然后执行SQL语句就可以了 //获取数据DataTable _DataTable =new DataTable(); _SqlConn.Open(); SqlDataAdapter _Command = new SqlDataAdapter("SQL语句", _SqlConn); _Command.Fill(_DateTable); //执行命令 _SqlConn.Open(); SqlCommand _Command = new SqlCommand("Sql语句",_SqlConn); _Command.ExecuteNonQuery(); _SqlConn.Close();
你说的是SQL数据库吗?那个应该很简单吧
你如果是新手的话,直接用数据源进行配置,可以支持每个字段与控件(如TEXT)进行绑定。
这个比较简单我这里这段代码就是数据库操作的,你可以看下数据库操作就是5个步骤:1,开路 2,做车 3,仓库 4,拉货到仓库 5,显示我的Q709152,多多交流,也才开始学习using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace shujushu { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) {
TreeNode xueyuan = new TreeNode("学院系统"); treeView1.Nodes.Add(xueyuan); //_________________________________________ SqlConnection lu = new SqlConnection("server=S513;database=the14;user id = sa;pwd=;"); SqlDataAdapter che = new SqlDataAdapter("select distinct(所在系别) from 学生",lu); DataSet cangku = new DataSet(); che.Fill(cangku); //___________________________________________ for (int i = 0; i < cangku.Tables[0].Rows.Count; i++) { string ii; ii = cangku.Tables[0].Rows[i][0].ToString(); TreeNode xibie = new TreeNode(); xibie.Text = ii; // _______________________________________ SqlDataAdapter banjiche = new SqlDataAdapter("select distinct(班级) from 学生 where 所在系别='" + ii+ "'", lu); DataSet banjicangku = new DataSet(); banjiche.Fill(banjicangku); for (int j = 0; j < banjicangku.Tables[0].Rows.Count; j++) { string jj; jj = banjicangku.Tables[0].Rows[j][0].ToString(); TreeNode banji = new TreeNode(); banji.Text = jj; xibie.Nodes.Add(banji); /*if (banji.Checked ) { SqlDataAdapter che3 = new SqlDataAdapter("select 姓名 from 学生 where 班级='" + banji + "'", lu); DataSet cangku3 = new DataSet(); che3.Fill(cangku3);
for (int k = 0; k < cangku3.Tables[0].Rows.Count; k++)
{ string kk; kk = cangku3.Tables[0].Rows[k][0].ToString(); ListViewItem xingmingx = new ListViewItem(); xingmingx.Text = kk; listView1.Items.Add(xingmingx); } }*/ } xueyuan.Nodes.Add(xibie);
先做连接如SqlConnection _SqlConn = new SqlConnection("Server=.;Database=Test;UID=sa;PWD=123"); 然后执行SQL语句就可以了
//获取数据DataTable _DataTable =new DataTable();
_SqlConn.Open();
SqlDataAdapter _Command = new SqlDataAdapter("SQL语句", _SqlConn);
_Command.Fill(_DateTable); //执行命令
_SqlConn.Open();
SqlCommand _Command = new SqlCommand("Sql语句",_SqlConn);
_Command.ExecuteNonQuery();
_SqlConn.Close();
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace shujushu
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
TreeNode xueyuan = new TreeNode("学院系统");
treeView1.Nodes.Add(xueyuan);
//_________________________________________
SqlConnection lu = new SqlConnection("server=S513;database=the14;user id = sa;pwd=;");
SqlDataAdapter che = new SqlDataAdapter("select distinct(所在系别) from 学生",lu);
DataSet cangku = new DataSet();
che.Fill(cangku);
//___________________________________________ for (int i = 0; i < cangku.Tables[0].Rows.Count; i++)
{
string ii;
ii = cangku.Tables[0].Rows[i][0].ToString();
TreeNode xibie = new TreeNode();
xibie.Text = ii; // _______________________________________ SqlDataAdapter banjiche = new SqlDataAdapter("select distinct(班级) from 学生 where 所在系别='" + ii+ "'", lu);
DataSet banjicangku = new DataSet();
banjiche.Fill(banjicangku); for (int j = 0; j < banjicangku.Tables[0].Rows.Count; j++)
{
string jj;
jj = banjicangku.Tables[0].Rows[j][0].ToString();
TreeNode banji = new TreeNode();
banji.Text = jj;
xibie.Nodes.Add(banji); /*if (banji.Checked )
{
SqlDataAdapter che3 = new SqlDataAdapter("select 姓名 from 学生 where 班级='" + banji + "'", lu);
DataSet cangku3 = new DataSet();
che3.Fill(cangku3);
for (int k = 0; k < cangku3.Tables[0].Rows.Count; k++)
{
string kk;
kk = cangku3.Tables[0].Rows[k][0].ToString();
ListViewItem xingmingx = new ListViewItem(); xingmingx.Text = kk; listView1.Items.Add(xingmingx);
}
}*/
} xueyuan.Nodes.Add(xibie);
} }
}
}