.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Query data from multiple calander in InfoPath button click

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#

Hi, I am building event booking system on InfoPath 2010 , I need to show available rooms for given start and end date time.

All calendars library are under same site.

I don’t want to use code behind. I have calendar lib for each room defined.









View Complete Post

More Related Resource Links

Insert/Update data to multiple tables on a single button click


Hi experts,

I need to insert/update data to 3 or more tables on a single button click.What is best method for achieving this?I am using mysql as my DB.

Thanks for your valuable reply in advance.

how to add multiple rows in a data table against a button click event


how to add multiple rows in a data table against a button click event, and then show it in a gridview

Retrieving multiple AD users with a button event click in InfoPath 2007


I’m developing an InfoPath 2007 form and need to give the current User the ability perform an AD search which will retrieve all AD entries with the same last name. I have successfully programmed the button event with the below code to retrieve a single AD user (first AD entry) using the DirectorySearch.FindOne method but have not been able to figure out how to get the DirectorySearch.FindAll method to work.

Does someone know how to tweak the below code to work for the FindAll method? Or, is the FindAll method the correct search method to use obtain the results I need?  



   Dim xnMyForm As XPathNavigator = Me.CreateNavigator()

Infopath button click event in custom workflow code.


Hi All,

I have designed the infopath form(Init) and integrated with my state machine workflow. i want to access button click event (designed in Infopath form) in my workflow code.

Can you help me.




Infopath form using Visual Studio - How to bind repeating table on submit button click ?


Hello friends,

   I have created infopath form using Visual Studio 2008

Form have 3 dropdowns and one repeating table which is bound by Datasource ( List from sharepoint ).

whenever i select appropritae values from drop down, Repeating table gets bound as datasource for dropdown and repeating table are same.

I have done conditional formating for repeating table using repeating table properties.


My Question:


Now i included one submit button and i want when i click submit button it will check DropDown Values and if appropriate record matching these values found it will fill repeating table

How i achive this ? as i dont find how to bind repeating table on submit button.

Please help if anyone have answer.


Thanks and Regards,


Kapil Bhosale.




InfoPath 2010, Multiple Repeating Sections have same name, Diff data connections using same SQL Serv

I've created an InfoPath 2010 form that has three Repeating sections and each one uses a different data connection but all three connections use the same table in SQL Server... "Accounts".  Now you might ask why I would do this? Well I need different sets of data in each section and it all resides in the same table in the repository. Also, sometimes one section will not have information and I do not want a bunch of blank fields displaying in the repeating section. So I split the data into separate sections. Now here is the challenge for you guru's out there. :) I want to use one column in the 3rd repeating section  to refer back to another column in the first repeating section.(for referential integrity) Unfortunately since they both use the same table in the database they possess the same name under advanced view:  myFields/dataFields "d_:Accounts". In fact all three of my repeating sections have the same name based upon the database table used in the data connection. In the SQL statement I attempted to rename each of the connections via the statement. I have not tried to give the table an alias in the statement yet. Will try that one next. 1. Is there a simple way to rename the repeating Section from "d_:Accounts" to something else so that  they are each unique? (Without using backend code as I've only used InfoPath/SP/S

how to update multiple row in one update button click

hi all,   im having a gridview in which im displaying records and status.....this gridview shows employee applied leave waiting for approvals.. so in gridview i have chabged the status button as radio button list and giving two choices as approve/reject ....so HOD seect relevant button and update the grid... how to do this? 1) do i need to place a button on footer and do some write code behind? 2) or any other easier way?

Multiple instance of User Control on Page - Button Click Event

Hi, I have this Web User Control, with 3 controls:<asp:TextBox ID="txtSearch" runat="server" /> <asp:RequiredFieldValidator ID="rfvSearch" runat="server" ControlToValidate="txtSearch" Display="None" /> <asp:Button ID="btnSearch" runat="server" onclick="btnSearch_Click" /> In code behind: protected override void Render(HtmlTextWriter writer) { rfvSearch.ValidationGroup = this.ID + "_validation"; txtSearch.ValidationGroup = this.ID + "_validation"; btnSearch.ValidationGroup = this.ID + "_validation"; base.Render(writer); } protected void btnSearch_Click(object sender, EventArgs e) { Response.Redirect("ResultadoSearch.aspx?argumento=" + txtSearch.Text); } When I try to add two UserControl and I Click in btnSearch of second UserControl, txtSearch.txt returns value of first User control.How I can get the value of second txtSearch?

Infopath 2007: Cant we fetch data from a list or form library without using a Query to the data conn

