FONForum

using System;
using System.Data;
using System.Data.SqlClient;

class SelectIntoDataSet
{

   public static void Main()
   {

      // step 1: formulate a string containing the details of the
      // database connection
      string connectionString =
         "Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=Northwind;Data Source=Ime vaseg servera";//ovde promenite naziv servera

      // step 2: create a SqlConnection object to connect to the
      // database, passing the connection string to the constructor
      SqlConnection mySqlConnection =
         new SqlConnection(connectionString);

      // step 3: formulate a SELECT statement to retrieve the
      // CustomerID, CompanyName, ContactName, and Address
      // columns for the first ten rows from the Customers table
      string selectString =
         "SELECT TOP 10 CustomerID, CompanyName, ContactName, Address " +
         "FROM Customers " +
         "ORDER BY CustomerID";

      // step 4: create a SqlCommand object to hold the SELECT statement
      SqlCommand mySqlCommand = mySqlConnection.CreateCommand();

      // step 5: set the CommandText property of the SqlCommand object to
      // the SELECT string
      mySqlCommand.CommandText = selectString;

      // step 6: create a SqlDataAdapter object
      SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();

      // step 7: set the SelectCommand property of the SqlAdapter object
      // to the SqlCommand object
      mySqlDataAdapter.SelectCommand = mySqlCommand;

      // step 8: create a DataSet object to store the results of
      // the SELECT statement
      DataSet myDataSet = new DataSet();

      // step 9: open the database connection using the
      // Open() method of the SqlConnection object
      mySqlConnection.Open();

      // step 10: use the Fill() method of the SqlDataAdapter object to
      // retrieve the rows from the table, storing the rows locally
      // in a DataTable of the DataSet object
      Console.WriteLine("Retrieving rows from the Customers table");
      mySqlDataAdapter.Fill(myDataSet, "Customers");

      // step 11: close the database connection using the Close() method
      // of the SqlConnection object created in Step 2
      mySqlConnection.Close();

      // step 12: get the DataTable object from the DataSet object
      DataTable myDataTable = myDataSet.Tables["Customers"];

      // step 13: display the columns for each row in the DataTable,
      // using a DataRow object to access each row in the DataTable
      foreach (DataRow myDataRow in myDataTable.Rows)
      {
         Console.WriteLine("CustomerID = " + myDataRow["CustomerID"]);
         Console.WriteLine("CompanyName = " + myDataRow["CompanyName"]);
         Console.WriteLine("ContactName = " + myDataRow["ContactName"]);
         Console.WriteLine("Address = " + myDataRow["Address"]);
      }

   }

}