Search results for query: *

I have a DataList with nested DataGrids in the item templates. The datagrids have text boxes where a user will enter a quantity of an item. I can compute these totals if I have one data grid, and I can reference it. So I have the code to find the control of type txtbox names such-and such...

Basically what I have is a datadrid I'm filling with accessories for a product that can be ordered. In a TemplateColumn, I've added a asp:TextBox. This is the box a user would enter the Quantity of the accessory they want to order (if they want). How do I loop through each DataRow in the...

How do you return a scalar value derived from a select statment within a user defined function?

Hi everyone, Want I need to do is basically copy a row in my table and insert it into the same table, giving it a different ID. here is my SQL statement insert into events (Title, [Description], Location, CreationDate, LastSavedDate, StartDate, FinishDate, TimeId, LabelID, IsAllDay, UserID...

here is my stored proc: CREATE PROCEDURE sp_SearchByEmail ( @Email varchar(100)= null ) AS SELECT username, users.id as UserID, displayname from UserProfiles join users on users.id = userprofiles.id where email like '%@Email%' GO The liek part isn't working like I want it to.... if...

I want to do some processing on my site if they close out of the browser; how can I capture this? Thanks for your help in advance

I did use the "obvious" table and divs inside and it was still not wrapping.

I've never output my content in a div before, do you have a sample I can look at? Thanks very much for your help!

What if I don't want scroll bars and just want all the data output? Do I not set a height for the div and that will work?

Here is my scenario. I have a users that have profile, and they fill out a series of questions about themselves. All the questions aren't required. When I just display them, I only want to display the items the user has filled out. I have this logic down. However, when I display my data...

I'm assigning the value when a person logs in. This page is accessed after a person logs in and the variable is set. I use the above syntax to access the value of the Session variable in other places and it works just fine.

Hi everyone, I have an .aspx file that is used by an external program to perform a function. There is no code behind, all code and HTML is contained in one file. the structure is like this: <% string strBlah = Request.Querystring("jdkfsd"); string userid =...

@FriendID should really be @FriendUserName in the variable declaration section, btw.

I've got this stored procedure, and I know it is wrong, but am not sure how to make it right. CREATE PROCEDURE [dbo].[sp_CreateNewConnection] ( @UserID int = NULL, @FriendID varchar = NULL ) AS INSERT INTO CONNECTIONS (userid, friendid)...

Hi everyone, I was working on a remote SQL Server in Enterprise Manager and my internet connection died. So I closed EM and Query Analzyer and rebooted my computer after the internet connection was fixed. Now, when I expand the Registration for the remote server, and I expand the list of...

Well I really think I need some coffee. This worked: update clients set maoverage=(maoverage / 100)

Well.... duh on my part there. Having all sorts of problems and not thinking clearly there :) Can I do that in a query? Or do I need to write a program to do it?

Hi all, I converted some legacy data into a SQL Server database. When I inserted data, I thought I was getting whole numbers. Unfortunately, that wasn't the case, so I inserted whole numbers into this particular field. For example, in the legacy data, I had the value 200, and it is now in my...

I'm updating a field across two databases. I know I"m close, but can you please tell me where my syntax is wrong here? update Q_UCDavis_1009.dbo.Clients set Q_UCDavis_1009.dbo.Clients.Race = Q_UCDavis_RACES.dbo.Clients.Race where Q_UCDavis_1009.dbo.Clients.SSN =...

I've been asked to import an Excel file into a Microsoft Access database. Some of the fields in the Excel file are formatted as numbers. Without changing any formats in the Excel file, how would I import all the data as text fields into Access? Thanks for your help! Cen