ASP.NET Discussion Boards

Import data from Excel sheet to sql Database-asp.net 2.0

Member 46590012-Mar-09 1:26

2-Mar-09 1:26

Currently I need to write a code To Import data from Excel sheet to sql Database-asp.net 2.0

I Have Written A function For It
Function Is Given Below ;
But as i execute it it gives Error Meaasge
"The Microsoft Jet database engine cannot open the file 'D:\'. It is already opened exclusively by another user, or you need permission to view its data."

I Have Order.xls File In D Drive

protected void btnUpload_Click1(object sender, EventArgs e)
{
string PathtoTextFile = ("D:\\");
Response.Write(PathtoTextFile);
System.Data.OleDb.OleDbConnection oCon = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\;Extended Properties= \"Excel 8.0;HDR=no;IMEX=1 \"");
System.Data.OleDb.OleDbDataAdapter oCmd = new System.Data.OleDb.OleDbDataAdapter("select * from Order.xls", oCon);

DataSet myDS = new DataSet();
oCmd.Fill(myDS);

oCon.Close();

}

Raghvendra

Re: Import data from Excel sheet to sql Database-asp.net 2.0

Greg Chelstowski2-Mar-09 1:34

Greg Chelstowski

2-Mar-09 1:34

You need to pass the filename in the data source, in the connection string, dude.
You're on the right path, though.
And then, the sql you wrote ("select * from Order.xls") should really be ("select * from Sheet1"), or whatever your Sheet is called in that excel spreadsheet.
The rest seems fine... Except I would use a DataTable, and not a DataSet.
Easier that way Wink | ;)

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

Re: Import data from Excel sheet to sql Database-asp.net 2.0

Member 46590012-Mar-09 18:09

Member 4659001

2-Mar-09 18:09

Thanks For Reply,
I did the same as u instructed ,
But Still Having Same Error

Raghvendra

Method?

Karthick_gc2-Mar-09 1:05

Karthick_gc

2-Mar-09 1:05

I declare a variable in one method and used it. Now i want to access the variable from another method. Can anyone say how to acheive this?

Re: Method?

Gaurav K Singh2-Mar-09 1:13

Gaurav K Singh

2-Mar-09 1:13

Variable within the method is private for that method. if you want to access one variable in more than one mthod, declase as private/public in the class.

The miracle is this--the more we share, the more we have.

Re: Method?

Karthick_gc2-Mar-09 1:23

Karthick_gc

2-Mar-09 1:23

Can u explain briefly?

Re: Method?

mr_muskurahat2-Mar-09 1:26

mr_muskurahat

2-Mar-09 1:26

public string abc;

public void function function1()
{

abc="anything";

}

public void function function2()
{

string def =abc;

}

function1();
function2();

or you can also pass it as a parameter...

umerumerumer

How to export data from datagrid to .mdb format

ballameharmurali2-Mar-09 0:21

ballameharmurali

2-Mar-09 0:21

Hi all,
Can anybody tell how to export data from datagrid to .mdb format(i.e into Access format).If possible please let me know the code.
thanks
Murali

Re: How to export data from datagrid to .mdb format

Greg Chelstowski2-Mar-09 0:48

Greg Chelstowski

2-Mar-09 0:48

Read up on the JET engine, please.
And stop posting the same question over and over again.
The JET engine will allow you to create a new ACCESS database (among other formats) and populate it with whatever you want. It is really easy to use, but:
you haven't posted a single line of code. Don't assume people are waiting to write stuff for you, look it up yourself! And even if they do, how can anybody assume, what you get will be comprehensible by you.
Good luck in your research.

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

the state information is invalid for this page and might be corrupted.

NidhiKanu1-Mar-09 23:31

NidhiKanu

1-Mar-09 23:31

whgen i load one page i got this error on post back

the state information is invalid for this page and might be corrupted.

N!dh! Smile | :)

Re: the state information is invalid for this page and might be corrupted.

Vimalsoft(Pty) Ltd1-Mar-09 23:38

Vimalsoft(Pty) Ltd

1-Mar-09 23:38

This is Not funny anymore. Really you gonna have to Google First before you post. i took your Error and posted it on Google, the results i found were so amazing.

http://support.microsoft.com/kb/812399[^]

http://www.stevetrefethen.com/blog/FixingASPNETErrorTheStateInformationIsInvalidForThisPageAndMightBeCorrupted.aspx[^]

http://support.microsoft.com/default.aspx?kbid=831150[^]

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za

Re: the state information is invalid for this page and might be corrupted.

NidhiKanu2-Mar-09 0:04

NidhiKanu

2-Mar-09 0:04

Hi,

I have already gone through all these but couldn't find solution so i pst it here.

N!dh! Smile | :)

Re: the state information is invalid for this page and might be corrupted.

Vimalsoft(Pty) Ltd2-Mar-09 0:08

Vimalsoft(Pty) Ltd

2-Mar-09 0:08

Have you seen this

http://chiragrdarji.blogspot.com/2007/04/http-405-resource-not-allowed-error-in.html[^]

http://forum.parallels.com/showthread.php?t=85150[^]

?

file have to save on existing file name...,

Member 38798811-Mar-09 23:26

Member 3879881

1-Mar-09 23:26

Hi in my folder i have a file...,

That fiel name is file1.doc...,

now i have to upload a file...,

the file have to save on that existing same file name...,

mean suppose if i upload the test.doc the file have to save as file1.doc...,

