row

SQL 2005 copy single column between databases

Hi, 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 copy the entire table. This causes error...

Define small row height in Reporting Services 2005

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 padding, lineHeight, font size, etc... An...

Remove Last Row Databound DataGridView C#

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 reason, when removing whatever happens to be ...

How to change the backcolor of a row in a DataGridView based on the value of a cell?

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). ...

Rows in their own columns depending on their value

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 INNER JOIN ...

What is the best way to insert into and update a single row table in MySQL?

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! ...

Table row height in Firefox

Hi, 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 for my footer is being rendered diffe...

c# gridview row click

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)); To prevent error messages i have this code: protected ...

WPF : How can I get the height of a listview row

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 ...

SQL Convert column to row

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 C and D. ...

wxPython wxListCtrl selected row color

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? ...

Copy data from one existing row to another existing row in SQL?

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 course number 11. Each row of data is for o...

Replace a gridview row while rendering

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. Is there a way to override the rendering...

Selecting whole row in alternating colored rows gridview

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 the other 2 are white. If I click on r...

Add Gridview Row AFTER Header

Hi, 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 2 does not work as expected. I can add th...

Jquery Hidden Field in Table

Hi all, I was wondering if anyone knew of a way to access a hidden field (by client id) within a table row using jquery. $("#tblOne").find("tr").click(function() { var worker = $(this).find(":input").val(); }); I find that the above works for a row that has only one input, but i need some help figuring out a way t...

Calling Dibs on a table row

The problem I have is this: I have a table (just an example) with the following fields: ID int Value int I have a method called IncreaseByFive() which does the following: method IncreaseByFive(int ID) { int value = GetValueFromDB(ID); value = value + 5; SaveValueToDB(value, ID); } What I want to avoid is the fo...

Adding row to binded dataview

I am in need to add row to the dataview My code is as follows DataGridViewSelectedRowCollection row = dataGridView1.SelectedRows; for (int o = 0; o < row.Count; o++) { DataRow myRow; myRow = (row[o].DataBoundItem as DataRowView).Row; DataRowView drv = dv2.AddNew(); drv = row[o].DataBoundItem as DataRowView; } It add...

Setting background color for datagrid row in Adobe Flex

Hi Folks, I need to programmatically change the background color for a single row in a datagrid in Flex. I've scoured the Net and found reference to "dg.setPropertiesAt," which is not a supported method (according to the compiler). Also, there are suggestions to extend the dg's "drawRowBackground" method but I need to set the backgrou...

[Beginner] JQuery reusable functions

Completely new to JQuery so I am learning everyday. One thing I noticed is how easy it is, you can just write $('div#test).remove(); But I am looking for an example on how to reuse some code, eg.: function RemoveTableRow(row, id) { $(row).remove(); // id should be used for ajax call } And then add a 'onclick' on my anchor-...