timer does not work - C# Discussion Boards

User 66589-Jul-08 20:24

9-Jul-08 20:24

You can use ADO.NET[^] to create a connection to the database and then query all databases using a SqlCommand. To connect to the database you need a valid connection string[^].

I'd recomment to use the MySQL .NET connector[^] to use for this task.

regards

modified 12-Sep-18 21:01pm.

Re: Connection to MySQL

D i x y9-Jul-08 20:34

D i x y

9-Jul-08 20:34

Sir as you give me the link of connection string that is used to connect to MySQL server that's great but as i want to connect to like this user will enter Server Name, UserID and Password in the available textboxes and after that it will click on connect button that it should connect with all the available databases and shows them in Listbox

Thanks

Re: Connection to MySQL

User 66589-Jul-08 20:45

User 6658

9-Jul-08 20:45

I'm not sure if you can connect to the server without specifying a valid database. Maybe you should once connect to a database and then issue the SHOW DATABASES SQL command to get a list of the databases available to use for the next DB login from the listbox.

modified 12-Sep-18 21:01pm.

Re: Connection to MySQL

sacr839-Jul-08 22:58

sacr83

9-Jul-08 22:58

$user="UsernameForYourMySqlDB";
$pass="PasswordForYourMySqlDB";
$db="YourDB_Name";

$link=mysql_connect("localhost",$user,$pass);

if(!$link)
die("Couldnt connect to MySQL");
mysql_select_db($db,$link) or die ("couldnt open $db: ".mysql_error());
print "connected to $db";

CheeN

How to rename a file?

Saiyed Alam9-Jul-08 19:31

Saiyed Alam

9-Jul-08 19:31

How can I rename a file? what i am doing is copying a file from it's source to a certain directory. Now I want to rename the file name in the destination folder. How can I do that?

Thanking in advance.

Re: How to rename a file?

User 66589-Jul-08 20:20

User 6658

9-Jul-08 20:20

File.Move[^]

regards

modified 12-Sep-18 21:01pm.

bindingsource.filter syntax question

crash8939-Jul-08 18:39

crash893

9-Jul-08 18:39

I've done some looking around and I'm a bit confused

Here is an example of the data that's in the binding source

[IMG]http://i38.tinypic.com/xfoimp.png[/IMG]

what i want to do is sort on the 3rd row ( 4 or 3) and then sort by the date ( to see if the record is before a certian time

my idea to do this was to

filter the BS
BS.count
then unfiltered the BS

The problem i keep running into is that i cant say that i want Just 4 or Just 3

What I've come up with so far is

private int deadlineCount(DateTime Time, int LeagueID)
        {
            int total = 0;
            string league;
            if (LeagueID == 99)
            {
                league = "";
            }
            else
            {
                league = LeagueID.ToString();
            }



            BS.Filter = string.Format("LeagueID >= '{0}' and LeagueID <= '{0}'and [End] <#12/30/1899 {1}#", league, Time.ToString("h:mm tt"));
            total = BS.Count;
            BS.Filter = "";
            
            return total;
        
        }

But i keep running into problems that i cant use any operator ( like ,> ,= ,>=,) becuase it can not preform X onn system.int32 and system.string.

I've been looking around but all the example seem to be for strings or dates.

timer does not work

benjamin yap9-Jul-08 18:13

benjamin yap

9-Jul-08 18:13

hi, i have a timer which call this method CalPrice().

The calprice will check the dategridview first column if the checkbox ==true, then calculate the price base on the the other column

private void CalPrice()
       {
           double price = 0.0;
           foreach (DataGridViewRow dgw in dataGridProduct.Rows)
           {
               DataGridViewCheckBoxCell datacell = dgw.Cells[0] as DataGridViewCheckBoxCell;

               try
               {
                   if ((bool)datacell.Value == true)
                   {
                       //MessageBox.Show("" + dgw.ToString());

                       price += Convert.ToDouble(dgw.Cells[6].Value.ToString());

                   }
                   lblTotalPrice.Text = "Total Price : $ " + price;
               }

               catch (Exception exc)
               {
               }
           }
       private void timer1_Tick(object sender, EventArgs e)
       {
           CalPrice();
       }
       }

I have set the timer to enable and interval to 1000(1 second). But when i load the form, the timer dont seems to start. It does not call the calPrice method

Re: timer does not work

mav.northwind9-Jul-08 19:09

mav.northwind

9-Jul-08 19:09

Hi!
Did you debug or are you just assuming that CalPrice is not being called?
If you're simply swallowing any exception that's being thrown, you can come to false conclusions.

Apart from that you either didn't assign an event handler for Tick or you didn't start the timer - not much else that can go wrong. Timers work just fine for a lot of people out there, you know... Smile | :)

