|
You can't. In order to enable the macro code to run, the macros would already have to be enabled!
|
|
|
|
|
Hi experts!
my query is.. can we create a dynamic conncation string at run time... no matter to which database we r connecting to.. it may be SQL server, Oracle, MYSQl, ACCESS... etc.
when ever i execute my appplication... the user shud be able to choose from the available drivers.... to which database they want to make connection ... like a wizard. i am using VB 6.0.
Or is it possible that ... the wizard which Microsoft provides for connection string...cud be called directly into the application.. from which connection shud be made automatically depending upon which database does the user has selected... is there any aPI to handle this!!! the reason.. i m askin this.. is to avoid the massive chunk of code to be written! which is surely gonna hang me up in the office for next couple of weeks!
Any suggestions please...!!
thanx in advance..!
|
|
|
|
|
A connection string is nothing but a normal string of text. You need to have template strings for all the database engines you're going to support. You can find examples at http://www.connectionstrings.com[^].
After that, you'd have to write a data layer for each database engine you're supporting too. Access doesn't support the same SQL syntax that SQL Server does and Orcale has it's own flavor too. Each version of this data layer would implement an Interface that you write to provide all the functions you need.
To support all this, you wouldnt be saving yourself frmo writing a "massive chunk" of code, you'd be guaranteeing it.
|
|
|
|
|
hello there good programmers... a little help here about vb code that can display a message while in 3d environment. any idea?
to explain further. am now coding a server/client program. and my problem is when i send a message to the client program the user cant see it while in 3d environment. how do i solve this problem? is there any other solution?
thank you very much...
jigs
-- modified at 7:01 Saturday 2nd June, 2007
|
|
|
|
|
How are you sending this message ? If a 3D game is running, I'm not sure what you can hope to do, Windows will not be processing any drawing messages.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
the server program sending a message in the client in normal way. recving a string then displaying it using normal window.
the problem is, its not displaying the message in the time its arrive but instead its in the back or behind of the 3d program when the user in the workstation which have a client program is in 3d environment. the scenario should like this
server
|
|
workstation (client running in 3d environment e.g. 3d games)
>> actually the workstation with client program receiving the message and displaying it but its in the back of the 3d program. i want to make a vb program that can display message wether its in 3d program or in normal mode. its possible?
|
|
|
|
|
If it is, it would involve detecting that DirectX was being used, finding the directX surface in use and rendering to it.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
nice idea thnx, but is it possible to display a message in windowless environment? if the client program detected dx8, is it possible to dislay message in the top of the 3d program? do i need a hooking technique or it is just simple detection and display in 3d way..?
>>> ok i'll make a experiment if its possible
-- modified at 8:28 Saturday 2nd June, 2007
|
|
|
|
|
i have no idea how to detect if directX is loaded or not... o boy having troubled with this program.
-- modified at 9:40 Saturday 2nd June, 2007
|
|
|
|
|
Serialization is the process of writing the data in a class, i.e. the values of its properties - into a string that can be written to disk, or sent to an object in a client program. It's approximately the equivalent of putting data into a DBF. So what's the big deal?
|
|
|
|
|
You may want to read up on Serialization[^]. You've generalized it way too much.
Serialization converts an objects data into a trasmittable or saveable form, be it binary or text based.
|
|
|
|
|
yes , Serialization is Process of packing data , but added it encode the data pack's it so that it can be sent over wire.
Main advantage of serialization is that it ca be used to access object between different Processes over different machines.
Thanks & Wishes
Navneet Hegde
Nashik(City Of Pilgrimage)
Develop2Program & Program2Develop
|
|
|
|
|
Can Somebody please show me an example code on how to make a user login and password that will look to a database table with fields username & password for verification.
I would greatly appreciate your help.
Thanks & more power to the group....
neal
|
|
|
|
|
Is this a windows app or a web app ? Which bits are you stuck on ? Do you know any SQL ? Do you know how to access a database ? What is the database you're using ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
yes sir its in MS VB6.0 and the database is in ms access and it is in windows app.
Thank you very much for your interest on helping me...
Regards,
Neal
|
|
|
|
|
OK - VB6 is a dead language. You need to specify if you're using VB6, as people will assume .NET otherwise.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
Sir christian,Its not in .Net. Sory I'm not specific in details. But once again. Thank you very much for your concern on helping me.
May you contionue your support to all people in-need of help. God Bless!
Best regards,
Neal
|
|
|
|
|
hi neal,
takes two text box(TextBoxlogin,TextBoxpassword) and on click event of button use following code
Dim q As String
Dim oleadapter As OleDbDataAdapter
Dim mdataset As New DataSet
If TextBoxlogin.Text = "" or TextBoxpassword.Text = "" Then
MsgBox("Enter Login ID & Password ", MsgBoxStyle.Information, mdGlobal.myMessage)
TextBoxlogin.Focus()
TextBoxlogin.Text = ""
TextBoxpassword.Text = ""
Exit Sub
End If
try
q = "select * from login where username='" & TextBoxlogin.Text.Trim & "' and password='" & TextBoxpassword.Text.Trim & "';"
oleadapter = New OleDbDataAdapter(q, mdGlobal.conn)
'where mdglobal is module and conn is oledb connection object
oleadapter.Fill(mdataset) ' mdataset is dataset
If mdataset.Tables(0).Rows.Count > 0 Then
loginok = True
Me.Close()
mainform.show
Else
MsgBox("Wrong Login ID / Password ", MsgBoxStyle.Information, mdGlobal.myMessage)
TextBoxlogin.Focus()
TextBoxlogin.Text = ""
TextBoxpassword.Text = ""
End If
Catch ex as exception
msgbox (ex.message.tostring)
End Try
hope this helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
Sir Rupesh, Thank you very much evrything, this is realy a big help for me. I'm wishing you more success in life and again thank you...and may God continously Bless you!
Best regards,
Neal
|
|
|
|
|
Hey All,
Was wondering if someone could shed some light on the use of the System.Drawing.ImageFormatConverter class in VB.NET (2005).
Could someone provide an example as I'm getting no-where:
dim pBMP = new Bitmap("c:\test.bmp")
dim pCON as new System.Drawing.ImageFormatConverter()
pCON.ConvertFrom(pBMP)
...Now where to?
Any help would be appreciated.
Thanks In Advance.
Lachlan.
|
|
|
|
|
|
Thanks,
The example in the link converts file formats, where my purpose is to convert the colors in the image from 24bpp to 16bpp bitmaps.
Therefore I believe I need the ImageFormatConverter.
Cheers
Lachlan.
|
|
|
|
|
The easiest way to do this is to create a 16bpp bitmap and draw the 24 bpp bitmap onto it. You can probably also use the color matrix to do this. In fact, the way to do it is just to strip the least significant bits of the red, green and blue component of each color. That is, if you wanted to build it yourself, which you probably don't.
The ImageFormatConverter converts between file formats, as in gif, jpeg, etc. So MSDN tells me, anyhow
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
Hello frnds,
i want to show a message box in word document, when i clicked the button in word 2003.
for that purpose the method i used was :
i took the button from visual basic tool bar in word2003,then i double click a button, it shows me a visual basic editor and i wrote a code to display a message box and save the word and exit from it,
if i again open the word and click the button then nothing happens ..means no event fires..Why????????
where i am wrong ????
what should i do ?
how can i use visual basic for applciation..
plz help...regards,Koolprasasd2003
Be A Good S/W Eng... Life is swing with you..Enjoy..
|
|
|
|
|
hi KoolPrasad,
THE REASON WHY IT IS NOT DISPLAYING THAT MSGBOX WHEN U RESTART, IS U NEED TO ENABLE MACROS IN MS-WORD. ENABLE THE MACROS THEN IT WILL SURELY DISPLAY THE MSGBOX.
HOPE IT HELPS..
REGARDS
IPS
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
