C#

private void Form1_Load(object sender, EventArgs e)
{
// code if any
timer1.Enabled = true;
}

private void timer1_tick(object sender, EventArgs e)
{
timer1.Enabled = false;
// splash screen code 
}

//your code
Application.Exit()
Application.Restart()

raghu.chanti wrote:

hi
i want to populate country's name in 1st dropdownlist and their states should be placed in the 2nd dropdownlist, if we select any state it should place the name of the capital in the textbox besides that and so on.....
If possible send me code

<br />
<br />
<br />
    using System;<br />
    using System.Collections.Generic;<br />
    using System.Text;<br />
    using System.Data;<br />
    using System.Data.OleDb;<br />
   <br />
    public class mdGlobal<br />
    {<br />
        string ConnectionString = "Provider=Microsoft.jet.oledb.4.0;data source=" + DatabasePath + " ;Jet OLEDB:Database Password=123";<br />
       //Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\bin\Debug\SaleAmount.mdb;Jet OLEDB:Database Password=123<br />
       OleDbConnection con;<br />
       OleDbCommand Com;<br />
       OleDbDataAdapter da;<br />
      <br />
       public object ExecuteScaler(string MyQuery)<br />
       {<br />
           try {<br />
               con = new OleDbConnection(ConnectionString);<br />
               Com = new OleDbCommand(MyQuery, con);<br />
               con.Open();<br />
               object result = Com.ExecuteScalar;<br />
               con.Close();<br />
               return result;<br />
           }<br />
           catch (Exception ex) {<br />
               mdChecking.Prompt(ex.Message.ToString);<br />
               if (con.State == ConnectionState.Open) {<br />
                   con.Close();<br />
               }<br />
           }<br />
          <br />
       }<br />
      <br />
       public void ExecuteQuery(string MyQuery)<br />
       {<br />
           try {<br />
               con = new OleDbConnection(ConnectionString);<br />
               Com = new OleDbCommand(MyQuery, con);<br />
               con.Open();<br />
               Com.ExecuteNonQuery();<br />
               con.Close();<br />
           }<br />
           catch (Exception ex) {<br />
               mdChecking.Prompt(ex.Message.ToString);<br />
               if (con.State == ConnectionState.Open) {<br />
                   con.Close();<br />
               }<br />
           }<br />
          <br />
       }<br />
      <br />
       public DataSet GetResultFromQuery(string MyQuery)<br />
       {<br />
           try {<br />
               DataSet ds;<br />
               con = new OleDbConnection(ConnectionString);<br />
               da = new OleDbDataAdapter(MyQuery, con);<br />
               ds = new DataSet();<br />
               con.Open();<br />
               da.Fill(ds);<br />
               con.Close();<br />
               return ds;<br />
           }<br />
           catch (Exception ex) {<br />
               mdChecking.Prompt(ex.Message.ToString);<br />
               if (con.State == ConnectionState.Open) {<br />
                   con.Close();<br />
               }<br />
           }<br />
          <br />
       }<br />
      <br />
       public long ReturnSingleValue(string MyQuery)<br />
       {<br />
           try {<br />
              DataSet ds;<br />
               long result;<br />
               con = new OleDbConnection(ConnectionString);<br />
               da = new OleDbDataAdapter(MyQuery, con);<br />
               ds = new DataSet();<br />
               con.Open();<br />
               da.Fill(ds);<br />
               if (ds.Tables(0).Rows.Count > 0) {<br />
                   if (!Information.IsDBNull(ds.Tables(0).Rows(0).Item(0))) {<br />
                       result = (long)ds.Tables(0).Rows(0).Item(0);<br />
                   }<br />
                   else {<br />
                       result = -1;<br />
                   }<br />
               }<br />
               else {<br />
                   result = -1;<br />
               }<br />
               con.Close();<br />
               return result;<br />
           }<br />
           catch (Exception ex) {<br />
               mdChecking.Prompt(ex.Message.ToString);<br />
               if (con.State == ConnectionState.Open) {<br />
                  con.Close();<br />
              }<br />
          }<br />
         <br />
      }<br />
     <br />
  }<br />
<br />
<br />

<br />
static class Program<br />
    {<br />
        [STAThread]<br />
        static void Main()<br />
        {<br />
            Application.EnableVisualStyles();<br />
            Application.SetCompatibleTextRenderingDefault(false);<br />
<br />
            //opening a connection to the SQL database<br />
            string ConnString = @"User id = ***; Password = ***; Initial Catalog = ***;<br />
                                Data Source = ***";<br />
<br />
            SqlConnection sqlConn = new SqlConnection(ConnString);<br />
<br />
            //open the main form (passing sqlConn)<br />
            Application.Run(new FrmMain(userClass, sqlConn));<br />
        }<br />
    }<br />

<br />
public partial class FrmMain : Form<br />
    {<br />
        SqlConnection sqlConn;<br />
<br />
        public FrmMain(SqlConnection sqlCon)<br />
        {<br />
            InitializeComponent();<br />
            sqlConn = sqlCon;<br />
        }<br />
    }<br />

HarveySaayman wrote:

if u make a new connection every time u want to get data from a database you cause unnecicary overhead and lag when you are opening the window (assuming u make the connection OnFormLoad)

what you sould be doing is making a connection when the program starts up in the Main() method

then when you open a new window u send the instance of the dataBaseConnection to that form