read inserted Identity value

[Danko Greiner]

I'm trying to update every table in DataSet, but getting inserted "id_user"
gets me an exception:
column "id_user" is read only

if(_dataSet.Has Changes())
{
SqlDataAdapter _adapter;
SqlCommandBuild er _builder;
SqlConnection conn = new
SqlConnection(G lobalSettings.C onnectionString );
conn.Open();
foreach(DataTab le dt in _dataSet.Tables )
{
string selectString = "SELECT * FROM " + dt.TableName;
_adapter = new SqlDataAdapter( selectString, conn);
_builder = new SqlCommandBuild er(_adapter);
_adapter.RowUpd ated += new
SqlRowUpdatedEv entHandler(_ada pter_RowUpdated );
_adapter.Update (dt);
}
}
private void _adapter_RowUpd ated(object sender, SqlRowUpdatedEv entArgs e)
{

SqlCommand command = new SqlCommand("SEL ECT @@IDENTITY",
e.Command.Conne ction);
object o = command.Execute Scalar();
e.Row.Table.Col umns["id_osoba"].ReadOnly = false;
e.Row["id_user"] = o;
e.Row.AcceptCha nges();
} conn.Close();
Please make comments about this code, but my prime problem is WHY do i get
an exception:
"column 'id_user' is read only"???
of course it's read only, it's Identity column, but everywhere i look, thi
is recommended way to retrieve inserted Identity

Thax for help.

[Fitim Skenderi]

How is your table declared ?

If your field ("id_user") is Identity (presuming your table is in MSSQL
database) then you cannot write data to the field, the value is
automatically assigned by MSSQL.

Fitim Skenderi

"Danko Greiner" <no*********@bc c.com> wrote in message
news:dk******** **@ss405.t-com.hr...

I'm trying to update every table in DataSet, but getting inserted
"id_user" gets me an exception:
column "id_user" is read only

if(_dataSet.Has Changes())
{
SqlDataAdapter _adapter;
SqlCommandBuild er _builder;
SqlConnection conn = new
SqlConnection(G lobalSettings.C onnectionString );
conn.Open();
foreach(DataTab le dt in _dataSet.Tables )
{
string selectString = "SELECT * FROM " + dt.TableName;
_adapter = new SqlDataAdapter( selectString, conn);
_builder = new SqlCommandBuild er(_adapter);
_adapter.RowUpd ated += new
SqlRowUpdatedEv entHandler(_ada pter_RowUpdated );
_adapter.Update (dt);
}
}
private void _adapter_RowUpd ated(object sender, SqlRowUpdatedEv entArgs e)
{

SqlCommand command = new SqlCommand("SEL ECT @@IDENTITY",
e.Command.Conne ction);
object o = command.Execute Scalar();
e.Row.Table.Col umns["id_osoba"].ReadOnly = false;
e.Row["id_user"] = o;
e.Row.AcceptCha nges();
} conn.Close();
Please make comments about this code, but my prime problem is WHY do i get
an exception:
"column 'id_user' is read only"???
of course it's read only, it's Identity column, but everywhere i look, thi
is recommended way to retrieve inserted Identity

Thax for help.

[Miha Markic [MVP C#]]

Hi Danko,

I suggest you to avoid using SqlCommandBuild er and rather create sql
commands by hand.
The insert statement would look something like: INSERT INTO table (...)
VALUES (...); SELECT SCOPE_IDENTITY( ) As Id (assuming Id is your pk)

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Danko Greiner" <no*********@bc c.com> wrote in message
news:dk******** **@ss405.t-com.hr...

I'm trying to update every table in DataSet, but getting inserted
"id_user" gets me an exception:
column "id_user" is read only

if(_dataSet.Has Changes())
{
SqlDataAdapter _adapter;
SqlCommandBuild er _builder;
SqlConnection conn = new
SqlConnection(G lobalSettings.C onnectionString );
conn.Open();
foreach(DataTab le dt in _dataSet.Tables )
{
string selectString = "SELECT * FROM " + dt.TableName;
_adapter = new SqlDataAdapter( selectString, conn);
_builder = new SqlCommandBuild er(_adapter);
_adapter.RowUpd ated += new
SqlRowUpdatedEv entHandler(_ada pter_RowUpdated );
_adapter.Update (dt);
}
}
private void _adapter_RowUpd ated(object sender, SqlRowUpdatedEv entArgs e)
{

SqlCommand command = new SqlCommand("SEL ECT @@IDENTITY",
e.Command.Conne ction);
object o = command.Execute Scalar();
e.Row.Table.Col umns["id_osoba"].ReadOnly = false;
e.Row["id_user"] = o;
e.Row.AcceptCha nges();
} conn.Close();
Please make comments about this code, but my prime problem is WHY do i get
an exception:
"column 'id_user' is read only"???
of course it's read only, it's Identity column, but everywhere i look, thi
is recommended way to retrieve inserted Identity

Thax for help.