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...
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...
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 ...
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 INNER JOIN ...
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! ...
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...
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 ...
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 C and D. ...
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 course number 11. Each row of data is for o...
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...
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...
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...
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...
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...
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...
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...
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-...