如何写入在SqlServer 2005中datetime 的空值即默认值为null delphi 写入SqlServer 2005的datetime 值时,如果为空值时,默认值一般为1900-1-1 ,如何在写入的时候修改默认值为空值 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 if ADOQuery1.FieldByName('dt').IsNull then 用isnull...example:string sqlStmt ; string conString ; SqlConnection cn =null; SqlCommand cmd =null; SqlDateTime sqldatenull ; try{ sqlStmt = "insert into Emp (FirstName,LastName,Date) Values (@FirstName,@LastName,@Date) "; conString = "server=localhost;database=Northwind;uid=sa;pwd=;"; cn = new SqlConnection(conString); cmd = new SqlCommand(sqlStmt, cn); cmd.Parameters.Add(new SqlParameter("@FirstName", SqlDbType.NVarChar, 11)); cmd.Parameters.Add(new SqlParameter("@LastName", SqlDbType.NVarChar, 40)); cmd.Parameters.Add(new SqlParameter("@Date", SqlDbType.DateTime)); sqldatenull = SqlDateTime.Null; cmd.Parameters["@FirstName"].Value = txtFirstName.Text; cmd.Parameters["@LastName"].Value = txtLastName.Text; if (txtDate.Text == "") { cmd.Parameters ["@Date"].Value =sqldatenull ; //cmd.Parameters["@Date"].Value = DBNull.Value; } else { cmd.Parameters["@Date"].Value = DateTime.Parse(txtDate.Text); } cn.Open(); cmd.ExecuteNonQuery(); Label1.Text = "Record Inserted Succesfully";}catch (Exception ex){ Label1.Text = ex.Message;}finally{ cn.Close();} 实体类型设为Nullable(Of DateTime) 组织一个SQL语句,用Tquery执行一下就行了,如:INSERT INTO Table1 (AA) VALUES (NULL) 怎么用DLL完成一个客户端的功能 delphi7(ado) + oracle9i,oracle9i客户端程序如何分发??? 关于取数据的一个问题(不好意思,真的是没分给啦,帮个忙啦) 请教关于SQL的连接问题??? 有没有这样的控件? Delphi2011出来了 关于读取ini文件中的相关内容 没想到会有这种情况出现,打印出错了. 我要送分哈哈哈哈哈 index out of date"错误,怎么办 寻openssl中的RSA_sign函数 如何把我写的东西加入到别的程序里啊
string conString ;
SqlConnection cn =null;
SqlCommand cmd =null;
SqlDateTime sqldatenull ;
try
{
sqlStmt = "insert into Emp (FirstName,LastName,Date) Values (@FirstName,@LastName,@Date) ";
conString = "server=localhost;database=Northwind;uid=sa;pwd=;";
cn = new SqlConnection(conString);
cmd = new SqlCommand(sqlStmt, cn); cmd.Parameters.Add(new SqlParameter("@FirstName", SqlDbType.NVarChar, 11));
cmd.Parameters.Add(new SqlParameter("@LastName", SqlDbType.NVarChar, 40));
cmd.Parameters.Add(new SqlParameter("@Date", SqlDbType.DateTime)); sqldatenull = SqlDateTime.Null; cmd.Parameters["@FirstName"].Value = txtFirstName.Text;
cmd.Parameters["@LastName"].Value = txtLastName.Text;
if (txtDate.Text == "")
{
cmd.Parameters ["@Date"].Value =sqldatenull ;
//cmd.Parameters["@Date"].Value = DBNull.Value;
}
else
{
cmd.Parameters["@Date"].Value = DateTime.Parse(txtDate.Text);
}
cn.Open();
cmd.ExecuteNonQuery();
Label1.Text = "Record Inserted Succesfully";
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
finally
{
cn.Close();
}