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(); }
- 2010-07-06
