Visual Basic

Crystal Report Deployment

5-Dec-07 5:04

Sure. Exactly how you do that depends entirely on where you're code is going to be running and how your ISP exposes the MySql server to it.

You can get the MySql data providers classes from here[^].

You can also find a pretty good tutorial on using it here[^].

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

poonams5-Dec-07 1:19

poonams

5-Dec-07 1:19

hi all

I am using vs.net 2003 with access.I Usng <b>Crystal Reports </b>in my project.I made my setup but i don't know which additional files I have to add for crystal repots.Can anyone helpme.When I am Installing app to client machine it get error "KeycodeV32.dll not registerd".Is the probelm is due to setup ???

Plz give me full details how to include crystal reports in setup.
Its urgent.

thanks in advance

poonam

Re: Crystal Report Deployment

Ujjaval Modi5-Dec-07 2:12

Ujjaval Modi

5-Dec-07 2:12

Hi,

While creating the setup of your application, right click on Application Folder and Add -> Assembly to the Folder.
It will open .NET assemblies window. Select all the crystal-report related assemblies.

When u will build the setup project u will obtain a installer for crystal reports. First install this setup and then install your application.
This should work.

Regards,
Ujjaval Modi

Re: Crystal Report Deployment

poonams11-Dec-07 18:40

poonams

11-Dec-07 18:40

hi
the error was solved.But I have new problm.When I am deploying the project on client machine all things work good.Only crystal report has a problem.It gives error "Load Report Failed".I wrote the code on CRV

[code]

crv.ReportSource = "..\Reports\enq.rpt"
[/code]
hw can i solve this type of prblm.

poonam

Re: Crystal Report Deployment

Ujjaval Modi12-Dec-07 1:03

Ujjaval Modi

12-Dec-07 1:03

Hi,

Even I am not much good at crystal reports but even I faced same problem in my application for crystal reports and I learnt to add its Installer, so I helped you out in it.

Regarding this problem, your Logon to database is failing, thts why your report fails to load.

Try this code :

<br />
<br />
dim rptObject as new ReportObject <br />
rptObject.SetDatabaseLogon(username,password)<br />
rptObject.SetDataSource(dataTableObject)<br />
crv.ReportSource = rptObject <br />
<br />

Here rptObject is an object of your "enq.rpt" report.

Regards,

Ujjaval Modi Smile | :)

Manpower moves wrenches, horsepower moves cars, and the power of the mind moves the world.

Saving data from gridvies -> dataset -> database

zwaailicht5-Dec-07 0:09

zwaailicht

5-Dec-07 0:09

Hello All,

I have an application, in which I use also DataGridViews to display data. When the user modifies (delete, modify or add) a column he cann save the data by clicking on a button.

Code :

Private Sub btnToeveoegenBewolkingLicht(ByVal sender As System.Object, ByVal e As

System.EventArgs) Handles Button1.Click
Try
Me.BewolkingBindingSource.EndEdit()
Catch ex As Exception
MessageBox.Show(ex.Message, "Fout bij schrijven data")
End Try
Me.SaveDataBewolking()
Try
Me.LichtBindingSource.EndEdit()
Catch ex As Exception
MessageBox.Show(ex.Message, "Fout bij schrijven data")
End Try
Me.SaveDataLicht()
'ResetControls()
End Sub

In SaveDataBewoling() I check if there are any changes and when so the tableadaper is updated.

Code :

Friend Function SaveDataBewolking() As Integer
'Hier IsUpdating
Dim rowsSaved As Integer = 0
Try
If Me.CarpDataSet.HasChanges Then
rowsSaved = BewolkingTableAdapter.Update(CarpDataSet.Bewolking)
End If
Catch ex As Exception

End Try
Return rowsSaved
End Function

Everything seems to be working OK, but ...... there is no data saved in the files. The new/mod data cann bee seen in the gridview, but the data is not being written to the database.

Maybe one of you cann help me solving this problem. I must be overlooking something but what ?!

Thnxs

Re: Saving data from gridvies -> dataset -> database

H.A.Faheem5-Dec-07 0:45

H.A.Faheem

5-Dec-07 0:45

Hello
please can you tell me how you are adding rows in datagrid because i have problem to add the data into the rows every time rows is inserted on to the top index 0 and data is not displayed

Re: Saving data from gridvies -> dataset -> database

Dave Kreskowiak5-Dec-07 4:58

Re: Saving data from gridvies -> dataset -> database

5-Dec-07 4:58

Using the debugger, step through the code in the SaveData... methods, line-by-line. Check to make sure that your If statement with the HasChanges check returns what you think it does. If HasChanges returns false, then you can get the symptoms you're describing.

When you write code, you can not assume you know that every line is doing. You have to verify that each line is behaving like it should, even if you think you know what it's doing.

If HasChanges works, step through the code in the TableAdapters Update method. It's possible that the code doing the update is wrong somehow.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

zwaailicht5-Dec-07 7:33

zwaailicht

5-Dec-07 7:33

Hi Dave

Thnxs for your reply.
I am sertain that HasChanges=True. The statement RowsSaved returns the number of rows that have changed, deleted or inserted.

