You query should be like following
SqlDataAdapter da = new SqlDataAdapter("select * from users where username='" + txtUserName.Text.Trim() + "' and password='" + txtPswrd.Text.Trim() + "'", con);
Note: Use parameterized query for better performance and security purpose
Thanks