Question

根据textbox中的姓名，查询数据库的记录。gridview绑定数据库，数据源是sqldatasource,应该怎么写啊

Answer 1

//设置连接字符串
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=G:\主界面2\学生成绩管理.mdb;";
OleDbConnection objConnetion = new OleDbConnection(strConnection);
objConnetion.Open();
//显示连接成功
MessageBox.Show("数据库连接成功！");
//定义SQL命令
string strSql = "SELECT * FROM 学生 ";
strSql += "WHERE 姓名='" + textBox1.Text + "'";

//新建Command命令对象，执行SQL命令
OleDbCommand objCommand = new OleDbCommand(strSql, objConnetion);
//新建DataAdapter数据匹配器对象，暂存命令对象的执行结果(数据集)
OleDbDataAdapter da = new OleDbDataAdapter(objCommand);
//新建DataSet数据集对象，存放从数据匹配器中传送过来的数据
DataSet ds = new DataSet();
da.Fill(ds);
//定义数据显示控件DataGridView的数据源
dataGridView1.DataSource = ds.Tables[0];

Answer 2

string connStr = @"Data Source=.;Initial Catalog=MySchool;User ID=sa;pwd=123";//连接数据库
StringBuilder sb = new StringBuilder();
sb.AppendLine("select * From Student");//查询SQL语句
connstr.Open();
ds = new DataSet();
adpter = new SqlDataAdapter(sb.ToString (),connstr);
adpter.Fill(ds,"Student");//填充数据集
this.dataGridView1 .DataSource =ds.Tables ["Student"];//绑定数据源

DataView dv = new DataView(ds.Tables["Student"]);
string name = this.textBox1.Text;
dv.RowFilter = string.Format("stuName={0}", name);//筛选条件
this.dataGridView1.DataSource = dv;//重新绑定数据源

Answer 3

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DBString %>"
SelectCommand="SELECT [PieMoney], [Account] FROM [Account] WHERE ([Account] = @Account)">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" DefaultValue="12" Name="Account"
PropertyName="Text" Type="String" />
</SelectParameters>
</asp:SqlDataSource>