public String GetReportData()
{
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
string sql = "select ID,Title,FileUrl from FangXunReport order by CreateTime desc";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
returns += "{'id':" + dr["ID"].ToString() + ",";
returns += "'title':'" + dr["Title"].ToString() + "',";
returns += "'fileurl':'" + dr["FileUrl"].ToString() + "'},";
}
dr.Close();
conn.Close();
}
if (returns != "")
{
returns = "[" + returns;
returns = returns.Substring(0, returns.Length - 1); // 去掉最后的","
returns += "]";
}
return returns.ToString();
}
{
string returns = "";
string connstr="Data Source=192.168.11.53;Initial Catalog=fangxunshuiwu;Integrated Security=false;uid=sa;pwd=root001";
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
string sql = "select ID,Title,FileUrl from FangXunReport order by CreateTime desc";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
returns += "{'id':" + dr["ID"].ToString() + ",";
returns += "'title':'" + dr["Title"].ToString() + "',";
returns += "'fileurl':'" + dr["FileUrl"].ToString() + "'},";
}
dr.Close();
conn.Close();
}
if (returns != "")
{
returns = "[" + returns;
returns = returns.Substring(0, returns.Length - 1); // 去掉最后的","
returns += "]";
}
return returns.ToString();
}