POpulate DataGrid

[aj_daria]

How can i add, delete, update using datagrid?currently, im using Sql Server as the database.

[nikkiH]

That highly depends on whether you meant Windows Forms or Web forms.
If you're using .net 2.0, use GridView, not DataGrid.

[aj_daria]

it is windows form. i know, the binding navigator can be used to add, delete, but i had to used button. so i didnt know how to add or delete without using the binding navigator. can anyone help me?

[nikkiH]

This is pretty basic if I understand you.
Search shows a ton of tutorials and FAQs on the subject.
http://www.google.com/search?source=ig&hl=en&q=windows+forms+datagrid&btnG=Google+Search

[kapil.goyal]

here is a sample code: modify according to ur need

this is for update task

TextBox tb1=new TextBox();
TextBox tb2=new TextBox();
TextBox tb3=new TextBox();
tb1=(TextBox)e.Item.Cells[2].Controls[0];
tb2=(TextBox)e.Item.Cells[3].Controls[0];
tb3=(TextBox)e.Item.Cells[6].Controls[0];
DropDownList ddl1=(DropDownList)e.Item.Cells[4].FindControl("dropdowndept");
string deptid=ddl1.SelectedItem.Value;
DropDownList ddl2=(DropDownList)e.Item.Cells[5].FindControl("dropdowndesgi");
string desgiid=ddl2.SelectedItem.Value;
int empid=Convert.ToInt32(DataGrid1.DataKeys[e.Item.ItemIndex]);

i think rest of the operations are easy.
if u r using indexing then u may have a problem in deleting a record when there is a single record in datagrid or in page.these 2 are diferent problems.if u hav this prob then ask me.

[aj_daria]

thanks for ur reply, but for the update task, i already know the code. right now, i m having problem for adding data because it involves master detail relationship and i have to add the data from text box and also datagrid.

[kapil.goyal]

just access the datagrid control value by findcontrol method by passing the id of the control in that.i think this is a sql problem rather than a grid problem.can u tell me in detail abt ur problem.