Re: Changing color on Boundfield text content - ASP.NET Discussion Boards

Count number of records from a tabel and display result in a gridview column at run time.

Eagle3222-May-10 11:58

22-May-10 11:58

Hi I am using a gridview to display data from my table at runtime. I am new to ASP.NET.

I am not using boundfields but I am using Template fields. I specify the HeaderText and DataKeys

I am using a web service to provide me a DataSet of the chosen table and bind it to the GridView in page_load event.

I would like to count the number of records from a chosen table and display that in the Gridview.

I have written a method to return number of records by passing in a string parameter product name
but i am not sure of how to invoke the method so the value is shown in the GridView.

How could i go about doing this?

Do i need to invoke the method using Eval like this:

<asp:TemplateField HeaderText="ProductName" SortExpression="ProductName">
      <ItemTemplate>
       <%#GetRowCount(Eval(ProductName))%>
  </ItemTemplate>
</asp:TemplateField>

Would the above work?

Thanks,

Re: Count number of records from a tabel and display result in a gridview column at run time.

Sandeep Mewara22-May-10 20:35

Sandeep Mewara

22-May-10 20:35

Why to hit performance(and extra code!) so much when you can get the same information in the dataset of gridview along with other data?

Using webservice when you are getting data, also retrieve the count of rows in it.
Or, if you cannot do that, then before using it as a source to grid, append the count of rows to dataset and use the modified dataset as datasource of your grid. You are all set!

Re: Count number of records from a tabel and display result in a gridview column at run time.

Eagle3223-May-10 1:32

Eagle32

23-May-10 1:32

Can you provide me an example please if you dont mind?

Thanks,

Changing color on Boundfield text content

lvq68422-May-10 8:21

lvq684

22-May-10 8:21

Hi.

I have this updatepanel, with some fields that are getting filled from an ObjectDataSource.
One of the fiels are a date, and i want this date to be marked as red (and maybe in bold) if the date is one day from today or later.

Problem is, I have no clue on how to do this, since I am new to asp.net!
So is there a way to add a method that changes this specific ItemStyle-ForeColor based on the content i get from my datalayer?

This is my updatepanel:

<asp:UpdatePanel ID="updatePanel" runat="server" UpdateMode="Conditional">
        <ContentTemplate>
            <asp:GridView Width="1200" ID="gvTasks" runat="server" OnRowCreated="gvTasks_RowCreated" 

                DataSourceID="odsTaskList" GridLines="None" AutoGenerateColumns="false" CssClass="mGrid"
                PagerStyle-CssClass="pgr" AlternatingRowStyle-CssClass="alt" OnSelectedIndexChanged="GvTasks_SelectedIndexChanged"
                DataKeyNames="ID">

                <Columns>

                    <asp:BoundField DataField="Enddate2" HeaderText="Enddate" ItemStyle-ForeColor=RED-IF-OVERDUE-EXCEEDED ItemStyle-HorizontalAlign=Center>
                        <HeaderStyle Width="80px" HorizontalAlign="Center" />
                    <asp:BoundField>

                <Columns>
            <asp:GridView>
        <ContentTemplate>
    <asp:UpdatePanel>

Thanks alot!

Re: Changing color on Boundfield text content

Sandeep Mewara22-May-10 10:25

Sandeep Mewara

22-May-10 10:25

lvq684 wrote:
I have this updatepanel

It does not matter in your case.

lvq684 wrote:
i want this date to be marked as red (and maybe in bold) if the date is one day from today or later

You need to use RowDataBound of GridView for this.

protected void GridView_RowDataBound(Object sender, GridViewRowEventArgs e)
{  
   DataControlRowType rtype = e.Row.RowType;   
   if (rtype == DataControlRowType.DataRow && rtype != DataControlRowType.Footer 
       && rtype != DataControlRowType.Separator && rtype != DataControlRowType.Header 
       && rtype != DataControlRowType.Pager)   
   {  
      //Logic to get the color needed to be shown    
      Calendar cd = e.Row.FindControl("myCal") as Calendar;
      //Set whatever color you need to!
      cd.ForeColor = Color.Red;
   }
}

