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

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

Problem with Finder method with parameters

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint


Could someone explain me how to provide some value to the parameters in a finder method. For exemple I know that the BDC list WP use this method. Is there a way to provide some value for those parameter at runtime? I really don't understand (even after some deep search on the web) where are the values for the parameters from and how we can connect to them. Even with C# code I can't find any information on how it work.

I don't want to define my parameters as filter in the ADF because then I will have this filter section in my BDC list WP (or is there a way to get rid of that?). Actually one of the parameter should be automatically calculated from a value in a SP list, the other parameter should be provided by my own filter web part.

Thank you for your help.

View Complete Post

More Related Resource Links

How to pass parameters from Application Main method to modules.

Hi , We created Prism WPF application.we have to pass some parameters(some information) to modules(they are instantiated by Bootstrapper) from Main method of App.xaml  Thanks in Advance.

MDX problem (Amount value is getiing doubled when multiselecting dimension parameters)

Hello...I need some help with the MDX...basically the problem is the Amount value is getting doubled when I am selecting more than one parameter. Here is situation...suppose I select a parameter  lets say A from dimension Account Element Hierarchy then I get the Budget Amount as $100, now in my SSRS report I change the dimension parameter value to B and then I get the Budget Amount $200. Now I multiselect A and B and ideally I should get the Total Budget Amount as $100+$200=$300 but in place of that I get $600 I have captured the mdx below...Please let me know if you have an idea to fix this --The below MDX returns $100 for Budget Value SELECT   NON EMPTY { [Measures].[Budget Amt], [Measures].[Budget / RSF] } ON COLUMNS, NON   EMPTY { (DESCENDANTS([Account Hierarchy].[Account Hierarchy].[Level 02].ALLMEMBERS) ) } DIMENSION   PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME, PARENT_UNIQUE_NAME, LEVEL_NUMBER ON   ROWS FROM [Finance]   WHERE (STRTOSET("{[Account Element Hierarchy].[Account Element Hierarchy].&[1214|425|406|495|1209|421]}"),   STRTOMEMBER("[Date].[Year].&[2010]"),   STRTOMEMBER("[Budget Version].[Budget Version].&[Budget]"), [Account Hierarchy].[Account Hierarchy Type].&[2])   CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR,   FORMATTED

Problem with Parameters

I'm fairly new to this and appreciate any detailed info you're able to give. I have a report that has two datasets. One dataset queries for possible term code values which is then passed into the second dataset. If I execute the first dataset statement within the report builder, I receive an expected output. If I hard code a value into the "?" parameter location in the second dataset, I receive expected information. It doesn't, however, work correct when previewed. My data source is of the "Oracle" type. Executing the report in the Preview tab results in: An error has occurred during the report processing. Query execution failed for data set 'Banner_FU'. ORA-01036: illegal variable name/number.   What am I missing?   joe

Problem with cheking the sended parameters on sended page

