C#

public DataTable SearchField(string strSearch, string strFieldName)
        {
            DataTable dt = new DataTable();
            
            foreach (DataRow dr in data.Rows)
            {
                string strT = dr[strFieldName].ToString();
                if (stringSearchMP(strSearch, strT) != -1)
                {
                    DataRow row = dr;
                    dt.ImportRow(row);
                }
            }
            return dt;
        }

private void get_vehicle_branches()

{

try

{

sql_connection = new SqlConnection("Data Source=.\\SQLEXPRESS;initial catalog=rent_a_car_company;integrated security=true;");

sql_connection.Open();

sql_command = new SqlCommand("sp_get_vehicle_branches", sql_connection);

sql_command.CommandType = CommandType.StoredProcedure;

// Create data adapter object 

sql_adapter = new SqlDataAdapter();

sql_adapter.SelectCommand = sql_command;

// Create a dataset object and fill with data using data adapter's Fill method 

data_set = new DataSet();

sql_adapter.Fill(data_set, "vehicle_branches");


// Attach dataset's DefaultView to the combobox 

cboVehicleBranch.DisplayMember = "branch_name";

cboVehicleBranch.ValueMember = "branch_id";

cboVehicleBranch.DataSource = data_set.Tables["vehicle_branches"].DefaultView;

cboVehicleBranch.SelectedIndex = -1;

}

// catch (Exception oE)

// {

// MessageBox.Show("Problem Populating Reader Box: [" + oE.ToString() + "]");

// }

finally

{

if (sql_reader != null) sql_reader.Close();

// if (sql_connection != null)

// {

// if (sql_connection.State == ConnectionState.Open)

// sql_connection.Close();

// }

}

}