[Link].

com C# & Sql Server2008

---------------------------------------------------------------------------------------------------------------------
C# & Sql Server 2008 Tutorial (3)

႔ ႔ ။
႕ (၃) ႔ ။ (၂)
Database (or) Project ႔ Login Account
။ ႔ ႔
Login Account Password ႔
Login Account ။
႔ ႕
(၁ ၂) ႔ ။ OK.. ႕ ႔…။

Change User Account’s Password

Login ႕ ႕
႔ ႔ ။
႔ ႕ Login Project IDCheck Database
၄ Login Tbl_Login Table ။
႔ C# UGI Record Sql ႕ IDCheck-Database
။ ႔ Tbl_Login
Table ။ Connection DataSet DataAdapter
႔ ။ Coding
။ ႕
။ ။ ႔..။

Account Password Change Sql Query

1. Fig.1 Tbl_LoginTableAdapter( ႕ Table ႕ TableAdapter)  R-Click Add
 Query…  Click ။

Fig.1
2. Fig.2 Use SQL statements Next ။ Fig.3 ။

-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။
[Link] C# & Sql Server2008
---------------------------------------------------------------------------------------------------------------------
3. ႔ Login Password Update
႔ ။ Fig.3 UPDATE Next ။ SQL Query
Page ။

Fig.2 Fig.3
4. ၄ Fig.4 Sql Query Next ။
Update Tbl_Login
Set UserName=@UserName, Password=@Password
Where UserName=@UserName
5. Fig.5 Next ။ User Account
႕ Password Change Query ႔ ChangeAccPw ႔ ။

Fig.4 Fig.5
6. Fig.6 Next ။
7. Fig.7 ႔ TablAdapter ChangeAccPw Sql Query
႔ ။
-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။
[Link] C# & Sql Server2008
---------------------------------------------------------------------------------------------------------------------

Fig.6 Fig.7
႔ C# Coding ႔ ။ ႔
ChangeAccPw Query C#
။

Change User Account’s Password C# Coding