Hi everyone hope u will help me i have some pages, in my first page have  a repeater with hyperlink and i want to send 2 parameters to another page<asp:HyperLink ID="hp1" runat="server" Text='<%# ". Sayi :"+ Eval("sayi") %>' NavigateUrl='<%# "~/arsivdetay.aspx?cilt=" +Eval("cilt") + "sayi=" +Eval("sayi") %>' ForeColor="#FF6600" Font-Bold="True" Font-Underline="False" Font-Size="12px" /> looks fine here atm but the problem start on sended page cs sideprotected void Page_Load(object sender, EventArgs e)        {                        if (!IsPostBack)                if (Request.QueryString["sayi"] == null)                    Response.Redirect("~/default.aspx");                else                    makalegetir(Request.QueryStri

Passing Parameters to Web Service Method using XML DataSource

I would like to know how to pass parameter values to a web service that I am using as a data source.  I am using the Data Source Type XML.  I have been able to retrieve data back from the web service method that does not require parameters.  But I need to be able to use a web service that requires parameter values.  How do you use the XML data source type with parameters?  I have use information from the article  http://www.codeproject.com/KB/reporting-services/SSRS2005XML.aspx. thanks, Lloyd

Problem : Need to make COM InterOp at runtime using reflections Passing Pointers as parameters?

Hello, I need to make COM IntetrOp at runtime using reflections. My native COM Object's exposed methods have some parameters as pointers (DWORD*) and some double pointers (DWORD**) and some are user defined types(e.g SomeUDTType objSmeUDTType) and vice versa its pointer(i.e. SomeUDTType *pSomeUDTType). Now for dynamic method invocation, we have single option for passing parameters as array of object i.e object[] and filling this array statically. But I need to pass pointers and references and pointers to pointers. For now how can I be able to populate object array as mixed data of simple data types, pointers or references and pointers to pointers. Working Example: Native COM exposed method : STDMETHODIMP MyCallableMethod(DWORD *value_1,BSTR *bstrName,WESContext a_wesContex Translated by tlbimp.exe (COMInterop) UDTINIDLLib.RuntimeCallingClass.MyCallableMethod(ref uint, ref string, UDTINIDLLib Now calling these methods at runtime using reflection at runtime, See here :        Assembly asembly = Assembly.LoadFrom("E:\\UDTInIDL\\Debug\\UDTINIDLLib.dll");         Type[] types = asembly.GetTypes();         Type type = null;    //foreach (Type oType in types)         {             try      &nb

Problem with Parameters.AddWithValue and GUID

Hi,have a problem, when i want to update a line in my database with the SQLCommand. I have following code: SqlCommand tmp_sqlcmd = new SqlCommand("UPDATE LogSend SET LogSend = @State WHERE DEVICE_UID = @Device_ID", Default_Con); tmp_sqlcmd.Parameters.AddWithValue("@State", logsend.state); tmp_sqlcmd.Parameters.AddWithValue("@Device_ID", logsend.Device_ID); int test = tmp_sqlcmd.ExecuteNonQuery(); tmp_sqlcmd.ExecuteNonQuery();But nothing happens when the command is executed. Any ideas?When i manually edit the line with:UPDATE LogSend SET LogSend = 1 WHERE DEVICE_UID = '5d8f3da0-e7c9-4a99-bb3f-246ce63ceebb'It works.Any ideas for me?Sincerely,Steven

Problem with overriding OnPaint method of System.Windows.Forms.Textbox

Hi,   I want to change the border colour of the Textbox. However, when I override the OnPaint method, some strange behaviour occurs.   The new border is drawn, as is the textbox background. However, the text itself appears in bold and only while I actually type something in, afterwards it disappears. I have provided a sample of my code here:         protected override void OnPaint(PaintEventArgs e)         {             base.OnPaint(e);             Rectangle rect = new Rectangle(0, 0, this.Width, this.Height);             ControlPaint.DrawBorder(e.Graphics, rect, _BorderColour, ButtonBorderStyle.Solid);         }   I have also set the style of the control to Userpaint, so that the paint method is actually used. Does anybody know how to solve this issue?

Interesting problem with getting OUTPUT parameters from SQL Server using C#

 I have the following SP: Create procedure dbo.example(@test INT OUTPUT)ASBEGINSET @test = 5SELECT * from UsersENDGO  and when I try calling it from C# using an SqlCommand with adding an output parameter and getting it's value, I get that the value is NULL. (I should mention that I use ExecuteReader)However,  if I alter the SP and remove the select line, the c# code works and returns the value 5. 

Input Parameter in Finder Method BDC Model

Hi Guys, I know it is possible to create a Finder method with an input parameter, but I am trying to figure out how to pass the parameter to the method. Here's my isssue:   I have created a BDC Model in VS2010, my finder needs to have an input parameter. This input parameter is available on a list that is already available on my site. What are my options to pass this parameter to my finder method and display the results?   My intention (not sure if it makes sense) is to create and action for the model of the list that is already available, so I can capture the variable and pass it in a query string to  a list that I create for the Finder method that requires an input parameter. The problem is I dont know how to do this or even if it the best way to go about solving the problem. Using a business data list and business data related list while possible is really not an option.   Thanks  

Problem using value() method for xml datatypes.

Hi i'm working on an application which stored infopath forms in database as xml datatype. now i want to get query of xml data which returns each node as sql dataType (column). here is my sample form data : <?mso-infoPathSolution solutionVersion="" productVersion="12.0.0" PIVersion="" href="file:///D:\customForm3.xsn" name="urn:schemas-microsoft-com:office:infopath:customForm3:-myXSD-2010-09-11T10-56-47" ?> <?mso-application progid="InfoPath.Document" versionProgid="InfoPath.Document.2"?> <my:myFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2010-09-11T10:56:47" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003" xml:lang="en-us"> <my:txtFirstName>test1</my:txtFirstName> <my:txtLastName>test2</my:txtLastName> <my:txtFatherName>test3</my:txtFatherName> <my:txtNationalCode>8278273828</my:txtNationalCode> <my:cmbReuqesType>2</my:cmbReuqesType> <my:dtmRequestDate>2010-09-17</my:dtmRequestDate> <my:txtDescription>test4</my:txtDescription> </my:myFields> to get query of this

Problem with SELECT COUNT query and parameters

Hello!I have a problem with SELECT COUNT query in ASP.net. I want to create CMS with articles which have categories (which have the option to be deleted). The problem is that I want to get the number of articles within the specified category so if there aren't any articles with the specified category I can proceed with the category deletion.I have the following code:protected void Page_Load(object sender, EventArgs e) { } protected void GridViewKategorije_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Uredi") { int index = Convert.ToInt32(e.CommandArgument); GridViewRow odabraniRed = GridViewKategorije.Rows[index]; TableCell ClanakID = odabraniRed.Cells[2]; string ID = ClanakID.Text; Response.Redirect("/Portal/Administracija/Kategorija.aspx?idKategorija=" + ID); } else if (e.CommandName == "Obrisi") { int index = Convert.ToInt32(e.CommandArgument); GridViewRow odabraniRed = GridViewKategorije.Rows[index]; TableCell KategorijaID = odabraniRed.Cells[2]; String connString = WebConfigurationManager.ConnectionStrings["CMS"].ToString(); SqlConnection conn = new SqlConnection(connString); conn.Open(); using (SqlC

Problem canceling asynchronous method



I want to canceling an asynchronous method.

How can me it?


public IAsyncResult BeginGetAllUsersCount(object sender, EventArgs args, AsyncCallback callback, object state)
       //Canceling asynchronous operation
     return AdapterUser.BeginGetAllUsersCount(callback);

   public void EndGetAllUsersCount(IAsyncResult asyncResult)
     _totalRowsCount = AdapterUser.EndGetAllUsersCount(asyncResult);




Problem while calling WCF method


I have a WCF Service and a client application. WCF Service has an operation contract (say UpdateTables()) with IsOneWay = True. I call this method of WCF Service from my client application using the code below:
   Private Sub UpdateTable_Client()
        Dim WCFSvcObject As New MyFirstWCFServiceClient
        Dim WCFSvcData as new MyFirstWCFDataRequest 'DataContract object
        WCFSvcData.TableName = "Customer"
        WCFSvcData.ColumnName = "Name"
        Catch ex As Exception
            Throw ex
            If WCFSvcObject  IsNot Nothing Then               
            End If
        End Try
    End Sub

Sometimes this call reaches to WCF Service successfully but sometime it lost and UpdateTable() method could not be invoked on service side. I am not sure but I think WCFSvcObject.Abort() code aborts the WCF request before it reaches to the service. I can not use Close() method here as my client application hangs on the Close().
Please suggest me what may be the reasons of the client call could not reach to the WCF Service. Should I not use Abort() method. If yes then how can I dispose the WCF proxy(since Close() method is not working here).

Problem creating method?


I added the extender and when i tried to add the method this message poped up;

Cannot create page method "GetCompletionList" because no Code Behind or codefile was found.

does anyone know why this is happening?

Thanks  =)

Reporting Services Report Parameters Problem


I have the next table, & I have the Id of the account as a report parameter @AccountID

|account |LastYear |Jan |Feb |Mar |Apr |May |jun |Jul |Aug |Sep |Oct |Nov |Dec |YTD  |Plan
| 00001  | 10.00    |  1   |  2  |  3  |   5 |  32  | 12 | 11| 10  |  8   | 87 | 54  | 54  | 123 | 250

I tried to build a Query that return me

Jan       |  1
Feb       |  2
Mar      |  3 ...

I already tried to build  a temporary table, but then Ignore my report parameter saying Must declare the scalar variable "@AccountID".
But If I eliminate the code of create #Table, The parameter works just fine.


Part of my query is :

Declare @IddeCuenta varchar(50)
set @IddeCuenta =

(Periodo varchar(30),
Informe_Ventas money)

INSERT INTO #VentasGraf VALUES ('LstYear',0)

    UPDATE #VentasGraf
    SET        Informe_Ventas =
    (SELECT  ISNULL(sum(new_acumula

Problem Using Invoke and passing multiple byref parameters


I have code, shown below highly simplified that works all except for 1 thing: The variables being passed byRef get passed, but once modified in RecordData, they are never updated in the calling function. The calling function does not receive the updated data that is in the variables custid and amt. When debugging, I see the data in the else section of if me.invokerequired, but once it returns from the callback and is in the latter part of if me.invokerequired the data is missing.

How do I fix this?


Delegate Sub RecordDataCallback(ByRef custid As String, ByRef amt As Double)

Private Sub RecordData(ByRef custid As String, ByRef amt As Double)
    If Me.InvokeRequired Then
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