本文整理汇总了C#中System.Data.Common.DbCommand.ExecuteNonQuery方法的典型用法代码示例。如果您正苦于以下问题:C# DbCommand.ExecuteNonQuery方法的具体用法?C# DbCommand.ExecuteNonQuery怎么用?C# DbCommand.ExecuteNonQuery使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Common.DbCommand
的用法示例。
在下文中一共展示了DbCommand.ExecuteNonQuery方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: datacontrol
public datacontrol(String path)
{
bool flag;
if(File. Exists(path)){
flag=false;
}else{
flag=true;
}
SQLiteConnection con = new SQLiteConnection ("Data Source="+path);
str = path;
con.Open();
connection=con;
cmd=new SQLiteCommand(con);
if(flag){
cmd.CommandText="create table driver(driverid varchar PRIMARY KEY,personid varchar not null,sex bool not null,name varchar not null,birthday char(8) not null,password varchar not null)";
cmd.ExecuteNonQuery();
cmd.CommandText="create table adminstrator (id varchar PRIMARY KEY,password varchar not null)";
cmd.ExecuteNonQuery();
cmd.CommandText="insert into adminstrator values(\'adminstrator\',\'1234\')";
cmd.ExecuteNonQuery();
cmd.CommandText="create table car(carid varchar primary key,caryear int,avaliable bool,insurancen bool,yearcheck bool)";
cmd.ExecuteNonQuery();
cmd.CommandText="create table contract(carid varchar,driverid varchar,startdate int,enddate int,isagree bool,isvalid bool,PRIMARY KEY(carid,driverid,startdate))";
cmd.ExecuteNonQuery();
//TODO create the table
}
}
示例2: CreateDataBase
/// <summary>
/// 初次使用创建数据库
/// </summary>
public static void CreateDataBase()
{
try
{
bool isExist = File.Exists(DataPath);
if (!isExist)
{
SQLiteConnection.CreateFile(DataPath);
}
conn = new SQLiteConnection(ConnStr);
conn.Open();
comm = conn.CreateCommand();
if (!isExist)
{
String sql = "Create table ReceiveData(DeviceNum INTEGER , Temperature INTEGER , Humidity INTEGER , Tyrere INTEGER , MotorState INTEGER , ErrorNum INTEGER , CreateDate DateTime);";
comm.CommandText = sql;
comm.CommandType = CommandType.Text;
comm.ExecuteNonQuery();
}
}
catch (Exception e)
{
}
}
示例3: ExecuteDropDemoTable
/// <summary>
/// Drops the DemoTable.
/// </summary>
/// <param name="command">A command attached to a connection</param>
private void ExecuteDropDemoTable(DbCommand command)
{
Console.WriteLine("Removing DemoTable..");
command.CommandText = "DROP TABLE DemoTable";
command.ExecuteNonQuery();
}
开发者ID:WindowsAzure-TrainingKit-RU,项目名称:HOL-IntroSQLDatabase-VS2012,代码行数:11,代码来源:SQLDatabaseConnectionDemo.cs
示例4: ExecuteNonQuery
// execute an update, delete, or insert command
// and return the number of affected rows
public static int ExecuteNonQuery(DbCommand command)
{
// The number of affected rows
int affectedRows = -1;
// Execute the command making sure the connection gets closed in the end
try
{
// Open the connection of the command
command.Connection.Open();
// Execute the command and get the number of affected rows
affectedRows = command.ExecuteNonQuery();
}
catch (Exception ex)
{
// Log eventual errors and rethrow them
//Utilities.LogError(ex);
throw ex;
}
finally
{
// Close the connection
command.Connection.Close();
}
// return the number of affected rows
return affectedRows;
}
示例5: ExecuteNonQuery
public static int ExecuteNonQuery(DbCommand cmd)
{
using (DbConnection connection = GetConnection())
{
cmd.Connection = connection;
return cmd.ExecuteNonQuery();
}
}
示例6: ExecuteNonQuery
public static int ExecuteNonQuery(DbCommand command)
{
int result = -1;
command.Connection.Open();
result = command.ExecuteNonQuery();
return result;
}
示例7: ExecuteNonQuery
// insert update delete command
// return no of affected rows
public static int ExecuteNonQuery(DbCommand command)
{
int affectedRows = -1;
command.Connection.Open();
affectedRows = command.ExecuteNonQuery();
return affectedRows;
}
示例8: ExecNonQuery
public int ExecNonQuery(DbCommand cm)
{
//OnExecuting(ExecTypes.NonQuery, cm);
int r = cm.ExecuteNonQuery();
//OnExecuted(ExecTypes.NonQuery, cm, r);
return r;
}
示例9: ExecuteCommand
/// <summary>
/// Will execute the given command on the database
/// </summary>
/// <param name="command">The command to execute</param>
protected void ExecuteCommand(DbCommand command)
{
bool doClose = InitializeConnection(ref command);
command.ExecuteNonQuery();
if (doClose)
Connection.Close();
}
示例10: ExecuteResultInternal
protected override object ExecuteResultInternal(IDbExecuteContext ctx, DbCommand command, Type resultType, object resultInstance)
{
var affectedRows = command.ExecuteNonQuery();
//判断是否是存储过程,是则需要处理输出参数和返回参数
if(command.CommandType == CommandType.StoredProcedure) {
var result = this.HandleOutputOrReturnValue(ctx, resultType, resultInstance, command, affectedRows);
return result;
}
return affectedRows;
}
示例11: ExecuteNonQuery
public static int ExecuteNonQuery(DbCommand cmd)
{
using(SqlCeConnection conn = new SqlCeConnection(DBHelper.GetConnectionString()))
{
PrepareCommand(cmd, conn, null);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return val;
}
}
示例12: ExecuteNonQuery
public void ExecuteNonQuery(DbCommand command)
{
using (var connection = new SQLiteConnection(_connectionString))
{
command.Connection = connection;
connection.Open();
command.ExecuteNonQuery();
}
}
示例13: ExecuteNonQuery
public static bool ExecuteNonQuery(DbCommand comm)
{
int i = -1;
comm.Connection.Open();
i = comm.ExecuteNonQuery();
comm.Connection.Close();
return i > 0;
}
示例14: ExecuteNonQuery
protected int ExecuteNonQuery(DbCommand command)
{
this.AbrirConexao();
command.Connection = this.Conexao;
var resultado = command.ExecuteNonQuery();
this.FecharConexao();
return resultado;
}
示例15: ExecuteNonQuery
public int ExecuteNonQuery(DbCommand command)
{
DbConnection connection = null;
try
{
connection = CreateOpenConnection();
command.Connection = connection;
return command.ExecuteNonQuery();
}
finally // is executed in case of exceptions as well
{
ReleaseConnection(connection);
}
}