作者:手机用户2502871993 | 来源:互联网 | 2023-06-28 02:35
webapi的controller中:(js调用该controller,然后返回数据给Js处理)publicstringgetztreenode(){try{SqlConnecti
webapi的controller中:(js调用该controller,然后返回数据给Js处理)
public string getztreenode()
{
try
{
SqlConnection sqlConnection =
new SqlConnection(
"Data Source=(local);Initial Catalog=filemaneger;Persist Security Info=True;User ID=sa;Password=123456");
sqlConnection.Open();
string sql = "select menuid,previousid,Name from menu";
DataSet dataSet = new DataSet();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sql, sqlConnection);
sqlDataAdapter.Fill(dataSet); //将数据填充进dataset
return JsonConvert.SerializeObject(dataSet); //将数据转换成json格式
}
catch (Exception ex)
{
return ex.ToString();
}
}
用 postman 测试,返回数据如图所示