C# execute transact sql

static public int AddProductCategory(string newName, string connString)
{
    Int32 newProdID = 0;
    string sql =
        "INSERT INTO Production.ProductCategory (Name) VALUES (@Name); "
        + "SELECT CAST(scope_identity() AS int)";
    using (SqlConnection conn = new SqlConnection(connString))
    {
        SqlCommand cmd = new SqlCommand(sql, conn);
        cmd.Parameters.Add("@Name", SqlDbType.VarChar);
        cmd.Parameters["@Name"].Value = newName;
        try
        {
            conn.Open();
            newProdID = (Int32)cmd.ExecuteScalar();
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
    }
    return (int)newProdID;
}

Source: stackoverflow.com

Similar codes

1 vote254 views1 answer
Stored procedure return value
SQL
0 vote302 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
52 votes502 views6 answers
Rename column sql
SQL
19 votes298 views6 answers
Create table sqlite
SQL
0 vote260 views1 answer
Mysql workbench search all tables
SQL
0 vote296 views1 answer
Ms sql filter all sympbol
SQL
0 vote298 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
0 vote299 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote291 views1 answer
Import sql in postgresql
SQL
1 vote299 views2 answers
Select into temp table
SQL