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!" ); }

Abhilash J A · 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()); }