获取系统的年月日在通过存储过程保存到数据库中和怎么命名空间的.代码如下:
protected void BTNtsubmit_Click(object sender, EventArgs e)
{
SqlConnection Conn = obj.GetConnection();
Conn.Open();
SqlCommand tousucmd = new SqlCommand("tousuinsert", Conn);
tousucmd.CommandType = CommandType.StoredProcedure;
SqlParameter[] prams={
new SqlParameter("@Tname",SqlDbType.Char,10),
new SqlParameter("@Tsex",SqlDbType.Char,10),
new SqlParameter("@Tattitude",SqlDbType.Char,10),
new SqlParameter("@Tlevel",SqlDbType.Char,10),
new SqlParameter("@Tacusetime",SqlDbType.DateTime,8),
new SqlParameter("@Tnowtime",SqlDbType.DateTime,8),
new SqlParameter("@Tcause",SqlDbType.NVarChar,100),
new SqlParameter("@Tdeal",SqlDbType.NVarChar,100),
};
prams[0].Value =TBXTGname.Text.Trim();
prams[1].Value = RBLTGsex.SelectedValue;
prams[2].Value = DDLTEattitude.Text;
prams[3].Value = DDLTElevel.Text;
prams[4].Value = TXBCtime.Text.Trim();
prams[5].Value = System.DataTime.Now.ToShortString(); ;//获取系统年月日
prams[6].Value = TBXEcause.Text.Trim();
prams[7].Value = TBXEdeal.Text.Trim();
}
}
protected void BTNtsubmit_Click(object sender, EventArgs e)
{
SqlConnection Conn = obj.GetConnection();
Conn.Open();
SqlCommand tousucmd = new SqlCommand("tousuinsert", Conn);
tousucmd.CommandType = CommandType.StoredProcedure;
SqlParameter[] prams={
new SqlParameter("@Tname",SqlDbType.Char,10),
new SqlParameter("@Tsex",SqlDbType.Char,10),
new SqlParameter("@Tattitude",SqlDbType.Char,10),
new SqlParameter("@Tlevel",SqlDbType.Char,10),
new SqlParameter("@Tacusetime",SqlDbType.DateTime,8),
new SqlParameter("@Tnowtime",SqlDbType.DateTime,8),
new SqlParameter("@Tcause",SqlDbType.NVarChar,100),
new SqlParameter("@Tdeal",SqlDbType.NVarChar,100),
};
prams[0].Value =TBXTGname.Text.Trim();
prams[1].Value = RBLTGsex.SelectedValue;
prams[2].Value = DDLTEattitude.Text;
prams[3].Value = DDLTElevel.Text;
prams[4].Value = TXBCtime.Text.Trim();
prams[5].Value = System.DataTime.Now.ToShortString(); ;//获取系统年月日
prams[6].Value = TBXEcause.Text.Trim();
prams[7].Value = TBXEdeal.Text.Trim();
}
}
解决方案 »
- 如何调出任务管理器
- 新手求教。。
- C#操作excel,复制不同文件的sheet
- (急,在线等)请问网页中如何直接打开excel?解决马上结贴
- sqlserver 存储过程中字段是变量报错,如表名.@selectthismonth 报错
- 颜色怎不出来?
- Enterprise Library Configuration 2.0哪里有下呀?
- 求救,有关SharpDevelop的问题
- 请问C#如何调用VB做的DLL?
- 高分求购Grid注册码.
- 100分~~!!涉及画图的问题(有代码),哪位前辈指点下!谢谢了
- Console.WriteLine(“The double is {0,10:E} and the int contains {1}”,d,i);
改成
DataTime.Now.ToShortString(); ;//获取系统年月日
改成
prams[5].Value = System.DataTime.Now.ToString("yyyy/MM/dd"); ;//获取系统年月日
DateTime date = DateTime.Now;
int year = date.Year;
int month = date.Month;
int day = date.Day;//IDE看一下
应该改成prams[5].Value = System.DataTime.Now;//获取系统年月日