string strConn=ConfigurationSettings.AppSettings["strcon"];
SqlConnection cn=new SqlConnection(strConn);
cn.Open();
String strSQL="insert into dat_jch(criqi,jcksdate,jcjsdate,jcnr,jcrenci,jczhidu,jcren,jclrdate) values(@jcriqi,@jcksdate,@jcjsdate,@jcnr,@jcrenci,@jczhidu,@jcren,@jclrdate );select @@IDENTITY as 'Identity'";
SqlCommand cm=new SqlCommand(strSQL,cn);
cm.Parameters.Add(new SqlParameter("@jcriqi",SqlDbType.SmallDateTime ));
cm.Parameters.Add(new SqlParameter("@jcksdate",SqlDbType.NVarChar,20 ));
cm.Parameters.Add(new SqlParameter("@jcjsdate",SqlDbType.NVarChar ,20));
cm.Parameters.Add(new SqlParameter("@jcnr",SqlDbType.Char ,500));
cm.Parameters.Add(new SqlParameter("@jcrenci",SqlDbType.NVarChar ,10 ));
cm.Parameters.Add(new SqlParameter("@jczhidu",SqlDbType.NVarChar,50 ));
cm.Parameters.Add(new SqlParameter("@jcren",SqlDbType.NVarChar,10 ));
cm.Parameters.Add(new SqlParameter("@jclrdate",SqlDbType.SmallDateTime ));
cm.Parameters["@jcriqi"].Value=Convert.ToDateTime(shijian.Text);
cm.Parameters["@jcksdate"].Value=wang.Text.Trim();
cm.Parameters["@jcjsdate"].Value=fan.Text.Trim();
cm.Parameters["@jcnr"].Value=neirong.Text.Trim();
cm.Parameters["@jcrenci"].Value=renci.Text .Trim();
cm.Parameters["@jczhidu"].Value=zhidu.Text.Trim();
cm.Parameters["@jcren"].Value=Session["gonghao"].ToString();
cm.Parameters["@jclrdate"].Value=DateTime.Now;
try
{
idd=Convert.ToInt32(cm.ExecuteScalar());
message.Text="信息单成功保存!";
}
catch(SqlException)
{
message.Text="信息单保存失败!";
}
转自:http://hi.baidu.com/marsbook/item/32dc623293bdc8f4a884281f