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.
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.
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.
You can do as 'Mick Curley' suggested in the above post. Change the last column header when you change the table source.
The problem in filltable method :
for ( column=1;column <= *(table[row]);column++); //remove the semicolon :)
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.
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.
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.
its a web application or forms..
if it is forms, it is enough if u give DataSource.
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.
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..................
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.
i would this in DOS using TSR program to fire events with....
but now..i don't know if it works....
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