如何使用两种方法，例如在页面加载时执行nonquery和execute reader? [英] how to use two method like execute nonquery and execute reader at pageload ?

问题描述

如何在页面加载时使用执行非查询"和执行阅读器"这两种方法?

how to use two method like "execute non query" and "execute reader" at page load ?

推荐答案

请检查以下教程:

http://www.w3schools.com/aspnet/aspnet_dbconnection.asp [

Please check the following tutorial:

http://www.w3schools.com/aspnet/aspnet_dbconnection.asp[^]

//ExecuteNonQuery Example:
protected void Page_Load(object sender, EventArgs e)
{
SqlCommand sqlCom = new SqlCommand("sp_InsertJob", sqlCon);
sqlCom.CommandType = System.Data.CommandType.StoredProcedure;
sqlCom.Parameters.AddWithValue("@JobName", ddlJob.SelectedValue);
sqlCon.Open();
sqlCom.ExecuteNonQuery();
sqlCon.Close();
}

//ExecuteReader Example:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlCommand sqlCom = new SqlCommand("select strDepartmentName from tblDepartment", sqlCon);
sqlCon.Open();
SqlDataReader sqlRd = sqlCom.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
while (sqlRd.Read())
{
(CreateUserWizard.CreateUserStep.ContentTemplateContainer.FindControl("ddlDepartment") as DropDownList).Items.Add(sqlRd[0].ToString());
}
sqlRd.Close();
sqlCon.Close();
}
}

这篇关于如何使用两种方法，例如在页面加载时执行nonquery和execute reader?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！