C#

Goalie35 wrote:

although I recomend encrypting your config file if you use this on a server

Goalie35 wrote:

Each method can accept up to 10 arguments to be passed into a stored procedure. If a user needs to declare more than 10 arguments, they must pass them in as an array.

Goalie35 wrote:

I'd greatly appreciate any advice/additions that can be made to this to help improve upon it. If you simply wish to use it as is and make no improvements, I hope it helps make your coding a little easier.

Ed.Poore wrote:

Not sure if it'd work but how about using the C# "loader" program to have the ShowInTaskbar property of the main form set to false?

Ed.Poore wrote:

I'm pretty sure if you just the shell to execute it then it won't work.

faladrim wrote:

how do i make my search go over my entire table

MyDataTable.DefaultView.RowFilter = "column1 LIKE '%" + myCol1String + "%' AND column2 LIKE '%" + myCol2String + "%'";

faladrim wrote:

what if i have 100 columns??

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();