.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Color for rows in a table

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :ASP.Net

I have a table with 5 rows and 2 columns and I am changing the color of each row based a value from the database.

The colr is owrking is good but there's white space between the columns and I don't want that.  I would like to see it all look like one long row blended together...  not black, then a white space and then more black.  Keep in mind that each row will be a different color.

Any suggestions?


View Complete Post

More Related Resource Links

Using jQuery to Filter Table Rows

The project is using the .net GridView control, so I had limited control over the output HTML code. Still, I think this code can work for most tables. One thing to notice: you should use the class "filterable" on your table or on one of its parents for the code to work.
First, we need a text box:

RadioButton Groups, Table Rows And NamingContainers in asp.net

The RadioButtonList. Very handy for inviting users to select just one item from a list although because of the screen real estate it takes up, used less and less in favour of the DropDownList. In plain HTML, the browser knows to enforce the unique selected value amongst a list of radio buttons because they all have the same value for their name attributes.

RadioButton Groups, Table Rows And NamingContainers

(In which AJAX-enhanced CheckBoxes become more useful than RadioButtons but inheritance saves the day, and a simple RadioButton-derived control establishes the purpose of a control's naming container)

The RadioButtonList. Very handy for inviting users to select just one item from a list although because of the screen real estate it takes up, used less and less in favour of the DropDownList. In plain HTML, the browser knows to enforce the unique selected value amongst a list of radio buttons because they all have the same value for their name attributes.

no of rows in single table

hi friends...i need one count...one sql table how many rows able to create or write in sql server 2005

How to get the Top N rows from SQL Table..

Hello Friends..                 Recently i have come across one question in sql queryQuestion:         Which SQL Query helps to view the TOP N rows From the particular SQL table?I request anyone please solve this question... Thanks...                   

Duplicate rows in Table

Hi, I have a table with two rows Name  ||    Surname || Account No || Money Expensise || Amount                                                     Total ------------ Amount How can I display the last row Total at the bottom of the table not for every first row.  Thanks Anyone helps!

generate dinamic rows with tetxbox in asp:table

) dynamically generated new rows containing two columns, one with a display name and the other a textbox for the user to enter a value. " ye="Hola, en TablaVenta () genero dinamicamente nuevas filas que contienen dos columnas una con un nombre para mostrar y la otra un textbox para que el usuario ingrese un valor." closure_uid_83htk5="176" mce_style="BACKGROUND-COLOR: #ebeff9">Hello, in TablaVenta (<asp:table>) dynamically generated new rows containing two columns, one with a display name and the other a textbox for the user to enter a value.When I want to retrieve those rows from the code, I notice that there are no rows created in the tableList<BLL.Producto> productos = new List<BLL.Producto>(); for (int i = 0; i <= TablaVenta.Rows.Count; i++) { TableRow tr = new TableRow(); tr = (TableRow)TablaVenta.Rows[i]; for (int c = 1; c <= tr.Cells.Count; i++) { BLL.Producto unProd = new BLL.Producto(); unProd.Nombre = TablaVenta.Rows[i].Cells[c].Text;   Error: Specified argument was out of the range of valid values.Parameter name: index Do you know, what i can will do? Thankss

How to get column value difference of rows in same table

Dear all, I need a TSQL statement to find the difference of values of two rows in the same table, by taking into consideration some conditions. I have the following rowss in a table named table1 dbname  sqlinst     size1   ddate sqldb1    inst1        200    1/1/2009 sqldb1    inst1        250    1/1/2010 sqldb1    inst1        170    1/1/2008 sqldb2    inst2        300    1/1/2009 sqldb2    inst2        340    1/1/2010 I need to find the difference between size1 values, for columns where their dbname and sqlinst are the same. I also need to define in TSQL that the ddate of row from where I subtract (size1) from is 1/1/2010 and that the ddate of the row I subtract (size1) is 1/1/2009 (e.g. in the above example: for sqldb1 inst1, I need to perform 250-200 and ignore 170, and for sqldb2 inst2  340-300). Please let me know if you have a solution for this. A million thanks!

How to declare a table variable in SSIS and then insert rows into it

Hello everyone,   I'll try to explain my problem as clearly as I can: 1)I have an Execute SQL Task that's inside a Foreach Loop Container. 2)Inside the Execute SQL Task, I have an int OUTPUT column. 3)With each iteration, I need to insert the data from the INT output colum into a table variable. 4)After the Foreach Loop finishes the iterations, I need to use the table variable to create a report based on the data inside.   My question is the following: How can I declare a table variable so that I can do all of the above?   Thank you, CostinP

Delete objects from table using another table to select rows - help needed

