DataSource Controls :: Passing Parameter From Web Page
Mar 16, 2010
I'm experimenting with an example of code that I found in a book. Here is the HTML:
[Code]....
This looks fine in DesignView.
Here is the VB:
[Code]....
The page loads when I hit F5. I enter initials for a state and click the button and get this error message: 'The connectionstring property has not been initialized'. This line is green:
objConnection.Open()
I'm highly confident that the connection srting is correct. Do I need to Dim another variable or something?
I am using DAAB with stored procedures. I use stored procedures more then once if possible. If I add a parameter later in stored procedure, I have to supply value for this in functions where it is even not being used as well, other wise it shows an error that number of parameters are not same. if I add parameter in last of parameter list in stored procedure and set a default value for it and I may have not to provide value for this from functions where I am not using it.
each of them is a check box inside this check box list and i have a stored proc that takes paramter which is the name of the city and gives me a data according to the name of the city (Filter). i wana know if i checkec more that one city how can i pass this to the stored proc eg if i checked on cairo and alex what can i do to make the filter looks like this where city Like 'Cairo' and City Like 'Alex' My Stored Proc takes @City Parameter like this Create Proc xx(@City varchar(2)) how can i pass the 2 cities 2 the stored proc
I am opening one page and sending parameter from one asppage to other using winodow.open method
var retVal = window.showModalDialog("PopupWindow.aspx?SQL=" + document.getElementById(SUCName.concat("txtRetVal")).value + "&Curr_Date=" + d , null,"dialogLeft=" + XPos + ";dialogTop=" + YPos + ";center=no;status=no;dialogHeight:430px;dialogWidth:420px;resizable=no;help=no"); in my document.getElementById(SUCName.concat("txtRetVal")).value contains: SELECT ResourceID, ResourceName FROM ResourceMaster WHERE AREA LIKE '%CALICUT%'
but when it access this on PopupWindow.aspx using Request.QueryString("SQL") then first 3 character in LIKE clause gets convert to some ascii character and my query becomes
SELECT ResourceID, ResourceName FROM ResourceMaster WHERE AREA LIKE '�LICUT%'
I have an asp.net page where I get the user_id from who's logged in. Now I need to pass this user_id to a flex application that runs in an asp.net page as a .swf. How can I get this user_id in a variable in my flex application. Or what is the best way to get the user_id into flex.
I have 2 asp.net pages first page (PaySlipForm.aspx) contains ui elements for getting values from user, second page shows the report depending on the parameters passed from first page. The problem is first time the report shows correctly but when I go back on first page by clicking the back button of browser and changes the selection the report is shown empty only labels are shown.
First Page PaySlipForm.aspx <asp:DropDownList ID="ddlAllEmployees" runat="server" style="margin-left: 7px" Height="20px" Width="174px"> </asp:DropDownList> <br /> <asp:DropDownList ID="ddlMonth" runat="server" Height="23px"> </asp:DropDownList> <br /> <asp:DropDownList ID="ddlYear" runat="server" style="margin-left: 18px" Height="23px" Width="77px"> <asp:ListItem>2010</asp:ListItem> <asp:ListItem>2011</asp:ListItem> <asp:ListItem>2012</asp:ListItem> </asp:DropDownList> <br /> <asp:Button ID="btnShow" runat="server" Text="Show" PostBackUrl="~/Reports/PaySlipViewForm.aspx"/> Second page is PaySlipViewForm.aspx that has the code <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="True" EnableDatabaseLogonPrompt="False" Height="50px" ReportSourceID="CrystalReportSource1" Width="350px" /> <CR:CrystalReportSource ID="CrystalReportSource1" runat="server"> <Report FileName="../Reports/PaySlip.rpt"> </Report> </CR:CrystalReportSource> --------------------- if (!IsPostBack) { int employeeID = Convert.ToInt32((((DropDownList)Page.PreviousPage.FindControl("ddlAllEmployees")).SelectedValue)); int monthID = Convert.ToInt32((((DropDownList)Page.PreviousPage.FindControl("ddlMonth")).SelectedValue)); int year = Convert.ToInt32((((DropDownList)Page.PreviousPage.FindControl("ddlYear")).SelectedValue)); CrystalReportViewer1.SelectionFormula = "{Payroll.EmployeeID} = " + employeeID + " And {Payroll.Month} = " + monthID + " And {Payroll.Year} = " + year; }
I have a web form that has drop down controls. These controls are data bound to a database. Now, I would like the results of the selected values to be shown on a new aspx page in a gridview or detailsview.
I am using VS 2005 (asp.net 2.0). Currently i am facing a problem everytime onclick button call the popup it will refresh the page. Below is my code, Any suggestion or better idea can do it without refresh
As you can see, the connectionstring parameter is defined to a specific connection string name and I need to be able to set such a parameter to a different value, for example, to a session variable content.
I am storing a custom "Organisation" object as a session variable. One of the properties of the Organisation object is "OrganisationID" (integer). I have a DataSource that requires a parameter value to run, and I want to use a SessionParameter to populate this. In a previous version, I stored the OrganisationID directly as a session variable. In that case, I could easily access it like this:
[Code]....
However, how do I now access the OrganisationID property of an "Organisation" type session variable (called "Organisation")? I have tried this, which does not seem to work: <asp:SessionParameter Name="OrganisationID" SessionField="Organisation.OrganisationID" Type="Int32" />
I have a page with some datasources in it. I am doing reenginering of the page itself and would like to split some parts of the page in several user controls.
In my code I have an ObjectDataSource object with the following params
[code]....
This piece of code automatically bind the hidden field "txtAlbumId" to the datasource. In my revision this datasource should be moved to a user control.
Secondly, how does ASP.NET MVC know that action is my action, and controller is my controller. Like I saw this in samples, and it does work, but isn't it just an anonymous object with no type?