C# - Inserting Row Into Table With Auto Increment Value?

Mar 23, 2011

I got a table PartsMedia where I can insert all the images related to a product. The table has the columns :

PartsMediaID , auto-increment

I want to insert a complete row with automatic increment and the PartsNo should be the same as the PartsNo from the PartsMaster table.

The medialink should be the PartsNo + '-2.jpg'
The mediadescription is for example 'image2'
The CatalogCode should be 'catalog'
and the sorting code should be '0'

From The partsMaster table I Just need the PartNo So I can add this to the PartMedia Table. The PartNo is the foreign key in the PartMedia table.

The following I got so far but no luck

insert into dbo.PartsMedia (PartNo,MediaLink,MediaDescription,CatalogCode, SortCode)
values (dbo.PartsMaster.PartNo, PartsMaster.PartNo+'-2.jpg','image2', 'catalog','0')

View 3 Replies

Similar Messages:

ADO.NET :: Get Auto Increment Field After Inserting?

Dec 6, 2010

I'm adding a couble of fields to database but i need the primary key of the master table to add it to sub table.

The database contains 2 tables :

Question Table :questionID(primary key and identity) , questionInText

Answer table : answerID , answer1,answer2 , questionID

code used to insert to db :


questionID is auto increment.

The question is : How i get questionID after adding to database without using sql statment ?

View 1 Replies

How To Auto Increment Field Value After Inserting To Database

Dec 6, 2010

i'm working on my first project on asp.net using c#.

I'm adding a couble of fields to database but i need the primary key of the master table to add it to sub table.

The database contains 2 tables :

Question Table :questionID(primary key and identity) , questionInText

Answer table : answerID , answer1,answer2 , questionID

code used to insert to db :


View 1 Replies

DataSource Controls :: Get Next Auto Increment Value From Table?

Apr 28, 2010

i have a question, suppose i have a table 'tblImage' which have 3 rows of data and my auto increment is not +1.

imageId imageName
1 a.gif
2 b.gif
4 c.gif

i want to query '2' using LINQ C# to the table in MS SQL and show the record which i have done easily BUT now i want to get the next auto incremented value to make Next button on the sane web form, which is in this case is '4' and i also want the previous imageId as well.

View 5 Replies

SQL Server :: How To Auto Increment Alphanumeric Primary Key In Database Table

Sep 30, 2010

auto increment alphanumeric primary key(eg :ABC001) in sql server 2005 database table.

View 2 Replies

DataSource Controls :: Obtain Inserted Table Row Identity With An Auto Increment Key

Feb 18, 2010

I am using LINQ to store and retrieve data from tables with a clustered index key. However, I also need to know how to obtain an inserted table row identity with an auto-increment Primary key. The "Go To Definition" feature for my data context of dataClassesDataContext provides the following information:

public partial class DataClassesDataContext : System.Data.Linq.DataContext

I am asking for the C# code that is needed in a button click event handler that will insert a row of data in a table named "Fields". It only consists of an auto-incrementing primary key column (FieldID), a string column (Phrase) and a null defaulted variable column.

View 3 Replies

Auto Increment The Record Number?

Apr 29, 2010

i am using one text box in New registration page. when ever user clicks on New registration button, The text box of record number should be auto incremented.

View 12 Replies

Auto Increment Feature In Database?

Nov 2, 2010

