C# Programming
08-29-2009, 01:21 PM
Dear All,
I have very simple select statement as
select * from tblA
tblA contains following columns
Id int PK Identity(1,1)
Name varchar(50)
when i create insertstatement from SqlCommandBuilder as
SqlDataAdapter da=new SqlDataAdapter("select * from tblA",connection)
SqlCommandBuilder b=new SqlCommandBuilder(da)
string query=b.GetInsertCommand().CommandText;
it generats the statement insert into tblA ([Name]) values (@p1)
how can i add identity column into the select statement of CommandBuilder or how can i create the statement which it should contain identity column too?
Note: I am only talking of make insert statement from SqlCommandBuilder
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
I have very simple select statement as
select * from tblA
tblA contains following columns
Id int PK Identity(1,1)
Name varchar(50)
when i create insertstatement from SqlCommandBuilder as
SqlDataAdapter da=new SqlDataAdapter("select * from tblA",connection)
SqlCommandBuilder b=new SqlCommandBuilder(da)
string query=b.GetInsertCommand().CommandText;
it generats the statement insert into tblA ([Name]) values (@p1)
how can i add identity column into the select statement of CommandBuilder or how can i create the statement which it should contain identity column too?
Note: I am only talking of make insert statement from SqlCommandBuilder
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan