Add vsta hosting code to infopath and query data from Sharepoint list

In the loading event, add the following code:
If (this. New) // if it is a new form, configure the original value.
{
// Obtain the fullname value of the current user in the configuration file
Using (spsite site = new spsite ("http: // oss") // replace this value with the URL of your SharePoint site
{
// The following configuration files are obtained based on the current user login name:
Servercontext context = servercontext. getcontext (SITE );
Userprofilemanager profilemanager = new userprofilemanager (context );
USERPROFILE u = profilemanager. getuserprofile (this. application. User. loginname );
String fullname = U [propertyconstants. preferredname]. value. tostring ();
　
Windows XP athnavigator mainnavigator = This. maindatasource. createnavigator (); // retrieve the cursor of the primary data source
　
// Configure the applicant's node value as the user name, that is, the preferredname attribute in the configuration file
Mainnavigator. selectsinglenode ("/My: myfields/My: Applicant", this. namespacemanager). setvalue (fullname );
　　　　　　　　　　
// Query a department from the SharePoint department list by name
Using (spweb = site. allwebs ["/demo"]) // replace this with the URL of your SharePoint site
{
Spquery query = new spquery ();
// Because the name field is modified from the title, its internal name is Title
Query. query = "<where> <EQ> <fieldref name = 'title'/> <value type = 'text'>" + fullname + "</value> </EQ> </Where> ";
Splist list = web. Lists ["department staff"];
Splistitemcollection items = List. getitems (query );
If (items. Count> 0) // configure the department value if it is found.
Mainnavigator. selectsinglenode ("/My: myfields/My: applying for a department", this. namespacemanager). setvalue (items [0] ["department"]. tostring ());
　
}
　
}
}
}