[mihaispr]

Hi to the community of dreamincode.net!

I have a little problem with interacting with sql server from vb.net.


I look here and read this tutorial from your forum:

http://www.dreaminco...wtopic32392.htm

And now I shall detail my problem.


I made an sql server table called Per:



Until here all it's ok.


What I want to do is to insert in the two textboxes the user types Mike (in textbox1) and Bottomley (in textbox2) ,press the button search and stored the results in listview if he finds the row(and in this case it finds).

Here is the printscreen of my windows forms application vb.net(i'm using visual studio 2008 ):



So I type in the two textboxes Mike(textbox1) , Bottomley(textbox2) press the button and it searches in my sql server table (if it finds -in this case I have this rows it's row1) it displays me the result in the Listview.

That's my problem.

Any and all help is appreciated!

This post has been edited by mihaispr: 15 November 2009 - 09:31 AM

[Donnie1581]

Show us your Button Click Event code

[mihaispr]

Donnie1581, on 15 Nov, 2009 - 09:26 AM, said:

Show us your Button Click Event code

My database is called test and my table is called Per.

Private Sub Form_Load()

Set MyDatabase = OpenDatabase("test.sql")
Set MyTable = MyDatabase.OpenRecordSet("Per", dbOpenDynaset)

In the button that I have on my form:

Private Sub Button1_Click()

'variable con is for connection is gived by server name , username=user and password =pwd

Dim con As New SqlConnection("HOME-PRIMAVERA";user=mihaispr;pwd=mihai")
		Dim cmd As New SqlCommand("Select * From Per", con)
		con.Open()
	   LisView1.Add(cmd)
		con.Close()

'otherwise if any row isn't search in textbox and it doesn't lie in table call errordialog
if con=" "
ErrorDialog.ShowDialog()
ShowMessage('Can't connect to database')

if cmd= " "
ErroDialog.ShowDialog()
ShowMessage('The  table doesn't contain the rows specified by values of the 2 textboxes')
'also i want to display an error message if any rows isn't in my sql server table
End Sub

Any ideas or it's a simple solution for this?

This post has been edited by mihaispr: 15 November 2009 - 02:45 PM