DataSet Ds = new DataSet();
SqlDataAdapter Da = new SqlDataAdapter();
SqlConnection SqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["name_of_connectionstrign"].ConnectionString);
 
try
{
    SqlConn.Open();
    SqlCommand CreateNewSessionCmd = new SqlCommand(@"
        INSERT INTO [table]
        (
            [column]
        )
        VALUES
        (
            [value]
        )
        SELECT SCOPE_IDENTITY()
    , SqlConn);
 
    int insertedID = int.Parse(CreateNewSessionCmd.ExecuteScalar().ToString());
}
catch (Exception ex)
{
 
}