Search results for query: *

This is the problem: I got an "ADD ROW" button and a gridview. Click the "ADD ROW" button and a new gridview row is inserted with the first column as a template textbox. If I type anything in the textbox and then hit "ADD ROW" button, the textbox values are lost. What can I do to retain those...

I changed the name and still does not work. I still get the same error. The example in the article worked if the method is not in a web service.

flat2,(works if not a web service method) I get the following error: "No overload for method 'ShowErrors' takes '3' arguments." 'ShowErrors' is the web service method. What am I doing wrong?

I want to create web service. I need to call a method and pass any number of parameters. That is, call a method (function) and pass one argument, two arguments up to 200. I tried to declare the parameters in the web service method as objects and call that method from a client application passing...

Thanks again :)

passing calendar date to a stored procedure and I'm trying to convert it to a Julian date. Any help?

I'm using SQL 2005. That's good to know. Thanks

Thanks a bunch for both of you. Both worked!

Declare @number int set @number=10 DECLARE @strSQL varchar(1200) set @strSQL = ' select top ('+ @number + ') account from contact' EXEC(@strSQL) The error I get is : Conversion failed when converting the varchar value ' select top (' to data type int. Any help would be appreciated

Thanks, George. That'll work.

I have an input parameter in a stored procedure "@TicketNumber BigInt". I need to check the length of the parameter. If the length is 18, then all is fine. If the length is 17 then I need to append a '0' to the beginning of the parameter. If the length is 16, then append '00' and so on ... What...

Thanks, guys. Rob, you wrote in the jobstep Declare @firstParam int,@nextParam varchar(100) Select @firstparam=SomeIntCol,@nextParam=SomeVarcharFiled From WhatEverYourTableIsCalled Where SomeCol=SomeVal --Now call the proc execute usp_SomeProc @firstParam,@nextParam etc.... works great. But...

Thanks, guys. But where do I add the sp_add_jobschedule procedure so that it runs? I believe I have to do something like that: EXEC sp_add_jobschedule @job_name = 'test', @name = 'Schedule_test', @freq_type = 4, -- daily @freq_interval = 1, @active_start_time = '11:00:00'...

Programmatically, can you set the job to run at a specific time? Basically, the user will decide if he/she wants to schedule the job daily, weekly, etc... I'll get the user input through a windows application and this input will be saved in SQL. Now I need to be able to get this input from the...

Hey Rob, Is there a way I can schedule running the job dynamically (by passing parameters containing schedule time based on input I receive from the user)

Thanks for the help. I believe taht should work. Thanks again!

I have an idea how to schedule a job in SQL server 2005. The job will be calling a stroed procedure with few parameters. The values for those parameters come from a table in SQL server and then should be passed to the stored procedure called from the job schedule. Do I need to write a script to...

How would you write a query to combine multiple records into one? for example, my table would have two fields like part number and location. I have multiple records for the same part number. I want to have the same part number with all locations it can be found at in one row(record). I want to...

How to add a row to a datagrid ? I got 4 integer values stored in variables that I need to add to a datagrid. There's no datasource involved here.

It does work without dynamic sql. Did it work for you in dynamic sql???