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>

转载于:https://www.cnblogs.com/asbeforelong/archive/2008/08/19/1271087.html