Issue with Dataset.tables[0].select ()

Question

0.00/5 (No votes)

See more:

Hi,
i have a dataset which contains a table "ClassName" with 2 columns "ID" and "class" and many rows in the table and when i used
DataRow[] aRow=dataset.Tables[0].Select("ID=(somevalue) and class=(somevalue)")
it's not returning rows into the datarow for given column values and if i change the value of the column it"s returning(ie it"s returning rows for some values only)
and when I checked in the visualiser during debugging the rows are present there but it"s
not returning into the the datarow.

Please help me regarding the same.

Posted 24-Mar-11 23:56pm

siva455

Updated 25-Mar-11 0:17am

m@dhu

v3

Add a Solution

3 solutions

Solution 2

Before we can work out what is going on, you need to check a few things.

1) Are you reading the correct info into the DataSet in the first place? If so, show the code fragment.
2) How can you tell it is not returning the "right" data? What values is it returning?

Edit your question, and give us the relevant code fragments for the DataSet load, the actual Select method call, and the read-out of your DataRow array.

Posted 25-Mar-11 0:11am

OriginalGriff

Solution 3

can you try the same by changing the select string as

DataRow = dataset.Tables[0].Select("ID = '" &(SomeValue like text from a text box)&"' AND class='"& (SomeValue like text from a text box)&"'" ).

If you still face the problem, can you post your exact code

Posted 25-Mar-11 0:12am

prasenjeit

Comments

rayaprasuna 26-May-12 5:50am

<asp:DropDownList ID="ddlSubCategory" runat="server" AppendDataBoundItems="True"
CssClass="DropDownStyle" DataTextField="SubCategoryName" DataValueField="SubCategoryId"
OnSelectedIndexChanged="ddlSubCategory_SelectedIndexChanged" TabIndex="13">
<asp:ListItem Value="0">Any

iam using the static dataset as

static dataset dsall =new dataset();

dsall.Tables[1].Select("GeneralCategoryId = '" + Int32.Parse(ddlGeneralCategory.SelectedValue) + "'");
ddlSubCategory.DataBind();

for this iam getting the error: DataBinding: 'System.Data.DataRow' does not contain a property with the name 'SubCategoryName'.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Accepted Answer · 2011-03-25T00:06:00

Solution 1

Try setting your expression to this:

C#

dataset.Tables[0].Select("ID='somevalue' and class='somevalue'");

Posted 25-Mar-11 0:06am

#realJSOP

Comments

siva455 25-Mar-11 6:22am

really thanks for your help..it"s working now..but my doubt is how come it is returning for other values eventhough i give expression like
dataset.Tables[0].Select("ID=somevalue and class=somevalue");

#realJSOP 25-Mar-11 7:37am

I don't understand your question. Are you saying that if you specify "ID='5'", it's giving you records where ID isn't necessarily equal to '5'?