Flex、 WebService、数据库通信
Flex、 WebService、数据库通信
using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.SqlClient;
using MySql.Data;
using MySql.Data.MySqlClient;
/// <summary>
/// WebService 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class WebService : System.Web.Services.WebService
{
public WebService()
{
//如果使用设计的组件,请取消注释以下行
//InitializeComponent();
}
[WebMethod]
public string HelloWorld()
{
return "Hello World dsdsdsdsds";
}
[WebMethod]
public string HelloWorlddfdf()
{
return "Hello World 2222222222222222";
}
//获取Sql所有用户
[WebMethod]
public System.Xml.XmlDocument GetSqlUsers()
{
//连接数据库字符长串
string strConn = System.Configuration.ConfigurationManager.ConnectionStrings["ConfigSqlConnection"].ConnectionString;
//string strConn = System.Configuration.ConfigurationManager.AppSettings["ConfigSqlConnection"].ToString();
SqlConnection conn = new SqlConnection(strConn);
string strSql = "select id,username,password from sdsuser";
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(strSql, conn);
sda.Fill(ds, "Users");
string xmlstr;
System.Xml.XmlDocument rt = new System.Xml.XmlDocument();
rt.LoadXml(ds.GetXml());
return rt;
}
//获取MySql所有用户
[WebMethod]
public DataSet GetMySqlUsers()
{
//连接数据库字符长串
string strConn = System.Configuration.ConfigurationManager.ConnectionStrings["ConfigMySqlConnection"].ConnectionString;
//string strConn = System.Configuration.ConfigurationManager.AppSettings["ConfigSqlConnection"].ToString();
MySqlConnection conn = new MySqlConnection(strConn);
string strSql = "select * from page";
DataSet ds = new DataSet();
MySqlDataAdapter sda = new MySqlDataAdapter(strSql, conn);
sda.Fill(ds, "page");
//dt = ds.Tables["Users"];
return ds;
}
}
<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" initialize="ws.GetSqlUsers.send();">
<mx:Script><![CDATA[
import mx.collections.XMLListCollection;
import mx.controls.Alert;
]]>
</mx:Script>
<mx:WebService id="ws"
wsdl="http://localhost:1994/WebService.asmx?WSDL"
showBusyCursor="true" >
<mx:operation name="GetSqlUsers">
<mx:request>
</mx:request>
</mx:operation>
</mx:WebService>
<mx:DataGrid x="25" y="10" dataProvider="{this.ws.GetSqlUsers.lastResult.NewDataSet.Users}" >
<mx:columns>
<mx:DataGridColumn headerText="id" dataField="id"/>
<mx:DataGridColumn headerText="username" dataField="username"/>
<mx:DataGridColumn headerText="password" dataField="password"/>
</mx:columns>
</mx:DataGrid>
</mx:Application>