Compare 2 columns in the table with combobobox value

Sasan Coderz

4y895Learn iOS Programming

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

3 Replies

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

Gajendra Jangid4y ago
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
+1
Rijwan Ansari4y ago
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();
}
+1
Muhammad Imran Ansari4y ago
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
+1