|
i've tried something. it is working with sql server but it doesn't seem to be working with oracle.I am receiving an error.Here's the coding to save the file on the disk.
HttpPostedFile filupload = FileUpload1.PostedFile;<br />
int filelength = System.Convert.ToInt32(filupload.ContentLength);<br />
byte[] data = new byte[filelength];<br />
string name = FileUpload1.FileName.Remove(3);<br />
filupload.InputStream.Read(data, 0, filelength);<br />
string username = this.Session["username"].ToString();<br />
string filename="C:\\Inetpub\\wwwroot\\website1\\data\\"+username+".xls";<br />
filupload.SaveAs(filename);<br />
and this is the code that i used to send excel file to sql database:
string conn = @" Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Inetpub\wwwroot\website1\data\"+ sheetname+";Extended Properties=Excel 8.0;Persist Security Info=false";<br />
string sqlconn = "Data Source=CHITRA;Initial Catalog=northwind;Integrated Security=True";<br />
OleDbConnection xlcon = new OleDbConnection(conn);<br />
string strComand = "select * from [sheet1$A1:C3]";<br />
OleDbDataAdapter xlda = new OleDbDataAdapter(strComand, xlcon);<br />
DataTable xldt = new DataTable();<br />
DataSet xlds = new DataSet();<br />
<br />
xlda.Fill(xldt);<br />
xlda.Dispose();<br />
SqlConnection sqlcon = new SqlConnection(sqlconn);<br />
SqlDataAdapter sqlda = new SqlDataAdapter("select * from products", sqlcon);<br />
<br />
DataSet ds = new DataSet();<br />
sqlcon.Open();<br />
sqlda.Fill(ds, "products");<br />
<br />
foreach (DataRow xlrow in xldt.Rows)<br />
{<br />
DataRow ordr = ds.Tables["products"].NewRow();<br />
string productid, productname, unitprice;<br />
ordr["productid"] = xlrow[0];<br />
ordr["productname"] = xlrow[1];<br />
ordr["unitprice"] = xlrow[2];<br />
ds.Tables["products"].Rows.Add(ordr);<br />
sqlda.Update(ds, "products");<br />
}<br />
<br />
ds.AcceptChanges();<br />
sqlda.Dispose();
if u find the data adapter is not working then use the insert query.but when i am trying it with oracle it is giving me this error and i couldn't find any description for this error. here it goes;
Unable to load DLL 'OraOps10.dll': Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
can any one help.
|
|
|
|
|
Please don't repost.
Best Regards,
Apurva Kaushal
|
|
|
|
|
I have page1.aspx which includes in the code behind the lines:
String commandstringclose = "chatbotwindow.close();";
ButtonCloseChatbot.Attributes.Add("onclick", commandstringclose);
The window.open() script gets called earlier in the page, so this works fine to close the window when the ButtonCloseChatbot is clicked.
My questions is, can I call the same method from another page? i.e. When the user is on another page of the site (logout.aspx) I want to be able to do chatbotwindow.close(). How do I pretend that ButtonCloseChatbot was clicked in the logout.aspx code? Or, is there a way to use the window.close() function from a page which is not the page that called the open() function?
Thanks,
Alice
|
|
|
|
|
Dear Friends i want to provide an option of printing a document on my web site but i have no idea about this please Help me with sample code... i am using ASP.NET 2005 ,VB.NET 2005 please reply me as soon as possilble.....
Ahmed
|
|
|
|
|
You can use javascript window.print function for this purpose.
Best Regards,
Apurva Kaushal
|
|
|
|
|
thanx for reply dear can you send me some code example please............
|
|
|
|
|
Suppose for a button if you want to print the page then you can do it like this:
button1.attributes.add("onclick", "javascript window.print();");
Best Regards,
Apurva Kaushal
|
|
|
|
|
on the button click event enter this code..
Button1.Attributes.Add("onClick", "window.print();");
else. u can create an HTML input button and write
<form><input type="button" value=" Print this page "<br />
onclick="window.print();return false;" /></form>
u can create a link as well... same way..
Kunal
|
|
|
|
|
Hi
I have a Datagrid and Button controls in a webform I am displaying Dept Details in Webform1.But when I click Button
Then Entire Details should display in webform2 using sessions How?
Thanks
|
|
|
|
|
You can store the complete data in session and then you can bind your controls after getting the data from session in the second page.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Pls tell me How can i Do?
|
|
|
|
|
Fetech complete data in a dataset and then pass that to a session variable, i guess it will work.
Session["myData"]=DatSet
|
|
|
|
|
If the button is inside the datagrid then it is fairly easy.
what you have to do is to hook the ItemCommand or RowCommand (in case you have Gridview).
The following code may help you
<asp:templatefield>
<itemtemplate>
<asp:button id="btnDetail" text="Detail" commandargument="<%# Eval("DatabaseIDFieldName" %>" commandname="ShowDetail" runat="server">
the CommandArgument property is inialized with the Id filed value in your table.
you may then right the following code in RowCommand event
protected void gw_RowCommand(object sender, GridViewCommandEventArgs e)
{
int ID = Convert.ToInt32(e.CommandArgument.ToString());
Session["ID"]=ID.ToString();
Response.redirect("http:detail.aspx");
}
After the page is redirected to detail page there you should retrieve the ID value from the session as
Integer Code=Convert.ToInt32(Session["ID"].ToString());
you can then use the Code to query your database and retrieve the datail
best luck
|
|
|
|
|
I have one ListBox and Label...How to retrieve two selected values from Listbox to Label...Please do needfull
With Regards,
Samson
|
|
|
|
|
Do you want to concatenate the selected values and then display it in the label?
Gautham
|
|
|
|
|
http://aspnetlibrary.com/codebankdetails.aspx?type=Controls&codebank=Get-a-list-of-all-selected-items-in-a-CheckBoxList
The ListBox works in the same manner as the CheckBoxList when it comes to looping through items, so simply use the example from the article above and replace the name of the CheckBoxList with the name of your ListBox.
|
|
|
|
|
hai all,
I am new to ASP2.0... I would like to include
calendar control in my project..
can anyone help me how to do this in Vs2005...
thanks in advance
with Regards,
Imthiyas Ahamed.A
|
|
|
|
|
You can take help from Here[^]
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi all,
Can we use one required field validator for two different controls,viz textbox and datagrid at a time.
If so,anyone pls explain the scenario.
Thanks all
Have a Nice Day Dudes
|
|
|
|
|
I don't think so. But what exactly is your requirement. Why you want it like that.
Best Regards,
Apurva Kaushal
|
|
|
|
|
HI Apurva,
There are two radio buttons, if one of them is selected,i have to show web editor,else another i have to show multiline textbox.
so in both the scenarios ,i want to place required feild validator.
so is it necessary to have two validators or its solved by one itself.
this is the problem.
Thanks
Have a Nice Day Dudes
|
|
|
|
|
Yes I think you need to have two separate requiredfield validator.
Best Regards,
Apurva Kaushal
|
|
|
|
|
I have created one application for send email in asp.net.
Emails are going to given address but going as Spam email. why it is so ? Is there any technique by which we can send Email properly to given address?
|
|
|
|
|
If emails are being received as span it is usually because of the subject of the email, the content of the email or the url that the email was sent from. So I would choose your subject and body of the email so that it doesn't look like spam. If your url you are sending from is on a spam list there isn't much you can do about that.
Ben
|
|
|
|
|
Hi,
I am having a problem calling a javascript function with a return value.
Iam using registerstartupscript("", function11());
public void function11()
{
string script="";
script += "";
script += "var r = confirm('Are you sure?');";
script += "if(r){return true;}else{return false;}";
script +=
}
Now, how to check whether true is returned or not? I dont want to use btn.attribute.add method as it does not serve my purpose.
Thanks,
Gautham
Gautham
|
|
|
|