|
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));
|
|
|
|
|
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.
|
|
|
|
|
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;
}
}
|
|
|
|
|
Textbox firing when an Enter key is Pressed....giv me a solution dat worked in both iexplorer and firefox.
Thankz in advance.
|
|
|
|
|
Masood Kochi,SSF wrote: Textbox firing when an Enter key is Pressed
Firing what? Your question is not clear. Please rephrase it.
|
|
|
|
|
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;
}
|
|
|
|
|
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 ??
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
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.
|
|
|
|
|
|
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.
|
|
|
|
|
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
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
I suggest you to search this forum because this question gets asked almost daily. If you are so lazy to find where to search, click here[^].
|
|
|
|
|
Use this java script in you .aspx file
window.history.forward(1);
|
|
|
|
|
use window.history.forward(1) in javascript.
Prince
Team Lead
Quest Solutions
www.imaginethinkact.com
|
|
|
|
|
how to redirect pages with the help of link bottons
|
|
|
|
|
shabsk wrote: how to redirect pages with the help of link bottons
That's a basic stuff. Just write Response.Redirect("pagename") in the link button's click event handler.
|
|
|
|
|
That's simple. Just use 'Response.Redirct("xxx.aspx", false)'.
|
|
|
|
|
Hi,
By using
Response.Redirect("ur URL")
and
server.transfer("ur URL")
S Kumar
|
|
|
|
|
Hi, I would like to know how to call a stored procedure from asp.net ?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
