473,569 Members | 2,872 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

is this dataset table select correct"

GS
If I want to find in the row of "codetable" with codeTblName like
"mypattern% " and Code like "abc%"
MyDataSet.codet able.select("co deTblName like 'mypattern%' and Code like
'abc%'")

does the above have the select parameter in the correct format?
Oct 26 '06 #1
2 2605
Short answer for this question Yes

Please note that the select statement wil return a datarow array and not a
datatable

so if yiou want to loopt through the results you can do this

for each dr as datarow in MyDataSet.codet able.select("co deTblName like
'mypattern%' and Code like 'abc%'")

--- do your stuff
next

regards

Michel Posseth [MCP]

"GS" <gs************ **********@msne ws.Nomail.comsc hreef in bericht
news:OM******** ********@TK2MSF TNGP02.phx.gbl. ..
If I want to find in the row of "codetable" with codeTblName like
"mypattern% " and Code like "abc%"
MyDataSet.codet able.select("co deTblName like 'mypattern%' and Code like
'abc%'")

does the above have the select parameter in the correct format?


Oct 26 '06 #2
gs
thx, I will give another shot.

somehow I got nothing in dr while I do see the data in the studio preview.
"Michel Posseth [MCP]" <MS**@posseth.c omwrote in message
news:O3******** **********@TK2M SFTNGP04.phx.gb l...
Short answer for this question Yes

Please note that the select statement wil return a datarow array and not a
datatable

so if yiou want to loopt through the results you can do this

for each dr as datarow in MyDataSet.codet able.select("co deTblName like
'mypattern%' and Code like 'abc%'")

--- do your stuff
next

regards

Michel Posseth [MCP]

"GS" <gs************ **********@msne ws.Nomail.comsc hreef in bericht
news:OM******** ********@TK2MSF TNGP02.phx.gbl. ..
>If I want to find in the row of "codetable" with codeTblName like
"mypattern% " and Code like "abc%"
MyDataSet.code table.select("c odeTblName like 'mypattern%' and Code like
'abc%'")

does the above have the select parameter in the correct format?



Oct 27 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
5248
by: Antonio Ooi | last post by:
Hi, I get a DataTable based on this simple query: SELECT * FROM Customers Later, I want to know just the table name because I do not want to play with the string within the SELECT statement. I expect DataTable.TableName to give me an exact name, i.e. "Customers", but it gives me "Table" regardless of what query from what table. Can...
5
7450
by: DraguVaso | last post by:
Hi, Something I don't understand about a Typed DataSet: When a value in the DataSet is DBNull, it throws this error: "Cannot get value because it is DBNull". But aren't Typed DataSets invented to make life easier, to be able to get to tge Tables and Values with less code, in less time? But with this thing you need to add a Try-Catch...
2
7039
by: Alanoly J. Andrews | last post by:
Hi, I have two tables (that I know of) in a database that seem to be corrupted. All SQL statements on the tables hang, "select * from..", "select count (*) from", "delete from..". I can't even drop the tables as the "drop table..." statement, too, hangs. But the tables do exist as they show up in "describe table <tabname> ". A "create...
1
7243
by: DB_2 | last post by:
Greetings, I was searching Google for ways to turn off transaction logging for some queries. I came across this old post from Feb 2003: > From: fareeda (fareeda@pspl.co.in) > Subject: Re: Question related to "CREATE TABLE AS SELECT" in DB2 > Newsgroups: comp.databases.ibm-db2 > Date: 2003-02-27 21:11:59 PST >
0
1273
by: BTI-User | last post by:
I have one GridView that contains one field from my DB and a second GridView2 that contains the related info to GridView1 - in essence a parent/child setup. When I choose "Enable Selection" from wizard in GridView1, GridView2 contains the correct related data. I don't like the column called "Select" in my GridView1. How can I make the...
4
3612
by: ShadowLocke | last post by:
Hi, Im not very experienced with XSL, this is my first run in with it. I found an XSL file that converts a dataset to an excel readable format. The problem I have is when the dataset has a null value for a column, it does not add an empty element for the column. Is there any way I can detect this? Excel.xsl: <xsl:stylesheet...
7
2911
by: php_mysql_beginer911 | last post by:
Hi .. hope someone will help i am trying to figure it out why i cannot post string "union select" every time i try to post data which content union and select .. the page doesn't get posted and it shows error page not found on this server i googled and found some people use union and select to hack sites (mysql injection) i guess the...
8
12376
by: ismailc | last post by:
Hi, I would like to change the text color of (<xsl:value-of select="Description") onmouseover of image. the javascript works, it's just that i can seem to get the name correct <td> <xsl:value-of select="Description" disable-output-escaping="yes" /> </td> <td> <xsl:element name="asp:image"> <xsl:attribute name='id'>ttip_<xsl:value-of...
0
7930
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8138
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7681
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7983
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6290
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3662
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3651
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2118
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
950
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.