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/datagridcheckbo x.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

[code=vbnet]
For Each row in MyGridView.Rows
Dim chkBox as CheckBox = Ctype(row.FindC ontrol("nameOfM yCheckboxInTheG rid"),Checkbox )
If chkBox.Checked = True
'Do your update
End If
Next
[/code]

-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.