grid

[shalini166]

how to select particular row in datagrid when checkbox in datagrid is selected and also inserted into database

pls help me.it is need for my mca project.

[vee10]

u can check out this link

http://www.codeproject.com/KB/webforms/datagridcheckbox.aspx

how to select particular row in datagrid when checkbox in datagrid is selected and also inserted into database

pls help me.it is need for my mca project.

[Frinavale]

how to select particular row in datagrid when checkbox in datagrid is selected and also inserted into database

pls help me.it is need for my mca project.

Add a CheckBox column to your grid.
Then when you are ready to update your database, loop through your grid and determine which ones were selected...

eg

For Each row in MyGridView.Rows
   Dim chkBox as CheckBox = Ctype(row.FindControl("nameOfMyCheckboxInTheGrid"),Checkbox)
   If chkBox.Checked = True
      'Do your update
   End If
Next
 

-Frinny

[shalini166]

Hi,

How to select particular row in datagrid when checkbox in datagrid is selected and also inserted into database.

sorry for the disturbance.

i need c# coding and also insert particular row coding.or multiple row insertion coding.

pls help me.

[vee10]

Hi,

I think on checking the checkbox in the datagrid any of the events is going to fire so u should place a button and do the necessay thing u want to do

if u get any solution plz share that

Hi,

How to select particular row in datagrid when checkbox in datagrid is selected and also inserted into database.

sorry for the disturbance.

i need c# coding and also insert particular row coding.or multiple row insertion coding.

pls help me.

[shalini166]

i want to know how to insert each cell in the datagrid to the database.

pls help me.

[vee10]

hi..

 
        SqlConnection conn = new SqlConnection("Data Source=PRAVEENAPC;Initial Catalog=testing;Integrated Security=True");
        conn.Open();
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "insert into emp values(";
        cmd.Connection = conn;
        for (int i = 0; i < GridView1.Columns.Count; i++)
        {
            cmd.CommandText  = cmd.CommandText + "'" + GridView1.Rows[0].Cells[i].Text + "'";
            if (i + 1 != GridView1.Columns.Count)
                cmd.CommandText = cmd.CommandText + ",";
                  }
 
        cmd.CommandText = cmd.CommandText + ")";
 
        int insert=cmd.ExecuteNonQuery();
 

this is one way of inserting the values into database

there are other way using parameter etc.....
but this is how u can retrieve the rows in database

i want to know how to insert each cell in the datagrid to the database.

pls help me.