C#

int colnr;
int colamount = db1DataSet.Tables[0].Columns.Count;
string cFilter = "";

for (colnr = 0; colnr < colamount; colnr++)
{
    cFilter = cFilter + (cFilter.Length > 0 ? " OR [" : "[") + db1DataSet.Tables[0].Columns[colnr].ColumnName + "] LIKE '%" + txt_sort.Text + "%' ";
}
db1DataSet.Tables[0].DefaultView.RowFilter = cFilter;
dataGridView1.DataSource = db1DataSet.Tables[0].DefaultView;

faladrim wrote:

what if i have 100 columns??

// colFilters is an array of strings with the text you are using to filter
// for each column
StringBuilder sb = new StringBuilder;
for (int i=0; i <myTable.Columns.Count; i++)
{
    sb.Append(myTable.Columns[i].ColumnName + " LIKE '%" + colFilters[i] + "%'");
    if (i <myTable.Columns.Count-1)
        sb.Append(" AND ");
}
.
.
.
MyTable.DefaultView.RowFilter = sb.ToString();

kumar.bs wrote:

How can we invoke subclass(derive class) default constructor and base class parametarized constructor at a time from derive class parametarized constructor, Is there any way?

class A
{
    A(int number, string text)
    {
        // Do stuff
    }
}
 
class B : A
{
    B() : base (1, "some text")
    {
        // Do stuff
    }
}
 
B b = new B();

kumar.bs wrote:

I want to invoke Class B's Default contructor(as well) along with Class A's parametarised constructor, is that possible?

class B : A
{
    B()
    {
        Initialise();
    }
 
    B(int number, string text) : base(number, text)
    {
        Initialise();
    }
 
    private void Initialise()
    {
        // Do stuff.
    }
}

Parshant Verma wrote:

dispaly exception at MouseEnter

Parshant Verma wrote:

But when i click on Browse for file button if appear over the form and also covered the button and dispaly exception at MouseEnter event .