Hi, Please provide me the code of adding checkbox control in Gridview at runtime. Thanks & Regards Care Career

I want to remove NULL from below given resultset.If I will remove NULL then data will come in two rows.SO how Can i do this using temp table? please help its urgent. Interval Avg1 Avg2 NULL NULL NULL 04/08 NULL NULL 05/08 2000 NULL NULL 1000 NULL NULL NULL NULL NULL NULL 4000 NULL NULL 3000 Thanks Care Career

Hi I do not want to change my existing SP I just want output as below given.I want to remove NULL Please help.. Sr No Interval Avg1 Avg2 1 04/2008 2000 4000 2 05/2008 1000 3000

Hi My Stored Procedure output is as below given. Interval Avg1 Avg2 NULL NULL NULL 04/08 NULL NULL 05/08 2000 NULL NULL 1000 NULL NULL NULL NULL NULL NULL 4000 NULL NULL 3000 I want result in two rows as below given. Interval Avg1 Avg2 04/2008 2000 4000 05/2008 1000 3000 Please let me know how i can do this using temm table ? Thanks Care Career

Hi I have result set as table name=ID ID1 ID2 ID3 1 3 1 2 6 1 1 1 1 I want output as Name1 Name2 Name3 A C A B D A A A A I have one table for name is Name field of this table are:Id,Name. I m trying query as Select Name.Name as Name1 Name ,Name.Name as Name2 from Name,Name.Name as Name3 from Name inner join ID on Name.ID=ID1 Inner join ID on Name.ID=ID2 inner join ID on Name.ID=ID3 above query is giving error. Plz help in this thanx Care Carrer

I want all the fields from 3 tables. This query solves fethes data from C table only i want data From a or b also SO can u help? thnx care career

Hi I have 3 tables e.g A,B,C. I am joining table A and table B on the bases of id Select A.id,B.Name from A,B where A.id=B.id . Now i want get records from table C basis on calculated A.id. These all I want in One Query. Is tht Possible? Thanks Care Career

i have date in string x=2007-08-24T00;00;00+5:30 Format. I need in mm/dd/yyyy format in C# plz help CARE CAREER

i want to calculate weekly dates & want to save these dates in databse. i have one dropdown in this values r daily,weekly,halfyearly,yearly.if i select weekly option & 2 textboxes r there,in 1st textbox 01/08/2007 2nd textbox 31/08/2007 values r there then i want to show on weekly basis all dates between ist aug. to 31st aug. Plz help me i need code in c# for this. Thanks for replaying. Care Career

Hi I have 2 textboxes .in first i m saving start date & in second i m saving end date. if in first textbox i have 01/08/07 value & in 2nd textbox i have 31/08/07 .I weekly dates between these. Can anyone help for this i want code for this in c# language syntax. Thanks CARECAREER

thnx for this but i m not using calandar control. i want to mekae in javascript only So plz help

plz relll me how to wite calander in javascript give egood ling for tht

HElp How to call js funtion on textbox 's on focus event

Hi I want to create calander in javascript.Plz help me how to create? My requirement is in my asp.net page one textbox is there & one image button . Calander must be opened on textbox's onfocus event & it must be open on image click. Plz tell me how to open calander popup on textbox'onfocus event . thnx Carecareer

Hi I have made calender control in javascript & called in asp.net 2.0. I want in textbox also tht calender sholud be called & & 2 months Date it should show & Which date & privious date must be disabled . Plz Help thnx

thnx lot Can u tell how to start Sql server agent? 1069 logon faliure error is coming when i start sql server agent. Thnx

ya SO how to do? Thnx

Hi I have to database in sql sever 2000 db1 & db2 I want db2 backup in db1 . I have taken db1 bacckup After tht how i do restore Plz Help

Thnks for replay BACKUP DATABASE Parikrama TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\SQLSpyNetJob.bak' WITH NOINIT, NOSKIP, STATS = 10 can anyone tell wht is the meaning of STATS =10 in above query. And plz tell me i want query tht taking automatically bacup of database with in interval0f 10-10 minutes by job scheduler . Thanks

Hi HOw to create Backup of database using query for a fixed time? I do not want to use Wizard. plz help as soon as possible. Thanks