ASP.NET

Error opening Word Document in Asp.Net

21-Apr-09 0:44

Set the Target[^] property of HyperLink to _blank

Navaneeth

How to use google | Ask smart questions

vyasdev200921-Apr-09 0:12

vyasdev2009

21-Apr-09 0:12

I am trying to opening Word file in asp.net application. I Try Following Code For That,

Private oWordAppl As Word.Application
Private oDoc As Word.Document
Public Sub New()
oWordAppl = New Word.Application
End Sub
Public Sub Open(ByVal strfileName As String)
Dim fieName As Object = strfileName
Dim readOnly1 As Object = False
Dim isVisible As Object = True
Dim missing As Object = System.Reflection.Missing.Value

oDoc = oWordAppl.Documents.Open(fieName, missing, readOnly1, missing, missing, missing, missing, missing, missing, missing, missing, isVisible)
oDoc.Activate()
End Sub

And this code for Opening file,

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
Dim Test As New WordAppl
Dim TamplatePath As String = ConfigurationManager.AppSettings("WordMod")
Dim DocumentPath As String = ConfigurationManager.AppSettings("WordDoc")
Test.Open(TamplatePath & "Test.Doc")
Test.SaveAs(DocumentPath & "Test.Doc")
Test.Open()
End Sub

All this works fine in View In Browser, But when I publish that Page The file not opening and on Click of Button, Browser running continuosly, but cant find file.

Please Help ME out,
Thanks.....

Re: Error opening Word Document in Asp.Net

Ashfield21-Apr-09 1:46

Ashfield

21-Apr-09 1:46

Try stepping through in debug and see what is happening, thats the easiest way of fixing it.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Unable to Fix The hight of Table cotrol in Report viewer (RDLC)

Member 226432921-Apr-09 0:10

Member 2264329

21-Apr-09 0:10

Hi I have made a report to print a Bill. every thing is working properly but Hight of Table varries according to the no of items.

I m putting Partnos , description , qty, rate, total in TABLE BODY section.

I have used footer section of TABLE control for tax and total amount display.

I have fixed 8 rows/ page.

when 8 rows r in report Tax comes at right place but when 2 or 3 rows r thier then Tax section comes immediatly after item rows.

I want it to come at fix place.

PLease help me out this problem.

Thanks in advance.............

amitendra

IIS and Tomcat

jchandramouli20-Apr-09 22:46

jchandramouli

20-Apr-09 22:46

Hi,

Consider two websites hosted in different services:
Web X (Hosted in IIS)
Web Y (Hosted in Tomcat)

I have made a successful integration between tomcat and iis using isapi_redirector. Now, i can access the Web Y through IIS. How can we connect web X with web Y? Like how can i access the site (Y) using site (X) through IIS.

Thanks.

Import data from excel cell to Textbox

samsonx20-Apr-09 21:58

samsonx

20-Apr-09 21:58

Hi,

I have an excel containing mail address For example: In excel "column B" i have a number of email address in B1,B2,B3.... Now the thing i want each email address from B1,B2,B3 into my TextBox1.Text.

Am using vb.net with c# language.

Can anyone send me the code or give me some idea?. Thanks in advance.

With Regards,
Samson

Re: Import data from excel cell to Textbox

Greg Chelstowski21-Apr-09 0:28

Greg Chelstowski

21-Apr-09 0:28

If your spreadsheet is structured as a table in a database would be, you can use OleDb to connect to it, select the Column you want (select [column b] from $Sheet1), and then iterate through the collection to put stuff in the TextBox.

private void ConnectToExcel(string Location)
{
string ConnectionStr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended properties=\"Excel 8.0;HDR=YES\"", Location);
            try
            {
                OleDbConnection Connection = new OleDbConnection(ConnectionStr);

                Connection.Open();
                           
                string SelectString = "select [column b] from $Sheet1";
                OleDbCommand Command = new OleDbCommand(SelectString, Connection);
                 OleDbDataReader olDbRead = Command.ExecuteNonQuery();

                while (olDbRead.Read)
                {
                    textBox1.Text += olDbRead[0].ToString();
                }

                
                
            }
            catch{}
            finally{Connection.Close();}
}

samsonx wrote:
Am using vb.net with c# language.

Well you lost me here...

var question = (_2b || !(_2b));

Re: Import data from excel cell to Textbox

krishna_goluguri7-Jul-10 23:27

krishna_goluguri

7-Jul-10 23:27

hi weather this code works perfectly or not i don't know bcoz when i wanted to use oledb connection for excel sheet my program didnt accept that one.it says it as unrecognized format.how to connect excel sheet using oledb connection plz explain step by step.

Unable to cast COM object of type 'Word.ApplicationClass' to interface type 'Word._Application'.

abyvjohnmca20-Apr-09 21:21

abyvjohnmca

20-Apr-09 21:21

I am dealing with word automation in asp.net 2.0 and when i am debugging my web application in VS in XP OS it is quite fine running. Then I deployed this site into server (OS is Windows 2000 advanced server) where I met with problem. So I installed VS 2005 in this server and I debugged where I got this error..
Unable to cast COM object of type 'Word.ApplicationClass' to interface type 'Word._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{00020970-0000-0000-C000-000000000046}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)).
If anyone helps to solve my problem that would be appreciable as I have been struggling with this problem for last week.
I have office 2000 premium in my server machine as well.

I give my coding part also here,

