ASP.NET

string text1 = "";
    string text2 = "";


 private void insertfiles()
    {

        foreach (RepeaterItem item in Rptdescription.Items)
        {
            TextBox txt1 = (TextBox)item.FindControl("TextBox1");
            TextBox txt2 = (TextBox)item.FindControl("TextBox3");
            text1 += txt1.Text + "|";
            text2 += txt2.Text + "|";
       }
                    
        foreach (string split2 in text2.Split('|'))
        {
            stringList.Add(split2 + "<br/>");
            SqlConnection SqlCnn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
            SqlCommand SqlCmd = new SqlCommand();
            SqlCmd.Connection = SqlCnn;
            SqlCnn.Open();
            SqlCmd.CommandText = "insert into test(test,id) values(@test,1)";
            SqlParameter DataBaseID = new SqlParameter("@test", SqlDbType.NVarChar, 50);
            DataBaseID.Value = stringList.Add(split2);
            SqlCmd.Parameters.Add(DataBaseID);
           
            SqlCmd.ExecuteNonQuery();
            SqlCnn.Close();
            Bindrepeater();
        }
   //ignore syntax errors

Private Sub BtnApp_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnApp.Click
    Response.Redirect("form_frameset.aspx?sno=&page=UserApplication&keyid=&keyinfo=All")
End Sub

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
        Dim page As String = Request.QueryString("page")
        Dim keyid As String = Request.QueryString("keyid")
        Dim keyinfo As String = Request.QueryString("keyinfo")
MyConn = New OdbcConnection(Session("sybase_constr"))
        Dim SelectCmd As OdbcCommand
If page = "UserApplication" Then
            Dim sqlstring As String
            If keyinfo = "All" Then
                sqlstring = "Select  ug.UserID,u.firstname, fg.GroupID, g.GroupDesc, f.FunctionID,f.FunctionDesc from EACS_Function f,  EACS_UserGroup ug,  EACS_FunctionGroup fg, EACS_Group g, EACS_user_1 u where   f.ApplicationID='" & keyid & "' and fg.FunctionID = f.FunctionID and fg.GroupID = ug.GroupID and ug.userid =  u.userid and fg.GroupID = g.GroupID order by ug.UserID"
            End If
            SelectCmd = New OdbcCommand(sqlstring, MyConn)
Dim DS As DataSet
        Dim MyCommand As OdbcDataAdapter
        MyCommand = New OdbcDataAdapter(SelectCmd)
        MyConn.Open()
DS = New DataSet
            MyCommand.Fill(DS)
Dim i As Integer
        i = 0
If page = "UserApplication" Then
            If DS.Tables(0).Rows.Count > 0 Then
                InsertPageBreak()
                InsertAppUserHeader()
                For i = 0 To DS.Tables(0).Rows.Count - 1
                    PopulateAppUsrRow(DS.Tables(0).Rows(i)(0), DS.Tables(0).Rows(i)(1), DS.Tables(0).Rows(i)(2), DS.Tables(0).Rows(i)(3), DS.Tables(0).Rows(i)(4), DS.Tables(0).Rows(i)(5))
                Next
            Else
                Response.Write("<script language=javascript > alert('Sorry no records found'); </script>")
            End If


Private Sub PopulateAppUsrRow(ByVal Usrid As String, ByVal Usrname As String, ByVal Grpid As String, ByVal Grpdsc As String, ByVal Fncid As String, ByVal FncDsc As String)

        Response.Write("<tr><td align=left>" + Usrid + "</td><td align=left >" + Usrname + "</td><td align=left >" + Grpid + "</td><td align=left >" + Grpdsc + "</td><td align=left >" + Fncid + "</td><td align=left >" + FncDsc + "</td></tr>")
    End Sub
Private Sub InsertPageBreak()
        Response.Write("</table></font><br style='PAGE-BREAK-BEFORE:always'>")
    End Sub
Private Sub InsertAppUserHeader()
        Response.Write("<font face=Arial ><table cellspacing=0 width=95% border=1 ><tr><td colspan=10 align=center ><b>Abu Dhabi Islamic Bank. <br> Application Management System.  </b></td></tr>")
        Response.Write("<tr><th align=center>User Id</th><th align=center >User Name</th><th align=center >Group Id</th><th align=center >Group Description</th><th align=center >Function Id</th><th align=center >Function Description</th></tr>")
    End Sub

                             National Bank. 
                      Application Management System.  
User Id   User Name   Group Id   Group Description   Function Id  Function Description 
000120   Hassan Sid   AMS01     Complete AMS      A004     User 
000120   Hassan Sid   AMS01     Complete AMS      A002     Group 
000120   Hassan Sid   AMS01     Complete AMS      A012     Reports 
000120   Hassan Sid   AMS01     Complete AMS      A003     Functions 
000120   Hassan Sid   AMS01     Complete AMS      A007     Group/User 
000120   Hassan Sid   AMS01     Complete AMS      A001     Application 
000120   Hassan Sid   AMS01     Complete AMS      A011     Audit Trial 
000120   Hassan Sid   AMS01     Complete AMS      A005     Group/Function 
000120   Hassan Sid   AMS01     Complete AMS      A009     Synchronise Users 
000120   Hassan Sid   AMS01     Complete AMS      A006     Special Group/user 
000120   Hassan Sid   AMS01     Complete AMS      A010     Pending for Approval 
001155   Ehab         AMS01     Complete AMS      A004     User 
001155   Ehab         AMS01     Complete AMS      A002     Group 
001155   Ehab         AMS01     Complete AMS      A012     Reports 
001155   Ehab         AMS01     Complete AMS      A003     Functions 
001155   Ehab         AMS01     Complete AMS      A007     Group/User 
001155   Ehab         AMS01     Complete AMS      A001     Application 
001155   Ehab         AMS01     Complete AMS      A011     Audit Trial 
001155   Ehab         AMS01     Complete AMS      A005     Group/Function 
001155   Ehab         AMS01     Complete AMS      A009     Synchronise Users 
001155   Ehab         AMS01     Complete AMS      A006     Special Group/user