Click here to Skip to main content
15,886,919 members
Home / Discussions / C#
   

C#

 
Questionhow to remote copy ? Pin
hdv2128-Apr-07 1:37
hdv2128-Apr-07 1:37 
AnswerRe: how to remote copy ? Pin
Sathesh Sakthivel8-Apr-07 2:04
Sathesh Sakthivel8-Apr-07 2:04 
GeneralRe: how to remote copy ? Pin
hdv2128-Apr-07 2:18
hdv2128-Apr-07 2:18 
GeneralRe: how to remote copy ? Pin
Rob Graham8-Apr-07 3:52
Rob Graham8-Apr-07 3:52 
QuestionHow to use IsampleGrabber interface in C#? Pin
Khoramdin7-Apr-07 21:43
Khoramdin7-Apr-07 21:43 
AnswerRe: How to use IsampleGrabber interface in C#? Pin
Colin Angus Mackay8-Apr-07 1:18
Colin Angus Mackay8-Apr-07 1:18 
AnswerRe: How to use IsampleGrabber interface in C#? Pin
Sathesh Sakthivel8-Apr-07 1:23
Sathesh Sakthivel8-Apr-07 1:23 
QuestionHelp Pls - Updating Access DB from DataSet - DataAdapter.Update problem Pin
esulin7-Apr-07 19:31
esulin7-Apr-07 19:31 
I'm using the following code to insert/update records to an Access database using a DataSet. (Don't worry too much about the 'EdiDatastore' class - I just use it to encapsulate some DB functionality - should be self explanatory).

Note that the DriverID is an AutoNumber field in the Access DB.

<br />
myDriverDB = new EdiDatastore();<br />
myDriverDB.open();<br />
myDriverDB.sqlCommand("SELECT DriverID, DriverName, DriverVersion, DriverDLL, DriverEnabled FROM Drivers");<br />
myDriverDB.makeDataAdapter();<br />
<br />
//Insert Command<br />
myDriverDB.dataAdapter.InsertCommand = myDriverDB.conn.CreateCommand();<br />
myDriverDB.dataAdapter.InsertCommand.CommandText = "INSERT INTO Drivers " +<br />
    "(DriverName, DriverVersion, DriverDLL, DriverEnabled) " +<br />
    "VALUES (?,?,?,?)";<br />
myDriverDB.dataAdapter.InsertCommand.Parameters.Add("DriverName", OleDbType.VarWChar, 255, "DriverName");<br />
myDriverDB.dataAdapter.InsertCommand.Parameters.Add("DriverVersion", OleDbType.VarWChar, 100, "DriverVersion");<br />
myDriverDB.dataAdapter.InsertCommand.Parameters.Add("DriverDLL", OleDbType.VarWChar, 100, "DriverDLL");<br />
myDriverDB.dataAdapter.InsertCommand.Parameters.Add("DriverEnabled", OleDbType.Boolean, 10, "DriverEnabled");<br />
<br />
//Update Command<br />
myDriverDB.dataAdapter.UpdateCommand = myDriverDB.conn.CreateCommand();<br />
myDriverDB.dataAdapter.UpdateCommand.CommandText = "UPDATE Drivers " +<br />
    "SET DriverName=?, DriverVersion=?, DriverDLL=?, DriverEnabled=? " +<br />
    "WHERE DriverID=?";<br />
