/
Default.aspx.cs
89 lines (74 loc) · 2.54 KB
/
Default.aspx.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Text;
public partial class _Default : System.Web.UI.Page
{
SqlConnection sqlcon = new SqlConnection("Server=7402fdb9-611a-4a2c-8ce6-a4ef00aece3d.sqlserver.sequelizer.com;Database=db7402fdb9611a4a2c8ce6a4ef00aece3d;User ID=olajscujyglsryfi;Password=yNUVfoKWJqTTbiKr3dZDNLSawq6kaFEMzo3q8CTtZmVAudvYLiXMgQNV5TxWryWd;");
SqlDataAdapter da = new SqlDataAdapter();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
show();
}
}
public void show()
{
da = new SqlDataAdapter("select * from mytbl12",sqlcon);
DataTable dt = new DataTable();
da.Fill(dt);
Response.Write(DataTableToJsonObj(dt));
}
public string DataTableToJsonObj(DataTable dt)
{
DataSet ds = new DataSet();
ds.Merge(dt);
StringBuilder JsonString = new StringBuilder();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
JsonString.Append("{");
JsonString.Append("\"data\"");
JsonString.Append(":");
JsonString.Append("[");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
JsonString.Append("{");
for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
{
if (j < ds.Tables[0].Columns.Count - 1)
{
JsonString.Append("\"" + ds.Tables[0].Columns[j].ColumnName.ToString() + "\":" + "\"" + ds.Tables[0].Rows[i][j].ToString() + "\",");
}
else if (j == ds.Tables[0].Columns.Count - 1)
{
JsonString.Append("\"" + ds.Tables[0].Columns[j].ColumnName.ToString() + "\":" + "\"" + ds.Tables[0].Rows[i][j].ToString() + "\"");
}
}
if (i == ds.Tables[0].Rows.Count - 1)
{
JsonString.Append("}");
}
else
{
JsonString.Append("},");
}
}
JsonString.Append("]");
JsonString.Append("}");
return JsonString.ToString();
}
else
{
return null;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
}
}