Search Results

Search found 7127 results on 286 pages for 'calculated columns'.

Page 148/286 | < Previous Page | 144 145 146 147 148 149 150 151 152 153 154 155  | Next Page >

• How to define a class with variable properties?

  - by user1723326

  I'm making a database program. I want the user to be able to define their own columns, as many as they want. How would I then define each record in its class file?(Since the properties would be different user to user) EDIT: It's part of a school assignment-it's going to hold different scores and the likes for the teacher for different students they can add, but they will also be able to add a new assignment, test(a column) .

  Read the article

• c# Column datatype Date type (NOT DateTime)

  - by Sha Le

  Hi All: I want know is there good way to detect Column DataType for Date field (NOT DateTime)? This what currently I do: switch (dt.Columns[col].DataType.FullName) { case "System.DateTime": formatedVal = Formatter.GetDateTime(val); break; // which is NOT possible, but something equivalent am looking for case "System.Date": formatedVal = Formatter.GetDate(val); break; default: formatedVal = val.ToString(); break; } Thanks a bunch. :-)

  Read the article

• Match a comma followed by a newline with a regular expression

  - by MarathonStudios

  I have a comma delimited list I want to import into a database, and in some cases the last item is blank: item1, item2, item3 item1, item2, item1, item2, I'd like to replace all of these empty columns with a placeholder value using a regexp item1, item2, item3 item1, item2, PLACEHOLDER item1, item2, PLACEHOLDER I tried preg_replace("/,\n/", ",PLACEHOLDER\n",$csv);, but this isn't working. Anyone know what regexp would work for this?

  Read the article

• How to access Excel Max Column value?

  - by Phsika

  i try to create table from excel rows. however; excel columns : column1 has max 200 character row column2 has max 300 character row column3 has max 500 character row So i need to create sql create MyTable column3 nvarchar(500) according to Excel Max Character.

  Read the article

• how to bind ComboBox with DataTable

  - by niko

  Hi, I have the DataTable with following columns: id, Name, Description, ParentId and would like to create a WPF control (.NET 4.0 framework) which implements a combobox which displays the names which are bound to values of id. So when the user selects a name displayed in the combobox the behind logic has to retrieve its id value. I would be very thankful if anyone could show the way of doing the described above.

  Read the article

• Calculate the sum of a datagrid's rows

  - by chchrist

  I have this datagrid which has columns with a NumericStepper as an itemEditor where the user can change the number of items he wants to buy. How can I calculate the sum of all cells when the user updates datagrid's values? Thanks in advance

  Read the article

• How to show Image Thumb in Flex DataGrid linked to FileReferenceList

  - by John V

  Hello I have a Flex datagrid linked to an array collection that gets filled from a FileReferenceList for uploading images to a server. I want to show a thumbnail of the image in one of the grid columns as a preview. I have seen a lot of examples of doing this with an Item Render but those examples where using images on the server. These images are on the client pc waiting to be uploaded?

  Read the article

• How to add a property table to a form in Visual Studio?

  - by roddik

  Hi. I don't have much experience with C# or VS, but I want to add a property table to a form, like this one: So that columns are resizable, editable, of different types (e.g. checkbox for boolean) and sortable. How do I do that?

  Read the article

• How to specifiy the column width and text alignment of an HTML table using CSS?

  - by xkcd

  Is it possible to specify the width of a table column in percentages using css? Also is it possible to specify the text alignment of a specific column? For example I have a table that has 3 columns. I would like to say col1.width = 20% col2.width = 40% col3.width = 40% col1.text-align = left; col2.text-align = right; col3.text-align = center;

  Read the article

• Find all the varchar() fields in sql server?

  - by JD

  Hi, Is it possible to find all the varchar() columns in my database? I am using SQL Server 2008 and would like to get the list in SQL server management console. JD.

  Read the article

• Evaluate column value into rows

  - by Hugo Palma

  I have a column whose value is a json array. For example: [{"att1": "1", "att2": "2"}, {"att1": "3", "att2": "4"}, {"att1": "5", "att2": "6"}] What i would like is to provide a view where each element of the json array is transformed into a row and the attributes of each json object into columns. Keep in mind that the json array doesn't have a fixed size. Any ideas on how i can achieve this ?

  Read the article

• Advanced datagrid in flex 3

  - by nimmyliji

  Hi, I have an XML file which is coming from the back end through an HTTP service(Using the perl cgi) and I want to display it in an advanced data grid....as in if I click the parent element the children have to be displayed in the corresponding columns...I'm trying it with my data provider but its not working. Is it possible? Thanks in Advance.

  Read the article

• Dynamic ORDER BY in SQL Server

  - by BrunoLM

  I saw some topics about this, but the problem is that the solutions required a "switch case"... Like this I have a table with a lot of columns, is there a way to do a dynamic sort without the switch?

  Read the article

• swing layout: vertical flow

  - by pstanton

  Hi All, What LayoutManager should I use to achieve a transposed version of FlowLayout? Essentially, I want a vertical list which occupies multiple columns if it can't fit all of it's components within one column. +------------------------+ | item 1 | | item 2 | | item 3 | | item 4 | | item 5 | | item 6 | | item 7 | | item 8 | +------------------------+ or +------------------------+ | item 1 item 7 | | item 2 item 8 | | item 3 | | item 4 | | item 5 | | item 6 | +------------------------+

  Read the article

• MySQL: Update table column from subquery result

  - by Jhourlad Estrella

  On the Members table are columns "MemberID" and "PointsEarned". I want to update the PointsEarned column from the result of this query: SELECT m.MemberID, m.UserName, ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=2)*10 ) + ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=3)*3 ) + ( (SELECT COUNT(*) FROM ChatMessages as c WHERE c.MemberID=m.MemberID)*.1 ) as PointsEarned FROM Members as m Can anybody tell me how I should do it with a single query? Thanks!

  Read the article

