kjewell23
Last Activity: Oct 5 '07, 05:44 PM
Joined: Sep 11 '07
Location:
-
ok i did and it worked... -
column qualifier or table undefined
I'm getting this error column qualifier or table undefined in asp.net
Dim connectionstrin g As String
connectionstrin g = "DRIVER=Cli ent Access ODBC Driver (32-bit);UID=ODBC;P WD=GOCATS;Syste m=143.42.191.13 5"
Dim Order As Integer
Order = CInt(txtOrderNu mber.Text)
Dim myConnection As New Data.Odbc.OdbcC onnection(conne ctionstring)
Dim mysql1... -
the fields that im missing is in the second table i tried both tables for the datamember and still missing...Leave a comment:
-
well i added the datamember to the first table between the datasource and databind. the massage part i dont' know what you are talking about...Leave a comment:
-
I don't have that installed on my machine so It don't help me. Its all the same code except the sql commands and of course the tables...Leave a comment:
-
ds.relations problem with dataset
sure it wouldn't hurt to try it. I have a gridview not a datagrid...Leave a comment:
-
I don't know. Does it...Leave a comment:
-
There are the ptyp1, ptyp2, and the descp fields that are missing....Leave a comment:
-
thats the thing I'm not getting no error I'm not getting 3 columns that I need from the table...Leave a comment:
-
ds. relations problem with dataset
Hi. I have the code working just fine except all the data isn't coming up with the ds.relations code. Could you see what I'm doing wrong or what else I need to add. Code down below
Dim adapter As OdbcDataAdapter = New OdbcDataAdapter (command)
Dim ds As DataSet = New DataSet()
adapter.SelectC ommand = New OdbcCommand("se lect rmsfiles2.obcop 200.line#, rmsfiles2.obcop 200.ordno, rmsfiles2.obcop 200.quano, rmsfiles2.obcop 200.quana,... -
data relations
Hi I have a dataset with two tables. Everything works and display except my second table. Could you see what I"m doing wrong. please my code is down below
[vbasp.net-code]
Dim adapter As OdbcDataAdapter = New OdbcDataAdapter (command)
Dim ds As DataSet = New DataSet()
adapter.SelectC ommand = New OdbcCommand("se lect line#, ordno, quano, quana, quans, c2rdt, unitm, actsp, prdno from rmsfiles2.obcop 200... -
I'm not going to update or insert. I'm just binding the two table together...Leave a comment:
-
how do I inner join two table to a dataset
Hello. I'm trying to inner join two tables into one dataset. Is that possible. If so I do I do it. I have my code down below, so if you could help me. please!! I'm using asp.net for my coding
[vb.asp.net-code]
Dim myConnection As New Data.Odbc.OdbcC onnection(conne ctionstring)
Dim mysql As String = "select rmsfiles2.obcop 200.line#, rmsfiles2.mspmp 100.ptyp1, rmsfiles2.mspmp 100.ptyp2, rmsfiles2.obcop 200.quano, rmsfiles2.obcop 200.quana,... -
what do you mean by that a mod could move it for you...Leave a comment:
-
Need to inner join two tables in a dataset
Hi. I have look but can't find or understand what I need to do here. I need to join two tables together with a common field which is prdno Here is my code. please help me If I'm doing it wrong.
[vb-code]
Dim connectionstrin g As String
connectionstrin g = "DRIVER=Cli ent Access ODBC Driver (32-bit);UID=xxxxxx ;PWD=xxxxxxx;Sy stem=xxx.xxx.xx x"
Dim Order As Integer
... -
How do I do that. I look and I kinda understand but not for sure how to do the code...Leave a comment:
-
The thing is that the customer won't type in a order number till the page load completes in a textbox then they hit submit then the data comes up...Leave a comment:
-
It is a valid table. However I change the code just like you changes it in the submit button but it don't display anything. What could be wrong...Leave a comment:
-
Ok . I thought I was, so how do I do that? I'm getting pass till the Ordno part so I change it to factory order and now it says that column factory number doesn't belong to the table. what does that mean? I know that its not recogniziting but it should. I think...Leave a comment:
-
well, the ordno is a column field of my database in as400, Here is rest of my code
[code=vbnet]
'the button to submit
Dim connectionStrin g = "DRIVER=Cli ent Access ODBC Driver (32-bit);UID=ODBC;P WD=xxxxxxxx;Sys tem=xxx.xxx.xxx .xxx"
Dim Order As Integer
Order = CInt(txtOrderNu mber.Text)
Dim sql As String
Dim myconnection As OdbcConnection
...Last edited by Frinavale; Sep 19 '07, 04:21 PM. Reason: Fixed [code] tag, removed IP and Password to DatabaseLeave a comment:
No activity results to display
Leave a comment: