ASP.NET

7-Sep-09 2:01

Hi,
There is one utility called SQLBULKCOPY but that is for sqlserver.
In asp.net 2.0, there is no as such utility for oracle.

My need is to transfer excel data to oracle?
Provide any solution.

Robert_Pan7-Sep-09 2:04

Robert_Pan

7-Sep-09 2:04

OLEDB

amittinku7-Sep-09 2:27

7-Sep-09 2:27

I have opned an oledb connection to connect to oracle.
I am working in offline mode.
I fill up the dataset with excel data. Works fine.

Now I open oracle connection with oledb only.
Created oracle adpater also using oledbadapter.
Created the dataset. it contains no rows as table in oracle is empty.

Check the code below:
string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\ASP1\\Book1.xlsx;Extended Properties=Excel 12.0";
OleDbConnection oledbConn = new OleDbConnection(connString);
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", oledbConn);
OleDbDataAdapter oleda = new OleDbDataAdapter();
oleda.SelectCommand = cmd;
DataSet ds = new DataSet();
oleda.Fill(ds, "Sheet1");

OleDbConnection oledbConn1 = new OleDbConnection("Provider=MSDAORA;Data Source=mywork; User Id = system; Password =Infosys123");
OleDbCommand cmd1 = new OleDbCommand("SELECT * FROM excel_ora", oledbConn1);
OleDbDataAdapter oledb = new OleDbDataAdapter(cmd1);
DataSet ds1 = new DataSet();
oledb.Fill(ds1, "excel_ora");
ds1 = ds.Copy();
OleDbCommandBuilder oo = new OleDbCommandBuilder(oledb);

oledb.Update(ds1,"excel_ora");
//the above line thorws error as it does not find table "excel_ora"
Response.Write("hi");

amittinku7-Sep-09 2:36

7-Sep-09 2:36

//Code related to excel
string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\ASP1\\Book1.xlsx;Extended Properties=Excel 12.0";
OleDbConnection oledbConn = new OleDbConnection(connString);
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", oledbConn);
OleDbDataAdapter oleda = new OleDbDataAdapter();
oleda.SelectCommand = cmd;
DataSet ds = new DataSet();
oleda.Fill(ds, "excel_ora");

//Code related to Oracle
OleDbConnection oledbConn1 = new OleDbConnection("Provider=MSDAORA;Data Source=mywork; User Id = system; Password =Infosys123");
OleDbCommand cmd1 = new OleDbCommand("SELECT * FROM excel_ora", oledbConn1);
OleDbDataAdapter oledb = new OleDbDataAdapter(cmd1);
DataSet ds1 = new DataSet();
oledb.Fill(ds1, "excel_ora");

//Transfer excel dataset to oracle
ds1 = ds.Copy();
OleDbCommandBuilder oo = new OleDbCommandBuilder(oledb);

oledb.Update(ds1,"excel_ora");
Response.Write("hi");
-----------------------------------------------
Written aboce code. everything fine but data does not transfer to oracle. WHy?

r a m e s h7-Sep-09 2:44

r a m e s h

7-Sep-09 2:44

Use Oracle Data Provider for .NET[^] to connect with Oracle from .NET.

Also refer this link: http://download.oracle.com/docs/html/E10927_01/OracleBulkCopyClass.htm[^]

amittinku7-Sep-09 2:54

How to publish asp.net website in localhost

7-Sep-09 2:54

I think asp.net 2.0 does not support this. I tried but not working.

vasanth arivali7-Sep-09 1:28

vasanth arivali

7-Sep-09 1:28

Hi Friends,

i develop a website using asp.net it work perfectly when i run my application from VS2008.But i want my website as published one ie i want my application to run without VS2008 support.How i publish that and run in IIS Server. please help with your valuable ideas.

regards

Vasanth.A

Re: How to publish asp.net website in localhost

Manas Bhardwaj7-Sep-09 1:33

Manas Bhardwaj

7-Sep-09 1:33

Google suggested me all these [^]articles to do this. Smile | :)

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: How to publish asp.net website in localhost

Arun Jacob7-Sep-09 1:36

Arun Jacob

7-Sep-09 1:36

Publish your website.Add a virtual directory in your IIS and target it to the published content.
Smile | :)

Arun Jacob
http://codepronet.blogspot.com/

Re: How to publish asp.net website in localhost

javeedxp11-Dec-11 2:34

javeedxp

11-Dec-11 2:34

For windowsxp:
open control panel
http://www.no-ip.com/support/guides/web_servers/setting_up_iis.html[^]http://www.no-ip.com/support/guides/web_servers/setting_up_iis.html[^]

Yahoo! cool clickey

Matt Cavanagh7-Sep-09 1:19

Matt Cavanagh

7-Sep-09 1:19

On some sites like yahoo mail when you right click it seems to override the default webbrowser right click menu and show its own html type menu. How do they do this? Im presuming its some javascript ninja'ing?
BTW i put this in the ASP.NET board because I will be doing on an ASP.NET site.

Strive to be humble enough to take advice, and confident enough to do something about it.

Basic XML question

Piya B7-Sep-09 1:01

Piya B

7-Sep-09 1:01

Hi all,

Im getting a soap response from a server. the xml looks like:

  <?xml version="1.0" ?> 
- <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
- <soap:Body>
- <TN_DetailsResp xmlns="http://tempuri.org/">
  <PersNr>2</PersNr> 
  <ProjCode>2</ProjCode> 
  <CardNr>2</CardNr> 
    </TN_DetailsResp>
  </soap:Body>
  </soap:Envelope>

How can i get a single element and display it in a label.
For example how to show the value of 'PersNr' in a label. Im using C#

Manas Bhardwaj7-Sep-09 1:12

Manas Bhardwaj

7-Sep-09 1:12

This is so basic. You should go to Google and sreach for 'Read xml + c#'.

If you do not understand even after that, come back and show us what have you done. Some one would help you.

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Abhishek Sur7-Sep-09 1:30

Abhishek Sur

7-Sep-09 1:30

Are you going to make a Soap Response Parser? Confused | :confused:

I think .NET automatically creates them for you.
You need to Add Web Reference to your project and you will get everything as an Object.
Cool | :cool:

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

N a v a n e e t h7-Sep-09 1:42

N a v a n e e t h

7-Sep-09 1:42

Piya B wrote:
How can i get a single element and display it in a label.

You can do that with XPath *easily*. Load the XML to a XmlDocument class work with SelectSingleNode() method.

string xPath = "/soap:Envelope/soap:Body/dummy:TN_DetailsResp/dummy:PersNr";
XmlDocument document = new XmlDocument();
document.Load("your_xml");
XmlNamespaceManager nm = new XmlNamespaceManager(document.NameTable);
nm.AddNamespace("dummy", "http://tempuri.org/");
nm.AddNamespace("soap", "http://schemas.xmlsoap.org/soap/envelope/");
XmlNode node = document.SelectSingleNode(xPath, nm);
string result = node.InnerText;

XPath is bit tricky here as your XML involves namespaces. dummy is a namespace prefix which I introduced as TN_DetailsResp node doesn't have any prefix.

Hope that helps.

Navaneeth

How to use google | Ask smart questions

Piya B7-Sep-09 1:54

Piya B

7-Sep-09 1:54

Thanks for response N a v a n e e t h,

I got this also by :

XmlDocument doc = new XmlDocument();
                doc.LoadXml(message);
                XmlNodeList persid = doc.GetElementsByTagName("PersNr");
 for (int _i = 0; _i < persid.Count; ++_i)
                {
                    //Response.Write(persid[_i].InnerText);
                                    
                }

Just wondering, what's the difference between this and your solution?