Browsing Questions About row (1)

I'm still fairly new to T-SQL and SQL 2005. I need to import a column of integers from a table in database1 to a identical table (only missing the column I need) in database2. Both are sql 2005 databases. I've tried the built in import command in Server Management Studio but it's forcing me to cop…

I want to specify a small row height in a Reporting Services report of about 3pt. However, while the report looks ok in the previewer, once deployed, the row height resets to the standard row height. I've tried adjusting the "CanGrow" and "CanShrink" settings as well as playing around with the …

Thanks in advance for any help. I'm using VS 2008/C# and binding a local List of helper classes as the DataSource for a DataGridView control. Calling the Remove() method on my List of helper classes fires the CellFormatting event of the DataGridView, which makes sense (a bit). But for some reas…

Say I have a DataGridView which shows the content of a DataTable. I want to be able to set the backcolor of a row based on the value of a cell in this row. Note that the cell in question is in a column which is not displayed in the DataGridView (Visible=False).

I have a select query that currently produces the following results: Description Code Price Product 1 A 5 Product 1 B 4 Product 1 C 2 Using the following query: SELECT DISTINCT np.Description, p.promotionalCode, p.Price FROM Price AS p…

I have a MySQL table that will only have one row. What should my statement be for the first time I insert to this row, and for subsequent updates? I tried an insert where the primary key equals 1, but this doesn't account for the first time around when no row exists yet. Thanks!

Due to current limitations on getting DIV tags to work well across browser platforms for the particular liquid layout I desire, I have opted to use a combination of Tables and DIVs for layout. That being said, a couple of issues remain. The FIRST issue is that in Firefox, my table row height f…

When I click on a row in my GridView, I want to go to a other page with the ID I get from the database. In my RowCreated event I have the following line: e.Row.Attributes.Add( "onClick", ClientScript.GetPostBackClientHyperlink( this.grdSearchResults, "Select$" + e.Row.RowIndex)); …

I need to know how high (in pixels) a row in a listview control will be, and can't find any way of getting it. Any ideas? The row just contains text, nothing fancy

My table has the following columns: A | B | C | D | E | F I want to displays this as follow: MyColumn | MyColumn2 A | B C | D E | F As you can see i want to display the columns as pairs with a custom column name. The pairs are Column A and B, column C and D and column …

I want to have certain rows selected color be red instead of the standard color (blue on windows) so that I can indicate status. Anyone know if this is possible in wxPython?

OK so I suck at SQL and I always have to ask for help, not sure what my disconnect is because I don't have any problem with programming C like languages, here is my challenge: I have a table full of tracking data for as specific course, course number 6. Now I have added new tracking data for…

I've got a datatable bound to a gridview and in the RowDataBound event I check the values of the fields to determine what to show in the gridview row. However, in some cases I want to show a row with just a single label that spans all columns, when the data values in the row can't be calculated…

I have a Gridview with alternating row colors and want to highlight a row when its clicked anywhere on that row. Unfortunaly, the code that I found and am using applies the darker color shade to the previously clicked row. For example, If out of a 4 row gridview, 2 and 4 are shaded silver, while t…

i'm trying to add a new headerrow to a Gridview. This row should appear below the original headerrow. As far as I know I have two events to choose from: 1.) Gridview_RowDataBound 2.) Gridview_RowCreated Option 1 is not an option as the grid is not binding the data on each postback. Option…