C# Database Connections and Queries

Create connection string:SqlConnection conn = new SqlConnection("Data Source=DATASOURCE\\\\SQLEXPRESS;Initial Catalog=DATABASE_NAME;Integrated Security=True");


try

            {

                conn.Open();

                SqlCommand sql = new SqlCommand("SELECT * FROM tableName", conn);

                SqlDataReader reader = sql.ExecuteReader();

while (reader.Read()) { this.TARGET_ID.InnerHtml += reader["column"] ; } } catch (SqlException sqle) { sqle.Message.ToString(); }

C# Programming c#database connection queries

Leave a Reply Cancel reply