Programming Logic upgrading from VB6 to Vb.net

Question

Hi guys,

I have been programming in vb6 for few time ago and i used open SQL Server connection and command objects to make database traansactions. I have been searching for similar approaches in vb.net too but not finding any starting point.

How can we work similarly in vb.net application?

Answer 1

I think you're looking for SqlConnection and SqlCommand.
The MSDN page for SqlCommand shows a sample for how they can be used:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx

Answer 2

I would recommend using the SqlDataReader when possible for retrieving data. It is a faster option, and it sounds like Microsoft is not investing in the future of DataSets.

using (SqlConnection conn = new SqlConnection(connString))
                    {

                        conn.Open();

                        if (conn.State == ConnectionState.Open)
                        {


                            string sql =   "Select FirstName, LastName from Customers";
                            SqlCommand cmd = new SqlCommand(sql, conn);

                            SqlDataReader reader = cmd.ExecuteReader();

                            if (reader != null)
                            {


                                while (reader.Read())
                                {

                                    Customer cust = new Customer();
                                    cust.FirstName = reader["FirstName"].ToString();
                                    cust.LastName= reader["LastName"].ToString();
                                    collection.Add(cust);

                                }

                                reader.Close();

                            }

                            conn.Close();

                        }