Click here to Skip to main content
15,908,264 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Drawing.Imaging;
using System.IO;
using Microsoft.VisualBasic;
using Microsoft.SqlServer.Management.Common;
using Microsoft.SqlServer.Management.Smo;
using System.Diagnostics;

namespace Parking
{
    public partial class Splash : Form
    {
        public Splash()
        {
            InitializeComponent();
        }

        ClassValidaciones util = new ClassValidaciones();
        int LoadPercent;

        private void Splash_Load(object sender, EventArgs e)
        {
            splashTimer1.Enabled = true;
            LoadPercent = 0;
        }

        private void splashTimer1_Tick(object sender, EventArgs e)
        {
            if (LoadPercent < 99)
            {
                LoadPercent += 1;
                lblLoadPerc.Text = LoadPercent.ToString();
            }
            else
            {
                splashTimer1.Enabled = false;
                Hide();

                if (CheckDatabaseExists(txtdatabase.Text))
                {
                }
                else
                {
                    crearbasededatos();
                }
                FormLogin frm = new FormLogin();
                frm.Show();
            }
        }

        public void crearbasededatos()
        {
            try
            {
                string ruta = Application.StartupPath + "\\ELPARKING.bak";

                string sBackup = "RESTORE DATABASE " + this.txtdatabase.Text +
                                 " FROM DISK = '" + ruta + "'" +
                                 " WITH REPLACE";

                SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder();
                csb.DataSource = this.txtServerName.Text;
                // Es mejor abrir la conexión con la base Master
                csb.InitialCatalog = "master";
                csb.IntegratedSecurity = true;
                //csb.ConnectTimeout = 480; // el predeterminado es 15

                using (SqlConnection con = new SqlConnection(csb.ConnectionString))
                {
                    con.Open();
                    SqlCommand cmdBackUp = new SqlCommand(sBackup, con);
                    cmdBackUp.ExecuteNonQuery();
                    util.Mensajes(3, "El Software PARKING fue instalado satisfatoriamente. \nIngrese al Sistema con las Credenciales por defecto 1234. \nEstando dentro del Sistema Llene el Formulario de Datos del Negocio. \nEl Formulario de Datos del Negocio se encuentra en el boton Ajustes.");
                    con.Close();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                //util.Mensajes(6, "Comuniquese con Nuestro Soporte Tecnico");
            }
        }

        public static bool CheckDatabaseExists(string dataBase)
        {
            string conStr = "Data Source=.;Initial Catalog=master;Integrated Security=True";
            string cmdText = "SELECT * FROM master.dbo.sysdatabases WHERE name ='" + dataBase + "'";
            bool isExist = false;
            using (SqlConnection con = new SqlConnection(conStr))
            {
                con.Open();
                using (SqlCommand cmd = new SqlCommand(cmdText, con))
                {
                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        isExist = reader.HasRows;
                    }
                }
                con.Close();
            }
            return isExist;
        }
    }
}


What I have tried:

My program when compiling it comes out correct but when executing it it stops in a splash.cs, please can you help me
Posted
Updated 21-Aug-22 1:30am
v2
Comments
[no name] 21-Aug-22 10:47am    
Which line did it "stop" on? (It's a little busy for a "splash" screen; in fact, the pattern is just wrong).

Compiling does not mean your code is right! :laugh:
Think of the development process as writing an email: compiling successfully means that you wrote the email in the right language - English, rather than German for example - not that the email contained the message you wanted to send.

So now you enter the second stage of development (in reality it's the fourth or fifth, but you'll come to the earlier stages later): Testing and Debugging.

Start by looking at what it does do, and how that differs from what you wanted. This is important, because it give you information as to why it's doing it. For example, if a program is intended to let the user enter a number and it doubles it and prints the answer, then if the input / output was like this:
Input   Expected output    Actual output
  1            2                 1
  2            4                 4
  3            6                 9
  4            8                16
Then it's fairly obvious that the problem is with the bit which doubles it - it's not adding itself to itself, or multiplying it by 2, it's multiplying it by itself and returning the square of the input.
So with that, you can look at the code and it's obvious that it's somewhere here:
C#
private int Double(int value)
   {
   return value * value;
   }

Once you have an idea what might be going wrong, start using the debugger to find out why. Put a breakpoint on the first line of the method, and run your app. When it reaches the breakpoint, the debugger will stop, and hand control over to you. You can now run your code line-by-line (called "single stepping") and look at (or even change) variable contents as necessary (heck, you can even change the code and try again if you need to).
Think about what each line in the code should do before you execute it, and compare that to what it actually did when you use the "Step over" button to execute each line in turn. Did it do what you expect? If so, move on to the next line.
If not, why not? How does it differ?
Hopefully, that should help you locate which part of that code has a problem, and what the problem is.
This is a skill, and it's one which is well worth developing as it helps you in the real world as well as in development. And like all skills, it only improves by use!

And by the way ... C++ and C# are very different languages that share some common syntax. Describing you code as C++ when it's C# means that people who know C# will be less likely to look at it.
 
Share this answer
 
v2
Comments
Greg Utas 21-Aug-22 6:58am    
I changed the tag to C#.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900