checking condition while assigning dataset

Posted by Bhanubysani under ASP.NET on 4/23/2011 | Points: 10 | Views : 1583 | Status : [Member] | Replies : 4
hi iam getting subcategorynames in a dataset and assigning that dataset to a datalist with checkboxes.my requirement is when assigning datset to datalist i have check a condition..that subcategories are present in another datalist are not..if have that checkboxes are checked otherwise unchecked..how can i check it help me...

Regards,
Bhanu Prakash Bysani



Responses

Posted by: Umeshdwivedi on: 4/24/2011 [Member] Starter | Points: 25

Up
0
Down
Hello,
you can do this simple query task no problem,
you write the query for that condition

Latest Technology Trainer
And Part time software consultant

Bhanubysani, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bhanubysani on: 4/25/2011 [Member] Starter | Points: 25

Up
0
Down
in this problem i compare two datsets how can it is possible...

Regards,
Bhanu Prakash Bysani

Bhanubysani, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Umeshdwivedi on: 4/25/2011 [Member] Starter | Points: 25

Up
0
Down
hello
You'll have to run all your SQL statements either way, but then once you
have all the tables in a dataset you can create the relationship(s). Here's
a snippet of code that shows how to create a relationship.

' Create and fill the DataSet.

m_DataSet = New DataSet
m_da_Addresses.Fill(m_DataSet, "Addresses")
m_da_TestScores.Fill(m_DataSet, "TestScores")

' Define the relationship between the tables.
Dim data_relation As New _
DataRelation("Addresses_TestScores", _
m_DataSet.Tables("Addresses").Columns("ContactID") , _
_
m_DataSet.Tables("TestScores").Columns("ContactID" ))
m_DataSet.Relations.Add(data_relation)
Once your relationships are created you can do some pretty neat things with
DataViews I think you should be able to query your tables and look for like
names but with different numbers.

Latest Technology Trainer
And Part time software consultant

Bhanubysani, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bhanubysani on: 4/26/2011 [Member] Starter | Points: 25

Up
0
Down
hi iam not getting clarity..my main problem is comparing two datsets at runtime ..this is possible

Regards,
Bhanu Prakash Bysani

Bhanubysani, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response