Here are the examples of the csharp api System.Data.SqlClient.SqlCommand.ExecuteNonQuery() taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.
2534 Examples
19
Source : SqlServerIo.cs
with MIT License
from 0ffffffffh
with MIT License
from 0ffffffffh
public bool Execute(bool nonQuery, string queryStringFormat, params object[] args)
{
bool result = false;
SqlTransaction sqlTran = null;
SqlCommand cmd = null;
string query;
ExecPerf perf = new ExecPerf();
affected = 0;
if (!Ready)
return false;
try
{
if (nonQuery)
sqlTran = conn.BeginTransaction();
query = string.Format(queryStringFormat, args);
cmd = new SqlCommand(query, this.conn, sqlTran);
if (nonQuery)
{
perf.Begin();
affected = cmd.ExecuteNonQuery();
perf.Time("SQL execution", TimeSpan.FromSeconds(3));
}
else
{
CloseReader();
perf.Begin();
reader = cmd.ExecuteReader();
perf.Time("sql execution",TimeSpan.FromSeconds(8));
affected = reader.RecordsAffected;
}
if (sqlTran != null)
sqlTran.Commit();
result = true;
}
catch (Exception e)
{
Log.Error("Sql exec error: {0}", e.Message);
if (sqlTran != null)
sqlTran.Rollback();
}
return result;
}
19
Source : SqlServerDataBase.cs
with Mozilla Public License 2.0
from agebullhu
with Mozilla Public License 2.0
from agebullhu
protected int ExecuteInner(string sql, params SqlParameter[] args)
{
lock (this)
{
int result;
using (var cmd = CreateCommand(sql, args))
{
result = cmd.ExecuteNonQuery();
}
return result;
}
}
19
Source : SqlServerDataBase.cs
with Mozilla Public License 2.0
from agebullhu
with Mozilla Public License 2.0
from agebullhu
protected int ExecuteInner(string sql, params DbParameter[] args)
{
using (var cmd = CreateCommand(sql, args))
{
return cmd.ExecuteNonQuery();
}
}
19
Source : DatabaseOperation.cs
with MIT License
from ap0405140
with MIT License
from ap0405140
public void ExecuteSP_Parameters(string SPname,
ref List<SqlParameter> pParameters)
{
try
{
RefreshConnect();
scm = new SqlCommand(SPname, scn);
scm.CommandType = CommandType.StoredProcedure;
scm.Parameters.AddRange(pParameters.ToArray());
scm.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
if (scn.State == ConnectionState.Open)
{
scn.Close();
}
scn.Dispose();
}
}
19
Source : DatabaseOperation.cs
with MIT License
from ap0405140
with MIT License
from ap0405140
public void ExecuteSQL(string sTsql, bool closeconnect = true)
{
try
{
RefreshConnect();
scm = new SqlCommand(sTsql, scn);
scm.CommandTimeout = 0;
scm.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception("Run SQL: \r\n" + sTsql
+ "\r\n\r\n" + "ExceptionSource: " + ex.Source
+ "\r\n\r\n" + "ExceptionMessage: " + ex.Message);
}
finally
{
if (closeconnect == true)
{
if (scn.State == ConnectionState.Open)
{
scn.Close();
}
scn.Dispose();
}
}
}
19
Source : DatabaseOperation.cs
with MIT License
from ap0405140
with MIT License
from ap0405140
public bool ExecuteSQL(string sTsql, out string sMessage, bool bFinallyClose = true)
{
bool y;
try
{
sMessage = string.Empty;
RefreshConnect();
y = false;
scm = new SqlCommand(sTsql, scn);
scm.CommandTimeout = 0;
scm.ExecuteNonQuery();
y = true;
}
catch (Exception ex)
{
y = false;
sMessage = ex.Source + " " + ex.Message;
}
finally
{
if (bFinallyClose == true)
{
if (scn.State == ConnectionState.Open)
{
scn.Close();
}
scn.Dispose();
}
}
return y;
}
19
Source : SqlServerHelper.cs
with Apache License 2.0
from aryice
with Apache License 2.0
from aryice
public override void ExecuteSqlTran(string connectionString, ArrayList SQLStringList)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
SqlTransaction tx = conn.BeginTransaction();
cmd.Transaction = tx;
try
{
for (int n = 0; n < SQLStringList.Count; n++)
{
string strsql = SQLStringList[n].ToString();
if (strsql.Trim().Length > 1)
{
cmd.CommandText = strsql;
cmd.ExecuteNonQuery();
}
}
tx.Commit();
}
catch (System.Data.SqlClient.SqlException E)
{
tx.Rollback();
throw new Exception(E.Message);
}
}
}
19
Source : SqlServerHelper.cs
with Apache License 2.0
from aryice
with Apache License 2.0
from aryice
public override int ExecuteSqlTran(string connectionString, ArrayList SQLStringList, List<SqlParameter[]> ParamList)
{
int val = 0;
using (var conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
var cmd = new SqlCommand();
try
{
for (int n = 0; n < SQLStringList.Count; n++)
{
string strsql = SQLStringList[n].ToString();
var cmdParam = ParamList[n];
PrepareCommand(cmd, conn, trans, strsql, cmdParam);
val += cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return val;
}
19
Source : SqlServerHelper.cs
with Apache License 2.0
from aryice
with Apache License 2.0
from aryice
public override int ExecuteSqlInsertImg(string connectionString, string strSQL, byte[] fs)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(strSQL, connection);
System.Data.SqlClient.SqlParameter myParameter = new System.Data.SqlClient.SqlParameter("@fs", SqlDbType.Image);
myParameter.Value = fs;
cmd.Parameters.Add(myParameter);
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SqlClient.SqlException E)
{
throw new Exception(E.Message);
}
finally
{
cmd.Dispose();
connection.Close();
}
}
}
19
Source : SqlServerHelper.cs
with Apache License 2.0
from aryice
with Apache License 2.0
from aryice
public override int RunProcedure(string connectionString, string storedProcName, IDataParameter[] parameters, out int rowsAffected)
{
using (var connection = new SqlConnection(connectionString))
{
int result;
connection.Open();
var command = BuildIntCommand(connection, storedProcName, parameters);
rowsAffected = command.ExecuteNonQuery();
result = (int)command.Parameters["ReturnValue"].Value;
return result;
}
}
19
Source : SqlServerHelper.cs
with Apache License 2.0
from aryice
with Apache License 2.0
from aryice
public override string RunProcedure(string connectionString, string storedProcName, IDataParameter[] parameters, out string rowsAffected)
{
using (var connection = new SqlConnection(connectionString))
{
string result;
connection.Open();
var command = BuildIntCommand(connection, storedProcName, parameters);
command.ExecuteNonQuery();
result = command.Parameters["ReturnValue"].Value.ToString();
rowsAffected = result;
return result;
}
}
19
Source : SqlServerHelper.cs
with Apache License 2.0
from aryice
with Apache License 2.0
from aryice
public override int ExecuteSqlTran(string connectionString, List<String> SQLStringList)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
SqlTransaction tx = conn.BeginTransaction();
cmd.Transaction = tx;
try
{
int count = 0;
for (int n = 0; n < SQLStringList.Count; n++)
{
string strsql = SQLStringList[n];
if (strsql.Trim().Length > 1)
{
cmd.CommandText = strsql;
count += cmd.ExecuteNonQuery();
}
}
tx.Commit();
return count;
}
catch
{
tx.Rollback();
return 0;
}
}
}
19
Source : SqlServerHelper.cs
with Apache License 2.0
from aryice
with Apache License 2.0
from aryice
public override int ExecuteSqlTran(string connectionString, string SQLString)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
SqlTransaction tx = conn.BeginTransaction();
cmd.Transaction = tx;
try
{
int count = 0;
string strsql = SQLString;
if (strsql.Trim().Length > 1)
{
cmd.CommandText = strsql;
count += cmd.ExecuteNonQuery();
}
tx.Commit();
return count;
}
catch
{
tx.Rollback();
return 0;
}
}
}
19
Source : SqlServerHelper.cs
with Apache License 2.0
from aryice
with Apache License 2.0
from aryice
public override int ExecuteSql(string connectionString, string SQLString)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand(SQLString, connection))
{
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SqlClient.SqlException E)
{
connection.Close();
throw new Exception(E.Message);
}
}
}
}
19
Source : SqlServerHelper.cs
with Apache License 2.0
from aryice
with Apache License 2.0
from aryice
public override int ExecuteSql(string connectionString, string SQLString, string content)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(SQLString, connection);
System.Data.SqlClient.SqlParameter myParameter = new System.Data.SqlClient.SqlParameter("@content", SqlDbType.NText);
myParameter.Value = content;
cmd.Parameters.Add(myParameter);
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SqlClient.SqlException E)
{
throw new Exception(E.Message);
}
finally
{
cmd.Dispose();
connection.Close();
}
}
}
19
Source : SqlServerHelper.cs
with Apache License 2.0
from aryice
with Apache License 2.0
from aryice
public override int ExecuteSql(string connectionString, string SQLString, params SqlParameter[] cmdParms)
{
using (var connection = new SqlConnection(connectionString))
{
using (var cmd = new SqlCommand())
{
try
{
PrepareCommand(cmd, connection, null, SQLString, cmdParms);
var rows = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return rows;
}
catch (System.Data.SqlClient.SqlException E)
{
throw new Exception(E.Message);
}
}
}
}
19
Source : SqlServerHelper.cs
with Apache License 2.0
from aryice
with Apache License 2.0
from aryice
public override void ExecuteSqlTran(string connectionString, Hashtable SQLStringList)
{
using (var conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
var cmd = new SqlCommand();
try
{
foreach (DictionaryEntry myDE in SQLStringList)
{
string cmdText = myDE.Key.ToString();
var cmdParms = (SqlParameter[])myDE.Value;
PrepareCommand(cmd, conn, trans, cmdText, cmdParms);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
}
19
Source : SqlServerHelper.cs
with Apache License 2.0
from aryice
with Apache License 2.0
from aryice
public override int ExecuteSqlTran1(string connectionString, Hashtable SQLStringList)
{
int val = 0;
using (var conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
var cmd = new SqlCommand();
try
{
foreach (DictionaryEntry myDE in SQLStringList)
{
string cmdText = myDE.Key.ToString();
var cmdParms = (SqlParameter[])myDE.Value;
PrepareCommand(cmd, conn, trans, cmdText, cmdParms);
val += cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return val;
}
19
Source : TraceableSqlCommand.net45.cs
with Apache License 2.0
from aws
with Apache License 2.0
from aws
public override int ExecuteNonQuery()
{
return Intercept(() => InnerSqlCommand.ExecuteNonQuery());
}
19
Source : MsSqlTests.cs
with MIT License
from azist
with MIT License
from azist
private void clearAllTables()
{
using(var cnn = new SqlConnection(CONNECT_STRING))
{
cnn.Open();
using(var cmd = cnn.CreateCommand())
{
cmd.CommandText = "delete from TBL_TUPLE; delete from TBL_PATIENT; delete from TBL_DOCTOR; delete from TBL_TYPES; delete from TBL_FULLGDID;";
cmd.ExecuteNonQuery();
}
}
}
19
Source : Catagoriesdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool update(Catagoriesbll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to update Data in DAtabase
string query = "UPDATE tbl_catagories set catagory=@catagory,supplier=@supplier,added_by=@added_by,added_date=@added_date WHERE id=@id";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@id", u.id);
cmd.Parameters.AddWithValue("@catagory", u.catagory);
cmd.Parameters.AddWithValue("@supplier", u.supplier);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : Catagoriesdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool delete(Catagoriesbll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to delete Data in DAtabase
string query = "DELETE FROM tbl_catagories WHERE id=@id";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@id", u.id);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Sucessfull
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : invoicedal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool insert(invoicebll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to insert Data in DAtabase
string query = "Insert into tbl_invoice(inv_no,customer_name,total_payable,paid_amount,discount,due_amount,change_amount,added_by,sales_date)Values(@inv_no,@customer_name,@total_payable,@paid_amount,@discount,@due_amount,@change_amount,@added_by,@sales_date)";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@inv_no", u.inv_no);
cmd.Parameters.AddWithValue("@customer_name", u.customer_name);
cmd.Parameters.AddWithValue("@total_payable", u.total_payable);
cmd.Parameters.AddWithValue("@paid_amount", u.paid_amount);
cmd.Parameters.AddWithValue("@discount", u.discount);
cmd.Parameters.AddWithValue("@due_amount", u.due_amount);
cmd.Parameters.AddWithValue("@change_amount", u.change_amount);
cmd.Parameters.AddWithValue("@added_by", u.added_by);
cmd.Parameters.AddWithValue("@sales_date", u.sales_date);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : invoicedal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool update(invoicebll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to insert Data in DAtabase
string query = "UPDATE tbl_invoice set inv_no=@inv_no, customer_name=@customer_name,total_payable=@total_payable,paid_amount=@paid_amount,discount=@discount,due_amount=@due_amount,change_amount=@change_amount,added_by=@added_by,sales_date=@sales_date WHERE id=@id";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@id", u.id);
cmd.Parameters.AddWithValue("@inv_no", u.inv_no);
cmd.Parameters.AddWithValue("@customer_name", u.customer_name);
cmd.Parameters.AddWithValue("@total_payable", u.total_payable);
cmd.Parameters.AddWithValue("@paid_amount", u.paid_amount);
cmd.Parameters.AddWithValue("@discount", u.discount);
cmd.Parameters.AddWithValue("@due_amount", u.due_amount);
cmd.Parameters.AddWithValue("@change_amount", u.change_amount);
cmd.Parameters.AddWithValue("@added_by", u.added_by);
cmd.Parameters.AddWithValue("@sales_date", u.sales_date);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : Manage_Productsdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool insert(Manage_Productsbll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to insert Data in DAtabase
string query = "Insert into tbl_stock(product_name,colour_code,supplier,catagory,purchase_price,retail_price,type,quanreplacedy,added_by,added_date)Values(@product_name,@colour_code,@supplier,@catagory,@purchase_price,@retail_price,@type,@quanreplacedy,@added_by,@added_date)";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@product_name", u.product_name);
cmd.Parameters.AddWithValue("@colour_code", u.colour_code);
cmd.Parameters.AddWithValue("@supplier" , u.supplier);
cmd.Parameters.AddWithValue("@catagory", u.catagory);
cmd.Parameters.AddWithValue("@purchase_price", u.purchase_price);
cmd.Parameters.AddWithValue("@retail_price", u.retail_price);
cmd.Parameters.AddWithValue("@type", u.type);
cmd.Parameters.AddWithValue("@quanreplacedy", u.quanreplacedy);
cmd.Parameters.AddWithValue("@added_by", u.added_by);
cmd.Parameters.AddWithValue("@added_date", u.added_date);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : Catagoriesdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool insert(Catagoriesbll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to insert Data in DAtabase
string query = "Insert into tbl_catagories(catagory,supplier,added_by,added_date)Values(@catagory,@supplier,@added_by,@added_date)";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@catagory", u.catagory);
cmd.Parameters.AddWithValue("@supplier", u.supplier);
cmd.Parameters.AddWithValue("@added_by", u.added_by);
cmd.Parameters.AddWithValue("@added_date", u.added_date);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : invoicedal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool delete(invoicebll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to delete Data in DAtabase
string query = "DELETE FROM tbl_invoice WHERE id=@id";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@id", u.id);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : userdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool delete(usersbll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to delete Data in DAtabase
string query = "DELETE FROM tbl_users WHERE id=@id";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@id", u.id);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : product_detailsdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool insert(product_detailsbll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to insert Data in DAtabase
string query = "Insert into tbl_productdetails(product_id,product_name,price,quanreplacedy,discount,total,purchase_price,inv_no,type,added_by,added_date,code)Values(@product_id,@product_name,@price,@quanreplacedy,@discount,@total,@purchase_price,@inv_no,@type,@added_by,@added_date,@code)";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@product_id", u.product_id);
cmd.Parameters.AddWithValue("@product_name", u.product_name);
cmd.Parameters.AddWithValue("@price", u.price);
cmd.Parameters.AddWithValue("@quanreplacedy", u.quanreplacedy);
cmd.Parameters.AddWithValue("@discount", u.discount);
cmd.Parameters.AddWithValue("@total", u.total);
cmd.Parameters.AddWithValue("@purchase_price", u.purchase_price);
cmd.Parameters.AddWithValue("@inv_no", u.inv_no);
cmd.Parameters.AddWithValue("@type", u.type);
cmd.Parameters.AddWithValue("@added_by", u.added_by);
cmd.Parameters.AddWithValue("@added_date", u.added_date);
cmd.Parameters.AddWithValue("@code", u.code);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : product_detailsdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool delete(product_detailsbll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to delete Data in DAtabase
string query = "DELETE FROM tbl_productdetails WHERE id=@id";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@id", u.id);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : userdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool insert(usersbll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to insert Data in DAtabase
string query = "Insert into tbl_users(user_name,user_type,preplacedword,email,cnic,adress,phone_no,added_by,added_date)Values(@user_name,@user_type,@preplacedword,@email,@cnic,@adress,@phone_no,@added_by,@added_date)";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@user_name", u.user_name);
cmd.Parameters.AddWithValue("@user_type", u.user_type);
cmd.Parameters.AddWithValue("@preplacedword", u.preplacedword);
cmd.Parameters.AddWithValue("@email", u.email);
cmd.Parameters.AddWithValue("@cnic", u.cnic);
cmd.Parameters.AddWithValue("@adress", u.adress);
cmd.Parameters.AddWithValue("@phone_no", u.phone_no);
cmd.Parameters.AddWithValue("@added_by", u.added_by);
cmd.Parameters.AddWithValue("@added_date", u.added_date);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : Manage_Productsdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool update_(Manage_Productsbll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to update Data in DAtabase
string query = "UPDATE tbl_stock set product_name=@product_name,colour_code=@colour_code,supplier=@supplier,catagory=@catagory,purchase_price=@purchase_price,retail_price=@retail_price,type=@type,quanreplacedy=@quanreplacedy WHERE id=@id";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@id", u.id);
cmd.Parameters.AddWithValue("@product_name", u.product_name);
cmd.Parameters.AddWithValue("@colour_code", u.colour_code);
cmd.Parameters.AddWithValue("@supplier", u.supplier);
cmd.Parameters.AddWithValue("@catagory", u.catagory);
cmd.Parameters.AddWithValue("@purchase_price", u.purchase_price);
cmd.Parameters.AddWithValue("@retail_price", u.retail_price);
cmd.Parameters.AddWithValue("@type", u.type);
cmd.Parameters.AddWithValue("@quanreplacedy", u.quanreplacedy);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : Manage_Productsdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool delete(Manage_Productsbll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to delete Data in DAtabase
string query = "DELETE FROM tbl_stock WHERE id=@id";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@id", u.id);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : Manage_Productsdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool UpdateQuanreplacedy(int id, decimal quanreplacedy)
{
//Create a Boolean Variable and Set its value to false
bool success = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//Write the SQL Query to Update Qty
string sql = "UPDATE tbl_stock SET quanreplacedy=@quanreplacedy WHERE id=@id";
//Create SQL Command to Preplaced the calue into Queyr
SqlCommand cmd = new SqlCommand(sql, conn);
//Preplaceding the VAlue trhough parameters
cmd.Parameters.AddWithValue("@quanreplacedy", quanreplacedy);
cmd.Parameters.AddWithValue("@id", id);
//Open Database Connection
conn.Open();
//Create Int Variable and Check whether the query is executed Successfully or not
int rows = cmd.ExecuteNonQuery();
//Lets check if the query is executed Successfully or not
if (rows > 0)
{
//Query Executed Successfully
success = true;
}
else
{
//Failed to Execute Query
success = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return success;
}
19
Source : product_detailsdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool update(product_detailsbll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to insert Data in DAtabase
string query = "UPDATE tbl_productdetails set product_id=@product_id,product_name=@product_name,price=@price,quanreplacedy=@quanreplacedy,discount=@discount,total=@total,purchase_price=@purchase_price,inv_no=@inv_no,type=@type,added_by=@added_by,added_date=@added_date,code=@code WHERE id=@id";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@id", u.id);
cmd.Parameters.AddWithValue("@product_id", u.product_id);
cmd.Parameters.AddWithValue("@product_name", u.product_name);
cmd.Parameters.AddWithValue("@price", u.price);
cmd.Parameters.AddWithValue("@quanreplacedy", u.quanreplacedy);
cmd.Parameters.AddWithValue("@discount", u.discount);
cmd.Parameters.AddWithValue("@total", u.total);
cmd.Parameters.AddWithValue("@purchase_price", u.purchase_price);
cmd.Parameters.AddWithValue("@inv_no", u.inv_no);
cmd.Parameters.AddWithValue("@type", u.type);
cmd.Parameters.AddWithValue("@added_by", u.added_by);
cmd.Parameters.AddWithValue("@added_date", u.added_date);
cmd.Parameters.AddWithValue("@code", u.code);
//Database Connection Open
conn.Open();
//To execute non query
int rows = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (rows > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : product_detailsdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool UpdateQuanreplacedy(int id, decimal quanreplacedy)
{
//Create a Boolean Variable and Set its value to false
bool success = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//Write the SQL Query to Update Qty
string sql = "UPDATE tbl_productdetails SET quanreplacedy=@quanreplacedy WHERE id=@id";
//Create SQL Command to Preplaced the calue into Queyr
SqlCommand cmd = new SqlCommand(sql, conn);
//Preplaceding the VAlue trhough parameters
cmd.Parameters.AddWithValue("@quanreplacedy", quanreplacedy);
cmd.Parameters.AddWithValue("@id", id);
//Open Database Connection
conn.Open();
//Create Int Variable and Check whether the query is executed Successfully or not
int rows = cmd.ExecuteNonQuery();
//Lets check if the query is executed Successfully or not
if (rows > 0)
{
//Query Executed Successfully
success = true;
}
else
{
//Failed to Execute Query
success = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return success;
}
19
Source : suppliersdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool insert(suppliersbll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to insert Data in DAtabase
string query = "Insert into tbl_suppliers(user_name,email,company,adress,phone_no,added_by,added_date)Values(@user_name,@email,@company,@adress,@phone_no,@added_by,@added_date)";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@user_name", u.user_name);
cmd.Parameters.AddWithValue("@email", u.email);
cmd.Parameters.AddWithValue("@company", u.company);
cmd.Parameters.AddWithValue("@adress", u.adress);
cmd.Parameters.AddWithValue("@phone_no", u.phone_no);
cmd.Parameters.AddWithValue("@added_by", u.added_by);
cmd.Parameters.AddWithValue("@added_date", u.added_date);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : suppliersdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool update(suppliersbll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to update Data in DAtabase
string query = "UPDATE tbl_suppliers set user_name=@user_name,email=@email,company=@company,adress=@adress,phone_no=@phone_no WHERE id=@id";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@id", u.id);
cmd.Parameters.AddWithValue("@user_name", u.user_name);
cmd.Parameters.AddWithValue("@email", u.email);
cmd.Parameters.AddWithValue("@company", u.company);
cmd.Parameters.AddWithValue("@adress", u.adress);
cmd.Parameters.AddWithValue("@phone_no", u.phone_no);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : suppliersdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool delete(suppliersbll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to delete Data in DAtabase
string query = "DELETE FROM tbl_suppliers WHERE id=@id";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@id", u.id);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : userdal.cs
with MIT License
from bilalmehrban
with MIT License
from bilalmehrban
public bool update(usersbll u)
{
//Create a boolean variable and set its value to false and return it
bool issucess = false;
//MEthod to connect Database
connclreplaced c = new connclreplaced();
SqlConnection conn = new SqlConnection(c.connection);
try
{
//SQL Query to update Data in DAtabase
string query = "UPDATE tbl_users set user_name=@user_name,user_type=@user_type,preplacedword=@preplacedword,email=@email,cnic=@cnic,adress=@adress,phone_no=@phone_no WHERE id=@id";
//For Executing Command
SqlCommand cmd = new SqlCommand(query, conn);
//Preplaceding Values to the Variables
cmd.Parameters.AddWithValue("@id", u.id);
cmd.Parameters.AddWithValue("@user_name", u.user_name);
cmd.Parameters.AddWithValue("@user_type", u.user_type);
cmd.Parameters.AddWithValue("@preplacedword", u.preplacedword);
cmd.Parameters.AddWithValue("@email", u.email);
cmd.Parameters.AddWithValue("@cnic", u.cnic);
cmd.Parameters.AddWithValue("@adress", u.adress);
cmd.Parameters.AddWithValue("@phone_no", u.phone_no);
//Database Connection Open
conn.Open();
//To execute non query
int row = cmd.ExecuteNonQuery();
//If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0
if (row > 0)
{
//Query Sucessfull
issucess = true;
}
else
{
//Query Failed
issucess = false;
}
}
catch (Exception ex)
{
//Throw Message if any error occurs
MessageBox.Show(ex.Message);
}
finally
{
//Closing Connection
conn.Close();
}
return issucess;
}
19
Source : VaultMsSqlBackup.cs
with MIT License
from burki169
with MIT License
from burki169
public bool Restore(string databaseName, string physicalPath)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
var sb = new StringBuilder();
sb.AppendLine("USE [master]");
sb.AppendLine("ALTER DATABASE " + databaseName + " SET SINGLE_USER WITH ROLLBACK IMMEDIATE");
sb.AppendLine("RESTORE DATABASE " + databaseName + " FROM DISK='" + physicalPath + "'");
sb.AppendLine("WAITFOR DELAY '00:00:02'");
sb.AppendLine("ALTER DATABASE " + databaseName + " SET MULTI_USER");
cmd.CommandText = sb.ToString();
cmd.ExecuteNonQuery();
}
return true;
}
19
Source : VaultMsSqlBackup.cs
with MIT License
from burki169
with MIT License
from burki169
public bool Backup(string databaseName, string physicalPath)
{
using (var conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
StringBuilder sb = new StringBuilder();
sb.AppendLine("BACKUP DATABASE " + databaseName + " ");
sb.AppendLine("TO DISK='" + physicalPath + "'");
cmd.CommandText = sb.ToString();
cmd.ExecuteNonQuery();
}
return true;
}
19
Source : DbLoggingTest.cs
with MIT License
from capslocky
with MIT License
from capslocky
private static void LogResponse(string response, int id)
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = "update [Requests] set Response = @response where ID = @id";
command.Parameters.AddWithValue("response", response);
command.Parameters.AddWithValue("id", id);
command.ExecuteNonQuery();
}
}
}
19
Source : DBAccessOfMSSQL1.cs
with GNU Lesser General Public License v3.0
from ccbpm
with GNU Lesser General Public License v3.0
from ccbpm
public static int RunSQL(string sql)
{
SqlConnection conn = DBAccessOfMSSQL1.GetSingleConn;
//string step="step=1" ;
//如果是锁定状态,就等待.
while (lock_SQL)
{
lock_SQL = true; //锁定
}
try
{
if (conn.State != System.Data.ConnectionState.Open)
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.CommandType = CommandType.Text;
int i = 0;
try
{
i = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
cmd.Dispose();
lock_SQL = false;
return i;
}
catch (System.Exception ex)
{
lock_SQL = false;
throw new Exception(ex.Message + " SQL = " + sql);
}
finally
{
lock_SQL = false;
conn.Close();
}
}
19
Source : DBProcedure.cs
with GNU Lesser General Public License v3.0
from ccbpm
with GNU Lesser General Public License v3.0
from ccbpm
public static int RunSP(string spName, Paras paras, SqlConnection conn)
{
if (conn.State != ConnectionState.Open)
conn.Open();
SqlCommand cmd = new SqlCommand(spName, conn);
cmd.CommandType = CommandType.StoredProcedure;
// 加入参数
foreach (Para para in paras)
{
SqlParameter myParameter = new SqlParameter(para.ParaName, para.val);
myParameter.Size = para.Size;
cmd.Parameters.Add(myParameter);
}
int i = cmd.ExecuteNonQuery();
conn.Close();
return i;
}
19
Source : DBAccessOfMSSQL2.cs
with GNU Lesser General Public License v3.0
from ccbpm
with GNU Lesser General Public License v3.0
from ccbpm
public static int RunSQL(string sql)
{
SqlConnection conn = DBAccessOfMSSQL2.GetSingleConn;
//string step="step=1" ;
//如果是锁定状态,就等待.
while (lock_SQL)
{
lock_SQL = true; //锁定
}
try
{
if (conn.State != System.Data.ConnectionState.Open)
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.CommandType = CommandType.Text;
int i = 0;
try
{
i = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
cmd.Dispose();
lock_SQL = false;
return i;
}
catch (System.Exception ex)
{
lock_SQL = false;
throw new Exception(ex.Message + " SQL = " + sql);
}
finally
{
lock_SQL = false;
conn.Close();
}
}
19
Source : DBLoad.cs
with GNU Lesser General Public License v3.0
from ccbpm
with GNU Lesser General Public License v3.0
from ccbpm
private static int ImportTable( DataTable source ,DataTable target , SqlDataAdapter sqlada )
{
int count = 0;
try
{
if( sqlada.InsertCommand.Connection.State!= ConnectionState.Open )
sqlada.InsertCommand.Connection.Open();
sqlada.InsertCommand.Transaction = sqlada.InsertCommand.Connection.BeginTransaction();
source.Columns.Add("错误提示",typeof( string));
source.Columns["错误提示"].MaxLength = 1000;
int i =0;
while( i < source.Rows.Count ) //for( int i=0;i<;i++)
{
for( int c=0;c< target.Columns.Count ;c++)
{
sqlada.InsertCommand.Parameters[c].Value = source.Rows[i][c];
}
try//个别记录失败,跳过
{
sqlada.InsertCommand.ExecuteNonQuery();
}
catch( Exception ex )
{
source.Rows[i]["错误提示"] =ex.Message;
i++;
continue;
}
count++; //已导入的记录数
source.Rows.RemoveAt( i );
}
sqlada.InsertCommand.Transaction.Commit();
}
catch( Exception ex)
{
if( sqlada.InsertCommand.Transaction!=null)
sqlada.InsertCommand.Transaction.Rollback();
sqlada.InsertCommand.Connection.Close();
throw new Exception( "导入数据失败!"+ex.Message );
}
return count;
}
19
Source : DBProcedure.cs
with GNU Lesser General Public License v3.0
from ccbpm
with GNU Lesser General Public License v3.0
from ccbpm
public static int RunSP(string spName, SqlConnection conn)
{
SqlCommand cmd = new SqlCommand(spName, conn);
cmd.CommandType = CommandType.StoredProcedure;
if (conn.State==System.Data.ConnectionState.Closed)
{
conn.Open();
}
return cmd.ExecuteNonQuery();
}
19
Source : SqlHelper.cs
with GNU General Public License v3.0
from chenyinxin
with GNU General Public License v3.0
from chenyinxin
public static int ExecuteSql(string SQLString)
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand(SQLString, connection))
{
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SqlClient.SqlException e)
{
connection.Close();
throw e;
}
}
}
}
19
Source : SqlHelper.cs
with GNU General Public License v3.0
from chenyinxin
with GNU General Public License v3.0
from chenyinxin
public static int ExecuteSqlTran(List<String> SQLStringList)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
SqlTransaction tx = conn.BeginTransaction();
cmd.Transaction = tx;
string sql = "";
try
{
int count = 0;
for (int n = 0; n < SQLStringList.Count; n++)
{
string strsql = SQLStringList[n];
if (strsql.Trim().Length > 1)
{
sql = strsql;
cmd.CommandText = strsql;
count += cmd.ExecuteNonQuery();
}
}
tx.Commit();
return count;
}
catch (Exception ex)
{
LogHelper.SaveLog(ex);
tx.Rollback();
return 0;
}
}
}
See More Examples