lighthead 55 Junior Poster in Training
select count(*) orders where (signNumber='required_sign_number' )and ( ( (fromDate > required_toDate ) or (toDate < required_fromDate )  )

Assuming your required_fromDate < required_toDate which you have to check if you not have already.

lighthead 55 Junior Poster in Training

The last column name is different.So keep some common name for the datagrid and both the tables, like fname , lname, mname and bid. Then assign the table. I am guessing all the columns are the same type in the gridview.

lighthead 55 Junior Poster in Training
lighthead 55 Junior Poster in Training

You can do as 'Mick Curley' suggested in the above post. Change the last column header when you change the table source.

lighthead 55 Junior Poster in Training

The problem in filltable method :
for ( column=1;column <= *(table[row]);column++); //remove the semicolon :)

tux4life commented: Yes! +13
lighthead 55 Junior Poster in Training

If you want to change colour of all the forms onload of the form, then write assign the colour of the form in the onload function of the form.

In form1

        public static System.Drawing.Color x1;
        public Form1()
        {
            InitializeComponent();
            ColorDialog cd = new ColorDialog();
            cd.ShowDialog();
            x1 = cd.Color;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            Form2 oj = new Form2();
            oj.Show();
        }

In form2
               public Form2()
		{
			InitializeComponent();
                        this.BackColor = Form1.x1;
		}

You can do the same for all the forms and i didn't understand why u have to create a new object of form1 in form3.

Hope this solves your problem.

lighthead 55 Junior Poster in Training

I believe you cannot do such a thing from any desktop application. As different websites use different methods like postback or ajax to transfer data to the server. The best you can do is call the login page which i believe you already are doing.

lighthead 55 Junior Poster in Training

It is not necessary to refresh the form, its enough to refresh the control(combobox). Call Refresh method of the combobox you want to reload.

lighthead 55 Junior Poster in Training

its a web application or forms..
if it is forms, it is enough if u give DataSource.

lighthead 55 Junior Poster in Training

There are many ways to bind data to the DataGridView. The method i use is
1. Create columns in the DataGridView control.
2. Create DataTable with the same columns.
3. Create Rows for the Datatable and insert data in to the row.
4. Set DataSource property of the DataGridview control to the created table.
5. Call DataBind method.

I think DataBinding is a property not a method.

kvprajapati commented: Very good +5
lighthead 55 Junior Poster in Training

Thanks ddanbe for the above link. I solved part of the problem.I am able to get almost consistent timings for the execution time. But the ExecutionStopwatch gives zero as the execution times most of the time.
I tried running it on the same thread and on different threads,
but the result is the same.
Is there any reason the time can be zero ?

I will be really grateful if anyone helps..................

lighthead 55 Junior Poster in Training

I was trying to measure the execution times of the c programs for efficiency by executing the .exe as process in C# and finding the time with TotalProcessorTime property.
But the problem i have been facing is that, when i run the process for more than a couple times, the TotalProcessorTime property is turned to zero.Even though the program executes completely.
I tried to create a separate thread and run the process on that, but
even then same problem persists.

Can anyone tell me why ? or if there is better way to measure the execution time.

P.S Stopwatch,Timer are much worse, they have a very large variation.

lighthead 55 Junior Poster in Training

i would this in DOS using TSR program to fire events with....
but now..i don't know if it works....

lighthead 55 Junior Poster in Training

hey,
i am a newbee to web development.i was wondering as to what is the best platform for creating dynamic websites....
i mean which is better php/myql. , asp , coldfusion etc... with respect to ease of coding and hosting