Search Results

Search found 27248 results on 1090 pages for 'table adapter'.

Page 735/1090 | < Previous Page | 731 732 733 734 735 736 737 738 739 740 741 742  | Next Page >

• How do I return count and not count in a SQL query?

  - by Gribbler

  Hi, If I have a table AgentID | IsNew | TeamID 1 N 1 2 Y 2 3 Y 2 4 N 2 5 Y 1 I want to return the following from a query: Team | CountIsNew = N | CountIsNew = Y 1 1 1 2 1 2 Is there a way I can do this? Using Oracle 10

  Read the article

• Passing multiple parameters of same column to SQL Server select SP

  - by Bill

  I have a string value in the web.config — for example 2 guids seperated by a ",". I need to query the database dynamically (i.e i have no idea how many values could be seperated by a comma in the web.config) and run a select statement on the table passing these values and getting all that is relevant for example: select * from tablename where columnname = string1 string2 string3 etc etc some strings may only contain 1 guid some may contain 10

  Read the article

• Printing user specified column from JTable

  - by technomage

  I have an application, and I would like to print a JTable, but since it has many columns, I would like user to select/limit which columns to print so it can fit in regular printer paper. I'm using JTable.print() function to print. (http://java.sun.com/docs/books/tutorial/uiswing/misc/printtable.html) Right now, my solution, is to create another JTable with the columns that user selected, then repopulate the table with the data, then send it to printer. Is there a better way to do it?

  Read the article

• MySQL: How to add one day to datetime field in query

  - by phpBOY

  Hello, In my table I have a field named eventdate in datetime format like 2010-05-11 00:00:00. How do i make a query so that it adds one day to the eventdate eg if today is 2010-05-11, i want to show in where clause to return all records with tomorrow's date.

  Read the article

• mysql procedure to update numeric reference in previous rows when one is updated

  - by markcial

  There's a table like this one ______________________ | id | title | order | |----------------------| | 1 | test1 | 1 | |-----|--------|-------| | 2 | test2 | 2 | |-----|--------|-------| | 3 | test3 | 3 | |-----|--------|-------| | 4 | test4 | 4 | '----------------------' when i introduce in my mysql shell a single update to a row $sql UPDATE `table` SET order=1 WHERE id=3; And then procedure or method resamples order column in the before update lower values to get its order renewed like this ______________________ | id | title | order | |----------------------| | 1 | test1 | 2 | |-----|--------|-------| | 2 | test2 | 3 | |-----|--------|-------| | 3 | test3 | 1 | |-----|--------|-------| | 4 | test4 | 4 | '----------------------' Any help would be appreciated, thanks!

  Read the article

• Sum values in a DataTable by a given criteria

  - by šljaker

  Which is the most effective way to sum data in the DataTable by a given criteria? I have the following table: KEY_1 KEY_2, VALUE_1, VALUE_2 Input: 01101, P, 2, 3 01101, F, 1, 1 01101, P, 4, 4 10102, F, 5, 7 Desired output (new DataTable): 01101, P, 6, 7 01101, F, 1, 1 01101, SUM, 7, 8 10102, F, 5, 7 10102, SUM, 5, 7 I need efficient algorithm, because I have 10k rows and 18 columns in a DataTable. Thank you.

  Read the article

• How to make an SQL query if Want some specific rows from Specific place

  - by Azhar

  How to make an SQL query if there are 30 records in table and I want to pick rows from 12 to 20 where 12 and 20 are row numbers not Ids. **Ids Code** 5 ABC 6 SDF 8 WSA 10 FSD 15 IOP . . . . 80 AWS

  Read the article

• SQL Server 2005: Invalid object name exception

  - by Craig Johnston

  In VS2005, I am using a DLL which accesses a SQL Server. The DLL returns a SQLException Invalid object name 'tableXYZ' but tableXYZ is a table in the database. Should it be looking for dbo.tableXYZ instead? Is this a permissions issue with the login being used?

  Read the article

• sql question regarding sum() and tax (MySQL 5.0.89)

  - by jason

  Select id, sum(amount), vat From transactions WHERE id=1; Each record in this table has a vat percentage, I need to get the total amount in all records, however each amount has to be multiplied by by its vat %. Is there away to do this without looping through all records?

  Read the article

• Timeout on Large mySQL Query

  - by Bob Stewart

  I have this query: $theQuery = mysql_query("SELECT phrase, date from wordList WHERE group='nouns'"); while($getWords=mysql_fetch_array($theQuery)) { echo "$getWords[phrase] created on $getWords[date]<br>"; } The data table "wordList" contains 75,000 records in the group "nouns" and every time I load the code I am returned an error. Help!

  Read the article

• Problem in hiding scrollbar of webbrowser control

  - by Royson

  I have web browser control in panel and panel is placed in table layout. i have tried to hide scroll bar by webBrowser.ScrollBarsEnabled = false; but still there is scrollbar are visible. I want to hide it irrespective of page width. User should see page area which are best fitted on panel. How to do this.

  Read the article

