Compare 2 columns in the table with combobobox value

Question

hello.i want Compare 2 columns in the table with combobox selected value and print the result in the label but i cannot pls help me tnx

Rijwan Ansari · Answer

You can get the selected value in string and execute query with where condition as shown sample: private void ComboBox_SelectionChanged( object sender, SelectionChangedEventArgs e) { ComboBox cmb = sender as ComboBox; Handle(); } private void Handle() { var ddlValue = cmbSelect.SelectedItem.ToString(); SqlConnection conn = new SqlConnection( "conectionString" ); conn.Open(); SqlCommand command = new SqlCommand( "Select Column1, Column2.. from [TableName] where Column1=@ddlVal and/or Column2=@ddlVal" , conn); command.Parameters.AddWithValue( "@ddlVal" ,ddlValue ); // int result = command.ExecuteNonQuery(); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { // bind the data to display } } conn.Close(); }

Gajendra Jangid · Answer

You should create Stored Procedure and set your combobox value as parameter then you can set condition in SP @V1 int, @V2 int select * from table where c1=@v1 and c2=@v2

Muhammad Imran Ansari · Answer

You can achieve through hr following code: private void btnCompare_Click(object sender, EventArgs e) { try { SqlConnection conn = new SqlConnection(); // Your Connectoin String conn.ConnectionString = "Data Source=.;Initial Catalog=YourDB;User id=UserId;Password=@Password;"; using (SqlCommand cmd = new SqlCommand("[dbo].[procCompare]", conn)) { cmd.CommandType = CommandType.StoredProcedure; // Passing parameter of combobox selected value cmd.Parameters.AddWithValue("@selectedValue", comboBox.SelectedValue); // Output Parameter which will retutn when columns matched var CompStatus = new SqlParameter("@CompStatus", SqlDbType.NVarChar, 100) { Direction = ParameterDirection.Output }; cmd.Parameters.Add(CompStatus); if (conn.State != ConnectionState.Open) conn.Open(); cmd.ExecuteNonQuery(); //Seeting value to label lblCompare.Text = Convert.ToString(CompStatus.Value); } } catch (Exception Ex) { throw Ex; } } -- Store Procedure to compare values CREATE PROCEDURE [dbo].[procCompare] @selectedValue INT, @CompStatus AS NVARCHAR(100) OUTPUT AS BEGIN SELECT @CompStatus = CompStatus FROM [dbo].[FinalTableData] WHERE [Row_Number] = @selectedValue AND ComplianceTypeID = @selectedValue END