Visual Basic

Crystal Report and DataBase Login

8-Dec-05 10:07

Jkkenzie wrote:
I've done Microsoft Access Programming .

Ah - that's why you're expecting to see a lot of stuff that isn't there by default.

Jkkenzie wrote:
What i dont understand in VB.net is where the table or file is?

There is no table. Unless you create one. It's called a Datagrid control, you need to drag it onto your form. Remember, there are plenty of apps in the world that don't have a table on them.

Same goes for files, if you want to read a file, you need to create the storage for the data in your app ( for example, an array of strings, or a Bitmap object, see how it's not provided because it can change ? ), and provide the way to get the data to and from a file on the HDD.

Jkkenzie wrote:
Or how is it connected to other databases for the data to be saved in a table?

You connect to databases using ADO.NET objects.

Jkkenzie wrote:
Could some one give me a sample ziped programme .

Look around you. If the Code Project VB.NET section doesn't have what you want, try google, and find some resources on a VB.NET specific site.

Christian Graus - Microsoft MVP - C++

Re: STARTING VB.NET

Jkkenzie8-Dec-05 10:13

Jkkenzie

8-Dec-05 10:13

OK. Thanks and i'll try what you've said.

Regards

Joseph

ffffffffffffffffffff

Re: STARTING VB.NET

Dave Kreskowiak8-Dec-05 11:44

Dave Kreskowiak

8-Dec-05 11:44

With all the assumptions you're carrying over from Access, it sounds like you need to start from scratch. Forget nearly everything you know about VB and start with this[^] friendly recommendation.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

dptalt8-Dec-05 9:23

dptalt

8-Dec-05 9:23

I'm using the CrystalReportViewer to view my Crystal report. At runtime the DataBase Login screen keeps coming up. How can I turn this feature off or supply it with the needed information ahead of time.

Also, I created a DataSet inside my project to hold the data for the report. My report textboxes are connected to the fields in the DataSet. But when the report runs it does not display the data. The data is in the DataSet but why doesn't the report display it?

Crystal Reports Preview

projectcode18-Dec-05 8:52

projectcode1

8-Dec-05 8:52

Hi All,

I am using subreports in my crystal reports in the main report's age header section.
The problem is I just adjusted the page header in the crystal reports and now I DON"T SEE MY DATA. I could see the data earlier. I can see the the data of the sub reports seperately but not when I want to preview it as a whole. If I check the "Show SQL query", it return the row but I cant see the data on the screen. Something goofy!!

Any ideas what went wrong?

Thanks for your help!

how to make dll

giotis828-Dec-05 2:56

8-Dec-05 2:56

I made an application with opengl and an application in VB.net and i want to make a dll to call from the VB app the opengl app and change his parameters from there..I know nothing about dlls does anyone can help me giving some steps?I try to make it in VB class library but i can't find how to call my opengl project,and how to change his parameters
I am new in programming!

Thank you...

giotis

Christian Graus8-Dec-05 10:04

8-Dec-05 10:04

giotis82 wrote:
I am new in programming!

Sounds like you're biting off too much at once.

I presume the opengl app is in C++ ? If so, your basic problem is, your OpenGL program wants to be an app, not a dll, so that it has a message pump, a window, etc. Then, your VB app is not going to be able to consume this application. The way to talk between VB.NET and C++ is probably C++/CLI. The way to do it from VB6 -> C++ is COM. COM works for VB.NET as well. But if you want a VB app and an OpenGL app, then you don't want a dll, because you're looking for two applications, and not an application that consumes a class library. In this case, WM_COPYDATA is the easiest way to send data between two applications ( google it ).

Christian Graus - Microsoft MVP - C++

giotis828-Dec-05 20:53

8-Dec-05 20:53

Thanks for ur reply,yes the opengl app is in C++ and i use glui libraries!I have 2 more questions, with WM_COPYDATA can i pass parameters in my opengl app, and change my variables values?
And the other question is that i try to copy my opengl code with his libraries to a "class library" app but there no response it stuck in all opengl libraries (glut,glu,glui, etc.). Is there any way to remake my opengl program as dll?

Thanks for ur response!

giotis

Christian Graus9-Dec-05 10:35

9-Dec-05 10:35

giotis82 wrote:
WM_COPYDATA can i pass parameters in my opengl app, and change my variables values?

Yes, and no. WM_COPYDATA is a message you send and recieve. You need to write code on both ends, to send the data, and to parse and use it on the other end. So yes, you can send values to the other application, and use them to set variables. But no, you can't send a message and have it change values without you writing the code to recieve the message on the other end.

giotis82 wrote:
Is there any way to remake my opengl program as dll?

Like I said, if it's a dll, then it's NOT a program, it does not have a window, nor can it be run by itself.

I think you should instead use DirectX in VB.NET, if that's an option.

Christian Graus - Microsoft MVP - C++

giotis8211-Dec-05 21:19

11-Dec-05 21:19

Thanks one more time for ur reply!That's mean that i must stop trying create a dll!Well i try to find an example using WM_COPYDATA but i didn't find something that could help me...Can u send me a simply code to understand it?That will be very helpful for me, as u already know the opengl window created in the "main" function so how it will be my WM_COPYDATA? As i think of what u said i must have a "send" and "receive" to each program.
If u have a moment please send me a simply code in my mail "giotis82@mycosmos.gr" or just type it over here!!

Thanks u very much for ur time!!

giotis

Christian Graus12-Dec-05 10:54

12-Dec-05 10:54

http://www.google.com.au/search?hl=en&q=WM_COPYDATA+VB.NET&meta=[^]

Christian Graus - Microsoft MVP - C++

giotis8212-Dec-05 22:04

12-Dec-05 22:04

Well i call my opengl exe with "CWinApp: Shell("ExePath")" it work properly!
As i thought the steps will be:
1. the opengl with the Sendmessage will send his variables
2. the VB will receive them
3. the VB will send the new values
4. the opengl will receive them and change each one
Am i right?
One more question:I have to do my variables global and place the WM_COPYDATA at the end of the main function?
Thanks for ur time, u r very helpfull..........

giotis

giotis828-Dec-05 21:18

8-Dec-05 21:18

I have to mention that my problem is that: if the "VB.NET" user press a button it will appear my opengl form and with a properties menu the user can change some of the grafic sizes.

giotis

uktrips0079-Dec-05 19:18

Problem with insert command

9-Dec-05 19:18

do you want dll to be created in vb.net?
if yes then while selecting new project go for class library
write ur function there, and save it then built it.it will create dll file inside bin directory of ur project folder.

try to be the best... whereever you go,

fitz2345678-Dec-05 2:13

fitz234567

8-Dec-05 2:13

Hi All,

Hope someone can help me on this I have written an insert command in VB for a connection to a MySQL database here is the code -

cmdSelect = cnn.CreateCommand
cmdSelect.CommandText = "SELECT Transaction_No, User_ID, Expiry_Date, " & _
"Expiry_Date_Hex, Product_ID, Update_Date, Key_Serial_No, Developer_ID, " & _
"Locking_Code, Unlock_Code FROM KeyIssueDetails"
mda.SelectCommand = cmdSelect

cmdInsert = cnn.CreateCommand
cmdInsert.CommandText = "INSERT INTO KeyIssueDetails(Transaction_No, User_ID, Expiry_Date, Expiry_Date_Hex, Product_ID, Update_Date, Key_Serial_No, Developer_ID, Locking_Code, Unlock_Code) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Transaction_No", Microsoft.Data.Odbc.OdbcType.Int, 0, "Transaction_No"))
prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("User_ID", Microsoft.Data.Odbc.OdbcType.VarChar, 50, "User_ID"))
prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Expiry_Date", Microsoft.Data.Odbc.OdbcType.DateTime, 0, "Expiry_Date"))
prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Expiry_Date_Hex", Microsoft.Data.Odbc.OdbcType.VarChar, 50, "Expiry_Date_Hex"))
prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Product_ID", Microsoft.Data.Odbc.OdbcType.VarChar, 50, "Product_ID"))
prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Update_Date", Microsoft.Data.Odbc.OdbcType.DateTime, 0, "Update_Date"))
prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Key_Serial_No", Microsoft.Data.Odbc.OdbcType.VarChar, 50, "Key_Serial_No"))
prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Developer_ID", Microsoft.Data.Odbc.OdbcType.VarChar, 50, "Developer_ID"))
prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Locking_Code", Microsoft.Data.Odbc.OdbcType.VarChar, 50, "Locking_Code"))
prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Unlock_Code", Microsoft.Data.Odbc.OdbcType.VarChar, 50, "Unlock_Code"))
'
mda.InsertCommand = cmdInsert
prm.SourceVersion = DataRowVersion.Original
prm.Direction = ParameterDirection.Output
mda.Fill(mds, "KeyIssueDetails")
DGMain.DataSource = mds
DGMain.DataMember = "KeyIssueDetails"