႕ SQL Server ႔ Connection
Command line ။ ႕ ႕
[Link] Form ႕ Command ႔ ။ ႔ (၂) SQl
Server ႔ Connection ။ ….
1. frmSetting Form ႕ TabControl tabPage2(Change Password Page)  Change Button D-
Click [Link] ႕ Coding ။
2. ၄ Change Button Command line Run ။
private void btnChange_Click(object sender, EventArgs e)
{
if ([Link] != "" & [Link] !="" & [Link] !="")
{
DialogResult result = [Link]("ဤ User Accont Password Change
။", "Change Pasword", [Link], [Link],
MessageBoxDefaultButton.Button1);
if (result == [Link])
{
[Link]([Link], [Link]);
[Link]("Success Your Change Password", "Change Password");
}
}
else
{

-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။
[Link] C# & Sql Server2008
---------------------------------------------------------------------------------------------------------------------
[Link](" TextBox ႔ Record ။","Change
Password");
}
}
Change Button Run ႔ if statement ႔ ။
If([Link] !=“” & [Link] !=“” & [Link] !=“”)
{
// Statement ႕
}
else
{
[Link](" TextBox ႔ Record ။","Change Password");
}
႔ UserName Box, Old Password Box and New Password Box Keyboard
Record Change Button if statements Else
{…} Statement Message Statements if{…} Command
line ။ Fig.8 ။

Fig.8
႔ ။
DialogResult result = [Link]("ဤ User Accont Password Change ။",
"Change Pasword", [Link], [Link],
MessageBoxDefaultButton.Button1);
if (result == [Link])
{
// Statement ႕
}
Command line MessageBox ႔
။ ႔ ။
.. [Link] User Message Box Yes and No
Buttons(2) ။ [Link]User ႔ Message
Information Icon ။
MessageBoxDefaultButton.Button1 Message Button1 Yes Button Dafault

-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။
[Link] C# & Sql Server2008
---------------------------------------------------------------------------------------------------------------------
႔ Auto Selected ။ ႔ ႔ Message Mouse ႔
Yes Button Auto Selected Enter Key
Access ။

မူလ Login Record Fig.9

MessageBox ႔ Message
Yes (or) No Button User
။ User result
Variable ။ ႔ command line
if{…} Statement ႔ ။ ဤ User Account Password
Message User Yes (or) No Button ။ User
Yes ႔ If Statement ။ {..} Command Line
။ User No ႔ Password
Program ။
[Link]([Link], [Link]);
[Link]("Success Your Change Password", "Change Password");
command line User Yes ႔ Cmd
။ SQL Database Connection ႔
tblLogin Variable ။ ႔ Change Password
ChangeAccPw SqlQuery keyboard ႔ [Link]
(UserName) ၄ UserName ႕ Password [Link](NewPassword)
။

။ ။ MessageBox
Attribute ။ … MessageBoxButtons
(AbortRetryIgnore, OK, OKCancel, RetryCancel, YesNo, YesNoCancel)
MessageBoxIcons (Asterisk, Error, Exclamation, Hand, Information, None, Question, Stop,
Warning) ။ Message Command
။

-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။
[Link] C# & Sql Server2008
---------------------------------------------------------------------------------------------------------------------
႔ ႔ ႔ Login Account Tayza(221) Password (112)
။

Fig.10 ေျပာင္းလဲၿပီး Login Record

Message Box ႕ Yes Button ။ ႔ Database
Tayza Login Account Password 221 112 ႔
။ ႔ Project ႔ Tayza(221) Tayza(112) ႔ ႔
။ Fig ႔ ။

Project
Project Project
။ ႔ ႔ ။
႔ Change Password ။ ႔ Database
Login Account Password ႔
။ Screen Shoot ။

Fig.11 Fig.12
User Name: Tayza User Name: BoBo
Old Password: 010 Old Password: 111
New Password: 111 New Password: 221

-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။
[Link] C# & Sql Server2008
---------------------------------------------------------------------------------------------------------------------
 Fig.11 ။ ႔ User Name Database ၄
Account ႕ Password Database 112 ႔ Project Keyboard
Old Password 010 ။ Database Password ႔ Keyboard
႕ Old Password Filter
Old Password ChangeAccPw Sql Query User
Name New Password Database Old Password Change
။ ႔ Change User Account ႕
Password Change ၄ Password ႔ Project ႔
႔ ။
 Fig.12 ။ ႔ User Account Database
။ ႔ ႔ Filter Coding
Success ။ ႔
ChangeAccPw Sql Query User Name SQL Database ႔
။ / ။
။ ႔ Project ႕ ႔ ။
.. ။ ႕ (၁ ၂)
။
။ ။ ။
႔ (၁) Default UserName and Password ႔ CheckLogin Stored Procedure
။ Stored Procedure ႕ UserName and
Password Database / ။ Procedure ႔ Keyboard
႕ UserName ႔ Old Password Database / UserName and
Password ChangAccPw Query OldPassword
NewPassword ႔ Change ။ UserName and Password ( ႔)
Check… Your UserName and Password,Please! Message User Password
Login Account ႕ UserName and OldPassword
။ ။ Coding
။
private void btnChange_Click(object sender, EventArgs e)
{
if ([Link] != "" & [Link] !="" & [Link] !="")
{
DialogResult result = [Link]("ဤ User Accont Password Change ။",
"Change Pasword", [Link], [Link], MessageBoxDefaultButton.Button1);
if (result == [Link])
{
int checkLogin = [Link]([Link]([Link],
[Link]).ToString());

-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။
[Link] C# & Sql Server2008
---------------------------------------------------------------------------------------------------------------------
if (checkLogin == 1)
{
[Link]([Link], [Link]);
[Link]("Success Your Change Password", "Change Password");
}
else
{
[Link]("Check...Your UserName and Old Password.", "Change Password");
}
}
}
else
{
[Link](" TextBox ႔ Record ။ ","Change Password");
}
}
႔ Coding ….
int checkLogin = [Link]([Link]([Link], [Link]).ToString());
if (checkLogin == 1)
{
//ChangeAccPw Sql Query
}
else
{
[Link]("Check...Your UserName and Old Password.", "Change Password");
}
။ ။
CheckLogin Stored Procedure ႔ ႔ Keyboard UserName
႔ Old Password Database / ။ Record Database 1 ။
Record 0 ။ ႔ if statement ႔ Stored
Procedure ႕ Result 1( ) ႔ 0( ) checkLogin variable
။ if Statement ChangeAccPw Sql Query
႔ User Account New Password Update ။
။ Screen Shoot ။

Fig.13 Fig.14

-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။
[Link] C# & Sql Server2008
---------------------------------------------------------------------------------------------------------------------
 Fig.13 Database User Account Change Password
UserName Database Message ။
 Fig.14 User Name Database ႔ Old
Password ၄ User Name ႕ Password ႔ Old Password
Message ။

Fig.15 Fig.16
 Fig.15 ႔ Password ႔ User Name ႔ Old
Password Database ၄ User Account
႔ New Password ႔ Success
။
 Fig.16 ႔ Kolin(456) Account Kolin(222)
Result ။
Change User Account’s Password ႔ ။
Coding ႕ ႔ ။
။

User Account Delete

႕ User Account
Delete ႔ Project ႕ Setting ႕
။ ႔ Sql
Server ႔ Database Table ႔
Result Stored Procedure .. Sql Query
။
႔ C# Coding ။
Delete Account ႔ Sql Query
။ … ႔ ။

-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။
[Link] C# & Sql Server2008
---------------------------------------------------------------------------------------------------------------------
Delete Account SQL Query

Fig.17 Fig.18
1. Fig.17 Tbl_LoginTableAdapter  R-Click  Add Query… Click ။
2. Fig.18 Use SQL statements Next ။

Fig.19 Fig.20
3. Fig.19 DELETE Next ။ Sql Qurey Page
။
4. Fig.20 command line Next ။
Delete From Tbl_Login
Where UserName=@UserName
5. Fig.21 Sql Query Name Next ။
User Account ႕ Query ႔ DeleteAccount
။

-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။
[Link] C# & Sql Server2008
---------------------------------------------------------------------------------------------------------------------
6. Fig.22 ႔ Next ။

Fig.21 Fig.22
7. ႔ ႕ Tbl_LoginTableAdapter Fig.23
DeleteAccount Query ။

Fig.23
႔ User Account Delete C# Coding ႔ ။
႔ DeleteAccount Query C#
။

Delete User Account C# Coding

Change User Account’s Password ႔ ။
[Link] Coding ႔ SQL Server ႔ Connection
။ ….
1. frmSetting Form ႕ TabControl tabPage3(Delete Account)  Delete Button D-Click
[Link] ႕ Coding ။
-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။
[Link] C# & Sql Server2008
---------------------------------------------------------------------------------------------------------------------
2. ၄ Delete Button Command line Run ။
private void btnDelete_Click(object sender, EventArgs e)
{
if ([Link] != "" & [Link] != "")
{
DialogResult result = [Link]("ဤ User Accont Delete ။",
"Delete Account", [Link], [Link],
MessageBoxDefaultButton.Button1);
if (result == [Link])
{
int delAccount = [Link]([Link]([Link], [Link]).ToString());
if (delAccount == 1)
{
[Link]([Link]);
[Link]("Delete Complete","Delete Account");
}
else
{
[Link]("Recheck... Your Login Record.", "Delete Account");
}
}
}
else
{
[Link](" Delete Account ၏ UserName and Password
TextBox ႔ ။","Delete Account");
}
}
Delete Button Run ႔ if statement Fig.24 ႕ Result
႔ UserName and Password ။

Fig.24 Fig.25

-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။
[Link] C# & Sql Server2008
---------------------------------------------------------------------------------------------------------------------
User Account / User Choose
။ User Yes( ) … ႔ ႕ Loging Account Database
/ CheckLogin Stored Procedure ႔ ။ 1 0 ။1
႔ Login Account ႔ ။ DeleteAccount Sql Query
Delete Complete Fig.27 Message ။

Fig.26 Fig.27
0( ) ႔ Record UserName Password
႔ ႕ Login Account Database
။ Fig.(25,26) Recheck.. Your Login Record.
။

Fig.28
Fig.28 ႔ Login Account(Kolin-222) Delete ။ Coding
႔
။ ႔ ။
႔ ႕ ႔
[Link] Form ႕ (Register, Change Password, Delete Account ) Codding
။ ။
using System;
using [Link];
using [Link];

-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။
 [Link] C# & Sql Server2008
---------------------------------------------------------------------------------------------------------------------
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace IDCheck_Tutorial
{
public partial class frmSetting : Form
{
[Link].Tbl_LoginTableAdapter tblLogin = new
[Link].Tbl_LoginTableAdapter();
public frmSetting()
{
SqlConnection conn = new SqlConnection([Link]);
[Link]();
InitializeComponent();
}
Register
private void btnRegister_Click(object sender, EventArgs e)
{
if ([Link] != "")
{
if([Link]!="")
{
if ([Link] != "")
{
if ([Link] == [Link])
{
int chkName = [Link]([Link]([Link]).ToString());
if (chkName == 0)
{
tblLogin.Insert_Login([Link], [Link]);
[Link]("Your Registion is Successful", "Register");
}
else
{
[Link]("Your User Name is already exit in Database.","Register");
}
}
else
{
[Link]("Password Confirm Password ။", "Register");
[Link]();
}
}
else
{
[Link](" Confirm Password ။", "Register");
[Link]();
}
}

-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။
 [Link] C# & Sql Server2008
---------------------------------------------------------------------------------------------------------------------
else
{
[Link](" Password ။", "Register");
[Link]();
}
}
else
{
[Link](" User Name ။", "Register");
[Link]();
}
}
Change Password
private void btnChange_Click(object sender, EventArgs e)
{
if ([Link] != "" & [Link] !="" & [Link] !="")
{
DialogResult result = [Link]("ဤ User Accont Password Change
။", "Change Pasword", [Link], [Link],
MessageBoxDefaultButton.Button1);
if (result == [Link])
{
int checkLogin = [Link]([Link]([Link],
[Link]).ToString());
if (checkLogin == 1)
{
[Link]([Link], [Link]);
[Link]("Success Your Change Password", "Change Password");
}
else
{
[Link]("Check...Your UserName and Old Password.", "Change Password");
}
}
}
else
{
[Link](" TextBox ႔ Record ။ ","Change Password");
}
}
Delete Account
private void btnDelete_Click(object sender, EventArgs e)
{
if ([Link] != "" & [Link] != "")
{
DialogResult result = [Link]("ဤ User Accont Delete ။",
"Delete Account", [Link], [Link],
MessageBoxDefaultButton.Button1);
if (result == [Link])
{
int delAccount = [Link]([Link]([Link], [Link]).ToString());
if (delAccount == 1)
-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။
[Link] C# & Sql Server2008
---------------------------------------------------------------------------------------------------------------------
{
[Link]([Link]);
[Link]("Delete Complete","Delete Account");
}
else
{
[Link]("Recheck... Your Login Record.", "Delete Account");
}
}
}
else
{
[Link](" Delete Account ၏ UserName and Password
TextBox ႔ ။","Delete Account");
}
}

}
}
႔ ႔ Project Default
UserName and Password ႔ UserName and Password ႔
႔ SQL & C# Coding ။ ႔
Login Account Password Account
Coding ။ ႔
Programming Language ။
။ ။ ႔ …..
။

C# and SQL Server 2008 (3 ။ ႔

။
႔ ။
႔ ။
႔ ၏ ႔… ႔၏
႔… ။

Tay Zar Lin

Koyinmaung007@[Link]
[Link]

-----------------------------------------------------------------------------------------------------------
႔၏ ႔…။