• Datable.Select sort expression

  - by xyz

  Hi, I have datatable with column name tag and 100 rows of data.I need to filter this table with tag starting with "UNKNOWN". What should my sortexpression for datatable.select be ? I'm trying the following. Datarow[] abc = null; abc = dtTagList.Select(string.format("tag='{0}'","UNKNOWN")) How can I achieve tag startswith 'UNKNOWN' in the above code ?

  Read the article

• sql count conditions

  - by user1311030

  there! I have this question, hope you guys can help me out. So i have this table with two fields: type and authorization in type i have 2 different values: Raid and Hold in authorization i have 2 different values: Accepted or Denied I need to make a view that returns values like this: TYPE:RAID ACCEPTED:5 DENIED:7 Basically i need to know how many of the values in TYPE are Raid, and then how many of them are Accepted and Denied. Thank you in advance!!

  Read the article

• SQL: Find the max record per group

  - by user319088

  I have one table, which has three fields and data. Name , Top , Total cat , 1 , 10 dog , 2 , 7 cat , 3 , 20 horse , 4 , 4 cat , 5 , 10 dog , 6 , 9 I want to select the record which has highest value of Total for each Name, so my result should be like this: Name , Top , Total cat , 3 , 20 horse , 4 , 4 Dog , 6 , 9 I tried group by name order by total, but it give top most record of group by result. Can anyone guide me, please?

  Read the article

• How do I write a PL/SQL anonymous block when I have discontinuous blocks?

  - by aryan

  I have to retrieve an ID and last_name from my table, but my ID is not continuous and there no pattern for the gaps. How do I write a PL/SQL anonymous block for this?

  Read the article

• How do the .NET Framework, CLR and Visual Studio version numbers relate to each other?

  - by Scott Dorman

  With the recent announcement of .NET 4.0 and Visual Studio 2010, it is becoming ever more difficult to keep track of what .NET Framework versions build on what version of the CLR and belong with which version(s) of Visual Studio. Is there a definative table that shows these relationships?

  Read the article

• In sql server, is there any way to check whether the schema change will impact on the stored procs?

  - by ziang

  In SQL Server, is there any way to check whether the changes in the schema will impact Stored Procedures (and/or Views)? For example a change of the column name in one table, may break some Stored Procedures; how to check the impacted stored procs?

  Read the article

• Tsql ordering data by specific string values

  - by anteneh maru

  Hi every body I have an audit table that have data for insert, update and delete operations. I am writing a report that will display data in the order of Insert, Update and Delete. I don't think the order by clause will help. any help?

  Read the article

• mysql syntax error for timestamp

  - by eyecreate

  I have this piece of SQL that is being fed to Mysql. CREATE TABLE pn_history( member INT, action INT, with INT, timestamp DATETIME, details VARCHAR(256) ) But is comes back as an error about the syntax. #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'with INT, timestamp DATETIME, details VARCHAR(256) )' at line 4 Why is this failing?

  Read the article

• Ignore mouse interaction on transparent parts in image and assign it to the image below

  - by TomBS

  i have two tables with images that parts of them are transparent and i want to ignore mouse interactions (especially clicking) on these parts and assign the click to the image in the other table that below. (i hope you understand because english is not my native language.) thanks..

  Read the article

• How to I define/change the mappings for Linq To Sql in code.

  - by Ian Ringrose

  I wish to be able to change the table a class is mapped to at run time, I can’t do this if all the mappings are defined with attributes. Therefore is there a way to define the mappings at runtime in code. (I would rather not have to maintain xml mapping files.)

  Read the article

• Finding easily parseable chemical element data

  - by nickname

  I am writing an application that needs simple data found (mostly) on the periodic table of elements, such as atomic mass, atomic number, state, etc. However, I would prefer not to manually enter this data. I managed to find the NIST website (http://www.nist.gov/pml/data/edi.cfm) with all of the data I need, but not in a downloadable format. Where can I find this data? Preferably, it would be in an XML/YAML/JSON/other documented format, however, any format would be helpful.

  Read the article

• How to sort Grid view on the basis of particular column?

  - by Jene

  Hi, I want to sort Grid View on the basis of paticular column. For example: Now i want to sort above table in such a way that all Developers should come first. Thanx

  Read the article

• Sql query builder c#

  - by pdiddy

  I'm building a windows mobile app. And using SqlCe. I'm looking for a good sql query builder. So instead of writing "SELECT COLUMNS FROM TABLE WHERE etc... Is there a good free library that can build this sort of query?

  Read the article

• Mysql Syntax Error

  - by tarnfeld

  Any idea why this is popping up :( ? You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `clocks` ( `id` int(11) NOT NULL AUTO_INCREMENT, ' at line 6

  Read the article

< Previous Page | 731 732 733 734 735 736 737 738 739 740 741 742  | Next Page >