Search access db using 3 fields

Question

How can I search using 3 fields on vb.net
Usually we use something like:

Dim query As String = "Insert into () values () Where id=1"

I am not really good in access or sql, so I asked. enter image description here
week, sow order and piglet# are different fields, because I need to segregate in the future if the user searches only on weeks.

What I want is, get the data which is the same as what the user inputs and display it in the DGV. Is something like this possible:

Dim query As String = "Insert into (FarrowDate) values (dtpFarrow.Text) Where week=1,soworder=1,pigletnumber=0"
' display the data in the DGV '

Help please, they only gave me a 2 week deadline >.<

"What I want is, get the data..", SQL SELECT statement? do you want to select/get data or update data? — har07
– har07, Commented Jan 30, 2014 at 6:32

Nagaraj S · Accepted Answer · 2014-01-30 04:03:04Z

2

In your query you cannot use where in insert statement.Use update statement

Update tablename set FarrowDate='' where PigletNumber='0' And Week='1' And SowOrder='1'

edited Jan 30, 2014 at 4:03

answered Jan 30, 2014 at 3:56

Nagaraj S

13.5k6 gold badges35 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Search access db using 3 fields

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related