C#数据库练习二(绑定数据) 傷城~ 2021-06-24 16:10 353阅读 0赞 第一步:添加类库 ![2789632-0409310bc9732c72.png][] RL.DBUtility.dll 第二步:添加配置文件 ![2789632-46fc530eee00205e.png][] 添加配置文件 配置文件内容 ![2789632-d5bbcdbaf74e1d94.png][] 配置文件内容 代码: <?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 ![2789632-a657e2d43a779524.png][] 控件命名 第四步功能代码编写: 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]; } } } 注意: ![2789632-dc49ff33967b7885.png][] 与引用的框架相匹配 结果显示: ![2789632-f180d36161cc8640.png][] 结果显示 扩展:增加搜索功能 textBox的name:textId;button的name:btnSearch ![2789632-9271870156ee7a15.png][] 搜索界面 代码: 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.输入断点 1. ![2789632-f609ce899a75215f.png][] 输入id 1. ![2789632-74cca69518cda8a2.png][] 调试查看 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) { } } } 注意: ![2789632-e60157305893ba44.png][] 利用参数代替变量 [2789632-0409310bc9732c72.png]: /images/20210615/34b0901b3c2f40cab151791cdeb4bf00.png [2789632-46fc530eee00205e.png]: /images/20210615/171b6a09599a45f2b25c0211e0bb217c.png [2789632-d5bbcdbaf74e1d94.png]: /images/20210615/2e7d0ce7e2044534a6b3d962724de8e6.png [2789632-a657e2d43a779524.png]: /images/20210615/ea43fb14f8f2488e9e5fd6bcc23e7873.png [2789632-dc49ff33967b7885.png]: /images/20210615/961bcc3a5fd3430dac2efd260533fe39.png [2789632-f180d36161cc8640.png]: /images/20210615/55f55322308a487eaad33a3298932332.png [2789632-9271870156ee7a15.png]: /images/20210615/7ad18525915448c09336cd6c4780829e.png [2789632-f609ce899a75215f.png]: /images/20210615/5f314f3d121245c8baeb6c1c90c0bd75.png [2789632-74cca69518cda8a2.png]: /images/20210615/b6b7532dceab45e584a10dd40498f19c.png [2789632-e60157305893ba44.png]: /images/20210615/a97570e95732420eb9d562f4eb25d524.png
还没有评论,来说两句吧...