SQlHelper数据库连接

SQlHelper数据库连接:

try{SQLHelper sqlhelper = new SQLHelper();//SqlDataSource sql = new SqlDataSource();//sql.DataSourceMode = SqlDataSourceMode.DataSet;DataSet ResultSet = new DataSet();ResultSet.Merge(sqlhelper.RunQuery_getStaffName("SELECT [StaffNo], [ChineseName] FROM [VStaffNameSection] where staffno='" + txtStaffNo.Text + "'"));if (ResultSet.Tables[0].Rows.Count == 0){Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "");e.Cancel = true;return;}}catch (Exception ex){throw ex;}

SQLHelper.cs

public class SQLHelper
{public DataSet RunQuery_getStaffName(string QueryString){System.Data.SqlClient.SqlConnection DBConnection = null;DBConnection = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["webConnectionString_Dept"].ToString());DBConnection.Open();SqlDataAdapter DBAdapter = default(SqlDataAdapter);DataSet ResultsDataSet = new DataSet();try{DBAdapter = new SqlDataAdapter(QueryString, DBConnection);DBAdapter.Fill(ResultsDataSet);DBConnection.Close();}catch (Exception ex){if (DBConnection.State == ConnectionState.Open){DBConnection.Close();}}return ResultsDataSet;}
}

Web.config

"webConnectionString_Dept" connectionString="Data Source=XXX;Initial Catalog=XXX;Persist Security Info=True;User ID=XXX;Password=XXX" providerName="System.Data.SqlClient" />

转载于:https://www.cnblogs.com/iDennis/p/5553544.html

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！