C#

for (int i = 0 ; i < cmb.Items.Count ; i++)
{
 if (String.Compare(cmb.Items[i].ToString,cmb.Text,true)
 {
  //values are the same
 }
 else
 {
  //different values
 }
}

pankaj.indore wrote:

If I having 15,000 records in combo then for loop will run 15,000 times and check the item.

bool chkitem_small = comboBox1.Items.Contains(comboBox1.Text.ToLower());
<pre>bool chkitem_cap = comboBox1.Items.Contains(comboBox1.Text.ToUpper());
if(chkitem_small == true | chkitem_cap == true)
{
// found
}
else
{
//not found
}

 <br />
using (SqlConnection connection = DbConnection("SerConstr"))<br />
                     {<br />
                         using (SqlCommand command =<br />
                                 connection.CreateCommand())<br />
                         {<br />
                             SqlTransaction transaction = null;<br />
<br />
                             try<br />
                             {<br />
                                  connection.Open();<br />
<br />
                                 transaction = connection.BeginTransaction();<br />
<br />
<br />
<br />
<br />
                                 command.Transaction = transaction;<br />
<br />
<br />
<br />
            // i need to perform this in con1                                <br />
  command.CommandText = "Insert ...";<br />
                                 command.ExecuteNonQuery();<br />
<br />
               // Execute i need to perform this in con2<br />
                                 command.CommandText = "Update...";<br />
                                 command.ExecuteNonQuery();<br />
<br />
                                 transaction.Commit();<br />
                             }<br />
                             catch<br />
                             {<br />
                                 transaction.Rollback();<br />
                                 throw;<br />
                             }<br />
                             finally<br />
                             {<br />
                                 connection.Close();<br />
                             }<br />
<br />

Vipin.d wrote:

// i need to perform this in con1
command.CommandText = "Insert ...";
command.ExecuteNonQuery();

// Execute i need to perform this in con2
command.CommandText = "Update...";
command.ExecuteNonQuery();

using (SqlConnection conn = new SqlConnection())
{
 //set the first cs
 string cs1 = "connection string 1";
 conn.ConnectionString = cs1;

 conn.Open();

 SqlTransaction trans = conn.BeginTransaction();

 //do the the select query

 if (InsertSecondDB())
 {
  //update first DB
  trans.Commit();
 }
 else
 {
  trans.Rollback();
 }

 conn.Close();
}