Fungsi Login pada C# dengan koneksi SQL Server

//koneksi data ke data base
private readonly string con_str = @"Data Source = (local);
Initial Catalog = Garamedia(ini adalah nama database kita); Integrated Security = SSPI";

private void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(con_str);
con.Open();
DataSet ds = new DataSet();
string u = txtUsername.Text.Trim();
string p = txtPassword.Text.Trim();

SqlDataAdapter da = new SqlDataAdapter("select * from Member where member_name ='" + u + "' and member_pass ='" + p + "'", con); ===>dari tabel member atribut nya member_name dan member_pass

da.Fill(ds);
int count = ds.Tables[0].Rows.Count;
if (count == 0)
{
MessageBox.Show("Invalid UserID/Password");
}
else
{
MessageBox.Show("Valid UserID/Password");
}
con.Close();
}

private void btnLogin_Click(object sender, EventArgs e) ===>ini merupakan method button login


selamat mencoba