For example, days1 = day1 + month1*31 + year1*365; days2 = day2 + month2*31 + year2*365; if( days1 > days2 ) { do something } else { do something } - NS - [ODBaseBtn]

Tq for your help...

Can you show me where to put the coding , I can understand. Tq very much.

Hello mate, Windows Applications were never meant to be connected to anythingelse than MS product. But you are in LUCK as there are ways to make your Windows Application work flawlessly with other technologies such as MySQL. Step 1: In order for your Windows Application written in C# to get connected to MySQL you need to have the right driver. You can get this from the good old MySQL website. Here is the link to save you the time and the headache looking for it, mate. http://dev.mysql.com/downloads/connector/odbc/3.51.html[^] Download and install the right package and then you are ready for Rock & Roll. Step 2: Add the following into your C# Windows Application: private System.Data.Odbc.OdbcConnection OdbcCon; //open connection to server private System.Data.Odbc.OdbcCommand OdbcCom; //run a query on the database private System.Data.Odbc.OdbcDataReader OdbcDR; //read the query private System.Data.Odbc.OdbcDataAdapter OdbcAd; //Create a bridge between the Dataset and data source private string ConStr; Step 3: Now you are ready to talk to your Database, mate. Just talk to your database using MySQL commands. What can be done is simply limited only by your imagination. Here is a few examples to set you in the right direction. Example 1: Getting Connected to MySQL database: private void btnConnect_Click(object sender, EventArgs e) { ConStr = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=" + txtIP.Text + ";PORT=" + txtPort.Text + ";DATABASE=" + txtDatabase.Text + ";UID=" + txtUsername.Text + ";PWD=" + txtPassword.Text + ";OPTION=3"; OdbcCon = new System.Data.Odbc.OdbcConnection(ConStr); btnListTables.Enabled = true; try { txtLog.AppendText("Openning connection...\r\n"); if (OdbcCon.State == ConnectionState.Closed) { OdbcCon.Open(); } txtLog.AppendText("Connection opened\r\n"); } catch (System.Data.Odbc.OdbcException Ex) { txtLog.AppendText(Ex.Message + "\r\n"); MessageBox.Show("Could not access the database.\r\nPlease make sure you completed the fields with the correct information and try again.\r\n\r\nMore details:\r\n"

krajah1984 wrote: How to get the text that user keyin in textbox in other window form to another form.Like from form1 to form2. You could read this article on passing values between forms[^] Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website

it doesnt work like this.. =| is there any other way?

You're looking for the Process[^] class. Dave Kreskowiak Microsoft MVP - Visual Basic

Just put a check to validate the user entered password with the default password. If both are same, the show the form2. Thats it.. public partial class Form1 : Form { Form2 form2 = new Form2(); public Form1() { InitializeComponent(); Password.PasswordChar = '*'; //Masking Char } private void Form1_Ok_Click(object sender, EventArgs e) { string strDefaultPassword = "ABCD"; //Keep ur default passowrd string strEnteredPassword = Password.Text; if(strEnteredPassword == strDefaultPassword ) { this.hide(); form2.ShowDialog(); } else { MessageBox.Show("Wrong password entered"); this.Close(); } } } Thanks & Rgds, Sri..

No-oe can tell you, because we don't know where the password comes from. The best asumption is a database, in which case, a proc that returns true or false for a username/password pair is the best bet. krajah1984 wrote: If correct link to another form and aotomaticlly close this form.If wrong automaticlly close this form. Close(); will close a form. Is this form the main form of the app ? You could have issues here, also. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

if u are using vs2005 then u dont need to write so much just go to the code and in auth. write ur code. But u r using vs2003 then u find the code on this portal on the left hand side of the Home Page.... Regards, Smart Boy Mumbai, (INDIA)