Question about using DBAccess

I need to use dbaccess to to write a sql database to a dataset in c#. I am not quite sure how to do this. Does anyo开发者_JS百科ne know of any good tutorials or have any advice on how to do this? Let me know if you need more info from me. Any help is appreciated. Thanks

Here's the nigh-canonical example:

var sql = "SELECT * FROM myTable";

using (var connection = new SqlConnection(connectionString)
{
    connection.Open();

    var command = new SqlCommand(sql, connection);

    var adapter = new SqlDataAdapter(command);

    var dataSet = new DataSet();

    adapter.Fill(dataSet);
}

"connectionString" is the provider specific string which enables the system to connection to your database. If you don't know what this should be, here's a good place to start: Connectionstrings.com.

Once you're ready to move to the next level beyond this, look at Entity Framework or NHibernate. HTH.

This ate the link you can start of:

C# Station ADO.NET

ADO>net c#

MSDN

Regards... All this tutorial helps and easy to learn..