Code needed frds

[sith]

HI friends,



I am new to this infopath is concept. and i need ypur help to solve my
problem.my problem is



when ever user opens infopath in his browser,i will catch his windows
authontication id,based on the id i have to load his details.however i
wrote the logic in webserver to retrive user infomation.

my code in webserver is:





using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.SqlClient;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Service : System.Web.Services.WebService
{
public struct Employee
{

public String Name;
public String EmailID;
public String LineMgr_EmailID;
public String SecApprover_ID;
public String HR_EmailID;
public String HRCC_ID;
public String Div_ID;
public String DepartementName;

}


SqlConnection sqlcEmployee = new SqlConnection();
SqlCommand sqldEmployee = new SqlCommand();

public Service()
{

//Uncomment the following line if using designed
components
//InitializeComponent();
}

[WebMethod]
public string HelloWorld()
{
return "Hello World";
}




[WebMethod]
public Employee GetEmployeeInformation(string UserName)
{
Employee ObjEmployee = new Employee();
sqlcEmployee.ConnectionString = "initial catalog=LMS;user
id=ias;password=ias;server=gdc-sql2000";
if (sqlcEmployee.State == ConnectionState.Closed)
{
sqlcEmployee.Open();
}
sqldEmployee.CommandText = "LMS_FillLeaveForm_Test";
sqldEmployee.Connection = sqlcEmployee;
sqldEmployee.CommandType = CommandType.StoredProcedure;
SqlParameter sqlpUserName = new SqlParameter("@uname",
SqlDbType.VarChar);
sqlpUserName.Value = UserName;
sqldEmployee.Parameters.Add(sqlpUserName);
SqlDataReader dr;
dr = sqldEmployee.ExecuteReader();
while (dr.Read())
{
ObjEmployee.Name = Convert.ToString(dr["NAME"]);
ObjEmployee.EmailID = Convert.ToString(dr["emailID"]);
ObjEmployee.LineMgr_EmailID =
Convert.ToString(dr["LineMgr_EmailID"]);
ObjEmployee.SecApprover_ID =
Convert.ToString(dr["SecApprover_ID"]);
ObjEmployee.HR_EmailID =
Convert.ToString(dr["HR_EmailID"]);
ObjEmployee.HRCC_ID = Convert.ToString(dr["HRCC_ID"]);
ObjEmployee.Div_ID = Convert.ToString(dr["Div_ID"]);
ObjEmployee.DepartementName =
Convert.ToString(dr["dept_name"]);

}

return ObjEmployee;
}

}





however i dont know how to get the results by using secoundary data
source.
i have to done this in pageload() event of JScript editor.



waiting for your kind response.

Regards

Sithender.S