asp.net web application

Question

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

Rajkiran Swain · Answer

if (string.IsNullOrEmpty(textBox1.Text)) { MessageBox.Show( Please enter a value into the text box. ); this .textBox1.Focus(); return ; } SqlConnectionStringBuilder connectionStringBuilder = new SqlConnectionStringBuilder(); connectionStringBuilder.DataSource = . ; connectionStringBuilder.InitialCatalog = TEMP ; connectionStringBuilder.IntegratedSecurity = true ; SqlConnection connection = new SqlConnection(connectionStringBuilder.ToString()); SqlCommand command = new SqlCommand( SELECT Column1 FROM TableA WHERE PKColumn = 1  connection); connection.Open(); string value = command.ExecuteScalar() as string; connection.Close(); if (textBox1.Text.Equals(value)) { MessageBox.Show( The values are equal! ); } else { MessageBox.Show( The values are not equal! ); }

Mani Kandan · Answer

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()); }