|
Update DataSet
|
|||
---|---|---|---|
#18+
При обновлении, выдает следующую ошибку: "Dynamic SQL Error\nSQL error code = -104\nToken unknown - line 1, char 8\n\"EVENTS\"\n" В чем ошибка??? public void UpdateSomeTable(DataSet dataSet,string table) { this.Connect(); FbDataAdapter adapter = new FbDataAdapter(); adapter.SelectCommand = new FbCommand("Select * From events",this.myConnection); DataSet dataset = new DataSet(); FbCommandBuilder builder = new FbCommandBuilder(adapter); adapter.Fill(dataset,"events"); dataset.Tables[0].Rows[1][1] = "real"; try { adapter.Update(dataset,"events"); dataset.AcceptChanges(); } catch(Exception ee) { Debug.Listeners.Add(new TextWriterTraceListener(Console.Out)); Debug.AutoFlush = true; Debug.Indent(); Debug.WriteLine(ee.ToString()); Debug.Unindent(); } finally { this.Disconnect(); } } ... |
|||
:
Нравится:
Не нравится:
|
|||
22.09.2004, 12:14 |
|
Update DataSet
|
|||
---|---|---|---|
#18+
посмотри как пример апдейта: public DataSet UpdateDataSet(DataSet ds,string CmdText, string TableName) { SqlConnection myConn = new SqlConnection(this.ConnectionString); SqlDataAdapter myDataAdapter = new SqlDataAdapter(); myDataAdapter.SelectCommand = new SqlCommand(CmdText, myConn); SqlCommandBuilder cb = new SqlCommandBuilder(myDataAdapter); try { myConn.Open(); //code to modify data in DataSet here cb.RefreshSchema(); //Without the SqlCommandBuilder this line would fail myDataAdapter.Update(ds, TableName); return ds; } catch( Exception exception ) { System.Diagnostics.Debug.WriteLine(exception.Message); return null; } finally { // Clean up the objects if( myConn != null ) myConn.Dispose(); } } ... |
|||
:
Нравится:
Не нравится:
|
|||
22.09.2004, 12:57 |
|
|
start [/forum/topic.php?fid=17&gotonew=1&tid=1354017]: |
0ms |
get settings: |
9ms |
get forum list: |
14ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
62ms |
get topic data: |
11ms |
get first new msg: |
7ms |
get forum data: |
3ms |
get page messages: |
40ms |
get tp. blocked users: |
1ms |
others: | 13ms |
total: | 168ms |
0 / 0 |