myDriverDB.dataAdapter.UpdateCommand.Parameters.Add("DriverName", OleDbType.VarWChar, 255, "DriverName");<br />
myDriverDB.dataAdapter.UpdateCommand.Parameters.Add("DriverVersion", OleDbType.VarWChar, 100, "DriverVersion");<br />
myDriverDB.dataAdapter.UpdateCommand.Parameters.Add("DriverDLL", OleDbType.VarWChar, 100, "DriverDLL");<br />
myDriverDB.dataAdapter.UpdateCommand.Parameters.Add("DriverEnabled", OleDbType.Boolean, 10, "DriverEnabled");<br />
myDriverDB.dataAdapter.UpdateCommand.Parameters.Add("DriverID", OleDbType.Boolean, 10, "DriverID");<br />
<br />
DataSet myDriverDS = myDriverDB.getDataSet("MyTable");<br />
<br />
DataRow driverDR = myDriverDS.Tables[0].NewRow();<br />
driverDR["DriverName"] = "Test";<br />
driverDR["DriverVersion"] = "0.0.0";<br />
driverDR["DriverDLL"] = "test.dll";<br />
driverDR["DriverEnabled"] = true;<br />
<br />
myDriverDS.AcceptChanges();<br />
myDriverDS.Tables[0].AcceptChanges();<br />
<br />
DataRow driverDR2 = myDriverDS.Tables[0].NewRow();<br />
driverDR2["DriverName"] = "Test";<br />
driverDR2["DriverVersion"] = "0.0.0";<br />
driverDR2["DriverDLL"] = "test.dll";<br />
driverDR2["DriverEnabled"] = true;<br />
<br />
myDriverDS.Tables[0].LoadDataRow(driverDR.ItemArray, true);<br />
myDriverDS.Tables[0].LoadDataRow(driverDR2.ItemArray, true);<br />
myDriverDS.Tables[0].AcceptChanges();<br />
myDriverDS.AcceptChanges();<br />
<br />
myDriverDB.dataAdapter.Update(myDriverDS, "MyTable");<br />
Application.DoEvents();<br />
<br />
myDriverDB.close();<br />


The problem is that the DataTable.LoadDataRow method doesn't actually execute any database commands (I have tested this by creating intentional syntax errors in the SQL insert and update commands - no exceptions are thrown). The DataSet itself shows the inserted values correctly.

I have tried removing the DriverID column from the DataSet, but that doesn't make a difference. Can anyone tell me why this code would not update the new rows in the dataset to the database?
AnswerRe: Help Pls - Updating Access DB from DataSet - DataAdapter.Update problem Pin
Muammar©7-Apr-07 20:55
Muammar©7-Apr-07 20:55 
GeneralRe: Help Pls - Updating Access DB from DataSet - DataAdapter.Update problem Pin
esulin7-Apr-07 22:06
esulin7-Apr-07 22:06 
AnswerRe: Help Pls - Updating Access DB from DataSet - DataAdapter.Update problem Pin
phantanagu8-Apr-07 22:25
phantanagu8-Apr-07 22:25 
QuestionGlobal variable in C# Pin
Hamed Musavi7-Apr-07 19:26
Hamed Musavi7-Apr-07 19:26 
AnswerRe: Global variable in C# Pin
Sathesh Sakthivel7-Apr-07 20:44
Sathesh Sakthivel7-Apr-07 20:44 
GeneralRe: Global variable in C# [modified] Pin
Hamed Musavi7-Apr-07 22:09
Hamed Musavi7-Apr-07 22:09 
AnswerRe: Global variable in C# Pin
Muammar©7-Apr-07 21:00
Muammar©7-Apr-07 21:00 
GeneralRe: Global variable in C# Pin
Hamed Musavi7-Apr-07 22:21
Hamed Musavi7-Apr-07 22:21 
GeneralRe: Global variable in C# Pin
Guffa8-Apr-07 7:55
Guffa8-Apr-07 7:55 
AnswerRe: Global variable in C# Pin
Mike_V7-Apr-07 23:00
Mike_V7-Apr-07 23:00 
GeneralRe: Global variable in C# Pin
Hamed Musavi8-Apr-07 5:51
Hamed Musavi8-Apr-07 5:51 
GeneralRe: Global variable in C# Pin
Not Active8-Apr-07 8:49
mentorNot Active8-Apr-07 8:49 
GeneralRe: Global variable in C# Pin
Mike_V8-Apr-07 9:05
Mike_V8-Apr-07 9:05 
AnswerRe: Global variable in C# Pin
Not Active8-Apr-07 8:55
mentorNot Active8-Apr-07 8:55 
QuestionSslStream and X509Chain Pin
atanamir7-Apr-07 14:26
atanamir7-Apr-07 14:26 
Questionvirtual makeover Pin
samreengr87-Apr-07 10:43
samreengr87-Apr-07 10:43 
QuestionNavigation Control Pin
indyfromoz7-Apr-07 10:25
indyfromoz7-Apr-07 10:25 

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.