Hindi na ako nakaalis dito haha na stuck nako dito

[klin]

May Error Huhuhu

 

[klin]

di ako makapag patuloy sa pag ccrud Hahaha patulong naman po baka may marunong jan
subukan ko mga suggestions nyo

 

[angel lore]

gusto ko sana tulongan ka paps, kaso nga lang wala akong alam jan

 

[Arjienx]

SQL query mo?

 

[dee-u]

Ano yung buong sql mo? Try mo i-enclose sa square bracket yung "table" kasi keyword yan eh.

INSERT INTO [table]

 

[angel lore]

ok paps salamat

 

[ced17]

sa sql query may prob

 

[klin]

Pano po ba?

dito po kasi ako gumawa eh

 

[klin]

eto po ba yung Query

 

[dee-u]

Yung kabuuan ng "INSERT INTO" mo ang ipakita mo, natakpan kasi. Try mo rin yung suggestion ko, i-edit mo lang.

 

[klin]

Yung kabuuan ng "INSERT INTO" mo ang ipakita mo, natakpan kasi. Try mo rin yung suggestion ko, i-edit mo lang.

Eto po yung kabuuan

 

[ced17]

dun sa error pakita mo yung code dun

 

[klin]

dun sa error pakita mo yung code dun

System.Data.SqlClient.SqlException
HResult=0x80131904
Message=Incorrect syntax near the keyword 'Table'.
Source=.Net SqlClient Data Provider
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at CRUD.Form1.Insert_Btn_Click(Object sender, EventArgs e) in C:\Users\Administrator\Documents\Visual Studio 2017\Projects\BASIC CRUD\CRUD\Form1.cs:line 30
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at CRUD.Program.Main() in C:\Users\Administrator\Documents\Visual Studio 2017\Projects\BASIC CRUD\CRUD\Program.cs:line 19



Eto po ba boss?

 

[klin]

Ano yung buong sql mo? Try mo i-enclose sa square bracket yung "table" kasi keyword yan eh.

INSERT INTO [table]

Ayownn gumana po ito boss

 

[klin]

 

[klin]

Ok na po na solved na po yung 3 days kong Problem
Salamat po sainyo sa mga Tumulong