how to do this?,

Thanks & Regards,
Member 3879881,
please don't forget to vote on the post

Re: file have to save on existing file name...,

Vimalsoft(Pty) Ltd1-Mar-09 23:33

Vimalsoft(Pty) Ltd

1-Mar-09 23:33

Just Check if it exists, if it does, delete it else save

if(System.IO.File.Exists(strPath))
{
System.IO.File.Delete(strPath);
}
else
{ 
  //Save................................
}

Hope it Helps

paging in repater control which is in inside the accordion control?

Member 38798811-Mar-09 23:04

Member 3879881

1-Mar-09 23:04

Hi guys in my accordion control content template i bind repeater control...,

now i like to do paging concept in my link button which is in inside the accordion control...,

i have tp pass 4 parameters to my repeater bind method...,

those are my repeaterid, hiden value amd that two linkbutton id's,
then only i can bind my repaeater...,

now in my paging link button how can i find this control ids and pass to my repeaterbind method?

Thanks & Regards,
Member 3879881,
please don't forget to vote on the post

ActiveX in Mozila is not working

Rajeesh MP1-Mar-09 23:02

Rajeesh MP

1-Mar-09 23:02

Dear All
i M loading a xml file from javascript..that is working in IE. but its not working Mozila..
this is the code

function importXML()
    {
	    if (document.implementation && document.implementation.createDocument)
	    {
	        xmlDescription = document.implementation.createDocument("", "", null);
		    xmlDescription.onload = getDescription;
		    
		    xmlDoc = document.implementation.createDocument("", "", null);
		    xmlDoc.onload = getData;
	    }
	    else if (window.ActiveXObject)
	    {
	        xmlDescription = new ActiveXObject("Microsoft.XMLDOM");
		    xmlDescription.onreadystatechange = function ()
		    {
			    if (xmlDescription.readyState == 4) getDescription()
		    };
		    
		    xmlDoc = new ActiveXObject("Microsoft.XMLDOM");
		    xmlDoc.onreadystatechange = function ()
		    {
			    if (xmlDoc.readyState == 4) getData()
		    };
 	    }
	    else
	    {
		    alert('Your browser can\'t handle this script');
		    return;
	    }
	    xmlDescription.load("details.xml");
	    xmlDoc.load("settings.xml");
    }

becouse of activex controls is not working in Mozila...
any solution for that to including activex control in mozila....?????
or any alternate way to load xml file from javasript..??????

Please....
Regards
Rajeesh MP

Re: ActiveX in Mozila is not working

N a v a n e e t h1-Mar-09 23:20

N a v a n e e t h

1-Mar-09 23:20

See if this[^] helps. Install FireBug and debug the JS code.

Navaneeth

How to use google | Ask smart questions

Re: ActiveX in Mozila is not working

Rajeesh MP2-Mar-09 1:19

Rajeesh MP

2-Mar-09 1:19

Hi Navneeth
that is not working

Ms Outlook Application integration with ASP.NET VB.

hits20091-Mar-09 22:37

1-Mar-09 22:37

Hi.

I am new to developing web applications in asp.net visual basic and need some help. I have a page (home.aspx) and I want to show outlook express on that page, for example inbox,new email etc. Is this possible? if so, how would I do this?

please email me. thanks.

How to Export DataSet to Microsoft Access Database

ballameharmurali1-Mar-09 22:28

ballameharmurali

1-Mar-09 22:28

Hi All,

Can anybody help me in finding out the code for Exporting the data in DataSet to microsoft access . ITS VERY URGENT.

Thanks
murali

Re: How to Export DataSet to Microsoft Access Database

Vimalsoft(Pty) Ltd1-Mar-09 22:38

Vimalsoft(Pty) Ltd

1-Mar-09 22:38

Nothing is Agent here. Refrain from using such words here.

To Saving the Data from the Dataset to Access table is simple.

see this

http://msdn.microsoft.com/en-us/library/aa288452(VS.71).aspx[^]

Hope it Helps

Re: How to Export DataSet to Microsoft Access Database

ballameharmurali1-Mar-09 22:49

ballameharmurali

1-Mar-09 22:49

Hi ,

Thanks for the need. This is working but How to Export the DataSet to .mdb format and also save on the desktop.

murali

Re: How to Export DataSet to Microsoft Access Database

Vimalsoft(Pty) Ltd1-Mar-09 22:58

Vimalsoft(Pty) Ltd

1-Mar-09 22:58

hi ballameharmurali

Really you have to be careful when using terms like Export and Dataset.

Firstly an .mdb Format is a Format used for a Access Database. Now in .NET a Dataset can have a Table and more than one table. a Dataset is not a Database in .NET.

When you Save the data in the Dataset , you will be saving it in a table, and that table belongs to a Database.

Secondly you wrote: and also save on the desktop.

I don't really understand what you mean here, you are Confusing me.

Please Clarify exactly what you want

Re: How to Export DataGrid to MS-Access

ballameharmurali1-Mar-09 23:37

ballameharmurali

1-Mar-09 23:37

HI ,

We want to Export the Data from DataGrid to MS-Access in ASP.NET.

Actually I want the code in VB.NET.

Thanks

Last Visit: 31-Dec-99 18:00 Last Update: 23-Apr-24 14:08

Refresh

ᐊ Prev 1...2263 2264 2265 226622672268 2269 2270 2271 2272 Next ᐅ

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