i have the following code
[Code]....
I have debugged the session and the value there is valid , but when i redirect to the page[Code]....
The Parameters seems to not to be passing parameter to the control
I followd Brian Orrell LINQ tutorial for paging/sorting and created a gridview bound to an ObjectDataSource through a method call which gets data from adatabase. My form includes two buttons with a textbox next to each one of them. I need to be able to populatte th egridview depending on the button that was pressed, I cannot figure out how signal my method which button was pressed.
[Code]....
[URL]
I need to pass the control parameter to Sql Datasource in code behind,
<asp:ControlParameter ControlID="DDL_RType" Name="rtype" PropertyName="SelectedValue"
I have 3 parameters say A,B,C. I want that when I select values in A and B only then C comes alive. I am using cascading parameter in SSRS 2005.
I know that in cascading parameters, one parameters passes a value to other one and it comes alive. But I want that 2 parameters pass the value to a single one.
dont say to use multi select as multi select is used only when we have to multi select from one parameter.
Also one thing how can I use radio buttons in SSRS 2005 and how to hide null checkbox when allowing null values in calender control.
im new to linq and im having lots of trouble creating complex queries.. My problem mainly is that i am using Linq as a BLL.
i created a dbml (with namespace called DAL) file with 2 tables with a one to many relation. Pop and City. There is a forgien key in pop that points to a city. I also created a class called Pop that inhertis DAL.Pop. Now in my ASPX page, i want to call a function in the Pop class that would retrieve some Pop according to its ID, but i need the city name as well.. Ive been going around this in circles for days. I dont know how to write the Linq syntax and i dont understandd how my function's signature should be like.. I want to recieve a table that i can bind to a Gridview and preferable, specify which coloumns to bind.
I have an ObjectDataSource3 that I am trying to use to insert data from:
From: Dropdownlist1.selected value To: (CustomerID)
From: Dropdownlist2.selected value To: (ProductCode)
From: txtTitle (Title) To: (Title)
CurrentDate To: DateOpened
The btnAdd event is suppose to calls:
ObjectDataSource3.Insert()
Below is my code for both the page and class. Although my class is expecting parameters, I don't know how to get the parameters to the insert function in my class.
[Code]....
[Code]....
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'm having an issue coming up with an appropriate code design to implement a search page using linq to sql for my DDL. I think the best way for me to explain where I'm at is describing what I've done in the past, before linq. Lets say we have a basic search page with various user input controls for search options... for simplicity, let's say there are two main ways the user can search.
1. a dropdown filled with account numbers. When that drop down is changed and an account number is selected, a gridview needs to be populated with all the records for that account.
2. the second way is a dropdown for choosing what field you want to search, a textbox for entering what you want to search for, and a button to execute that search. In the past, just using straight ado.net
I would handle each of these two search options separately within the events of the dropdown list and the button, respectively. In selectedIndexChanged for 1, and in the buttonClick event for 2, I would construct my sqlCommand etc., ultimately returning a dataset or datatable which I would then bind to the gridview. The logic was separated by the two different event handlers. Now, fast forward to linq to sql and I have a similar page layout, but I am using the linqdatasource selecting event to build my where conditions. Now the difference is *everything*, all the logic, is now in this one event handler, which search option did the user run? Could I somehow craft an IQueryable <T> within each of the input controls event handlers (like the button click, or selectedIndexChanged of the dropdown) and pass that in to the linqdatasource's selecting event? that way my logic stays logically separated...
further, after this initial search is done and results are bound to a gridview, I have several other dropdown lists that appear for search refinement. I need to keep track of that top level query, and each of the refinements... and again, right now it looks like everything is going into the linqdatasource selecting event and I get the feeling it shouldn't be... using the selecting event enables my paging and sorting to work, so I want to use that, but again, it's turning out that I'm putting *everything* there, like all the page's logic, and I'm thinking that is not good? if I could just pass in the actually query, like an IQueryable<T>, and keep my logic separated.
I want to make data-driven page and ability to filter data on some parameters, for example 3 text boxes and 2 dropdown lists and then show the results by the grid view control.
Actually I like input data in the text boxes and select item from dropdown list and then press "OK" Button and result (filtered data) show in the new page by the grid view.
What I have seen in the quick start tutorial is filtering by one parameter.
I got DDL1: 10 miles
20 miles
TextBox1 : 'AAA20'
Button:
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...
[code]....
ALTER procedure [dbo].[Sample2]
@Col as nvarchar(1000),
@Value as nvarchar(1000)
[code]...
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.
View 1 Replieslets say i have check box list like that
Cairo
Alex
Aswan
All
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 have used a sql data source to connect to ORACLE.
Select command is working fine, as soon as I try to provide a parameter, it doesn;t work.
Getting following error " ORA-01036: illegal variable name/number"
Tried searching for error message -- but It says the parameters name has to be less then 32 characters, which is what I have.
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DevConnection %>"
ProviderName="<%$ ConnectionStrings:DevConnection.ProviderName %>" SelectCommand="Select ID, Name from Employee where state = @stateid">
<SelectParameters>
<asp:ControlParameter Name ="stateid" ControlID = "drdState" PropertyName = "SelectedValue" />
</SelectParameters>
I have several web forms which use a GridView linked to a DataSource control which is defined at design time as follows:
<cc1:pgsqldatasource
id="dsStates"
runat="server"
connectionstring="<%$ ConnectionStrings:PgSqlConnection %>"
oldvaluesparameterformatstring="Original_{0}"
providername="<%$ ConnectionStrings:PgSqlConnection.ProviderName %>" >
</cc1:pgsqldatasource>
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 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.
View 3 Replieshow to pass parameters to the selectmethod property of the objectdatasource control.
View 1 Repliesafter I pass querystring parameter to page,page works as expected,but after that when I change my control parameter(dropdownlist selected value how can I set querystring to null or empty...
View 1 RepliesI'm trying to link 2 objectdatasource together using the Control Parameter Source.However, I'm stuck at the screenshot below. The Next button is disabled.
View 1 RepliesI have an user control placed on a content page. The content correctly receives the session variables. In the user control I have the following
1. The pageload fires and the text box is correctly set.
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
if (Session["app_id"] != null)
{
txtAppId.Text = Session["app_id"].ToString();
}
</script>
2. I have datagrid in the usercontrol which has a binding variable tied to a control parameters as follows
<asp:SqlDataSource ID="SqlDataSourceMain" runat="server"
ConnectionString="Myconnectionstring"
ProviderName="MyProvider" SelectCommand="select
last_name,first_name
from applications
where (id = to_number(:pAppId))">
<SelectParameters>
<asp:controlparameter name="pAppId" controlid="txtAppId" propertyname="Text" />
</SelectParameters>
<SelectParameters>
<asp:controlparameter name="pAppId" controlID="txtAppId" propertyname="Text"
Direction="InputOutput" Type="Int32" ConvertEmptyStringToNull="True" />
I tried the following, same error
</SelectParameters>
<asp:SessionParameter
ConvertEmptyStringToNull="True"
DefaultValue="0"
Direction=" InputOutput "
Name="pAppId"
SessionField="app_id"
Size="integer"
Type="String" />
</asp:SqlDataSource>
For some reason the select parameter pAddId is getting set to null and get the following error when the content page is loaded If I hard code the value it works RA-01036: illegal variable name/number Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Oracle.DataAccess.Client.OracleException: ORA-01036: illegal variable name/number
I want to send multivalued parameter to SQLdatasource via gridview control.
My slect query is like
SELECT * FROM FRUITS
WHERE FruitID IN(@FruitIDs)
how can i achieve that?
I have a gridview inside a user control bind to an object datasource. Now I want to bind the object datasource with a parameter from parent page.
For this purpose I defined a public property in user control but how do I pass it with object datasource ?
I am calling from parent page like
myusercontrol.parameter=querystring["id"];
How to bind object datasource with my parameter ?
have two user controls on one aspx page. UC1 has a grid which contains a link button column which user clicks. Based on the value of clicked cell, I need to show some data into UC2.How do I pass data from UC1 to UC2? How do I invoke a function of UC2 from UC1?
View 2 RepliesI know how to pass parameters to Reportviewer in LocalReport mode via textboxes on the page where the user enters them and then they click refresh and everything works fine. What I cannot figure out is how to not pass parameters and make the report display everything, which should be the default.
I know I am missing something really obvious on the Report Parameters screen. Does anybody know the secret?
I am currently writing an ASP .NET (Framework 3.5) page that has a Grid View inside it.
One of the columns of this GridView contains only buttons, that if clicked should open a popup dialog.
To open the dialog I wrote the following code on the button's event handler:
[Code]....
Now when I click on any of the buttons the dialog opens just fine, however I need to pass some parameters to the dialog so that they can be displayed inside it. That's why I've encoded a Base 64 string and passed it as an argument of the popup dialog (apparently if I just used the plain string, the dialog would not open because the string contained linefeed characters).
Unfortunately I wasn't able to get the parameter (base 64 string) on the code behind of the popup dialog. How can I do this?