//public static DataTable FillAdapterwithView(SqlCommand cmd)
//{
// cmd.Connection = conn;
// cmd.CommandType = CommandType.Text ;
// DataTable dttable;
// SqlDataAdapter adp = new SqlDataAdapter((SqlCommand)cmd);
// DataSet ds = new DataSet();
// adp.Fill(ds,cmd.CommandText );
// dttable = ds.Tables[0];
// return dttable;
//}
//public static DbCommand CreateCommand(String str)
//{
// DbCommand Dbcmd = conn.CreateCommand();
// opencon(conn);
// Dbcmd.CommandType = CommandType.StoredProcedure;
// Dbcmd.CommandText = str;
// closecon(conn);
// return Dbcmd;
//}
//public static DataTable ExecuteSelectCommand(DbCommand cmd)
//{
// cmd.Connection = conn;
// opencon(conn);
// DataTable dttable;
// SqlDataAdapter adp = new SqlDataAdapter( (SqlCommand) cmd );
// DataSet ds = new DataSet();
// // DbDataReader reader = cmd.ExecuteReader();
// // dttable = new DataTable();
// adp.Fill(ds , cmd.CommandText ) ;
// dttable = ds.Tables[0];
// //dttable.Load(reader);
// //reader.Close();
// //reader.Dispose();
// //closecon(conn);
// return dttable;
//}
public static Int32 ExecuteNonQuery(DbCommand cmd)
{
dy();// in comment
SqlConnection conn = new SqlConnection();
// conn.ConnectionString = @"Data Source =C3\C3SERVERMASTER,30000; Initial Catalog = jobcenter.INTMSGDB; User ID=sa; Password=06De1963++; Persist Security Info=true;";
conn = PageConn.extmsg();
cmd.Connection = conn;
opencon(conn);
Int32 rst;
rst = cmd.ExecuteNonQuery();
rst = (Int32)cmd.Parameters["@ReturnValue"].Value;
closecon(conn);
cmd.Dispose();
return(rst);
}
