string ConnectionStr = "server=yourservername;
user id=youraccount;
database=yourDBName";
SqlConnection cn = new SqlConnection ();
cn.ConnectionString = ConnnectionStr;
cn.Open ();
try
{
SqlCommand cmdUpdate = "……" //这里是上面的那串东西
try
{
cmdUpdate.ExecuteNoQuery ();
}
catch
{
Context.Response.Write ("提示"); //这里可以写些提示
}
}
finally
{
cn.Close ();
}
user id=youraccount;
database=yourDBName";
SqlConnection cn = new SqlConnection ();
cn.ConnectionString = ConnnectionStr;
cn.Open ();
try
{
SqlCommand cmdUpdate = "……" //这里是上面的那串东西
try
{
cmdUpdate.ExecuteNoQuery ();
}
catch
{
Context.Response.Write ("提示"); //这里可以写些提示
}
}
finally
{
cn.Close ();
}
SqlCommand cmdUpdate = new SqlCommand ("……", cn);
换一个思路,用img字段如何。你的字符串种有太多的易混淆的标点符号。
string ConnectionStr = "server=yourservername;
user id=youraccount;
database=yourDBName";
SqlConnection cn = new SqlConnection ();
cn.ConnectionString = ConnnectionStr;
cn.Open ();
try
{
SqlCommand cmdUpdate = new SqlCommand (@"……", cn);//这里是上面的那串东西
try
{
cmdUpdate.ExecuteNoQuery ();
}
catch
{
Context.Response.Write ("提示"); //这里可以写些提示
}
}
finally
{
cn.Close ();
}
{
string strsql = "UPDATE TMemo set Content = @Content WHERE StrucID0 = @StrucID0";
OleDbConnection myConnection = new OleDbConnection(GetBZDBConnstr());
OleDbCommand myCommand = new OleDbCommand(strsql,myConnection); OleDbParameter param1 = new System.Data.OleDb.OleDbParameter("@Content", System.Data.OleDb.OleDbType.VarWChar, 0, "Content");
param1.Value = content;
myCommand.Parameters.Add(param1); OleDbParameter param2 = new System.Data.OleDb.OleDbParameter("@StrucID0", System.Data.OleDb.OleDbType.VarWChar, 20, "StrucID0");
param2.Value = id;
myCommand.Parameters.Add(param2);
//myCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Content", System.Data.OleDb.OleDbType.VarWChar, 0, "Content"));
//myCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("StrucID0", System.Data.OleDb.OleDbType.VarWChar, 20, "StrucID0")); // 执行命令
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
if(myConnection.State == ConnectionState.Open)
myConnection.Close();
}
}