[cancer10]

Hi Ppl,


I come from a PHP programming background, I also know classic asp 3 very well. Now, I wanna learn ASP.net, Last night I was going through an ASP.net Ebook, But the connection string given in that book had many lines of code and confusing too.

In PHP or classic asp, we had 1 or just 2 line of code for connecting to the DB (in VB and C#).

Can someone please tell me a connection code with a minimal line of code?

Also, Since I am from a PHP background, Plz suggest me which language should I use for ASP.net (VB or C#)?


Thanx

[digioz]

I made that same transition some 6 years ago. I recommend C# for PHP developers switching over.

Here is a Class I wrote for database connectivity, etc to make it easier:

http://digioznetportal.cvs.sourceforge.net/viewvc/digioznetportal/DigiOz%20.NET%20Portal/App_Code/clsMSSQL.cs?view=markup

And here is how to use it:

Code:

string lsSQL = "SELECT * FROM tblConfig";
clsData coDB = new clsData();
coDB.dbhost = "HOSTNAME";
coDB.dbname = "DATABASENAME";
coDB.dbuser = "USERNAME"
coDB.dbpass = "PASSWORD";
coDB.dbtype = "MSSQL";
coDB.openConnection();
coDB.QueryDBDataset(lsSQL);
loDT = coDB.ds.Tables[0];
...
coDB.closeConnection();

The class is part of a larger open source portal I am writing, so you may have remove the ": IData" from the class declaration.

Pete