Cloning Web Part

Hi,

can you share more info like what version and is it cloning on same page or was it copied to another page?

Usually when something like this happens we remove and copy it again.

I am using version 8.2. What I am trying to do is clone the poll web part and add a comment box on it. When the poll closes, then they want the poll to disappear and the comment box to appear.

I am sorry to be such a bother, but I have just been thrown into Kentico with little or no help. They told me everything would be out of the box and it turns out that everything is a customization.

I am having trouble with the cloning, but more importantly, I am having trouble making a database call to save the comments. I am from asp.net and normally I would use ado.net to save the data back to the database.

Is that appropriate in Kentico. I am not knowledgeable about the various classes.

This is my code for the click event on the new button

SqlConnection conn = new SqlConnection(); conn.ConnectionString = "Server=(localdb)\v11.0;Integrated Security=true";

    SqlCommand cmd = new SqlCommand();
    cmd.CommandText = "Insert into dbo.form_IntranetPortal_CommentForm(CommentBox) Values(" + pollcommentbox.Text + ")";

    cmd.Connection = conn;
    conn.Open();
    cmd.ExecuteNonQuery();
    conn.Close();
    pollcommentbox.Text = "Thank You For Your Comment";

This is the markup for the new comment box

After entering data into the comment box then when I look back into the database there is nothing in the table. I am doing this from my local where I am not getting any errors when I pull the clone on. The cloning errors are occurring on another box.

Any help you could provide would be appreciated.

Sherry, the code above for ado.net is not good, it allows for SQL Injection Attacks, you should always use parameters and AddWithValue. Additionally, you should always conn.Dispose(), close is not enough. Or wrap it in a using statement. Also your conn may not be working.

using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["CMSConnectionString".ConnectionString))
{ 
try
{
const string SQL = "Insert into form_IntranetPortal_CommentForm (CommentBox) Values(@CommentBox);
SqlComand cmd = new SqlCommand(SQL, conn);
cmd.Parameters.AddWithValue("CommentBox", pollcommentbox.Text ?? "");

conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

}
catch
{
conn.Close();

}
}