Maybe a foolish question, but the TableAdapter.Update statement, does it directly execute the update of the database?

In my dataset i have an sql-statement that has generated automatically the needed statements for update, inserting etc ....

Thanks
Hans

Re: Saving data from gridvies -> dataset -> database

Dave Kreskowiak5-Dec-07 7:55

Re: Saving data from gridvies -> dataset -> database

5-Dec-07 7:55

zwaailicht wrote:
Maybe a foolish question, but the TableAdapter.Update statement, does it directly execute the update of the database?

Yes, it does.

zwaailicht wrote:
In my dataset i have an sql-statement that has generated automatically the needed statements for update, inserting etc

Did it autogenerate the SELECT command, or all of the commands?? Does your database table have a Primary Key?? If not, then you've got a problem where no changes can be made to the database.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

zwaailicht5-Dec-07 11:34

zwaailicht

5-Dec-07 11:34

Hi Dave,

All the statements auto autogenerate (select, update, delete, insert).
And Yes each file as an unique key.

Greet
Hans

installing merge modules and windows services

Mbire4-Dec-07 23:34

Mbire

4-Dec-07 23:34

Hi guys, how do I install an added merge module in my setup project (vb 2005)? I have 2 merge modules the other one is a windows service, how can i register (installutil service.exe) and start the automatic service soon after installation without the user having to do the manual DOS staff(i mean going to the command prompt and typing ....\installutil ...\service.exe and restarting the machine or having to go to the services list and starting it there)?

thanks in advance

Re: installing merge modules and windows services

Dave Kreskowiak5-Dec-07 4:34

5-Dec-07 4:34

Override the Commit method of your Installer class and, in that code, use the ServiceController class to start your service.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

What is worng ?

~V~4-Dec-07 23:16

~V~

4-Dec-07 23:16

Hi all,

I m using datatable.compute method in my application but it not works properly.

In my data table there is feild run (value are 99 and 100).

<br />
 Dim datatable As New DataTable<br />
            datatable = mydataset.table(0)<br />
<br />
            minimum_run = 0<br />
            If Not (datatable.Rows.Count = 0) Then<br />
                minimum_run = Val(datatable.Compute("MIN(run)", ""))<br />
            End If<br />

It gives minimun_run is 100

I don't know what's wrong with my code,Can anyone tell where i m wrong?

Thanks with anticipaton

John_Adams5-Dec-07 3:42

John_Adams

5-Dec-07 3:42

Hi,

Please try the following code and if this helps.

Dim datatable As New DataTable
datatable = mydataset.table(0)

Dim minimum_run as Integer = 0

If Not (datatable.Rows.Count = 0) Then
minimum_run = CType(datatable.Compute("MIN(run)", ""), Integer)
End If

I hope this would be helpful.

Regards,
John Adams
ComponentOne LLC

Guffa5-Dec-07 7:59

Guffa

5-Dec-07 7:59

John_Adams wrote:
minimum_run = CType(datatable.Compute("MIN(run)", ""), Integer)

That would change the type of the result, but it doesn't change how the values in the data table are compared.

Experience is the sum of all the mistakes you have done.

Dave Kreskowiak5-Dec-07 4:18

5-Dec-07 4:18

The first two lines of your code should read:

Dim dataTable As DataTable = mydataset.Tables(0)

What your original code did was create a new instance of a DataTable object, then immediately abandon it and point the datatable variable at an already existing instance of another DataTable object.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Guffa5-Dec-07 7:53

Guffa

5-Dec-07 7:53

Your data in the table is text, not numbers. The string value "100" is smaller than "99", so the result that you get is correct.

If you want to compare the values numerically, you have to change the data type in the data table.

Experience is the sum of all the mistakes you have done.

~V~6-Dec-07 18:27

~V~

6-Dec-07 18:27

Thanks to all for having look at my post and reply.

Now i have understood the problem(The data type was string and have to convert in integer)

Thanks once again Rose | [Rose]

Urgent rpely

pavanteja4-Dec-07 22:23

pavanteja

4-Dec-07 22:23

hai

I have created a Main Form in vb.net(windows application) in that main form i have 4 Link buttons like Register,QuoteReq form etc.. when i click the register Link that will go to the Register form..the code wt i used there is
Dim obj as New RegForm
obj.show()
wen i run it is going to the regform but that is opening in a seperate window...For every click a seperate window is opening..i want the new form in the same window only....can any one help....

H.A.Faheem4-Dec-07 22:42

H.A.Faheem

4-Dec-07 22:42

you want to open the form in mdi form or you want to open just new form

pavanteja4-Dec-07 22:50

pavanteja

4-Dec-07 22:50

In the same window a seperate form has to open..

suppose in my Form1 i have Register, QuoteReq,PaymentForm like that links are there. when i click Register link the page has to be redirected to Register form which is a new one.... I want the new form to be open in the same window ...The design for all the forms are same... only controls are different...

Dave Kreskowiak5-Dec-07 4:00

5-Dec-07 4:00

Then you do what you are already doing, though you have to Hide the form that launched this new form. Something like:

Dim newForm As RegisterForm
Me.Hide()
newForm.Show()

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007