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;
}
}
