Hello All,
I need to read a Excel file to Import that data into the database. I can read it When Excel data Is In Tabular Form, but here, Excel data is in Random cells Format.
So, Will you please tell me, how to read excel's cell's value..
Thanking You
Manesh Pawar
Last Activity: Nov 25 '10, 11:24 AM
Joined: Sep 25 '10
Location: Mumbai
-
How to Read Excel File using Excel Object????
-
How To Read Sheet Name Of uploaded excel File
Hello,
I a now Porting a data from Uploaded Excel File to database. In that, I need to check "Sheet name" Of that Excel file Whether it is Sheet1 or Sheet2 or something else...
Will You Please Tell Me how to Check/Read Excel Sheet name at runtime..
Thanking you -
Ok.
Thank you -
Ok Thank you, SirLeave a comment:
-
How to messege box in ASP.net C#?
Hello,
In my project, I need to inform user about his activity using messege box.
But i am not getting the way how to show messege box in asp.net.
please help me...
thanking you -
How Export Data from Access to Excel randomly?
Hello,
I want to Export data from ms-Access to Excel. I know the way, How to export data in tabular form.
But i need to export data to the random cell of sheet,and print it.
I got Solution Of How the access data can be export to the excel in particular cell.but i also need porting data form excel to access database. Means i want to get the value of particular cell, and save it into access database. ...Last edited by Frinavale; Feb 10 '11, 02:08 PM. -
Yes Sir, I will Fit it into my mind.
I am Using MS-access. Is There Any Problem With MS-Access database in case of concurrency?Leave a comment:
-
Manesh Pawar replied to Solution for Object reference Not set to an instance in asp.net while filling datasetin ASP .NETOokkk!! Realy Thanks For The Help.Leave a comment:
-
Executereader requires an open and available connection
Hello,
I m getting an error "System.Invalid OperationExcept ion - Executereader requires an open and available connection"
I have Open an Connection, but still it throughs an Error. But it occurs Sometimes..
Following is the code,
...Code:if (con == null) con = new OleDbConnection("" + StrConnection); if (con.State == ConnectionState.Closed) -
Manesh Pawar replied to Solution for Object reference Not set to an instance in asp.net while filling datasetin ASP .NETHello,
Now I m Getting same error at
Exception Details: System.NullRefe renceException: Object reference not set to an instance of an object.
Source Error:
...Code:if (con == null)//Line 1598: { //Line 1599: con = new OleDbConnection("" + StrConnection); //Line 1600: }//Line 1601: if (con.State == ConnectionState.Closed) //Line 1602: con.Open(); //Line 1603:Last edited by Frinavale; Sep 28 '10, 01:27 PM. Reason: Please post code in [code] ... [/code] tags. Added code tags.Leave a comment:
-
Manesh Pawar replied to Solution for Object reference Not set to an instance in asp.net while filling datasetin ASP .NETThank You sir, It will realy Help me.Leave a comment:
-
Hello Sir,
Thanx
Actualy i hav a single database connection used in application, And I m facing the same problem of Opening/ Closing Connection. But It occurs sometimes, and sometimes it Works.
I am using "static OledbConnection con;" and it is being used in all functions
What should I do To fix that problem? and When Should I open/ Close Connection?Leave a comment:
-
Manesh Pawar replied to Solution for Object reference Not set to an instance in asp.net while filling datasetin ASP .NETHello Nitin,
Following is the Code,
i m getting error while checking conditionCode:if (Session["UserName"].ToString() != null) Response.Redirect("~/AspX/Account.aspx?ShowMenu=No");
But Whenever i Replace "Session["UserName"].ToString()" with "(string)Session["UserName"]", it works
What could b the problem
...Last edited by Frinavale; Sep 27 '10, 02:21 PM. Reason: Please post code in [code] ... [/code] tags. Changed bold tags into code tags and added inline code tags.Leave a comment:
-
How Oledb connection should be Declared
Hello
I m new in asp.net c#.
How to declare a oledbconnection object in asp.net c#.
Means should it be declared as a static or public?
ex:- suppose the object is
OleDbConnection con;
Whether it should be
static OleDbConnection con;
Or
public OleDbConnection con;Last edited by Frinavale; Sep 27 '10, 02:22 PM. Reason: Fixed formatting and added inline code tags. -
Manesh Pawar started a topic Solution for Object reference Not set to an instance in asp.net while filling datasetin ASP .NETSolution for Object reference Not set to an instance in asp.net while filling dataset
Heloo, I m working on ASP.net2.0
I m facing an error like "Object reference Not set to an instance" while filling dataset
wht will b the Solution for this error?
No activity results to display
Leave a comment: