DataGrid and INSERT problem

[mattgcon]

When I use a stored procedure to insert data into a table and when the
Datagrid refreshes two new columns are added. The dataSet is set up with one
table with NO columns defined. Please help me on this. I have screen shots of
the before and after.

Here is the code:

sqlCommand.Comm andType = CommandType.Sto redProcedure;
sqlCommand.Comm andText = SQLInsertSP;
sqlCommand.Para meters.Add("@ai d",SqlDbType.In t,4);
sqlCommand.Para meters.Add("@ty pe",SqlDbType.V arChar,50);
sqlCommand.Para meters["@aid"].Value = tAID;
sqlCommand.Para meters["@type"].Value = tValue;
sqlADBAdapt.Ins ertCommand = sqlCommand;

//This is the point where the Insert Statement is working but its adding two
new columns

sqlADBAdapt.Upd ate(dataSet1);
sqlCommand.Para meters.Clear();
sqlCommand.Comm andType = CommandType.Sto redProcedure;
sqlCommand.Comm andText = SQLSelectSP;
try{
sqlADBAdapt.Sel ectCommand = sqlCommand;
sqlADBAdapt.Fil l(dataSet1.Tabl es[0]);
}
catch(SqlExcept ion ae){
MessageBox.Show (ae.Message.ToS tring());
}
dataGrid1.DataS ource = dataTable1;
dataGrid1.ReadO nly=true;

[mattgcon]

I wrote this awhile ago, but no one answered it, Can anyone please help me on
this

"mattgcon" wrote:

When I use a stored procedure to insert data into a table and when the
Datagrid refreshes two new columns are added. The dataSet is set up with one
table with NO columns defined. Please help me on this. I have screen shots of
the before and after.

Here is the code:

sqlCommand.Comm andType = CommandType.Sto redProcedure;
sqlCommand.Comm andText = SQLInsertSP;
sqlCommand.Para meters.Add("@ai d",SqlDbType.In t,4);
sqlCommand.Para meters.Add("@ty pe",SqlDbType.V arChar,50);
sqlCommand.Para meters["@aid"].Value = tAID;
sqlCommand.Para meters["@type"].Value = tValue;
sqlADBAdapt.Ins ertCommand = sqlCommand;

//This is the point where the Insert Statement is working but its adding two
new columns

sqlADBAdapt.Upd ate(dataSet1);
sqlCommand.Para meters.Clear();
sqlCommand.Comm andType = CommandType.Sto redProcedure;
sqlCommand.Comm andText = SQLSelectSP;
try{
sqlADBAdapt.Sel ectCommand = sqlCommand;
sqlADBAdapt.Fil l(dataSet1.Tabl es[0]);
}
catch(SqlExcept ion ae){
MessageBox.Show (ae.Message.ToS tring());
}
dataGrid1.DataS ource = dataTable1;
dataGrid1.ReadO nly=true;

[Guadala Harry]

What is the value of SQLSelectSP?


"mattgcon" <ma******@discu ssions.microsof t.com> wrote in message
news:B2******** *************** ***********@mic rosoft.com...

I wrote this awhile ago, but no one answered it, Can anyone please help me on this

"mattgcon" wrote:

When I use a stored procedure to insert data into a table and when the
Datagrid refreshes two new columns are added. The dataSet is set up with one table with NO columns defined. Please help me on this. I have screen shots of the before and after.

Here is the code:

sqlCommand.Comm andType = CommandType.Sto redProcedure;
sqlCommand.Comm andText = SQLInsertSP;
sqlCommand.Para meters.Add("@ai d",SqlDbType.In t,4);
sqlCommand.Para meters.Add("@ty pe",SqlDbType.V arChar,50);
sqlCommand.Para meters["@aid"].Value = tAID;
sqlCommand.Para meters["@type"].Value = tValue;
sqlADBAdapt.Ins ertCommand = sqlCommand;

//This is the point where the Insert Statement is working but its adding two new columns

sqlADBAdapt.Upd ate(dataSet1);
sqlCommand.Para meters.Clear();
sqlCommand.Comm andType = CommandType.Sto redProcedure;
sqlCommand.Comm andText = SQLSelectSP;
try{
sqlADBAdapt.Sel ectCommand = sqlCommand;
sqlADBAdapt.Fil l(dataSet1.Tabl es[0]);
}
catch(SqlExcept ion ae){
MessageBox.Show (ae.Message.ToS tring());
}
dataGrid1.DataS ource = dataTable1;
dataGrid1.ReadO nly=true;

[Jon Skeet [C# MVP]]

mattgcon <ma******@discu ssions.microsof t.com> wrote:

I wrote this awhile ago, but no one answered it, Can anyone please help me on
this

I suggest you ask on the .adonet newsgroup, with a more descriptive
subject line.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too