columns

How to change DataTable colums order

Hi all, How to change Datatable columns oder in c#. example: am created sql table type order is Qty,Unit,Id but in program DataTable order is Id,Qty,Unit. In code Behind am directly pass DataTable to sql table type so the table order is different. DataTable columns are :`Id,Qty,Unit.` i want this to be :`Qty,Unit,Id` please help...

Splitting address, city, state, and zip, lacking delimiters, in excel

Hey all, I have an excel spreadsheet that contains entire addresses packed in a single cell without delimiters. The addresses look like this: 2701 NW 64TH TER MARGATE FL 33063-1703 901 NE 8 ST HALLANDALE BEACH FL 33009-2626 1840 DEWEY ST UNIT 305 HOLLYWOOD FL 33020 3049 NE 4 AVE WILTON MANORS FL 33334-2047 650 NE 56 CT OAKLAND PARK ...

Stored Procedure to query value of one column in First Table to Match any value in Second Table?

I wrote this but it only returns exact matchs such as 'Carburetor' not 'Brand X Carburetor' Any help would be greatly appreciated! SELECT [Col] FROM a WHERE ([Col]) IN ( SELECT [col] FROM B ) UNION ALL SELECT Distinct [col] FROM B WHERE ([col]) IN ( Select [col] FROM A ) ...

mysql aggregate multiple columns by hour.

Hi all, Had a quick look through and couldn't find my question again. So I'm hoping someone here can help. I have a large table with a similar structure to the below. DateTime | InboundUserID | OutboundUserID | CustomerUserID | Cost | Mins | Account Number I'm trying to group the above data into hourly chunks and store the result in a...

How to like two columns in one SQL statement

Table A Column aa ----- jack jim alan Table B Column bb ----- jacky jimmy william output is: ----- jack jacky jim jimmy because aa's value is bb's substring. How to write this SQL? ...

Ajax auto form submit

Hi, Does anyone know how to automatically submit a form via AJAX, without, having to explicitly click on the submit button. For example, say I have the following form: <form id="form1" method="post" action="" name="form1"> Rows: <input type="text" name="rows" id="rows" /> <br/ > Columns<input type="text" name="columns" id="columns"> ...

Assigning Each Primary Key Its Own Column

//Define your database settings. define('DB_HOST', ''); define('DB_PORT', ''); define('DB_USER', ''); define('DB_PASS', ''); define('DB_NAME', ''); $database = new MySQLi(DB_HOST, DB_USER, DB_PASS, DB_NAME, DB_PORT); // Escape the id, incase it's a malicious input. $id = $database->real_escape_string($id); $sql = 'SELECT Brand.brand, ...

Breaking data into multiple display colums with Django

Overlap in terminology makes search for answers difficult for this one. I'm looking for advice on the best way to implement a multiple-column display of my QuerySet that fills each column top to bottom over X columns. Meaning that the number of items in each column equals the QuerySet count divided by X (number of columns). Using Offs...

How do I use rows-as-fields in a SQL database

I've got a SQL related question regarding a general database structure that seems to be somewhat common. I came up with it one day while trying to solve a problem and (later on) I've seen other people do the same thing (or something remarkably similar) so I think the structure itself makes sense. I just have trouble trying to form cert...

what is the use of related fields in openerp ?

I want to know the something about related fields, how it can be helped, and for which kind of scenario I should use fields.related, if anybody can provide small example for real use of fields.related it would be great Thanks in advance....... ...

flex datagrid columns drag

I have a data grid where users can drag columns and reposition them. But there is a strange requirement that some columns should not be draged to the left of some other column. eg, assume the columns are : name, price , start date, end date, The end date should not be dragged and placed before the start date. i.e. The user can have ...

Stretching 4 col template with two fixed columns in the middle and custom SOC. Possible?

Hello :) The html code source order should look like this: <body> <div>col2</div> <div>col3</div> <div>col1</div> <div>col4</div> </body> and should look like this: <----------------------100%-----------------------> +--------+-------------------+-----------+--------+ | col1 | col2 | col3 | col4 ...

[PostgreSQL] How to select distinct from multiple columns

Hi I'm sure there's query for this kind of operation, but I just can't seem to get it. I have a table like this: product_id | saved_by | deleted_by | accepted_by | published_by -----------+----------+------------+-------------+------------- 1 | user1 | | user1 | -----------+----------+------------+---------...

using R - delete rows when a value repeated less than 3 times

Hi I have a data.frame with 10 rows and 3 columns a b c 1 1 201 1 2 2 202 1 3 3 203 1 4 4 204 1 5 5 205 4 6 6 206 5 7 7 207 4 8 8 208 4 9 9 209 8 10 10 210 5 I want to delete all rows where the same value in the column "c" repeated less than 3 times. In this example I want to remove rows 6, 9 and 10. (my real d...

Splitting up content that will be displayed over multiple columns

Scenario: You have a CMS where an user is able to determine what content will be displayed. The content consists of multiple colums with links underneath them. It looks something like this: Column name link1 link2 link3 link4 link5 link6 liiiiiiiiiiiiiiiiiink7 link8 liiiink9 liiiiiiink10 Column name2 link1 link2 link3 link4 link5 link...

GridView Column AutoSize BestFit

I have a GridView that I render to html and export that to MS Word, Excel , PDF etc. I need to programmatically make column best fit and autosize them to fit their inner text. Is there is any way to do that? ...

How can one dynamically modify row and column definitions of a WPF grid?

I have two dimensional data with varying number of rows and columns and must display it to the user for editing. The format of the data itself is essentially described by a list of row and column descriptors with a header text for each row or column. I derived a control from Grid that has two properties for the row and column descriptor...

Remove spacing between CSS3 columns

I'm trying to get an effect where it looks like: C---------------------------------------) | Address 1 | Phone Numbers | | Address 2 | Times place is open | (---------------------------------------) But the spacing with the following makes it (-------------------------------------------) | Address 1 | Phon...

Why does wrapping div not expand around floating elements?

I have two columns in a center column. (They are all div tags.) When I set the inner divs to float:left, the outer div does not wrap around the inner divs. Why, and how do I fix that? ...

What is the better way to store an arbitrary key:value array in mongodb

I have an array of key values {val1: [{gender:male}, {age:23}, {favorite-color:red}] } The thing about this array is that in no way is it structured and in no way am I ever guaranteed to see the same key value again. For example I could see the following for val2 {val2: [{sex:male}, {hair-color:red}, {height:6'1"}] } My quest...