Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Problem in Executing SQL Query

Author  Topic 

umapriya
Starting Member

5 Posts

Posted - 2007-03-29 : 15:43:35
Hi,
SQL Table:

VPATH
-----
/library/a.aspx
/freegifts/b.aspx
/library/c.aspx

i have a asp.net web page in which i need to build a Querytext and using OLEDB objects i need to execute and retrieve the result in a datatable.

i need to filter the above table in which the VPATH contains '/library/' in it using wildcards.

can anyone help to build the querytext in a asp.net web page?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-29 : 15:51:26
Why post the same question again?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81401


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

umapriya
Starting Member

5 Posts

Posted - 2007-03-30 : 09:12:41
hi,

In the starting i thought that i need help in executing a query in sql query builder..but, later i found that it is a problem in buidling and executing from asp.net web page.thats the reason i posted the forum under asp.net section..

anyways, the link which u send it to me didn't help us..i would appreciate if anyone can help in this issue..!!

Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-30 : 09:17:17
Did you bother to take a look at my last suggesetions?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -