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

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

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

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

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

Hi everyone, I've got an application that I devloped locally. When I run it, it compiles and excutes perfectly. When I place the page on my intranet site, I can not view the site. I get an error in my web.config file on the following line: <configuration...

Hello everyone, I looked through the FAQs but couldn't find anything on this. What I have is a client table in one database, and I need to select ID, RACE from that table in database 1 and update the same client's race in database #2. What is the syntax for doing this? Thanks a ton Cen

Hi, I'm making a customer control navigation bar. How do I link up to my CSS file for this control? This is my code: <%@ Control Language="vb" AutoEventWireup="false" Codebehind="Title.ascx.vb" Inherits="CHMA.Title" TargetSchema="http://schemas.microsoft.com/intellisense/ie5" %>...

Hi everyone, I have two drives - an 80 gig and a 200 gig. I installed a fresh copy of WIndows 2k on my first drive. Before I installed this fresh copy, my 200 gig was partitioned up into three partitions and working just fine. I have a Maxtor PCI card because of the large size of the drive...

Here is the code I have: DataRow SavedGameRow = tbl.Rows[0]; for (x = 1; x < 10; x++) { switch (SavedGameRow[x]) { case "X": pictureBox1.Image = "playerOne.Img"; break; case "O": pictureBox1.Image = "playerTwo.Img"; break; case "E": //Some code...

Hi, I need to write a stored procedure that looks at a phone number field in my database and if the phone number starts with (513) [5-9](6 more digits), I need to update the area code to be (999)-original 7 digits. For example: i have a phone number that is (513)566-7788, I need to update it...

Can anyone point me in the right direction so I can fix this problem? Thanks! Therese