private void button1_Click(object sender, EventArgs e){ this.tblProgramsTableAdapter.Insert("test cat", "test name"); this.tblProgramsTableAdapter.Update(this.programsDataSet.tblPrograms);}
private void button1_Click(object sender, EventArgs e){ SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM tblPrograms", this.tblProgramsTableAdapter.Connection); SqlCommandBuilder sqlCmd = new SqlCommandBuilder(sda); DataSet ds = new DataSet(); sda.Fill(ds); DataRow dr = ds.Tables[0].NewRow(); dr["Cat"] = "test cat"; dr["Name"] = "test name"; ds.Tables[0].Rows.Add(dr); sda.Update(ds);}