寂寞 发表于 2008-5-25 18:16

令人头痛的Access

现将代码拷贝如下,不知道为什么? 这个头痛的Access功能超差, 我下面的代码运行老提示Insert into 发生错误, 究竟是为何?
在线等待

using (myDataSet = OleDbHelper.ExecuteDataSet(Database.ConnectionString, CommandType.Text, String.Format(" insert into Input(Mobile_Number, Mobile_Name, Mobile_Type, Time_Input, Provider_id, Booking_Input, IsSample)" + " Values({1}, (select Mobile_Name from Prefix_Name_Type where Mobile_Number_Prefix = {0}), (select Mobile_Type from Prefix_Name_Type where Mobile_Number_Prefix = {0}), getdate(), {2}, {3}, 0)" + " insert into Stocks(Mobile_Number, Mobile_Name, Mobile_Type, Time_Input, Provider_id, Booking_Input, IsSample)" + " Values({1}, (select Mobile_Name from Prefix_Name_Type where Mobile_Number_Prefix = {0}), (select Mobile_Type from Prefix_Name_Type where Mobile_Number_Prefix = {0}), getdate(), {2}, {3}, 0)" + " select Mobile_Number, Mobile_Name, Mobile_Type, Price_Input, Color, Remark, IsSample, Time_Input" + " from Stocks where Mobile_Number = {1}",this.txtMobileNum.Text.Trim().Substring(0, 9), this.txtMobileNum.Text.Trim(), (this.cboProvider.Text.Trim() != string.Empty) ? this.cboProvider.SelectedValue : DBNull.Value,this.lblBookingInput.Text.Trim()))) { DataRow r = myDataSet.Tables.Rows; this.dgvGoodInput.Rows.Add(r, r, r, r, r, r, r, r); //this.TotalDisplay(r.ToString(), r.ToString()); }

寂寞 发表于 2008-5-25 18:17

狂哭!

垃圾的access!

寂寞 发表于 2008-5-25 18:17

狂求救!

iptton 发表于 2008-5-25 18:57

纯帮顶。。
PS：出错信息没这么精简吧？

gdut_stu 发表于 2008-5-25 20:43

提问的智慧

寂寞 发表于 2008-5-26 01:35

对啊, 就只单纯说Insert into 错误!
我鼻血都出来了~!

海上飞洪 发表于 2008-5-26 10:05

这语句好长啊

hjack 发表于 2008-5-26 12:13

建议把语句分好段,再逐个逐个排查....

镜花水月 发表于 2008-5-26 13:52

学紧openGL

诸事丁 发表于 2008-7-3 23:48

opengl边类公司会请？
页: [1]
查看完整版本: 令人头痛的Access