Jumat, 21 Oktober 2011

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...