InfoPath Dev

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

Hi Sithender,

For a browser-enabled form, you should use a UDC file for your Active Directory Web service. It should look something like this:

udc:Authentication><udc:SSO AppId='' CredentialType='' /></udc:Authentication

Patrick, I successfully created a getuserprofile UDCX and configured SSO and works like a charm for me and my User Name.

However, I am confused about adding accounts?  Do I have to add all my users individually in the Manage Account Information for an Enterprise Definition.

If so, that means I need the user password info OR am I missing something.

 -Stephen