I use SQL Server and when I create a new table I make a specific field an auto increment
primary key. The problem is some people told me making the field an auto increment for the primary key means when deleting any record (they don't care about the auto increment field number) the field increases so at some point - if the type of my field is integer for example - the range of integer will be consumed totally and i will be in trouble.

So they tell me not to use this feature any more.The best solution is making this through the code by getting the max of my primary key then if the value does not exist the max will be 1 other wise max + 1.Any suggestions about this problem? Can I use the auto increment feature?I want also to know the cases which are not preferable to use auto increment ..and the alternatives...note :: this question is general not specific to any DBMS , i wanna to know is this true also for DBMSs like

View 6 Replies

Web Forms :: Auto Increment Of Primary Key Which Is Varchar?

Sep 21, 2010

i was given a form in which empid is varchar and i m supposed to auto increment it using a function and calling it ....i have never done this. plz help me out the way .

View 9 Replies

SQL Server :: How To Add A Fixed Value To Auto-increment Primary Key

Jan 1, 2011

If its posible I want to create a table with a primary key with auto-increment and a fixed value to differentiate the table from others tables


table 1 | table 2
a1 |b1
a2 |b2
a3 |b3

View 6 Replies

SQL Server :: Auto Increment Column In SQL View

Oct 23, 2010

show me what is the syntax to add an increment column to Select Query? There will be additional column which goes 1,2,3 ... n.

View 3 Replies

SQL Server :: T-SQL Set Identity Seed On Auto Increment +1?

Nov 20, 2010

I have stored procedure where i am creating table and setting primary key how to set auto increment ?

set @sql =@sql +
'CONSTRAINT [PK_'+@Table+']

View 4 Replies

SQL Server :: Failing Insert When Using Auto Increment?

Aug 6, 2010

I am trying to set up an insert command in vb for sql server (not mysql). the following works fine as long as I manually enter a new ASSalesId and don't have this field auto increment. this field is set up a a primary key. I would like to just use auto increment on this field. but every time I set the field to auto increment the insert fails. if I just remove the reference to this field from the statement the insert fails.

Sub SQLDatabaseEntry()

View 4 Replies

Web Forms :: Auto Increment Using Stored Procedure

Oct 1, 2012

I want an auto increament using stored procedure how can I do this process. I want a reference number in this procedure ...

ALTER PROCEDURE [dbo].[Emp_Detail] (

@Name varchar(max),
@Emp_No varchar(50),
@Job_Title varchar (max),
@Nationality varchar(50),
@Administration varchar(50),

[Code] ....

View 1 Replies

DataSource Controls :: Getting An Auto-increment Field To Work In SQL

Feb 11, 2010

I'm trying to get an IDENTITY column to auto-increment with each new row inserted, so that the field (userid in this case) can be used as a unique identifier.

However, I'm getting this error:


My code looks like this:


I don't understand - if I have to explicitly insert something into my auto-increment column, how do I know what to insert? Isn't the point of an auto-increment column that it's... auto?

View 7 Replies

Forms Data Controls :: Auto Increment The Value Of Boundfield?

Jan 17, 2011

How can I autoincrement the value of a boundfield column in a gridview ?

View 2 Replies

Data Controls :: Insert Using GridView Into Auto Increment Field

Apr 1, 2013

I have a gridview with the serial no , I want to increment the serial no automatically when i insert new row

How can i ?

View 1 Replies

Forms Data Controls :: Hide Auto Increment Values In Chart Control?

Dec 14, 2010

i am using asp.net chart control, problem i am facing is that it automatically generates values in Y-Axis.

As you can see in image , values 0, 3 and 4 are automatically generated. how to hide these automatic generated values.

View 1 Replies

Auto Generate Number In Asp.net Which Is Auto Add In Sql Server Table With Other Data?

Mar 25, 2011

I have project in asp.net with sql server backend.i want to auto generate a number for particular column.with the auto generated number i want to insert some other data in the same row same table. on button click event.details

railway PNR no.:- want to autogenerat
passenger details:- want to inserted simultaneously

View 2 Replies

Web Forms :: How To Auto Delete And Auto Create Table Data

Jun 6, 2010

I have a simple online web system where it possible for the visitors to "play around" with the system. They can like create categories and products and so forth. Everything they create are stored into a database.

What I want is to be able to reset this database with my default values (table data) every n hours.

So for example if we have a bunch of users that have played with the system and created new things. Then I want to be able to make some kode that deletes all data in the tables in this database and fill it with default data. The default data can come from a backup file, or another database with same tables structure or whatever.

I want this task to be done every day at 12 pm or every n hour.

Is this possible (by forexample scheduled webservice tasks or just something as long as it is simple).

View 8 Replies

ADO.NET :: How To Display Auto - Incrementing Value From Database In The Same Page Where Inserting Value

Feb 8, 2011

in my aspx page user is creating a request and when the request is created a request_id is generated automatically in databse..i want to retreive tht particular request_id and display it on the same web page.

here is my code-

protected void Button1_Click(object sender, EventArgs e)
String selection = DropDownList1.Text.ToString();
String status = "inactive";
ConnectionStringSettings set = ConfigurationManager.ConnectionStrings["WATERMARKING"];
String cns = set.ConnectionString;
SqlConnection cnn = new SqlConnection(cns);
String query = "Insert into REQUESTS (USERNAME,REQUEST_TYPE,STATUS) values ('" + uName + "','" + selection + "','" + status + "')";
SqlCommand cmd = new SqlCommand(query, cnn);
//Response.Write("Request created Successfully ");
//MessageBox.Show("request created successfully");
Label4.Text="request created successfully";
Label5.Text = "Your Request ID is";
Label6.Text = "ID required to Check the Request Status";
catch (Exception err)
//Response.Write("error generated while raising request"+err);
Label4.Text = "request creation error"+err;

here wen a value is getting inserted in REQUESTS table a column named REQUEST_ID gets populated and i want to display that value on the web page

View 7 Replies

Forms Data Controls :: Error When Inserting Into Table - Cannot Insert Explicit Value For Identity Column In Table

Aug 11, 2010

I am working on a web app for an online photo album. It is the last project in Scott Mitchell's book: "ASP.Net 2.0 in 24 hours".

I am creating a page where users can enter new photo images. The functionality for uploading an image will come later. I am working on just inserting a new row into the Pictures table with an optional category, a required title and a required description.

I am getting an error when I try to insert a new row.

Here is a screenshot of the page with a shot of the dropdown list.

The Categories are user-specific. I am getting the correct values retrieved.


There are two pretty simple database tables involved here.

NOTE: The CategoryID and PIctureID are both autoincrement integer columns.


The page uses a DetailsView that uses a SqlDataSource that uses the Pictures table. (The DetailsView's Default Mode property is set to "Insert". The "Enable Inserting" checkbox is also checked.)

The dropdown list uses a dropdown control that uses a SqlDataSource that uses the Categories table.

When the "Insert" button is clicked the CategoryID value associated with selected (Category) Name on the dropdown list will be used along with the Title and Description values to insert a row in to the Pictures table. (If no Category value is selected, then a null value will be used for the CategoryID. This is OK because the CategoryID column in the Pictures table allows nulls.)

My problem is that I am getting this error:

Cannot insert explicit value for identity column in table 'Pictures' when IDENTITY_INSERT is set to OFF.

(FYI: I have the full version of both Visual Studio and SQL Server.)

Here is my source code for the page:


View 3 Replies

Data Controls :: How To Set Auto Incremented ID Field In XML File While Inserting Data

Nov 20, 2013

there is 2 pages the first page include gridview its fill from xml file and there is button (Called add new student) when i click on this button its arrive me to second page and the second page inckude 5 Text box if to add new student.

** the problem with the ID of new student its can be show on the head page like this (http://localhost:57175/gridvieww/Default2.aspx?ID=8) i want head the ID number i am using query string now i want code to find the last node in xml and then increment +1.this is my code 

XML code 



View 1 Replies

ADO.NET :: Inserting Data Table Into SQL

Oct 8, 2010

Is there an easier way to insert the values contained in a data table generated in ASP into a SQL table without having to loop through all the rows in the data table and insert individually into the SQL table?

View 4 Replies

ADO.NET :: Inserting Dataset Into Sql Table?

Dec 29, 2010

I need some basic guidance on how I can get my Dataset to insert into a single table instead of sending it to a datagrid.

I get the following columns from DS.Tables["ItemAttributes"]:





I get the following columns from DS.Tables["Item"]:





Item_Id from DS.Tables["Item"] and DS.Tables["ItemAttributes"] are the same

So I would like to insert the data into a table named amaz with columns as follows






My DataSet is fetched using the following code, There can be upto 10 rows in the dataset


View 7 Replies

Copyrights 2005-15 www.BigResource.com, All rights reserved