|
I have the following data in my table
PartId SerialNo Qty
1 r0011 2
2 r0012 3
3 r0013 4
4 r0014 1
5 r0015 2
1 r0016 7
2 r0017 3
3 r0018 5
4 r0019 1
5 r0020 2
1 r0012 7
2 r0014 3
3 r0018 5
4 r0016 1
5 r0020 2
I need the following output
Page: 1
PartId r0011 r0012 r0013 r0014 r0015
1 2 7 0 0 0
2 0 3 0 3 0
3 0 0 4 0 0
4 0 0 0 1 0
5 0 0 0 0 2
PartId r0016 r0017 r0018 r0019 r0020
1 x x x x x
2 x x x x x
3 x x x x x
4 x x x x x
5 x x x x x
|
|
|
Page :2
same as page 1
---------------------
The columns r0016- r0020 has to display below of first results when there is no room to accomodate for columns.
I have used cross tab but partid:r0016 ---- r0020 are displayed in 2 nd page eventhough there is a lot of space to accomodate in page 1.
Please give me a solution for this problem.
|
|
|
|
|
Hey, Im reading from a database and retrieving a whole long list of URL's. Im using a label and just saying(from my code behind): myLabel.Text += theurl + " ";
Now that obviously just makes a whole long list. But is there some way i can use something like a radiobuttonlist to format them? A radiobuttonlist would be perfect(because you can specify number of columns etc etc) except that i want hyperlinks now radiobuttons.
Thanks alot
|
|
|
|
|
use a repeater or datalist
|
|
|
|
|
That looks good, but I dont want to use databinding. Is there a way that I can just say(while in the sql read loop) something like: repeater.Items.Add("url:" + urlFromSql);
??
Thanks
|
|
|
|
|
roguemat wrote: That looks good, but I dont want to use databinding
I want to bang in a nail but I dont want to use a hammer.
|
|
|
|
|
So is the only possible way databinding?
p.s. u could use a spade
|
|
|
|
|
roguemat wrote: p.s. u could use a spade
Or a shoe, but its not the right tool for the job!
|
|
|
|
|
Use a StringBuilder if you want to build a string. Put each URL in an element, so that it's easy to format it. You can easily loop the URLs into a StringBuilder:
builder.Append("<div>").Append(Server.UrlEncode(theUrl)).Append("</div>");<br />
<br />
Then just add the string in a div element using it's <code>InnerHtml property, put a class on the div, and you can format it any way you like using css. You can format the elements as lines, or float them beside each other as many as you like.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
i want to display todays date and time in a page
how can i do it
even if client changes his system timings
the time should not be changed
and the time should be unique in india
i used dotnet functions to get date and time
ex. DateTime.Now()
Date.Today()
TimeOfDay
these are not showing todays time
if i change the time in system then the date changes
plz help me
its urgent
thanks in advance
vijay kumar
|
|
|
|
|
You either get the time from the persons computer or the time from the server where the application is held.
|
|
|
|
|
if you want to get the time independent of the user's or the server's settings, then you'll need to call a webservice to fetch the time in the location you want (India). You'll have to google for "world time webservice" or something, but there'll be one somewhere...
|
|
|
|
|
If the applicationis web application then don't worry
even if cleint changes the date, it is not going to change as ou are setting the date at server side.
But what if system date is changed at server side ?
THen you can't do anything. then Create a service that will return date ?
What if they (machine in which service is implemented )changes the Date ?
So my friend,DateTime uses system date one should not change the date at server side as it is going to affect many applications (if hosting).
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|
|
Hi Guys,
I want to show some video files in my webpage.
my question is where is the better place to save those files???
in the database(im using sql server 2005) or in a directory on the webserver???
maybe some references of how to do that?
|
|
|
|
|
Must be on Server in some folder in your portal
because video files are very heavy and the will kill your application by slowing down it if u bring it from database.
store them in some folder on server itself and save path like "\videos\comedy\" and "\videos\sports\" in database simple varchar field. that will be more faster
Anand Desai
Developer
Atharva Infotech
|
|
|
|
|
I agree def dont store them in the database, just store the file location in the database
|
|
|
|
|
Hi Anand,
Thanx a lot for your advice.
Do you know maybe any references/links that i can learn more about how to do that??
|
|
|
|
|
Hi,
I am using a datagrid to show my data. In my datagrid I have one column it shows the image. My problem is that I can see the images in IE but not in firefox. How can I make my images visible in datagrid for firefox.
Rock Star
|
|
|
|
|
I suspect the issue is nothing to do with the datagrid. What happens if you try displaying the same image just on it's own with a "normal" img tag? If your image path/filename has spaces in it, try replacing them with %20 in the url. Examine the page source code to see exactly what is being sent to the browser.
|
|
|
|
|
There is no pace in the path I have given for the image. Problem is I can see the image in dadatgrid column in IE but not in the firefox. I just see the blank column in datagrid in firefox.
Rock Star
|
|
|
|
|
Rock Star. wrote: I just see the blank column in datagrid in firefox.
Now do a right-click and choose "View page source" and see what is written to the column...
|
|
|
|
|
Hi,
It shows the path of the image and image name but it didnt show the image in a datagrid column in firefox.
Rock Star
|
|
|
|
|
and if you copy/paste that exact path into the src property of a standard HTML img tag outside the datagrid, does it or does it not show in Firefox?
Is this by any chance a jpg image that was produced on a Mac and you are displaying it on a PC, or vice versa? This can cause issues too. Open the file in an image manipulation program on your computer and save it again.
|
|
|
|
|
Yes when I am copy/paste the entire path outside the datagris I can see the image. but not in datagrid.
I dont think image produced on Mac is the issue. Because if it so I should't see any image in datagrid in IE. But I can see the images there but not in fire fox
Rock Star
|
|
|
|
|
Hi
I asked a similar question below but am reposting as it is in different circumstances.
I need to be able to minimize the broswer window when it is in kiosk mode using a button.
Is there any way to do this? for example using javascript or similar language
thanks!
|
|
|
|
|
My datagrid is bounded with a table to show records, in the last of datagrid i have buttoncommand which i set to link,
"when some1 click on it the specific user_id pass into querystring" how to do that ??
thanks
|
|
|
|