Home ›
All Tags » query (RSS)

Browse by Tags

Related Posts

  • Query Problem

    Hello, I am trying to write page that uses profiles to localize it to each user. The Query is based on UserId but I get this error: Failed to convert parameter value from Guid to string. Any ideas? Basically I want the page to select records in a table based on UserId. Thank you, Peter
    Posted to Getting Started (Forum) by pryanjr on 06-02-2009, 12:00 AM
    Filed under: query

  • Linq dynamic select query, occur injection

    Hi, Im making an c# asp.net webservice and using Linq for my DAL layer. I have an method with some parameters. I would like to use the parameter values in an SELECT query after the WHERE. Something like this: public void GetItems(String filter) { string sql = "SELECT * FROM ConfigurationItems WHERE...
    Posted to Data Access and ObjectDataSource Control (Forum) by khalidelmeknesi on 05-28-2009, 12:00 AM
    Filed under: Query, Dynamic, Linq, Select

  • Union or Join? Can't quite get my query dialed in.

    I will try to make this question as simple as possible. I basically want to display a running balance of credits and debits in my datagrid. Background: We are shipping agents at the Panama Canal and attend vessels that transit. Each transit has various cost items associated with them (canal tolls, line...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bcoffey on 05-26-2009, 12:00 AM
    Filed under: outer join, queries, query, query null value, query optimisation, query?, sql 2000 sql query, sql 2000 sql queryerver management studio express problem, SQL 2005, SQL 2005 SQL, sql express, sql server, SQL Server 2005, sql server 2005 express edition installation, sql server update, sql stored procedure, sql 2000, sql 2000 "sql server express 2005", SQL 2000 2005 from Ms Access 2007, sql 2000 administration security asp.net, Sql 2000 Dates, SQL 2000 Server, SQL 2000 Server Connection, SQL 2000 SQL 2005 migration syntax, SQL 2000 vs SQL 2005, SQL 20005, sql 2005, Sql 2005 .NET, SQL 2005 .NET ExecuteNonQuery, sql 2005 .NET ExecuteNonQuery return id of newly inserted record, SQL 2005 .NET full-text indexing, sql 2005 .NET Select query limits, SQL 2005 .NET SP storedprocedure options split, SQL 2005 ASP.NET Navision aspx.vb, SQL 2005 Design, SQL Distinct, SQL Programming, sql queries, sql queries gridview, sql Query, sql query rows, Sql query/views, "GROUP BY", "sp_executesql", "SQL Select and Update Where ", "SQL Server", "T-SQL", sql script

  • Very serious issue with MS-Sql

    We are using .NET 2.0 and intermittently egt the following errors on almost all our web pages. The error is not repoducable and cycling the worker process seems to temporarily fix the problems. Has anyone seen this or have any suggestions? There are columns available in that table. and there were no...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by achleshsoni on 05-26-2009, 12:00 AM
    Filed under: Query, sql 2005

  • Non-Agregate function PIVOT table needed...I think

    Here is the data that I get back from my SQL query (SQL 2005): ID NIIN WSC 1 015565845 M3A 1 015565845 M4A 2 015576613 M5A 2 015576613 M6A 4 015576709 M5A 4 015576709 M6A 6 015576712 M5A 6 015576712 M6A 7 015623462 IRM 7 015623462 M1A 7 015623462 MYA 7 015623462 MZA Here is my SQL: SELECT RobListOfNIINs...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by BrianFan on 05-12-2009, 12:00 AM
    Filed under: multiple, Multiple queries, multiple result sets, queries, query, query?, SelectCommand, slq 2005, Slq Server, SQL, SQL 2005, sql 2005 server, SQL 2005 SQL, sql 2005, Sql 2005 .NET, SQL 2005 Design, sql 2005 stored procedure full text index, SQL datatable, sql efficiency, SQL inner join, SQL Programming, sql Query, "MSSQL error", "SQL Server", "T-SQL", .net 3.5, data Acces, Dynamic Query, dynamic sql, Dynamic SQL&quot, Select Statements, "ASP.NET and SQL Server", sql script

  • need help - filter data by month in gridview ???

    i am unable to create the following report: my requirement is to display a 12 month report of data that a user sorts by year. i cannot figure out to structure my sql query to filter my data so that all the data is organized and summed by month. i have searched the forums and the net for some examples...
    Posted to Data Presentation Controls (Forum) by yogweedo on 04-07-2009, 12:00 AM
    Filed under: Query, SQL Query, SQL-Server, stored procedure, grid view row, GridView compute sum

  • How to create table linked to another database

    I'm using Visual Web Developer 2008 (VB code) and need to create a table that links to our main database, an AS400. Basically, I want to query Part #s from the AS400 and create a table in a separate database that will store additional information about the part #s. What I have, thus far, will bring...
    Posted to Data Presentation Controls (Forum) by jct.maf on 04-01-2009, 12:00 AM
    Filed under: Query, sqldatasource, data access, database

  • Select query for gridview

    Hi everybody, Im making an c# asp.net website. I have 2 tables with an relation between them. Im using an dataset with for each table an tableAdapter. Here are my tableAdapters: I have an gridview and an objectDatasource(to the StatsTableAdapter). For the select method Im using the method "GetUsersByDate"...
    Posted to Data Access and ObjectDataSource Control (Forum) by khalidelmeknesi on 03-16-2009, 12:00 AM
    Filed under: Query, DataTable, SELECT, GridView

  • EasyQuery WebForms 2.4.0 - FREE user-friendly query builder for your ASP.NET web-site

    We are proud to announce EasyQuery.NET WebForms edition version 2.4.0 release. EasyQuery.NET WebForms edition allows you to establish user-friendly data searching and filtration interface on your ASP.NET web-site. It gives your users an ability to describe their requests in natural language instead of...
    Posted to Announcements (Forum) by Korzh.com on 03-12-2009, 12:00 AM
    Filed under: query, .NET 2.0, .NET component, .NET Components, asp .NET 2.0 database objects sql, ASP.NET 2.0, Data access

  • How to get the value of primary key to the row just added?

    I am adding a row to a table A and then want to add primary key value of this row to another table. How to achieve that? I have tried SELECT SCOPY_IDENTITY(), but what i always get is number '1', which i think is number of row affected. moreover, i believe in the sql query builder of VWD, i am...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ruchitgarg on 12-21-2008, 12:00 AM
    Filed under: query, SQLEXPRESS, vwd
Page 1 of 8 (74 items) 1 2 3 4 5 Next > ... Last ยป

Contact | Advertise | Ads by BanManPro | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.