Using Datasets and Data Adapters - Beginning C# 2008 Databases: From Novice to Professional - page 297

// insert employees
//
// create command
SqlCommand cmd = new SqlCommand(ins, conn);
//
// map parameters
cmd.Parameters.Add(
"@firstname",
SqlDbType.NVarChar,
10,
"firstname");
cmd.Parameters.Add(
"@lastname",
SqlDbType.NVarChar,
20,
"lastname");
cmd.Parameters.Add(
"@titleofcourtesy",
SqlDbType.NVarChar,
25,
"titleofcourtesy");
cmd.Parameters.Add(
"@city",
SqlDbType.NVarChar,
15,
"city");
cmd.Parameters.Add(
"@country",
SqlDbType.NVarChar,
15,
"country");
//
// insert employees
da.InsertCommand = cmd;
da.Update(ds, "employees");
}
catch(Exception e)
{
Console.WriteLine("Error: " + e);
}
finally