I can't understand how it works. Can you tell me where to find an example? Thanks, Silvia

Not without, with N! With a lot of sheets!

Hi, my name is Silvia Terzi. I want create an Excel file with n sheets. I try to use this function: Sub CreateExcel Dim FileName As String FileName = "test.xsl" Response.Buffer = True Response.ContentType = "application/vnd.ms-excel" Response.AddHeader("content-disposition", "inline; ") FileName = " & FileName " Response.Write("<Worksheet ss:Name=""Sheet1"">") Response.Write("<table>") Response.Write("<tr>") For i = 1 To 15 Step 3 Response.Write("<td>") Response.Write(i * i) Response.Write("</td>") Next Response.Write("<td width=40><b>=somma(A1:D1)</b></td>") Response.Write("</tr>") Response.Write("</table>") Response.Write("</Worksheet>") Response.Write("<Worksheet ss:Name=""Sheet2"">") Response.Write("<table>") Response.Write("<tr>") For i = 1 To 15 Step 3 Response.Write("<td>") Response.Write(i * i) Response.Write("</td>") Next Response.Write("<td width=40><b>=somma(A1:D1)</b></td>") Response.Write("</tr>") Response.Write("</table>") Response.Write("</Worksheet>") Response.Flush() Response.End() End Sub But it doesn't work. It makes a file xls with only one sheet called like the file. What I mistake? Thanks, Silvia

Thank you very much, it works. There is only one problem; if I open two different pages of internet in my computer, it doesn't work. I know that if I open the page with "New Session" it works, but i'd like to do it only opening a new page of internet. Any idea? Thanks, Silvia

Hello, I am Silvia Terzi and I am quite new in asp .net. I have a very contingent and, at least I hope, banal problem. In my website I've built a login page where I give the possibility to the user, to choose the database he/she wants to enter, considering that I have 4 db (oracle) structurally identical but containing different datas. Inside the site then use various objects, like gridview and combobox, connected to db through SqlDatrasource. I've been able to do this thing and it seemed to work, but I have realized, that the change of connection string, instead of being only for session user, seems to work to global level. So, when an user changes connectionstring entering in the site, also changes connectionstring of the other users connected to the site from other computers. What I wrong?? I simply change the ConnectionString of the sqldatasource, but what's missing? Thank you to everyone who wants to help me. Regards, Silvia Terzi

Hello, I really hope someone can help me, I do not know how to do. I've created an ado .net entity model (called model.edmx) in my site web and I have to change the connection string dinamically. After that I want to refresh data in a gridview that has, like datasource, an entitydatasource linked to model. How can i do?? Thanks in advance, Silvia Terzi

Yes, it's good. But how much is this?

Hello, I need to extend the ComboBox control so that while the user types text, it automatically displays its drop-down containing only those of its items that contain the text being typed by the user. This is almost similar to using AutoCompleteMode = Suggest and AutoCompleteSource = ListItems but It must show not only items that start with the text being typed but all that have it as substring. How can I achieve this? Thanks Silvia Terzi