Thanks for tje answer but the link is to insert he control in my page web or i want to insert the text typed in the CKEditor 3.x in my sql server database.
No. That link is about what you must do BEFORE using CKEditor.
Think about it for a moment. Do you think that it will be easier to find tutorials about how to use CKEditor+.Net+Sql server+ etc... or start with just a tutorial for .Net+Sql server?
Thank for the answer. I have find to insert in my database with this code :
Imports System.Data.SqlClient Partial Class JeuxVideo_Default Inherits System.Web.UI.Page Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click ' Déclaration de l'objet de connexion Dim oConnection As SqlConnection Dim strRequete As String = "INSERT into TestJeuxVideo(id, texte) Values('" & TextBox1.Text & "','" & editor1.Text & "')"
' Création de l'objet de connexion oConnection = New SqlConnection
' Ecriture de la chaîne de connexion Dim sConnectionString As String = "Server=SQL2005.HEBERGEMENT.COM;Initial Catalog=db_worldgam3_1;uid=db_worldgam3_1;password=********" oConnection.ConnectionString = sConnectionString
' Ouverture de la connexion oConnection.Open() Dim oCommand As New System.Data.SqlClient.SqlCommand(strRequete, oConnection)
' Traitement des opération à effectuer sur la base de données oCommand.ExecuteNonQuery() ' Fermeture de la connexion oConnection.Close() End Sub End Class
But the text typed in the control ckeditor is not insert why
Re: problem to insert in sql server database
Read this post: http://alfonsoml.blogspot.com/2009/08/u ... sites.html
Re: problem to insert in sql server database
Re: problem to insert in sql server database
That link is about what you must do BEFORE using CKEditor.
Think about it for a moment. Do you think that it will be easier to find tutorials about how to use CKEditor+.Net+Sql server+ etc... or start with just a tutorial for .Net+Sql server?
Re: problem to insert in sql server database
I have find to insert in my database with this code :
Imports System.Data.SqlClient
Partial Class JeuxVideo_Default
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
' Déclaration de l'objet de connexion
Dim oConnection As SqlConnection
Dim strRequete As String = "INSERT into TestJeuxVideo(id, texte) Values('" & TextBox1.Text & "','" & editor1.Text & "')"
' Création de l'objet de connexion
oConnection = New SqlConnection
' Ecriture de la chaîne de connexion
Dim sConnectionString As String = "Server=SQL2005.HEBERGEMENT.COM;Initial Catalog=db_worldgam3_1;uid=db_worldgam3_1;password=********"
oConnection.ConnectionString = sConnectionString
' Ouverture de la connexion
oConnection.Open()
Dim oCommand As New System.Data.SqlClient.SqlCommand(strRequete, oConnection)
' Traitement des opération à effectuer sur la base de données
oCommand.ExecuteNonQuery()
' Fermeture de la connexion
oConnection.Close()
End Sub
End Class
But the text typed in the control ckeditor is not insert why