62,269
社区成员
发帖
与我相关
我的任务
分享string dbDtr = string.Format("server={0};database={1};uid={2};pwd={3}", "localhost", "Northwind", "sa", "xxxxxx");
string param = Convert.ToString(Request["param"]);
Access.connstring = Convert.ToString(dbDtr);
string sql = String.Format("select [Name] from {0}..sysobjects WHERE [type] IN (N'U')", "Northwind");
DataSet ds = Access.GetDataSet(sql);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
List<Hashtable> testList = new List<Hashtable>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Hashtable ht = new Hashtable();
DataRow row = ds.Tables[0].Rows[i] as DataRow;
ht["TableName"] = Convert.ToString(row["Name"]);
testList.Add(ht);
}
string json = JavaScriptConvert.SerializeObject(testList);
Response.Write(json);
} [{"TableName":"Orders"},{"TableName":"Products"},{"TableName":"Order Details"},{"TableName":"CustomerCustomerDemo"},{"TableName":"CustomerDemographics"},{"TableName":"Region"},{"TableName":"Territories"},{"TableName":"EmployeeTerritories"},{"TableName":"dtproperties"},{"TableName":"Employees"},{"TableName":"Categories"},{"TableName":"Customers"},{"TableName":"Shippers"},{"TableName":"Suppliers"}] public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
List<Post> posts = new List<Post>()
{
new Post{ Id=1, Title="一步一步学Silverlight 2系列(13):数据与通信之WebRequest", Author="TerryLee" },
new Post{ Id=2, Title="一步一步学Silverlight 2系列(12):数据与通信之WebClient", Author="TerryLee" },
new Post{ Id=3, Title="一步一步学Silverlight 2系列(11):数据绑定", Author="TerryLee" },
new Post{ Id=4, Title="一步一步学Silverlight 2系列(10):使用用户控件", Author="TerryLee" },
new Post{ Id=5, Title="一步一步学Silverlight 2系列(9):使用控件模板", Author="TerryLee" },
new Post{ Id=6, Title="一步一步学Silverlight 2系列(8):使用样式封装控件观感", Author="TerryLee" }
};
Blog blog = new Blog();
blog.Posts = posts;
context.Response.Write(JavaScriptConvert.SerializeObject(blog));
}