StringBuilder taskStr = new StringBuilder ( "[");using (SqlConnection conn = newSqlConnection(connString))
{
conn.Open();string strSQL = @"select * from Tasks order by OrderNumber";//SqlCommand cmd = new SqlCommand(strSQL, conn);//SqlDataReader rdr = cmd.ExecuteReader();
SqlDataAdapter myda = newSqlDataAdapter(strSQL, conn);
DataSet myds= newDataSet();
myda.Fill(myds);
DataTable tb= myds.Tables[0];for (int i = 0; i < tb.Rows.Count; i++)
{
DataRow row=tb.Rows[i];int UID = int .Parse(row[ "OrderNumber"].ToString());string taksName = row["Title"].ToString();
DateTime StartDate= DateTime .Parse(row[ "StartDate"].ToString());
DateTime DueDate= DateTime .Parse(row[ "DueDate"].ToString());
TimeSpan ts=DueDate.Subtract(StartDate);int FatherTask = int .Parse(row[ "FatherTask"].ToString());int datelenth =ts.Days;
taskStr.Append("{");
taskStr.Append("'UID': '" + UID + "',");
taskStr.Append("'Name': '" + taksName + "',");
taskStr.Append("'Duration':" + datelenth + ",");
taskStr.Append("'Start': '" + StartDate.ToString() + ":T00:00:00" + "',");
taskStr.Append("'Finish': '" + DueDate.ToString() + ":T00:00:00" + "',");
taskStr.Append("'PercentComplete':" + 0 + ",");if (FatherTask == -1)
taskStr.Append("'Summary':" + 1 + ",");elsetaskStr.Append("'Summary':" + 0 + ",");
taskStr.Append("'Critical':" + 1 + ",");
taskStr.Append("'Milestone':" + 0 + ",");
taskStr.Append("'PredecessorLink': 0,");
taskStr.Append("'ParentTaskUID':" + FatherTask + ",");
taskStr.Append("}");if (i != tb.Rows.Count - 1)
taskStr.Append(",");
}
taskStr.Append("]");
}
Response.Write(taskStr.ToString());
Response.End();