01.
private
void
eadd_Click(
object
sender, EventArgs e)
02.
{
03.
System.Data.OleDb.OleDbConnection conn =
new
System.Data.OleDb.OleDbConnection();
04.
string
strCon = @
"Provider=Microsoft.ACE.Oledb.12.0;Data Source=C:\project_one\medicine.accdb"
;
05.
conn.ConnectionString = strCon;
06.
conn.Open();
07.
08.
string
sql;
09.
StringBuilder sb =
new
StringBuilder();
10.
sb.Append(
"select mid(max(emp_id),4,6) from emps"
);
11.
sql = sb.ToString();
12.
OleDbDataAdapter empDA =
new
OleDbDataAdapter(sql,conn);
13.
DataSet empDS =
new
DataSet();
14.
empDA.Fill(empDS,
"emp"
);
15.
DataTable tbl_emp =
new
DataTable();
16.
DataRow tblR_emp = tbl_emp.NewRow();
17.
18.
19.
if
(DBNull.Value ==
null
)
20.
{
21.
string
id;
22.
id=(DateTime.Now.Year+543).ToString()+
"00001"
;
23.
}
24.
else
25.
{
26.
string
stRef1 =
"E"
+(DateTime.Now.Year + 543 - 2500).ToString();
27.
string
NextId = stRef1 +
"00001"
;
28.
string
ids;
29.
ids=empDS.Tables[
"emps"
].Rows[0][
"emp_id"
].ToString();
30.
if
(ids.IndexOf(stRef1) >= 0)
31.
{
32.
int
n=Convert.ToInt32(ids.Substring(stRef1.Length))+1;
33.
NextId = stRef1 + n.ToString(
"00000"
);
34.
textBox1.Text = NextId;
35.
}
36.
textBox1.Text = NextId;
37.
}
38.
}