Hi

I don't know anything about the sqlHelper thing, but a normal sql insert statement would be: INSERT INTO my_custom_table (title) VALUES ('some value')

hth

Hi,

Thanks for your help, but it didn´t help me. I am afraid my problem is that I don´t know much of .NET. So mayby my whole code is build wrong. I just found an example code and build upon it. Maybe my imported namespaces isn´t useful. Maybe I should not use SqlHelper. i don´t know.

Could anyone give me an example on a usercontrol (all the code) that inserts a row in a table. Like the INSERT INTO my_custom_table (title) VALUES ('some value')

regards, Martin

Hi in your sample code you have put single quotes around the table and column name, remove them and it will work I think. So in other words, copy the query that you made bold in your last reply and use that in your sample code.

Cheers,

Richard

Hi Richard,

I have tried several ways including the query in my last reply: SqlHelper.ExecuteNonQuery("INSERT INTO my_custom_table (title) VALUES ('some value')");

But it gives this error: MySql.Data.MySqlClient.MySqlException: Table 'database_name.MY_CUSTOM_TABLE' doesn't exist

But the table do exist! Only its name is not in capital letters but lowercase. Don´t know why the table name seems to be processed with capital letters by .NET....

Without sqlHelper:

using System.Data;
using System.Data.SqlClient;

~~~~~

string strConn = ConfigurationManager.ConnectionStrings("Your_ConnectionString").ToString();
SqlConnection DBConnection = default(SqlConnection);
SqlCommand DBCommand = default(SqlCommand);
string strSQL = string.Empty;
Int32 rowsaffected = 0;


DBConnection = new SqlConnection(strConn);
strSQL = "INSERT INTO my_custom_table (title) VALUES ('some value')";

DBCommand = new SqlCommand(strSQL, DBConnection);
DBCommand.CommandType = CommandType.Text;
DBConnection.Open();
    
rowsaffected = DBCommand.ExecuteNonQuery();
    
DBConnection.Close();
DBConnection.Dispose();

if (rowsaffected < 1) 
  {
     Response.Write("Error!");
 }

Hope it helps you get going!

/Finn

Hi Martin

It's because the Umbraco datalayer converts it to uppercase. I had the same problem when I first started using MySQL a year ago and the MySQL I was using wasn't case-insensitive. If you look at the tables Umbraco creates during installation I'm pretty sure they are all Uppercased. I don't know if this problem has been solved in the current version.

I think your solution is to create your custom tables uppercase - or do as I did - start using MSSQL.

/Paul S

Hi Finn and Paul,

Thanks for your replies. It seems to be the right way to do it the way Finn writes. I found another code last evening - in the essense it was like Finn´s last example. And now it works!

And Pauls explanation is what I have discovered too. I will keep on using MySql - my hosting has that as default. :)

Regards,

Martin

is working on a reply...