예제 #1
0
        public virtual DataTable QueryInfo(string xSQL, fc.DBInfo xDBInfo)
        {
            SqlConnection conn = null;

            conn = null;
            conn = new SqlConnection(makeConnectString(xDBInfo));
            try
            {
                conn.Open();
                SqlCommand myCommand = null;
                myCommand = new SqlCommand(xSQL, conn);

                SqlDataAdapter sqldataadpt = new SqlDataAdapter(myCommand);
                DataTable      dt1         = new DataTable();
                sqldataadpt.Fill(dt1);

                conn.Close();
                return(dt1);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
                fc.ErrorLog(ex.Message);
                return(null);
            }
        }
예제 #2
0
        public string makeConnectString(fc.DBInfo xDBInfo)
        {
            string mRes = "Persist Security Info=true" +
                          ";Integrated Security=" +
                          ";Data Source=" + xDBInfo.IP +
                          ";Initial Catalog=" + xDBInfo.DB +
                          ";User ID=" + xDBInfo.ID +
                          ";Password=" + xDBInfo.PW;

            return(mRes);
        }