Data displaying in datagrid as dynamically..

[_AK_]

You can use onitemdatabound event for that purpose it executes for each an every row of the datagrid. In that event you just have to find the control and assign the values.

Best Regards, Apurva Kaushal

[Prabs frm PGP]

Hi! Apurva! I am a newer., Can u give me some sample coding.. How can we using that findcontrol method?

[_AK_]

here is the sample code for itemdatabound event: public void dg_ItemBound(object sender, DataGridItemEventArgs e) { if(e.Item.ItemType==ListItemType.Item || e.Item.ItemType==ListItemType.AlternatingItem) { Label lbl = (Label)e.Item.FindControl("lblName"); lbl.Text = "Apurva"; } }

Best Regards, Apurva Kaushal

[Prabs frm PGP]

Hi! I tried that one., but The DataGrid Control is not displaying., We have to Bind the Datagrid na.... How can we do that one..? Prabu.T

[_AK_]

For that first you need to get the data from the database and then assign the datasouse property and then bind the datagrid by calling the method databind. This is the sample code to bind the datagrid: SqlConnection conn = new SqlConnection("Your connection string"); SqlCommand com = new SqlCommand("Select * from emp", conn); SqlDataAdapter da = new SqlDataAdapter(com); DataSet ds = new DataSet(); da.Fill(ds); DataGrid1.DataSource = ds; DataGrid1.DataBind();

Best Regards, Apurva Kaushal

[Prabs frm PGP]

Hi! Thanks i got datagrid with the Labelbox control it displays what i gave in that control's text ie., if i gave lbl.text="Apurva" it shows this one but i i need the value frm DB.. Prabu.T

[_AK_]

For this you need to fetch the data from the database and then assign. If you are having the data in the same table which you have bind to the datagrid then with the help of datarowview you can access the data and then can assign the data to the control in ontemdatabound event. like this: DataRowView drv = (DataRowView)e.Item.DataItem; lbl.Text=drv[0].ToString(); -- modified at 4:44 Wednesday 9th August, 2006

Best Regards, Apurva Kaushal

[Prabs frm PGP]

Hi nice yar., I got that one also., but if i add another one control with that one., thats a imagebutton control., i did what u gave for that label box i did kike that only ImageButton img =(ImageButton)e.Item.FindControl("imgbtnModel"); img.ImageUrl= "E:\rose.jpg"; first for ex: i gave like this but for this also i hv to retrieve the url frm DB., k., i vl do that one used that datarowview., but wat s the error in the above one..? T.Prabu

[_AK_]

Exactly dude.... :)

Best Regards, Apurva Kaushal

[Prabs frm PGP]

Hi Apurava., I got that image also., everything is fine., Last one: If i clicks that image butoon it has to go some other page and displays the details abt that page., how can v do this one..? Prabu.T

[Prabs frm PGP]

Hi Apurava., I got that image also., everything is fine., Last one: If i clicks that image butoon it has to go some other page and displays the details abt that page., how can v do this one..? and during dynamic retrieval how can v achieve the paging on datagrid? Prabu.T

[_AK_]

Two ways are there either you can put that in anchor tag and give href property or you can handle the click event of the imagebutton in the itemcommand event of the datagrid.

Best Regards, Apurva Kaushal

[_AK_]

for datagrid paging you can take help of this site. It is having so many good articles on datagrid. www.datagridgirl.com :)

Best Regards, Apurva Kaushal

[Prabs frm PGP]

Hi Apurva., Today only i registered to this Forum., and its my first question very nice and patient answer from ur side., Thanks yaar.., Prabu.T

[_AK_]

always welcome... :)

Best Regards, Apurva Kaushal