ASP.NET

Sub Page_Load()

        Dim myMDBConnection As OleDbConnection = New OleDbConnection(ConfigurationManager.ConnectionStrings("Register").ToString().Trim())
        myMDBConnection.Open()
        'do stuff here
        myMDBConnection.Close()
    End Sub


    Protected Sub CreateUser_Click(ByVal sender As Object, ByVal e As System.EventArgs)

        Dim conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\myDatabase.mdb;")
        Using conn

            Dim Sql As String = "INSERT INTO userlist (username,password, strEmail) VALUES (@username,@password, @strEmail)"
            Dim cmd As New OleDbCommand(Sql, conn)
            conn.Open()
            cmd.Parameters.AddWithValue("@username", username.Text)
            cmd.Parameters.AddWithValue("@password", password.Text)
            cmd.Parameters.AddWithValue("@strEmail", strEmail.Text)
            cmd.ExecuteNonQuery()
            conn.Close()

        End Using
    End Sub

End Class

<?xml version="1.0"?>

    <configuration>
      <connectionStrings>       
          
            <add name="Register" providerName="Microsoft.Jet.OLEDB.4.0;" 
                 connectionString="C:\myDatabase.mdb;" />
     
          </connectionStrings>
     </configuration>

<configuration>
  <connectionStrings>

    <add name="ConnStr" connectionString="Data Source = inayat; Initial Catalog = KIU; User ID=sa; Password=jan5562"/>
  </connectionStrings>
    <system.web>
        <compilation debug="true" targetFramework="4.0"/>
    <authentication mode="Forms">
      <forms name="KIUAuth" loginUrl="login.aspx" protection="All" path="KIUAuth/" timeout="30" slidingExpiration="true"/>
    </authentication>
    </system.web>
</configuration>

The type or namespace name 'Optimization' does not exist in the namespace 'System.Web'
The type or namespace name 'DotNetOpenAuth' could not be found

GridViewRow row = AdminSearchGridView.Rows[index]

<asp:GridView ID="AdminSearchGridView" runat="server" AutoGenerateColumns="False"
Style="color: #333333; border-collapse: collapse; font-size: 14px; 
text-align: center;width: 1530px; margin-left: 0px; margin-top: 0px" CellPadding="4" ForeColor="#333333"
AutoGenerateDeleteButton="True" DataKeyNames="ID" OnRowDeleting="AdminSearchGridView_RowDeleting"
OnRowCommand="AdminSearchGridView_RowCommand">
<AlternatingRowStyle BackColor="White" />

     <Columns>
<asp:ButtonField ButtonType="Button" Text="Issue" CommandName="Issue" />
 <asp:BoundField DataField="IssueStatus" HeaderText="Issue Status" />
 <asp:BoundField DataField="AccessionNo" HeaderText="Accession Number" />
 <asp:BoundField DataField="CallNo" HeaderText="Call Number" />
 <asp:BoundField DataField="Title" HeaderText="Title" />
    </Columns>
    </asp:GridView>

protected void AdminSearchGridView_RowCommand(object sender, GridViewCommandEventArgs e)
  {
   if (e.CommandName == "Issue")
      {
        int index = Convert.ToInt32(e.CommandArgument);

 GridViewRow row = AdminSearchGridView.Rows[index]; // INDEX OUT OF RANGE ERE

 string accessno = AdminSearchGridView.Rows[index].Cells[3].Text;
 string title = AdminSearchGridView.Rows[index].Cells[5].Text;
                

       Session["accessno"] = accessno;
       Session["title"] = title;
             }
         }