Click here to Skip to main content
15,913,115 members

Comments by PP from bangalore (Top 6 by date)

PP from bangalore 3-Nov-13 16:53pm View    
thanks for the reply. But the problem is how can I arrange the visible tds or buttons so that ther wont be any space . Actually when I make the tds visible false or true then the invisible tds also take the sacing between the buttons. as shown in the code. As tda and tde are visible but the tdb,tdcand tdd which are nothing but the ids if the td which is run at server attribute.can I make a feel that thereis no button in between the visible buttons. if all the buttons (tds ) are visible then ther is no problem for that case.
PP from bangalore 31-Aug-13 5:58am View    
Hi Dave

I have updated the question but after trying that i get the same thing like the system hangs.
PP from bangalore 31-Aug-13 5:41am View    
Deleted
Hi Dave

I also did that , but the same thing it hangs.

thnaks
PP
PP from bangalore 27-Aug-13 16:33pm View    
I think the only way is get the file from the fileupload control and save it to the temp location or any location by getting the server path and then pass this full path to the oledb and read it and do the necessary thing and then delete it from that location.

If any body knows anything better please suggest me. The only extra work which I don't like to do is to save the file to the server and then read. I was thinking can I read it on the fly rather saving it to a physical location in the server and then delete it.
PP from bangalore 27-Aug-13 12:02pm View    
hi,

do you say that the file must be present in the server not in the local machine.
My code is as below.
excellFileName = fileUpload2.PostedFile.FileName;
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + excellFileName + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
And the file name is the selected file by the Fileupload control.
MSdb.OleDbDataAdapter xlAdapter = new MSdb.OleDbDataAdapter(strSql, connString);