Data Atapter ile DataTable A Veri Yükleme

SqlConnection Connection = (SqlConnection)CreateDatabaseConnection();

Connection.Open();

try{

SqlCommand dbcmd = new SqlCommand("SELECT * FROM E_MyProject_Form WHERE Text1=@Text1 AND Text2=@Text2 AND WHERE ID=@DOCID", Connection);

dbcmd.Parameters.Add(new SqlParameter("@Text1", Text1.Text));

            dbcmd.Parameters.Add(new SqlParameter("@Text2", Text2.Text));

            dbcmd.Parameters.Add(new SqlParameter("@DOCID", documentId));

SqlDataAdapter Adapter = new SqlDataAdapter(dbcmd);

              DataTable dt = new DataTable();

             Adapter.Fill(dt);

             foreach(DataRow dr in dt.Rows){

//Yapılacaklar

}

               Adapter.Dispose();

               Command.Dispose();

}

finally{

                Connection.Close();

           }