adding to a dataset

wilbur · April 16th, 2005, 02:47 AM

i have a single form with two textbox entries connected to a Access db.

it fills and the two entries are seen at load....but i cant seem to add a new entry, i clear the values first and am completly stuck. ive tried....
    private void Form2_Load(object sender, System.EventArgs e)
        {
oleDbDataAdapter1.Fill (dataSet11);
        {
        private void button1_Click(object sender, System.EventArgs e)
        {
        dataSet11.Table1.Rows .Add textBox1.text;// no way
        }

completly knackered any ideas?

mehdi62b · April 16th, 2005, 08:25 AM

Code:

object[] entries={textBox1.Text,textBox2.text};//according to the columns
dataSet11.Table1[0].Rows.Add(entries);

if that array doesnt fit the column of dataset a exception would be thrown.now just DataSet is updated not DB.

_____________
Mehdi.
software student.

planoie · April 16th, 2005, 10:44 PM

wilbur,

Simply adding rows to a dataset table isn't enough. A DataSet is a disconnected data construct. You need to make a call back to the database to insert/update your data. You can do this several different ways. Usually there is a preferred way based on what kind of application you are creating.

-Peter