public void creatEquityTicket() { SqlConnection cn = new SqlConnection("Data Source=ZM-SQL-1;Initial Catalog=ZM_GALLAGHER; Integrated Security=SSPI;"); cn.Open(); SqlCommand CMD = new SqlCommand(); CMD = cn.CreateCommand(); SqlDataReader RDR; //CMD.CommandText = "IF OBJECT_ID('EQUITY_TICKET', 'U') IS NOT NULL DROP TABLE EQUITY_TICKET;"; CMD.CommandText = "IF OBJECT_ID (N'EQUITY_TICKET',N'U') IS NOT NULL SELECT 1 AS RES ELSE SELECT 0 AS RES;"; RDR = CMD.ExecuteReader(); RDR.Read(); if (RDR.GetValue(0).ToString() == "0") { RDR.Close(); CMD.CommandText = "CREATE TABLE EQUITY_TICKET( [ID][int] IDENTITY(1, 1) NOT NULL, TKT_USER[VARCHAR](255) NOT NULL, " + " TKT_ACCOUNT_ID [INT] NOT NULL, TKT_TICKER[VARCHAR](10) NOT NULL, TKT_DATE[datetime] NOT NULL )"; CMD.ExecuteNonQuery(); } RDR.Close(); cn.Close(); }
private void quita() { MySqlConnection Conexion_BD = new MySqlConnection("server=127.0.0.1; database = gestor1; Uid=root; pwd=;"); //private SqlConnection Conexion_BD = new SqlConnection(Properties.Settings.Default.ConBDatos); MySqlCommand CMD; MySqlDataReader RDR; MySqlCommand consulta = new MySqlCommand("select Tipo_usuario from usuarios where Tipo_usuario = 'ADMIN'"); consulta.Connection = Conexion_BD; Conexion_BD.Open(); consulta.ExecuteNonQuery(); consulta.CommandType = CommandType.Text; consulta.Parameters.Add(new MySqlParameter()); RDR = consulta.ExecuteReader(); if (RDR.Read()) { CMB_TipUsu.Items.Remove("ADMIN"); } Conexion_BD.Close(); //"select * from usuarios where Tipo_usuario = 'ADMIN'"; }