How to autogenerate empid with string?

Question

i am using vb.net2005 and ms sql server2005 i want source code for autogenerate the empid in my table . for example' sb1001'

Answer 1

The simplest answer to your question is:

      For x As Integer = 0 To dt.Rows.Count - 1
        dt.Rows(x)("emp_id") = "sb" & x
      Next

dt represents your datatable