Search results for query: *

Hello, I created a user control in c#.net to display google maps. In the event that a location is missing a latitude and longitude, I make a call to the google service, which returns xml. I want to load a dataset with this xml data, but I get an error: "Data at root is invalid. Line 1 position...

Hello - I'm new to C#, and can create basic webforms. I'm exploring repeaters, and was wondering if it's possible to create a repeater that will: 1. display existing data 2. enable you to add a new record and save 3. display existing data with newly created record 4. enable you to add another...

hello - i have a select case set up like so: select case ucase(actionmode) 'first time user loads page CASE "" strExtensionID = Request.QueryString("NoteExtensionId") CASE "update" strExtensionID = Request.QueryString("NoteExtensionId") end select i seem to be able to successfully get a...

hello - i need to create a dynamic number of recordsets each time the page loads. i'm trying to do something like this: for eCounter = 0 to ExtensionCounter dim RS[eCounter] set RS[eCounter] = "select * from table where id = eCounter" next what is the syntax for creating the name of the...

hello, I converted an asp function that generates a mortgage loan schedule to a SQL stored procedure. Everything is working fine, but one of the columns has data that is off by one cent for a few rows. i cant seem to find out how to correct this, or see where the problem is happening. does...

hello, i have a list of editable text fields that are displayed dynamically. I need to be able to "disable" each field using either a checkbox or a button. I added a lock image next to each editable field, with an "onclick" property that calls a function to disable the proper field. However...

hello - i'm new to CR, and have a project to convert existing reports in CR over to activereports. how do i view the CR report files? can i open them up in visual studio.net 2003? do i need to download some other software? this is going to be a difficult task for me since i haven't used...

hello - i don't have that much experience working with asp and sql server. currently, i have a page that displays quite a bit of data, and everything is handled within asp. I need to change this to sql so that we can call the sp whenever i need to, and then get the values. does anyone know...

Hi, This is my first time using REporting Services, and I'm also a newbie with SQL Server 2000. Is it possible to set the dataset of a report using a stored procedure? I have a webform that provides a dropdown list of possible order numbers to generate a report on. When the "view report"...

Hello, I'm using WinXP, and am hosting my SQL Server 2k and ASP.NET app on my local server. I'm trying to set up the reporting services, but I'm unable to deploy, since I don't seem to have the correct target URL. I know this sounds ridiculous, but what is the format for the target URL? I've...

Hi, I have a webform with several usercontrols and a few buttons. The OnClick event of the button should be able to pull values from one of the usercontrols, and use those values to create a SELECT statement query that returns the results from a database and populates a dropdownlistbox. Is...

Hello, I'm having some problems creating a SELECT statement in my C# app. Here's what I have so far: SELECT bill_no FROM voice_main WHERE beg_stamp > convert(datetime,StartDateTbx.Text) AND end_stamp < convert(datetime, EndDateTbx.Text)"; StartDateTbx & EndDateTbx are both textboxes on the...

Hello, I have a webform that has usercontrol (DateTimeSpan), and a "View Report" button. What I need to do, is when the button is clicked, I need to ensure that all the fields on the DateTimeSpan usercontrol are populated before continuing. How can I reference the controls within a...

Hi, I'm taking data from an Oracle db, and importing it into a "holding table". After that, I'm running a stored procedure to update/add some fields, after which I need to take that data and add it to the main data table. The problem is that there are a few fields that I don't need to copy...

I'm completely new to SQL Server 2000, and I have a project to create and deploy a client server system with SQL Server and C#.NET. The data comes from monthly .DAT files, which actually originate from someone else's Oracle database. I'm just trying to wrap my head around the process of how...

Hello, I'm trying to create my first asp.net web application using VB.NET. I've been able to successfully create and debug Windows Applications in visual studio, but not asp.net web applications. here is the error message I get: Error while trying to run project: Unable to start debugging on...

I'm a total newbie at this, so any advice or suggestions are more than welcome. I need to create a SQL Server db that imports files from an Oracle db. We receive these files in .DAT form every month, that are zipped. Does anyone know the best way to import this data? I can open the .DAT files...

I have a .dat file that originates from Oracle, and I need to import this data into sql server 8.0. I'm pretty new with SQL Server, can anyone advise on the best way to do this? Thanks!

Hello - I can't figure out why the following sql statement is causing this error: Run-time error '3346': Number of query values and destinatino fields are not the same. Here's the sql statement(its really long, 20 column fields, and 20 values...i define the variables used earlier in the...

Hello, I have an asp page that displays a table of records. in each record is a "View" link, that when clicked, should load another asp page with the record details. i'm not sure how to pass the value of the selected record over to the new asp page, and i'm trying to do it by having the link's...