Click here to Skip to main content
16,005,149 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralCreate Splash Screen.... Pin
Niranjan Kulkarni29-May-05 21:01
Niranjan Kulkarni29-May-05 21:01 
GeneralRe: Create Splash Screen.... Pin
Binary011029-May-05 21:25
Binary011029-May-05 21:25 
GeneralRe: Create Splash Screen.... Pin
Niranjan Kulkarni31-May-05 18:33
Niranjan Kulkarni31-May-05 18:33 
GeneralRe: Create Splash Screen.... Pin
Binary011031-May-05 18:54
Binary011031-May-05 18:54 
GeneralRe: Create Splash Screen.... Pin
Dave Kreskowiak31-May-05 5:39
mveDave Kreskowiak31-May-05 5:39 
GeneralIcon question Pin
Binary011029-May-05 20:59
Binary011029-May-05 20:59 
GeneralRe: Icon question Pin
Rizwan Bashir29-May-05 21:31
Rizwan Bashir29-May-05 21:31 
GeneralSyntax error in INSERT INTO statement. Pin
Manik Nath29-May-05 20:09
Manik Nath29-May-05 20:09 
hi there,
Can someone help with this.

Syntax error in INSERT INTO statement.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.

Source Error:


Line 84: strsqlinsert = "INSERT INTO Transmittal(Action, Copies, Drw_Doc_Num, Kind_Attn, Project_Name, Referenced_To, Rev_Num, Title, Username)" + "VALUES('" + TextBox9.Text + "', '" + TextBox7.Text + "', '" + TextBox6.Text + "', '" + TextBox4.Text + "', '" + TextBox2.Text + "', '" + TextBox3.Text + "', '" + TextBox8.Text + "', '" + TextBox5.Text + "', '" + TextBox1.Text + "' )"
Line 85: TransDataAdapter.InsertCommand.CommandText = (strsqlinsert)
Line 86: TransDataAdapter.InsertCommand.ExecuteNonQuery()
Line 87: TransConnection.Close()
Line 88: End Sub


Source File: C:\Inetpub\wwwroot\OM\trans1.aspx.vb Line: 86

Stack Trace:


[OleDbException (0x80040e14): Syntax error in INSERT INTO statement.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) +41
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +154
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +92
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +65
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +112
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +54
OM.trans1.Button1_Click(Object sender, EventArgs e) in C:\Inetpub\wwwroot\OM\trans1.aspx.vb:86
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1263



GeneralRe: Syntax error in INSERT INTO statement. Pin
Rizwan Bashir30-May-05 2:11
Rizwan Bashir30-May-05 2:11 
GeneralRe: Syntax error in INSERT INTO statement. Pin
Manik Nath30-May-05 23:22
Manik Nath30-May-05 23:22 
GeneralRe: Syntax error in INSERT INTO statement. Pin
Dave Kreskowiak31-May-05 4:29
mveDave Kreskowiak31-May-05 4:29 
GeneralRe: Syntax error in INSERT INTO statement. Pin
Manik Nath1-Jun-05 0:36
Manik Nath1-Jun-05 0:36 
GeneralRe: Syntax error in INSERT INTO statement. Pin
Dave Kreskowiak1-Jun-05 1:59
mveDave Kreskowiak1-Jun-05 1:59 
GeneralRe: Syntax error in INSERT INTO statement. Pin
Manik Nath1-Jun-05 3:07
Manik Nath1-Jun-05 3:07 
GeneralRe: Syntax error in INSERT INTO statement. Pin
Dave Kreskowiak1-Jun-05 11:07
mveDave Kreskowiak1-Jun-05 11:07 
GeneralRe: Syntax error in INSERT INTO statement. Pin
Manik Nath2-Jun-05 1:13
Manik Nath2-Jun-05 1:13 
GeneralRe: Syntax error in INSERT INTO statement. Pin
Dave Kreskowiak2-Jun-05 2:49
mveDave Kreskowiak2-Jun-05 2:49 
GeneralRe: Syntax error in INSERT INTO statement. Pin
Manik Nath2-Jun-05 20:24
Manik Nath2-Jun-05 20:24 
GeneralRe: Syntax error in INSERT INTO statement. Pin
Dave Kreskowiak3-Jun-05 5:23
mveDave Kreskowiak3-Jun-05 5:23 
GeneralVB.NET creating a drawing area for users Pin
zoethomas200529-May-05 20:09
zoethomas200529-May-05 20:09 
GeneralRe: VB.NET creating a drawing area for users Pin
Christian Graus30-May-05 12:22
protectorChristian Graus30-May-05 12:22 
Generalbarcode generation in VB6 Pin
RupeshSunkara29-May-05 19:07
RupeshSunkara29-May-05 19:07 
GeneralRe: barcode generation in VB6 Pin
toxcct29-May-05 23:38
toxcct29-May-05 23:38 
QuestionHow to add ToolStripDropDownItem by code? Pin
rushing29-May-05 17:51
rushing29-May-05 17:51 
Generalsearching personal folder in outlook Pin
dw192829-May-05 15:03
dw192829-May-05 15:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.