将空白数据插入数据库 [英] Insert blank data into the database
本文介绍了将空白数据插入数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想将数据插入数据库。但如果没有记录,我点击按钮。因此不应插入任何数据。请查看我的代码
我尝试过:
SqlConnection con = new SqlConnection(Data Source = .; Initial Catalog = MYDB; Integrated Security = True);
con.Open();
SqlCommand cmd;
string query =插入员工(ID,姓名,年龄,部门,工资,DateOF周)值(@ ID,@ Name,@ Age,@ Department,@ Salary,@ DateFirth);
cmd = new SqlCommand(query,con);
if(cmd.CommandText ==)
{
cmd.Parameters.AddWithValue(@ ID,null);
cmd.Parameters.AddWithValue(@ Name,null);
cmd.Parameters.AddWithValue(@ Age,null);
cmd.Parameters.AddWithValue(@ Department,null);
cmd.Parameters.AddWithValue(@ Salary,null);
cmd.Parameters.AddWithValue(@ DateOFBirth,null);
}
else
{
cmd.Parameters.AddWithValue(@ ID,textBox1.Text);
cmd.Parameters.AddWithValue(@ Name,textBox2.Text);
cmd.Parameters.AddWithValue(@ Age,textBox3.Text);
cmd.Parameters.AddWithValue(@ Department,textBox4.Text);
cmd.Parameters.AddWithValue(@ Salary,textBox5.Text);
cmd.Parameters.AddWithValue(@ DateOFBirth,textBox6.Text);
}
cmd.ExecuteNonQuery();
con.Close();
解决方案
您是否尝试用DBNull.Value?
i want to insert data into database. but if there are no records and i click on the button.so no data should be inserted. please check my codes
What I have tried:
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=MYDB;Integrated Security=True"); con.Open(); SqlCommand cmd; string query = "insert into Employee(ID,Name, Age, Department, Salary, DateOFBirth) values(@ID,@Name, @Age, @Department, @Salary, @DateOFBirth)"; cmd = new SqlCommand(query,con); if (cmd.CommandText == "") { cmd.Parameters.AddWithValue("@ID",null); cmd.Parameters.AddWithValue("@Name",null); cmd.Parameters.AddWithValue("@Age",null); cmd.Parameters.AddWithValue("@Department",null); cmd.Parameters.AddWithValue("@Salary",null); cmd.Parameters.AddWithValue("@DateOFBirth",null); } else { cmd.Parameters.AddWithValue("@ID", textBox1.Text); cmd.Parameters.AddWithValue("@Name", textBox2.Text); cmd.Parameters.AddWithValue("@Age", textBox3.Text); cmd.Parameters.AddWithValue("@Department", textBox4.Text); cmd.Parameters.AddWithValue("@Salary", textBox5.Text); cmd.Parameters.AddWithValue("@DateOFBirth", textBox6.Text); } cmd.ExecuteNonQuery(); con.Close();
解决方案
Did you try to replace null withDBNull.Value?
这篇关于将空白数据插入数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文