Hi Morison, Thanks for replying.. but fortunately i got the solution solution lies in using nested grid... Am glad i have done it...... thanks

--Here 2 See Sharp-- I have not failed. I've just found 10,000 ways that won't work. :)

Hi all How to get multiple headers in a gridview? I want data to be shown something like this Car ... .... .... ... .... .... ... .... .... ... .... .... Bikes ... .... .... ... .... .... ... .... .... . . . . and so on....

--Here 2 See Sharp-- I have not failed. I've just found 10,000 ways that won't work. :)

Thanks Krish.. It worked....

--Here 2 See Sharp-- I have not failed. I've just found 10,000 ways that won't work. :)

Hi MarkBrock Anything appended to a string is understood as string only by the compiler.

--Here 2 See Sharp-- I have not failed. I've just found 10,000 ways that won't work. :)

select rank from table where input between P1 and P2

--Here 2 See Sharp-- I have not failed. I've just found 10,000 ways that won't work. :)

This solution is when you are manually putting data in the fields rom enterprise manager. Just click on the cell and do " control 0 ". That is press control key and zero. this will get NULL value in the empty field. -Naina

--Here 2 See Sharp-- I have not failed. I've just found 10,000 ways that won't work. :)

thanks a lot steve... this piece of code has made my things so simple.... it works like a charm.... :-D --Naina

--Here 2 See Sharp-- I have not failed. I've just found 10,000 ways that won't work. :)

Hi all, Is there any way to get current weeks detail frm the database using SQL 2000?? For e.g. today is wednesday, i want all data from monday to sunday. Plz can anyone help in this

--Here 2 See Sharp-- I have not failed. I've just found 10,000 ways that won't work. :)

Hi all, Is there any way to get current weeks detail frm the database using SQL 2000?? For e.g. today is wednesday, i want all data from monday to sunday. Plz can anyone help in this

--Here 2 See Sharp-- I have not failed. I've just found 10,000 ways that won't work. :)

No.. I did not get the clue how to solve this problem.... --Naina

Still Debugging the past?..I have already coded the future..

Hi ppl, I am working on a project where excel sheet has to be generated. In the end i have added this piece of code. theWorkbook.SaveAs(SourceFile, Type.Missing, "", "", false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); ExcelObj.Quit(); Marshal.ReleaseComObject(ExcelObj); theWorkbook = null; ExcelObj = null; but somehow its not removing the excel frm TM. and when i try to generate Excel again it gives error "Its already used by some program" --Naina

Still Debugging the past?..I have already coded the future..

Hi, Just put a dot after thsi and you get selected as a property. check out. ListBox.Items[i] ----Naina

Just make the property of textbox as follows. TextMode="MultiLine" Naina :)

Oh..ok... Thanx Christian Graus .... Actually i was resetting data on postback.. I just put the code if (!IsPostBack) {} And it worked like a charm.... :-D Thanks a lot

Hi Vikram.. It does have the property called "Selected"

Hi Christian Graus, Data is comin from the database table. I did binding on page load. as in below: lstResource.DataSource = ds; //ds-Dataset lstResource.DataTextField = "Names"; On Submit button click i want the selected values to get inserted in database together.

Hi all, I m having problem with selecting multiple values in a listbox and inserting tht in the database. I wrote this code: if (lstResource.SelectedIndex != -1) { for (int i = 0; i < lstResource.Items.Count; i++) { if (lstResource.Items[i].Selected == true) { stringBuilder.Append(lstResource.Items[i].Value + ","); } } } but somehow its not giving any value as TRUE, even if it is selected. Thanks in advance :^)