|
Hi Experts,
I need help with a databinding in a text box, which draws a column from a dataview.
the sql statement used for the dataview is:
SELECT ArtistID, SUM(Popularity) from ArtistPopularity WHERE NOW >= PeriodStart AND NOW <= PeriodEnd GROUP BY ArtistID
The dataview is row filtered by artist id. The artist id can be selected through a combobox.
The crux of the issue is that not all artists will have a popularity, so this means there will be null values for some artists. So when you scroll through the artist id's in the combobox, only ones with popularities should come up in the dataview.
First i got an indexoutofrange exception, stating that there is no row at positiong 2, this is down to the fact that position 2 in the dataview does not have a value so i caught the exception like so:
Try
TextBox13.Text = oArtistPopularity3DT.Rows(TextBox1.Text).Item("Popularity")
Catch ex As Exception
End Try
But now the problem i face, is that the textbox does not update to the values inside of the datview now. It just remains the same as the last value, before it catches the index out of range.
How do i make it show the value in the textbox, when there is a value in the dataview.
Any help is much appreciated
thanks.
|
|
|
|
|
How to display a word document in Crystal Report,
Please help i am not getting any information in Google.
Thank You...
Jats
|
|
|
|
|
A word document (.doc, .docx) in Crystal Reports???
Don't know if anyone else has ever wondered if that can be achieved, but I have my doubts there is a simple way to do it.
Theoretically, you could... create a report in CR, then open the word document as a string, somehow put it into a dataset or object, then use that dataset or object as datasource for the CR... thought it'd be kinda pointless I guess.
If you're looking for a viewer or editor, though... well, use MS Word or Open Office Writer or Google Docs or write your own .doc or .docx editor using the specs[^] given by Microsoft.
Good Luck anyhow
Kazz
"Users are there to click on things, not think. Let the archs do the damn thinking."
|
|
|
|
|
Thank you for the info...
Do you have any code samples to do it,
Or any link where i can get exact procedure.
Jats
|
|
|
|
|
Hi All
I have one problem.My crystal report has diffrent database fields.It works fine.
But i want to change "detail section" when i select value from combo box.
means my last field of detail section is "jan from student table".when i select value as feb from combo box,i want feb values from database in "detail section"
Is it possible?
if possible,how can i do that?
pls if u have any code for reference,pls help me as early as possible.
Thanks
monika
|
|
|
|
|
Apply a new record selection formula to your report, when the value of your combobox changes.
It's "please" by the way, not "pls". You have a proper keyboard in front of you and aren't typing this on a mobile phone.
"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)
|
|
|
|
|
Create a parameter in crystal report and send text you select from combobox. Now check parameter value in formula and change the detail section accordingly....
J A Nasir K
|
|
|
|
|
Hai, I use datagridview to display all the data from database. There is a field named userlevel in the database. The value stored in the database is '1', '2' and so on. So, when display in the datagridview, can it change the '1' to admin and '2'to power user and so on.
Thank in advance.
|
|
|
|
|
Why do you not do it in the query?
Il principe
|
|
|
|
|
Thank for the reply. could you show me how to use query to do it?
|
|
|
|
|
i think u r having 2 tables to get data from. if this is the way then use views in the database. it will gona solve ur problem.
J A Nasir K
modified on Monday, April 28, 2008 8:41 AM
|
|
|
|
|
Hi
i have some embedded devices on the network.
I need to send a message to my devices on a LAN.
My devices are programmed to response to the message
But i need a help to broadcast the message. How can i broadcast the message.
Can anybody tell me about the network broadcasting.
|
|
|
|
|
Use Network Protocols TCP, UDP
to send data.
But it's depends on your device which is connected on the LAN.
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
Hi all,
I have need to convert a group of files (.DOC or .RTF) to PDF.
The basic need is to merge 5 to 10 files and generate a single PDF output.
Any idea would be of great help...
Thank you for your time...
Jats
modified on Monday, April 28, 2008 5:49 AM
|
|
|
|
|
You need to buy a PDF library to do this. Merging the files, depends on what sort of files they are, probably easiest just to add them all to a PDF
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi,
please i need help about this issue
I want windows to inform my application when the screen resolution is changed, I am using vb.net 2003 thanks.
Mohammad Al Hoss
|
|
|
|
|
Add a handler for the SystemEvents.DisplaySettingsChanged event.
I'm largely language agnostic
After a while they all bug me
|
|
|
|
|
thanks alt i will check it.
Mohammad Al Hoss
|
|
|
|
|
Hi Friends,
I am in middle of a Vb.Net project working in VS2003.
I need to migrate it to VS2008 version.
The problem is that i didnt have the XP CD for installing. Please advice will that be a problem for installing VS2008.
Also what might be the Pre-requirements for installing VS2008?
Thanks,
Ramki
|
|
|
|
|
Did you try it to find out ? If you don't have the XP CD, odds are you do not own XP. But, all the prerequirements, come on the VS2008 CD/DVD
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hello,
I own xp but the CD is broken during logistics. Thats y i am posting this query.
And for your other query, i havent tried installing VS 2008. I need to know what and all is pre-required and get prepared to migrate.
Please let me know the solution.
Thanks,
Ramki
|
|
|
|
|
Ramki Sankaran wrote: Please let me know the solution.
I did....
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi!
All
I am new to this site..
I am in a situation where i want to change the owner of the file (*.txt,or any other) (local / remote)file.
I have successfullly written code to change the file's last modified date and time and as well as created time and date.
But I want to chanage the owner too.....
I unable to do this magic....
can anybody help me to come out of this....?
After Searching around 6 hrs (including this Codeproject) on Internet , I am finally posting here....
Thanks in Advance...
D.N.Raj
|
|
|
|
|
hi all experts,
as i'm new to this, can someone plz advice me?
my project requirements:
1. images upload with adding texts/descriptions attached to it (save it in notepad/html??) using microformats (not too sure also as need details from lecturer)
2. search images via information in the notepad/html saved to the images
3. display searched results images
should i use C#, VB, C++ for this project? as i want to start on the right path... can someone plz refer to any guide?
i've found this:
http://www.codeproject.com/KB/aspnet/netimageupload.aspx
is this the right on to start on? so i can add on later...
please help thanks a million.. waiting on your reply!!
my email/MSN : narmon@gmail.com
plz help
|
|
|
|
|
Did you cross post this, or was my answer lost ?
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|