Search results for query: *

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...

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...

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...

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...

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...

hi, I have written a highlight function based on an array of words. Apparently was working fine until I added entities. Could someone suggest an alternative way to this problem? >>highlight(list_of_words, text) Function Highlight(ByVal searchStr As String, _ ByVal inputTxt As String)...

hello, I am trying to render an xml file but I am having problems trying to get the record count for the categories and the total amount (Pi in the XML) for each category. I am posting the XML and the XSL I have to see if someone could help me. It supposed to be something very simple but I...

Hi, I have a piece of code that looks like this: Select Case ID Case 1 var1 = "something" var2 = "something" var3 = "something" Case 2 var1 = "somethingelse" var2 =...

Hi, i am creating the following view and I was wondering if this is a correct query to have? the query works just fine but i am not sure if it is tune the best way. Basically i have 4 inner join and one left outer join because i need to show the data when applies in the tableextra. As I said...

Hi, I have a windows form that basically just retrieves some data from a SQL database. I have on column on the database I need to change before rendering the form on the datagrid. the problem is that I do not know how I could get the value before its added in the datagrid so I can change it...

I have a table with 5 records, 3 of them from the same user and 2 of them from other users. I am trying to get a query that shows the total number of records(5) and the number of unique users (3). Here is the data I have: ID USERID VALUE1 CCC COM...

Hi, I have the following stored procedure: CREATE PROCEDURE testingprocedure ( @IDs VarChar(8000), @DV int ) AS Declare @IdNumbers Table(Id Integer) Insert Into @IdNumbers(Id) Select FieldName As Id from dbo.Split(@new_lettersID, ',') SELECT ID, DATANAME, DV...

Hi, I have a query that I would like to move into a stored procedure but I can't find the right syntax. Query: SELECT ID, DATANAME, DV FROM table_name WHERE (ID IN (39, 40, 69)) AND (DV= 1) The value inside in varies, sometime it comes just one value, for example 39, and...

hi, I am trying to render this xml so it looks like the way I want it but I can't get this grouping to work, I am not very familiar with XSLT so I was wondering if someone knows how to do this? thanks XML: <records> <customer> <id>1</id> <name>tom</name> <city>broon</city> <amnt>10</amnt>...

Hello, I have a navigation bar in a datalist and I am trying to be able to specify what I want to display depending on the value i pass through a variable. Let me explain you what I have so far: I have a simple navigation file (i.e. navigation.ascx) with this : <ASP:DATALIST...

Hi, I am building an access control system and I am storing all user permissions and groups in SQL Server. My site has many different sections and each user may or may not have access to one of those sections and within that section I will have another layer of permissions, i.e. read...

I have a procedure that give me results when I run it on EM but it doesn't when I run it on ASP.NET. CREATE PROCEDURE testproc ( @ID int, @TEL int, @RES int OUTPUT, @RESD varchar(20) OUTPUT ) AS SELECT a.RES, a.RESD FROM vTTM a LEFT OUTER JOIN (SELECT...

Hi, I am driving nuts trying to figure out a problem I am having with a stored procedure. I created a function and call the stored procedure but I am not getting any results. The stored procedure works fine as I get results if I run that from EM. If have tried also to hardcore the results...

Hi, I am trying to have a procedure that it checks if some data exist on one table and if it does then it perfoms an update in another table and if it doesn't then does nothing. I have the following procedure, although it doesn't actually work yet don't know why :(, this shows my idea. Is this...

hi is it possible to hightlight words within a readonly textbox? I written a highlight function to highlight text but the html tags that does the highlight doesn't render in the textbox? I am wondering if is it possible to do this or not? Been trying several different things but didn't work so far.