MySQL

Re: how to update columes in the mysql using C#.net

Karrar666 — Fri, 05 Sep 2008 16:43:54 GMT

MySqlParameter usernameParameter = new MySqlParameter("?username", MySqlDbType.VarChar, 150); // You can use string patameter

usernameParameter.Value = string (string)Session["username"];

cmd.Parameter.Add(usernameParameter);

MySqlParameter seekingParameter = new MySqlParameter("?seeking", MySqlDbType.Int32, 0); // You can use Integer Patameter

seekingParameter.Value = ddlseek.Text;

cmd.Parameter.Add(seekingParameter);

MySqlParameter agefromParameter = new MySqlParameter("?agefrom", MySqlDbType.Date, 0); // You can use date Patameter

agefromParameter.Value = ddlfrom.Text;

cmd.Parameter.Add(agefromParameter);

string SQL = " UPDATE tbl_users SET seeking = ?seeking, agefrom = ?agefrom Where username = ?username";MySqlCommand cmd = new MySqlCommand(SQL, conn);

conn.Open();

cmd.ExecuteNonQuery();

conn.Close();

Always use Paramters Coz is protected against SQL injection and easy to debug ;)

Re: how to update columes in the mysql using C#.net

bullpit — Fri, 29 Aug 2008 14:16:55 GMT

krishnakumari:

+"where username=";

You don't have a space before "where". Insert a space like this: " where "

Re: how to update columes in the mysql using C#.net

krishnakumari — Fri, 29 Aug 2008 13:59:06 GMT

I tried with this

string un = (string)Session["username"];

string str1 = @"update tbl_users set seeking=" + ddlseek.Text +" ,agefrom=" + ddlfrom.Text + ",ageto=" + ddlto.Text +"where username=";

string str2 = "'" + un + "'";

string str = str1 + str2;

MySqlCommand cmd = new MySqlCommand(str, conn);

conn.Open();

cmd.ExecuteNonQuery();

conn.Close();

Error Message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'username='user1'' at line 1

But with the same srting I tried with the mysqlcmd, It's working.

please help me.

thank you

Re: how to update columes in the mysql using C#.net

bullpit — Fri, 29 Aug 2008 13:41:54 GMT

It should be same. What have you tried?

how to update columes in the mysql using C#.net

krishnakumari — Fri, 29 Aug 2008 13:36:57 GMT

Hi,

in my application I have update the columes . But that is in mysql databse.

I tried with normal sql query.

Is it same as sql server 2005 or is their any diiff.

please help me.

very urgent