I have a page containing a link to to MS Excel spreadsheet (I am able to assume that Excel is available as this is an intranet page). All works fine until I want to pass a parameter into the spreadsheet.
Normally I would do this with /e but this will not work I am starting Excel through a link.
Any ideas how I would pass the parameters into Excel?
(also - there may be multiple requests for the spreadsheet at any time with differing parameters!!)
Instead of specifying 10 parameters in the URL, is there any good alternative way of passing the parameters? And note the new window has to be a popup.
I used a sub in which need to pass about 15 parameters. How to simplify it? Protected Sub test(ByVal _a As String, ByVal _b As String) //about 15 parameters will pass Dim s As String = "insert into AAA a, b value(" & _a & ", " & _b & ")" End Sub
crystal report has two parameters field, however, i used three method searched, all failed. Error is missing parameter values. sure parameter is passing by query string URL] checked by Label However, do not know why Error is missing parameter values.
Method 1 // First parameter ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = Request.QueryString["ID"]; crParameterFieldDefinitions = objRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Cheque_IssueRecord_Secretary_Review_TT_ID"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); // Second parameter ParameterFieldDefinitions crParameterFieldDefinitions2; ParameterFieldDefinition crParameterFieldDefinition2; ParameterValues crParameterValues2 = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue2 = new ParameterDiscreteValue(); crParameterDiscreteValue2.Value = Request.QueryString["tCOMDB"]; crParameterFieldDefinitions2 = objRpt.DataDefinition.ParameterFields; crParameterFieldDefinition2 = crParameterFieldDefinitions2["tCOMDB"]; crParameterValues2 = crParameterFieldDefinition2.CurrentValues; crParameterValues2.Clear(); crParameterValues2.Add(crParameterDiscreteValue2); crParameterFieldDefinition2.ApplyCurrentValues(crParameterValues2); Method 2 //objRpt.SetParameterValue("Cheque_IssueRecord_Secretary_Review_TT_ID", Request.QueryString["ID"]); //objRpt.SetParameterValue("tCOMDB", Request.QueryString["tCOMDB"]); Method 3 var value = new ParameterDiscreteValue(); value.Value = Request.QueryString["ID"]; objRpt.ParameterFields["Cheque_IssueRecord_Secretary_Review_TT_ID"].CurrentValues.Add(value); var value2 = new ParameterDiscreteValue(); value2.Value = Request.QueryString["tCOMDB"]; objRpt.ParameterFields["tCOMDB"].CurrentValues.Add(value2);
This crystal report database use stored procedure, parameter field is automatically added, after added i removed @ character do not know why parameter missing
I am trying a programming example, which I saw in a book, in an attempt to learn ASP.NET and figure out how to pass parameters to a simple query. Here is my HTML:
[Code]....
The page loads but the ListBox does not fill. As a consequence, or maybe as an aside, the button click_event does absolutely nothing. Here is my VB:
how can i use jquery in a scenario where when i click an image, jquery picks up the values of 2 dropdown lists and passes them up as parameters to a remote POST URL?
The page is then redirected to this new URL with the appropriate parameters.
When user selects 10 miles from dropdownlist DDL1 and types AAA20 in textbox1 which is of type text, on button click it has to pull all the columns from database and show results in gridview using sqldatasource store procedure. I'm stuck in server side code..how to pull the data..in store procedure I'm passing two parameters val1 and val2. val1 gets data from DDL1 and val2 gets data when user types in textbox1 and it has to validate the text...see the code below mentioned and tell me how to pass the params and get the data in gridview...
i am working in the webservice project. I have one project when i run it then shows the text box for parameters and return the result after passing the parameters.
But another webservice does not allow me to enter the paramerters when execute then list of methods displayed and then show the soap xml when click at any method.
what difference found in both webserivces are Excuting-one that have the Text boxes: Test: "To test the operation using the HTTP POST protocol, click the 'Invoke' button."
2nd One Not provide the parameter text boxes: Test: "The test form is only available for methods with primitive types as parameters"
Dont know how to fix that. Because i want to debug the webservice and as i am unable to provide the parameter then how can i fix it.
how can i pass the parameters in the 2nd webservice as it has different information mentioned above.
Instead of dynamically building an sql to update data based on certain fields that are filled in, I would like to try and do it via a stored procedure I have three fields passing potentially passing to a stored procedure
I want to be able to pass parameters in a variety of ways
field1, field2, field3 or field1, field3 or field2, field3
When I attempt thsi, it provides an error of a missing parameter when I do not supply all three. Is there any way to pass exclude parameters at times. The most important thing is that I do not want to update the field to a null when a parameter is not passed, I want it to exclude updating that field altogether
Basically I want to call a user control from a master page. However, I need to pass an object (a List of objects to be more specific), to the user control. I'm generating the list of objects in the Page_Load of the master page. Here's the line in my master page that calls the user control.
This user control has a parameter called CalendarItems that accepts the list of items. However, if I try to set this inside of the Page_Load method, my control executes before the Page_Load and throws an exception saying CalendarItems is null. Is there any way around this?
EDIT: I have a drop down list on this page that determines what the list of CalendarItems is so when I populate the CalendarItems list I need to be able to read the selected value from the drop down list.
I have a webpart in a page in which there is a gridview(which shows list of customers). When I click on a link button in gridview, I would like to popup a JQuery modal window and fill the popup(this contains textboxes, then a gridview which contains mapped systems for thet customer, and another gridview which contains list of configured reports for that customer) with the details based on the customer name(link) clicked. Here I need to pass the customer Id and customer name parameters based on which I can fill the Jquery modal window.
pass parameters to JQuery modal window in order to fill the contents inside it?
Is there any possibility to pass values of form elements to action methods but using parameters?I have a form with a lot of input fields and the method signature will get pretty long. Besides the form elements depend on each other so if the user makes a special choice only a subset of the form elements should be displayed so there are several combinationof values to be passed.Can I access the posted values in a generic way through a collection in the controller or something similar?
I'm using C# language Asp.net version 3.5 I have a masterpage and pages which they use master. I think there are three ways to implement my application with ability passing parameters between controller to pages.
First Way :
I need to pass a string parameter from page to master how I can do that ? I'm going to pass a string parameter between page to master when controller request page and then page pass parameter to it's master. Second way : Passing some string parameters from a controller class to master page at first (not to page and then page to it's master). Third Way : Passing to another class or field that must be static and then master load it's value. Which is the best or possible way I mean with high performance and security.
Basically, my question is: how do I specify optional parameters to a WebMethod when providing JSON data?
I know I can reduce the parameters down to just the required values, and then use HttpContext.Request.Params to read the values of optional paramaters, but I would have thought the way I have tried here should have worked.
EDIT
The XMLHttpRequest.responseText value for the error is:
Invalid JSON primitive: staffcode.
This is throwing me even more off the scent of the problem :(
i want to update my page from database every 20 Sec..so for that i want to pass multiple data fields from server to Client using AJAX.. what can i use for that except using xml?
