cmd.Parameters.Append cmd.CreateParameter("CLASS_CODE", adNumeric, adParamInput, 6, Val(txtSpareCode))

Private Sub SaveBranchProcedure()

Dim cmd  As New ADODB.Command

 "select max(centreid) from regionmaster where centreid like '" & intBranchPrefix & "%'", DBConnection, adOpenKeyset, adLockOptimistic
         If rsMain.RecordCount > 0 Then
            intID = Mid(rsMain(0), 3, 13)
        End If
         intCentreID = intBranchPrefix & (intID + 1)

DataService myservices = new DataService();
    protected void Page_Load(object sender, EventArgs e)
    {

<%@ Master Language="C#" AutoEventWireup="true" CodeFile="submaster.master.cs" Inherits="submaster"

   string  title = Convert.ToString

private string GetSelected()
    {
        // Initially set the values to Blank 
        h_chkSelected.Value = "";

        foreach (GridViewRow di in GridView1.Rows)
        {
            HtmlInputCheckBox chkBx = (HtmlInputCheckBox)di.FindControl("chkBoxId");

            if