QueryInterface for interface Microsoft.Office.Interop.Excel._Application failed - ASP.NET Discussion Boards

First Prev Next

Re: How do I select column from datagrid?

wilssmith5-Jul-06 22:32

wilssmith

5-Jul-06 22:32

in the data grid properties make the column as the template column and then add check box inside...

Re: How do I select column from datagrid?

blurMember5-Jul-06 22:40

blurMember

5-Jul-06 22:40

How should I add the check box with the datagrid.

thanks in advance. Much appreciated.

Re: How do I select column from datagrid?

_AK_5-Jul-06 22:44

_AK_

5-Jul-06 22:44

here you will get lot of examples on datagrid.
http://www.datagridgirl.com/articles.aspx

Best Regards,
Apurva Kaushal

Re: How do I select column from datagrid?

blurMember5-Jul-06 23:08

blurMember

5-Jul-06 23:08

Thanks. I recall knowing that website through this forum. You reminded me. I hope I will find something useful.

thanks in advance. Much appreciated.

Re: How do I select column from datagrid?

Vipin Venugopal5-Jul-06 22:39

Vipin Venugopal

5-Jul-06 22:39

use the code i had mentioned earlier. store that value to a string and the u can use that anywhere u want to.

stringVariable = dataGridView.Rows[index].Cells[index].Value.toString();

Here U give the index of the cell thats is if u want the first cell give as 1 or if u want the second then give it as 2 etc etc.

stringVariable = dataGridView.Rows[index].Cells["ColumnName"].Value.toString();

Here U give the name of the column of the grid

Vipin

Re: How do I select column from datagrid?

blurMember5-Jul-06 22:48

blurMember

5-Jul-06 22:48

My problem earlier was, "how do I select certain column and its data, then pass or transfer it to another page".
Is this method correct? To tell you the truth, its my six week in learning C#.

dataGridView refers to the dgDisplay is it?

thanks in advance. Much appreciated.

Re: How do I select column from datagrid?

Vipin Venugopal5-Jul-06 23:59

Vipin Venugopal

5-Jul-06 23:59

for selecting the entire row create a new tempelate column and add a select button in the created tempelate column.Give a command name "Select" for that button in its properties.end the templelate editing. select the event properties of the grid. go to command name event. give this event as datagrid_commandname. it will take u to the code behind.
give the code as
if(e.CommandName="Select");
{
//write the code i had suggested before;
}
this will help u.

Vipin

QueryInterface for interface Microsoft.Office.Interop.Excel._Application failed

kavithapuranik5-Jul-06 20:39

kavithapuranik

5-Jul-06 20:39

Hi,

im developing a web application using vb.net,where in im creating an excel sheet ,fillin the cells and saving it,
im using windows 2000,and i have installed office 2003.
in my application i have added reference to Excel and microsoft.office.core

in the code ,im using
Imports Excel = Microsoft.Office.Interop.Excel

and in page load ,i have wriiten

Dim excelobj As New Excel.Application
    Dim xlBook As Excel.Workbook
    Dim xlsheet As Excel.Worksheet
    Dim i As Int32

  Dim xlApp As Excel.Application
        Dim xlBook As Excel.Workbook
        Dim xlSheet As Excel.Worksheet
        xlApp = CreateObject("Excel.Application")
        xlBook = CType(xlApp.Workbooks.Add, Excel.Workbook)
        xlSheet = CType(xlBook.Worksheets(1), Excel.Worksheet)

        xlSheet.Cells(2, 2) = "This is column B row 2"
        xlSheet.Application.Visible = True
        xlSheet.SaveAs("C:\Test.xls")
        xlApp.Quit()
        xlApp = Nothing

im not getting any error when i compile ,but during execution,i get
"QueryInterface for interface Microsoft.Office.Interop.Excel._Application failed."

Exception Details: System.InvalidCastException: QueryInterface for interface Microsoft.Office.Interop.Excel._Application

failed.

Execption occurs here
xlBook = CType(xlApp.Workbooks.Add, Excel.Workbook)

pls help to solve this error

thanks

kavitha

-- modified at 2:57 Thursday 6th July, 2006

Re: QueryInterface for interface Microsoft.Office.Interop.Excel._Application failed

RichardGrimmer6-Jul-06 1:25

RichardGrimmer

6-Jul-06 1:25

Actually, I'd suggest that it's failing when you try to instantiate the Application object. QueryInterface is a COM call that returns the interfaces avail for a COM Obj. Looks like somewhere it's trying to cast it to an invalid type (needs to be IUnknown)

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

processes running in remote system

mehnazash5-Jul-06 20:35

mehnazash

5-Jul-06 20:35

hi,

we can get processes runnug in ones macine using getprocess()
can someone help me to get process running in remote machine
if we use getprocess(), an eror is displyed saying access denied
anybody, anythought of how to get over it??

Thanks
Jiny

How can i get the list of Email clients installed on my computer

sharma sanjeev5-Jul-06 20:32

sharma sanjeev

5-Jul-06 20:32

Hi I want to show a list of Email clients installed on my computer in a list box........can any one help me out to get that list ..........veryyyyyyyyy urgent...i hope this is doable in .net.......

pls reply if u hav any idea or read any article.. pls give link

thanks in advance

happy coding

sanjeev sharma

Generating HTML FROM XML File

King Shez5-Jul-06 20:25

King Shez

5-Jul-06 20:25

HI

I have got the data from CSV file with the help of query in DataSet then from dataset writeXML method i have made the XML File , now i want to Convert this File to HTML.I know i have to do this by XSLT , can any one let me know the solution ASAP , thankx in advace,please guys do remember i have made the XML File from DataSet write XML Method.

