Member Avatar for kavithabhaskar

Hi:

I am writing code in VB but SQL is the major role here..

I am checking if MFG="DELL" in table1 and if that is there I need a msg box saying "DELL is supported"


Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click

Dim con As OleDbConnection = New OleDb.OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=C:\Documents and Settings\bashkark\Desktop\Final Database.mdb")

Dim cmd As New OleDbCommand

cmd = New OleDbCommand (if exists("select * from table1 where MFG='DELL'")

MsgBox("DELL is Supported")

else

i am going to have several such statements.. and if those values exist in my table2, I will have to change the forecolor of values in table1 to green if exists and red if they do not exist. Table1 and table2 have the same fields.

I am trying to do something like this.. But not sure if this is right.. can u please correct me ?

thanks

kukks

  • 2 Contributors
  • 1 Reply
  • 96 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by AntonioGK
Member Avatar for AntonioGK

Hello,

1 - This is a windows form or a web form?
2 - are you using visual studio .net or The express edition?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.