Regards,
mav

--
Black holes are the places where God divided by 0...

Re: timer does not work

benjamin yap9-Jul-08 19:34

benjamin yap

9-Jul-08 19:34

which event should i use to check if the column is tick or untick in a datagrid.

i tried cell_click but after i tick a checkbox, i have to click OUt of the datagrid, then it will populate the price

Re: timer does not work

Seishin#9-Jul-08 21:58

Seishin#

9-Jul-08 21:58

Maybe grid's CellValueChanged event - in the event arguments you get the index of the edited row and column index as well..

it's called when the value is commited ex. when the editmode is set to 'doubleclick or f2' [entar] commits value change.

also when you use Convert.To... you don't have to use ToString() on the converted object.

life is study!!!

THE PRINTER

Silvyster9-Jul-08 17:53

Silvyster

9-Jul-08 17:53

I want to know how to create a simple program that can print data using PRINTER CLASSES(if any) of C#?..

Re: THE PRINTER

Ajay.k_Singh9-Jul-08 22:33

Ajay.k_Singh

9-Jul-08 22:33

I am not clear about ‘Printer Classes’, however printing can be done using PrintDocument and Print Preview control.

In case if you need to access printer settings you may do so by accessing System.Drawing.Printing.PrinterSettings class items.

-Dave.

------------------------------------
http://www.componentone.com
------------------------------------

Re: THE PRINTER

Silvyster10-Jul-08 1:59

Silvyster

10-Jul-08 1:59

hmmm.. interesting... i'm trying to create my own text editor and should have the print feature.. am guessing maybe someone has already coded it so that i could just refer to the code. any tutorials or resources you have that could help?

close form

nelsonpaixao9-Jul-08 14:18

nelsonpaixao

9-Jul-08 14:18

hi,

i design a application that opens a form from other form, i use the ".showdialog" ".show" methods that works fine.

but a also want to close the first form when the second form loads, but i can´t manage to do that.
when i trie to do that i shutdown the all application or something else!!!

thanks!!! Cool | :cool:

Re: close form

Christian Graus9-Jul-08 15:21

Christian Graus

9-Jul-08 15:21

The logical thing to do here is to make both forms laid out on user controls, then show them both in the one form.

Christian Graus

No longer a Microsoft MVP, but still happy to answer your questions.

Re: close form

Nirandas9-Jul-08 22:59

Nirandas

9-Jul-08 22:59

You may hide the first form (Closing your start up form will close the application).
Also code will stop executing at the call ".ShowDialog()", and will only continue after the user has closed the second form.

Nirandas,
a developer from India.
http://www.nirandas.com

cancel button [X]

nelsonpaixao9-Jul-08 14:07

nelsonpaixao

9-Jul-08 14:07

Hi,

How can i trigger an event when the user presses the cancel button [X] on the title bar? i want the application to perform a final task before it goes off!

Sigh | :sigh:

Re: cancel button [X]

PIEBALDconsult9-Jul-08 14:58

PIEBALDconsult

9-Jul-08 14:58

You mean the Form's Closing event?

cancel button [X]

nelsonpaixao9-Jul-08 15:14

nelsonpaixao

9-Jul-08 15:14

it´s to manage a login/logout process!
I prefer that the user uses the logout button, but sometimes the user shotdown the application or it goes down.

I already have a store procedure for all that but, like i said, sometimes i can´t get logout info. Sigh | :sigh:

yes, a form closing or application closing event i think! Dead | X|

Re: cancel button [X]

Luc Pattyn9-Jul-08 15:21

Luc Pattyn

9-Jul-08 15:21

Form.FormClosing
and maybe FormClosingEventArgs.CloseReason

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Voting for dummies? No thanks. Dead | X|

Re: cancel button [X]

PIEBALDconsult10-Jul-08 4:19

PIEBALDconsult

10-Jul-08 4:19

nelsonpaixao wrote:
or it goes down

There's nothing you can do about a system crash or the user terminating the app via Task Manager.

I use a FormClosing event handler to do cleanup like that.

The handler for a Close button simply calls this.Close()

Re: cancel button [X]

PIEBALDconsult10-Jul-08 12:40

PIEBALDconsult

10-Jul-08 12:40

Then have the FormClosing handler call the Logout handler.

title bar

nelsonpaixao9-Jul-08 14:01

nelsonpaixao

9-Jul-08 14:01