My Problem is that the command works fine bar the last parameter. "Unlock_Code" comes back as NULL even though the dataset accepts the data I enter. I am fairly new to this so I may just be missing something obvious but any help would be great I can't figure out where I went wrong. D'Oh! | :doh:

dll registration problem

uktrips0077-Dec-05 21:47

7-Dec-05 21:47

hi dear
I m facing a problem.I have devlpoped a dll file in vb.net.now I want to register it.while registration with regsrv32 it gave me message as follows.

"dll file was loaded, but dllRegisterServer entry point was not found.
file can't b registered"

I don'tknow how to solve this error.

please help me......

Sleepy | :zzz:

thank you

be the best...

registering dll problem

uktrips0077-Dec-05 21:46

7-Dec-05 21:46

thank you

be the best...

Gerben Jongerius7-Dec-05 22:08

Gerben Jongerius

7-Dec-05 22:08

For as far as I know it is impossible to register .Net dll's with RegSvr32, its not supported. This should not be a problem when you only use this DLL in other .net projects.

However if you want other projects to use the DLL you can try regasm.exe which allows COM clients to create .NET Framework classes transparently. For more information on this I advice you to read this article on the tool.

uktrips0077-Dec-05 22:15

7-Dec-05 22:15

Thanks for ur prompt answer.But I have to use it in ASP coding.and I think without having register it I couldn't use it in asp coding.if u know the way by which i can use this dll in asp coding without registering it tell me pls.and regasm.exe is not there in window xp as it shows error:"window can't find regasm.exe"