public class WordApp
{

private Word.Application oWordAppl;

private Word.Document oDoc;

public WordApp()
{

oWordAppl = new Word.Application();

}

public Word.Document Open(string strFileName)

{
try
{

object fileName = strFileName;

object readOnly1 = false;

object isVisible = true;

object missing = System.Reflection.Missing.Value;

oDoc = (Word.Document)oWordAppl.Documents.Open(ref fileName, ref missing, ref readOnly1,
ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref isVisible);
/*Above line i am gettin error {"Unable to cast COM object of type 'Word.ApplicationClass' to interface type 'Word._Application'.
This operation failed because the QueryInterface call on the COM component for the interface with IID
'{00020970-0000-0000-C000-000000000046}' failed due to the following error: Library not registered.
(Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))."}
*/

}
catch (Exception ex)
{
throw ex;
}
finally
{
//object missing = System.Reflection.Missing.Value;
//oWordAppl.Documents.Close(ref missing, ref missing, ref missing);
}

return oDoc;

}
}

How we can fetch a textbox value when an enter key is pressed ?

Masood Kochi,SSF20-Apr-09 21:15

Masood Kochi,SSF

20-Apr-09 21:15

Textbox firing when an Enter key is Pressed....giv me a solution dat worked in both iexplorer and firefox.

Thankz in advance.

Re: How we can fetch a textbox value when an enter key is pressed ?

N a v a n e e t h20-Apr-09 21:57

Re: How we can fetch a textbox value when an enter key is pressed ?

20-Apr-09 21:57

Masood Kochi,SSF wrote:
Textbox firing when an Enter key is Pressed

Firing what? Your question is not clear. Please rephrase it.

Smile | :)

Navaneeth

How to use google | Ask smart questions

jai_10121-Apr-09 1:42

jai_101

21-Apr-09 1:42

You can write the JavaScript Code and Get the Value of TextBox

<asp:textbox id="txt" onkeypress="CheckEnter_Onclick(event)" runat="server" xmlns:asp="#unknown">

---- This is Javascript Function that show the Value of Textbox in alert Box when Enter Key is Pressed--------------

function CheckEnter_Onclick(e)
{
var key;
key=(e.which) ? e.which : e.keyCode;
if(key==13)
{

var x= document.getElementById('<%=txt.ClientID %>').value;
alert(x);

}
return true;
}

view html source code - asp.net

Manish Thaduri20-Apr-09 20:35

20-Apr-09 20:35

the user enters an url , and i want to get the html source code of that webpage(url) on button click. can we get the solution using innerHTMl ??? any ideas ??

N a v a n e e t h20-Apr-09 20:39

20-Apr-09 20:39

Work with WebClient.DownloadString()[^] method.

Navaneeth

How to use google | Ask smart questions

[Message Deleted]

Manish Thaduri20-Apr-09 20:42

20-Apr-09 20:42

[Message Deleted]

N a v a n e e t h20-Apr-09 20:56

20-Apr-09 20:56

Manish Thaduri wrote:
can u be more specific. temme what exactly i hve to do..

Have you tried that suggestion? Spoon feeding is bad and we don't do it here. I have given you the class and method you need to work with. Look at the method's documentation and learn how to use it. If you face any issues, come back with specific questions. If you are not understanding the MSDN documentation and sample provided, you need to take a book and improve your knowledge.

Smile | :)

Navaneeth

How to use google | Ask smart questions

[Message Deleted]

Manish Thaduri20-Apr-09 21:06

20-Apr-09 21:06

[Message Deleted]

N a v a n e e t h20-Apr-09 22:19

20-Apr-09 22:19

Manish Thaduri wrote:
so i need to pass the proxy ip,port no, username , password etc. and im working on it.. but cudnt resolve it !!

As I said, go with WebClient class. It is the easiest one. Use the WebProxy[^] class and set it to WebClient.Proxy property.

Smile | :)

Navaneeth

How to use google | Ask smart questions

[Message Deleted]

Manish Thaduri20-Apr-09 22:45

20-Apr-09 22:45

[Message Deleted]

N a v a n e e t h20-Apr-09 23:46

20-Apr-09 23:46

Manish Thaduri wrote:
I need to use internet explorer object,shdocvw.dll & innerHTML !!

Your user is entering the required URL in text box and you need to get the HTML of that page on button click, right? If yes, WebClient or any request/response classes is the way to go. Alternatively, you can use JS and send AJAX request to the page. Get the response and read values from it. InnerHTML may work in this scenario(I haven't tried it). But I'd suggest the webclient rather than JS.

Navaneeth

How to use google | Ask smart questions

Disable the Back button from Browser

Ashfield21-Apr-09 1:50

Ashfield

21-Apr-09 1:50

I think the main problem is that you obviously have many missing keys on your keyboard - or you are sending in your posts by txt msg

There is no charge for using full words Smile | :)

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Sharepint connector

Ch.Gayatri Subudhi20-Apr-09 20:20

Ch.Gayatri Subudhi

20-Apr-09 20:20

hi.......
how to use sharepoint connector to link excel and powerpoint in web as well as windows..using c#.net.If somebody knows some sample site plz help me out.Thanks in advance

Thanks and Regards
Ch.Gayatri Subudhi

sekannak20-Apr-09 19:59

sekannak

20-Apr-09 19:59

Hi All,

How to (Stop/Disable) back button click from browser (IE/Firefox) after signout of my application. If any one of you knows plz respond me...

kannak

Re: Disable the Back button from Browser

N a v a n e e t h20-Apr-09 20:05