C#

public static OleDbDataReader GetAll(OleDbConnection conn, bool status)
        {
            try
            {
                string query =
                    "SELECT [Id], [Name], [CreatedDate], [CreatedBy], " +
                    "   [UpdatedDate], [UpdatedBy] " +
                    "FROM [Role] " +
                    "WHERE [Status] = @pStatus " +
                    "ORDER BY [Name] ASC";

                OleDbCommand cmd = new OleDbCommand(query, conn);
                OleDbParameter pStatus = cmd.Parameters.Add("@pStatus", 
                    OleDbType.Boolean);
                pStatus.Value = status;
                OleDbDataReader dr = cmd.ExecuteReader();

                return dr;
            }
            catch (OleDbException ex)
            {
                throw new Exception("OleDb Error: " + ex.Message);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

public List<Role> GetAll(bool status)
        {
            List<Role> listRole = new List<Role>();

            try
            {
                if (conn.State != ConnectionState.Open)
                {
                    conn.Open();
                }

                OleDbDataReader dr = RoleData.GetAll(conn, status);

                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        Role role = new Role();
                        role.Id = int.Parse(dr["Id"].ToString());
                        role.Name = dr["Name"].ToString();
                        role.CreatedBy = dr["CreatedBy"].ToString();
                        role.CreatedDate = (string.Empty.Equals(dr["CreatedDate"].ToString()) ?
                            DateTime.MinValue :
                            DateTime.Parse(dr["CreatedDate"].ToString()));
                        role.UpdatedBy = dr["UpdatedBy"].ToString();
                        role.UpdatedDate = (string.Empty.Equals(dr["UpdatedDate"].ToString()) ? 
                            DateTime.MinValue : 
                            DateTime.Parse(dr["UpdatedDate"].ToString()));
                        listRole.Add(role);
                    }
                }

                return listRole;
            }
            catch (OleDbException ex)
            {
                throw new Exception("OleDb Error: " + "\n" + ex.Message);
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
            finally
            {
                conn.Close();
            }
        }

Jinal Desai - LIVE wrote:

I don't think it is possible to detect vehicle from image/video.

Jinal Desai - LIVE wrote:

I don't think it is possible to detect vehicle from image/video.

Jinal Desai - LIVE wrote:

Obviously you can.

Jinal Desai - LIVE wrote:

But in current scenario for "ruknil" it is equivalent to
impossible ( I M Possible).

Stanciu Vlad wrote:

apply a filter to your second comboBox (something like "Option1 = " + comboBox1.Text, but adapt it to a dataGridView).

private void GetRowsByFilter()
        {
            //DataTable table = DataSet1.Tables["Orders"];
            //// Presuming the DataTable has a column named Date.
            string expression;
            expression = "MeasureType = 'Force'";
            DataRow[] foundRows;

            // Use the Select method to find all rows matching the filter.
            foundRows = table.Select(expression);

            

            // Print column 0 of each returned row.
            for (int i = 0; i < foundRows.Length; i++)
            {
                
                Debug.WriteLine(foundRows[i][0] + "test");
            }
        }

BindingSource bsOrders = new BindingSource();
bsOrders.DataSource = Dataset1;
bsOrders.DataMember = "Orders"

//eventualy do a nothing selected check
if(filterText == string.Empty)
    bsOrders.Filter = string.Empty;
else
    bsOrders.Filter = "Option1 = " + filterText;

public void Form1_Load(object sender, EventArgs e)
        {
            
            DataTable tblPrimary = dataSet1.Tables.Add("Primary");
            tblPrimary.Columns.Add("Type");
            tblPrimary.Rows.Add("Force");
            tblPrimary.Rows.Add("Torque");
            tblPrimary.Rows.Add("Pressure");
            
            DataTable tblSecondary = dataSet1.Tables.Add("Secondary");
            tblSecondary.Columns.Add("Primary_Type");
            tblSecondary.Columns.Add("Unit");
            tblSecondary.Rows.Add("Force", "lb");
            tblSecondary.Rows.Add("Force", "N");
            tblSecondary.Rows.Add("Force", "oz");
            tblSecondary.Rows.Add("Torque", "in-lb");
            tblSecondary.Rows.Add("Torque", "oz-in");
            tblSecondary.Rows.Add("Torque", "N-m");

            dataGridView1.DataSource = tblSecondary;

            DataGridViewComboBoxColumn col = new DataGridViewComboBoxColumn();
            col.DataSource = tblPrimary;
            col.ValueMember = "Type";
            dataGridView1.Columns.Add(col);

            
            DataGridViewComboBoxColumn col2 = new DataGridViewComboBoxColumn();
            col2.DataSource = tblSecondary;
            col2.ValueMember = "Unit";
            dataGridView1.Columns.Add(col2);

           
        }

        private void primaryCB_SelectedIndexChanged(object sender, EventArgs e)
        {

            if (dataGridView1.CurrentCell.ColumnIndex == 0) //allow control on only one column
            {

                ComboBox cb = sender as ComboBox;

                if (cb != null)
                {
                    Debug.WriteLine(cb.SelectedValue + "TEST");

                    BindingSource bsSecondary = new BindingSource();

                    bsSecondary.DataSource = dataSet1.Tables["tblSecondary"];
                   
                    string filter = string.Format("Primary_Type = {0}", cb.SelectedValue);

                    bsSecondary.Filter = filter;
                                      
                    Debug.WriteLine(filter);

                                    
                }
            }
        }

        private void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
        {

            if (dataGridView1.CurrentCell.ColumnIndex == 0)  //allow control only on one column
            {
                ComboBox cb = e.Control as ComboBox;
                if (cb != null)
                {
                    cb.SelectedIndexChanged -= primaryCB_SelectedIndexChanged;
                    cb.SelectedIndexChanged += primaryCB_SelectedIndexChanged;
                }
            }

        }

BindingSource secondTableBindingSource = new BindingSource();
public void Form1_Load(object sender, EventArgs e) {
    // ... etc

    DataGridViewComboBoxColumn col = new DataGridViewComboBoxColumn();
    col.DataSource = tblPrimary;
    col.ValueMember = "Type";
    dataGridView1.Columns.Add(col);

    secondTableBindingSource.DataSource = tblSecondary;

    DataGridViewComboBoxColumn col2 = new DataGridViewComboBoxColumn();
    col2.DataSource = secondTableBindingSource;
    col2.ValueMember = "Unit";
    dataGridView1.Columns.Add(col2);
}

private void primaryCB_SelectedIndexChanged(object sender, EventArgs e)
{
    if (dataGridView1.CurrentCell.ColumnIndex == 0) 
    //allow control on only one column
    {
        ComboBox cb = sender as ComboBox;
        if (cb != null)
        {
            if(cb.SelectedValue != null)
                secondTableBindingSource.Filter = string.Format("Primary_Type = '{0}'", cb.SelectedValue);
            else 
                secondTableBindingSource.Filter = string.Empty;
        }
    }
}

Stanciu Vlad wrote:

secondTableBindingSource.DataSource = tblSecondary;