I have a window form name Login and a database with a Table name Login it has two fleids usernm, pwd. usernm is to hold user names and pwd is to hold password. Ok on the form I have two text box name user_name and user_password. And two buttons. I want this to check the user name and pasword. I have made a sqlConnection name sqlConn. I have made a sqlCommand name sqlcommand1; I have made a sqlDataReader name dataReader. here is my part of my code. What am I doing wrong with my string? void check_password() { string query = string.Format(S"SELECT * FROM BankLogin where usernm= '{0}' and pwd= '{1}'", user_name.Text, user_password); sqlConn.Open(); sqlcommand(query, sqlConn); slqcommand1.ExecuteReader(); } Harrison Brock

I have a textbox that I want to enter a value in. Than search the database for the closes matches. Harrison Brock

Hi I have used this for the slq statem SELCT FirtName, LastName, ID,From Coustomer WHERE FirstName LIKE '[A-Z]' C# private void button1_Click(object sender, System.EventArgs e) { oleDbConnection1.Open(); oleDbDataAdapter2.SelectCommand.Parameters["LastName"].Value = textBox1.Text; dataSet11.Clear(); oleDbDataAdapter2.Fill(dataSet11) oleDbConnection1.Close(); } But when I run it gave a and error can u help me anyone Harrison Brock

Hi I have used this for the slq statem SELCT FirtName, LastName, ID,From Coustomer WHERE FirstName LIKE '[A-Z]' C# private void button1_Click(object sender, System.EventArgs e) { oleDbConnection1.Open(); oleDbDataAdapter2.SelectCommand.Parameters["LastName"].Value = textBox1.Text; dataSet11.Clear(); oleDbDataAdapter2.Fill(dataSet11) oleDbConnection1.Close(); } But when I run it gave a and error can u help me anyone Harrison Brock

Thank It work good now. Harrison Brock

Am try to tell if a number is prime or not. I only can get this to work with even number. It say that 15,21,25 35 ect. it said thatthey are prime number but there not. Prime number are only divisible by it self and one. Here is the code its in C#. This is for a math apllication that am work on. int iPrime = Int32.Parse(TextBox1.Text) for (int icount = 2; icount <= (iPrime / 2); icount++) { if((iPrime % icount) == 0) { Label1.Text = "False"; return; } Label1.Text = "True"; return; } Harrison Brock