I am totally new to VBA (aside from recording and running manually) so was hoping somebody could help me with designing this. I have a worksheet with unspecified # of rows per unique ID (column A), based on date and type. : A B C D 1 12Jan2010 type A Person1 1 16Jan2010 type B Person1 ...
I have a gridview that I need to get the width of columns for after the gridview is databound. I have to have AutoGenerateColumns=true because the columns for the datatable that the gridview is bound to is not going to be fixed. The problem I'm having is the gridview columns collection is not populated when AutoGenerateColumns is true....
Hello all! Say I have a table like that: |x1|y1| |0 |1 | |2 |4 | |3 |2 | I know I can do something like that: SELECT a.x1 AS .., a.y1 AS .., b.x1 AS .., b.y1 AS .., c.x1 AS .., c.y1 AS .., d.x1 AS .., d.y1 AS .. FROM xytable a, xytable b, xytable c, xytable d WHERE ... In my result table, however, I wo...
I have a Listbox in to which I am binding the data coming from a DataTable I am using VisualStudio 2003, .net 1.1 For Each dr As DataRow In dt.Rows Dim li As New ListItem(dr("BIPAD").ToString().PadRight(25, Microsoft.VisualBasic.ChrW((160))) + dr("TITLENAME").ToString()) lbMagTilteByCategory.Items.Add(li) ...
I'd like to create columns of links in an MVC2 view, like this: a g m b h n c i o d j e k f l I could build a table row by row, doing some math to determine which items should be in the row, or I could build a table per column, but I'm hoping there's a simpler way to do this. Is there? ...
Hi, I'm using the jQuery Columnizer plugin, and I'm running into a weird problem. Using 3 columns, I columnize content from a hidden <div> into a target <div>. It distributes only one paragraph to each of the first two columns and then puts all the remaining paragraphs into the last column. The strange thing is that it auto-corrects it...
Disclaimer: I'm an SQL newb, just discovering the great possibilities of sqlite embedded in applications. I'm designing a small database for an application that primarily handles data storage for plotting. Say I have several instrument data tables (one for each type of instrument) with a column for each data field, such as pressure, ...
Trying to get columns to line up in Telerik report (Q2 - 2009.) The report was auto-generated by the wizard and the width was increased. I cannot figure out how to get the columns to line up properly. They are rendering all out of whack. I've attached a screenshot to demonstrate. ...
In an Access app, I've linked to MySQL tables. I have also linked to a View. A couple of the View columns have been mapped by Access as Memo, and one as OLE Object. They should be Text(255). Is there anyway that I can fix this? MTIA ...
In an Access app, I've linked to MySQL tables. I have also linked to a View. A couple of the View columns have been mapped by Access as Memo, and one as OLE Object(!). They should be Text(255). Is there any way that I can define the columns in a View? MTIA ...
I have two columns in different product tables. tblproduct1.partno is an old product list tblproduct2.partno2 is a new one Both partno columns should have identical model numbers but they don't. When executing the below query, I get about 300 model numbers that don't match when comparing counts from both tables. tblproduct2 has 1955...
I work on an accounting project in .NET. I want to sum all transaction and its opening balances. I use summary but it Allows only one column.. ...
I'm new to XML. What I have is a load of XML from Adobe Illustrator which I'm trying to map excel data onto. I have sequences in the original data which look like this <Market_Pie> <datanumDataColumns="5"> <values> <row> <valuekey="name"></value> <value>503.931</value> <value>268.301</value> <value>285.561</value> <value>152.037</value>...
I am looking for a fast sql sentence for determine when a field exist or not in a table . actually i am using this sentence Select 1 from dual where exists (select 1 from all_tab_columns where table_name = 'MYTABLE' and column_name = 'MYCOLUMN') I think there must be...
Visual Studio 2008, .Net 3.5 I am populating a ListView with 100+ items, about 10 columns each. I find that after some horizontal and vertical scrolling my column headers get corrupted with snippets of data from the items. For example, a ListView with a column "Animals" with items that have "Dog", "Cat", "Pig", "Horse" in that column, ...
How to get the string-name of a field from a table on subsonic 3? On subsonic version 2 I use the TableName.columns.Field Also in subsonic 2 I have the opportunity to get the max length of a string field. How can I do that on subsonic 3 ? Thank you in advanced. ...
Hi, I am able to read the excel sheet from c# + asp.net application with MS interop Excel services (namespace). Data retrieving fine. But my excel sheet have a colummn whose formate type is of hh:mm:ss type. while retriving data i found value of this column fetching as General column getting some 0.45645646... like value. What should thi...
hi, I need to build a dynamic multiple columns view for the content of my website (I'm using drupal as CMS, if can be useful info), with the following features 1) the columns width is fixed (OK) 2) the columns number depends on the window width (OK) 3) the elements has not fixed height (important, not fixed yet) 4) the content shoul...
Hi all, I'm trying to create a website and it's design is forcing me to use multiple backgrounds. I'm talking about a technique that looks like this <div id="left"> <div id="left_1"> <div id="left_2"> </div> </div> </div> #left{ width:235px; margin:0; padding:0; float:left; bac...
Howdy using c#, vs2008 winforms I have a datagridview that i am programtically binding to a binding source, that is bound to a dataset with 1 table. After filling the dataset using the sqlAdaptor, i want to add a new column to the dataset, and in the new column populate it with a result derived from a call to a custom method in the fo...