页面生命周期，数据库连接是否进入Page_Load
||
目前，我有以下代码：
void Page_Load(object sender, System.EventArgs e)
{
string connectionString = \"server=abc;database=abc;uid=abc;pwd=1234\";
SqlConnection mySqlConnection = new SqlConnection(connectionString);
string procedureString = \"Callin_Insert\";
SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
mySqlCommand.CommandText = procedureString;
mySqlCommand.CommandType = CommandType.StoredProcedure;
mySqlCommand.Parameters.Add(\"@LVDate\", SqlDbType.DateTime).Value = DateTime.Now;
mySqlCommand.Parameters.Add(\"@LVTime\", SqlDbType.DateTime).Value = DateTime.Now;
mySqlCommand.Parameters.Add(\"@CuID\", SqlDbType.Int).Value = CustID;
mySqlCommand.Parameters.Add(\"@Type\", SqlDbType.Int).Value = Keypress;
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
mySqlDataAdapter.SelectCommand = mySqlCommand;
mySqlConnection.Close();
}
没有找到相关结果
已邀请:
2 个回复
混侩闯空坷
string connectionString = \"server=abc;database=abc;uid=abc;pwd=1234\"; using (SqlConnection mySqlConnection = new SqlConnection(connectionString)) { string procedureString = \"Callin_Insert\"; SqlCommand mySqlCommand = new SqlCommand(procedureString, mySqlConnection); mySqlCommand.CommandType = CommandType.StoredProcedure; mySqlCommand.Parameters.Add(\"@LVDate\", SqlDbType.DateTime).Value = DateTime.Now; mySqlCommand.Parameters.Add(\"@LVTime\", SqlDbType.DateTime).Value = DateTime.Now; mySqlCommand.Parameters.Add(\"@CuID\", SqlDbType.Int).Value = CustID; mySqlCommand.Parameters.Add(\"@Type\", SqlDbType.Int).Value = Keypress; mySqlConnection.Open(); mySqlCommand.ExecuteNonQuery(); //i have no idea what does this mean, data adapter is for filling Datasets and DataTables SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(); mySqlDataAdapter.SelectCommand = mySqlCommand; }岭取