数据库里有一日期型字段,通过类让数据库添加记录,前台没有给该字段赋值,在类里却自动赋为0001-1-1 0:00:00,却又存不进去,提示:SqlDateTime 溢出。必须介于 1/1/1753 12:00:00 AM 和 12/31/9999 11:59:59 PM 之间。
怎么才能给日期型字段赋null呢?
我类里的代码:
string strSql = "";
DataSet ds = new DataSet();
DataRow dr;
SqlCommandBuilder cb; strSql = "SELECT * FROM T_StuInfo WHERE"
+ " ID = " + m.ID; Cls_DataBase.cn.Open();
SqlDataAdapter myAdapter = new SqlDataAdapter(strSql, Cls_DataBase.cn);
cb = new SqlCommandBuilder(myAdapter);
myAdapter.Fill(ds, "T_StuInfo"); //根据查询结果进行判断进行的操作是添加还是更新
if (ds.Tables[0].Rows.Count == 0)
{
//添加新行
dr = ds.Tables[0].NewRow();
dr = SetMyProperty(dr);
ds.Tables[0].Rows.Add(dr);
}
else
{
//更新
dr = ds.Tables[0].Rows[0];
dr = SetMyProperty(dr);
} myAdapter.Update(ds, "T_StuInfo"); private DataRow SetMyProperty(DataRow dr)
{
dr["Name"] = m.Name;
dr["Password"] = m.Password;
dr["Birthday"] = m.Birthday;
dr["IDCard"] = m.IDCard;
dr["Tel"] = m.Tel;
dr["OverEduTime"] = m.OverEduTime;
dr["College"] = m.College;
dr["TestTime"] = m.TestTime;
dr["Address"] = m.Address;
dr["Postcode"] = m.Postcode;
dr["IDC_Sex"] = m.eSex;
dr["IDC_Nation"] = m.IDC_Nation;
dr["IDC_Edu"] = m.IDC_Nation;
dr["IDC_Speciallity"] = m.IDC_Speciallity;
dr["IsTrain"] = m.IsTrain;
dr["IDC_State"] = m.eState;
dr["IsPay"] = m.IsPay;
dr["PayTime"] = m.PayTime; //错误就在这一句
return dr;
}
怎么才能给日期型字段赋null呢?
我类里的代码:
string strSql = "";
DataSet ds = new DataSet();
DataRow dr;
SqlCommandBuilder cb; strSql = "SELECT * FROM T_StuInfo WHERE"
+ " ID = " + m.ID; Cls_DataBase.cn.Open();
SqlDataAdapter myAdapter = new SqlDataAdapter(strSql, Cls_DataBase.cn);
cb = new SqlCommandBuilder(myAdapter);
myAdapter.Fill(ds, "T_StuInfo"); //根据查询结果进行判断进行的操作是添加还是更新
if (ds.Tables[0].Rows.Count == 0)
{
//添加新行
dr = ds.Tables[0].NewRow();
dr = SetMyProperty(dr);
ds.Tables[0].Rows.Add(dr);
}
else
{
//更新
dr = ds.Tables[0].Rows[0];
dr = SetMyProperty(dr);
} myAdapter.Update(ds, "T_StuInfo"); private DataRow SetMyProperty(DataRow dr)
{
dr["Name"] = m.Name;
dr["Password"] = m.Password;
dr["Birthday"] = m.Birthday;
dr["IDCard"] = m.IDCard;
dr["Tel"] = m.Tel;
dr["OverEduTime"] = m.OverEduTime;
dr["College"] = m.College;
dr["TestTime"] = m.TestTime;
dr["Address"] = m.Address;
dr["Postcode"] = m.Postcode;
dr["IDC_Sex"] = m.eSex;
dr["IDC_Nation"] = m.IDC_Nation;
dr["IDC_Edu"] = m.IDC_Nation;
dr["IDC_Speciallity"] = m.IDC_Speciallity;
dr["IsTrain"] = m.IsTrain;
dr["IDC_State"] = m.eState;
dr["IsPay"] = m.IsPay;
dr["PayTime"] = m.PayTime; //错误就在这一句
return dr;
}
解决方案 »
- 求 sql 语句
- ListBox1.SelectedItem 为NULL
- 请问在打包的时候如何把注册服务也打进去啊?
- 高分讨论: DataGrid中显示图片方法和问题
- 有没有交换链接的?
- 简单的难问题,在线等
- import system.data.sql时报找不到sql命名空间的错误
- GridView关于固定表头,表身可以上下动(与网上多数情况不一样)问题
- 如何解决由于启动用户实例的进程时出错,导致无法生成 SQL Server 的用户实例。该连接将关闭。
- ef - linq 如何处理批量更新?
- 关于c#通信 传输文件 和networkstream问题 (我的毕设 请大家帮帮忙)
- 替换图片后显示不正确???
dr["PayTime"] = m.PayTime; //错误就在这一句 改成dr["PayTime"] = m.PayTime==null?"默认值":m.PayTime;
ran hou zai xie ru shu ju ku