Help me pls........... Confused | :confused:

be the best...

Gerben Jongerius7-Dec-05 22:48

Gerben Jongerius

7-Dec-05 22:48

I take it the .Net framework is installed. This should include the regasm.exe program in its root directory.

The location is usuallay 'C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322', though the version number could vary pending on the version you are using.

uktrips0077-Dec-05 23:32

7-Dec-05 23:32

how can i use this.I've got regasm.exe.if i double click it just flash once on screen and become unvisible.using command prompt i tryed but same result, tell me the way i should Use.

Thanks n regards
Uttam kumar D'Oh! | :doh:

be the best...

Gerben Jongerius8-Dec-05 2:17

Gerben Jongerius

8-Dec-05 2:17

Its easy, just open your command prompt and type:

Register: %windir%\Microsoft.Net\Framework\v1.1.4322\RegAsm.exe <library>
Unregister: %windir%\Microsoft.Net\Framework\v1.1.4322\RegAsm.exe /unregister <library>

Replace <library> with the name of the DLL (include the full path)

uktrips0079-Dec-05 0:42

9-Dec-05 0:42

Thank you Gerben Jongerious!

I got my Answer.

Thanks a lot.

Uttam Kumar;)

try to be the best... whereever you go,

uktrips0079-Dec-05 2:24