62,046
社区成员
发帖
与我相关
我的任务
分享
protected void Button1_Click(object sender, EventArgs e)
{
string name_id = TextBox1.Text;
string machine_id = TextBox2.Text;
string price = TextBox3.Text;//获取修改信息
int price_int = int.Parse(price);//转换单价的数据类型
string time= DateTime.Now.ToString();//获取当前时间
DateTime dt = Convert.ToDateTime(time);//转换时间的数据类型
//string time=DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string str = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection conn = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("insert into 上机记录表(学号,设备号,上机时间,单价/小时) values('"+name_id+ "','" + machine_id + "','" + dt + "'," + price_int + ")", conn);
cmd.Parameters.Add("@name_id", SqlDbType.Char, 10);/*'"+name_id+ "','" + machine_id + "','" + time + "'," + price_int + "*/
cmd.Parameters["@name_id"].Value = name_id;
cmd.Parameters.Add("@machine_id", SqlDbType.Char, 5);
cmd.Parameters["@machine_id"].Value = machine_id;
cmd.Parameters.Add("@dt", SqlDbType.DateTime);
cmd.Parameters["@dt"].Value = dt;
cmd.Parameters.Add("@price_int", SqlDbType.Int);
cmd.Parameters["@price_int"].Value = price_int;
//执行sqlcommand对象cmd
if ((name_id == "") || (machine_id == "")||(price == ""))
{
Response.Write(@"<script>alert('信息不能为空');</script>");
}
try
{
conn.Open();
int flag = cmd.ExecuteNonQuery();
if (flag == 1)
{
Response.Write(@"<script>alert('登记成功!');</script>");
}
}
catch
{
Response.Write(@"<script>alert('登记失败,请重新核对信息');</script>");
}
finally
{
conn.Close();
}
}