C#

string connectionString = "Data Source=srv032k3; Initial Catalog=MuzeDB;Integrated Security=SSPI; User ID=sa; Password=;sa";
SqlConnection connection = new SqlConnection(connectionString);

try
{
    connection.Open();
    SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM students ORDER BY Id", connection);
    SqlCommandBuilder command = new SqlCommandBuilder(adapter);

    //create a dataset object
    DataSet ds = new DataSet("StudentsSet");
    adapter.Fill(ds, "students");

    //create a new datatable object
    DataTable dt = ds.Tables["students"];
    DataRow row = dt.NewRow();

    //give value for the new row
    int id;
    string name, address;
    id = 4;
    name = "Nadeem";
    address = "Layya";

    row["Id"] = id;
    row["Name"] = name;
    row["Address"] = address;
    dt.Rows.Add(row);

    adapter.Update(ds, "students");

    Console.WriteLine("A new row added: {0} {1} {2}", id, name, address);

    connection.Close();
}
catch (Exception ex)
{ Console.WriteLine(ex.Message); }