Database

fifothekid wrote:

the only thing that I want to implement is that to make my program read only the record that I'm viewing currently on the form

using (SqlConnection connection = new SqlConnection(connectionString)) {
   SqlCommand command = new SqlCommand("SELECT * Customer WHERE ID = @Id", connection);
   command.Parameters.AddWithValue("@ID", 5);
   connection.Open();
   SqlDataReader reader = command.ExecuteReader();
   reader.Read(); 
   ...

fifothekid wrote:

using the SqlCommand while limiting the number of records is not the thing that I want, for example, if I use it to read 10 rows only, then only those rows will be displayed in the form, and this is not correct in my case

update yourtablename
set Result = col1 + col2

Amit Agarrwal wrote:

want to insert record in both database but the major concern is that if any one failed its transaction then it should rollback both trasaction in both databases

Amit Agarrwal wrote:

i have two database in sql server 2005