I have data in a db. I can get to this data through a data source. However when I review values into a data control (GridView, FormView... etc.) I am unable to get to the values in the data controls logically. How do I reference these values? Is there a better way than using data controls?
View 8 RepliesSay I've got a database with about 5,000 blog posts from the last 2 years, I'm trying to create 'monthly' archives so I can display the data in a much more logical way. For some reason I've never really had to work with date's all that much and my knowledge is lacking. I'm using Linq/C#; can someone point me in the right direction to learn how to do this?
View 2 RepliesUsing a class component, an Object data source and a formview I am successfully pulliing data from a SQL database. In some cases the rows contain one or more Null values and I would like them to be ignored completely. My simple code follows:-
<%# Eval("add_1") & ","%>
<%# Eval("Add_2") & ","%>
<%# Eval("Add_3") & ","%>
OUTPUT:-
Rose Cottage, 123 New Road, Margate,
I 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 am using Asp.net 3.5 listview control. In item_updating event I am using this code...
dim country as string = Dim country As String = e.NewValues("country_name").ToString.Replace(" ", "")
It's updating record correctly. for example if I update USA to USA 1 1 then it's updating like as it. But I want it to be USA11
I am using VS 2005.I have 5 tables depending on their values ,I need to draw a bar chart.
View 1 RepliesUpdates to the edited item are not passing the new / updated values but rather the original values. And I can't for the life of me figure out why when I change the original value in an edit textbox and post the update the new value is not being passed. I get the original value. Perhaps fresh eyes can spot the problem. This should be super basic but apparently I'm missing something.
Here's the code for the Item and Edit templates. The code behind is below this.
[Code]....
Code behind begins here....
[Code]....
i take data from Sqlserver database , and my prblem is that i want to get old and new values from gridview and base on that i want to change there background colors .. i try gridview rowupdating , editing ,updated Events but when i debug no break point hit and there was no value in ViewSate that i declare ,
View 2 RepliesI have a grid view and I added edit and Save buttons to it. When I click on edit I am able to edit the data but when I click on save I amgetting the data before edit.Please see my code below.Eg: I have start date as 2005-10-10 12:00 AM so After I click On edit it is letting me to edit, So If I edit the start date to 2010-10-10 12:00 PM and click on the save button I am stil getting the old start date. which is 2005-10-10 12:00 AM instead of 2010-10-10 12:00 PM
View 3 RepliesI used following code,
[Code]....
In my database....
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.
sample SQL data:
table1:
eid ename
1 vijay
2 shankar
table 2:
id eid sal
1 1 4000
2 1 3000
3 2 2000
i want to bind the below data format in repeater.
vijay
4000
3000
shankar
2000
I am showing data on a gridview.I want to show one of the column as hyperlinks and when i click that column value and it need to releated value information in a sepereate page.
I am trying to use hyperlinkfield but it wont take values (data).How to acheive my task..
I'm trying to collect the checked boxes values in a data list. Need to collect the checked value (ie "1") and the data key value (cdID) together in an array to then insert into DB. Here's the Datalist:
[Code]....
Here's my attempt(which isn't working too well):
[Code]....
I have a grid which is binding to a objectdatasource and when it is in edit mode, i am displaying a form template and wanted to bind all the values. I have one field called ApprovedCode. In the edit mode, i am displaying all the codes drop down list box and making a bind on the selectedvalue and i dont know how to handle when it is empty. When it is empty i wanted to display "Select..."
I followed this forum post but i am getting error
[URL]
This is my code
[Code]....
This is the error message that i am receiving
"ddlApprCode' has a selectedvalue which is invalid because it does not exist in the list of items
I'm using ADO.Net code to access and update the data from the database. I'm using GridView for presentation. I wish to preserve old values of all the columns while updaing the records.
I'm using Code behind and not d Data Source controls. I wish to list the old records once record is updated.
I have a gridview, which on the row data bound method that inserts a row when comparing values on a particular field. If the two values are different, a new row is inserted, if not no row is inserted. This coding is working as a grouping gridview, and is working correctly. However, I have problem, and problem is counting the rows between each group, which I want to display in my blank row between each group, the value of which I am holding in a hiddenfield.
When I try to do it, the first group doesn't show the result, but is displayed on the next group. I am pretty sure that I am doing something wrong. My approach is that if the value between the last row and the existing row are different, then the value is one, on the next row data bound event, if the values are the same then the value is increased by one, else the value is one because it is a new group. Here is my code:
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
Table tbl = e.Row.Parent as Table;
TableCell cell = new TableCell();
CheckBox chk = new CheckBox();
Label lbl2 = new Label();
HiddenField rowValue = new HiddenField();
if (e.Row.RowType == DataControlRowType.Header)
{
e.Row.Visible = false;
}
else
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Session["count"] = 1;
Label lbl = (Label)e.Row.FindControl("lblValue");
string str1 = ((Label)(lbl)).Text;
string prevStr= (string)Session["previousStr"];
if (prevStr== str1)
{
lbl.Visible = false;...................
I am looking for an open source CMS for ASP.NET MVC. I have found MvcCms, N2, and AtomicCMS. I'm looking for any advice, anecdotes, resources or articles comparing the different open source projects so I can find the best one for my project. I'd like to find information about the features, extensibility, relative reliability and continued development of the different projects.
View 2 RepliesHere's what I am trying to do:
Inside Form View Want to display the average of a field based from field1/field2
ie:)
Field 1 = 10
Field 2 = 5
Field 3 would equal 2 (Field 1 / Field 2)
How would I go abaout doing this. Code currently looks like:
[Code]....
Using custom bind expression in the formview but it won't let me do this..
I need to get data from all rows which are selected (check box enabled). Can anyone give me hint? I am killing myself for last 10 houres with this.
What i need to say is that datasource is xml file
I am working with a formview edititemtemplate. Currently in my page load, i have some stuff that would show or hide certain panels based on dropdownlist values. These dropdown values get binded during page load. I need to be able to change the values/dropdowns, without rebinding the old data, and updating the visibility of the panels based on predefined rules.
I have experimented with putting my formview.databind() in page load if isnotpostback, in prerender, in prerender if isnotpostback. I have tried my rules (ex if ddlState.selectedvalue = "DE" then pnlDelaware.visible = "true") in the page load, and the page render. I'm just not sure how to get the stars aligned here. The closest i have come is having the databind in the pageload if notispostback, and the rules in the prerender. However I get an error "dropdownlist has a SelectedValue which is invalid because it does not exist in the list of items.
I have a typical gridview/formview master control setup. When I try to update or insert I don't get any errors but it also doesn't work. When I try to insert data all I get are null values and when I update, none of the values are updated. The formview looks like its working, but just doesn't. The primary key is an identity and it auto-increments by one.
[Code]....
i am using a gridview in my web page,i used to bind the database records to the gridview..my columns are name,empid,company name,pl leave,sl leave,total leave taken here total leave taken is not a database fields,in the page i want to fill the records once loaded pl leave and sl leave is added and display in the total leave taken column..it working properly when all pl ans sl columns fill with numbers,if some pl and sl leave having blank values.it showing an error like input sting was not in correct format..this is my code
<Columns>
<asp:BoundField DataField="slno" HeaderText="SerialNo"
SortExpression="slno" />
<asp:BoundField DataField="ecode" HeaderText="Employee Code"
SortExpression="empcode" />
<asp:BoundField DataField="ename" HeaderText="Employee Name"
[code]....
i showed two column (Electronics,Photoshop) but i have six. i want to update their checked or unchecked condition in database (0,1) how do i do?
<asp:CheckBox ID="CheckBox1" runat="server" Text="Electronics" />
<asp:CheckBox ID="CheckBox2" runat="server" Text="Photoshop" />
<asp:CheckBox ID="CheckBox3" runat="server" Text="VideoEditing" />
<asp:CheckBox ID="CheckBox4" runat="server" Text="Gaming" />
<asp:CheckBox ID="CheckBox5" runat="server" Text="Coding" />
<asp:CheckBox ID="CheckBox6" runat="server" Text="Miscellaneous" />
I have a web page on which I want to show reviews from a particular Amazon product. How do I do that? Whenever a new review is written on Amazon, my page should be able to show that.
View 1 Replies