I have a date base with a table named 'movies'. I want to take information on my database. I use a SQLDataSource. For my presentation, I use a repeater. Here is my code :
[Code]....
But if for exemple, 'champ1' is empty in my database, i don't want to print it in the result of my query ! But i can't arrive ...
I understand in a gridview that is databound by default HtmlEncode is set to trueHow do I protect template fields in any data presentation control?
View 1 RepliesMy question is if my page size is 10 records per page and my query returning 100,000 rows then remaining all records are not in use for that page.
Is there any way so I can only fetch records from table as page size (10) with all page numbers at bottom and fetch next 10 records only when user clicks on next page number?
Apologies if this is in the incorrect forum.. just a question about how to best structure some tables for a particular presentation of data. In the following table (2nd column) you'll see that each motorcycle product applies to a range of years. What is the best way to store this range of years in a relational db? At the moment I have a datefrom and a dateto field for the two ranges, but that may complicate things when I want to filter the table by a particular year. E.G. datefrom is 2006 & dateto is 2010 and I would like to filter by products for a 2008 model.
View 4 RepliesI am displaying images on grid view control and I want to export these images on power point (.ppt) file how can I do this?
View 1 RepliesI have a table in my database with three fields: COURSE_ID, PERC, DATE.I need to display sets of rows based on the date, the number of rows in every set will be known at run time, the same as the number of sets, so I was thinking about adding two buttons (one to add a set and another to add rows in that set)
I know that working with GridViews will do, but do not know how exactly, maybe one gridview for the sets and a second gridview (inside the first one) for the rows inside the sets.
<Add Set>
<Add Row>
Set 1
COURSE_ID PERC DATE
2 10 2010-12-02
3 90 2010-12-02
Set 2
COURSE_ID PERC DATE
3 90 2010-12-10
4 10 2010-12-10
Set 3
COURSE_ID PERC DATE
3 80 2010-12-15
4 5 2010-12-15
5 15 2010-12-15
Set 4
COURSE_ID PERC DATE
2 100 2010-12-18
We are using a tierd design with a Data Access Layer and classes for everything we need. This serves as an advantage because we do not have to write querys over and we can separate the Presentation layer from the Data Access Layer and Business Rules.I have always in the past populated GridViews, DataLists, repeaters,etc with SqlDataSources. This is what I have become accustomed to and I feel like it is simple. For querys such as Select * from Members, I feel like using a DataSource is simpler than having to go in the code and calling methods to populate and DataBind these presentation controls.
I am working with a gentleman who has introduced me to the world of Data Access Layers and we are breaking everything down into simeple, but effective queries to populate controls and do what we need to accomplish with this application. He is not very approving of using any type of DataSource. We are disagreeing on the time and place to use these class methods to call the database.So my question is, which is more widely used in the programming world? Do most people use DataSources to populate presentation controls regardless of the Data Access Layer they are working with? Which type of queries are best suited for a DAL - simple, populating queries or complicated joins and upserts?
On my web page I'm trying to manage a tabular control of some kind that supports inserting. The data will be inserted locally on the page, with no connection to any kind of DB. The inserted data will exist only on this page and will be lost after navigatingto another page.A table that shows all the added rows and has an empty row for inserting is perfect.
View 5 RepliesI have a SQL table with questions and store the answers. Depend on the user selections, I need to display dynamically the questions and try to get the answers for them. ie: sometime I need to display 3 questions, and get 3 answers; sometime 5 questions, and try to get 5 answers.I know about dynamically loading the questions and display them. But how do I dynamically binding some kind of data control to get the dynamic answers back?Normally, in .aspx I would have <asp:TextBox ID=MyAnswer ....> or <DropDownList ID=MyDropDownList....> then I would use the C# behind to refered to MyAnswer.Text or MyDropDownList.SelectItem.....But in the dynamicly generated forms, how do generate multiple questions and bind somekind of multiple "TextBox" with ID and be able to refer them from the c# behind?
View 1 Repliesi have problem with manging format of string at run time
actually i have infomation in tabular form , a i am accessing that in coding in string fromat and send it by mail but when i send it shows html coding and not view in tabular .
I am trying to workaround a case where I have to design my page similar like msdn library page whew left nevigation is collepseble as well as dumemic extemded as per tje wodtj of tree item in tree .
View 1 Repliesi use the grid view so edit & Delete the records. using
<asp:CommandField ShowEditButton="True" />
<asp:CommandField ShowDeleteButton="True" />
But due to more fields the gridview is out of the Master page.
So how can I manage the gridview columns especially at time of edit the records.
I have a Data Table which Populate from the Stored Procedure which is below
[Code]....
and iam binding the Gridview with Data Table it is working .Now i have to make some thing visible and Invisible based upon some Value like below
Datatable dtTable = (Viewstate)["StatusData"]; // Same Data Table which is Data Source of Gridview Control
[Code]....
Where Status.Open is an integer Enum value like Open = 1 and Close = 2 .row["Status"] is the Text Open and i want to compare with integer valueHow i compare the Values ? i have to use the same Data table or not?
I have Gridview with column name END Date.
DATE is dd/mm/yyyy Format
Available data is :- START DATE = 1/1/2010 , STOP DATE = 1/4/2010 ,INTERVAL = 1 WEEK
HOw to bind data to gridview such that gridview should display data from 1/1/2010 to 1/4/2010 for the interval of 1week
THE OUTPUT SHOULD BE:-
[code]...
[URL]
if the ABOVE pic is not visible CLICK HERE to view
I want to change the colors of the values from the table SALARY
if the salary is > 20,000 i want to change it to GREEN color
if < 20,000 then it should show RED color
I am trying to get gridview with SqlDataSource.
When I do test the SQlDataSource with condition in status field, It shows error that invalid column name.
status field data type is char and default value is O in SQL server. When I give the 'O' in condition, it comes error about invalid column name.
What does it mean eaxctly invalid column name and how can I fix it?
Do I have to change DB type or something?
.error message is Invalid column name 'O'
[Code]....
In my grid I have three fields: Action date, type name and TypeId. I want to make the Edit linkbutton disabled when the type name is either 'Accepted date' or 'Received Date'. I can do it if there is one condition by the following code, but I can not pass both.
<asp:LinkButton
ID="lbEditAction"
runat="server"
CausesValidation="False"
CommandName="Edit"
CssClass="LinkButton"
Height="19px"
Text="Edit"
Enabled='<%# Not "Accepted Date".Equals(Eval("ActionTypeName")) %>'
Width="39px"></asp:LinkButton>
Is there a way to do this?
I have a gridview that is being populated off of a query that has joins in it. It works fine. However, I want to display one record of all information but then blank out all colunmns accept 1 for the other 3 records that it is picking up. In other words, right now, all three records have duplicate info in them accept this one column. can this be done? Can I somehow blank out other columns based upon what is in the single column? This is all being done in a gridview. I realize it would do a master detail type scenario but I want all of this information to display without someone having to click on a field or anything.
View 4 RepliesI have a gridview bound to object data source & in its item template i have some labels and one image control and I have a [Status] column in database that store either true or false in bit format . now what i want is if value in status column is true then image control's ImageUrl property should use image ~/images/Show.jpg and if it have false value then it should show ~/images/Hide.jpg.
currently i am using this code it works fine but i think there must be some good better way to achieve this goal. here is the code that i m using
if (e.Row.RowType == DataControlRowType.DataRow)
{
Image img = (Image)e.Row.FindControl("ImgCatStatus");
if (img.AlternateText == "True")
{
img.ImageUrl = "~/images/Show.jpg";
}
else
{
img.ImageUrl = "~/images/Hide.jpg";
}
i have bound the alertenateurl to <%#Bind('Status')%> and performing evaluation based on value it contain
I have one asp.net gridivew where i have written some code and bind it.. itz working fine now my requirment is when ever any gridview row which conatin column 3rd zero(0) i want to hide tht row ..
View 2 RepliesI have a Repeater displaying some data that doesn't do what I'd like to see. If a certain condition is met (ex: parent.NumOfChildren > 0) I would like a hyperlink shown. Here is what I have so far:
<asp:Repeater ID="parents" runat="server" >
<ItemTemplate>
<asp:HyperLink NavigateUrl='<%# "Children.aspx?parent=" + DataBinder.Eval(Container.DataItem,"Parent_ID")%>'
Text='View Children' runat="server" target="_self" ID="Hyperlink2" NAME="Hyperlink2"/> -
</ItemTemplate>
</asp:Repeater>
In this case, the "View Children" link shows up for every item in my Repeater, but I'd like it shown only if parent.GetNumOfChildren() > 0. Would it be correct to try setting the Visible="true/false" property of the HyperLink? Is that the norm for this sort of problem? Or, is there a way to wrap the entire <asp:Hyperlink> ... </asp:Hyperlink> tag in an if statement that has a reference to the object that is currently being interated in the Repeater? Ie:
if(CurrentDataItemInIteration.GetNumOfChildren() > 0)
{
<asp:Hyperlink> ..... </asp:Hyperlink>
}
To me, the Visible="true/false" solution seems cleaner, if possible.
i want to add b.colr to gridview row
html code
<div>
if i give the 10 number,10 number of same images should be diplayd in the Grid View.
how can i do that.
i m displaying an image in gridview based on condition from sql table. That is if the colum named "availabillity" is A the image will be red n if the value is "NA" the image will be green. i am using RowDataBound event.
but i am getting error as "Cannot implicitly convert type 'System.Web.UI.WebControls.DataControlRowType' to 'bool'".
I have a stored procedure which is returning me several rows. I am presenting the rows as item in a repeater. I need to move one of the rows down to the footer template, based on a condition. For instance, if my stored proc is returning a column called A, I need to drop this record to the footer item, if the A column value is Total. I have no idea how to do that.
View 2 Replies
