Browse by Tags

Home ›

All Tags » sql » Insert (RSS)

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
ExecuteScalar() Returns Null

Hi All, I'm trying to insert a new record into my SQL Server dataabse. The first column is an automatically-generated identity field. I want to retrieve the ID number of the new row when I add the record using, string NewID = command.ExecuteScalar().ToString(); For some reason, the ExecuteScalar...

Posted to Data Access and ObjectDataSource Control (Forum) by matmc on 07-03-2007, 12:00 AM
Filed under: sql, Insert, ExecuteScalar
Data insertion failure. Help much appreciated.

Hi everybody. I'm having difficulties with a button handler I put together from a few examples around the internet. Here's my code: <script runat="server"> Sub Add_To_Cart(ByVal Src As Object, ByVal Args As EventArgs) Dim FVArtikel_id As Label = FormViewDisplay.FindControl("Artikel_idLabel"...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Hao1981 on 01-03-2008, 12:00 AM
Filed under: ASP.NET, insert, SQL, Database, ASP.net vb, session, asp.net 2.0, .NET 2.0, insert multiple row values
Urgent Help needed: How to INSERT into a field having "UniqueIdentifier" data type

I am new at ASP.net and I am having problems inserting data using C# in ASP.net I have created a table named "Profile" in the MS sql server database named "MyDataBase". There is a field named "ID" that has data type 'uniqueidentifier'. I am confused how to INSERT...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by jadoon88 on 01-08-2008, 12:00 AM
Filed under: records, insert, sql, ASP.NET, C# 2005, Urgent, data access, uniqueidentifier, data entry
Re: trouble with insert query - date fields

Hi Jen, First, what is up with that single quote mark after @N? Did you want that to be enclosed in quotes because it's a string, or not? Also, when inserting dates into Access DBs you have to be careful with the formatting (yyyy-mm-dd vs dd-mm-yyyy) and ensure they are surronded with hash/number...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by djh on 03-10-2008, 12:00 AM
Filed under: insert, SQL, date, access database
Re: Between sql2005 db, tableAdapters, BLL and Codehinds, How do display data related error messages?

This is the code for the method in question: 1 [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, false )] 2 public MarketingContacts.OwnershipDataTable GetOwnershipByContactIdAndStaffDivId( int ContactId, int StaffDivId) 3 { 4 return GetOwnershipByContactIdAndStaffDivId...

Posted to Data Access and ObjectDataSource Control (Forum) by akuyali on 04-18-2008, 12:00 AM
Filed under: SQL ASP OBJECTDATASOURCE, DataAdapter Update, ObjectDataSource DataSet Multitable, sql, BLL, DataTable, C#, DataAdapter, Insert, DataSource, BLL DAL Tier Separation, ADO.NET data access, strongly typed datatable, insert datatable

Page 1 of 1 (6 items)

Advertise on ASP.NET

About this Site

Browse by Tags

Related Posts

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

ExecuteScalar() Returns Null

Data insertion failure. Help much appreciated.

Urgent Help needed: How to INSERT into a field having "UniqueIdentifier" data type

Re: trouble with insert query - date fields

Re: Between sql2005 db, tableAdapters, BLL and Codehinds, How do display data related error messages?