令人头痛的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[0].Rows[0]; this.dgvGoodInput.Rows.Add(r[0], r[1], r[2], r[3], r[4], r[5], r[6], r[7]); //this.TotalDisplay(r[1].ToString(), r[2].ToString()); }

寂寞

狂哭!

垃圾的access!

寂寞

狂求救![em06]

iptton

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

gdut_stu

提问的智慧

寂寞

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

海上飞洪

这语句好长啊

hjack

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

镜花水月

学紧openGL

诸事丁

opengl边类公司会请？