• how to make popup box based on dropdown list selection using jquery

  - by kumar

  Hello friends.. I have three columns in the jquery grid with all three column has dropdown list boxes.. if you select first dropdown list box any value i need to enable second one.. if you senlect second I need to enable third one..using jquery... thanks

  Read the article

• MYSQL autoincrement a column or just have an integer, difference?

  - by David19801

  Hi, If I have a column, set as primary index, and set as INT. If I don't set it as auto increment and just insert random integers which are unique into it, does that slow down future queries compared to autincrementing? Does it speed things up if I run OPTIMIZE on a table with its primary and only index as INT? (assuming only 2 columns, and second column is just some INT value) (the main worry is the upper limit on the autoincrement as theres lots of adds and deletes in my table)

  Read the article

• Question on XJB

  - by Hima

  I have two tables -- INSTALL_BUILD_RESULTS and BUILD_RESULTS. IBR has a primary key called Install_Build_Id and BR has a primary key called Build_Id. Both are numbers A third table, LINK_BUILD_TO_INSTALL_BUILD is a table simply consisting of the two columns mentioned above, used together as a composite key. How can I write an xjb for these 3 tables.

  Read the article

• Django - 2 fields unique together

  - by webvulture

  Suppose, I want to record say poll choices by users everyday. In this case, i have a table named vote which has columns poll , choice and user-id . So how can i out the constraint (maybe in the django models or wherever possible) that poll and user-id both should not be the same for any entry but like the same user can vote for various different polls once and obviously various users can vote for the same poll. I hope I am clear.

  Read the article

• Is it bad to have a non-clustered index that contains the primary key from the clustered index?

  - by Don

  If you have a table with a clustered index on the Primary Key (int), is it redundant and bad to have one (ore more) non-clustered indexes that include that primary key column as one of the columns in the non-clustered index?

  Read the article

• Ensuring the contacts in a Distribution List are displayed with both name and email address

  - by hawbsl

  How can I ensure the contacts I add to an Outlook distribution list are displayed with both name and email address? These contacts may not exist in any other address book, just the distribution list. Currently they show up just as an email address (in both columns). Here's roughly the VBA we're using: Do Until RS.EOF //here's where we want to inject RS!FirstName, RS!Surname etc objRecipients.Add RS!Email objRecipients.Resolve RS.MoveNext Loop Set objDistList = contactsFolder.Items.Add("IPM.DistList") objDistList.DLName = "Whatever" objDistList.AddMembers objRecipients objDistList.Save etc

  Read the article

• ASP.net C# Add controls automatically to a data form

  - by user333817

  I am using ASP.net with C# and am looking for a tool that given a SQL table name, reads the table columns and populates an aspx form with controls (textboxes with matching labels). Something like ComponentOne InputPanel, except that this product only works for WinForms. See demo of ComponentOne InputPanel: http://www.componentone.com/newimages/Products/Videos/StudioEnterprise/InputPanel/ComponentOneInputPanel.html

  Read the article

• mysql: inserting data and autoincrement

  - by every_answer_gets_a_point

  i am converting from access to mysql i have a table in access where one of the columns is an autonumber when i transfer the data into the mysql database (where i also have a column that is auto_increment), should i be transfering the auto_increment data into the auto_increment column, or will it auto_increment itself? how do i ensure that if i do not transfer the autoincrement data from access, that it auto_increments properly?

  Read the article

• How to display a mysql table data in another language properly in php

  - by Shinigami

  i have a mySQL table which the data in one of its columns is in a language other than English.(Persian) when i input data in the table , it is shown properly but when i want to show the data in a php file it displays like this:???? well,what should i do in order to show the data in its correct form?

  Read the article

• How efficient is a details table?

  - by Jeffrey Lott

  At my job, we have pseudo-standard of creating one table to hold the "standard" information for an entity, and a second table, named like 'TableNameDetails', which holds optional data elements. On average, for every row in the main table will have about 8-10 detail rows in it. My question is: What kind of performance impacts does this have over adding these details as additional nullable columns on the main table?

  Read the article

< Previous Page | 144 145 146 147 148 149 150 151 152 153 154 155  | Next Page >