Loading

asp.net web application

asp.net web application

Santosh Reddy

Santosh Reddy

9y833Learn iOS Programming

how to compare textbox text and sqlDatabase colomn in value please step by step code send me and please explain ::::

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajkiran Swain9y ago
1. if (string.IsNullOrEmpty(textBox1.Text))
2. {
3. MessageBox.Show("Please enter a value into the text box.");
4. this.textBox1.Focus();
5. return;
6. }
8. SqlConnectionStringBuilder connectionStringBuilder = new SqlConnectionStringBuilder();
9. connectionStringBuilder.DataSource = ".";
10. connectionStringBuilder.InitialCatalog = "TEMP";
11. connectionStringBuilder.IntegratedSecurity = true;
13. SqlConnection connection = new SqlConnection(connectionStringBuilder.ToString());
14. SqlCommand command = new SqlCommand("SELECT Column1 FROM TableA WHERE PKColumn = 1", connection);
15. connection.Open();
16. string value = command.ExecuteScalar() as string;
17. connection.Close();
19. if (textBox1.Text.Equals(value))
20. {
21. MessageBox.Show("The values are equal!");
22. }
23. else
24. {
25. MessageBox.Show("The values are not equal!");
26. }
+1

Abhilash J A

Abhilash J A9y ago

Here is the algorithm:

1. Read the textbox value

2. Send the value to database, using stored procedure execute the below query to check whether the values exist or not:

declare @itexists as int;
if exists(select * from MyTable where Barcode=@barcode)
set @itexists=1;
else
set @itexists=0;
print @itexists;

3. Get the result using ExecuteScalar and perform rest of the operations based on this value

In your case. just modify your database code as below:

public bool CompareBarcode(string barcode)
{
using (SqlConnection conn = new SqlConnection(ConnectionSTring))
{
SqlCommand cmd = new SqlCommand("uspCheckBarcode", conn);
cmd .CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@barcode", barcode);
return Convert.ToBoolean(cmd.ExecuteScalar());
}

0