Browse by Tags

Home ›

All Tags » database » query (RSS)

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
Implementing site search.

Hi All, I'm interested in including a search function on a couple of sites, but I'm not really sure where to start. Thought I would try and start a discussion to see how people are tackling this function, as I know a lot of users are used to just hitting a search query in these days, rather than...

Posted to Getting Started (Forum) by magicjoef on 12-12-2008, 12:00 AM
Filed under: query, search, Search Engine, sql statements, database
Need foreach functionality in Stored Procedure

I have a stored proceudre that brings back 6 columns (PART, FSC, NIIN, NAME, TotalQty, ReqID). After the SELECT statement has run, I need to update one of my tables. In the table that I need to update, there is a column named ReqStatus, and this tables PK is ReqID (from above SELECT statement). Fore...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bfancett on 12-05-2008, 12:00 AM
Filed under: query, query?, slq 2005, Slq Server, SQL, SQL 2005 SQL, sql server, SQL Server 2005, sql server update, sql 2005, SQL Server 2005, Stored procedure sql, Stored Procedure update / insert, stored procedure variables, stored procedure variables WHERE clause, stored proceduredure sql, stored proceduree, Stored procedures, StoredProcedure, StoreProcedure, UPDATE, update column, Update SQL Statement, update statement, "T-SQL", "User Defined Function", 2005, asp.net c# profiles sql server, ASP.NET C# sql, c#, C# SQL, column attributes, column name, column name query, Data, Database, HAVING, "Dynamic SQL", For Each Loops, for loop, queries, SQL 2005, SqL For Each Loops, update records, "SQL Server", .net 3.5, db
Dynamic LINQ Objects

I have spent quite some time Googling and looking around for anything relatively related to my subject, and have found very little. My scenario is this: I want to use LINQ in a web application, BUT I need the ability to dynamically create a Data Context, I believe it's called? The .dbml file that...

Posted to Data Access and ObjectDataSource Control (Forum) by JMoore5268 on 09-17-2008, 12:00 AM
Filed under: Query, sql, Visual Studio 2008, "Linq to Sql" LinqDataSource, .NET 3.5 SP1, asp.NET 3.5, asp.net 3.5 Linq, C#, data Acces, Data Access, Database, dynamic LINQ, LINQ in Action, Linq query, LINQ SQL Dynamic predicate builder, Linq to SQL, LinqDataSource, database connection, Linq, linq ado, LINQ databasecontext dbml, LINQ databasecontext dbml System, 3.5, Data Access connections, Data Access Application block, linq databasecontext
How to make hyperlink to open another page and show filtered in datalist

Hi, i have a gallery.aspx page (datalist) which swows every data (id) from databas. The collumns in database which i use are id, foto, cat, ..... Now, i want to make a hyperlink from another page (e.x.index), clicking that, to display filtered data in gallery.aspx (some of the data from database), where...

Posted to Web Forms (Forum) by bluewire on 07-02-2008, 12:00 AM
Filed under: Query, SelectParameters, Database, Filter
Query Access database for DATE (using the > operator)

I am connecting to an access database in a .net page (using c#) I need to query the database for results matching a date that is greater than today. (I am using the results to populate a calendar control) something like: DateTime dtCurrentDate = DateTime.Today; strQuery = "SELECT * FROM myTable...

Posted to Access Databases and AccessDataSource Control (Forum) by wizzkidd07 on 06-14-2008, 12:00 AM
Filed under: query, access, database, datediff, dates
Need Help with webservices

Hi, I am Amit from India, I need ur help on ASP.NET Webservices. I am getting problem while running a WebService on Prouction server. Below is source code, that I am using. Actually I am trying to connect my WebService to mine installed blog. here is the link of issue that I had posted earlier. http...

Posted to XML Web Services (Forum) by amitranjan on 06-11-2008, 12:00 AM
Filed under: query, sql server 2005, database, webservices, database access using webservices, datatable
Acess tables from different databases

I am using Vista Business with Visual Web Developer and Sql Server Express 2005. I want to be able to access the data from two tables in a query. Both tables are attached to the application. To refer to the two databases I have used the following DATABASE.OWNER.TABLE (specifically TaskMgr.dbo.TaskTable...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by michael_y on 01-23-2008, 12:00 AM
Filed under: query, SQL Server Express, visual web developer, Database
EasyQuery WebForms 2.5.0 - user-friendly query builder for your ASP.NET web-site

We are proud to announce EasyQuery.NET WebForms edition version 2.5.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 07-09-2009, 12:00 AM
Filed under: sql, report, query, quer builder, database

Page 1 of 1 (9 items)

Browse by Tags

Related Posts