ͼ4.3.7 Ìí¼ÓÐÅÏ¢´°¿Ú
ͼ4.3.8 ²éѯ
רҵ×ÊÁÏ
4.3.4ÒôÀÖ²¥·ÅÆ÷
ÒôÀÖ²¥·Å£ºµ±Óû§µÇ¼³É¹¦£¬½øÈëÖ÷´°¿ÚÖ®ºó£¬»áºÜÃ÷ÏԵĿ´µ½Ò»¸ö²¥·ÅÆ÷£¬Èçͼ4.3.9Ëùʾ,ÔÚ²¥·ÅÆ÷µÄÏÂÃæÓÐÈý¸ö°´Å¥£¬¿ÉÒÔʵÏÖ´ò¿ª(ͼ4.3.10)£¬²¥·Å/ÔÝÍ££¬ºÍĬÈÏÒôÀÖ.
ͼ4.3.9
ͼ4.3.10
¸è´ÊÁ÷¶¯ÏÔʾ:½øÈëÖ÷½çÃæºó¿ÉÒÔ¿´µ½ÓÒ±ßÓÐÒ»¿éÇøÓò(ͼ4.3.11)£¬ÕâÀï±ãÊÇÏÔʾ¸è´ÊµÄ.µ±´ò¿ªµÄÒôÀÖËÑË÷²»µ½¸è´ÊµÄ»°£¬»áÏÔʾ(ͼ4.3.12)ÈÃÓû§×Ô¼ºÈ¥ÏÂÔØ¸è´Ê.
רҵ×ÊÁÏ
ͼ4.3.11
ͼ4.3.12
רҵ×ÊÁÏ
µÚÎåÕ Ö÷Òª¹¦ÄÜÄ£¿é´úÂë
5.1 ¹«¹²Àà´úÂëÉè¼Æ
namespace MyHelper {
class SqlHelper {
public static readonly string connstr =
ConfigurationManager.ConnectionStrings[\].ConnectionString;
public static int ExecuteNonQuery(string cmdText, params SqlParameter[] parameters) {
using (SqlConnection conn = new SqlConnection(connstr)) {
conn.Open();
using (SqlCommand cmd = conn.CreateCommand()) {
cmd.CommandText = cmdText;
cmd.Parameters.AddRange(parameters); return cmd.ExecuteNonQuery(); } } }
public static object ExecuteScalar(string cmdText, params SqlParameter[] parameters) {
using (SqlConnection conn = new SqlConnection(connstr)) {
conn.Open();
using (SqlCommand cmd = conn.CreateCommand()) {
cmd.CommandText = cmdText;
cmd.Parameters.AddRange(parameters); return cmd.ExecuteScalar(); } } }
רҵ×ÊÁÏ
public static DataTable ExecuteDataTable(string cmdText, params SqlParameter[] parameters) {
using (SqlConnection conn = new SqlConnection(connstr)) {
conn.Open();
using (SqlCommand cmd = conn.CreateCommand()) {
cmd.CommandText = cmdText;
cmd.Parameters.AddRange(parameters); using (SqlDataAdapter adapter = new SqlDataAdapter(cmd)) {
DataTable dt = new DataTable(); adapter.Fill(dt); return dt; } } } }
public static SqlDataReader ExecuteDataReader(string cmdText, params SqlParameter[] parameters) {
SqlConnection conn = new SqlConnection(connstr); conn.Open();
using (SqlCommand cmd = conn.CreateCommand()) {
cmd.CommandText = cmdText;
cmd.Parameters.AddRange(parameters); return
cmd.ExecuteReader(CommandBehavior.CloseConnection); } } } }
5.2 µÇ¼½çÃæ´úÂëÉè¼Æ
private void login_Click(object sender, EventArgs e) {//Óû§Ãû¼°ÃÜÂë×éºÏÅжÏ
רҵ×ÊÁÏ
Ïà¹ØÍÆ¼ö£º