Browse by Tags

Home ›

All Tags » Data » Insert (RSS)

Table Adapter Insert Problem

Hi Guys I am hoping someone kind person would help me out here, I a have just starting using tableAdapters but I am not quite confident just yet, although I have come a long way in the last few days and " Nights ", the problem I have is very simple I am sure, but I cannot solve it for the life...

Posted to Data Access and ObjectDataSource Control (Forum) by Web Design Devon on 06-13-2009, 12:00 AM
Filed under: Data, TableAdapter, TableAdapters, Table Adapter, DataSet, DataSet Access Parameter C#.NET 2.0, DataAdapter, Insert, Data Access Layer, DataAdapter DataTable SQL Server, DataRow, tableadapter dataset datatable, datatable.rows, dataadapter.fill(), insert datatable, database add records, Insert data, tableadapter passing parameter, data accesss layer, Insert Data Values into SQL Database
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
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
Re: How to insert a text to tab delimeted text file using asp.net or asp.?

Hi Thank you very much for the code. But how do I insert the below line as the tab delemeted to the very first row of the text file? | ------First Tab--------------------------------| |--Second Tab--| |-------------Third Tab-----------------------------------------------------------| TemplateType=ConsumerElectronics...

Posted to Data Access and ObjectDataSource Control (Forum) by SudhaYogesh on 09-11-2007, 12:00 AM
Filed under: .net, Asp.Net 2.0, Data, data Acces, Data Access, Data Access ASP.net vs. ASP, DataSource, Insert, Merge, ASP .NET 2