How to Join 2 tables in to 1

bex · June 26th, 2009, 09:06 AM

Hi There

I Have 2 tables and need to get 2 columns from tabel1 and 3 columns from table2.

I Have this So far:

Code:

Dim cmd As SqlCommand = cnn.CreateCommand
cmd.CommandType = CommandType.Text
cmd.CommandText = "SELECT SLP05.CUSN05, SLP05.CNAM05, SimDefault.SimNet, SimDefault.Cost, SimDefault.Commission FROM SimDefault CROSS JOIN SLP05()WHERE (SLP05.CUSN05 = @CUSN05)"

cmd.Parameters.Add("@CUSN05", Data.SqlDbType.Char, 8).Value = Me.TextBox1.Text
Dim da As SqlDataAdapter = New SqlDataAdapter
da.SelectCommand = cmd
Dim ds As DataSet = New DataSet
da.Fill(ds, "CUSN05")
DataGridView1.DataSource = ds
DataGridView1.DataMember = "CUSN05"

But i get this error:
Parameters supplied for object 'SLP05' which is not a function. If the parameters are intended as a table hint, a WITH keyword is required.

thanks

gbianchi · June 26th, 2009, 09:35 AM

Hello..
I think that () after SLP05 is useless...

bex · June 26th, 2009, 10:22 AM

Thanks that was it

gbianchi i have a little question??

How to make the Query to ingnore the spaces ;

I have a text box that you enter the company name than you click search, the SQL command runs to the database and checks 4 the exact match.

i need to search 4 minimum of 5 karacters and % after.

I know that i have to use the LIKE thing but i dont know exactly how >>

can you post something regarding this?

i have this buti it only works with the first letter in the textbox, if i type mor it returns no data
cmd.CommandText = "SELECT SLP05.CNAM05, SLP05.CUSN05, SimDefault.SimNet, SimDefault.Cost, SimDefault.Commission FROM SimDefault CROSS JOIN SLP05 Where (SLP05.CNAM05 Like '" & txtName.Text & " %')"

gbianchi · June 26th, 2009, 10:51 AM

did you try the querys directly on the database?? the query looks perfectly fine, it should be working (but you have a space before the % that should not be there...

bex · June 26th, 2009, 10:58 AM

thanks

1 little space :)

bex · June 26th, 2009, 11:26 AM

Can i pass this to a textbox insted of a DataGrid?

gbianchi · June 26th, 2009, 02:21 PM

A select??? only if you return only one row/column... and you use executescalar

bex · June 26th, 2009, 03:46 PM

That is not good for me,

I asked that cos i have a print button that i want to print the DataGrid, I got it working with the textbox, but not with the Datagrid, Is there a way to print grid data?

bex · June 27th, 2009, 03:24 PM

gbianchi I Have a Job in SQL 2005 Importing Data From SQL2000. Every time the job runs it imports the data but creates duplicates, how to stop this from creating duplicates?

I Just Need Updates

gbianchi · June 27th, 2009, 05:17 PM

You are not giving me any information that could help me solve this... you are getting duplicates, but why, I can't tell you without knowing how this thing works, SQL involved, when do it run, etc...