|
Hi To all,
I got the this error in Following Line.
Line: Dim ExcelApp As New Excel.Application()
Error:Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.
I am Using IIS7.0, ASP.NET 2.0, Vista OS
Please Help me Soon...
|
|
|
|
|
It may be permissions. The account running the application pool may not have permissions to open excel.
BTW, if you are not using a pre-formatted spreadsheet then you don't need to use excel...
I didn't get any requirements for the signature
|
|
|
|
|
Thanks for your Replay.
Now, I am Getting Convertion problem in Convert Character Data to Number.
For Example
My Card No is:40563500012124
After convert the Excel Format Now, I am Getting Like This. 4.05635E+15
If I Convert that Cell, I am getting Perfect Result. Please give me the solution....
Thanks
|
|
|
|
|
I have the following coding but when I build it it gives me following error
public static DataFeedEntities2 entities = new DataFeedEntities2();
var type = (from p in entities.Address select p);
this.GridView2.DataSource = type;
this.GridView2.DataBind;
ERROR:-- Only assignment, call, increment, decrement, and new object expressions can be used as a statement
|
|
|
|
|
I would remove public static from the code
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
No it doesn't solve my problem when I remove public static from my code
|
|
|
|
|
then change DataBind; in DataBind();
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
Hi,
I have few controls in table. When I resize the IE these controls are not wrapping.i.e. they will be in single line when I make the IE smaller.
Any idea?
<table id="FilterBar" border="0">
<tr>
<td><select name="_ctl26" id="ddlField" >
<option selected="selected" value="entity_name">Name</option>
<option value="DS_mnem">DS Mnemonic</option>
</select></td>
<td><select name="_ctl26" id="ddlField" >
<option selected="selected" value="entity_name">Name</option>
<option value="DS_mnem">DS Mnemonic</option>
</select></td>
<td><select name="_ctl26" id="ddlField" >
<option selected="selected" value="entity_name">Name</option>
<option value="DS_mnem">DS Mnemonic</option>
</select></td>
<td><select name="_ctl26" id="ddlField" >
<option selected="selected" value="entity_name">Name</option>
<option value="DS_mnem">DS Mnemonic></option>
</select></td>
</tr></table>
|
|
|
|
|
Can you show the code for your table and are you using CSS.
John
|
|
|
|
|
Please find below.
<table id="FilterBar" border="0">
<tr>
<td><select name="_ctl26" id="ddlField" class="control">
<option selected="selected" value="entity_name">Name</option>
<option value="DS_mnem">DS Mnemonic</option>
</select></td><td><span class='controlNameSeparator'></span></td><td><select name="_ctl27" id="ddlCriteria" class="control">
<option value="Contains">Contains</option>
<option value="Equals">Equals</option>
<option value="StartsWith">Starts With</option>
<option value="DoesNotContain">Does Not Contain</option>
</select></td><td><span class='controlNameSeparator'></span></td><td><input name="_ctl28" type="text" id="txtSearchValue" class="border" maxlength="75" onkeydown="return event.keyCode==13?OnExplorerSearchClick():true" /></td><td><span class='controlNameSeparator'></span></td><td><span class="controlLabel">Currency Equals</span></td><td><span class='controlNameSeparator'></span></td><td id="cell1"><select name="_ctl30" id="Currency" style="Z-INDEX:100;" class="controlLabel">
<option value="All">All</option>
<option value="Euro">Euro</option>
<option value="United States Dollar">United States Dollar</option>
</select></td><td><span class='controlNameSeparator'></span></td><td><span class="controlLabel">IBES Equals</span></td><td><span class='controlNameSeparator'></span></td><td id="cell2"><select name="_ctl32" id="IBES" style="Z-INDEX:100;" class="controlLabel">
<option value="All">All</option>
<option value="No">No</option>
<option value="Yes">Yes</option>
</select></td><td><span class='controlNameSeparator'></span></td><td><span class="controlLabel">MSCI Equals</span></td><td><span class='controlNameSeparator'></span></td><td id="cell3"><select name="_ctl34" id="MSCI" style="Z-INDEX:100;" class="controlLabel">
<option value="All">All</option>
<option value="No">No</option>
<option value="Yes">Yes</option>
</select></td><td><span class='controlNameSeparator'></span></td><td><span class="controlLabel">WS Equals</span></td><td><span class='controlNameSeparator'></span></td><td id="cell4"><select name="_ctl36" id="WS" style="Z-INDEX:100;" class="controlLabel">
<option value="All">All</option>
<option value="No">No</option>
<option value="Yes">Yes</option>
</select></td><td><span class='controlNameSeparator'></span></td><td><span class="controlLabel">Exchange Equals</span></td><td><span class='controlNameSeparator'></span></td><td id="cell5"><select name="_ctl38" id="Exchange" style="Z-INDEX:100;" class="controlLabel">
<option value="All">All</option>
<option value="Frankfurt">Frankfurt</option>
<option value="London">London</option>
<option value="NASDAQ">NASDAQ</option>
<option value="New York">New York</option>
<option value="Non NASDAQ OTC">Non NASDAQ OTC</option>
<option value="NYSE Alternext">NYSE Alternext</option>
<option value="OTC Bulletin Board">OTC Bulletin Board</option>
</select></td><td><span class='controlNameSeparator'></span></td><td><input name="_ctl39" type="button" onClick="OnExplorerSearchClick();" value="Filter" onmouseout="MouseOut(this);" onmouseover="MouseOver(this);" class="search" /></td><td><span class='controlNameSeparator'></span></td><td><input name="_ctl40" type="button" onClick="resetFilter();" value="Reset" onmouseout="MouseOut(this);" onmouseover="MouseOver(this);" class="search" /></td>
</tr>
</table>
|
|
|
|
|
A TD is not going to fall below another TD, it is what makes it a table. The TDs are shrinking down to the smallest they can go. As an alternative try using DIV tags I think it will get you a bit closer to what you are looking for.
<div>
<div style="float: left;">
<select name="_ctl26" id="Select1" class="control">
<option selected="selected" value="entity_name">Name</option>
<option value="DS_mnem">DS Mnemonic</option>
</select></div>
<div style="float: left;">
<span class='controlNameSeparator'></span>
</div>
<div style="float: left;">
<select name="_ctl27" id="Select2" class="control">
<option value="Contains">Contains</option>
<option value="Equals">Equals</option>
<option value="StartsWith">Starts With</option>
<option value="DoesNotContain">Does Not Contain</option>
</select></div>
<div style="float: left;">
<span class='controlNameSeparator'></span>
</div>
<div style="float: left;">
<input name="_ctl28" type="text" id="Text1" class="border" maxlength="75" onkeydown="return event.keyCode==13?OnExplorerSearchClick():true" /></div>
<div style="float: left;">
<span class='controlNameSeparator'></span>
</div>
<div style="float: left;">
<span class="controlLabel">Currency Equals</span>
<span class='controlNameSeparator'></span>
<select name="_ctl30" id="Select3" style="z-index: 100;" class="controlLabel">
<option value="All">All</option>
<option value="Euro">Euro</option>
<option value="United States Dollar">United States Dollar</option>
</select></div>
<div style="float: left;">
<span class='controlNameSeparator'></span>
</div>
<div style="float: left;">
<span class="controlLabel">IBES Equals</span>
<span class='controlNameSeparator'></span>
<select name="_ctl32" id="Select4" style="z-index: 100;" class="controlLabel">
<option value="All">All</option>
<option value="No">No</option>
<option value="Yes">Yes</option>
</select></div>
<div style="float: left;">
<span class='controlNameSeparator'></span>
</div>
<div style="float: left;">
<span class="controlLabel">MSCI Equals</span>
<span class='controlNameSeparator'></span>
<select name="_ctl34" id="Select5" style="z-index: 100;" class="controlLabel">
<option value="All">All</option>
<option value="No">No</option>
<option value="Yes">Yes</option>
</select></div>
<div style="float: left;">
<span class='controlNameSeparator'></span>
</div>
<div style="float: left;">
<span class="controlLabel">WS Equals</span>
<span class='controlNameSeparator'></span>
<select name="_ctl36" id="Select6" style="z-index: 100;" class="controlLabel">
<option value="All">All</option>
<option value="No">No</option>
<option value="Yes">Yes</option>
</select></div>
<div style="float: left;">
<span class='controlNameSeparator'></span>
</div>
<div style="float: left;">
<span class="controlLabel">Exchange Equals</span>
<span class='controlNameSeparator'></span>
<select name="_ctl38" id="Select7" style="z-index: 100;" class="controlLabel">
<option value="All">All</option>
<option value="Frankfurt">Frankfurt</option>
<option value="London">London</option>
<option value="NASDAQ">NASDAQ</option>
<option value="New York">New York</option>
<option value="Non NASDAQ OTC">Non NASDAQ OTC</option>
<option value="NYSE Alternext">NYSE Alternext</option>
<option value="OTC Bulletin Board">OTC Bulletin Board</option>
</select></div>
<div style="float: left;">
<span class='controlNameSeparator'></span>
</div>
<div style="float: left;">
<input name="_ctl39" type="button" onclick="OnExplorerSearchClick();" value="Filter"
onmouseout="MouseOut(this);" onmouseover="MouseOver(this);" class="search" /></div>
<div style="float: left;">
<span class='controlNameSeparator'></span>
</div>
<div style="float: left;">
<input name="_ctl40" type="button" onclick="resetFilter();" value="Reset" onmouseout="MouseOut(this);"
onmouseover="MouseOver(this);" class="search" /></div>
</div>
|
|
|
|
|
I can use a session variable in my vbscript but I get an error when I add the following line in the html to reference the code behind file.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>
The error is:
The Session does not exists in the current context.
I want to use the code behind file, so how can I get this error to go away?
|
|
|
|
|
The class Default3 in the file Default3.aspx.cs should be inherited from System.Web.UI.Page class. If not, you will get this error.
|
|
|
|
|
That is code that the VS designer automatically wrote. Do you mean I have to change it?
|
|
|
|
|
I tought you had fixed your problem
Why dont you paste your code? Maybe some could help you
If it was working and then after adding that line its not
The problem could be with your class
Why dont you add a new page (select the option to use the code behind page)?
Alexei Rodriguez
|
|
|
|
|
Below is the html and code behind I'm working on.
The error I get is "The Session does not exists in the current context."
The error is referring to this session variable in the code: Session("DocumentFile")
If I remove this line the error goes away but I need my code behind file.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>
<title>Office Viewer Component Demo - EdrawSoft
#OA1
{
height: 750px;
width: 1000px;
}
Sub OpenFromServer()
On Error Resume Next
OA1.Open <% =Session("DocumentFile") %>
End Sub
Sub NotifyCtrlReadyEvent()
End Sub
NotifyCtrlReadyEvent()
OpenFromServer()
<asp:button id="Button1" runat="server" onclick="Button1_Click" text="Button">
|
<object classid="clsid:6BA21C22-53A5-463F-BBE8-5CF7FFA0132B" id="OA1"
="" codebase="http://www.ocxt.com/download/officeviewer.cab#5,6,578,1">
<param name="BorderColor" value="-2147483632" />
<param name="BackColor" value="-2147483643" />
<param name="ForeColor" value="-2147483640" />
<param name="TitlebarColor" value="-2147483635" />
<param name="TitlebarTextColor" value="-2147483634" />
<param name="BorderStyle" value="1" />
<param name="Titlebar" value="0" />
<param name="Toolbars" value="1" />
<param name="LicenseName" value="<Company Name>" />
<param name="LicenseKey" value="<Product License Key>" />
<param name="Menubar" value="1" />
<param name="ActivationPolicy" value="1" />
<param name="FrameHookPolicy" value="1" />
<param name="MenuAccelerators" value="1" />
| | | | |
Code behind:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Default3 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
|
|
|
|
|
I found the problem. If I change Session("DocumentFile") to Session["DocumentFile"] everything works great!
|
|
|
|
|
Thats right
You were using vb syntax to access the session Session("name")
And in your code is c#
Alexei Rodriguez
|
|
|
|
|
Hi,
In my application am using repater control of item template hyperlink button in one page. i want to navigate another page when i click the link butoon through code behind. plz give me reply.
|
|
|
|
|
If you want to navigate in code behind, use a link button, because a hyperlink, is going to navigate without any sort of postback.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
sqlstr = "select country , city FROM tbl_data WHERE RID in( " & ID & ") "
dr = ''''''''''''''''''''exexuting the reader
Ifdr.HasRows Then
Whiledr.Read
Dim datacountry =dr("country").ToString.Trim
Dim datacity =dr("city").ToString.Trim
MsgBox(datacountry & "===" & datacity)
sqlstr = "SELECT user FROM tbl_info " _
& " WHERE country='" & drpcountry.SelectedItem.Text & "' AND city='" & drp city.SelectedItem.Text & "'"
dr = ''''''''''''''''''''exexuting the reader
Ifdr.HasRows Then
Whiledr.Read
sqlstr = "IF EXISTS (SELECT user, country, city FROM tbl_info " _
& " WHERE user='" &dr("user").ToString.Trim & "'" _
& " AND country='" & datacountry & "' AND city='" & datacity & "')" _
& " UPDATE tbl_info set user='" &dr("user").ToString.Trim & "' " _
& " WHERE user='" &dr("user").ToString.Trim & "' AND country='" & datacountry & "' AND city='" & datacity & "' " _
& " Else " _
& " INSERT INTO tbl_info(user,country, city) " _
& " VALUES ('" &dr("user").ToString.Trim & "','" & datacountry & "','" & datacity & "')"
''''''''''exexuting the query........
End While
End If
End While
End If
but in this only the first record from the country and city gets affected.
all the records obtained in the reader shld get affected
how do i rectify it
|
|
|
|
|
Have you ever used a debugger ?
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
From you code, it seems that the SqlDataReader variable 'dr' is re-builds again within the first while loop.
Use another variable for inner data reader.
|
|
|
|
|
I was hoping to instead teach him how to debug his own code, one run through in the debugger should have told him what was wrong.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
I have something of a time issue, and I need to deliver a very basic, early edition of a web site within the next two days or so. I would like to have at least:
Three horizontal 'bands':
1) a flagship photo and some text at the top
2) a horizontal photo-film (with sprocket holes etc.) underneath that, with frames containing one photo for each of several categories, where clicking one opens a set of photos in the category in the bottom band
3) a bottom band containing pages of photos for a chosen category.
I would appreciate some suggestions on the quickest and easiest way to achieve this using ASDP.NET 'dirty tricks' and technologies. I think a DataList for the film strip and bottom band will be quickest, but how can I achieve the 'sprocketed frame' look quickly?
You really gotta try harder to keep up with everyone that's not on the short bus with you.
- John Simmons / outlaw programmer.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
