|
Many thanks for the quick reply!
|
|
|
|
|
I want to import excel sheet into my database. Can anybody help me to find any article or books to find how to do this(asp.net/c#).
|
|
|
|
|
Open enetrprise SQL Server
Select the database
Select Tables, Right Click , select All tasks, select Import Data
Click Next
Choose Microsoft Excel 97-2000
Browse the file to import
click Next
Choose the destination Database
clcik Next
Click Next
Select the Sheet name and the table name you want to import
click Next
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
Thanks, But I am using Firebird as the database.
|
|
|
|
|
private void GetData()<br />
{<br />
try<br />
{<br />
if(FileName.Text.EndsWith("xls"))<br />
{<br />
string connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ FileName.Text + ";Extended Properties=Excel 8.0;";<br />
<br />
DataSet bulkData=new DataSet() ;<br />
<br />
OleDbDataAdapter adap = new OleDbDataAdapter("SELECT [Postal/Kommune], HouseType, KommuneNumber, PostalCode, StreetCode, HouseNumber, Floor, SideDoorNumber FROM [" + SheetName.Text + "$]", connection);<br />
<br />
adap.Fill(bulkData);<br />
<br />
if(bulkData!=null)<br />
if(bulkData.Tables[0].Rows.Count>0)<br />
{<br />
BulkPropertyBLL bulkpropertyBll = new BulkPropertyBLL();<br />
<br />
for(int i=0;i<bulkData.Tables[0].Rows.Count;i++)<br />
{<br />
UserProfile userInfo1 = new UserProfile();<br />
userInfo1.UserProperty = new Property();<br />
<br />
userInfo1.ReportType = bulkData.Tables[0].Rows[i]["Postal/Kommune"].ToString();<br />
userInfo1.UserProperty.PropertyType = Convert.ToInt32(bulkData.Tables[0].Rows[i]["HouseType"]);<br />
userInfo1.KommuneIDss = bulkData.Tables[0].Rows[i]["KommuneNumber"].ToString();<br />
userInfo1.PostalCodess = bulkData.Tables[0].Rows[i]["PostalCode"].ToString();<br />
userInfo1.StreetCode = bulkData.Tables[0].Rows[i]["StreetCode"].ToString(); <br />
userInfo1.HouseNumber = bulkData.Tables[0].Rows[i]["HouseNumber"].ToString(); <br />
userInfo1.Floor= bulkData.Tables[0].Rows[i]["Floor"].ToString(); <br />
userInfo1.SideDoor= bulkData.Tables[0].Rows[i]["SideDoorNumber"].ToString(); <br />
<br />
DataSet ds = bulkpropertyBll.GetNewDistanceEvaluationResultBulk(userInfo1);<br />
<br />
<br />
<br />
int result = bulkpropertyBll.AddBulkPropertyEvaluation(ds,userInfo1); <br />
<br />
}<br />
MessageBox.Show("Bulk Evaluation completed");<br />
<br />
}<br />
}<br />
}<br />
catch(Exception Ex)<br />
{<br />
MessageBox.Show(Ex.Message); <br />
}<br />
}
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
Stop spamming the forums with your useless job postings.
If you have a job put it here![^]
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton
My website
|
|
|
|
|
Hi,
All
Could any body help me out. I have a stored procedure in oracle which returns 4 sysrefcursor and on dot net side I mean asp.net using c#. I am not able to recieve the SysRefCursor. If any body has any clue please help me....
Thanks
Sapan
Spillting Headache
|
|
|
|
|
Hi All,
I need some help. I'm trying to export Gridview into Excel. But i'm getting the following error!
"Control 'myGridView' of type 'GridView' must be placed inside a form tag with runat=server."
Here is my Code:
protected void BtnExport_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
// If you want the option to open the Excel file without saving then
// comment out the line below
// Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/ms-excel.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
myGridView.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
THIS IS THE GRIDVIEW THAT I'M USING::
<asp:gridview id="myGridView" runat="server" width="483px" cellpadding="4" forecolor="#333333" autogeneratecolumns="False" datasourceid="AccessDataSource1">
<columns>
<asp:boundfield datafield="Sno" headertext="SNo" sortexpression="Sno">
<asp:boundfield datafield="Partno" headertext="PartNo" sortexpression="Partno">
<asp:boundfield datafield="mfg" headertext="Manufacturer" sortexpression="mfg">
<asp:boundfield datafield="qty" headertext="Quantity" sortexpression="qty">
<asp:boundfield datafield="price" headertext="Price" sortexpression="price">
<footerstyle backcolor="#507CD1" font-bold="True" forecolor="White">
<rowstyle backcolor="#EFF3FB">
<editrowstyle backcolor="#2461BF">
<selectedrowstyle backcolor="#D1DDF1" font-bold="True" forecolor="#333333">
<pagerstyle backcolor="#2461BF" forecolor="White" horizontalalign="Center">
<headerstyle backcolor="#507CD1" font-bold="True" forecolor="White">
<alternatingrowstyle backcolor="White">
<asp:accessdatasource id="AccessDataSource1" runat="server" datafile="~/App_Data/db1.mdb"
="" selectcommand="SELECT [Sno], [Partno], [mfg], [qty], [price] FROM [RfqInfo]">
But my Gridview is already placed in the form only!!!! 
could any one please help me on this issue???
Thanks in Advance.
|
|
|
|
|
Your gridview is a server control and that control have to inside the form with runat=server tag. Add runat=server to your form tag.
Apurva Kaushal
|
|
|
|
|
Please add the Runat= server tag in your Grid view and run ur application.
Regards,
Satips. ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
I think runat=server has to be added in form control not in gridview.
Apurva Kaushal
|
|
|
|
|
Yes. Runat=server has to be added in the form Control.
Regards,
Satips.
|
|
|
|
|
Thank you all for the quick response!!!
my Form tag & Gridview both contains "runat=server" tag in it! ~!!! but no use!
grrrrrrr!
|
|
|
|
|
I think there would be some mismatch can you show us the form tag code?
Apurva Kaushal
|
|
|
|
|
yes, here is my form tag code:
<form id="form1" runat="server" style="width: 100%; height: 75%;">
<div>
<table border="0" width="100%">
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblCompany" Width="100%" runat="server">Company</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblCompany1" runat="server"></asp:Label></td>
<td width="5%"></td>
</tr>
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblAddress" Width="100%" runat="server">Address</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblAddress1" runat="server" TextMode="MultiLine"></asp:Label></td>
<td width="5%"></td>
</tr>
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblTelephone" Width="100%" runat="server">Telephone</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblTelephone1" runat="server"></asp:Label></td>
<td width="5%"></td>
</tr>
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblFax" Width="100%" runat="server">Fax</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblFax1" runat="server"></asp:Label></td>
<td width="5%"></td>
</tr>
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblEmail" Width="100%" runat="server">Email</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblEmail1" runat="server"></asp:Label></td>
<td width="5%"></td>
</tr>
</table>
<br /><br />
<asp:GridView ID="myGridView" runat="server" Width="483px" CellPadding="4" ForeColor="#333333" AutoGenerateColumns="False" DataSourceID="AccessDataSource1">
<Columns>
<asp:BoundField DataField="Sno" HeaderText="SNo" SortExpression="Sno" />
<asp:BoundField DataField="Partno" HeaderText="PartNo" SortExpression="Partno" />
<asp:BoundField DataField="mfg" HeaderText="Manufacturer" SortExpression="mfg" />
<asp:BoundField DataField="qty" HeaderText="Quantity" SortExpression="qty" />
<asp:BoundField DataField="price" HeaderText="Price" SortExpression="price" />
</Columns>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/db1.mdb"
SelectCommand="SELECT [Sno], [Partno], [mfg], [qty], [price] FROM [RfqInfo]"></asp:AccessDataSource>
<br />
<br />
<table border="0" style="width: 100%">
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblComments" Width="100%" runat="server">Comments</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblComments1" runat="server" TextMode="MultiLine"></asp:Label></td>
<td width="5%"></td>
</tr>
<tr>
<td style="width: 5%; height: 26px;"></td>
<td valign="top" style="width:10%; height: 26px;"><font face="Verdana" size="2">
<asp:Button ID="btnSubmit" Width="100%" runat="server" Text="submit" OnClick="btnSubmit_Click"></asp:Button></font></td>
<td width="5%" style="height: 26px"></td>
</tr>
</table>
<asp:Button ID="BtnExport" runat="server" OnClick="BtnExport_Click"
Text="Export to Excel" />
</div>
</form>
|
|
|
|
|
This peace of code works fine for me. I executed that one and is performing well.
Apurva Kaushal
|
|
|
|
|
hmm...but whats wrong from my side:
I executed it again but still the same error persists
here is the error::
Control 'myGridView' of type 'GridView' must be placed inside a form tag with runat=server.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: Control 'myGridView' of type 'GridView' must be placed inside a form tag with runat=server.
Source Error:
Line 63: System.IO.StringWriter stringWrite = new System.IO.StringWriter();
Line 64: System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
Line 65: myGridView.RenderControl(htmlWrite);
Line 66: Response.Write(stringWrite.ToString());
Line 67: Response.End();
|
|
|
|
|
its showing the error at Line 65.
|
|
|
|
|
In order to overcome the error, We have to override the below function.
public override void VerifyRenderingInServerForm(Control control)
{
}
Regards,
Jay 
|
|
|
|
|
Cool stuff man... I will rate this...
|
|
|
|
|
Thanks (For Nellai Website Too)
-- modified at 5:45 Wednesday 13th June, 2007
Regards,
Jay
|
|
|
|
|
DKalepu wrote: myGridView.RenderControl(htmlWrite);
You cannot render the GridView Control into HTML directly. Use DataGrid.
May be Jay_se is correct. But I haven't tried that before. We also had this issue before and we solve that using DataGrid. We can used JavaScript get the HTML String of the GridView and do the same.
|
|
|
|
|
Hi,
Venkatesh MookkanYou cannot render the GridView Control into HTML directly.
We Can do Vankat. It works fine too.
Regards,
Jay
|
|
|
|
|
If it works fine, then no problem for me man..
Thanks...
|
|
|
|
|
Hi, Thank you very much for the help Jay..
That piece of code solved my problem.....
Thank you so much once again to all of you for helping on my problem/
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
