protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { String URL = "http://localhost:49990/Service.svc/"; HttpWebRequest request = (HttpWebRequest)WebRequest.Create(URL); WebResponse response = request.GetResponse(); StreamReader reader = new StreamReader(response.GetResponseStream(), Encoding.UTF8); string json = reader.ReadToEnd(); DataTable db = JsonConvert.DeserializeObject <DataTable>(json); DatabaseFields.DataSource = db; DatabaseFields.DataBind(); } }
private void SetDatabaseFieldName() { switch (XmlPropertyName) { case XmlNodes.StandardName: DatabaseFieldName = DatabaseFields.STANDARDNAME; break; case XmlNodes.Version: DatabaseFieldName = DatabaseFields.VERSION; break; case XmlNodes.Description: DatabaseFieldName = DatabaseFields.DESCRIPTION; break; case XmlNodes.QtyBaseUnit: DatabaseFieldName = DatabaseFields.QTYBASEUNIT; break; case XmlNodes.TextTemplate: DatabaseFieldName = DatabaseFields.TEXTTEMPLATE; break; case XmlNodes.MassTemplate: DatabaseFieldName = DatabaseFields.MASSTEMPLATE; break; case XmlNodes.MassUnit: DatabaseFieldName = DatabaseFields.MASSUNIT; break; case XmlNodes.GroupReference: DatabaseFieldName = DatabaseFields.GROUPREFERENCE; break; case XmlNodes.DrawingName: DatabaseFieldName = DatabaseFields.DRAWINGNAME; break; case XmlNodes.NoPrjSpecFlag: DatabaseFieldName = DatabaseFields.NOPRJSPECFLAG; break; case XmlNodes.IdTagTemplate: DatabaseFieldName = DatabaseFields.IDTAGTEMPLATE; break; case XmlNodes.Name: DatabaseFieldName = DatabaseFields.MTRNAME; break; case XmlNodes.Mass: DatabaseFieldName = DatabaseFields.MASS; break; case XmlNodes.IdTag: DatabaseFieldName = DatabaseFields.IDTAG; break; case XmlNodes.MaterialCode: DatabaseFieldName = DatabaseFields.MATERIALCODE; break; case XmlNodes.Number: DatabaseFieldName = DatabaseFields.PARNUMBER; break; case XmlNodes.Context: DatabaseFieldName = DatabaseFields.CONTEXT; break; case XmlNodes.ValueType: DatabaseFieldName = DatabaseFields.VALUETYPE; break; case XmlNodes.Value: DatabaseFieldName = DatabaseFields.PARVALUE; break; case XmlNodes.Unit: DatabaseFieldName = DatabaseFields.PARUNIT; break; case XmlNodes.ValueOptions: DatabaseFieldName = DatabaseFields.VALUEOPTIONS; break; case XmlNodes.ContextString: DatabaseFieldName = DatabaseFields.CONTEXTSTRING; break; case XmlNodes.ExternalName: DatabaseFieldName = DatabaseFields.EXTERNALNAME; break; case XmlNodes.GroupName: DatabaseFieldName = DatabaseFields.GROUPNAME; break; default: break; } }