Data Connections

Re: Pls code needed.

sschempp — Mon, 18 May 2009 23:10:57 GMT

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

Re: Pls code needed.

Patrick Halstead — Wed, 22 Aug 2007 06:45:40 GMT

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:

<?xml version="1.0" ?>

<?MicrosoftWindowsSharePointServices ContentTypeID="0x010100B4CBD48E029A4ad8B62CB0E41868F2B0"?>

<?mso-infoPathSolution PIVersion="1.0.0.0" name="urn:schemas-microsoft-com:office:infopath:UDCEditor:http---schemas-microsoft-com-office-infopath-2006-udc" solutionVersion="1.0.0.10" language="en-us" ?>

- <udc:DataSource MajorVersion="2" MinorVersion="0" xmlns:udc="http://schemas.microsoft.com/office/infopath/2006/udc">

<udc:Name>GetMyInfo New</udc:Name>

<udc:Description>Format: UDC V2; Connection Type: WebService; Purpose: ReadOnly; Generated by Microsoft Office InfoPath 2007 on 2007-01-31 at 22:55:55 by AUTONOMYSYSTEMS\pathal.</udc:Description>

- <udc:Type MajorVersion="2" MinorVersion="0" Type="WebService">

<udc:SubType MajorVersion="0" MinorVersion="0" Type="" />

</udc:Type>

- <udc:ConnectionInfo Purpose="ReadOnly" AltDataSource="">

<udc:WsdlUrl>http://formsboard.com:30794/dbxl/aduserinfo.asmx?WSDL</udc:WsdlUrl>

- <udc:SelectCommand>

<udc:ListId />

<udc:WebUrl />

<udc:ConnectionString />

<udc:ServiceUrl UseFormsServiceProxy="true">http://formsboard.com:30794/dbxl/aduserinfo.asmx</udc:ServiceUrl>

<udc:SoapAction>http://qdabra.com/webservices/GetMyInfo</udc:SoapAction>

<udc:Query />

</udc:SelectCommand>

- <udc:UpdateCommand>

<udc:ServiceUrl UseFormsServiceProxy="true" />

<udc:SoapAction />

<udc:Submit />

<udc:FileName>Specify a filename or formula</udc:FileName>

<udc:FolderName AllowOverwrite="" />

</udc:UpdateCommand>

- <!--

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

--> f(clean);

</udc:ConnectionInfo>

</udc:DataSource>

Pls code needed.

sithender — Mon, 13 Aug 2007 11:22:41 GMT

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