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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
