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

0 vote343 views1 answer
Get create sql of hibernqte entity
SQL
1 vote317 views1 answer
Primary key reset in SQL database
SQL
0 vote305 views1 answer
Mysql group rows with same value
SQL
0 vote353 views1 answer
Mysql show category once count how many products
SQL
6 votes321 views1 answer
How to count number of rows in sql
SQL
3 votes336 views2 answers
Monthname sql
SQL
0 vote381 views1 answer
Traccar mysql
SQL
1 vote325 views1 answer
How to get alternate records from a table in sql
SQL
2 votes337 views2 answers
How to check data type in sql server
SQL
0 vote360 views1 answer
Mysql get hour from datetime
SQL