column

Subsonic 3.0 - Prefix all column names

Hi, Problem. Subsonic 3 build against an existing, medium sized DB Lots of columns, some badly named so conflicting against reserved words, Subsonic functions etc. Want to be able to prefix all column names (not tables) with something, eg. 'c' for column so that the appear together in intellisense drop down and solve naming issues in...

MS Charts column graph - left aligned with NO lines

Hi. I am working with MS Charts and can produce typical looking charts.... But I need to produce a single column chart (saved as .jpeg) with these oddities: it needs to be in the leftmost position in the chartarea the column needs a title above it it needs a text area to the right it no lines at all: no grids, axis, nada.. (MajorGrid/...

Blueprint: Push column partially in to another column

Is it possible using Blueprint's push-x and pull-x classes to create an overlapping column that is half in one column and half in another column? Here's an example: +-------+-----+-------+ | | | | | 1 | 2 | 3 | | +-----+ | | | | | | | +----------+----------+ I ...

How can I show/hide a column in Windows Explorer programmatically?

Or, failing that, how can I add an entry to the context menu that pops up when you right-click the header column (from the "More..." list). I've been digging around the Shell API docs for a while and I can't seem to find anything. This comes up in at least two situations I've run into: At my workplace, we routinely inspect the "Produ...

Showing column numbers in Dreamweaver?

I wasn't quite sure if this would go on SU or here, but I figured people here were more likely to have an answer. Everyone knows the 80 character column rule, right? I'd like to be able to follow this, but I use Dreamweaver, and until this point I have not been able to find a way to turn on a display for the current column in the text I...

Maximum number of columns in a table

Problem1: What is the maximum no of columns we can have in a table Problem2: What is the maximum no of columns we should have in a table ...

Fastest way to change column data type in SQL Server

In SQL Server 2008, I have got a table of around 3 million records. I want to change the type of one of its columns from float to int. But seems it will take a lot of time. Is there any way to accomplish this very fast? ...

How to define a column that can automate capitalizing?

So that when you insert 'abc',it'll be converted to 'ABC' automatically. I'm using MySQL,is it possible? ...

SQL database design suggestion : Naming a database table

I have to create a table and store Active Directory SIDs representing an User or a Group. How would you name the category representing both an User and a Group ? Edit 1. Table will contain four columns : ID ( PK ), SID's Name, SID's value and another column for SID's Type ( 0 for User, 1 for Group ). Please suggest the table name...

WPF Grid Show/Hide Column

I have the following layout in my grid <Grid> <Grid.RowDefinitions > <RowDefinition Height="50" /> <RowDefinition /> </Grid.RowDefinitions> <Button Click="Button_Click" Grid.Row="0" Width="50" Grid.Column="2" Content="Test" /> <Grid Grid.Row="1"> <Grid.ColumnDefinitions> <ColumnDefinition Wid...

Modify a Column's Type in sqlite3

Hey guys, I'm pretty new to sqlite 3 and just now I had to add a column to an existing table I had. I went about doing that by doing: ALTER TABLE thetable ADD COLUMN category;. Of course, I forgot to specify that column's type. The first thing I was thinking about doing was dropping that column and then re-adding it. However, it seems t...

How to implement "Hide/Show Column" feature of Excel in C# GridView

I want to create a "Hide/Show Column" function for a GridView. Scenario: When user right-clicks to the header of a column and select "Hide", all the selected column will be hidden. Status: This is easy by setting "Visible" property or setting the Width to 0. But I want to imitate the effects done by Excel when a column is hidden. The ...

jquery highlight row based on specific column's value

i know there are many tangential posts on this topic (I've read them all) but i can't seem to put it all together. I would like to highlight all rows whose 2nd column contains the '-' character. in case its relevant: 1) the second column's header (th) is "Due In" 2) the values in the second column are strings 3) there isn't a specific...

Excel VBA - Insert a Row to a Specific Set of Columns

Hi all, I'm working on a spreadsheet to act as a master copy for some important information that will be kept track of for a project. On the main sheet I have a table for notes and a table for contacts set up seperated by several columns and some VB code to insert new notes or new contacts. However, when I insert a new note I want it to...

WPF Toolkit DataGrid: how to get ColumnHeader width to be the same as GridColumn width

For my WPF Toolkit DataGrid I use the following custom column header style: <Style x:Name="ColumnStyle" x:Key="ColumnHeaderStyle" TargetType="my:DataGridColumnHeader"> <Setter Property="ContentTemplate"> <Setter.Value> <DataTemplate> <StackPanel Orientation="Vertical" HorizontalAlignment="Stretch"...

Sharepoint: rename column (field) with C#

I want to rename a column (field) of some list with C#. How do I do this? Resetting 'Title' property or something else doesn't work. ...

Set cell width of a Datagrid in a c# windows application

I have a datagrid in my c# windows application and my code is private void BindGrid(SmsPdu pdu) { DataRow dr=dt.NewRow(); SmsDeliverPdu data = (SmsDeliverPdu)pdu; dr[0]=data.OriginatingAddress.ToString(); dr[1]=data.SCTimestamp.ToString(); dr[2]=data.UserDataText; dt.Rows.Add(dr); dataGrid1.DataSource=dt; } An...

Dynamically assign a column width to a winforms datagrid?

I ve created columns of my datagrid using this, private void Receive_Load(object sender, System.EventArgs e) { dt.Columns.Add("Sender",typeof(string)); dt.Columns.Add("Time",typeof(string)); dt.Columns.Add("Message",typeof(string)); } How can i dynamically assign a column width to a winforms datagri...

Is there a module which gives me an output of two colums ( or more ) on STDOUT?

Hello, is there a module which gives me an output of two columns ( or more ) on STDOUT? #!/usr/bin/env perl use warnings; use strict; printf "%0.3d\n", $_ for 1 .. 100; I'd like to have 1-50 in the first column and 51-100 in the second. ...

Multiple row INSERT into SQL, from text file

Hi, I have a table with 3 columns, 2 of which are auto-incrementing. I have a text file with various content that I would like to insert into the 3rd column. In that text, values are separated as such: "value1", "value2", "value3", "etc", How would I go about inserting all those values into a specific column, while being able to use th...