I am trying to fetch data from a form library and a list (both secondary data sources). But cant do it without using a rule (Query using a data connection). However when I use the 'Refresh' control on the form it brings the value. I find it quite weird, as the connections are made properly and logically speaking all the data connetions should fetch dynamic data once the form opens or loads. Cant we do it without using a (data query) rule? Update: I am using a web based infopath forms, while using the same form on client its working fine. Why is that?

CAML query to access List data across multiple site collection.

Hi   Is there any way to get the Task List data across multiple site collection using CAML query. Currently, I have the code which will retrieve the data from a single site collection. Below is the code.                           /***************************************************I am using Moss2007.Thanks!Ravi             SPSiteDataQuery q = new SPSiteDataQuery();             q.ViewFields = "<FieldRef Name=\"Title\" />" "<FieldRef Name=\"Status\" Nullable=\"TRUE\"/>";             q.Lists = "<Lists ServerTemplate=\"107\"/>";             q.Webs = "<Webs Scope=\"SiteCollection\"/>";             q.Query = "<Where>" +                                "<Eq>" +                                     "<FieldRef Name=\"Status\" />" + "<Value Type=\"Choice\">Not  Started</Value>" +                                     "</Eq>" +                         "</Where>";             DataTable dt=null;             using (SPSite s = new SPSite("http://banglabguest1:31000/"))             {                 SPWeb w = s.OpenWeb();                 dt = w.GetSiteData(q);                 w = null;             }                              *************************

How to redirect Infopath form programmatically on button click


I am having an issue with infoPath Forms and C#, 
I have a 1st form open to the user, and when he click a button it opens a 2nd form.

Sounds pretty easy, but I have tried many ways and still error.
(environment is InfoPath Forms 2007 in Sharepoint and code: C#)

this is what I have:
- form1 . a text field where I enter the URL of form2
            . a button with code below

The issue is that if I type the URL of form2 
 in the text field and press the button I get this error
"Critical Error : An error occurred submitting this form to the Web server. The form will now be closed."

But instead of the URL of form2.xsn I type http://www.google.com/ they it works (w

Infopath 2010 Displaying datas from SQL SERVER 2008 with a button click



This is my second post. I am really new to infopath 2010, and need some help.

To display database information on the form, normally you drag the whole datafields to the form.

Then the form will auto generate the header row and data columns. When you PREVIEW the form,

the datas from the server will automatically be binded to the form.


My question is, is there a way not to auto bind the data when the form is loaded, and when the user

clicks a button on the form then this datas display on the form dynamically.

Really appreciate your help,

and since I am a newbie please instruct me with step by step, every details please.


-Wook Tae Jung (Mister Car Wash Inc) 


I want to know what are the table and query behind a button click


I have to start working in a project. this project is already done 80%. Now i have to do further work in this. i want to know on some button click what database operations are performed in our sql server.

load users records in infopath fields without using "run the query" button



is it posible to instead of clicking the "run the query" button to load the users records in the fields that the fields load automatically.

can this only be done with a role and a "set a value's field" action? 

Is there a way to query entity based on multiple filter criteria? WCF Data Services, Linq to Entiti


Instead of:

DW_CMSOPEN dwc = new DW_CMSOPEN(new Uri("http://acctdev02/WCFDataService/EmployeeService.svc"));

dwc.Credentials = System.Net.CredentialCache.DefaultCredentials;

var employees = from emp in dwc.Employees 
             where emp.DEPT == "123"
             select emp;

I'd like the linq query to resemble:

var employees = from emp in dwc.Employees
              where emp.DEPT // in {"123", "456", etc}
              select emp;

upload multiple files from a single upload button i infopath form


Hi all

        My Infopath form contains an image upload button . Is it possible to upload multiple files at a time from the same upload button.




Best way to get anonymous InfoPath data into multiple lists/libraries?


I'm trying to figure out the best way to create a solution for the situation I have.  I'm still pretty new to SharePoint, and very new to InfoPath.  I'm working with MOSS 2007 and I've created a browser-enabled InfoPath 2007 form that I need to make available to both anonymous users at the top level of my site, and AD authenticated users from within a secured site collection.  It will be important for me to be able to determine whether the form is being submitted by an anonymous or authenticated user, as it will have some fields that need to be handled differently in each case.  Once the forms are submitted, I need to be able to store them in a forms library in the secured site collection, and also create a list item in the top level site with some of the basic info from the form.  That list will be visible and searchable for the anonymous users.

After searching through this forum, I've found at least 2 possible ways for anonymous users to submit forms to a form library.  Right now I'm leaning towards having it submit to a web service which would handle the task of moving/copying the data to the proper places.  Would that be the best solution in this case, or am I missing something?

The next thing I'm not sure about is what my options are for presenting the form 

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend