If you are looking only for certain/particular data and getting the whole column of data you would have to refine your SQL Statement or get all of the data and use your C# to parse through and parse out what you want.
Ok so then what is the issue? That is particular data that you are getting? Do you have a list of what you are getting and what you want to get? When you query it will return all of the data you ask for.
I think im not having problem in my SQL statements but in c# code... I have 3 tables in my database and im having sevral columns in it. I just want to retrieve the datas into my richtextBox from the column called 'Code type' which is present in two of my tables.
My RichTextBox Should be like this
SELECT Heading, Rating, Code type, Details FROM TableMovies WHERE (Rating = 'x' ) AND (CategoryCode = y )
But im Getting it as
SELECT Heading, Rating, Code type, Details FROM TableMovies WHERE (Rating = 'x' ) AND (CategoryCode = )
Here is my c# Coding:
MyRichTextBoxName.Text = "SELECT Heading, Rating, Code type, Details FROM TableMovies WHERE (Rating = '" + this.MyCheckedlistBoxName.Text + "' ) AND (CategoryCode =";
I need the c# coding for my CodeType
It's a simple logic, but i don't know how to do. If i get the answer for it, my project will be finish.
Hi I'm having a problem implementing a mini shopping cart drop down in the header to show the user all the products they have in their shopping cart. It seems the only solution for this is Ajax, and I've looked all over and can't find anything that I could possibly ...
Help! I want to create a java program that finds the highest even integer among the values entered by the user. Stop asking values when a value less than 1 have been entered. If no even integer is entered, display "No Even Integer"