|
|
Hi there,
I need to read data from a excel spreadsheet, show on a webpage and insert into a sql server 2005 database. Need to do it in asp.net 2.0, using ado.net and VB(or C# samples will also help).
Can anyone point me to the right place?
|
|
|
|
|
There are a few ways that you can go about this, depending on how complex the spreadsheet is that you wish to read. In a simple case, you may want to consider using ADO to tap Excel as a data source. You can find a nice article on doing so here[^].
If that doesn't work for you, you may wish to consider purchasing one of the commercial components that allow you to work with the Excel native format without Office being present on the machine, such as this[^] one.
As a last resort, it is possible to install Office on the server and use the Office interop assemblies to automate Excel. Please note that I label this the last resort, because it is slower, consumes more resources, and requires client software to be installed on a server (potentially increasing the attack surface.)
Hope that helps. 
--Jesse
|
|
|
|
|
Can ASP.NET script and HTML server controls be placed in an XSL file?
And if so are there any guides to using them this way?
My program uses a single page with an XML control that accepts an SQL "FOR XML" query result and as its source and an XSL file to format it.
In one case I would like the results of the query sent to drop down selection boxes.
I would like to do so without having to make an entirley new page for it, so was thinking about having HTML server controls and the coresponding scripts for those controls within the XSL file that formats the particular query.
Any advice would be appreciated.
Thanks.
|
|
|
|
|
I have 2 questions
Question # 1
============
Can I resize Master Page like frames.
If not then anyother solution.
Question # 2
============
I have 2 Iframes with IDs (LeftFrame, BodyFrame)
How I get BodyFrame ID from any server control event of LeftFrame page.
Know Yourself Then Grow Yourself.
|
|
|
|
|
KamalJKhan wrote: Can I resize Master Page like frames.
No, you can't, as a content tag in a master page doesn't have any specific size. A content tag doesn't represent a rectangular portion of the page, but a section of the code for the page.
---
b { font-weight: normal; }
|
|
|
|
|
I have IFRAME control on my page. I can set the 'src' property at design time, to load desired page into that control.
But how to load a page into that IFRAME control programatically? I mean:
This IFRAMe hase ID="aaa". I would like to be able to write in aspx.cs file:
aaa.url = "Page1.aspx" or something similar
How is that possible?
thank you in advance for any help
|
|
|
|
|
You can use attributes property to achieve the required thing. something like this:
iframeid.Attributes.Add("src","yourpage.aspx");
Best Regards,
Apurva Kaushal
|
|
|
|
|
Exactly, thank you very much
|
|
|
|
|
always welcome..
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi!
I have to do paging in thr datagrid., for that I wrote the code :
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex=e.NewPageIndex;
models();
}
In models() Func... I retrieve the value from the DB.
It shows the value and that the Page no also: 1,2,3.... Bur if i clicks the 2nd page..
It goes to next form.. it doesn't show the values...
How can we solve this one..?
How can we do the paging in the DataList..?
T.Prabu
|
|
|
|
|
|
|
Hi Prabs,
Let me Know it in detail what is ur doubt in datagrid paging .
Happy Coding,
with regards
Satips
|
|
|
|
|
Hi Satips!
As i told earlier.,
I got the values in the grid, and that page no s also..
It shows the first page, If i clicks the 2 nd page no .,
it redirects to another page (instead of displaying remaining data...)
If u want to chk my code let me know i vl send u....
And then, How can v achieve the pagiong in data list..?
T.Prabu
|
|
|
|
|
|
Hi Satips!
Thanks for ur response...
I vl go through that link.,
If i hv any doubt i vl let u know.,
Bye.,
T.Prabu
|
|
|
|
|
can anyone plz tell me how to do Sorting for dynamically created column in a datagrid using C#
|
|
|
|
|
|
i didn't get, what i exactly need. I want dynamic sorting
|
|
|
|
|
I am using C# as base language to devlope a asp.net website. The problem is that I want to use SqlDataadapter but I find it to be disabled in the toolbox. I ve tried to genrate a dataadapter by dragging a table from Server explorer to Default.aspx form but instead of SQLDataAdapter it genrates a SqlDatasource and dataview. Can someone please tell me what I need to do to use a Sqldataadapter in asp.net?
|
|
|
|
|
raviroyx wrote: The problem is that I want to use SqlDataadapter but I find it to be disabled in the toolbox
Excellent - Being able to drag that from the toolbox to your page is the first stage in producing very badly designed code.
raviroyx wrote: Can someone please tell me what I need to do to use a Sqldataadapter in asp.net?
SqlDataAdapter da = new SqlDataAdapter();
See Also:
SqlDataAdapter Class[^] (MSDN)
|
|
|
|
|
I said I dragged a table from Server explorer to form not a dataadapter from toolbox.
|
|
|
|
|
Either way my basic message stands. Don't drag and drop data items from the toolbox or server explorer to your form. Learn how the database interaction actually works then create your own DAL (Data Access Layer) to do it properly. Putting data access on a form is very VERY bad design. Just don't do it. Period!
|
|
|
|
|
Are You using vs2005 or vs2003 ?
StonePit
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
