Hello Fans,


I have just started using vb.net and i found it very efficient application for creating windows application. But the problem i have face is that, i just recently create software for one pharmacy, fully completed but when i came to deploy the application so that it can be installed on any compatible system that was where i hit the rock. Please help me on how to deploy this application.

Click on project menu > properties

in the dialog box, set your application and publish it.

Cheers!!!

this can be of help 2 u.

http://msdn.microsoft.com/en-us/library/k3bb4tfd(VS.80).aspx

and this

http://www.c-sharpcorner.com/UploadFile/rahul4_saxena/Setup08232007071849AM/Setup.aspx

Please N'lander,

questn 1: i'm trying to search for record in my Database usiing vb.net OLedb , but it's complaining of datatype mismatch in criterial expression at line
no 10 & 11

questn 1: At line no 18, how can i load picture of the person i'M searching for back on my picturebox from database?


1 Dim sqlstr As String, inp As String
2. strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
3 "Data Source=C:\Users\Ademola\Desktop\Oledb Connection\coop.mdb"
4 objConnection = New OleDbConnection(strConnection)
5 objConnection.Open()

6 inp = InputBox("Enter Oracle No"
7 sqlstr = "Select * from reg Where oracle='" & inp & "'"
8 objCmd.CommandText = sqlstr
9 objCmd.Connection = objConnection
10 dr = objCmd.ExecuteReader
11 dr.Read()
12 txtoracle.Text = dr.GetString(0)
13 txtmrn.Text = dr.GetString(1)
14 txtname.Text = dr.GetString(2)
15 txtha.Text = dr.GetString(3)
16 dp1.Text = dr.GetString(4)
17 cmbsex.Text = dr.GetString(5)
18 ' pic.Image = (dr.GetString(7))
19 dr.Close()


End Sub

You need to figure out exactly what is stored in column 8 below . .
You cannot cast a String to an Image. . . .

pic.Image = dr.GetString(7)

If, you have a bytes there in column 7, then you probably want to Ctype it appropriately to Image type. Else if you have a string that is an address to an actual image on your drive somewhere, then what you want to do is create an image object with that info

Also, try to avoid doing this

txtoracle.Text = dr.GetString(0) 

I know it is easy to, knowing the current structure of the table in question, assume that doing this is ok, but any changes to the order of the columns would likely cause  you to also need to change and recompile your code as well.