µÚÒ»·¶ÎÄÍø - רҵÎÄÕ·¶ÀýÎĵµ×ÊÁÏ·ÖÏíÆ½Ì¨

C#ѧÉú³É¼¨¹ÜÀíϵͳ¿Î³ÌÉè¼Æ±¨¸æ

À´Ô´£ºÓû§·ÖÏí ʱ¼ä£º2025/5/29 1:24:33 ±¾ÎÄÓÉloading ·ÖÏí ÏÂÔØÕâÆªÎĵµÊÖ»ú°æ
˵Ã÷£ºÎÄÕÂÄÚÈݽö¹©Ô¤ÀÀ£¬²¿·ÖÄÚÈÝ¿ÉÄܲ»È«£¬ÐèÒªÍêÕûÎĵµ»òÕßÐèÒª¸´ÖÆÄÚÈÝ£¬ÇëÏÂÔØwordºóʹÓá£ÏÂÔØwordÓÐÎÊÌâÇëÌí¼Ó΢ÐźÅ:xxxxxxx»òQQ£ºxxxxxx ´¦Àí£¨¾¡¿ÉÄܸøÄúÌṩÍêÕûÎĵµ£©£¬¸ÐлÄúµÄÖ§³ÖÓëÁ½⡣

ͼ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) {//Óû§Ãû¼°ÃÜÂë×éºÏÅжÏ

רҵ×ÊÁÏ

ËÑË÷¸ü¶à¹ØÓÚ£º C#ѧÉú³É¼¨¹ÜÀíϵͳ¿Î³ÌÉè¼Æ±¨¸æ µÄÎĵµ
C#ѧÉú³É¼¨¹ÜÀíϵͳ¿Î³ÌÉè¼Æ±¨¸æ.doc ½«±¾ÎĵÄWordÎĵµÏÂÔØµ½µçÄÔ£¬·½±ã¸´ÖÆ¡¢±à¼­¡¢ÊղغʹòÓ¡
±¾ÎÄÁ´½Ó£ºhttps://www.diyifanwen.net/c2vm9c2n1xe4g4gh0kzl91od1e2lms500xwr_4.html£¨×ªÔØÇë×¢Ã÷ÎÄÕÂÀ´Ô´£©
ÈÈÃÅÍÆ¼ö
Copyright © 2012-2023 µÚÒ»·¶ÎÄÍø °æÈ¨ËùÓÐ ÃâÔðÉùÃ÷ | ÁªÏµÎÒÃÇ
ÉùÃ÷ :±¾ÍøÕ¾×ðÖØ²¢±£»¤ÖªÊ¶²úȨ£¬¸ù¾Ý¡¶ÐÅÏ¢ÍøÂç´«²¥È¨±£»¤ÌõÀý¡·£¬Èç¹ûÎÒÃÇ×ªÔØµÄ×÷Æ·ÇÖ·¸ÁËÄúµÄȨÀû,ÇëÔÚÒ»¸öÔÂÄÚ֪ͨÎÒÃÇ£¬ÎÒÃǻἰʱɾ³ý¡£
¿Í·þQQ£ºxxxxxx ÓÊÏ䣺xxxxxx@qq.com
ÓåICP±¸2023013149ºÅ
Top