SqlConnection conn= new SqlConnection(
ConfigurationManager.ConnectionStrings["dbConn"].ConnectionString
);
string insertStr =
"INSERT INTO [tabla]([texto],[fecha]) VALUES(@texto,getDate())
;SELECT  Scope_Identity();";
SqlCommand cmd=new SqlCommand(insertStr,conn);
cmd.Parameters.Add("@texto", SqlDbType.NVarChar).Value="El texto va aca";
cmd.Connection.Open();
string ret=cmd.ExecuteScalar().ToString();
cmd.Connection.Close();

SqlConnection conn= new SqlConnection( ConfigurationManager.ConnectionStrings["dbConn"].ConnectionString ); string insertStr = "INSERT INTO [tabla]([texto],[fecha]) VALUES(@texto,getDate()) ;SELECT Scope_Identity();"; SqlCommand cmd=new SqlCommand(insertStr,conn); cmd.Parameters.Add("@texto", SqlDbType.NVarChar).Value="El texto va aca"; cmd.Connection.Open(); string ret=cmd.ExecuteScalar().ToString(); cmd.Connection.Close();