Exemplo n.º 1
0
        public int SPExecutorSQLClient(string sqlCommand, string connString)
        {
            int        returnValue  = 0;
            SqlResults ucSQLResults = new SqlResults();

            try
            {
                using (SqlConnection con = new SqlConnection(connString))  //here is the error
                {
                    con.Open();
                    SqlCommand oldbCmd = new SqlCommand(sqlCommand, con);
                    oldbCmd.CommandType = CommandType.StoredProcedure;
                    SqlParameter rParam = new SqlParameter();
                    rParam.Direction = ParameterDirection.ReturnValue;
                    rParam.DbType    = DbType.Int64;
                    oldbCmd.Parameters.Add(rParam);
                    Object res = oldbCmd.ExecuteScalar();
                    con.Close();
                    returnValue = Convert.ToInt32(rParam.Value);
                }
            }
            catch (Exception ex)
            {
                return(-1);
            }
            return(returnValue);
        }
Exemplo n.º 2
0
        public frmSQLResults(SqlResults sr)
        {
            InitializeComponent();
            this.sqlResult.AssignDataSourceToDGV(sr.GetQueryDataSource(), sr.GetConnectionString());
            this.sqlResult.AddInputQuery(sr.GetQueryString(), true, false);
            this.sqlResult.AddTextToMessages(sr.GetMessage(), true, false);
            sqlResult.ShowSizeButtons(false);

            this.Text = this.Text + " ( " + GetFromText(sr.GetQueryString()) + " )";
        }
Exemplo n.º 3
0
        private void ShowSQLResultsInNewForm(SqlResults sr)
        {
            frmSQLResults fsr = new frmSQLResults(sr);

            try
            {
                fsr.ShowDialog();
            }
            catch (Exception ex)
            {
                fsr.ShowDialog();
            }
        }
Exemplo n.º 4
0
        public bool CommandExecutor(string sqlCommand, string connString)
        {
            bool       returnValue  = true;
            SqlResults ucSQLResults = new SqlResults();

            try
            {
                using (OleDbConnection con = new OleDbConnection(connString))  //here is the error
                {
                    con.Open();
                    OleDbCommand oldbCmd = new OleDbCommand(sqlCommand, con);
                    oldbCmd.ExecuteNonQuery();
                    con.Close();
                }
            }
            catch (Exception ex)
            {
                return(false);
            }
            return(returnValue);
        }
Exemplo n.º 5
0
        public List <SqlResults> DataExecutor(string selectCommand, string connString, bool treatSemicolonAsNewLine = false)
        {
            List <SqlResults> sqlResults = new List <SqlResults>();

            string[] sqlStrs = new string[] { string.Empty };

            if (!treatSemicolonAsNewLine)
            {
                sqlStrs = selectCommand.Split(';');
            }
            else
            {
                sqlStrs[0] = selectCommand.Replace(';', ' ');
            }

            for (int i = 0; i < sqlStrs.Length; i++)
            {
                using (StreamWriter w = File.AppendText(SQLExecutor.sqlCommandLogFile))
                {
                    w.WriteLine(sqlStrs[i]);
                }

                sqlStrs[i] = sqlStrs[i].Replace(Environment.NewLine, "");

                if (String.IsNullOrEmpty(sqlStrs[i]))
                {
                    continue;
                }

                SqlResults ucSQLResults = new SqlResults();
                try
                {
                    using (OleDbConnection con = new OleDbConnection(connString))  //here is the error
                    {
                        con.Open();
                        OleDbCommand     oldbCmd = new OleDbCommand(sqlStrs[i], con);
                        OleDbDataAdapter oldbDA  = new OleDbDataAdapter(oldbCmd);
                        DataSet          ds      = new DataSet();
                        int numRows = oldbDA.Fill(ds);

                        string sqlMsg = "Total Rows returned (" + numRows.ToString() + ").";

                        if (ds.Tables.Count > 0)
                        {
                            ucSQLResults.AssignDataSourceToDGV(ds.Tables[0], connString);
                        }

                        ucSQLResults.AddTextToMessages(sqlMsg, true, false);
                        ucSQLResults.AddInputQuery(sqlStrs[i], true, false);
                        con.Close();
                    }
                }
                catch (Exception ex)
                {
                    string queryCommand = sqlStrs[i];
                    ucSQLResults.AddTextToMessages(queryCommand, true, false);
                    string sqlMsg = "Error: " + ex.ToString();
                    ucSQLResults.AddTextToMessages(sqlMsg, false, true);
                    ucSQLResults.AddInputQuery(queryCommand, false, true);
                    ucSQLResults.AddConnString(connString);
                }
                ucSQLResults.AdjustHeightBasedOnTotalRows();
                sqlResults.Add(ucSQLResults);
            }

            return(sqlResults);
        }
Exemplo n.º 6
0
        private void ShowSQLResultsInNewForm(SqlResults sr)
        {
            frmSQLResults fsr = new frmSQLResults(sr);

            fsr.ShowDialog();
        }