public gettestdata GetInfo() { gettestdata g = new gettestdata(); SqlConnection con = new SqlConnection("Data Source=WINDOWS-C8ATAQL;Initial Catalog=CRUD;Persist Security Info=True;User ID=sa; Password=pacitan1"); 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(); 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); }