SqlConnection con = new SqlConnection("server=.;database=uk_coupon_main_database;uid=sa;pwd=");
con.Open();
SqlCommand com = new SqlCommand("select * from UK_Province", con);
com.ExecuteNonQuery();
DataSet ds=new DataSet();
SqlDataAdapter adp=new SqlDataAdapter(com);
adp.Fill(ds,"UK_Province");