Filling Dataset with Data Adapter query results C# Asp.Net

Question

I am working with C# and Asp.Net. I have following data adapter and Data set:

SqlDataAdapter da_Select_Matching_Records;
DataSet ds_for_showing_X_Rows_Cols = new DataSet();

I want to fill in the Data Set ds_for_showing_X_Rows_Cols with the query results. Here is my Code:

    con = new SqlConnection("Data Source=local;Initial Catalog=Test;Integrated Security=True");

da_Select_Matching_Records = new SqlDataAdapter("Select BusinessSector5.Description_DE, SubCategory.Kategorie "+
"FROM   Match_Subcategory_BusinessSector5 INNER JOIN "+
" SubCategory ON Match_Subcategory_BusinessSector5.SubCategoryID = SubCategory.ID INNER JOIN "+
" BusinessSector5 ON Match_Subcategory_BusinessSector5.BusinessSector5ID = BusinessSector5.ID", con);

//Filling of Data Set
da_Select_Matching_Records.Fill(ds_for_showing_X_Rows_Cols, "Description_DE, Kategorie");

I am getting this error, on the line where I am filling the data set. I used the query in Sql Server management studio and its running OK.

Incorrect syntax near the keyword INNER.

You should paramaterize your queries too to avoid sql injection: msdn.microsoft.com/en-us/library/bbw6zyha(v=vs.110).aspx — hutchonoid
– hutchonoid, Commented Nov 22, 2013 at 14:26

hutchonoid · Accepted Answer · 2013-11-22 14:38:40Z

3

You need to add a space at the end of this line:

"FROM   Match_Subcategory_BusinessSector5 INNER JOIN"+

i.e.

"FROM   Match_Subcategory_BusinessSector5 INNER JOIN "+

the same with this line too:

"SubCategory ON Match_Subcategory_BusinessSector5.SubCategoryID = SubCategory.ID  INNERJOIN"+

You've also got no space between INNER and JOIN.

So to confirm, add a trailing space to all lines and a space between inner and join

edited Nov 22, 2013 at 14:38

answered Nov 22, 2013 at 14:20

hutchonoid

33.4k15 gold badges102 silver badges106 bronze badges

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

6 Comments

Kamran Over a year ago

Yes I added the space but still I am getting the same error. Then I also added space on other lines but still getting the same error.

hutchonoid Over a year ago

A space on the end of this line too: Select BusinessSector5.Description_DE, SubCategory.Kategorie"+

hutchonoid Over a year ago

A space between INNERJOIN i.e. INNER JOIN

hutchonoid Over a year ago

Please can you add your updated code to the question? Just so I can re-check it.:)

Kamran Over a year ago

I got it now. There was a space missing the end of this line. "Select BusinessSector5.Description_DE, SubCategory.Kategorie". I added the space and its working now. Thanks

|

Collectives™ on Stack Overflow

Filling Dataset with Data Adapter query results C# Asp.Net

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related