Re: Importing - ASP.NET Discussion Boards

hi friends

now i got the answer.thanx

but i got the uname,pass in pageload

now i want if i enterd uname then only password is displayed

another one query is in cookies username,password details alos saved

how can i achive this

regards

I did not found an AJAX message board so I drop my question here.
Confused | :confused:

With Ajax/Asp.net I want to give users the opertunity to manage Gridviews, deleting editing adding records, without reloading the whole main page. Can somebody give me a hint?

Regards, André

go here http://ajax.asp.net/[^]

you will find a lot of examples and videos

Regards,
Sylvester G
sylvester_g_m@yahoo.com

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.

Try this way..

		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 />
								//ds.WriteXml("c:/bulk.xml");<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!!!! Cry | :((

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]

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. Rose | [Rose]

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 Smile | :)

Cool stuff man... I will rate this... Smile | :)

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group | Blog Spot

Thanks

(For Nellai Website Too)

-- modified at 5:45 Wednesday 13th June, 2007

Regards,

Jay Smile | :)

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.

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group | Blog Spot