默认值无法保存 [英] Default Value is Unable to Save
问题描述
Asalam Alaikum! (问候)
Asalam Alaikum! (Greetings)
我正在尝试ADO .Net将数据从数据库保存和检索到适配器并在网格上显示,并允许网格到所有DML功能。在Database中,我提供了DMLDate Column,这个列的默认值是GETDATE()函数。但是从Windows Form的Grid中,当
i保存数据时,它会在其中放置空字段。
I am trying ADO .Net to save and retrieve data from database to an adapter and show it on grid, and allow grid to all DML Functions. In Database, I provide DMLDate Column, this column's default value is GETDATE() function. But from Windows Form's Grid, when i save data it put null field in it.
任何人都可以帮我解决这个问题,当我插入新数据或更新数据时,日期每次都会更改,但只会更改DMLDate,而且不会全部更改。
Can anyone help me to resolve that, when i insert new data, or update data, date changes every time, but only that DMLDate, which are being changed not all.
谢谢,
问候,
Muhammad Naveed Haroon
Regards,
Muhammad Naveed Haroon
推荐答案
这里我有一个实现简单数据库的演示阅读和更新。代码如下所示:
Here I have a demo that implements simple database reading and updating. The code is shown as follows:
private static string strConn = @"Connection String";
SqlDataAdapter adapter = null;
DataSet dSet = null;
private void Form1_Load(object sender, EventArgs e)
{
adapter = new SqlDataAdapter("select * from DMLdate", strConn);
dSet = new DataSet();
adapter.Fill(dSet);
dataGridView1.DataSource = dSet.Tables[0];
}
private void Update_Click(object sender, EventArgs e)
{
SqlCommandBuilder scb = new SqlCommandBuilder(adapter);
try
{
adapter.Update(dSet);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
这是设置值的SQL语句:
Here is the SQL statement that set value:
INSERT INTO DMLdate VALUES ('1', GETDATE())
INSERT INTO DMLdate VALUES ('2', GETDATE())
INSERT INTO DMLdate VALUES ('3', GETDATE())
INSERT INTO DMLdate VALUES ('4', GETDATE())
如果有任何误解,请告诉我。
If there is any misunderstanding, please let me know.
问候,
Kyle
这篇关于默认值无法保存的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!