Browse by Tags

Related Posts

  • Updating Sql DB. My code compiles, but doesn't update.

    C#, Webforms, VS 2005, SQL Hi all, quick hit question. I'm trying to update a table with an employee name and hire date. Session variable of empID, passed from a previous page (successfully) determines which row to plop the update into. It's not working even though i compiles and makes it all...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Corby on 09-15-2006, 12:00 AM
    Filed under: sql, update
  • New Paging Alternative....

    While working with the Gridview control enhancements I decided to see if there was some new features of SQL 2005 I could use... Check out my latest article on Http://tech-review.org which covers how to use SQL optional paramaters, Row_Number(), and how to dynamically control whether or not you bring...
    Posted to Community Starter Kit (Forum) by jodywbcb on 09-20-2006, 12:00 AM
    Filed under: SQL, optional parameters, Paging, Datasets, ROW_NUMBER(), custom, GridView
  • will sqlcommand be realeased from memory in a using block?

    My question is this. Do I need to use the line in green or does the Using command dispose of the sqlCMD object as well as the cn object? 'Maleki: Have fun use it but give credit if you do. =:) Private Function WhoIsYourDady(ByVal intID As Integer) As String Dim strReturn As String = ""...
    Posted to Data Access and ObjectDataSource Control (Forum) by Maleki on 10-05-2006, 12:00 AM
    Filed under: sql, Database, VB.Net
  • Re: tableAdapter Headaches. I need help

    It seems nobody wants to help. I am completely stuck and I need help. All I want is to be able to use my tableadapter and its insert method to insert data into my database ORDER table. my problem is using the tableadapter and my insert method to get the values of my textbox fields and dropdownlistbox...
    Posted to Data Access and ObjectDataSource Control (Forum) by derry1406 on 10-13-2006, 12:00 AM
    Filed under: sql, TableAdapter, TableAdapters, Database
  • Re: Typed DataSet tool doesn't like temp tables!??

    I've found 2 possible solutions. 1.) temporarily change your stored procedure to select the columns you would like to see in the data table (what you see when you open the xsd file). Example: SELECT 0 as [CustomerID], 'some text' as [CustomerName] FROM Customer Comment out the SQL that created...
    Posted to Data Access and ObjectDataSource Control (Forum) by dotcarlisle on 10-13-2006, 12:00 AM
    Filed under: Data, sql, ADO.NET Tutorial, VB.Net
  • Install Fails at SQL Express - RATS!

    First part of .NET Express install went fine. Visual Web Developer 2005 Express work good ... BUT! Attempting to install - SQL Server 2005 Express Edition - Get Error The SQL Server System Configuration Checker cannot be executed due to WMI configuration ERROR: 2147942402 Researched above issue and found...
    Posted to Installation and Setup (Forum) by FlashSand on 10-23-2006, 12:00 AM
    Filed under: SETUP EXPRESS EDITION, System.Security.SecurityException, SQL, WMI, DCOM
  • 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: Help, sql, TableAdapter, TableAdapters, DAL, Data Access, Database
  • Re: @@identity

    After you do an insert you can return the key for the insert like: INSERT INTO [dbo].[table] ( name , phone) VALUES ("Denny", "555-1234") Return @@IDENTITY Also be sure to read on the differences of SCOPE_IDENTITY() and @@IDENTITY - to be sure which one you should use to return the...
    Posted to Getting Started (Forum) by SuperGhost on 10-27-2006, 12:00 AM
    Filed under: SQL, @@IDENTITY, Scope_Identity
  • 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: Data, Help, SQL ASP OBJECTDATASOURCE, ObjectDataSource DataSet Multitable, sql, ADO.NET Tutorial, Data Access, Columns, Database
  • complex dynamic query - best practice/approach?

    I'm coding something pretty common - using form input to create a dynamic database query and displaying the results. However, some of the form controls are multi-select boxes, so my query winds up containing a lot of loops and looking pretty messy. Any suggestions/example code on the best approach...
    Posted to Getting Started (Forum) by lcountee on 10-31-2006, 12:00 AM
    Filed under: SQL, query, loop
Page 1 of 34 (334 items) 1 2 3 4 5 Next > ... Last ยป