How to autogenerate empid with string?

i am using vb.net2005 and ms sql server2005 i want source cod开发者_JS百科e for autogenerate the empid in my table . for example' sb1001'

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