DB-DATA

Application Details

About this application

• Using C# and SQL database
• Simple login applied
• For Student

SQL Connection

SqlConnection con = new SqlConnection(@"Data Source = <here user_name[PC_name]>; Initial Catalog = StudentDB; Integrated Security = True");

Ex:

SqlConnection con = new SqlConnection(@"Data Source = ASUS; Initial Catalog = StudentDB; Integrated Security = True");

Database Deatils

Database - Select Data

string query_search = "SELECT * FROM Teacher WHERE email = '" + u_email + "'";

Database - Insert Data

string query_insert = "INSERT INTO FormLoginData VALUES('" + user_name+ "','" +password+ "','" +role+ "','"+ usertype  + "')";

Database - Update Data

string updatesql = "UPDATE Student SET firstname='" + fname + "',email='" + email + "',tp='" + tel + "',gender='" + gender + "',grade='" + grade + "' where email='" + email + "'";

Database - Delete Data

string deletesql = "DELETE FROM Teacher WHERE email='" + email + "'";

Form Movement Handle

Example Only

[DllImport("user32.DLL", EntryPoint = "ReleaseCapture")]
private extern static void ReleaseCapture();
[DllImport("user32.DLL", EntryPoint = "SendMessage")]
private extern static void SendMessage(System.IntPtr hwnd, int wmsg, int wparam, int lparam);
private void Headerpanel_MouseDown(object sender, MouseEventArgs e)
{
    ReleaseCapture();
    SendMessage(this.Handle,0x112,0xf012,0);
}

Github Pages