how to auto increment a varchar column value in C#

Question

I want to auto increment a column value like P1,P2,P3.......and so on in windows C#

Satyapriya Nayak · Answer

It is a label control Run the attachments.

Gopal Mahadak · Answer

First Add & then Delete the Record..

Mustaq Khan · Answer

Actually I have a problem.....When a record is deleted and when a new record is inserted its ID is the same as the previous record...So please tell me what to do...????

Mustaq Khan · Answer

Thank You Buddy......!!!

Mustaq Khan · Answer

Can you please explain the code......??? what is lbl_castecode

Satyapriya Nayak · Answer

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Dynamic_generate_id { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; string str; int count; public Form1() { InitializeComponent(); } private void btn_save_Click(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "insert into caste(cast_code,cast_desc) values('" + lbl_castecode.Text.Trim() + "','" + txt_castename.Text.Trim() + "')"; com = new OleDbCommand(str, con); com.ExecuteNonQuery(); con.Close(); MessageBox.Show("Records successfully Inserted"); txt_castename.Text = ""; autogenerated(); } private void autogenerated() { OleDbConnection con = new OleDbConnection(ConnectionString); str = "select count(*) from caste"; com = new OleDbCommand(str, con); con.Open(); count = Convert.ToInt16(com.ExecuteScalar()) + 1; lbl_castecode.Text = "P" + count.ToString(); lbl_castecode.Enabled = false; con.Close(); } private void Form1_Load(object sender, EventArgs e) { autogenerated(); } } }