TableAdapter insert 无效
使用设计器编程数据集,再查询生成器,再执行查询,输入数据后,就可以录入到数据文件中。
但是在编程中却不能实现。比如
s_day = Convert.ToInt32(Convert.ToDateTime(dateTimePicker1.Value.ToString()).Day.ToString());
s_month = Convert.ToInt32(Convert.ToDateTime(dateTimePicker1.Value.ToString()).Month.ToString());
s_year = Convert.ToInt32(Convert.ToDateTime(dateTimePicker1.Value.ToString()).Year.ToString());
s_money = Convert.ToSingle(textBox2.Text);
s_name = textBox1.Text;
s_infromation = textBox4.Text;
s_user = textBox3.Text;
Database1DataSetTableAdapters.shang_money_moneyTableAdapter insert_ad = new WindowsApplication1.Database1DataSetTableAdapters.shang_money_moneyTableAdapter();
try
{
insert_ad.Insert(s_money, s_year, s_month, s_day, s_user, s_name, s_infromation);
}
catch (Exception ee)
{
textBox4.Text = ee.ToString();
}
可以运行,但是根本就无法插入数据!! 但是 单独的执行这个语句的时候是完全可以的
请求打人帮忙解决了