Home ›
All Tags » database » sql (RSS)

Browse by Tags

Related Posts

  • 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

  • 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

  • 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

  • Inserting a new record into sql db using user-entered information

    Im trying to add a new rcord to my db on a button click usign the following code 'data adapter Dim dAdapt1 As New SqlClient.SqlDataAdapter 'create a command object Dim objCommand As New SqlClient.SqlCommand 'command builder Dim builderT As SqlClient.SqlCommandBuilder 'connection string Dim cnStr As String...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by rox163 on 11-22-2006, 12:00 AM
    Filed under: ASP.NET, Microsoft SQL Server 2005, Connection String, .NET SQL Server 2005, insert, SQL, Database

  • Not getting any data

    Hello I am not really new to ASP.NET but I am building my first site at my new job. I just built the computer that I will be developing on. I have XP Pro, SQL server 2000, and visual studio 2005 with AJAx extensions. I created a web app and put a datagrid on the default.aspx page. I created a connection...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by jgsteeler on 12-12-2006, 12:00 AM
    Filed under: table lookup, sql stored procedure, ASP.NET, .NET SQL Server 2000, Connnection String, Connection String, SQL, Database

  • Re: Saving images from formview

    Ok, so i have now managed to save the image into my 'Images' folder on my server from a FormView. Now all i need to do is save the images url into my ms sql 2005 database. Does anybody know what datatype these images should be saved too and how i go about the coding behind it in c# and asp.net2.
    Posted to Data Presentation Controls (Forum) by copperchair32 on 02-02-2007, 12:00 AM
    Filed under: FormView, database, c#, sql, formview template insert

  • Pull content from SQL based on url query string

    I am trying to pull content into a content page (within a master page) by using url query strings. I have got the code to pull the query string in and it is working fine. I am having trouble creating my sql Select Command using a variable. My sql Select Command works fine if I hard code it - I am just...
    Posted to Data Presentation Controls (Forum) by timwilson on 02-07-2007, 12:00 AM
    Filed under: database, sqldatasource, asp.net 2.0, datasource, data access layer, data, sql, VB, querystring, dataitem

  • Performance tips for Database access

    1.Use Stored Procedures whenever possible stored procedures are highly optimized tools that result in excellent performance when used effectively. 2.Use the Optimal Managed Provider Make the correct choice of managed provider, rather than relying on a generic accessor. 3. Pick Data Reader over Data Set...
    Posted to Tips & Tricks (Forum) by swap on 02-09-2007, 12:00 AM
    Filed under: SQL, ADO.Net, Performance, Access, Database

  • Pull between 2 dates from user input

    I want to pull dates from my database that are between to set dates i have written a query that does this which looks like this: "SELECT OCH_ID, empno, Selected_OCD, Start_Time, End_Time, Selected_OCDay, Selected_DOM, Selected_Month, Selected_Year FROM dbo.ICT_On_Call_Hours WHERE (CONVERT (datetime,...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Dazza22 on 02-14-2007, 12:00 AM
    Filed under: ASP.NET, SQL, Database, sql Query
Page 1 of 4 (34 items) 1 2 3 4 Next >

Advertise on ASP.NET

About this Site