0

I have a access database from where I am populating the datagridview on button click event. but what I exactly I want to add record of access database in datagridview when button is clicked. Means on 1st click 1 record should be add in datagridview, on 2nd click another record should be add and so on...

What modification I need to make in my code, please guide me

        private void button1_Click(object sender, EventArgs e)
        {
            aCommand3 = new OleDbCommand("select * from batch_tbl", main_connection);
            aAdapter3 = new OleDbDataAdapter(aCommand3);

            ds3 = new DataSet();
            aAdapter3.Fill(ds3, "app_info");

            ds3.Tables[0].Constraints.Add("pk_bno", ds3.Tables[0].Columns[0], true);
            int batch_count = ds3.Tables[0].Rows.Count;

            dataGridView1.AutoGenerateColumns = true;
            dataGridView1.DataSource = ds3.Tables[0];
        }

Thank you everybody for any advice/suggestion

2
Contributors
1
Reply
10
Views
4 Years
Discussion Span
Last Post by JOSheaIV
0

Hmm, never worked with Access databases before, but couldn't you use some sort of incrementer that kept track how many times the button is clicked?

Now for dataGridViews all you need to do is do something like

dataGridView1.Rows.Add(); //adds a new row

dataGridView1 [i, (dataGridView1.Rows.Count - 1)].Value = "";
    // i would the # for which column you want to access, so you'll have to do with that as 
    // you want, but this will add to the last row in the dataGridView, well you'd have to 
    // replace the "" with whatever data you want to add

You'd just use this everytime the button is clicked (well you might want a check to make sure that there's still data being pulled from the database).

This help at all (sorry if it seems a little rushed)?

Edited by JOSheaIV

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.