Search Results

Search found 10060 results on 403 pages for 'column'.

Page 252/403 | < Previous Page | 248 249 250 251 252 253 254 255 256 257 258 259  | Next Page >

• how to show only date?

  - by kumar

  I have a column in the data table called CurrentDate as datatype string..(12/2/1983) when I am displaying on the screen this is showing as 12/2/1983 12:00:00AM I am not sure why I am getting timestamp here? can anybody help me out? thanks

  Read the article

• .Net: how can I have a combobox with multitple fields of its data source as Displaymember?

  - by odiseh

  hi How can I have a combobox with multiple fields of its data source as its display member without adding additional columns to its data source? I mean I wanna to have a combobox with displaymember like "ID" + "-" "Name" . 1 - Black 2 - White 3 - Red I DO NOT want to add additional column to its data source. Thank you

  Read the article

• Add a fixed3d border to a specific coulmn in a datagridview inorder to indicate that a cell is edita

  - by user271077

  I need to somehow show the userd that the a specific column in a datagridview is editable. I want to add a fixed3d border only to that coulmn but couldn't find how to. How can I do that or any other creative idea on how to solve this problem - showing the cell can be edited?

  Read the article

• Access different columns from LINQ resultset

  - by Piyush

  I have a query which returns multiple columns from the database using LINQ var donors = from d2 in db.Donors where d2.Status == "Pending" select new { donorID = d2.donorID, bloodGroup = d2.bloodGroup, contactNo = d2.contactMobile, status = d2.Status }; now I want to display the results in different Labels accessing one column value from donors resultset. ex: Label1.Text = donorID; Label2.Text = bloodGroup; ...and so on please help me achieve this.

  Read the article

• wxGrid different cursor

  - by snorlaks

  Hello, Im using wxGrid which has 3 columns. I would like cursor to be differen (Hand) when mous is over cells from 2 and 3 column. How can I do that ? Thanks for help

  Read the article

• Exceptions handling in SQL?

  - by Vineet

  Is there any way to handle exceptions in sql(ORACLE 9i)? Since I was trying to divide values of a column that contains both numbers and literals ,I need to fetch out only numbers from it ,as if it divisible by any number then its number else if contains literals it would not get divided it will generate error. how to handle those errors? Please suggest!!

  Read the article

• Item of one combobox should not come into the other

  - by syedsaleemss

  Im using c# .net windows form application. I have a database with some tables.I have two comboboxes (A & B). I have populated a combo box A with column names of a table using sys.columns. Now when i select an item in combo box A ,combo box B should be populated with the same items except the selected item which was selected in combobox A .

  Read the article

• When should I consider representing the table-id ...?

  - by JMSA

  When should I consider representing the table-id columns as classes? When should I consider storing data as comma-separated values in a column in a DB table rather than storing them in different columns?

  Read the article

• how to select rows from table.

  - by Ayyappan.Anbalagan

  my table contains category_name and parent_category_Id column My parent_category data contains, the same table primary key id. i need to select the all rows and insted my parent_category_Id i need to select the catogry_name

  Read the article

• CodeIgniter - numbers in sql query are masked with ``

  - by Checkson

  Hello, i'm using CodeIgniter for developing a community board. As I'm using nested sets to get a nested forum hierarchy, I have to run a lot of queries such as: SELECT `id` FROM `forums` WHERE 1 BETWEEN `lft` AND `rgt` My problem: CodeIgniter is replacing the "1" by "`1`" because the "1" is recognized as a column name. Of course, the query does not work any more. Is there a way to get it working? thx in advance

  Read the article

• sqlite and visualstudio

  - by dban10

  How do I set an identity column for sqlite in visual studio? I am performing a new query and am trying to create a new table using script.

  Read the article

• How do I mysql select with aliases from another table?

  - by Rob

  I'm working with a CMS system where I cannot control database column names. And I've got two related tables: Table: content +------------+----------+----------+----------+----------+ | content_id | column_1 | column_2 | column_3 | column_4 | +------------+----------+----------+----------+----------+ | 1 | stuff | junk | text | info | | 2 | trash | blah | what | bio | +------------+----------+----------+----------+----------+ Table: column_names +------------+-------------+ | column_id | column_name | +------------+-------------+ | 1 | good_text | | 2 | bad_text | | 3 | blue_text | | 4 | red_text | +------------+-------------+ What I'd like to do here is select from the first table, but select the columns AS the column_name from the second table. So my result would look like: +------------+-----------+----------+-----------+----------+ | content_id | good_text | bad_text | blue_text | red_text | +------------+-----------+----------+-----------+----------+ | 1 | stuff | junk | text | info | | 2 | trash | blah | what | bio | +------------+-----------+----------+-----------+----------+

  Read the article

