Database

new SqlParameter(
        "@IsNull_DtClassification",  // Parameter name
        System.Data.SqlDbType.Int, // DbType
        0, // size
        System.Data.ParameterDirection.Input, // direction
        0, // precision
        0, // scale
        "DtClassification", // source column
        System.Data.DataRowVersion.Original, // source version  
        true, // sourceColumnNullMapping
        null, // value
        "", // xml...
        "", 
        "");

new System.Data.SqlClient.SqlParameter(
        "@IsNull_DtClassification", 
        System.Data.SqlDbType.VarChar, 
        1024, 
        System.Data.ParameterDirection.Input, 
        0, 
        0, 
        "", 
        System.Data.DataRowVersion.Original, 
        false, null, "", "", "")

--create a table with three columns
CREATE TABLE dbo.tblMyTable
	(
	Col1 int NOT NULL,
	Col2 varchar(50) NULL,
	Col3 int NULL
	)  ON [PRIMARY]


/******Add a column in 2nd position*****/
/*Now create a temporary table that is just the same,
  only insert a column between Col1 and Col2*/
CREATE TABLE dbo.Tmp_tblMyTable
	(
	Col1 int NOT NULL,
	InsertedCol int NULL,
	Col2 varchar(50) NULL,
	Col3 int NULL
	)  ON [PRIMARY]

--Take all the data from the old table, and put it in the new one
INSERT INTO dbo.Tmp_tblMyTable (Col1, Col2, Col3)
		SELECT Col1, Col2, Col3 FROM dbo.tblMyTable 

DROP TABLE dbo.tblMyTable --drop the old table

EXECUTE sp_rename 'dbo.Tmp_tblMyTable', 'tblMyTable' --rename new one

/*Add the primary key CONSTRAINT into the new table 
  (be sure to add any other indexes and triggers)*/
ALTER TABLE dbo.tblMyTable ADD CONSTRAINT
	PK_tblMyTable PRIMARY KEY CLUSTERED 
	(
	Col1
	) ON [PRIMARY]

rfebin2001 wrote:

But i want to pass the error to the DAL Factory Class and we throw as a errror

rfebin2001 wrote:

that is the SQL exception error plus our company's validation engine error

rfebin2001 wrote:

while we insert as a sql command as a string, and use executenonquery method will executed

this scenario how will get the last affected row from a table

NICE TO MEET wrote:

Without using any extra query, or SP how will get the last affected row in that table

cmd.CommandText = "INSERT MyTable(Column1, Column2) VALUES ('ABC', 'DEF'); SELECT @@IDENTITY;";
int primaryKey = (int)cmd.ExecuteScalar();