|
Saving the image in your database isn't recommended.
It will only make the database grow fast.
Better way would be to save the path to the image.
If you have a multi-user environment (with network) you'll best copy the image to a network share and save the network share path in the database.
Be sure to use the correct name of the network share, so: '\\servername\sharename\...' and NOT 'Z:\'
In the last case Z: is a network drive pointing to: '\\servername\sharename\'
If you use that ALL your users need to have the same Z: pointing tot the sharename and it can never change, so using the full path (\\servername\sharenama\...') is safer.
If you would still like to actually store the image in the database, google gives you plenty of help:
goolge your friend[^]
|
|
|
|
|
I am making a costing software for a pharmaceutical company in VB6.The software has following details in it.
DataBase: Access (It includes following tables)
01. MatMaster (Material Master)
02. ProMaster (Product Master)
03. ForMaster (Formula Master)
Now i want to connect formula master with product master and material master, can anyone help me.(Formula Master includes a unique code which related to Product Master & Material Master) - Frankly speaking it just like making a "Invoice Software".
I also want to know which grid control should i use because i have to insert data as well as i have view it simultaneously.
thanks in advance.
|
|
|
|
|
you can use Datagrid or Flexgrid in VB for your issue.
|
|
|
|
|
The people who will tell you, that VB6 is obsolete and that it's a bad idea to write a new application with such old tools, will be here in a minute. "I love deadlines. I like the whooshing sound they make as they fly by." (DNA)
|
|
|
|
|
This is precisely why Banks and Financial Institutions use it
|
|
|
|
|
sohil masani wrote: VB6
If this is not a legacy project DON'T use it.
It's bad, and even microsoft doesn't support it anymore.
sohil masani wrote: DataBase: Access
Why? sql-express is free, faster and more reliable.
sohil masani wrote: (Formula Master includes a unique code which related to Product Master & Material Master
You answered your own question, well at least provided a answer since you haven't given us much to go on.
Use SQL JOINS (INNER JOIN / LEFT OUTER JOIN / RIGHT OUTER JOIN / ... ) (do some research if you don't know them)
sohil masani wrote: I also want to know which grid control should i use because i have to insert data as well as i have view it simultaneously.
No matter what grid you'll use you will still have to write the code.
|
|
|
|
|
I am trying to build a network chat program. I know this has been done a million times in a million different ways usually by beginner programmers but bear with me.
Basically the issue i'm having is that I want to create one application (kept as an executable in a shared location) to receive messages in the form of strings from each chat application on workers computers. In this way it will work as a micro server receiving messages and distributing them into a readable form for all users. I'm doing it this way because I want the messages received to be displayed in order and there will be several users at once. This is important to the functionality.
So my question is this. How do you send a string from one application and how do you make the other application receive or do something with it?The ANZAC
|
|
|
|
|
Isn't that the concept behind WCF? (Have never used it myself). This may clarify things MSDN[^] I don't speak Idiot - please talk slowly and clearly
'This space for rent'
Driven to the arms of Heineken by the wife
|
|
|
|
|
I haven't used it and I'm not really keen to. Just trying to look for a quick and dirty solution. If it is effective i'll work up a more efficient application later. For now i just want to use technologies i am familiar with.
|
|
|
|
|
Maybe you could use this?
FileSystemWatcher[^]I don't speak Idiot - please talk slowly and clearly
'This space for rent'
Driven to the arms of Heineken by the wife
|
|
|
|
|
Couldn't your service set up an xml file for each user on the server. Then the service just needs to poll for updates to the xml file, which can be updated by the clients.
|
|
|
|
|
The ANZAC wrote: So my question is this. How do you send a string from one application and how do you make the other application receive or do something with it?
Perhaps you can modify the example of the TcpListener [^] class to suit your needs I are Troll
|
|
|
|
|
Thanks in Regards,
Needs PDF ebook on Vb.net and XMLBest Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
You should type your question into Google before posting it here,
Look what I found: free computer books[^]I don't speak Idiot - please talk slowly and clearly
'This space for rent'
Driven to the arms of Heineken by the wife
|
|
|
|
|
I am trying to create a volume controller application.
Private Declare Ansi Function waveOutSetVolume Lib "Winmm" (ByVal wDeviceID As Integer, ByVal dwVolume As Long) As Integer
waveOutSetVolume(0, 0) -----------> I noticed that this statement does not mute the speaker.
Can you explain why?
|
|
|
|
|
|
Andy_L_J wrote: waveOutSetVolume(0, &H0000)
How is that different from waveOutSetVolume(0, 0) ?txtspeak is the realm of 9 year old children, not developers. Christian Graus
|
|
|
|
|
I get confused with this stuff...never have to use these api's
dwVolume For the waveOutSetVloume function, this parameter specifies
the new volume setting. For the waveOutGetVolume
function, it specifies a far pointer to a location that will be
filled with the current volume setting.
The low-order word contains the left-channel volume setting,
and the high-order word contains the right-channel volume
setting.
A value of &HFFFF represents full volume, and a value of
&H0000 represents no volume.
If a device does not support both left and right volume
control, the low-order word of dwVolume specifies the volume
level, and the high-order word is ignored.
The example in the link explains.
To paraphrase, you must force the logical operation to use a four-byte Long Integer rather than a two-byte IntegerI don't speak Idiot - please talk slowly and clearly
'This space for rent'
Driven to the arms of Heineken by the wife
|
|
|
|
|
Andy_L_J wrote: To paraphrase, you must force the logical operation to use a four-byte Long Integer rather than a two-byte Integer
Except that &H0000 is 16-bits, i.e. two bytes, not four.txtspeak is the realm of 9 year old children, not developers. Christian Graus
|
|
|
|
|
Which one is the best for oracle server? System.Data.OleDb(.Net Faramework Data provider for ole db) or System.Data.OracleClient(.Net Faramework Data provider for Oralce)?
i'm using vb.net8
Public Shared DB_Connection As New OleDbConnection, DB_Command As New OleDbCommand
Or
Public Shared DB_Connection As New OracleConnection, DB_Command As New OracleCommand
I have creted a class ORACLE_SQL.vb for some basic oparation(DDL,DML) in oracle server. 3 pc are connected to a single database server. Both '.Net Faramework Data provider for ole db' and '.Net Faramework Data provider for Oralce' works replacing (swaping) the above Declarations and few more modification.
But i don't know which is the best. Can u plz tell me about the different between '.Net Faramework Data provider for ole db' and '.Net Faramework Data provider for Oralce'?
Thanks for reading my Q .
Here is some code of ORACLE_SQL.vb class:<br />
<br />
Public Sub New()<br />
If DB_Connection.State <> ConnectionState.Open Then<br />
Dim CONNECTION_STRING As String = ""<br />
'NewTec_Connection provides a default security for my app<br />
Dim NC As New NewTec_Connection<br />
CONNECTION_STRING = "Server=" & NC.ServerName & ";Uid=" & NC.UserName & ";Pwd=" & NC.Password<br />
Try<br />
DB_Connection = New OracleConnection(CONNECTION_STRING)<br />
DB_Connection.Open()<br />
'Create a transaction point<br />
BeginTransaction()<br />
Catch ex As Exception<br />
MsgBox("Can't use New() without having connection with 'NewTec' Server! Try New($) or New($,$,$) constructor.", MsgBoxStyle.Critical)<br />
Throw ex<br />
End Try<br />
'different types connections for oledb 'CONNECTION_STRING = "Provider=OraOLEDB.Oracle.1;Password=mypw;Persist Security Info=True;User ID=myname;Data Source=myserver" 'mdb'= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & FileName 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Desktop\DDLTEST.mdb;Persist Security Info=True;Jet OLEDB:Database Password=asd 'pw access="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Desktop\pwdb.mdb;Persist Security Info=True;Jet OLEDB:Database Password=***" 'ms sql=Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=iZMA\SQLEXPRESS 'CONNECTION_STRING = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=iZMA\SQLEXPRESS" 'DB_Connection = New OleDbConnection(CONNECTION_STRING) 'DB_Connection.Open()<br />
End If<br />
End Sub<br />
<br />
''' <summary><br />
''' Connect to oracle.<br />
''' </summary><br />
''' <param name="CONNECTION_STRING">set CONNECTION_STRING Like 'Server=giit;Uid=iZMA;Pwd=***' if using oracle provider. Otherwise for oledb 'CONNECTION_STRING = "Provider=OraOLEDB.Oracle.1;Password=mypw;Persist Security Info=True;User ID=myname;Data Source=myserver"</param><br />
''' <remarks></remarks><br />
<br />
Public Sub New(ByVal CONNECTION_STRING As String)<br />
If DB_Connection.State <> ConnectionState.Open Then<br />
DB_Connection = New OracleConnection(CONNECTION_STRING)<br />
DB_Connection.Open()<br />
BeginTransaction()' UF<br />
End If<br />
End Sub<br />
<br />
Sub New(ByVal ServerName As String, ByVal UserName As String, ByVal Password As String)<br />
Dim CONNECTION_STRING As String = "Server=" & ServerName & ";Uid=" & UserName & ";Pwd=" & Password<br />
If DB_Connection.State <> ConnectionState.Open Then<br />
DB_Connection = New OracleConnection(CONNECTION_STRING)<br />
DB_Connection.Open()<br />
BeginTransaction()<br />
End If<br />
End Sub<br />
<br />
'Execute<br />
''' <summary><br />
''' Not for select. For Insert, update, delete Statment.<br />
''' </summary><br />
''' <param name="SQL_Command"></param><br />
''' <returns></returns><br />
''' <remarks></remarks><br />
<br />
Function Execute(ByVal SQL_Command As String) As Integer<br />
Dim AffectedRow As Integer<br />
DB_Command.CommandText = SQL_Command<br />
AffectedRow = DB_Command.ExecuteNonQuery()<br />
RequireCommit = True<br />
Return AffectedRow<br />
End Function<br />
<br />
'''''''''''''''''*************************************
|
|
|
|
|
The Oracle provide is specifically written for interaction with Oracle databases (likewise the SqlClient is specifically from MS SQL Server databases) and therefore would provide better performance, but would limit your program to work purely with Oracle.
The OleDb is a more generic interface with would mean that you could use pritty much any SQL compatible database system such as Oracle, SQL Server MS Access, MySQL etc as your back-end database provided you limit your interact with the database to pure ISO SQL command.Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Thanks To: Steve Jowett
It’s a dedicated class for oracle server. So other databases (MySQL, MS SQL or MS Access) are not considered while build-up it.
I’m pleased for your advice but I can’t totally understand what u said bellow (about comment) of your Reply.
1st time I used ole db but that had a problem inserting date before 2000(‘1-jan-2000’ no error but before that date ’31-Dec-1999’ date generated an error) generated a strange error. So finally choose OracleProvider.
|
|
|
|
|
Based on what you said
kisukortechai wrote: It’s a dedicated class for oracle server
the Oracle provider is the right choice.Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
kisukortechai wrote: System.Data.OleDb(.Net Faramework Data provider for ole db)
That's a "general" database driver, and can be used to connect to SQL, Oracle or MS Access.
kisukortechai wrote: System.Data.OracleClient(.Net Faramework Data provider for Oralce)
That's the one that was created specific for Oracle, somewhat comparable to System.Data.SqlClient for SQL Server. This one is said to be faster and will have better support for Oracle-specific type and functions.I are Troll
|
|
|
|
|
Thanks To: Eddy Vluggen
I’m working only for Oracle server so in future I’ll need ole db if I change my mind. Am I okay?
|
|
|
|