• Replace BIT values with some text

  - by nihi_l_ist

  I have a BIT column with gender (0,1) and want to replace 0 and 1 in the resulting view with the words "man" and "woman". Can i do this right in the view with some system finction or i have to write my own function to do that?

  Read the article

• Make a set from CSV values in TSQL

  - by rossfabricant

  If I want to see which values from an Excel spreadsheet column don't match values in a table, I can easily create a table with Bulk Import. Is there a simpler way? EG, I want to do a query like: select into #temp from ('a', 'b', 'c') as 'Id' select * from #temp where Id not in (select Id from MyTable)

  Read the article

• Selecting two specific mysql table rows in a single query

  - by Scotta

  Lets say I have a table with 20 entries. They are sorted by date (date is a column name _) in descending order. How would I go about selecting ONLY the newest entry and the 15th oldest entry? I am getting all 15 results by doing the following query SELECT * FROM mytable m WHERE col1 = "zzz" ORDER BY date DESC LIMIT 15;

  Read the article

• How do I do this query in MysQL? (datetime)

  - by alex

  Suppose I have a datetime column in MySQL. How do I select all that have a datetime within 2500 seconds of the current datetime? SELECT ALL where current_datetime - that_datetime < 2500 ...

  Read the article

• Flex AdvanceDatagrid

  - by udara

  What is the difference between normal datagrid and advance datagrid.Sorting,draging columns,resizing columns are supported even in normal datagrid. I want to add footer details like summery,average etc of each column,does AdvanceDataGrid supports these features?

  Read the article

• how to pass parameters to sql query

  - by Shiny

  Im using Sql compact server.I created table with varchar datas.But i select a particular column member to be an identity.im programming in c#. I want pass the query. how can i achieve this? Im new to this sql compact,

  Read the article

• Sql query number of occurance

  - by phenevo

  Hi, I wanna to have query: Select cars.* from cars where cars.code in ( select carCode from articles where numberofrecords with this car (it is not a column) >1 and Accepted=1 order by date ) How to write it?

  Read the article

• i am using c# with asp.net and sql 2005 as backend, i want to use dropdown list cntrl in a form and

  - by kunal

  i am using c# with asp.net and sql 2005 as backend, i want to use dropdown list cntrl in a form and fetch a column in a textbox which is linked to that dropdown cntrl in the database, what coding should i use in c# for that?

  Read the article

• Excel - linking 2 columns

  - by Andrew

  I'm trying to create a scheduling system in Excel. I have a column with employees and right beside that, their roles. How do I link each employee to a role?

  Read the article

• Mysql ADDDATE() or DATE_ADD() with table columns?

  - by John

  How do I do something like the following SELECT ADDDATE(t_invoice.last_bill_date, INTERVAL t_invoice.interval t_invoice.interval_unit) FROM t_invoice ...where the column t_invoice.last_bill_date is a date, t_invoice.interval is an integer and t_invoice.interval_unit is a string. Basically, I want to determine a person's next bill date based on his desired billing frequency. Is there a better way to achieve this?

  Read the article

• Excel function advanced filter

  - by Adam

  I have a list of sales people and a list of their sale revenues in two separate columns. How do I use an advanced filter or other sorting means to find the max of the sale revenue column and then have the formula output be the corresponding sales person?

  Read the article

• PHP Round Minute to nearest Quarter Hour

  - by Rob

  I need to round times down to the nearest quarter hour in PHP. The times are being pulled from a MySQL database from a datetime column and formatted like 2010-03-18 10:50:00. Example: 10:50 needs to be 10:45 1:12 needs to be 1:00 3:28 needs to be 3:15 etc. I'm assuming floor() is involved but not sure how to go about it. Thanks

  Read the article

• Write a JavaScript that accepts a number from the user using the “prompt” function

  - by A sw A

  Write a JavaScript that accepts a number from the user using the “prompt” function. Then it draws a table in the HTML document that has the user specified number of rows and columns. In each table data, it displays the result of the math operation (row raised to the power of column). For example, if the user enters the number 3, the JavaScript should draw the following table: 1 1 1 2 4 8 3 9 27

  Read the article

< Previous Page | 248 249 250 251 252 253 254 255 256 257 258 259  | Next Page >