开发者

Webservice problem in C#.net

I am creating web service for getting the employee details in client application. To achieve this i have followed the following steps:

employee propertyclass:

public class EmployeeProperty
{
    #region class Members.
    private string _employeeid;
    private string _employeename;   
    #endregion

    #region class property.

    public string EmployeeID
    {
      get { return _employeeid; }
      set { _employeeid = value; }
    }

    public string EmployeeName
    {
      get { return _employeename; }
      set { _employeename = value; }
    }

EmployeeDAL class:

public DataSet GetEmployeeById(EmployeeProperty employee)
{
  SqlConnection conn = new SqlConnection(connStr);    
  conn.Open();   

  // building the command
  SqlCommand oCommand = new SqlCommand("GetEmployeeById", conn);
  oCommand.CommandType = CommandType.StoredProcedure;

  // Parameters 
  SqlParameter paraemployeeId = new SqlParameter();
  paraemployeeId.ParameterName = "@employeeId";
  paraemployeeId.SqlDbType = SqlDbType.VarChar;
  paraemployeeId.Size = 15;
  paraemployeeId.Direction = ParameterDirection.Input;
  paraemployeeId.Value = employee.EmployeeID;
  oCommand.Parameters.Add(paraemployeeId);

  // Adapter and DataSet
  SqlDataAdapter oAdapter = new SqlDataAdapter();

  oAdapter.SelectCommand = oCommand;
  DataSet oDataSet = new DataSet();

  try
  {       
    oAdapter.Fill(oDataSet, "Employee");

    if (oDataSet.Tables[0].Rows.Count > 0)
    {
      employee.EmployeeID = oDataSet.Tables[0].Rows[0]["Emp_ID"].ToString();
    开发者_高级运维  employee.EmployeeName = oDataSet.Tables[0].Rows[0]["Emp_Name"].ToString();         
      return oDataSet;
    }
    else
    {
      throw new ApplicationException("Business object not found.");
    }
  }
  catch (Exception oException)
  {       
    throw;
  }
  finally
  {
    conn.Close();
  }
}

WebserviceClass:

public class EmployeeWebService : System.Web.Services.WebService
{

[Webmethod]
public DataSet GetEmployeeById(EmployeeProperty employee)
{
    DataSet ds = new DataSet();
    EmployeeDAL empdal=new EmployeeDAL();
    return empdal.GetEmployeeById(employee);
}
}

From Client Application:

    webservice .EmployeeWebService empweb = new webservice .EmployeeWebService();       

    EmployeeProperty empproperty = new EmployeeProperty();         

    string empid = Txtempid.Text;

    empproperty.EmpID = empid;

    empweb.GetEmployeeById(empproperty);

    Txtempid.Text = empproperty.EmployeeID;

    Txtempname.Text = empproperty.EmployeeName;

    ....like this other values should display…..but not displaying the employee name in the text box its showing empty   value...

   What i done is correct????pls help its not working...how can i achieve it.


You are not using the DataSet returned by the WS.

empweb.GetEmployeeById(empproperty);

The above line returns a DataSet containing the queried data.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