Asp.Net代码备忘

来源：互联网发布：facebook代理软件编辑：程序博客网时间：2024/06/04 17:42

该篇代码适用于VS2012与SQL2012的开发环境，其它环境未经测试（未标注则默认为后台代码）

引用连接字符串：

string sqlconn = System.Configuration.ConfigurationManager.ConnectionStrings["BookConnectionString"].ConnectionString;

数据绑定（从控件读取的值与数据库中的列名绑定）：

sqlInsertCommand.CommandText = @"Insert into [Bookdetail] ([book_name]) values (@book_name)";string book_name = TextBox1.Text;sqlInsertCommand.Parameters.AddWithValue("@book_name", book_name);

数据绑定至控件（从数据库中读取数据写入到控件）：

using (SqlCommand cmd = new SqlCommand("select book_name from Bookdetail where book_id=@book_id ", myConnection)){    cmd.Parameters.AddWithValue("@book_id", book_id);    TextBox1.Text = cmd.ExecuteScalar().ToString();}

执行数据库操作语句：

myCommand.ExecuteNonQuery();

获取前台控件中的控件值（如动态获取datalist中的label的值）
前台：

<asp:DataList ID="DataList1" runat="server" DataKeyField="shop_id" DataSourceID="SqlDataSource1">    <ItemTemplate>        <asp:Label ID="shop_idLabel" runat="server" Text='<%# (Eval("shop_id")) %>' Visible="False" />        <asp:Button ID="Button1" CommandArgument='<%#Eval("shop_id") %>' ValidationGroup='<%#((DataListItem)        Container).ItemIndex %>' runat="server" OnClick="Button1_Click" Text="Button1"/>    </ItemTemplate></asp:DataList>

后台：

Button bt = sender as Button;int count = Convert.ToInt32(bt.ValidationGroup.ToString());/*获取要验证的组的值*/Label lb = (Label)DataList2.Items[count].FindControl("shop_idLabel");/*通过count值来定位shop_idlabel*/string shopid =lb.Text;int shop_id = Convert.ToInt32(shopid);

会员注册页代码：

string sqlconn = System.Configuration.ConfigurationManager.ConnectionStrings["BookConnectionString"].ConnectionString;SqlConnection myConnection = new SqlConnection(sqlconn);myConnection.Open();SqlCommand sqlSelectCommand = new SqlCommand("select [user_name] from [User] where [user_name]=@user_name", myConnection);/*在数据库中搜索TextBox1的值，如果返回的数据集表不为空，则已存在该用户，反之则插入新用户资料*/string user_name = TextBox1.Text;sqlSelectCommand.Parameters.AddWithValue("@user_name", user_name);SqlDataAdapter Adapter = new SqlDataAdapter();Adapter.SelectCommand = sqlSelectCommand;DataSet myDs = new DataSet();Adapter.Fill(myDs);DataTable myTable = myDs.Tables[0];if (myTable.Rows.Count!=0){    Label1.Text = "已存在用户名，请重新输入";}else{    SqlCommand sqlInsertCommand = new SqlCommand();    sqlInsertCommand.CommandText = @"insert into [User] ([user_name],[user_pwd],[user_phone],    [user_address]) values (@user_name1,@user_pwd,@user_phone,@user_address)";    sqlInsertCommand.Connection = myConnection;    /*数据绑定*/    string user_name1 = TextBox1.Text;    sqlInsertCommand.Parameters.AddWithValue("@user_name1", user_name1);    string user_pwd = TextBox2.Text;    sqlInsertCommand.Parameters.AddWithValue("@user_pwd", user_pwd);    string user_phone = TextBox4.Text;    sqlInsertCommand.Parameters.AddWithValue("@user_phone", user_phone);    string user_address = TextBox5.Text;    sqlInsertCommand.Parameters.AddWithValue("@user_address", user_address);    /*执行数据库操作语句，关闭数据库连接并跳转至指定页面*/    sqlInsertCommand.ExecuteNonQuery();    myConnection.Close();    Response.Redirect("congratulations.aspx");}

TextBox提示文字点击后自动消除：

<asp:TextBox ID="TextBox2" runat="server" BorderStyle="Solid" ForeColor="#2E81A9" Text="请输入反馈正文" OnFocus="javascript:if(this.value=='请输入反馈正文') {this.value=''}" OnBlur="javascript:if(this.value=='') {this.value='请输入反馈正文'}"></asp:TextBox>

0 0