I have/had a problem with field values from existing InfoPath forms not displaying in Sharepoint form library columns (columns are checked as visible). I fixed the error which was caused by a mis-calculation in the errant field/column. The form fields value now appears but only in a newly created form, the old forms corrected value does...
If I include an Environment.NewLine in the Header text of a DataGrid column, will the header row increase its size appropriately, or is there another property that needs to be configured for this to be achieved? ...
I'd like to display a list of items in multiple columns without having to specify the number of columns, and just let the browser add more columns so that all items fit. I tried to adapt this article, but the items are just listed as a long, one-column list: <head> <STYLE type="text/css"> ul.columns { float: left...
I'm using a chart and column series in the WPF toolkit to display a value for each month of the year. Everything is working good and the chart loads except it looks like junk since the series labels on the X axis are all overlapping and I cannot figure out how to get the sizing correct. When using the lineseries the chart seems to size...
If you try to create a TEXT column on a table, and give it a default value in MySQL, you get an error (on Windows at least). I cannot see any reason why a text column should not have a default value. No explanation is given by the MySQL documentation. It seems illogical to me (and somewhat frustrating, as I want a default value!). Anybod...
When a user tries to search for people on our system, we've noticed that they often type a full name for their search. How can we enable full name searching on our database when first name and last name are stored in different columns? ...
How should columns in a database table that have a PK/FK relationship be named? Should their names contain a reference to the table they are in? Consider the examples below. Each employee has an ID which is a FK in the salaries table. /* Employees Option 1*/ CREATE TABLE dbo.Employees ( EmployeeID INT PRIMARY KEY, EmployeeFir...
Hi Everybody, Again a c# question I cant't seem to figure out: I have a datagridview on my form. In Visual Studio design mode, I enter 4 columns: refernce, country, name & city. After a searchform is filled in, I try to refresh the datasource: A custom class fetches all the data from the selected table and fills the datagridview. The p...
Hello. I have simple problem. In my table have columns ID, NAME, CONTENT, TIMESTAMP. If i use session.query(table).all() result is array of table class objects. So i have no problem with modify one or more objects and update, or use this objects in associations. But i need only columns ID and NAME. If use session.query(table.id, table.n...
I have 3 elements I want to arrange into columns. I want the left and right elements to stay fixed widths and align to their respective edges of the page, but the middle element I need to fill in the space between them. How do I do this? ...
Can anybody reccomend a way of generating a multi column RTF document with python, i was going to use PyRTF but i cant find any documentation on how to set up columns. i think i might need to edit the modules source any reccomendations? ...
Hi, I am in need of layout with resizable columns. I have a panel with 3 grid panels inside, now I am using hbox layout in the outer panel to organize them and this is ok, but I want to have a separator, like in the border layout, to resize the columns. how is it possible? ...
I have a Microsoft Access database that I connect to with the Jet Database Engine, using VB.NET. I want to programmatically get all of the column names for a particular table. I would like to do the equivalent of this MS SQL statement: SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = 'TableName' Is this possible...
So my data sample is in the following format. jgi|Xentr4|100164|gw1.1441.2.1 scaffold_1441 18150 18354 jgi|Xentr4|100164|gw1.1441.2.1 scaffold_1441 19856 19974 jgi|Xentr4|100164|gw1.1441.2.1 scaffold_1441 21455 21638 jgi|Xentr4|100164|gw1.1441.2.1 scaffold_1441 21727 21897 jgi|Xentr4|100164|gw1.1441.2.1 scaffold_144...
I have a data frame that I am outputting to MS Word. Lets say I'm trying to output the data frame mtcars, then using the R2wd package, I get: #install.packages("R2wd") require(R2wd) wdGet() wdTable(mtcars) '>ncol(mtcars) 11 however a count shows that there are actually 12 columns. R doesn't include the model of car. I have a...
Hi, I'd like to show my search results separated in many columns, that is, in separate lists like: Item 1 Item 5 Item 9 Item 2 Item 6 Item 10 Item 3 Item 7 Item 4 Item 8 Following whatever way to indicate how many items should be shown per list before creating a new one. I'm not clear about the formatItem(...
How do you get a list of the input parameters for a stored procedure using metadata in SQL Server 2005? I want to do a SELECt on it and then iterate through the variable names. ...
Hello, I have a csv file, which consists of many fields (columns). However, I would like to import some columns while not others. Every time I am importing csv files with same structure and selecting columns one by one takes much time. How to automatically select the columns imported? DO I need a template or VBA code? (I am lack of pro...
Lets say you have a relational DB table like INVENTORY_ITEM. It's generic in the sense that anything that's in inventory needs a record here. Now lets say there are tons of different types of inventory and each different type might have unique fields that they want to keep track of (e.g. forks might track the number of tines, but refri...
private void BindFields() { DataTable table = Globals.ConvertDataReaderToDataTable(DataProvider.GetFields()); _fieldCount = table.Rows.Count; dataGrid.DataSource = table; dataGrid.DataBind(); } The ConvertDataReaderToDataTable, provided by the DotNetNuke platform, throws this exception : A column named [column name...