用于Windows应用程序中日志页面的C＃编码。 [英] C# coding for logging page in Windows application.

问题描述

我对编程比较大。我想在c＃windows应用程序中创建简单的日志页面。我已经创建了sql table.table名称是loginp，有两个coloumn用户名和密码.Pz给我在C＃中的登录页面和SQL数据库连接编码。

I'm biggner for programming.I want to create simple logging page in c# windows application. I already create sql table.table name is loginp and there are two coloumn username and password.Pz give me loging page and SQL datadase connection coding in C#.

推荐答案

As一个初学者这个代码对你有好处



http://bhanumadan.blogspot.in/2012/08/how-to-login-in-login-form-using-cnet.html [< a href =http://bhanumadan.blogspot.in/2012/08/how-to-login-in-login-form-using-cnet.htmltarget =_ blanktitle =New Window> ^ ]



其他



你也可以查看这个



http://www.c-sharpcorner.com/forums/thread/106840/login-page-in-c-sharp-using-windows-application.aspx [ ^ ]

As a beginner this code will be good for u

http://bhanumadan.blogspot.in/2012/08/how-to-login-in-login-form-using-cnet.html[^]

else

you can check with this also

http://www.c-sharpcorner.com/forums/thread/106840/login-page-in-c-sharp-using-windows-application.aspx[^]

希望这会对你有帮助

Hope this will help you

/* Namespace Required  */
using System.Data.Odbc;


/* Declaration position */

  public partial class LoginWindow : Form
    {
        public LoginWindow()
        {
            InitializeComponent();
        }
        OdbcConnection con = new OdbcConnection(Globaldata.ConnectionString);
        OdbcCommand cmd = new OdbcCommand();

/* you may use SqlConnection ,MySqlConnection */



/* Add this code on login button event */
 private void button1_Click(object sender, EventArgs e)
        {
            if (cb_projectname.Text.Length != 0)
            {
                cmd.Connection = con;

                Globaldata.SQLQuery = "SELECT COUNT(*) FROM Login WHERE UserName='" + txt_username.Text + "' AND PASSWORD ='" + txt_password.Text + " ' ";

                cmd.CommandText = Globaldata.SQLQuery;

                //MessageBox.Show(Globaldata.SQLQuery);

                int login = Convert.ToInt32(cmd.ExecuteScalar());

                if (login == 1)
                {
                    
                   MessageBox.Show("..Login Successful.."); 

                }
                else
                {
                    MessageBox.Show("..please enter correct password..");
                }

这篇关于用于Windows应用程序中日志页面的C＃编码。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！