ASP.NET 2.0 Database Connection

[paulbinju]

Hi,

I am a classic asp developer, trying to migrate to asp.net 2.0
how can i connect to the SQL SERVER database?
access the value of a field?

it is not for any control, but for comparing the value of textbox aganist the values in the database.


regards

Binju Paul

[izzy]

** This code is in Visual Basic.NET **

In this example you connect to an MS SQL database.

Dim conn As New System.Data.SqlClient.SqlConnection("Data Source=192.168.0.1;Initial Catalog=DATABASEname;User ID=dev;Password=123")
Dim adapter As New System.Data.SqlClient.SqlDataAdapter("SELECT * FROM [tblMyTable])", conn)
Dim ds As New Data.DataSet
adapter.Fill(ds, "tblMyTable")
txtBox.Text = ds.Tables("tblMyTable").Rows(0).Item("fldMyColumn")

[Soulmaker]

You can create a new Dataset or add a new one in our App_Data project folder...
when you create it a wizzard will guide you to configure it...

function getElement()
{
MyDataSet.ClienteDataTable cdt = new MyDataSetTableAdapters.ClienteTableAdapter().GetDa ta();
textBox1.Text = cdt.Rows[0].ItemArray[0].toString();
}
Try it.....