private void ExecuteInsert(string us, string ps)
{
us = TextBox1.Text;
ps = TextBox2.Text;
SqlConnection conn = new SqlConnection(GetConnectionString());
SqlCommand cmd = new SqlCommand("INSERT INTO log" + "( us,ps)"
+
"values" + " (@us,@ps)");
try
{
conn.Open();
cmd.Parameters.Add(
new SqlParameter(@us, SqlDbType.VarChar, 20).Value = us);
cmd.Parameters.Add(
new SqlParameter(@ps, SqlDbType.VarChar, 20).Value = ps);
cmd.CommandType =
CommandType.Text;
cmd.ExecuteNonQuery();
}how can convert string to varchar
VulpesPosted May 7, 2013, 7:11 AM
Check this link for which .NET types correspond to SQL Server types:
http://msdn.microsoft.com/en-us/library/system.data.sqldbtype.aspx
Ravi ShekharPosted May 7, 2013, 7:10 AM
we use string in c# and varchar in sql server.
Regards ,
ravi