Recent content by sonya9879

Hello, I have a datalist paging in ASP.NET 2.0 and I am trying to use atlas on top of it for the paging but I am having a hard time trying to figure out if it is possible to trigger a <a id="NextPage" runat="server"> tag event within atlas so I can get it to work. The paging I am doing is...

here is a function that does the looping: ALTER FUNCTION [dbo].[listToTable](@list as varchar(8000), @delim as varchar(10)) RETURNS @listTable table( Position int, Value varchar(8000) ) AS BEGIN declare @myPos int set @myPos = 1 while charindex(@delim, @list) > 0 begin insert...

I think I found an answer to this by creating a function and loop the comma delimited string. Just in case someone else has the same problem in the future, thats a way to sort the problem out :).

Hi, I am having a problem trying to pass a variable to a stored procedure. create procedure test @word varchar(10), @sectionID varchar(max) as begin SELECT * FROM [testtable] WHERE sectionID IN (@sectionID) end sectionID sometimes is just one value, like for example 1 and sometimes several...

I am using 2.0

Hello, I am working on a project where I am using redirection URLs to get to my scripts, for example, /sample goes to /sample/test.aspx and stuff more complex with regular expressions. I have found a problem with .net and the way the html form action is displayed. For example, when I call...

What can I say? bborissov and SQLDenis, you are both a star thanks so much.

Hi kxramse, thanks for your reply but I am not using oracle, I am using SQL Server 2005 that is why I posted this here.

Hi, I have a table with the following columns: uniqueid customerid destxt I want to add a constraint that doesn't allow duplicate values in the destxt column for each customer ID. So two customers could have the same destxt value but not the same customer. example: 10 12345 Hello 11...

thanks but this "solution" wouldn't work for me because I have several other tables on the same page. Anybody else know if it is possible to add a line after each row in a GridView? Must be something withing the Grid to achieve this line OnRowCreated or something similar perhaps???

hi there, but i am using asp:TemplateField for each column, in fact I dont use HTML within the gridview tag. isn't there another simple way?

hi guys, my quick thoughts on this, If you dont want to use a relational database, just create XML files and use XSLT to retrieve just the information you need from the XML. You can find plenty of samples on how to render XML with XSLT on the web.

Hi, I have been trying unsuccessfully to add a horizontal line separator (an image line or <hr> rule) after each row in my asp:gridview but I haven't manage to find a way to do this. Does anyone has an idea on how to do it? There must be a way that we can add a separator after each row. It...

hey adamroof you are a star thanks for trying to help. the problem I originally had on my code was that I was doing the replacement and adding the tag to every single part of the string instead of JUST replacing the word I wanted when it was found on the list, with the <span> tag. Now I just...

thanks god i found an alternative way that it works so I though to share it with you all :) Function Highlight(ByVal searchStr As String, _ ByVal inputTxt As String) As String ' Setup the regular expression and add the Or operator. Dim RegExp As Regex = New...