本文整理汇总了C#中System.Db.ExecuteNonQuery方法的典型用法代码示例。如果您正苦于以下问题：C# Db.ExecuteNonQuery方法的具体用法？C# Db.ExecuteNonQuery怎么用？C# Db.ExecuteNonQuery使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Db的用法示例。
在下文中一共展示了Db.ExecuteNonQuery方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: HandleDetailsUpdate
private static void HandleDetailsUpdate(HttpRequest Request, HttpResponse Response, Guid userId)
{
BinaryReader r = new BinaryReader(Request.InputStream);
int responseVersion = 0;
int responseCode = -1;
Encoding e = Encoding.Unicode;
try
{
int clientVersion = r.ReadInt32();
responseVersion = clientVersion;
if(userId == Guid.Empty)
{
responseCode = -2;
return;
}
int itemcount = r.ReadInt32();
using(Db db = new Db())
{
db.CommandText = "UPDATE tPhoto SET [email protected], [email protected] WHERE [email protected]";
IDataParameter pid = db.AddParameter("@photoId", Guid.Empty);
IDataParameter ptitle = db.AddParameter("@title", string.Empty);
IDataParameter ptext = db.AddParameter("@text", string.Empty);
for(int i=0;i<itemcount;i++)
{
Guid photoId = new Guid(r.ReadBytes(16));
int len;
byte[] raw;
len = r.ReadInt32();
raw = r.ReadBytes(len);
string title = e.GetString(raw, 0, raw.Length-2);
len = r.ReadInt32();
raw = r.ReadBytes(len);
string text = e.GetString(raw, 0, raw.Length-2);
bool ok;
try
{
Database.EnforcePhotoPermission(userId, photoId, Permission.Change);
pid.Value = photoId;
ptitle.Value = title;
ptext.Value = text;
ok = db.ExecuteNonQuery(0)==1;
}
catch(System.Data.SqlClient.SqlException exc)
{
string debug = exc.ToString();
throw;
}
catch(Error_AccessDenied)
{
ok = false;
Log.LogSecurity(2, "Denied access to edit photo details with client control. userId:{0}, photoId:{1}, title{2}, text:{3}.",
userId, photoId, title, text);
}
}
}
responseCode = 0;
Log.LogStatistics(2, "Updated details for {0} photos.", itemcount);
}
catch
{
responseCode = -1;
throw;
}
finally
{
BinaryWriter writer = new BinaryWriter(Response.OutputStream);
writer.Write(responseVersion);
writer.Write(responseCode);
writer.Flush();
}
}