Home ›
All Tags » sql » data (RSS)

Browse by Tags

Related Posts

  • How to populate a table from a CSV File

    Using SQL Server 2005 Standard, Visual Studio 2008 Profession, ASP.NET 3.5, C#, ASP.NET AJAX. System Configuration: Web Server is a Virtual Server, Database Resides on a different server, also a Virtual Server (VMWare). I need users to be able to upload a file from their LOCAL machine. This file will...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bfancett on 12-30-2008, 12:00 AM
    Filed under: ObjectleDbDataReader, odbc, oldedb, sql, SQL 2005, SQL Data Adapter, SQL Datasets, sql server 2005, sql server 2005 stored procedure, SQL Server Stored Procedures, sql serverver reports, SQL TransactSQL Randomize Function, SqlDataAdapter, sqldatasource, SqlParameter, sqlreader, SQL-Server, stored procedure, stored Procedures, stringbuilder, Strongly Typed Datasets, strored procedures, table, table adapter, tables, Thanks, Thanks in Advace, Thanx, to a sql server database and how to retrive them, UPDATE, updating, Urgent Help needed, .NET 3.5, 2 column text field, add data, adding data, ADO.NET, ADO.NET 2.0, advanced, as.net 3.5, asp, 'ASP', asp .net 2.0, asp .net code, ASP .net.NET, ASP .net.NET Grid View, asp sql query customize datalist, ASP>NET, ASP.NET, asp.net c# sqlserver 2005 dataadapter querystring date comparison, asp.net 2.0 c#, asp.net 2.0 with c#, ASP.Net 3.5, c#, 'C#', C# 2005, c# code, c#.net, data, data access, data access layer, data entry, Data list, data mapping layer, data presentation, data repeater control, Data Set, data source, data tables, Dataa access, Excel to Sql-Server C# ASP.Net 2.0, fields, file upload, fileupload, insert, insert command, insert database sql, Insert new records, insert parameter value, insertion, InsertMode, LINQ Dynamic Data, LINQ SQL-to-LINQ DataGrid DetailsView, linq textbox query, LinqDataSource Linq, linq, ASP.NET3.5, ASP .net.net2, asp .net.net2.0, asp .net2.0, vs2008, SP, ASP .net ... c#, ASP .net ... c# ., asp .net ... c# ... SQL javascrpt, ASP .net ... c# 3.5, upload file, ASPNET SQL Server, excel C#, Sql Server, sqll, VS 2008, adding table data, ado.net designer dataset datatable datatableadapter designview gridview webforms bug, asp.net 2.0, C#. NET 2005, C#3.0, Data table, document, insert select, insert values, ASP .net ... c# ... javascript

  • Upload Excel File to SQL Server 2005 and Retrieve as link

    I want users to be able to upload an Excel file using the ASP.NET File Upload Control, have the file saved into a database table (which I have not created yet), and later on, based on an ID assigned to the file, retrieve it as a hyper link that when they click on it will open the file for them. I have...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bfancett on 12-19-2008, 12:00 AM
    Filed under: slq 2005, Slq Server, SQL, SQL 2005 SQL, Sql 2005 .NET, SQL 2005 ASP.NET, SQL Database design, SQL Server 2005, SQLL Serverr DTS, SQLServer, sqlserver 2005, SQLServer 2005SP2, sqLserver2005, sqlserverver, System.Array, varbinary, Visual Studio 2008, Visual Studio 2008 SP1, Web Project, "T-SQL", .NET 2.0, 2005, 2008, ADO.NET, asp.net 3.5, binary data, BLOB, c#, C# SQL, complex, convert, Data, data Acces, data access, data source, data storage, Database, DTS, DTS package, File Upload, files, LINQ Statement, LINQ toSQL, .NET SQL Server 2005, SQL 2005, SQL datatable, SQLServere2005, "SQL Server", .net 3.5, Linq, Store File to database, Stored procedures, ASP.NET C# sql, CSV, cvs, Data Type

  • 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

  • Catch a "cannot insert duplicate value" error

    Hi, I have a unique index in my database (as well as my primary key with ID). This prevents the user uploading files with duplicate names. However, I cannot work out a way to catch the error and present it in a user friendly way (ideally by displaying a small message 'this file already exists'...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by magicjoef on 09-30-2008, 12:00 AM
    Filed under: SQL, Data, Duplicate, insert

  • Preventing the same value being inserted into a database column twice

    Hi, I have created a form that inserts data into my mssql database. I would like to prevent one of the columns having duplicated date. Is there a way to check a column for a value and prevent the insert happening if the value already exists? I would need to prevent the whole row being added to maintain...
    Posted to Getting Started (Forum) by magicjoef on 09-25-2008, 12:00 AM
    Filed under: data, duplicate, insert, SQL

  • Can't find the error!!!???

    Anyone, I am just trying to do a simple insert, but can't figure out what the cause of my unhandled exception is. I am just trying to do a simple insert into a backend sql table. I'm using VB and sql '05. My codebehind calls this method in my Business Layer: Public Sub Insert( ByVal createdBy...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bcoffey on 09-12-2008, 12:00 AM
    Filed under: sql, sql insert query, Sql Parameters, Sql server 2000, sql server2005 ADO.NET, sql update management studio, 2.0, 3 tier applications, ASP VB Data, asp.net 2.0, Asp.Net 2.0, bll business layer objects, BLL DAL Tier Separation, BLL Data 3 tiers business logic DAL ObjectDataSource sql connection, DAL, Data, data Acces, Insert, Insert data, asp.net2.0, sql data control, ASP.NET 2.0 search multiple keyword term sql server express 2005, BLL, Data Access and ObjectDataSource Control, .net 2.0, DAL Provider Interfaces

  • help please, no matter what i do... Cannot insert the value NULL into column

    hello there. i need your help. i have a very simple insert form. but its not working... here is my html/aspx code: "C#" MasterPageFile= "~/gdMasterPage.master" AutoEventWireup= "true" CodeFile= "inserttest.aspx.cs" Inherits= "admin_inserttest" Title=...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by dj5000 on 07-20-2008, 12:00 AM
    Filed under: SQL, Data, null

  • Using Case Statement in Where clause for datediff function

    I am trying to use a case statement in my where clause to do a datediff so that when my close_date is null it will use getdate() instead of the close_date column. With the code poste below I receive the following error: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '>'. SELECT ...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by cgreene.gsu on 07-18-2008, 12:00 AM
    Filed under: slq 2005, SQL, SQL Server 2005, "T-SQL", case datetime, Data, DATEDIFF NULL, datediff sql sql2000 sql2005, DB NULL, getdate() SQL Server 2005, where, "Dynamic SQL", Select * from tablename where column1 = (), .NET SQL Server 2005, date sql, null, "SQL Server", null value column, "ASP.NET and SQL Server"

  • How to get membership related data row?

    Dear I'm working on a statistic data project where member data is saved into a row, which is currently identified with a uniqeId extracted from Membership .GetUser( HttpContext .Current.User.Identity.Name).ProviderUserKey Before I begin with developing, I just wanted to know if this is the right...
    Posted to Security (Forum) by zipfeli on 03-05-2008, 12:00 AM
    Filed under: data, MembershipUser ProviderUserKey, SQL

  • SQL Database to C# Variable

    Hi everyone I'm new to the forums. I have been browsing for awhile for answers and I've found most of them. I am still having a problem finding out how to take data from an SQL database and storing it in some variable in my C# code. I tried looking at how it is implemented in the Gridview, but...
    Posted to Getting Started (Forum) by era86 on 11-16-2007, 12:00 AM
    Filed under: SQL, c#, Data, data access, variable
Page 1 of 3 (22 items) 1 2 3 Next >

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.