|
Public crxApp As CRAXDRT.Application
Public crxReport As CRAXDRT.Report
Public crxDataBase As CRAXDRT.Database
Public crxTable As CRAXDRT.DatabaseTable
Public crxTables As CRAXDRT.DatabaseTables
Public strSelectionfrm As String
Public strCRSourcePath As String
Private Sub frmCrystalReport_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.MdiParent = frmMain
crxApp = New CRAXDRT.Application
crxReport = crxApp.OpenReport(strCRSourcePath, 0)
crxReport.RecordSelectionFormula = strSelectionfrm
crxDataBase = crxReport.Database
crxTables = crxDataBase.Tables
For Each crxTable In crxTables
crxTable.Location = DataSource
crxTable.SetLogOnInfo("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & reportPath, "myDatabase.mdb", "", "password")
Next crxTable
'Error occur here! i dont know why im access denied.. but if i will ommitt the .SetReportVariableValue() then it works just fine without committing access denied but then i have to set some variable i've declare inside the report..
crxReport.SetReportVariableValue("varEduc", "Hello Crystal World")
AxCRViewer1.ReportSource = crxReport
AxCRViewer1.ViewReport()
crxDataBase = Nothing
crxTable = Nothing
crxTables = Nothing
crxReport = Nothing
crxApp = Nothing
Catch ex As Exception
MsgBox(ex.ToString())
Finally
End Try
End Sub
***************
crxReport.SetReportVariableValue("varEduc", "Hello Crystal World")
the varEduc is already declare inside the report which means it is existing variable inside report..
is anybody there who have a good idea or solutions about this??? please??? 
Anybody there Please help me with this headache... 
-- modified at 3:00 Wednesday 26th September, 2007
|
|
|
|
|
Hi all,
I want to connect to an Excel File in VB.NEt could anyone help me out
Thanks in Advance..
|
|
|
|
|
hi vidya
here's the code
Public Sub excelconn(ByVal exlpath As String)<br />
exconn = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; " & "data source='" & exlpath & "'; Extended Properties=Excel 8.0;")<br />
exconn.Open()<br />
Dim da As OleDbDataAdapter<br />
da = New OleDbDataAdapter("select * from [Sheet1$]", exconn)<br />
da.Fill(ds)<br />
End Sub
let me know if it works for you
help everyone
|
|
|
|
|
Thank u so much
Its working fine
|
|
|
|
|
All our winform apps are deployed using clickonce - works fine.
We have a central authentication and autorisation app and the logon DLL is deployed with each app.
We are building a single logon app to access all the apps.
I can locate the "application reference" in C:\Program Files\Group\......."
Using the App ref
Dim sApp As String = mvApp.Shortcut
System.Diagnostics.Process.Start(sApp)
I get the following error
System.ComponentModel.Win32Exception was unhandled
ErrorCode=-2147467259
Message="The system cannot find the file specified"
Source="System"
Does anyone have a suggestion how to launch a clickonce app from another VB App
|
|
|
|
|
The Application Reference resides under
C:\Documents and Settings\username\Start Menu\Programs\Group Risk
|
|
|
|
|
The appref has an extension that windows does not display (.appref-ms)- I had to use dos to get the extension - how quaint.
C:\Documents and Settings\username\Start Menu\Programs\Group Risk\StressMastr.appref-ms
System.Diagnostics.Process.Start(sApp) now launches the program successfully. Now to include a command line string!
|
|
|
|
|
Hi,
I have a project and I have designed the form, but I am not sure of my code. Can somebody help me plz?
This is the question of my project:
A local car rental company would like a computer application to calculate and display rental charges for each renter and summary rental charges for the day. The company charges AED60 per day plus AED0.8 for each kilometre driven by the renter. In this assignment, you are expected to use structured programming methodology to develop a user-friendly, high quality VB.NET windows system that will handle the following:
1. For each renter:
1.1the application must be enable the user to input the renter’s name, beginning odometer reading, ending odometer reading, and the number of days the car was used. The application will check to ensure that the name of the customer is not blank, ending odometer reading is greater than the beginning odometer reading, and that the beginning odometer reading and number of usage days are greater than zero – appropriate error messages must be displayed if incorrect data is entered by the user.
1.2when the compute and display button is clicked, the application upon ensuring that correct data has been entered, will calculate and display in appropriate controls, the charge for kilometres driven, the charge for the usage of the car, and the rental charge (sum of kilometre and usage charges). After displaying charge details for each renter, the system will update and display summary data (totals for kilometres, usage and rental charges).
2.Prepare for next renter’s charges or cancel the current renter by having a button for clearing all user entered data and computed details – but not the summary details. The summary details must always reflect the latest totals, and they are not to be cleared while the program is running.
|
|
|
|
|
*Muskan* wrote: Can someone give me the code of my project?
erm let me think about it... NO
Please read the forum guidelines.
You always pass failure on the way to success.
|
|
|
|
|
*Muskan* wrote: Can someone give me the code of my project?
This is a homework assignment. Treat this board as if your prof is reading it. Asking us to just handover the code is cheating.
|
|
|
|
|
Dave Kreskowiak wrote: Treat this board as if your prof is reading it.
I sure wouldn't mind having his professor's email address and drop them a line about the cheat 
"Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus
|
|
|
|
|
Seriously, assuming you manage to pass your course, when you get a job, did you hope to post here to get your work done for you then, too ?
You need to do your own homework, but, if you try and get stuck on specific things, we're more than happy to help you.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
We only assist when you have problems with your code. What u are asking for is for this forum to fix u up with a whole project! Wake up and work!
---------------------------
Baniani mbaya, kiatu chake dawa.
Regards,
Hesbon Ongira
Nairobi, Kenya.
|
|
|
|
|
It smell like homework, even through the internet i can smell it 
Well, the first, start working, because sure you don't have all the time.
Drill down the assignment in things that you need, try to create what you can, and than with specific questions we will help you. But the meaning of all is learn to program in VB.NET.
Good luck, and I hope to see you here with questions and with the progress of your assignment.
|
|
|
|
|
ESTANNY wrote: It smell like homework
Yes, it reeks of homework...
"Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus
|
|
|
|
|
To get help you need to show that you have put significant effort into building your code ie you must have code of your own, then people can comment on your effort. You cant ask people to do all your work. This will not be taken kindly by the other hard working coders out there. This sort of practice is generally frown upon
Future Coding
|
|
|
|
|
I'm sure this has been asked ad nauseum, but I have MTA thread from which I need to write to a textbox on a different form.
Is there any simple, or at least doable, answer?
Thanks
|
|
|
|
|
|
Right, I understand the idea of the delegate and I know how to call one from a backgroundworker or from a STA thread.
My problem is that the code that I'm using (third-party) is running under an MTA (multiple apartment) thread.
I cannot seem to get the same delegates that work just fine from a backgroundworker to work under the MTA thread.
It's my impression that the MTA threading is a different animal entirely...that the GUI is based on calls from STA threads.
Am I wrong about that?
|
|
|
|
|
cstrader232 wrote: It's my impression that the MTA threading is a different animal entirely...that the GUI is based on calls from STA threads.
Am I wrong about that?
Nope. You're not. I'm just too tired and missed that part of your post.
Hmmm...
|
|
|
|
|
Wow, have I really stumped DK? First time on that for me! Makes me wonder whether this is even possible.
|
|
|
|
|
Stumped?? Hardly. I just need to do the research and come up with a testable solution. Time is a bit short right now, so this takes a while.
|
|
|
|
|
Well, it does work and without anything "off the wall". This is the test case I put together under the .NET Framework 2.0. The only controls are a Form, TextBox, and Button.
Imports System.Threading
Public Class Form1
Private Delegate Sub UpdateTextBoxDelegate(ByVal Message As String)
Private Sub UpdateTextBox(ByVal Message As String)
TextBox1.AppendText(message & Environment.NewLine)
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles Button1.Click
For x As Integer = 1 To 20
Dim t As New Thread(AddressOf GenerateData)
t.SetApartmentState(ApartmentState.MTA)
t.Start()
Next
End Sub
Private Sub GenerateData()
Dim callback As New UpdateTextBoxDelegate(AddressOf UpdateTextBox)
For x As Integer = 1 To 10
TextBox1.Invoke(callback, New Object() { _
String.Format("Thread Id: {0} Apartment: {1} Message: {2}", _
Thread.CurrentThread.ManagedThreadId, _
Thread.CurrentThread.GetApartmentState().ToString(), _
x)})
Next
End Sub
End Class
Sorry, I just went back and found out you're using a third party component. The short version of apartments is COM components written in STA mode can only have one thread call their methods at any one time, the thread that created the component. In MTA (sometimes called "free threading", multiple calls to the component's methods from any thread(s) are possible with complete safety.
Since most of Windows Forms and the controls it supplies wrap the existing COM controls, most of which are written in STA mode, the default apartment mode for a Windows Forms app is STA. It's possible to change this, but not a good idea because the COM controls backing Windows Forms requires an STA environment to run.
Calling a method of a control in STA can be done from any apartment mode, so long as the call is marshaled to the thread that created the control. It matters more about the apartment your code is calling, than the apartment the call is comming from. I'd be willing to bet that there's something in this third party component that is not marshalling the call back to STA correctly.
|
|
|
|
|
OK, thanks... I think you are on to something there. The 3rd party code is not allowing me to make my callback properly. I'll try to keep checking into this. Thank you so very much for your time....really appreciated.
|
|
|
|
|
Thank You, that is exactly what I need to be using.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
