📄 adosp.aspx.cs
字号:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 adoSP : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ConnectionStringSettings connSettings = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"];
SqlConnection conn = new SqlConnection(connSettings.ConnectionString);
conn.Open();
//指定预存程序名称SP_EmpInfo
SqlCommand cmd = new SqlCommand("SP_EmpInfo", conn);
//声明为StoredProcedure命令类型
cmd.CommandType = CommandType.StoredProcedure;
gviewEmployees.DataSource=cmd.ExecuteReader();
gviewEmployees.DataBind();
cmd.Dispose();
conn.Close();
conn.Dispose();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -