C#操作sql server数据库实例源代码.docVIP

C#操作sql server数据库实例源代码 1.实现的界面 2.要导出的命名空间 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; using System.Configuration; 3.app.config配置 ?xml version=1.0 encoding=utf-8 ? configuration configSections /configSections connectionStrings add name=MingXinERP.Properties.Settings.mingxindataConnectionString1 connectionString=Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\App_Data\mingxindata.mdf;Integrated Security=True;User Instance=True providerName=System.Data.SqlClient / /connectionStrings /configuration 4.窗口load事件的实现 此功能和刷新按钮的功能是一样的. private void frmclientinfo_Load(object sender, EventArgs e) { try { string sql; string strcon = ConfigurationManager.ConnectionStrings[MingXinERP.Properties.Settings.mingxindataConnectionString1].ToString(); SqlConnection con = new SqlConnection(strcon); con.Open(); sql = select top 12 * from (select top 12 * from 客户信息 order by 编号 desc) a order by 编号 asc;//显示最后的12条记录 SqlDataAdapter da = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); da.Fill(ds, abc); dataGridView1.DataSource = ds.Tables[abc].DefaultView; } catch (Exception ex) { MessageBox.Show(ex.Message); } } 5. dataGridView_CellClick的实现 是单击dataGridView单元格所触发的事件. private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { txtid.Text = Convert.ToString(dataGridView1[0, dataGridView1.CurrentCell.RowIndex].Value); txtname.Text = Convert.ToString(dataGridView1[1, dataGridView1.CurrentCell.RowIndex].Value); cbotype.Text = Convert.ToString(dataGridView1[2, dataGridView1.CurrentCell.RowIndex].Value); cbofrom