Re: Changing color on Boundfield text content

lvq68422-May-10 11:48

lvq684

22-May-10 11:48

Thanks alot for your answer, but I dont quite follow the code.
Whats up with the

Calendar cd = e.Row.FindControl("myCal") as Calendar;

And could you please paste the corresponding .aspx code for the Gridview please?

I am very grateful!

Re: Changing color on Boundfield text content

Sandeep Mewara22-May-10 20:31

Sandeep Mewara

22-May-10 20:31

I believe what i have provided is more than enough.

lvq684 wrote:
could you please paste the corresponding .aspx code

No! i wouldn't

lvq684 wrote:
but I dont quite follow the code

You said you have a calendar inside the grid, so that line gets the calendar control to you.

Looks like you are a fresher. Would suggest you to read book first.

Re: Changing color on Boundfield text content

lvq68422-May-10 20:49

lvq684

22-May-10 20:49

Yes, as stated in the first post, I am new to asp.net.
It´s not a calendar but a simple string which holds the date. The date sorting is being issued elsewhere. But I´ll try changing the calendar to a string and fiddle with it.
Question is just how the page control calls this method. I will google some more.

Thanks.

how to draw vertical rule in asp.net

developerit22-May-10 3:28

developerit

22-May-10 3:28

hi, iam using asp.net with c#,
in my page there are many images in top ,left , right,bottom i want to draw verticle line and horizontal lines like this as showed in below example .can you give example which helps me

||
image1 || || image9
|| ||
|| ||
image2 || || image9
|| ||
|| ||
|| ||
image3 || || image10
|| ||
||====================================||

image4 image5 image6 image7 image8

Re: how to draw vertical rule in asp.net

Yusuf22-May-10 7:01

Yusuf

22-May-10 7:01

You can use css to draw borders, see here[^]

Yusuf
May I help you?

Re: how to draw vertical rule in asp.net

Tej Aj23-May-10 21:24

Tej Aj

23-May-10 21:24

Check this post
it may help to draw vertical and horizontal rule

http://opexsolution.com/forum/viewtopic.php?f=15&t=43&p=126#p126[^]

xml to gridview

Tomlor198022-May-10 3:21

Tomlor1980

22-May-10 3:21

Hello all!
I'm new to asp.net and i'm trying to bind some XML data to a gridview.
abviously I'm not understanding how to do it properly because that my code doesn't seem to
work...Can anyone could help me please?

this is my xml:
#########################################
<?xml version "1.0" encoding "utf-8"?>
<dictionary>
<item>
<key>
<string> hello world </string>
</key>
<value> <anytype xmlns:q1="http://www.w3.org/2001/XMLSchame" d4p1:type="q1:int"
xmlns:d4p1="http-instance">45</anytype>
</value>
</item>
</dictionary>

and this is my code:
########################################
string path = "D:\\myXmlFile.xml";
DataSet oDs = new DataSet();
oDs.ReadXml(path);
GridView1.DataSource = oDs;
GridView1.DataBind();

thanks
Tom

Cross post

Not Active22-May-10 3:32

Not Active

22-May-10 3:32

You were asked to not cross post. Please read the How to get an answer to your question[^]

I know the language. I've read a book. - _Madmatt

Re: xml to gridview

dan!sh 22-May-10 5:59

dan!sh

22-May-10 5:59

There are a lot more forums left. Why not post your question in all of them.

Looking for a pattern for managing URL in a Web Application

Nadia Monalisa22-May-10 2:51

Nadia Monalisa

22-May-10 2:51

Hello,
I am looking for a good design pattern that will solve managing Urls in a web application. At this moment, I have a chaos of hard coded url referring in every pages. If I change the page name, I get lost as I dont know how many pages I have to update where I used the url. So, I am assuming, there should be a pattern something named URL Factory etc. Cany you please give me a guidance... !

