예제 #1
0
        public gettestdata GetInfo()
        {
            gettestdata   g   = new gettestdata();
            SqlConnection con = new SqlConnection("Data Source=DESKTOP-LDV7NOV;Initial Catalog=WCFService1;Integrated Security=True");

            con.Open();
            SqlCommand     cmd = new SqlCommand("Select * from UserTab", con);
            SqlDataAdapter da  = new SqlDataAdapter(cmd);
            DataTable      dt  = new DataTable("mytab");

            da.Fill(dt);
            g.usertab = dt;
            return(g);
        }
예제 #2
0
        public gettestdata GetInfo()
        {
            gettestdata   g   = new gettestdata();
            SqlConnection con = new SqlConnection("Data Source=DESKTOP-0QLRLVG;Initial Catalog=CrudDB;Persist Security Info=True;User ID=sa; Password=albana123");

            con.Open();
            SqlCommand     cmd = new SqlCommand("Select * from dbo.UserTab", con);
            SqlDataAdapter da  = new SqlDataAdapter(cmd);
            DataTable      dt  = new DataTable("mytab");

            da.Fill(dt);
            g.usertab = dt;
            return(g);
        }
        public gettestdata GetInfo()
        {
            gettestdata   g   = new gettestdata();
            SqlConnection con = new SqlConnection("Data Source=TEPOS;Initial Catalog=TestDB;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");

            con.Open();
            SqlCommand     cmd = new SqlCommand("Select*From UserTab", con);
            SqlDataAdapter da  = new SqlDataAdapter(cmd);
            DataTable      dt  = new DataTable("mytab");

            da.Fill(dt);
            g.usertab = dt;
            return(g);
        }
예제 #4
0
        public gettestdata GetInfo()
        {
            gettestdata   g   = new gettestdata();
            SqlConnection con = new SqlConnection("Data Source=DESKTOP-9BLFC43\\AFANDISQL;Initial Catalog=PatWcf;Persist Security Info=True;User ID=sa; Password=Nurafandi09");

            con.Open();
            SqlCommand     cmd = new SqlCommand("Select * from UserTab", con);
            SqlDataAdapter da  = new SqlDataAdapter(cmd);
            DataTable      dt  = new DataTable("mytab");

            da.Fill(dt);
            g.usertab = dt;
            return(g);
        }
예제 #5
0
        public gettestdata GetInfo()
        {
            gettestdata   g   = new gettestdata();
            SqlConnection con = new SqlConnection("Data Source=LAPTOP-54NOARJ3;Initial Catalog=MyTestDB;Persist Security Info=True;User ID=sa; Password=123;Pooling=False");

            con.Open();
            SqlCommand     cmd = new SqlCommand("Select*from UserTab", con);
            SqlDataAdapter da  = new SqlDataAdapter(cmd);
            DataTable      dt  = new DataTable("mytab");

            da.Fill(dt);
            g.usertab = dt;
            return(g);
        }
예제 #6
0
        public gettestdata GetInfo()
        {
            gettestdata   g   = new gettestdata();
            SqlConnection con = new SqlConnection("Data Source=DESKTOP-7DLLAR8;Initial Catalog=WCFservice1;Persist Security Info=True;User ID=sa; Password=123");

            con.Open();
            SqlCommand     cmd = new SqlCommand("Select * from UserTab", con);
            SqlDataAdapter da  = new SqlDataAdapter(cmd);
            DataTable      dt  = new DataTable("mytab");

            da.Fill(dt);
            g.UserTab = dt;
            return(g);
        }
예제 #7
0
        public gettestdata GetInfo()
        {
            gettestdata   g   = new gettestdata();
            SqlConnection con = new SqlConnection("Data Source=DESKTOP-CM1O7BQ;Initial Catalog=MyTestDB;User ID=sa;Password=123");

            con.Open();
            SqlCommand     cmd = new SqlCommand("Select * from UserTab", con);
            SqlDataAdapter da  = new SqlDataAdapter(cmd);
            DataTable      dt  = new DataTable("mytab");

            da.Fill(dt);
            g.usertab = dt;
            return(g);
        }
        public gettestdata GetInfo()
        {
            gettestdata    g   = new gettestdata();
            SqlConnection  con = new SqlConnection("Data Source=LAPTOP-HGH9CCBA;Initial Catalog=MyTestDB;Persist Security Info=True;User ID=sa;Password=311000;Pooling=False"); con.Open();
            SqlCommand     cmd = new SqlCommand("Select * from UserTab", con);
            SqlDataAdapter da  = new SqlDataAdapter(cmd);
            DataTable      dt  = new DataTable("UserTab");

            da.Fill(dt);
            g.userTab = dt;
            cmd.ExecuteNonQuery();
            con.Close();
            return(g);
        }
예제 #9
0
        public gettestdata GetInfo()
        {
            gettestdata   g   = new gettestdata();
            SqlConnection con = new SqlConnection("Data Source = desktop-gb128hp\\mssql2014; Initial Catalog = MyTestDB; Persist Security Info = True; User ID = sa; Password = FErdy277; Pooling = false;");

            con.Open();
            SqlCommand     cmd = new SqlCommand("Select * from UserTab", con);
            SqlDataAdapter da  = new SqlDataAdapter(cmd);
            DataTable      dt  = new DataTable("mytab");

            da.Fill(dt);
            g.usertab = dt;
            return(g);
        }
예제 #10
0
        public gettestdata GetInfo()
        {
            gettestdata   g   = new gettestdata();
            SqlConnection con = new SqlConnection("Data Source=DESKTOP-4ON24VD\\MUAMMARSQL;Initial Catalog=pat_wcf;Persist Security Info=True;User ID=sa; Password=muammar310");

            con.Open();
            SqlCommand     cmd = new SqlCommand("Select * from UserTab", con);
            SqlDataAdapter da  = new SqlDataAdapter(cmd);
            DataTable      dt  = new DataTable("mytab");

            da.Fill(dt);
            g.usertab = dt;
            return(g);
        }
예제 #11
0
        public gettestdata GatInfo()
        {
            gettestdata   g   = new gettestdata();
            SqlConnection con = new SqlConnection("Data Source=DESKTOP-3M69Q4U;Initial catalog=MyTestDB;Persist Security info=True;User ID=sa;Password=Pbun2018;Pooling=False");

            con.Open();
            SqlCommand     cmd = new SqlCommand("Select * from UserTab", con);
            SqlDataAdapter da  = new SqlDataAdapter(cmd);
            DataTable      dt  = new DataTable("UserTab");

            da.Fill(dt);
            g.usertab = dt;
            return(g);
        }
예제 #12
0
        public gettestdata GetInfo()
        {
            gettestdata g = new gettestdata();

            con.Open();
            SqlCommand     cmd = new SqlCommand("Select * from UserTab", con);
            SqlDataAdapter da  = new SqlDataAdapter(cmd);
            DataTable      dt  = new DataTable("UserTab");

            da.Fill(dt);
            g.usertab = dt;
            cmd.ExecuteNonQuery();
            con.Close();
            return(g);
        }