Click here to Skip to main content
15,914,452 members
Home / Discussions / C#
   

C#

 
AnswerRe: How to scroll a windows form? Pin
Stefan Troschuetz23-Jan-05 0:06
Stefan Troschuetz23-Jan-05 0:06 
Generalneed beginner's treeView help Pin
SuperStruct22-Jan-05 9:03
SuperStruct22-Jan-05 9:03 
GeneralRe: need beginner's treeView help Pin
mav.northwind22-Jan-05 11:19
mav.northwind22-Jan-05 11:19 
GeneralRe: need beginner's treeView help Pin
SuperStruct26-Jan-05 5:23
SuperStruct26-Jan-05 5:23 
GeneralCreating Custom DataGrid Column Pin
Anonymous22-Jan-05 8:19
Anonymous22-Jan-05 8:19 
Generalsimple question about serviceName when developing a win service Pin
liyang yu22-Jan-05 8:10
liyang yu22-Jan-05 8:10 
GeneralRe: simple question about serviceName when developing a win service Pin
Andy Brummer23-Jan-05 19:03
sitebuilderAndy Brummer23-Jan-05 19:03 
GeneralAccess database Pin
webhay22-Jan-05 4:43
webhay22-Jan-05 4:43 
Hello all,

I need to insert rows in access database table but the code give me "Sytax error in INSERT statement" but the insert works fine in access query

this the code:

<br />
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=L:\\Work\\Elkddeh\\Project\\Can\\Can_App\\bin\\Debug\\Can_DB.mdb;Mode=Share Deny None;Extended Properties=\"\";Jet OLEDB:System database=\"\";Jet OLEDB:Registry Path=\"\";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False");<br />
			string myInsertQuery = "INSERT INTO Can_Info (Can_ID,First_Name,Last_Name,Full_Name,Position,Last_Evaluation,Pass_Num,Issu_Date,Expire_Date,SB_Num,SB_Issu_Date,SB_Type,SB_Expire_Date,DOB,Email,Address,Phone1,Phone2,Mobile1,Mobile2,Last_Ship,Current_Ship,New_Crew,EX_Crew,Company,Medical_Report,Med_Date,Comment) VALUES ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28')";<br />
			OleDbCommand myCommand = new OleDbCommand(myInsertQuery);<br />
			myCommand.Connection = myConnection;<br />
			myConnection.Open();<br />
			myCommand.ExecuteNonQuery();<br />
			myCommand.Connection.Close();<br />

please help

hay
GeneralRe: Access database Pin
Colin Angus Mackay22-Jan-05 8:04
Colin Angus Mackay22-Jan-05 8:04 
Questionhow to package the C# application and MS-SQL(7) ?? Pin
Shahrouz Sadeghi22-Jan-05 4:37
Shahrouz Sadeghi22-Jan-05 4:37 
AnswerRe: how to package the C# application and MS-SQL(7) ?? Pin
Nick Parker22-Jan-05 6:47
protectorNick Parker22-Jan-05 6:47 
GeneralRe: how to package the C# application and MS-SQL(7) ?? Pin
Shahrouz Sadeghi24-Jan-05 21:46
Shahrouz Sadeghi24-Jan-05 21:46 
GeneralParsing Word documents Pin
Member 159449022-Jan-05 4:27
Member 159449022-Jan-05 4:27 
GeneralRe: Parsing Word documents Pin
Andy Brummer23-Jan-05 18:59
sitebuilderAndy Brummer23-Jan-05 18:59 
QuestionSet VScrollBar &amp; HScrollBar colors? Pin
bbzzdd22-Jan-05 4:25
bbzzdd22-Jan-05 4:25 
AnswerRe: Set VScrollBar &amp; HScrollBar colors? Pin
Nick Parker22-Jan-05 6:42
protectorNick Parker22-Jan-05 6:42 
GeneralListView Pin
Newbie_Toy22-Jan-05 4:00
Newbie_Toy22-Jan-05 4:00 
QuestionHow to call a function in VC++ DLL from C# Pin
Anonymous22-Jan-05 1:44
Anonymous22-Jan-05 1:44 
GeneralMarshalling of SAPI4 interfaces/structs Pin
mav.northwind22-Jan-05 0:09
mav.northwind22-Jan-05 0:09 
Generalprogress bar Pin
Newbie_Toy21-Jan-05 19:35
Newbie_Toy21-Jan-05 19:35 
GeneralRe: progress bar Pin
Dave Kreskowiak23-Jan-05 6:28
mveDave Kreskowiak23-Jan-05 6:28 
GeneralCAD programming with C# Pin
Abhinandan_Shah21-Jan-05 19:19
Abhinandan_Shah21-Jan-05 19:19 
GeneralRe: CAD programming with C# Pin
Dave Kreskowiak23-Jan-05 6:27
mveDave Kreskowiak23-Jan-05 6:27 
GeneralRe: CAD programming with C# Pin
Abhinandan_Shah23-Jan-05 7:52
Abhinandan_Shah23-Jan-05 7:52 
GeneralRe: CAD programming with C# Pin
Dave Kreskowiak23-Jan-05 8:39
mveDave Kreskowiak23-Jan-05 8:39 

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.