protected void Page_Load(object sender, EventArgs e)
{
//Get Data
SqlCommand cmd = new SqlCommand("[Stored Proc Name]", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 14400;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
if (con.State != ConnectionState.Open)
con.Open();
da.Fill(ds);
con.Close();
DataTable dt = ds.Tables[0];
string json = "[";
//Build JSON
foreach (DataRow dr in dt.Rows)
{
json = "{";
foreach (DataColumn dc in dt.Rows)
json += "\"" + dc.ColumnName + "\": \"" + dr[dc.ColumnName] + "\"";
json = "}";
}
json += "]";
ParseWebRequest request = new ParseWebRequest();
request.UpdateParseDataPost("ParjvvKO2Xxt0R1qbJccfxT7CzJF9jAjjseSWPsW"
, "84Q84H3PIlWWZVxBQQDpGz2a3t3TR2bViIJcLb0A"
, "https://api.parse.com/1/classes/Booth" //+ "/" + ""
, json);
}
