Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim obj As New OleDbCommand
obj.Connection = coon
obj.CommandText = "Insert into LearnWeb(ID,Mozo,Matn,UserName,DateP,TimeP,Filter, Daste)values(@ID,@Mozo,@Matn,@UserName,@DateP,@Tim eP,@Filter,@Daste)"
Dim objmax As New OleDbCommand("select max(ID) from LearnWeb", coon)
coon.Open()
Dim maxid As Object = objmax.ExecuteScalar
If maxid Is DBNull.Value Then
maxid = 0
End If
coon.Close()
obj.Parameters.AddWithValue("ID", maxid + 1)
obj.Parameters.AddWithValue("@Mozo", TextBox3.Text)
obj.Parameters.AddWithValue("@Matn", FCKeditor1.Value)
obj.Parameters.AddWithValue("@UserName", Label1.Text)
obj.Parameters.AddWithValue("@DateP", TextBox1.Text)
obj.Parameters.AddWithValue("@TimeP", TextBox2.Text)
obj.Parameters.AddWithValue("@Filter", Me.DropDownList1.SelectedValue.ToString)
obj.Parameters.AddWithValue("@Daste", Me.DropDownList1.SelectedItem.Text)
coon.Open()
obj.ExecuteNonQuery()
coon.Close()
Response.Write("<script> alert('مطلب شما با موفقیت ثبت گردید'); </script>")
End Sub