📄 insertingdata.aspx
字号:
<%@ Page Language="C#" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="C#" runat="server">
SqlConnection myConnection;
protected void Page_Load(Object sender, EventArgs e)
{
//建立数据连接
myConnection = new SqlConnection("server=(local);database=Northwind;Trusted_Connection=yes");
if (!IsPostBack) {
BindGrid();
}
}
public void BindGrid() {
//创建SqlDataAdapter对象
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Shippers",myConnection);
//创建DataSet对象
DataSet ds = new DataSet();
//将查询结果填充到DataSet对象中
myCommand.Fill(ds, "Shippers");
MyDataGrid.DataSource=ds.Tables["Shippers"].DefaultView;
MyDataGrid.DataBind();
}
public void AddCompany_Click(Object sender, EventArgs E)
{
//检查用户的输入是否有空值
if (CompanyName.Value == "" || Phone.Value == "")
{
Message.InnerHtml = "错误: 公司名、电话号码不能为空";
Message.Style["color"] = "red";
BindGrid();
return;
}
//插入记录的SQL语句
String insertCmd = "insert into Shippers (CompanyName,Phone) values (@CompanyName, @Phone)";
SqlCommand myCommand = new SqlCommand(insertCmd, myConnection);
//给插入记录的字段赋值
myCommand.Parameters.Add(new SqlParameter("@CompanyName", SqlDbType.NVarChar, 40));
myCommand.Parameters["@CompanyName"].Value = CompanyName.Value;
myCommand.Parameters.Add(new SqlParameter("@Phone", SqlDbType.NVarChar, 24));
myCommand.Parameters["@Phone"].Value = Phone.Value;
myCommand.Connection.Open();
try
{
//执行插入的SQL语句
myCommand.ExecuteNonQuery();
Message.InnerHtml = "<b>记录添加成功</b><br>" ;
}
catch (SqlException e)
{
Message.InnerHtml = "错误:记录添加失败";
Message.Style["color"] = "red";
}
//关闭连接
myCommand.Connection.Close();
BindGrid();
}
</script>
<body>
<h3>清单</h3>
<form runat=server>
<ASP:DataGrid id="MyDataGrid" runat="server"
BorderColor="black"
HeaderStyle-BackColor="#aaaadd"
AutoGenerateColumns="true"
PagerStyle-HorizontalAlign="Right"
PagerStyle-Mode="NumericPages">
</asp:DataGrid>
<hr>
<table>
<tr><td>添加新记录:</td></tr>
<tr>
<td nowrap>公司名: </td>
<td>
<input type="text" id="CompanyName" value="Doe" runat="server">
</td>
</tr>
<tr>
<td nowrap>电话号码: </td>
<td>
<input type="text" id="Phone" value="(503) 555-9999" runat="server">
</td>
</tr>
<tr>
<td>
<input type="submit" OnServerClick="AddCompany_Click" value="添加" runat="server">
</td>
</tr>
</table>
<span id="Message" EnableViewState="false" runat="server"/>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -