C#添加数据到数据库，代码应该如何添加呢?

private string GetInsertData()
{
string tx = string.Empty;
tx = "insert into books(ISBN,书本名,出版社,出版日期,作者,价格,评论,页数,类别) values(";

if (tbxISBN.Text != "")
tx += "'" + tbxISBN.Text + "'" + ",";
else
tx += "''" + ",";

if (tbxBookName.Text != "")
tx += "'" + tbxBookName.Text + "'" + ",";
else
tx += "''" + ",";

if (tbxPublish.Text != "")
tx += "'" + tbxPublish.Text + "'" + ",";
else
tx += "''" + ",";

if (tbxPDate.Text != "")
tx += "#" + tbxPDate.Text + "#" + ",";
else
tx += "" + ",";

if (tbxAuthor.Text != "")
tx += "'" + tbxAuthor.Text + "'" + ",";
else
tx += "''" + ",";

if (tbxPrice.Text != "")
tx += tbxPrice.Text + ",";
else
tx += "0" + ",";

if (tbxComments.Text != "")
tx += "'" + tbxComments.Text + "'" + ",";
else
tx += "''" + ",";

if (tbxPages.Text != "")
tx += tbxPages.Text + ",";
else
tx += "0" + ",";

tx += cbxCategory.SelectedValue.ToString() + ")";

return tx;
}
其中：

if (tbxPDate.Text != "")
tx += "#" + tbxPDate.Text + "#" + ",";

else
tx += "" + ",";

有问题，应该怎样修改？

tbxPDate.Text 应为Date是datetime类型，所以应写成tbxPDate.Text .ToString()

需要注意数据类型哈 童鞋...

null试下。

数据库中出版日期是什么类型?

tx += "#" + tbxPDate.Text + "#" + ","; 要是数据库为DateTime类型肯定加不进去的.

把数据库设置为varchar(20)

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息