Another question, does it make any difference in performance if I use absolute URL instead of relative url ? I am thinking of developing a URL factory for my web application and so, if I use Absolute url, it may be easy to manintain my Url factory.

Regards.

Re: Looking for a pattern for managing URL in a Web Application

Not Active22-May-10 3:10

Not Active

22-May-10 3:10

There is no pattern for this, although, the MVC pattern may be able to help since urls are based on actions not actual page names. The application should be sufficiently designed so you are not continuously changing file names.

I know the language. I've read a book. - _Madmatt

Re: Looking for a pattern for managing URL in a Web Application

Nadia Monalisa22-May-10 3:15

Nadia Monalisa

22-May-10 3:15

Hi Mark,
Thanks for your reply. I know that MVC solve this problem, but I actually do not like MVC as I am so much fond of event based programming, moreover, I have already developed a complicated ASP.NET Application based on Web Form, so maybe Model View Presenter would be a solution for this. Can you tell me if there is any standard Model View Presenter framework available for Web Forms ?

Re: Looking for a pattern for managing URL in a Web Application

Not Active22-May-10 3:23

Not Active

22-May-10 3:23

Emran Hussain wrote:
I actually do not like MVC as I am so much fond of event based programming

It's not a case of whether you like it or not, or whether you are fond of it or not. The best tools for the work should be the deciding factor. Many projects have failed miserably because managers, architects and developers having only used what they are most familiar with or most comfortable with, not the best solution for the problem.

I know the language. I've read a book. - _Madmatt

Print Button Not Working well

reogeo200821-May-10 21:38

reogeo2008

21-May-10 21:38

Hi Every1,

I have webpage which displays an article and at the end of the same i have a print buttn (Asp:ImageButton).When i click on it ,i want to open a new window with article on it and a print dialogue box for printing..How can i acheive this...
Thanks in Advance,

Re: Print Button Not Working well

Viral Upadhyay22-May-10 0:40

Viral Upadhyay

22-May-10 0:40

I don't understand your question but, if you want to open a new window on image click then
Use ImageButton 'onClientClick' Event.

like

onClientClick="window.open(your page url);"

Viral
My Site

Save Our Tigers

Re: Print Button Not Working well

Andy_L_J22-May-10 0:51

Andy_L_J

22-May-10 0:51

This may just foot fit the bill..

Creating print preview page dynamically in ASP.NET[^]

I don't speak Idiot - please talk slowly and clearly

'This space for rent'

Driven to the arms of Heineken by the wife

Re: Print Button Not Working well

Yusuf22-May-10 1:13

Yusuf

22-May-10 1:13

window.open opens link[^]a new window and window.print link[^] will print your article. It will show the print dialog first.

Yusuf
May I help you?

Language Conversion to English, Hindi

kavithadev21-May-10 21:26

kavithadev

21-May-10 21:26

Hi,

I Want to Convert my whole site to Hindi...I have two links as Hindi and English...If i click the link as Hindi the whole site should be converted to Hindi and if i click the link as English then the whole site should be changed to English, same as that of this site "http://www.univercell.in/mobiles/populateStore.action". Plz do the needful

Regards,
Kavitha

Re: Language Conversion to English, Hindi

Sandeep Mewara22-May-10 0:43

Sandeep Mewara

22-May-10 0:43

No need to post it multiple times. Stick to one and follow it. Remove the other one you had posted before anyone replies to it.

Re: Language Conversion to English, Hindi

Yusuf22-May-10 1:21

Yusuf

22-May-10 1:21

lmgtfy[^]

Yusuf
May I help you?

Last Visit: 31-Dec-99 18:00 Last Update: 17-Apr-24 15:56

Refresh

ᐊ Prev 1...903 904 905 906907908 909 910 911 912 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.