|
I have a tabcontrol which I have added a MonthCalendar1 to Tabpage1.
Is it possible to display this MonthCalendar1 on another Tabpage?
If so how would I go about doing this? Or would I just add another MonthCalendar to this Tabpage?
Cheers in Advance
Procrastifixation (adj)- the time taken to fix a software bug.
|
|
|
|
|
Hi There
I'm badly stuck trying to get what seems to be a very simple crystal report to display in the report viewer. I am using the .NET 2003 version of CR (which I have been told that is basically version 9.0) and SQL Server 2000.
I have been through multiple articles/tutorials regarding this issue but all seem to be based on creating design time SqlDataAdapter, SqlDataConnection, DataSet objects. However, I require these objects (or at least the adapter) to be created at runtime as the query that the report can be based on is dynamically built by the user.
So just to get a handle on what is going on I thought I would try a very simple single table query before messing around with the actual multi-table inner-outer join nightmare that I really need. That was three days ago...
I have created a dataset by dragging the single table "tbl_Students" onto the dataset design form. I can't see anything else I have to do here. I also created the crystal report using the report expert and simply added all the fields of the table to this report.
Here is the rest of my code:
Dim adConn As New SqlConnection("Initial Catalog = DBName;Data Source=Server;Integrated Security=SSPI")
Dim adCmd As New SqlCommand("SELECT * FROM tbl_Course", adConn)
Dim adAdapter As New SqlDataAdapter(adCmd)
Dim dSet As New CrsInfo
adAdapter.Fill(dSet)
Dim stuRep As New Students
stuRep.SetDataSource(dSet)
cvwMain.ReportSource = stuRep
I continually get Crystal Report Windows Forms Viewer Error that simply says Query Engine Error with a path to some temp_GUID.rpt file in my user profile. If I do the design time drag and drop with a connection object, adapter object and a dataset object all works well, but this is not what I need. Any help will be much appreciated.
Thanks.
Mountie
|
|
|
|
|
In my cut and paste frenzy, I forgot to change all kinds of things in the code. I'm going to retry and post my results in a minute or two...
|
|
|
|
|
Okay - success!!
Despite my code posting not making any sense let me assure you that that was just a cut and paste error. However the problem really was that when I called the .Fill method of the DataAdapter I didn't specify which table to use for the field mappings. If you don't, the report comes out blank! Hmmmm, what about when I do the real multi-table query? I'm assuming I have to use the field mapping editor with the DataSet - yes?
Thanks everyone for letting me vent and solve my own problem (I hope)...
|
|
|
|
|
Okay, now that I have mastered my single table report, I thought I would plunge into the multi-table report.
But I do have a couple of questions regarding the DataSet design. Do I just drag the tables onto the designer form and that's it? Do I have to worry about the relationships between the tables? Also, I do not require all the fields from all the tables. Can I eliminate some of the fields so the dataset fields more closely match the query? Does it matter one way or the other?
Thus far I just dragged the tables onto the designer and didn't do anything else and surprise surprise my report runs but it is blank. So, besides the above, is there anything else I need to worry about to get this report to run?
Again, any help is much appreciated
Thanks.
|
|
|
|
|
How do I show and hide controls. In particular I need to show and hide a picturebox, label and command button.
Thanks,
Tim
|
|
|
|
|
Use the visible property
Well.. later
|
|
|
|
|
Found the answer... Need to set the Visible property.
Thanks,
Tim
|
|
|
|
|
I need to write a program that every morning at 5am its start a verification on a table in the SQL Server, is Windows Services a good way or is there another way around ? Thank you very much for your time.
Well.. later
MCP
|
|
|
|
|
Sebastien_Lachance wrote:
I need to write a program that every morning at 5am
You can use Windows' Task Scheduler service to do this (see How To Use the AT Command to Schedule Tasks[^]).
is Windows Services a good way or is there another way around ?
I'd say creating a service is a good idea if you want to run something unattended and without desktop interaction. However keep in mind that if you create a service on your own you'll also be responsible for the scheduler logic. You'll have to decide which solution is most suitable for your requirements.
Best regards
Dennis
|
|
|
|
|
hummm i think right now the best choice i have is to create a small program, and will try to make it run with the Task Scheduler. Thank you
Well.. later
|
|
|
|
|
Hey,
I am using a PDF printer.
I am setting the "HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows" Device key to my PDF printer to set it as the default printer so that it is automatically selected when a application prints.
But some applications succesfully recognise the newly set key as the new default printer and others do not, and only see the previous default printer.
Is there another value that i need to check or set for all applications to use the newly set default printer?
Thanks for your help
Chris
|
|
|
|
|
I'm using code I found on Internet (www.TheScarms.com) to populate/update Excel data from VB.net project. When debugging I'm getting the following error:
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in PRCoverSheet.exe
Additional information: Invalid index.
The code of the part that gives the error is:
'Open the XLS file and activate the worksheet to populate:
Dim strWorkSheetName As String = "MyData"
Dim sbExcelData As System.Text.StringBuilder
Dim aWorkbook As Excel.Workbook
Dim aWorkSheet As Excel.WorksheetClass
aWorkbook = myExcel.Workbooks.Open(strExcelFile)
aWorkSheet = CType(aWorkbook.Sheets(strWorkSheetName), Excel.Worksheet)
' CType(myExcel, Excel._Application).Quit()
aWorkSheet.Activate()
The debugger highlights the following statement:
aWorkSheet = CType(aWorkbook.Sheets(strWorkSheetName), Excel.Worksheet)
What could it possibly be and how can i fix it?
Thank you all in advance
Alika
|
|
|
|
|
Is it possible to change printer settings through a VB .NET program? Ex Number of copies, duplex, custom paper type, etc
If you have some suggestions or examples that would be great, if not I will have to make do with an answer if it is possible or not.
Thanks
Mark
|
|
|
|
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbconPrintSupport.asp
Try this link, it may be not what you wanted but im pretty sure y'oull find a response there.
Well.. later
|
|
|
|
|
Hey,
I was wondering when the 'X' is clicked in the top of the application window to exit the application what is the event that fires? As i need to set values back to defaults etc.
Any help would be appreciated
chris
|
|
|
|
|
the event Closing is fired...
|
|
|
|
|
|
Hello everybody!
I have a trouble with Outlook. The following VB code
set objOLApp = CreateObject("Outlook.Application")
objOLApp.Session.AddStore("c:\temp\test.pst")
perfectly adds new store but how can I get the root folder corresponding to this newly added store? If I were sure that this file is not yet added then I could collect EntryIDs before and after operation and find the difference. But I'm not sure because of statement of work. Is there a way to establis correspondence between root folder and store file name? As far as I know Outlook GUI allows this.
Thanks in advance.
|
|
|
|
|
Can I consume a Webservice coded using ASP.NET & C# in a VisualBasic 6.0
application?
I read it can be done using Soap toolkit..but I a dont want to use it as it will be required to be installed on all the machines using that application.
How to do it without using toolKit.
Thanx
|
|
|
|
|
Save yourself the aggravation of re-writing the SOAP toolkit yourself and just use it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
How to ship framework with the package instead of asking for download from web
|
|
|
|
|
You need to download setup.exe bootstrapper form www.msdn.com.microsoft.
|
|
|
|
|
Is it possible to change the color of only certin lines in a text box? I am trying to write a cheap game for my senior project and I thought it would be cool to be able to change color of the text if I was getting hit by something to red, and have me hitting the enemy in white. If anyone has any helpful thoughts please email them to me or post them.
Thanks so much
Tommy
|
|
|
|
|
You know 'txtSample.ForeColor = vbColorRed' can change your text's color, but all lines. It's impossible to change colors of only certain lines in textbox. I have 2 ways to solve this problem (I often do):
1)I think textbox is not for displaying, it's for inputing. So you should use 2 labels: 1 for you and 1 for the enemy. When you are getting hit , your label red, enemy's label white , contrary...
2)You can use a RichTextBox:
rtbSample.SelText.ForeColor = vbColorRed
but it's not my favourite because the RichTextBox control is very complex .
I post this reply on a computer without Visual Basic installed, so that I can't test the code. If you don't like my answer or don't understand , reply me, I will find another way (I pay attention to this problem too!)
GF bos
|
|
|
|