|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Exactly dude.... 
Best Regards,
Apurva Kaushal
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
always welcome...
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi I'm a web designer and I have a problem with a photo gallery in my web site
Is there a photo gallery DLL or something like that I can use in my web site without any problem
thanks...
dimo gidora
DC 83
Birjinia
|
|
|
|
|
You can have a look at this:
http://www.rebex.net/ImageGallery/
BTW you can also build your own component for that.
Best Regards,
Apurva Kaushal
|
|
|
|
|
|
I am using datagrid in my form.
In that datagrid i'm using dropdownlist in edit mode.
So when i click on edit linkbutton , it shows the first value by default in that dropdownlist.
I don't want like this.
i want when i click on edit linkbutton of each row, it should display dropdownlist accordingly.
But in that dropdownlist it should show the value itself , not the defalt value.
If i have 1,2,3 no. in dropdownlist.
Then if in first row if selected 2.
Then while editing this row through datagrid it should show 2 selected in dropdownlist.
But it is showing 1 by default.
This is the prob.
Plz help me.
Prakash
|
|
|
|
|
This you can do in OnItemDatabound event of the datagrid. That event gets fired for each row of the datagrid. In that event what you need to do is to find the dropdownlist and set the value accordingly.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Thanks for ur great help.
This is really working....
prakash
|
|
|
|
|
always welcome... 
Best Regards,
Apurva Kaushal
|
|
|
|
|
HI,
i have r problem ,i want to pull the image from the sqlserver2000 database and display it in Asp.net datagrid.
i try it but the image is not displayed in the grid.
kindly help me in this above regard.
my code is
Dim connstring As String = ConfigurationSettings.AppSettings.Item("DBSettingsServer")
Dim con As SqlConnection
Try
con = New SqlConnection(connstring)
con.Open()
Dim adp As New SqlDataAdapter("Select * from tblnews where NewsID =" & Request.QueryString("id"), con)
'Dim cmd As New SqlCommand
'cmd.Connection = con
Dim dst As New DataSet
adp.Fill(dst, "Table")
Dim row As DataRow
row = dst.Tables("Table").Rows(0)
Dim mydata() As Byte
mydata = row("NewsImg")
Response.Buffer = True
Response.BinaryWrite(mydata)
dst = Nothing
mydata = Nothing
row = Nothing
kindly send me some clue or code snnipet that help me
bst regards
|
|
|
|
|
There are a couple of things that you need to check:
+ Successfully get data from DB?
+ Propertly assign this web page to the image control in the datagrid?
...
Also, you can find the sample code using the search functionality of the site or check out this girl[^].
|
|
|
|
|
Hi.. I have a question about passing data.
My problem is i have a page which contain few textboxes, buttons and datagrid. My page actually is like an invoice form.
My question is how can i pass this page whole data to another page for printing purposes? Another question is can we perform printing process in asp.net?
anyone can help me? Thanks..
Best Regards,
Pei Sun
|
|
|
|
|
You can use session variables for passing the data from one page to another.
To print a page use the JavaScript function - window.print();
Thomas
|
|
|
|
|
hi..
what you mean is use session for every variable and then pass to another page? Or got any idea pass the whole page directly to another page?
Best Regards,
Pei Sun
|
|
|
|
|
Why are you using two separate page for that. If it is possible then use it in same page, you can use panels for that purpose. And to put the data in session what you can do is to create an array object and then put it in session.
Best Regards,
Apurva Kaushal
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
