C#数据库练习二(绑定数据)
第一步:添加类库
第二步:添加配置文件
配置文件内容
代码:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<add name="MainConn" connectionString="server=.;database=Test_SQL;user=sa;pwd=0000;Max Pool Size = 512;"
providerName="System.Data.SqlClient" />
</configuration>
第三步添加控件
注意:此处的id改为Id,数据库中为Id
第四步功能代码编写:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using RL.DBUtility;
namespace SQL_Conn
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Leave(object sender, EventArgs e)
{
}
private void dgvGrade_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string sql = "select * from dbo.Student";
DataSet ds = DbHelperSQL.Query(sql);//DbHelperSQL.Query(sql)返回类型未dataset
dgvGrade.DataSource = ds.Tables[0];
}
}
}
注意:
结果显示:
扩展:增加搜索功能
textBox的name:textId;button的name:btnSearch
代码:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using RL.DBUtility;
namespace SQL_Conn
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
int id = int.Parse(textId.Text);//获取id
string sql = "select * from dbo.Student where Id = " + id;
DataSet ds = DbHelperSQL.Query(sql);
}
private void textId_TextChanged(object sender, EventArgs e)
{
}
}
}
调试运行:
1.输入断点
4添加string输入类型
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using RL.DBUtility;
using System.Data.SqlClient;
namespace SQL_Conn
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
//int id = int.Parse(textId.Text);//获取id
string Name = textName.Text;
//string sql = "select * from dbo.Student where Name = '" + name + "'";
//string sql = "select * from dbo.Student where Id = " + id;
string sql = "select * from dbo.Student where Name = @Name";
SqlParameter[] pms = {
new SqlParameter("@Name",SqlDbType.NChar,50)
};//创建参数
pms[0].Value = Name;
DataSet ds = DbHelperSQL.Query(sql,pms);
}
private void textId_TextChanged(object sender, EventArgs e)
{
}
}
}
注意: