Search Results

Search found 23568 results on 943 pages for 'select'.

Page 521/943 | < Previous Page | 517 518 519 520 521 522 523 524 525 526 527 528  | Next Page >

• ado.net data entity problem

  - by ognjenb

  I have this error Cannot implicitly convert type 'System.Linq.IQueryable' to 'Mvc.Models.engineer'. An explicit conversion exists (are you missing a cast?) after write this code engineer Ing = new engineer(); Ing = from j in testPersons.ibekoengineer select j.Name; What is wrong?

  Read the article

• Is there a better way to retrieve unique ID upon INSERT?

  - by Andy

  Hi, I am using the following MS SQL statement to insert records and return the unique auto-inc ID value all in one shot. Wonder if there is a simpler/faster/better way to do it? SET NOCOUNT ON; DECLARE @res table (ID bigint); INSERT INTO [Titles] ([Name],[Timestamp],[Title]) OUTPUT INSERTED.ID INTO @res VALUES ('Name','23 aug 2010','this is a title'); SELECT [ID] FROM @res;

  Read the article

• Selecting text and focusing on a textbox

  - by Malfist

  I'm trying to programmatically select the text in a textbox, and focus on it too, so that when the form is launch the user only has to start typing and it will replace what is already there. I've been using the code: stage.focus = _finalScoreTF; _finalScoreTF.setSelection(0, _finalScoreTF.text.length - 1); but it doesn't work...any ideas?

  Read the article

• Foreign Keys Duplicated in DataGridView

  - by John Doe

  I created a Windows Forms Application to which I added a DataGridView and LINQ to SQL Classes from one of my databases. I can successfully bind one of my database's tables to my DataGridView: var dataSource = from c in _db.NetworkedEquipments select c; dataGridView1.DataSource = dataSource; However, the foreign keys get duplicated, that is, the columns appear twice. How can I prevent this?

  Read the article

• onclick event in combo box

  - by raam

  function ram(){ document.write("Hello World!") alert("ok"); } India Autralia England Ameriaca Pakistan In this above code the event will not fire for combo box ..i try by using focus and click event....i can i do this....and i want 1 more thing if i select combo box value as India,i want to create a combo box with state(elements are TN,DL..) updation...

  Read the article

• Skip first letters of all values returned from a sql server database

  - by Peter

  Hi, as topic says, I don't want to return the first two letters in the return values just an example: select companyname from companies returns companyX Can I write a query that returns panyX instead? Thanks in advance

  Read the article

• Mysql syntax help

  - by Karthick

  Query: select t1.col1 from table1 t1 inner join with (nolock) table2 t2 on t1.col2 = t2.col1 Am trying to use nolock option for optimized query in mySQL db, but for some reason the above query does not work and the error i receive is You have an error in your SQL syntax; Any thoughts?

  Read the article

• Selecting specific range of columns with jquery

  - by AdamB

  I'm looking to select columns 2-4 on the 2nd row in a table. Does jquery have any sort of "and" function in their selectors? Or would I have to do something like this? $('#id tr:eq(1)').find('td:lt(5)').find('td:gt(1)')

  Read the article

• mysql multi count() in one query

  - by atno

  Hi, I'm trying to count several joined tables but without any luck, what I get is the same numbers for every column (tUsers,tLists,tItems). My query is: select COUNT(users.*) as tUsers, COUNT(lists.*) as tLists, COUNT(items.*) as tItems, companyName from users as c join lists as l on c.userID = l.userID join items as i on c.userID = i.userID group by companyID The result I want to get is --------------------------------------------- # | CompanyName | tUsers | tlists | tItems 1 | RealCoName | 5 | 2 | 15 --------------------------------------------- what modifications do i have to do to my query to get those results? Cheers

  Read the article

• FolderBrowseDialog Silverlight

  - by scrat789

  I have an silverlight 4 application, and I want to upload recursively a local folder on the server. For upload files separatly, there is OpenFileDialog method, But I can not select a folder path. Does exist an equivalent of the WPF "FolderBrowseDialog" method in silverlight ?

  Read the article

• Count total number of callers?

  - by Kristopher Ives

  I'm currently doing this query to find the guy who makes the most calls: SELECT `commenter_name`, COUNT(*) AS `calls` FROM `comments` GROUP BY `commenter_name` ORDER BY `calls` LIMIT 1 What I want now is to be able to find out how many total unique callers. I tried using DISTINCT but I didn't get anywhere.

  Read the article

• Can I concatenate multiple MySQL rows into one field?

  - by Dean

  Using MySQL, I can do something like select hobbies from peoples_hobbies where person_id = 5; and get: shopping fishing coding but instead I just want 1 row, 1 col: shopping, fishing, coding The reason is that I'm selecting multiple values from multiple tables, and after all the joins I've got a lot more rows than I'd like. I've looked for a function on MySQL Doc and it doesn't look like the CONCAT or CONCAT_WS functions accept result sets, so does anyone here know how to do this?

  Read the article

• how to pass a parameter safely into linq to sql

  - by Blankman

  If I want to get a user that has the email address of '[email protected]', how do I pass that as a parameter in linq? ie.: var a = from u in Users where u.Email = @email Select u; So this would be used in my method: public static GetuserByEmail(string email) Do I just pass in the variable or?

  Read the article

• Problem with libxml2 and Unicode char in XML Soap with Qotes (") and &amp;quot;

  - by x2on

  I'm using libxml2 for SOAP-Actions in an iPhone App. The big problem is that i want send an SQL-Statement with NSString *query = @"SELECT test FROM database WHERE test = \"string\"" But libxml2 converts the qotes " into &amp;quot; Any ideas how to prevent this?

  Read the article

• incrementing a table column's data by one || mySql

  - by Praveen Prasad

  iam having a table with columns like id || counter if i do something (some event) i want the counter's value(at a particular id) to increase by one , currently iam doing this : //get current value current_value = select counter from myTable where id='someValue' // increase value current_value++ //update table with current value update myTable set counter=current_value where id='someValue'; currently iam running 2 queries for this, please suggest me some way do it in one step.

  Read the article

• List Component that acts as if control was permanently pressed

  - by Dennkster

  Hey, I have a list control and i want the user to be able to select many items at a time. Thus I want it to act that if the control key is pressed while he is clicking. Eg if he clicks on a selected row it should become unselected and if he clicks on a unselected row it should become selected. Do you have any idea how to do this? Thanks, Dennis

  Read the article

• Bona fide transiant windows with WinAPI?

  - by user146780

  I want to create a Window like when a context menu pops up or clicking the menubar. I want a Window that will be like this and that I can take over its paint event. Sort of like what is created when you select a sub tool in Photoshop. Thanks

  Read the article

• is there any column click event in ext js ?

  - by vaishali

  I am using Ext.grid.gridpanel.As in rowclick event, we can handle row click of grid..Is there any event to handle column click of grid? i want to select a particular column of grid.

  Read the article

• Selecte and retrieve file path to image using dialog box

  - by Steven

  I'm expanding Wordpress to function more like a CMS. This includes relating image to a post. Currently I have a text field where I paste an image path. Now I want to click a button which opens a dialog box, then I navigate to the right folder and select a file to "open" (from server side). The file path is returned. How can I go about accomplishing this?

  Read the article

• Linq, how to delete items in the middle of a query return?

  - by 5YrsLaterDBA

  I got a list of objects in the following query. How to delete items in the middle, saying I want to delete item in 2, 5, and 7 position? thanks var archivedPwds = from archivedPwd in db.PasswordArchive where archivedPwd.UserId == userId orderby archivedPwd.DateChanged select archivedPwd;

  Read the article

• How to load 1 milion records from database fast?

  - by Leonard P.

  Now we have a firebird database with 1.000.000 that must be processed after ALL are loaded in RAM memory. To get all of those we must extract data using (select * first 1000 ...) for 8 hours. What is the solution for this?

  Read the article

• Generate T-SQL for Existing Indexes

  - by Chris S

  How do you programmatically generate T-SQL CREATE statements for existing indexes in a database? SQL Studio provides a "Script Index as-Create to" command that generates code in the form: IF NOT EXISTS(SELECT * FROM sys.indexes WHERE name = N'IX_myindex') CREATE NONCLUSTERED INDEX [IX_myindex] ON [dbo].[mytable] ( [my_id] ASC )WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY] GO How would you do this programmatically (ideally through Python)?

  Read the article

• SQl Server error handling pattern

  - by Patrick Honorez

  Hi all. I am not an expert on SQl Server. Is this a valid pattern for handling errors in a batch of SELECT, INSERT...in SQl SERVER ? (I use v.2008) BEGIN TRANSACTION BEGIN TRY -- statement 1 -- statement 2 -- statement 3 COMMIT TRANSACTION END TRY BEGIN CATCH ROLLBACK TRANSACTION END CATCH Thanks

  Read the article

• problem in listbox value and mysql database in vb.net

  - by testkhan

  i have a problem in inserting the listbox value into mysql database in vb 2008 i.e if i select a video file i.e D:\videos\video1.mpg and add a msgbox() event before inserting into data base it shows the exact path i.e D:\videos\video1.mpg but when i check my database it shows me as D:videosvideo1.mpg how can i solve that

  Read the article

• ruby 1.9.1 in netbeans?

  - by fayer

  i have installed ruby 1.9.1 and when i in the command prompt type: ruby -v i see the latest version. however, in netbeans when i create a new project i can only select 1.8.7 version. how do i tell netbeans to use the latest ruby version that i have installed? thanks

  Read the article

< Previous Page | 517 518 519 520 521 522 523 524 525 526 527 528  | Next Page >