📄 sqlstoredprocedure.aspx
字号:
<%@ Page Language="C#"%>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<script runat=server>
void Page_Load(Object sender , EventArgs e)
{
SqlConnection conNorthwind;
string strInsert;
SqlCommand cmdInsert;
conNorthwind = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;database=Northwind" );
cmdInsert = new SqlCommand( "InsertProducts", conNorthwind );
cmdInsert.CommandType = CommandType.StoredProcedure;
cmdInsert.Parameters.Add( "@ProductName", "Milk" );
cmdInsert.Parameters.Add( "@UnitPrice", 12.45 );
conNorthwind.Open();
cmdInsert.ExecuteNonQuery();
conNorthwind.Close();
Response.Write("New Product Added!");
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -