apsx 页面: GridView 控件,Button控件,TextBox控件
aspx.cs页面
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;public partial class essay : System.Web.UI.Page
{protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){bind();}}// 配置 数据库连接语句public SqlConnection SqlConnection(){string conn = ConfigurationManager.AppSettings["ConnectionString"].ToString();SqlConnection sqlconn = new SqlConnection(conn);return sqlconn;} public void bind (){// 实例化一个连接语句SqlConnection sqlconn = SqlConnection();sqlconn.Open();//查询语句string strsql = "select * from tb_Student";// dataAdaption 提供 连接 dataset 和 数据库 的 桥梁 使用 command对象在数据源中 执行sql命令 以便将数据 加载到dataset 中 确保dataset中数据的更改与数据源保持一致SqlDataAdapter myDa = new SqlDataAdapter(strsql,sqlconn);//实例化一个 DataSet 命名为myDsDataSet myDs = new DataSet();
//搭桥myDa.Fill(myDs);GridView1.DataSource = myDs;GridView1.DataBind();sqlconn.Close();}protected void btnSelect_Click(object sender, EventArgs e){if (txtName.Text != ""){SqlConnection sqlconn = SqlConnection();sqlconn.Open();string strsql = "select * from tb_Student where Name=@Name";//@Name的容器是SqlCommend
//command对象 返回数据 修改数据 运行存储过程 发送参数信息SqlCommand myCm = new SqlCommand(strsql, sqlconn);
//ParametersmyCm.Parameters.Add("@Name", SqlDbType.VarChar, 20).Value = txtName.Text;SqlDataAdapter myDa = new SqlDataAdapter(myCm);DataSet myDs = new DataSet();myDa.Fill(myDs);GridView1.DataSource = myDs;GridView1.DataBind();myDa.Dispose();myDs.Dispose();sqlconn.Close();}else{bind();}}
}
Web.Config连接语句
<appSettings><add key="GetCon" value="server=DESKTOP-5KVS068\SQLEXPRESS;uid=sa;pwd=;database=db_NetShop" /><add key="ConnectionString" value="server=DESKTOP-5KVS068\SQLEXPRESS;database=db_09;UId=sa;password=''"/></appSettings>