Re: Generating HTML FROM XML File

King Shez5-Jul-06 22:06

King Shez

5-Jul-06 22:06

Guys its urgent i have to display the XMl file in HTML format nad i have made the XML File from DataSet ,please reply me ASAP ,
regards,
tippu

Re: Generating HTML FROM XML File [modified]

DIMPLE_R5-Jul-06 22:48

DIMPLE_R

5-Jul-06 22:48

Hi,
Refer to the following example and see if it helps with your code:

Myxml.xml:-
<?xml version="1.0" ?>
<?xml-stylesheet type="text/xsl" href="Myxsl.xsl" version="1.0"?>
<NewDataSet>
<Row>
<customerID>8</customerID>
<customerName>Wily Widgets</customerName>
</Row>
<Row>
<customerID>9</customerID>
<customerName>Willy Wonka</customerName>
</Row>
</NewDataSet>

Myxsl.xsl:-
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html"/>
<xsl:template match="/NewDataSet">
<HTML>
<BODY>
<TABLE border="1" cellspacing="2" cellpadding="1" width="100%">
<TR >
<xsl:for-each select="Row">
<TD><xsl:value-of select="customerID"/></TD>
<TD><xsl:value-of select="customerName"/></TD>
<TR></TR>
</xsl:for-each>
</TR>
</TABLE>
</BODY>
</HTML>
</xsl:template>
</xsl:stylesheet>

Create the above 2 files and view the Myxml.xml in the browser ...See if this example helps you with your problem

--Dimple

-- modified at 4:49 Thursday 6th July, 2006

Re: Generating HTML FROM XML File

King Shez6-Jul-06 5:20

King Shez

6-Jul-06 5:20

Thankx Dimple it was easy but i didn't know abt it thankx once again

sharepoint for win xp

mehnazash5-Jul-06 20:04

mehnazash

5-Jul-06 20:04

Hi Is any version of sharepoint compatible with Windows xp?

please suggest some link where from can i get the installable

Thanks
jiny

Re: sharepoint for win xp

minhpc_bk5-Jul-06 20:51

minhpc_bk

5-Jul-06 20:51

mehnazash wrote:
Is any version of sharepoint compatible with Windows xp?

No, you'll need Windows Server OS to install. If Windows XP is currently running on your box, you can install a Virtual PC with Windows Server, then install SharePoint.

SharePoint Portal System Requirements[^]

Recieve Mails in Asp.Net

venkatasivaramaprasad5-Jul-06 19:26

venkatasivaramaprasad

5-Jul-06 19:26

Can any body tell how to do recieving mails concept in Asp.Net. Thanks in advance

Thanks and Regards

Venkat

Re: Recieve Mails in Asp.Net

Socheat.Net5-Jul-06 22:03

Socheat.Net

5-Jul-06 22:03

What do you need?

................

Re: Recieve Mails in Asp.Net

venkatasivaramaprasad6-Jul-06 23:18

venkatasivaramaprasad

6-Jul-06 23:18

i want to build an application to recieve mails in asp.net

Thanks and Regards

Venkat

Re: Recieve Mails in Asp.Net

Socheat.Net6-Jul-06 23:30

Socheat.Net

6-Jul-06 23:30

Yes
This is example
<%@ Import Namespace="System.Web.Mail" %>
Dim objEmail as New MailMessage()
objEmail.To ="webmaster@khmerfriend.com"
objEmail.From = txtEmail.Text
objEmail.BodyFormat = MailFormat.HTML
objEmail.Body = "Re:"
objEmail.Priority = MailPriority.High
SmtpMail.SmtpServer = "localhost"
Try
SmtpMail.Send(objEmail)
lblSuccess.Text="Your email has been sent successful."
Catch ex As Exception
lblSuccess.Text="Sending failed " & ex.Message
End Try
End Sub

................

Interfaces in the vb.net 1.1

amaneet5-Jul-06 18:41

amaneet

5-Jul-06 18:41

i wanted to create an interface in the vb.net 1.1.But I don't know the utility of interfaces. Can somebody please tell the application for using the interfaces in the vb.net 1.1.
Thanks Smile | :)

need urgent help

nauty5-Jul-06 18:27

nauty

5-Jul-06 18:27

hi buddies
my problem is that i've to make a web application in which the server sends the request to the client and as the message reaches the client a pop up should come.
i am getting no idea about it.i thought of something related to chat server program but i did'nt found any program which is in asp.net.

kindly help me out as soon as possible.
Thanks in advance .
bye

nauty

Re: need urgent help

Vasudevan Deepak Kumar5-Jul-06 18:58

Vasudevan Deepak Kumar

5-Jul-06 18:58

You can have a IFRAME that keeps sending a META HttpEquiv Refresh Request to a particular page on the server.

This page can send the Alert message to the client.

Vasudevan Deepak Kumar
Personal Homepage
namespace LavanyaDeepak
Personal Weblog
The World of Deepak and Lavanya
Views and Reviews

Re: need urgent help

Muhammad Chitrali5-Jul-06 21:03

Muhammad Chitrali

5-Jul-06 21:03

There are many POP UP Menus programs in this website. you can download any such popup program and then connect it in your original project A/C to your need

aLi

Last Visit: 31-Dec-99 18:00 Last Update: 7-Jun-24 23:27

Refresh

ᐊ Prev 1...6105 6106 6107 610861096110 6111 6112 6113 6114 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.