Browse by Tags

Home ›

All Tags » query » C# (RSS)

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
First Web & Web 2.0 oriented database is released

The first release of Eloquera, the fusion database, is out. Eloquera's architecture and technology specifically targets at the Web developer. It provides the desired objectives of speedier development and maintenance. At the same time, it provides the seemingly contradictory benefit of startlingly...

Posted to Announcements (Forum) by bablind on 11-21-2008, 12:00 AM
Filed under: object-relational, Productivity, Programming, query, Search, servers, sql, web application, Web applications, web components, .NET 3.0, .NET based CMS, AJAX, asp .NET 2.0 database objects sql, asp.net, ASP.NET 2.0, ASP.NET 3.5, c#, csharp, Data access, dotnet, asp .NET 2.0, API, Find
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
Re: Ican't update my dataset

here i post the code that i wrote i take the stage and depId from two textboxs and beging to excute the queries usin tabel adapter and put the desired result in arrayList then because the tableadpter StudentCourses1 can't up date the dataset as contain multiple table so i use table studentCourses...

Posted to Data Access and ObjectDataSource Control (Forum) by semsem0 on 06-08-2007, 12:00 AM
Filed under: Query, sql, C#, Data Access, DataSet, ADO.NET
Using results of one query in another

I'm probably approaching this the completly wrong way but... I have one query which returns (hopefully) the key field of one table which I then want to add to an INSERT statement. It's an Access database, hence the ? instead of @ The first query is here: //selects register id for insertion below OleDbConnection...

Posted to Access Databases and AccessDataSource Control (Forum) by wibblet on 01-30-2007, 12:00 AM
Filed under: parameters, querystring, asp.net 2.0, C#, query
Random display query works as query but not on the page - ASP.Net - Visual Studio

Hi there I’m new to forum help so I hope can explain my problem to the best of my ability. Basically I have a data list view which is connected to an object data source. The object data source is a table adapter which has a query init(buitl witht he query builder). The query is stated below and when...

Posted to Getting Started (Forum) by teesel on 12-03-2009, 12:00 AM
Filed under: asp.net, query, ObjectDataSource, C#, visual studio, problem, random display query