Re: Import data from Excel sheet to sql Database-asp.net 2.0 - ASP.NET Discussion Boards

First Prev Next

Re: Update Connection String

Vimalsoft(Pty) Ltd4-Mar-09 1:27

Vimalsoft(Pty) Ltd

4-Mar-09 1:27

Good Day Greg

I would like to take this chance and thank you for what you have doe for me. Everything is Working Fine.

Thank you

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

Can i use my own User Registartion Information Class with ASP .NET Login controls

The One2-Mar-09 1:49

The One

2-Mar-09 1:49

Hi friends,

I got a question that
"Can i use my own SQl Databse Table named 'RegisteredUsers' to store the information about users who wants to register on my site. If i used my own class like such without using the ASPMembershipProvider then is there any drawback of using my method."

As i have this table "Registered Users" and its class that will handle all the information about the user.

Thanks in advance if any one can answer.

Cause i m confused about my using wether my own structures, Methods and classes OR just to use the ASPMembershipProvider for the user login and registration.

WTF | :WTF:

Re: Can i use my own User Registartion Information Class with ASP .NET Login controls

Abhishek Sur2-Mar-09 3:55

Abhishek Sur

2-Mar-09 3:55

Yes ... no problem with that ... We generally use own custom database for Registered user and dont use ASPMembershipProviders.

Rather it is better to create a Web Interface for login, probably you can use Web service for login if you want Rose | [Rose]

Abhishek Sur

My Latest Articles
Basics on LINQ and Lambda Expressions

Create .NET Templates

Error occuring while developin with ASP.NET

VeeKeyBee2-Mar-09 1:46

VeeKeyBee

2-Mar-09 1:46

I got this error during debugging the code without using an IIS or webserver. I got two errors ,
1.
Line 105:<compilers>
Line 106:<compiler language="c#;cs;csharp" extension=".cs" warninglevel="4" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
Line 107:<provideroption name="CompilerVersion" value="v3.5">
Line 108:<provideroption name="WarnAsError" value="false">
Line 109:
--the bolded session will have the error.

2. child notes not allowed.

Help me please!

Re: Error occuring while developin with ASP.NET

Vimalsoft(Pty) Ltd2-Mar-09 1:54

Vimalsoft(Pty) Ltd

2-Mar-09 1:54

Really you have not Specified your Problem.

Tell us what were you trying to do before the Error occurred. and post us the Error the way it appears

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

Member 46590012-Mar-09 1:26

Member 4659001

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[^]

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.

Last Visit: 31-Dec-99 18:00 Last Update: 5-May-24 13:02

Refresh

ᐊ Prev 1...2262 2263 2264 226522662267 2268 2269 2270 2271 Next ᐅ

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