|
hi there..
i assume that u know how to use formula field.
so i'l gonna solve your problem as:
use a variable which stores the value of the previous row result and then add this variable to the sum of the current row result.
i hope you got it..!
J A Nasir K
|
|
|
|
|
Hi All,
I working on developing a windows application, i want to give user the permission to compress a specific directory and i want to knw how do we achieve it.
Note: I want to compress a Directory\Folder.
Thanks and regards,
Ashwin.
|
|
|
|
|
A quick google search for " vb.net compression" provides a range of pages dealing with that subject, some of them even with code examples.
278.000 results for vb.net compression. (0,08 seconds).
"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)
|
|
|
|
|
Hi,
I´d like to save a file in an oracle database over oledb. The code was allready running for sql only. But it has also to work with oracle. So i changed my connection from sql to oledb. But since that it don´t work with booth. Something is wrong with the parameter @data in booth cases. Has anybody an idea?
Private Function SQL_Save_this_PDF(ByVal selection As String, ByVal where As String) As Boolean
Dim oledbConn As OleDbConnection
If Not CcPdfViewer1.pdffile = "" Then
Dim id As String = ""
Dim bindata As Byte()
Dim strm As IO.Stream
Dim filename As String = CcPdfViewer1.pdffile
strm = New IO.FileStream(filename, IO.FileMode.Open, IO.FileAccess.Read)
ReDim bindata(strm.Length - 1)
strm.Read(bindata, 0, strm.Length)
strm.Close()
filename = My.Computer.FileSystem.GetName(filename)
If dbms = "oracle" Then
oledbConn = New OleDbConnection("Provider= OraOLEDB.Oracle; Data Source=" + server + "; User ID=" + database_user + "; Password=" + database_pwd + ";")
Else
'mssql
oledbConn = New OleDbConnection("Provider= sqloledb; Data Source=" + server + ";Initial Catalog=" + database + "; User ID=" + database_user + "; Password=" + database_pwd + ";")
End If
Try
oledbConn.Open()
Static save_pdf As OleDbCommand
save_pdf = New OleDbCommand("Insert into dateien (id,name,data) values ('" + id + "','" + filename + "',@data)", oledbConn)
save_pdf.Parameters.Add("@data", OleDbType.LongVarBinary)
save_pdf.Parameters("@data").Value = bindata
save_pdf.ExecuteNonQuery()
Thanks, Daniel
Catch e As OleDbException
MsgBox(e.Message)
oledbConn.Close()
Return False
End Try
bindata = Nothing
End If
Return True
End Function
|
|
|
|
|
Found it. Just change the parameter @data in the oledbcommand to "?".
|
|
|
|
|
Hi all,
Now i am working with a checkedlistbox. Can i sort the checked items in a checkedlistbox. In other words , I want to display the checked items in the top of the checkedlistbox. Any suggestions would be appreciated
Thanks
Sebastian
|
|
|
|
|
Sounds like you'll have to load the checked items into a list, then the unchecked items into another list, then clear the checkedlistbox, then add items to it first from the checked items list, and then the unchecked items list.
|
|
|
|
|
|
Is it possible to merge two RTf files into one...
Please post any reference links or sample code...
Jats
|
|
|
|
|
You are really annoying. You asked a question like this just a few hours ago.
"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)
|
|
|
|
|
My Mott Community College instructor accomplished this by having a richtextbox on a form->copy the RTF information->strip the header inforamtion->concat to another richtextbox.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios[ ^]
|
|
|
|
|
Thanks for the information,
Could you provide any sample code for the same...
Jats
|
|
|
|
|
how will i get the cursor position in the textbox..?
J A Nasir K
modified on Monday, April 28, 2008 8:40 AM
|
|
|
|
|
Hi,
If you are looking for Mouse position in the textbox then you can do it by
TextBox1.MousePosition
Howerver, if you are for the text cursor which is called caret, then you may try the control's 'SelectionStart'.
Hope this helps .
Regards,
John Adams
ComponentOne LLC
|
|
|
|
|
<blockquote class="FQ"><div class="FQA">Jamal Abdul Nasir wrote:</div>how will i get the cursor position in the textbox..? </blockquote>
By reading the documentation and writing a little bit of code, as always.
You might be interested in TextBox.SelectionStart
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
|
Hi every body
i have a treeview control in windows mobile application which load it's data from a database ,
i want when the user select a node automaticlly clear the other loaded nodes , so how can do that ??
Thanks ,
Mona
LA ELAH ELA ALLAH MOHAMED RASOL ALLAH
|
|
|
|
|
-- > How will i package a software in a way it detects the prerequisites(e.g; sqlserver, dotNet framework, crystal reports etc...) for the software and install them in a single click after detecting them?
J A Nasir K
|
|
|
|
|
If you use VS 2005, you can use ClickOnce deployement.
Here[^] is a code project article that discusses it.
Here [^]is an MSDN article that discussees it.
Google [^]will yield other articles you use to research.
If you do not have VS2005 or better, you will want to research visual studio setup and deployment[^] projects.
|
|
|
|
|
Hi,
I have added an outlook plugin project.Everything works fine.
Whenever I receive a mail an Incoming mail event needs to be fired and hence I do my processing further.
This works fine when the outlook is opened.But when my outlook is closed and if I receive the mails in the mean time, again when I open the outlook the "Incoming mail event" is not fired for all the new mail messages. What could be the problem?
How Should I handle this ?
Any Suggestions would be helpful.
Thanks
Satya
Today is a gift, that's why it is called the present.
|
|
|
|
|
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)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
