ado net
I did an inner join and then I created a table where I stored the data. There are 4 columns, I used getString with the index 0, it went to the second column, I used the index 1, and it said that the index was too big, and it's kind of stupid that I have 4 columns. I wanted to extract a value from each column and it only worked if I wrote 0 everywhere asa arata tabelul
CREATE TABLE Cars (Name varchar(50) NOT NULL, Model varchar (50) NOT NULL, Fabrication varchar(50) NOT NULL, Price decimal(18,2) NOT NULL).
3 Replies
for such questions u should also tell the actual SQL dialect/dbms (there can be differences between MSSQL, MySQL, PostgreSQL, etc)
u should also provide the code u used for querying the data, both the c# code and the sql query code.
this part is mandatory because without it we can not help u
storing the results of a join sounds wrong
uh, where does the storing part come from?
oh, i just saw it, somehow i overread the first sentence