Hi, Follow the url: http://www.google.co.in/search?hl=en&source=hp&q=adding+checkbox+to+gridview&meta=&aq=0&oq=adding+checkbo[^] Hope this will help. Anurag Gandhi. http://www.gandhisoft.com Life is a computer program and every one is the programmer of his own life.

This simply isn't possible unless there is some kind of logic why the result set should look like you described. If your result set in the start is: 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 and you want: Interval Avg1 Avg2 04/2008 2000 4000 05/2008 1000 3000 Please explain for example why the last row having 3000 in Avg2 should be combined with the row having 05/08 as interval. Also why the value 2000 on the same row is moved to the row 04/08 and so on... One crucial thing is that you think this as result sets having rows with conditions since this is the way the DBMS does it. The need to optimize rises from a bad design

Man thats ugly, got to be one on the lousiest data structures around. Joins are not going to do it. You will need to use sub selects. select (Select name from name where ID = ID1) name1, (Select name from name where ID = ID2) name2, (Select name from name where ID = ID3) name3 from ID Never underestimate the power of human stupidity RAH

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

DateTime d = DateTime.Parse(x); d.ToString("MM/dd/yyyy"); -^-^-^-^-^- no risk no funk ................... please vote ------>

Use the AddDays method on the DateTime class. Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

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

Well, seeing as you wrote your own control, and have not posted code, I really don't see how we can help with this. If you want to disable a control, look it up and set it's disabled property ( from memory, it's disabled, not enabled ). But, I'm surprised you don't know this, if you've written a calendar control in javascript ? Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

I assume you want to copy everything from db2 to db1. 1. Backup db2. 2. Right click db1, go to All Task/Restore Database.. 3. Check "FROM Device". 4. Select the device by click on button "Select Devices". 5. Add the backup file that you backup from db2. Click button "OK". 6. Go to tab "Option". Change the physical file name to db1.mdf and db1.ldf. 7. Check option "Force restore over existing database". 8. You should know how to continue now. btw, please check Management/Current Activity/Process Info to make sure no connection is connected to db1. Eliz.K www.oin1.com

Rob Graham wrote: That means with statistics update based on a 10% sample of the data. Are you sure? This is what I found: STATS [ = percentage ] Displays a message each time another percentage completes, and is used to gauge progress. If percentage is omitted, SQL Server displays a message after each 10 percent is completed. The STATS option reports the percentage complete as of the threshold for reporting the next interval. This is at approximately the specified percentage; for example, with STATS=10, if the amount completed is 40 percent, the option might display 43 percent. For large backup sets, this is not a problem, because the percentage complete moves very slowly between completed I/O calls.

Krish - KP wrote: @@IDENTITY returns last generated auto increment number Yes, but for what table? If you have a large multi user database handling many transactions at once there is no guarantee that it will return the identity of the last row inserted in the scope your running in. It might return the identity for some other code running on some other table that just happens to be running at the same time as your code. You should use SCOPE_IDENTITY() to ensure that you get the identity of the last insert in your scope (and no one else's scope) Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... * Reading: Developer Day 5 Ready to Give up - Your help will be much appreciated. My website

are the DML operations are done one after the other in batch or jumbled Regards KP

check whether this solvs select * from score where s2 in ( select s.s2 from emp e inner join score s on e.id = s.id group by s.s2 having count(*) > 1 ) Regards KP

Care Career wrote: if (txtECODE.Text == ds.Tables["EMPLOYEE"]["E_CODE"]) It should be ds.Tables["EMPLOYEE"].Rows[i]["E_CODE"].ToString(); Best Regards, Apurva Kaushal

I did it "off-the-cuff" & missed that one (oops! & thanks), what did you think of the rest or the advice?

Explicitly converts an expression of one data type to another. CAST and CONVERT provide similar functionality. Syntax Using CAST: CAST ( expression AS data_type ) Using CONVERT: CONVERT ( data_type [ ( length ) ] , expression [ , style ] ) Regards, Satips.

You can conver the check box field into Boolean and insert it.. Like Insert into CreateAccount values('" + txtUname.Text + "','" + txtPass.Text + "','" + txtCPass.Text + "','" + txtEmail.Text + "','" + txtSQuest.Text + "','" + txtSAns.Text + "', " + Boolean.Parse(ChkEnquiry.Checked) + "," + Boolean.Parse(ChkStock.Checked) + ",'" + ChkPayroll.Text + "' )"; Try this one..hope it will helps you KHATRI

www.asp.net[^] is the place to look, I think there's a guest book and blog you can download, for a start. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

if(username == "you" && password == "oh") { // good login }else{ // bad login } ghehe =D Stef