|
Hi, my computer have sql server 2000 and vb.net. Now I successfully install sql server 2000 reporting service on the machine. I could create the project about making the report, BUT......... Now I have a windows application and I want to create report. I have designed the report in reporting service but I don't know how to integrate it with my application. I try to find it item in Add new component... But I just found only crystal report, not reporting services. Is it possible to integrate reporting service in windows application? If it is possible, how could I do it??? Please there is any information about using reporting service and vb.net for the beginner, it would be greate.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
A good place to start would be with the samples included in reporting services. Personally I figured out most of what I need to know by looking at the RSExplorer example. Assuming you installed reporting services in the default path you can find it here:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Applications\RSExplorer\vb
Beyond that there is a lot of good information in the Books Online for reporting services.
Hope that helps,
Daryl Morgans
|
|
|
|
|
 Wich is better :
Dim myAdapter as oledbDataAdapter = new oledbDataAdapter("bla bla")
or
Dim myAdapter as new oledbDataAdapter("Bla bla")
.
|
|
|
|
|
Neither. They produce exactly the same IL code.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
And Integer.Parse or CINT OR CTYPE ?
|
|
|
|
|
These three functions don't do the same things, so your trying to compare apples to oranges to banana's.
Integer.Parse attempts to create an 32-bit signed integer out of a text string.
CInt attempts to convert the value of a numeric datatype into a signed 32-bit integer value.
CType attempts to convert one datatype into another datatype. This works with numeric types, objects, structures, classes, interfaces, ...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
ok thanks a lot  You really are a very helpfull resources
Now for the last question :
Dim ocls as Classname
or
Private (public etc..) ocls as Classname
in the Code-Behind (not in methods).
I'm sorry for all those question, it's just thing i havent paid attention, in my learning process.
|
|
|
|
|
At this level, both of your statements generate the exact same code. If Public or Private is specified, the Dim keyword becomes optional. If there is no access modifier specified, Dim must be used and the variable is Private by default. These three statements do the exact smae thing:
Class myClass
Private Dim mstrLine1 As String
Private mstrLine2 As String
Dim mstrLine3 As String
End Class
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Great, thank you very much.
|
|
|
|
|
 I have a word macro (W97) that reads rich text from a database field assigns it to a rich text box control and pastes it into the word doc.
The macro has been tested on four development machines and it runs fine. However, when it is moved to a production PC it produces error 429 can't create object. This error occurs on the rich text assignment line.
rtb.TextRTF = strSelection
Is there anything special ( a DLL or OCX that should be registered) that should be done to release the macro. What is special about the development machines that allow the macro to run?
|
|
|
|
|
There are a bunch of reasons why this error could come up, but none of them have anything to do with the RichTextBox. It's more likely that it is a problem with the Data Access Components. Try updating the components with MDAC 2.7 SP1 (at least).
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
----------------------------------------------------------------------------
How do I set different tooltip message for different selected Listviewitems?
My ListView is in Detail mode and FullRowSelect = true
|
|
|
|
|
ToolTips are not supported on ListViewItems.
What you'll have to do is handle the MouseHover event of the ListView control, then use the ListView .GetItemAt() method to return the ListViewItem that the mouse is over. You can then use whatever you want from that to set the Text of your ToolTip control. Handle the MouseHover event of the ListView to display the ToolTip.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
thankz for the reply & tips, but im having abit problem. My program's listview display a report in such way as it will identify the row where there are error in any of it's colume and highlight it in pink. I'm suppose to display a tooltip on selecting of the "error" row and display a message stating the column that are incorrect.
How should i do it?
|
|
|
|
|
If your code highlights a ListViewItem in Pink because of an error, then you can also set that ListViewItems Tag property to some value to signify the same. You can then check that Tag property when you go to set the ToolTip Text. If the Tag signifies an error, setup the ToolTip. If not, clear it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
After loading an image file in a picturebox with picturebox.Image = Image.FromFile(Foto.Path) i want the file deleted from the hard disk.
First I dispose the image in the picturebox (picturebox.Image.Dispose()) an then I delete teh file (System.IO.File.Delete(Foto.Path))
I recieve the message acces denied
Can anybody help me
Thnks
Jo De Decker
|
|
|
|
|
The Image object that you originally used to load the image from the file still has the file open. You called .Dispose() on the Image object in the picturebox, not on the Image object that loaded the file.
To work around this little "feature", see this[^] article on MSDN.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
|
While testing a service we've setup in Visual Studio / VB.NET we've found that the service will start without a problem if the files that it is monitoring are local to the machine the service is running on.
As soon as we try to monitor a file on our network, and start the service, the following security message is thrown:
Service cannot be started. System.UnauthorizedAccessException: Access to the path "\\TheServer\D Drive\FTP Files\OpenActions.csv" is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String str)
at System.IO.File.GetLastWriteTimeUtc(String path)
at System.IO.File.GetLastWriteTime(String path)
at FileChangeMonitor.ChangeMonitor.CheckFileChanged(String FileName, DateTime& LastChangeDate) in E:\_MyFiles\Vb.NetProjects\Development\FileChangeMonitor\FileChangeMonitor\ChangeMonitor.vb:line 171
Any suggestions on what needs to be changed via security is appreciated.
Lost in the vast sea of .NET
|
|
|
|
|
By default services run under the SYSTEM account. That wont have any rights to access files on the network. Each service can be configured seperatly. This can be done under Control Panel->Administration->Services->Right Click->Properties->LogOn (Im not sure about the names because Im using a german windows version).
|
|
|
|
|
That worked... Thanks!!
Lost in the vast sea of .NET
|
|
|
|
|
A second problem your going to run into is that the FTP server will not lock the file that is being uploaded to it. Your service has to take into account that it cannot know when the file is completely written to the disk by the FTP server. The FileWatcher will notify you when the file is created, not when it is closed by the FTP Server.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
You brought up a very good question. How do we know if a file that we're looking for with the service is closed by the FTP process? I'm not sure what the answer is? Any suggestions?
Lost in the vast sea of .NET
|
|
|
|
|
The short answer is, you can't.
Most FTP server implementations (and I can't tell you which ones do and don't do this) don't lock the files they are writing for exclusive write access. This means that you can open the file while the FTP server is writing it.
You can not open the file for exclusive (not shared) access while you read the file, because this might have the affect of forcing the FTP server to abort the transfer when it can no longer write to the file.
Other that testing for exclusive read access, there is no way to find out when the file is completely written.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I need to get the date to show in something such as a textbox or whatever. But everything I try doesn't show the date. I set the textbox to read only and everything. i am using ;
<br />
Dim D As Date<br />
D = Today<br />
TextBox7.Show()<br />
can anyone help me?
thanx
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
