I have a database that has four columns like this level_1, level_2, level_3, level_4 There are also id, name, etc., but only these four are the ones that matter to me at the moment. I need to know which column, by columnname, has the value 'BOSS'. For example, level_2 may have the value BOSS. I need to know that one of the four colu...
Hi, how can I define different ContextMenus for each column in the DataGrid (Microsoft's grid)? I found out that the grid provides a ContextMenu attribute, but i want different context menu items for the columns, not the same ContextMenu for the whole grid.. Thanks for any help on this! Edit: Thanks for your answer! I tried to listen...
I have 12 columns separated by a tab. How can I join them side-by-side? [Added] You can also tell me other methods as AWK: the faster the better. ...
I have a temp table that has numeric integer values in one column. I want to either replace the integer values with character values based on some criteria or I want to add another column of character type that automatically inserts values into itself based on some criteria. If x <= 1, change to "SP" or make new column and store "SP" i...
I have a gridview whose datasource is an oracle database. I want to know how to be able to change column width (in the gridview) when it is being displayed in the web browser. Thank you ...
I'm trying to hide a column based a value I get from my object. Following is a bit of my playing around. Note: Binding="{Binding Path=SelectedShortName}" returns a value. I want to hide the column when that value is equal to something. I've tried a variety of ways, but it just seems like i'm butting my head. Any input appreciated. Ta ...
I am using SQL Server for the first time and I see that a column property is called Is Identity. What doeds this mean? What are the advantages of marking a column property as Is Identity = Yes ? Thanks in advance. ...
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. ...
There seems to be a bug with columns in SharePoint MOSS 2007. It allows you to add a new column say 'Team'. When you add this it stores the internal name as 'Team' which makes sense. The business then decide that 'Team' should be called 'Workstream', so you rename it as requested. The internal name remains 'Team' for this column in the...
I am doing a simple SELECT statement in an Oracle DB and need to select the columns in a somewhat-specific order. Example: Table A has 100 attributes, one of which is "chapter" that occurs somewhere in the order of columns in the table. I need to select the data with "chapter" first and the remaining columns after in no particular order...
I am looking to retrieve a list of columns in a table. The database is the latest release of SQLite (3.6, I believe). I am looking for code that does this with a SQL query. Extra bonus points for metadata related to the columns (e.g. length, data type, etc...) ...
Hello, I've come to StackOverflow before with this quest: http://stackoverflow.com/questions/547040/ms-sql2005-query-stored-proc-results-to-text-using-sqlcommand-or-such I was told to build the string myself so that I get the same results as from SQL Managment Studio's Results To Text (Cntrl + T) I have now run into a problem, how ...
The idea is simple - I want all Command columns in my GridViews to have a specific button image for, say, the "Delete" button. Sounds like a job for skins, but I cannot find the right syntax for that... ...
Here's the thing: a sortable JTable backed by JTableModel with an array of objects that populate rows (one object = one row). Need to delete rows. Without sorting, deleting an object is simple: get selected row index, delete array object under the same index. With sorting, though, row indexes mess up in a sense that they no longer match...
I want to add a new column to a table in MySQL database that should get the value of another column in the same table. Is this possible? If so, how do you do it? Thanks! ...
Say I defined a char column Type. I want to strict its value to say for example (Black, White, Red, Blue) Only... How can I do that?? All i know, this is easy in Access :P ...
Hi! I am trying to match column values returned, but values are returned as a result of pattern matching: select app.employees.id, app.employees.name, app.employees.current_bp, app.designation.designation from app.employees, app.designation where app.employees.id like 'khsn?' = app.designation.desig_id like 'khsn?'; As you can see,...
Hi All, I have a XL source file, the first column contains the name, 199001,19902.....,199012, In SSIS package using XL source if click the 1st column contains headings it automatically covert my heading as name,F2,F3.....F13. But i need as it is like Name,199001,19902,.....,199012 as a heading than i am using unpivot transformation ...
I would like to generate view CUSTOMER, CUSTOMER_ID, PRODUCTS ABC INC 1 A=XYX, B=ZZZ DEF CO 2 A=XYX, B=ZZZ, C=WWW GHI LLC 3 B=ZYX Would like the view to be something like CUSTOMER, CUSTOMER_ID, A B C ABC INC 1 XYX ZZZ DEF CO 2 XYX ZZZ WWW GHI LLC 3 ...
I want to save my dates in sql2005 as dates (without hour minutes and seconds). I want to do this because the between function isn't always correct if the hours, minutes and seconds are filled in. but neither datetime nor smalldatetime allows this, in 2008 you have the Date column which can do this. I've also found this question which ...