.NET Logo
Welcome Guest Search | Active Topics | Members | Log In | Register

รบกวนด้วยครับ Connection Database ExcuteReader Options · View
Sifered
Posted: Wednesday, July 09, 2008 4:58:35 AM
Rank: มือพระกาฬ
Groups: Member

Joined: 1/8/2008
Posts: 24
Location: Ngamwongwan

ติดบรรทัดที่ ไฮไลท์ สีเหลืองครับรบกวนช่วยดูหน่อยครับ ขอบคุณครับ

    public partial class Window1 : Window
    {
        SqlConnection Conn = new SqlConnection();

        private void Window1_Load(object sender, EventArgs e)
        {
            string strConn = Conn.ConnectionString;

            if (Conn.State == ConnectionState.Open)
            {
                Conn.Close();
            }

            Conn.ConnectionString = strConn;
            Conn.Close();
        }
        private void btnSubmitMM_Click(object sender, RoutedEventArgs e)
        {
                StringBuilder sb = new StringBuilder();
                sb.Append("SELECT MemberUsername,MemberPassword FROM MemberUsername");
                sb.Append(" WHERE (MemberUsername=@UserName)");
                sb.Append(" AND (MemberPassword=@PassWord)");

                SqlParameter UserName = new SqlParameter("UserName", SqlDbType.NVarChar);
                SqlParameter PassWord = new SqlParameter("PassWord", SqlDbType.NVarChar);

                string sqlLogin;
                sqlLogin = sb.ToString();

                SqlCommand com = new SqlCommand();
                SqlDataReader dr;

                com.CommandType = CommandType.Text;
                com.CommandText = sqlLogin;
                com.Connection = Conn;
                com.Parameters.Add(UserName).Value = usernameTextBoxMM.Text;
                com.Parameters.Add(PassWord).Value = passwordTextBoxMM.Password;

                dr = com.ExecuteReader();

                if (dr.HasRows)
                {
                    //frmMain fMain = new frmMain();
                    //fMain.Show();
                    //this.Hide();
                    MessageBox.Show("Complete", "Process Report", MessageBoxButton.OK, MessageBoxImage.Exclamation);

                }
                else {
                    MessageBox.Show("Username Or Password InValid", "Process Report", MessageBoxButton.OK, MessageBoxImage.Exclamation);
                    usernameTextBoxMM.Text = null;
                    usernameTextBoxMM.Focus();
                    passwordTextBoxMM.Password = null;
                }
                dr.Close();
                dr.Dispose();
            }
        }

    }



I LIKE DOTNET

DOTNET Never DIe`
ball
Posted: Wednesday, July 09, 2008 7:13:55 AM

Rank: อาจารย์
Groups: Administration

Joined: 12/1/2007
Posts: 473
Location: Bangkok

ยังไม่ได้ Open Connection นะครับ

comm.Connection.Open();
dr = com.ExecuteReader();



Imagination is more Important than Knowledge... /A.Einstein
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

YAFVision Theme Created by Jaben Cargman (Tiny Gecko)
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.


Sponsored by