I have one table named 'dbo.ac_Products'Within this table there is a column named 'ProductId'There is also another table named 'dbo.ac_CatalogNodes'Within this table there is a column named 'CatalogNodeId'and a column named 'CatalogNodeType'I need to delete all the rows from 'dbo.ac_Products' and 'dbo.ac_CatalogNodes' where 'ProductId' = 'CatalogNodeId' and 'CatalogNodeType' = 1Any help would be greatly appreciated!

Infopath 2007 Repeating Table - Multiple Value Column Text - Hiding Rows based on Column text values

Infopath 2007 browser based form Full Trust Example: I have a repeating table (FruitChoice) that has multiple columns. Both drop down list point to sharepoint list data sources. Choose your tree ft. drop down list – 6Ft Choose your Department drop down list - 103 This repeating table is conditional on the drop down values. This works great. Trees     Fruit       Cost   Date Ordered    Date Delivery Department 6Ft        Peaches                                                        103 3Ft        Apples                                                          102 3Ft        Peaches         &

how to get the distinct of rows in a table with all collumns displayed

Hi all,   i have a table SBTRAN i have to select distinct rows of that table in which it should elminate the duplicate rows depending on the accno that is ACCNO should be unique my table has the collumns that look like below SB_TYPE   ACCNO  NAME   ACC_TYPE   GENDER   ADDRESS   PINCODE   i should get the distinct rows in which ACCNO should not have duplicate valuesother collumns can have duplicate values. please help me out thanks in advance   Regards Sunil Yoganna  

Max number of rows in a table

Hey I'm doing a bit of research on which database to use for a new project. And one of the factors I have to take into consideration, is that we will have some tables with a high amount of records. I originally intended to use mysql (because it's free), but I have found that it has a cap of 4.2 billion rows per table. And it is a possibility that we will exceed that number in a few of our tables. So far, from looking around here, and on the web, I've only be able to find, that is no such cap on tables in mssql, and that table sizes is only limited by available storage. The thing is, 99% of the info I found regarding tablesize limits in mysql, also stated that it was only limited by the storage size (4gb, not all available). I had to look very thouroughly to find that last 1% where someone mentioned the 4.2 bil. upper limit. I hope someone here can confirm that, there is indeed no limit on the number of records in a single table in mssql, no hidden cap, however unlikely to be an issue. I find, that there's a ton reasons to pick mssql over mysql. But this factor will be a big selling point, in convincing the higher-ups that mssql is the better choice for my project.

How to dynamically add table rows within update panel ?

Hi, In my webform, i have 3-4 textbox, on there textchange event i have to fetch data from database and put it on the form. I have taken another html table (with runat="server")  below textbox and  and in textchange event created a new <tr>, <td> and simply added contents in <td>, then finally added <tr> in the table. This is done in UpdatePanel. When i enter something in textbox1 data is added in that table,that's fine. But when i enter something in 2nd textbox the previous data is overridden. My requirement is that if 2nd textbox's text changes than another row with appropiate data should be added, i.e., now two rows. Silimarly if 3rd ,4th textbox data changes then subsequently 3 or 4 rows should be displayed. What should i do ?

DetialsView where each row has multiple detail rows from another table


Hi everyone,

I have a <asp:DetailsView> based on a table that has a details table, like so:

DB1 --> TABLE1 --> Customers: ID, name, street, mail

DB1 --> TABLE2 --> SitesToCustomers:  CustomerID, SiteID

Problem One: I need my details view to show / edit both values from customer table and SitesToCustomers table, How do i do that?

Problem two: The site name (oppesed to its code that is saved at SitesToCustomers) is found on another DataBase in this table:

DB2 --> TABLE1 --> Sites: ID, SiteName

How can make the data source show site names according to their id's from SitesToCustomers table?

all of the code behind is c#.

Any help will be much appreciated,

and please use code examples, i'm pretty new to asp.net / c#.

InfoPath Forms : Adding rows dynamically from a SQL table along with a 'Delete' button per row


My requirement is something like this:

In a Task Approval form, I want to have a view which shows all the rows in a particular SQL table (in a infopath repeating table?). Along with each row, there should also be a button, on clicking which the row should disappear from the infopath view table. Do you think InfoPath can handle all this? :) 

To summarize:

1. How do I add rows to a table dynamically?

2. Per row, how do I create a button dynamically?

3. How do I remove the row from the view when the button is clicked?

Conditional insert: If select return rows, insert rows to table otherwise insert specific row indica

This is what I have

Insert into ReportDetail( Partcipantid, Reportid)  

select distinct ParticipantID , 9 from OpenCredit

      except select ParticipantID, 9 from StoreCredit where Closed = 0

 Issue is that when above select statement returns no row, it seems like no record is

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend