hello.In my projet, i have to enter new teachers and their information to my database.The form used for this action containd checkBox & radio bottum.I wrote a code but it dosn't working.All i wan't to do, is to add row to table & delete Row from Table.Thats mean Add or delete a teacher from my database.

My code:

Dim Nom, Prenom, CapitalInitial As String
        Nom = txtnom.Text
        Prenom = txtprenom.Text
        CapitalInitial = StrConv(Nom, VbStrConv.ProperCase)
        CapitalInitial = StrConv(Prenom, VbStrConv.ProperCase)

        Dim NewRow As DataSet1.ProffesseurRow
        NewRow = DataSet11.Proffesseur.NewProffesseurRow
        NewRow.Item("NomProff") = txtnom.Text
        NewRow.Item("PrenomProff") = txtprenom.Text
        If Vacbtm.Checked Then
            NewRow.Item("Etat") = Vacbtm.Text
        Else
            NewRow.Item("Etat") = Perbtm.Text
        End If

        If IGbx.Checked Then
            NewRow.Item("Options") = " & IGbx.Text"
        ElseIf GEAbx.Checked Then
            NewRow.Item("Options") = " & GEAbx.Text"
        ElseIf ACOBAbx.Checked Then
            NewRow.Item("Options") = " & ACOBAbx.Text"
        ElseIf Ibx.Checked Then
            NewRow.Item("Options") = " & Ibx.Text"
        ElseIf IMbx.Checked Then
            NewRow.Item("Options") = " & IMbx.Text"
        End If
        NewRow.Item("CodeProff") = 0
        DataSet11.Proffesseur.AddProffesseurRow(NewRow)
        Me.BindingContext(DataSet11, "Proffesseur").ResumeBinding()


Thank you

myriam

Hi,

If you are using a SQL database, then you can use the SqlCommand class under the System.Data.SqlClient namespace for the job. Here's a link where you can read more about it:

http://www.aspalliance.com/aspxtreme...mandClass.aspx

Cheers!


Marlon Villarama
Support Team
Web Burner Hosting
[email protected]
www.webburner.com
Toll-Free: 877-535-2876