static DataView getdv(string SQLText)
        {
            string strconn = System.Configuration.ConfigurationManager.AppSettings["kdatastrconn"];
            SqlConnection conn = new SqlConnection(strconn);
            conn.Open();
            SqlCommand mCommand = new SqlCommand(SQLText, conn);
            mCommand.CommandType = CommandType.Text;
            mCommand.CommandText = SQLText;
            mCommand.CommandTimeout = 3600;
            SqlDataAdapter adapter = new SqlDataAdapter();
            DataSet ds = new DataSet();
            adapter.SelectCommand = mCommand;
            adapter.Fill(ds, "t1");
            conn.Close();
            return ds.Tables[0].DefaultView;
        }