第一个与服务器交互的登录程序（C#)

太过爱你忘了你带给我的痛 2022-04-08 13:12 85阅读 0赞

在登录之前首先有和数据库连接

[http://blog.csdn.net/tskyming/article/details/8495024][http_blog.csdn.net_tskyming_article_details_8495024]

然后就是和数据库进行数据交互

交换程序源码

Console.WriteLine("请输入用户名");
                string username = Console.ReadLine();
                Console.WriteLine("请输入密码");
                string password = Console.ReadLine();
    
                using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDBFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"))
                {
                     conn.Open();
    
                     using (SqlCommand cmd = conn.CreateCommand())
                     {
                         cmd.CommandText = "Select * from T_Users where UserName='"+username+"'";
                         using (SqlDataReader reader = cmd.ExecuteReader())
                         {
                             if (reader.Read())
                             {
                                 //
                                 string dbpassword = reader.GetString(reader.GetOrdinal("Password"));
                                 if (password == dbpassword.Trim())
                                 { Console.WriteLine("登录成功"); }
                                 else
                                 {
                                     Console.WriteLine("登录失败");
                                 }
                             }
                             else
                             {
                                 Console.WriteLine("用户名错误");
                             }
                         }
                         cmd.ExecuteNonQuery();
                       
                     }
                }

[http_blog.csdn.net_tskyming_article_details_8495024]: http://blog.csdn.net/tskyming/article/details/8495024