I have a GridView control with a header template with Text Boxes so users can input new data for a new row. I need to bind the text property of each TextBox in the header row with the insert parmaeters in my ObjectDataSource.
View 3 RepliesHow do I need to change the last line of the code to set the parameter and delete the record that is checked. The code I am referencing is the one near the bottom that begins with SQLDataSOurce2.Delete.
The Delete command in asp slq data source is "DELETE FROM Products WHERE ProductId = @ProductId".
DataSource:
[Code]....
VB code:
[Code]....
This is an ASP.NET 3.5 web app written in C# using VS2008 and connecting to an MS SQL backend. It is using ad hoc queries in a strongly typed dataset to pull from the database. This query (shortened for clarity) is designed to allow optional input of parameters (a requirement) or pull all records if no parameters are input. It works normally in SQL Server Management Studio with the addition of Declare and Set statements and it works normally in the TableAdapter's Query Builder:
[Code]....
The markup contains this ObjectDataSource, which is tied to the TableAdapter with the above query:
[Code]....
The problem I'm having is in passing null values to the ODS to feed to the query. Tying the ODS parameters directly to the dropdownlists and textboxes didn't work. Got an error message that there was a mismatched data type. Tried several combinations of code to feed the right values to the ODS parameters but couldn't find one that worked. Is the problem in the query or am I setting up the code-behind wrong? Here's the code:
[Code]....
I am trying to update record in gridview using ObjectDataSource (with conflict detection)The following is the ObjectDataSource
[Code]....
Update Method is as follows
[Code]....
In ObjectDataSourceProducts_Updating(..) event , I am checking objects which are being sent to UpdateProduct(..) method. I found that both the objects " original_ProductDB and productDB " have the same the values. When I click "Update" in GridView after entering new value, ObjectDataSource is not picking new value
[Code]....
GridView is as follows.
[Code]....
ProductBO is as follows
[Code]....
How to change the values in gridview on text change of templated control without databind again?the value of templated text boxes should change If i change the value of one of the templated textbox then accordingly(By mathematical calculations) the vlaues of all tempated textboxes should also change.
View 7 RepliesI have a problouw with a listview connected to a object datasource, when I try to edit a record and hit the save button without changing anything I got a error : Cannot convert value of parameter 'BirthDate' from 'System.String' to 'System.DateTime' The birthdatevalue is presented in a masked textbox, my data access layer is not reached so the error is in the listview itself How can I edit date values in a listview?
View 1 RepliesI have a repeater that I have bound to a sql reader via my code behind page.
However I can't figure out how to populate the controls in my repeater in my code behind code.
At the moment I am having to specify the database field e.g productprice with the control in the .aspx page like this
<asp:Label ID="LabelUnitPrice" runat="server" Text='<%# Eval("productprice") %>'></asp:Label>
I would rather specify fields in my code behind than embedding them in the .aspx page.
I also have a subtotal label control in my repeater that I would like to populate its text property by mutiplying two of the database values e.g productprice * unitprice shown in my repeater.
I need to do this in code behind, looping through the repeater. Any idea of how I can do this in C#?
i'm beginning with a little question. So i have this scenario
[Code]....
So i have a Linq object named TCategory. When the user wants to edit this object he will have 2 fields id and categoryName and when he press update the UpdateCategory function will receive an already made object of TCategory type storing the data user has typed. The problem is that i also want to let the client to change the id of the object so i need to pass to the function the actual Id and the TCategory object. How can i do this?
[Code]....
I have a details view that is bound to a sqldatasource. The datasource has some extra parameters besides the updated data on the screen, they are;
[Code]....
I am want to take the old values of the details view from the detailsview1_itemupdating event and add them as a parameter to my sqldatasource.
[Code]....
So how can I then add this as a parameter to my sqldatasource?
My database has 4 colums;
TraditionalID-------------TraditionalName------------Singles-----------Suppers
Singles and suppers are money fields for the price of same item. A bit like the price of a Small, Medium or Large item. What I would like to do is display the 'Singles' price and 'Suppers' price in seperate listitems so the user can choose 1 of them.
GridView:
Traditional Name__________Size
Chicken-------------------[DROPDOWNLIST]
DropDownList:
Price of Single is: £1.50
Price of Supper is: £2.50
My page loads up with the correct items in TraditionalName colum but the DropDownList is completely empty. I'm aware I don't have anything in for DataValueField and DataTextField but I have tried putting things in these attributes, like Suppers and Singles, but nothing works, so I have taken them out below.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="TraditionalID" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="TraditionalID" HeaderText="TraditionalID" InsertVisible="False" ReadOnly="True" SortExpression="TraditionalID" Visible="False" />
<asp:BoundField DataField="TraditionalName" HeaderText="Meal" SortExpression="TraditionalName" />
<asp:templateField HeaderText="Size">
<ItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2">
</asp:DropDownList>
<asp:HiddenField ID="RowTraditionalName" runat="server" Visible="false" Value='<%# Eval("TraditionalName") %>' />
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:The CodfatherConnectionString %>"
SelectCommand="SELECT Suppers AS Suppers, Singles AS Singles FROM [Traditional] WHERE TraditionalName = @TraditionalName">
<SelectParameters>
ControlParameter Name="TraditionalName" Type="String" ControlID="RowTraditionalName" PropertyName="Value" />
</SelectParameters>
</asp:SqlDataSource>
</ItemTemplate>
</asp:templateField>
</Columns>
</asp:GridView>
I'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 a Detailsview grid with an SqlDatasource, this DVG is only going to be used to insert records. The primary purpose of the DS is to populate a DDL control in the insertItem Template that I created my code is this:
[Code]....
The DDL control populates correctly, but when I try to modify the INSERTCommand property in my DS, I try to assign the value to my parameters "TesterID" and "TesterDate" but the only options for controls to pick from, is the DGV but not the DDL in it. I assume it has to do with the InsertItem template but even if I reset it I still cannot pick the textbox as a control that would give the value to my parameters.
I did find a workaroun by build a public method and calling it in the onclick event of the insert button but looks like I have to create another connection to the database which to me seems unnecessary since I already have a DS and everything. how can I do this without having to use my method. here is my method just in case.
[Code]....
I use an objectdatasource programmatically to use a parameterless method when SearchWord variable is empty and a Search method with one parameter when SearchWord is not empty, the event I use is objectdatasource selecting so that I can adjust parameters conveniently, I have a problem here: I can add a new parameter and set its value but I can't remove a previously added parameter from objectdatasource selectparameters and an error raises because of this, this is the selecting method:
[Code]....
Both adding and removing the search parameter takes place in this method while adding works removing the added one Not works.
I'm trying to figure out if it's possible to use an ObjectDataSource Update method with a table-valued parameter. Here's my ODS:
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
DataObjectTypeName="TestProject.MyTestDataTable"
SelectMethod="GetTestData" TypeName="TestProject.BLL.TestBLL"
OldValuesParameterFormatString="original_{0}"
UpdateMethod="UpdateTestData">
<SelectParameters>
<asp:Parameter DefaultValue="65" Name="testId" Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>
I bind this to a GridView but I'm not looking to edit row by row. Instead my GridView has a bunch of TemplateFields with textboxes. I also have a Button that when pressed, invokes the Update method of the ODS. So then the "UpdateTestData" function in my TestBLL is called. This looks like this:
public void UpdateTestData(MyTestDataTable dt)
{
QueriesTableAdapter qta = new QueriesTableAdapter();
qta.UpdateTestData(dt);
}
At run-time in debug, it seems like the object for the signature above is not populated with the data from my GridView.
I want to bind an ObjectDataSource to a property in my asp page and I want to do it in the page's aspx code, not in code-behind. I've already done it in code-behind, as follows:
[Code]....
I'd prefer to get rid of the ugly code-behind and just do this in mark-up. Something like
[Code]....
This gives me a run-time error: Cannot create an object of type 'System.Object' from its string representation 'SelectedBook' for the 'DataSource' property.Is there a way of doing this declaratively and not in code-behind? Further, what if what I want is to actually use a child property of the property in question? For example, if my Book object has a ReaderComments collection, can I databind to it decaratively in the aspx mark-up?
I have a gridview and there is a templateField with a few labels in it. I have a dropdownlist in a headertemplate and when the selectedindexchanged event I am trying to change the values associated with those labels. The name of the gridview is Gridview1. Here is the template field when it is first shown
<asp:TemplateField ItemStyle-CssClass="phoneCostsPhoneStyle" >
<ItemTemplate>
<div style="position:relative">
<asp:Label ID="lblDayCallPhone" runat="server" Text="Day:" CssClass="lblDayCallPhoneStyle"></asp:Label>
<asp:Label ID="lblDayCostsPhone" runat="server" Text='<%# Eval("NATIONAL_DAY", "{0:C}") %>' CssClass="lblDayCostsPhoneStyle"></asp:Label><br /><br />
<asp:Label ID="lblEveningCallPhone" runat="server" Text="Evening:" CssClass="lblEveningCallPhoneStyle"></asp:Label>
<asp:Label ID="lblEveningCostPhone" runat="server" Text='<%# Eval("NATIONAL_EVENING", "{0:C}") %>' CssClass="lblEveningCostPhoneStyle"></asp:Label><br /><br />
<asp:Label ID="lblWeekendCallPhone" runat="server" Text="Weekend:" CssClass="lblWeekendCallPhoneStyle"></asp:Label>
<asp:Label ID="lblWeekendCostPhone" runat="server" Text='<%# Eval("NATIONAL_WEEKEND", "{0:C}") %>' CssClass="lblWeekendCostPhoneStyle">.........
Append Query String Parameter Values in Current URL.
I have added Hyperlink in data list.which is Bind with their Respective data.When I Click that Hyperlink it Will Pass Url like this.
Area_id,Cuisine_Id and Veg_Id Bind in Datalist
[URL]
I want to Built a Filter Page Which Includes Area_id, Cuisine_Id and Veg_Idso when i Click to Hyperlink of Area then url like this. [URL] And then After i click to hyperlink of Cuisine then URL Like this.
[URL]
Similar Way
[URL]
So Basically I want Filter Data With Clickable query Strings Parameter Values
Problem : How can i Make Url Like this and it is Dynamic
[URL]
I want to Do Something like this SitePage Filter
[URL]
The values in one of the fields in my GridView's table are just either a zero or a one or a null. Well, "zero," "one," and "" are not very appropriate values to display to the end user. Is there a way I could change these to "True"/"False"/"NA" or "Yes"/"No"/"NA"?
View 5 RepliesI have a dataset into which I load an xml file using DS.ReadXml("~/Example.xml"). I have a column labeled show which is a checkbox. Below the gridview I have a button which says show all. When this is pressed, I want it to check every checkbox in the gridview and save the dataset back to the xml file.
My xml file has the following format:
[Code]....
My code is as follows:
[Code]....
Why doesn't this code work? I get the following error whilst executing it:
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
I got a gridview -CompGrid, having 3 columns - Dept, Employees, Status.
The 'Status' tab need to be edited. So that I put a Dropdownlist as an Itemtemplate and connected the 'DataValueField' as 'Status'.
Now I can edit each row by row only. Some times it needs to update all the employees status in one department.
So that I placed 2 more dropdownlists in outside of gridview.
1. Department List, 2. Status List.
My requirement is this, When I select one department and corresponding status, it should update all the records of that department in the grid.
I am using VS 2008 SP1. My also have included CSS Friendly adapter [URL] in my project ( I mentioned this because my GridView Empty data template is not showing when using GridView's CCS Friendly adapter). I have a GridView and a DetailsView. When a record in GridView is selected its details information is shown in the Details View. Type of Data source I am using is ObjectDataSource. My Insert and Update methods works perfectly. It is only the Delete method that is passing null values to the underlying object delete method. My source codes for both the UI, BLL, DAL is shown below
[Code]....
My Business Object code is below :
[Code]....
My Data Access Layer Code is:
[Code]....
I have a repeater control populated with data binding expressions like in the expression below...
[Code]....
I want to be able to redirect a user to default link if the LinkURL value is empty, that is for each data item, there will be a check if the LinkURL field contains a value. If not, a default value will be supplied.
i want to pass multiple arrays variable in query string.for example i have three checkbox list Brand ,Price, Attribute any arrays variable may have more than one value key arrays variable are fixed for checkboxlist
1-checkbox list Brand has Brand []arrays variable
2-checkbox list Price has Price []arrays variable
3-checkbox list Attribute has Attribute []arrays variable
now i have selecting two -two from every checkbox list .than i want to query string something like this
www.defualt.aspx?brand[]=samsung=123&apple=11,Price[]=100=12&200=2,Attribute []=camera=1&display=2
I have a gridview that has certain values in it that I would like to change based on a condition. For example, if a value in the column is 'x', I would like to make that Value Bold and have text that says 'Not applicable'
How can I do this? How can I programtically chnage values in a gridview?
I have a gridview with a dropdownlist in one to the headers. So on the onselect event of the dropdownlist I want to change the assigned values of itemTemplate values inside one of the columns.
View 1 Replies