Browse by Tags

Home ›

All Tags » sql » help (RSS)

SQL Columns Will not appera in my Grid. ???

Hi, Most times I load my gridview with data from a database trough a Stored Procedure. This is my procedure: 1 Select SUM (korting) as Totaal_korting, ( SUM (korting)-( SUM (bedrag))) as totaal_betalen, 2 CASE 3 WHEN ( SUM (korting)-( SUM (bedrag)))=0 THEN 'Te Ontvangen' 4 WHEN ( SUM (korting...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bakoven on 08-12-2008, 12:00 AM
Filed under: SQL, SQL 2005 ASP.NET, sql queries, sql Query, sql stored procedure, "store result" " variable on Stored Procedure" "Stored Procedure", asp .NET 2.0 SQL data sqldataadapter, help, gridview, queries, ".NET 2", "ASP.NET and SQL Server"
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Urgent Please help me| Admin Please rush it thanks a lot

I've just posted mywebsite andthis error keep being trhrown as soon as I access the DB I dont understand what is going on and if I dont get it working bu today will delivery date will expire and I will get in trouble... So anyone knows what is going on It says the following: An error has occurred...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by norchnou on 04-04-2008, 12:00 AM
Filed under: SQL, SQL Server 2005, data access, Database, help, error database
DetailsView and GridView for Beginners

I have a SqlDataSource attached to both views, and am trying to select one row with GridView, and then edit it in DetailsView. I have the proper buttons in place, but the select buttons are only sticking with the first row, therefore only allowing the first row to be edited. I am also trying to find...

Posted to Getting Started (Forum) by thasard on 10-18-2007, 12:00 AM
Filed under: SQL, sqldataSource, beginner, C#, C# 2.0, Detailsview, help, help me, grid view, gridview, Beginner Book, button
Multiple Filters & Mulitple Options

First post, go easy on me. I have a table with 3 fields I need to filter with, ClientName(text), Status(text), LocationID(int32). I can create a where statement that filters all three, when there is a selection for each one. However, what I need is for the user to be able to pick and choose. Not having...

Posted to Data Access and ObjectDataSource Control (Forum) by cush on 10-30-2006, 12:00 AM
Filed under: ObjectDataSource DataSet Multitable, sql, SQL ASP OBJECTDATASOURCE, ADO.NET Tutorial, Columns, Data, Data Access, Database, Help
Strongly Typed DAL and Filtered Searching

Hey All, I have built a Strongly Typed DAL for a system I am working on and I am trying to add filtered searching to it. Example: Before I put the Strongly Typed dataset in place I had a class file that made all the calls to the database/stored procedures. To accomplish this I simply added to the SQL...

Posted to Data Access and ObjectDataSource Control (Forum) by Matthews on 10-24-2006, 12:00 AM
Filed under: sql, TableAdapter, TableAdapters, DAL, Data Access, Database, Help