public static System.Data.DataTable GetDataTable(string strSQL)
{
System.Data.DataTable dt = new System.Data.DataTable();
System.Data.SqlClient.SqlConnectionStringBuilder csb = new System.Data.SqlClient.SqlConnectionStringBuilder();
csb.DataSource = System.Environment.MachineName;
csb.DataSource = @"VMSTZHDB08\SZH_DBH_1";
csb.InitialCatalog = "HBD_CAFM_V3";
csb.DataSource = "CORDB2008R2";
csb.InitialCatalog = "Roomplanning";
// csb.DataSource = "cordb2014";
// csb.InitialCatalog = "ReportServer";
csb.DataSource = @"CORDB2008R2";
csb.InitialCatalog = "COR_Basic_SwissLife";
csb.IntegratedSecurity = true;
using (System.Data.Common.DbDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(strSQL, csb.ConnectionString))
{
da.Fill(dt);
}
return dt;
}
private void ProductTypeForm_Load(object sender, EventArgs e)
{
// TODO сделать для обновления
System.Data.SqlClient.SqlCommand cat_cmd = Producer.Categories.Select(Guid.Empty);
cat_cmd.Connection = this.cConnection;
System.Data.SqlClient.SqlDataAdapter catda = new System.Data.SqlClient.SqlDataAdapter(cat_cmd);
System.Data.DataTable tbl = new System.Data.DataTable("Categories");
catda.Fill(tbl);
this.cbxCategories.DataSource = tbl;
this.cbxCategories.DisplayMember = "CategoryName";
this.cbxCategories.ValueMember = "CategoryID";
string col_name = "Category";
if (!System.Convert.IsDBNull(this.product_type[col_name])) this.cbxCategories.SelectedValue = this.product_type[col_name];
this.isNewType = (System.Convert.IsDBNull(this.product_type["TypeId"]) || ((int)this.product_type["TypeId"]) < 0);
string caption = "Добавление нового типа продукта";
if (!this.isNewType)
{
int ptype = -1;
col_name = "TypeId";
if (!System.Convert.IsDBNull(this.product_type[col_name]))
ptype = (int)this.product_type[col_name];
col_name = "Name";
if (!System.Convert.IsDBNull(this.product_type[col_name]))
this.tbxProductType.Text = (string)this.product_type[col_name];
col_name = "Comment";
if (!System.Convert.IsDBNull(this.product_type[col_name]))
this.tbxComment.Text = (string)this.product_type[col_name];
caption = string.Format("Редактирование типа продукта #{0}", ptype);
}
this.Text = caption;
return;
}
private void cbxCategories_SelectedIndexChanged(object sender, EventArgs e)
{
if (!this.bBlockContent)
{
this.bBlockContent = true;
System.Data.SqlClient.SqlCommand cmd = null;
if (this.cbxCategories.SelectedIndex >= 0)
{
cmd = Producer.Commands.Products((Guid)this.cbxCategories.SelectedValue, System.Guid.Empty);
}
else
{
cmd = Producer.Commands.Products(Guid.Empty, System.Guid.Empty);
}
cmd.Connection = this.cConnection;
System.Data.SqlClient.SqlDataAdapter sda = new System.Data.SqlClient.SqlDataAdapter(cmd);
this.products = new DataTable("Products");
sda.Fill(this.products);
this.cbxProducts.DataSource = this.products;
this.cbxProducts.ValueMember = "ProductID";
this.cbxProducts.DisplayMember = "ProductName";
if( this.products.Rows.Count > 0 )
this.LoadPrices((Guid)this.products.Rows[0]["ProductID"]);
this.bBlockContent = false;
}
}
private void ChangePositionForm_Load(object sender, EventArgs e)
{
System.Data.SqlClient.SqlDataAdapter sda = null;
System.Data.SqlClient.SqlCommand prdccmd = Producer.Commands.Products(-1, -1 );
prdccmd.Connection = this.connection;
sda = new System.Data.SqlClient.SqlDataAdapter(prdccmd);
this.products = new System.Data.DataTable("Products");
sda.Fill(this.products);
this.cbxProducts.DataSource = this.products;
this.cbxProducts.DisplayMember = "ProductName";
this.cbxProducts.ValueMember = "ProductID";
this.cbxProducts.SelectedValue = this.product_id;
prdccmd = Producer.Commands.Products( -1, this.product_id );
prdccmd.Connection = this.connection;
sda = new System.Data.SqlClient.SqlDataAdapter(prdccmd);
System.Data.DataTable prods = new System.Data.DataTable("Product");
sda.Fill(prods);
System.Data.SqlClient.SqlCommand catccmd = Producer.Commands.ProductCategories();
catccmd.Connection = this.connection;
sda = new System.Data.SqlClient.SqlDataAdapter(catccmd);
this.categories = new System.Data.DataTable("Categories");
sda.Fill(this.categories);
this.cbxCategory.DataSource = this.categories;
this.cbxCategory.DisplayMember = "CategoryName";
this.cbxCategory.ValueMember = "CategoryID";
this.cbxCategory.SelectedValue = prods.Rows[0]["Category"];
//this.block = false;
//this.tbxCurrentProduct.Text = this.product["ProductName"].ToString();
}
private void ReloadStatistics()
{
System.Data.SqlClient.SqlCommand cmd = null;
string d_member = "";
string v_member = "";
if(this.tsmiByReceiver.Checked){
cmd = Statistics.Contents.ByReceiver(this.receipt, out d_member, out v_member);
}
else if (this.tsmiByBuyer.Checked)
{
cmd = Statistics.Contents.ByBuyer(this.receipt, out d_member, out v_member);
}else if( this.tsmiByProductTypes.Checked){
cmd = Statistics.Contents.ByProductTypes(this.receipt, out d_member, out v_member);
}
else if (this.tsmiByCategories.Checked)
{
cmd = Statistics.Contents.ByCategories(this.receipt, out d_member, out v_member);
}
if (cmd != null)
{
System.Data.DataTable content_stat = new DataTable("ContentsStatistics");
cmd.Connection = this.connection;
System.Data.SqlClient.SqlDataAdapter sda = new System.Data.SqlClient.SqlDataAdapter(cmd);
sda.Fill(content_stat);
this.dgvData.DataSource = content_stat;
this.dgvData.Columns[d_member].DisplayIndex = 0;
this.dgvData.Columns[v_member].DisplayIndex = 1;
}
else
{
MessageBox.Show("Не выбрано ни одного критерия!", "Ошибка");
}
return;
}
private System.Data.DataRow GetParameter(string IDParametro, int? IDPortal, int? IDSistema, string IDUsuario)
{
// Aca se lee la informacion de la base de datos
// y se preparan los layers
string connStr = ValidacionSeguridad.Instance.GetSecurityConnectionString();
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(connStr);
conn.Open();
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand
("SELECT * FROM dbo.SF_VALOR_PARAMETRO(@IDParametro, @IDPortal, @IDSistema, @IDUsuario)", conn);
System.Data.SqlClient.SqlParameter prm = new System.Data.SqlClient.SqlParameter("@IDParametro", System.Data.SqlDbType.VarChar, 100);
prm.Value = IDParametro;
cmd.Parameters.Add(prm);
prm = new System.Data.SqlClient.SqlParameter("@IDPortal", System.Data.SqlDbType.Int);
if (IDPortal.HasValue)
{
prm.Value = IDPortal.Value;
}
else
{
prm.Value = null;
}
cmd.Parameters.Add(prm);
prm = new System.Data.SqlClient.SqlParameter("@IDSistema", System.Data.SqlDbType.Int);
if (IDSistema.HasValue)
{
prm.Value = IDSistema.Value;
}
else
{
prm.Value = null;
}
cmd.Parameters.Add(prm);
prm = new System.Data.SqlClient.SqlParameter("@IDUsuario", System.Data.SqlDbType.VarChar);
if (IDUsuario != null)
{
prm.Value = IDUsuario;
}
else
{
prm.Value = null;
}
cmd.Parameters.Add(prm);
// IdParametro, Alcance, ValorTexto, ValorEntero, ValorDecimal, ValorLogico, ValorFechaHora
cmd.CommandType = System.Data.CommandType.Text;
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cmd);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
conn.Close();
return ds.Tables[0].Rows[0];
//return resultado;
}
private void FillDataSet()
{
//1. Make a Connection
System.Data.SqlClient.SqlConnection objCon;
objCon = new System.Data.SqlClient.SqlConnection();
objCon.ConnectionString = @"Data Source=(localDB)\v11.0;Initial Catalog = EmployeeProjects; Integrated Security=True;";
objCon.Open();
//2. Issue a Command
System.Data.SqlClient.SqlCommand objCmd;
objCmd = new System.Data.SqlClient.SqlCommand();
objCmd.Connection = objCon;
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = @"pSelEmployeeProjectHours";
//3. Process the Results
System.Data.DataSet objDS = new DataSet();
System.Data.SqlClient.SqlDataAdapter objDA;
objDA = new System.Data.SqlClient.SqlDataAdapter();
objDA.SelectCommand = objCmd;
objDA.Fill(objDS); // objCon.Open() is not needed!
dataGridView1.DataSource = objDS.Tables[0];
//4. Clean up code
objCon.Close();
dataGridView1.Refresh();
}
//Form 1
public void dataGrid2(DataTable dt, object textbox)
{
System.Data.SqlClient.SqlDataAdapter da;
string sql = string.Format("SELECT * FROM itemtable where Item_Name LIKE '%{0}%'", textbox);
da = new System.Data.SqlClient.SqlDataAdapter(sql, con);
da.Fill(dt);
}
//Form 1
public void dataGrid(DataTable dt, object table)
{
System.Data.SqlClient.SqlDataAdapter da;
string sql = "SELECT * FROM " + table;
da = new System.Data.SqlClient.SqlDataAdapter(sql, con);
da.Fill(dt);
}
public ReturnResult CheckUserAccount(string UserAccount, string UserPassWord)
{
ReturnResult ReturnResult = new ReturnResult();
ConnStr(0);
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandTimeout = 300;
System.Data.SqlClient.SqlDataAdapter Adp;
cmd.CommandText = "Select Login_id,Check_result from SchManage.dbo.V_Sys_id where Login_id=@Login_id and Pwd=@PWD"; //只要不是1就不是審核跟啟用
cmd.Parameters.AddWithValue("@Login_id", UserAccount);
cmd.Parameters.AddWithValue("@PWD", GetMD5(UserPassWord.Trim().ToUpper()));
Adp = new System.Data.SqlClient.SqlDataAdapter(cmd);
DataSet DBViewDS = new DataSet();
try
{
Adp.Fill(DBViewDS);
}
catch (Exception ex)
{
ReturnResult.ReturnMsgNo = -99;
ReturnResult.ReturnMsg = "WS的取得CheckUserAccount資料失敗" + ex.Message;
return ReturnResult;
}
if (DBViewDS.Tables.Count == 0)
{
ReturnResult.ReturnMsgNo = -98;
ReturnResult.ReturnMsg = "查詢不到您的帳號";
return ReturnResult;
}
if (DBViewDS.Tables[0].Rows.Count == 0)
{
ReturnResult.ReturnMsgNo = -98;
ReturnResult.ReturnMsg = "查詢不到您的帳號";
return ReturnResult;
}
if (Convert.ToString(DBViewDS.Tables[0].Rows[0]["Login_id"]).ToLower() == UserAccount.Trim().ToLower())
{
if (Convert.ToInt32(DBViewDS.Tables[0].Rows[0]["Check_result"]) == 1)
{
ReturnResult.ReturnMsgNo = 1;
ReturnResult.ReturnMsg = "登入成功";
return ReturnResult;
}
else
{
ReturnResult.ReturnMsgNo = -97;
ReturnResult.ReturnMsg = "帳號尚未啟用";
return ReturnResult;
}
}
else
{
ReturnResult.ReturnMsgNo = -96;
ReturnResult.ReturnMsg = "帳號不符";
return ReturnResult;
}
return ReturnResult;
}
protected void cmdSearch_OnClick(object source, EventArgs e)
{
try
{
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
conn.ConnectionString = "Server=devrystudentsp10.db.6077598.hostedresource.com;User Id=DeVryStudentSP10;Password=OidLZqBv4;";
conn.Open();
// Console.WriteLine(conn.State);
System.Data.SqlClient.SqlCommand comm = new System.Data.SqlClient.SqlCommand();
comm.Connection = conn;
string SQL = "select usertrackerid, trackkey, value,trackwhen from huber_tracker12 where 1=1";
if (txtKey.Text.Length > 0)
{
SQL += " and trackkey like @trackkey";
comm.Parameters.AddWithValue("@trackkey", "%" + txtKey.Text + "%");
}
if (txtValue.Text.Length > 0)
{
SQL += " and value like @value ";
comm.Parameters.AddWithValue("@value", "%" + txtValue.Text + "%");
}
Response.Write(SQL);
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter();
comm.CommandText = SQL;
#region "Dataset"
//this is a dataset
// System.Data.DataSet ds = new System.Data.DataSet();
//da.SelectCommand = comm;
//da.Fill(ds);
//this is a dataset
//rptDisplay.DataSource = ds.Tables[0];
#endregion
System.Data.SqlClient.SqlDataReader dr;
dr = comm.ExecuteReader();
if (dr.HasRows)
{
rptDisplay.DataSource = dr;
rptDisplay.DataBind();
}
}
catch (System.Data.SqlClient.SqlException sqlex)
{
//throw new would go with the changes to your web.config
//throw new Exception("Connecting to DB", sqlex.InnerException);
//this way is "roll your own"
Response.Redirect("anerrorpage.aspx?msg=Error Connecting To DB");
}
catch (Exception ex)
{
Response.Write("error!");
}
}
public CL_cad()
{
this.rq_sql = null;
this.cnx = @"";
this.oCNX = new System.Data.SqlClient.SqlConnection(this.cnx);
this.oCMD = null;
this.oDA = null;
this.oDS = new DataSet();
}
public System.Data.DataSet m_getRows(string rq_sql, string rows)
{
this.oDS = new DataSet();
this.rq_sql = rq_sql;
this.oCMD = new System.Data.SqlClient.SqlCommand(rq_sql, this.oCNX);
this.oDA = new System.Data.SqlClient.SqlDataAdapter(this.oCMD);
this.oDA.Fill(this.oDS, rows);
return this.oDS;
}
static RoomClient()
{
//string ConnectString = "metadata=res://*/Model2.csdl|res://*/Model2.ssdl|res://*/Model2.msl;provider=System.Data.SqlClient;provider connection string="Server=192.168.2.24,8605;Database=dbroom;User ID=sa;Password=654321;MultipleActiveResultSets=True"";
//System.Data.SqlClient.SqlConnectionStringBuilder sqlConnection = new System.Data.SqlClient.SqlConnectionStringBuilder();
//sqlConnection.DataSource = @"192.168.2.24,8605";
//sqlConnection.ApplicationName = "";
//sqlConnection.InitialCatalog = "dbroom";
//sqlConnection.IntegratedSecurity = true;
//sqlConnection.PersistSecurityInfo = true;
//sqlConnection.UserID = "sa";
//sqlConnection.Password ="******";
//string connectString = "Server=10.21.99.82;Database=SecureDB;User ID=secure;Password=secure;";
string connectString = "data source=10.21.99.80;initial catalog=SecureDB;persist security info=True;user id=secure;password=secure;MultipleActiveResultSets=True;App=EntityFramework;";
string dir = System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName;
dir = dir.Remove(dir.LastIndexOf('\\'));
if (System.IO.File.Exists(dir +@"\Server.txt"))
{
string serverSet = System.IO.File.ReadLines(dir + @".\Server.txt").First();
if (serverSet.Length < 300)
{
connectString = serverSet;
}
}
//System.Data.SqlClient.SqlConnection s = new System.Data.SqlClient.SqlConnection(sqlConnection.ConnectionString);
//System.Data.EntityClient.EntityConnectionStringBuilder ecsb = new System.Data.EntityClient.EntityConnectionStringBuilder();
//ecsb.Provider = "System.Data.SqlClient";
//ecsb.ProviderConnectionString = sqlConnection.ConnectionString;
//ecsb.Metadata = @"res://*/Model2.csdl|res://*/Model2.ssdl|res://*/Model2.msl";
//System.Data.EntityClient.EntityConnection ec = new System.Data.EntityClient.EntityConnection(ecsb.ConnectionString);
//dbroomClientEntities dbroom = new dbroomClientEntities(ec);
try
{
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter("Select * from tblHostConfig;", connectString);
System.Data.DataTable DT = new System.Data.DataTable();
adapter.Fill(DT);
adapter.Dispose();
objUrl = "tcp://" + DT.Rows[0]["IP"] + ":" + DT.Rows[0]["Port"] + "/RoomObj";
System.Runtime.Remoting.Channels.Tcp.TcpChannel tcp = new System.Runtime.Remoting.Channels.Tcp.TcpChannel(0);
System.Runtime.Remoting.Channels.ChannelServices.RegisterChannel(tcp, false);
//var HostData = (from o in dbroom.tblHostConfigs select o).First();
//objUrl = "tcp://" + HostData.IP + ":" + HostData.Port + "/RoomObj";
}
catch (Exception )
{
throw new Exception("資料庫讀取失敗");
}
roomEvent.RoomEvent += new RoomEventHandler(RoomClient_RoomEvent);
timer.Elapsed += new System.Timers.ElapsedEventHandler(timer_Elapsed);
timer.Interval = 10000;
timer.Start();
}
/// <summary>
/// 构造函数，接收一个SqlServer数据库连接对象SqlConnection
/// </summary>
public SqlDbOperHandler(System.Data.SqlClient.SqlConnection _conn)
{
conn = _conn;
dbType = DatabaseType.SqlServer;
conn.Open();
cmd = conn.CreateCommand();
da = new System.Data.SqlClient.SqlDataAdapter();
}
public static System.Data.DataTable GetDataTable(string sql, System.Data.SqlClient.SqlConnection conn)
{
System.Data.SqlClient.SqlDataAdapter adp = new System.Data.SqlClient.SqlDataAdapter(sql, conn);
adp.MissingSchemaAction = System.Data.MissingSchemaAction.AddWithKey;
System.Data.DataSet ds = new System.Data.DataSet();
adp.Fill(ds);
System.Data.DataTable tbl = ds.Tables[0];
return tbl;
}
private System.Data.DataSet MyDataSet()
{
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(strCon);
con.Open();
da_1 = new System.Data.SqlClient.SqlDataAdapter(sql_string, con);
System.Data.DataSet dat_set = new System.Data.DataSet();
da_1.Fill(dat_set, "Employee"); //adapter.Fill(ds); для всех таблиц
con.Close();
return(dat_set);
}
protected override System.Data.DataTable DataTableFromSQL(string SQLText,
string databaseName,
string tablename)
{
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(SQLText, GetConnection(databaseName));
System.Data.DataTable dt = new System.Data.DataTable();
da.Fill(dt);
dt.TableName = tablename;
return(dt);
}
protected static System.Data.DataTable RunQueryDataTableSqlClient(string sql)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(sql, ConnectionObjectSqlClient))
{
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(cmd);
System.Data.DataTable dt = new System.Data.DataTable();
adapter.Fill(dt); // Just pass the DataTable into the SqlDataAdapters Fill Method
return(dt);
}
}
private System.Data.DataSet MyDataSet()
{
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(str_con);
con.Open();
da_1 = new System.Data.SqlClient.SqlDataAdapter(SQL_string, con);
System.Data.DataSet data_set = new System.Data.DataSet();
da_1.Fill(data_set, "Test");
con.Close();
return data_set;
}
public override System.Data.Common.DbDataAdapter GetAdapter(string selectCommand, System.Data.Common.DbConnection connection, FastReport.Data.CommandParameterCollection parameters)
{
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(selectCommand, connection as System.Data.SqlClient.SqlConnection);
foreach (FastReport.Data.CommandParameter p in parameters)
{
System.Data.SqlClient.SqlParameter parameter = adapter.SelectCommand.Parameters.Add(p.Name, (System.Data.SqlDbType)p.DataType, p.Size);
parameter.Value = p.Value;
}
return(adapter);
}
//Finalmente, es el turno de definir CrearDataAdapter, el cual aprovecha el método Comando para crear el comando necesario.
protected override System.Data.IDataAdapter CrearDataAdapter(string procedimientoAlmacenado, params Object[] args)
{
var da = new System.Data.SqlClient.SqlDataAdapter((System.Data.SqlClient.SqlCommand)Comando(procedimientoAlmacenado));
if (args.Length != 0)
{
CargarParametros(da.SelectCommand, args);
}
return(da);
} // end CrearDataAdapter
public System.Data.DataTable RunQueryDataTable(string sql)
{
using (System.Data.SqlClient.SqlCommand sqlCommand = new System.Data.SqlClient.SqlCommand(sql, SqlConnection))
{
System.Data.DataTable dataTable = new System.Data.DataTable();
System.Data.SqlClient.SqlDataAdapter sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(sqlCommand);
sqlDataAdapter.Fill(dataTable); // Just pass the DataTable into the SqlDataAdapters Fill Method
return(dataTable);
}
}
private void sqlConnTest_Click(object sender, EventArgs e)
{
using (var conn = new System.Data.SqlClient.SqlConnection(@"Data Source=localhost\sqlexpress;Initial Catalog=BIMWEB_Test;Integrated Security=True"))
{
conn.Open();
var adapter = new System.Data.SqlClient.SqlDataAdapter("select * from Sys_UserInfo", conn);
var dt = new DataTable();
adapter.Fill(dt);
}
}
public DataTable QuerySqlDataTable(string sql)
{
using (var con = CreateCon())
{
DataTable table = new DataTable();
System.Data.SqlClient.SqlDataAdapter dapt = new System.Data.SqlClient.SqlDataAdapter(sql, con);
dapt.Fill(table);
return(table);
}
}
private void InitAdapter()
{
this._adapter = new System.Data.SqlClient.SqlDataAdapter();
System.Data.Common.DataTableMapping tableMapping = new System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "ONLclimbers";
tableMapping.ColumnMappings.Add("iid", "iid");
tableMapping.ColumnMappings.Add("photo", "photo");
this._adapter.TableMappings.Add(tableMapping);
}
public System.Data.DataSet consultaSimple(string sql_qry)
{
System.Data.SqlClient.SqlDataAdapter adaptador = new System.Data.SqlClient.SqlDataAdapter(sql_qry, con);
System.Data.DataSet datos = new System.Data.DataSet();
adaptador.Fill(datos, "resultado");
return datos;
}
public void UpdateDatabase(System.Data.DataSet ds)
{
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(strCon);
con.Open();
System.Data.SqlClient.SqlDataAdapter da_1 = new System.Data.SqlClient.SqlDataAdapter(sql_string, con);
System.Data.SqlClient.SqlCommandBuilder cb = new System.Data.SqlClient.SqlCommandBuilder(da_1);
cb.DataAdapter.Update(ds.Tables[0]);
}
public DataSet QuerySqlDataSet(string sql)
{
using (var con = CreateCon())
{
DataSet ds = new DataSet();
System.Data.SqlClient.SqlDataAdapter dapt = new System.Data.SqlClient.SqlDataAdapter(sql, con);
dapt.Fill(ds);
return(ds);
}
}
private void spesifikasi()
{
q = "SELECT MERK,TYPE,PROCESSOR, HDD, RAM, VGA,KONDISI,KODE,WARNA FROM GUDANG";
if (global.ds.Tables["data2"] != null)
{
global.ds.Tables["data2"].Clear();
}
ad2 = new System.Data.SqlClient.SqlDataAdapter(q, global.con);
ad2.Fill(global.ds, "data2");
}
private System.Data.DataSet MyDataSet()
{
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(strCon);
con.Open();
da_1 = new System.Data.SqlClient.SqlDataAdapter(sql_string, con);
System.Data.DataSet dat_set = new System.Data.DataSet();
da_1.Fill(dat_set, "Table_Data_1");
con.Close();
return(dat_set);
}
public List <UsuariosView> SP_62_CONSULTAR_USUARIOS()
{
Conectar();
_commandTimeout = 600;
DataTable result = new DataTable();
List <UsuariosView> listaUsuarios = new List <UsuariosView>();
try
{
System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand("SP_62_CONSULTAR_USUARIOS", cnn);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandTimeout = _commandTimeout;
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(command);
da.Fill(result);
command.Dispose();
}
catch (Exception e)
{
result = null;
Console.WriteLine(e.StackTrace);
}
finally
{
Desconectar();
}
if (result != null)
{
if (result != null && result.Rows.Count > 0)
{
listaUsuarios = result.AsEnumerable().Select(x => new UsuariosView
{
IdUsuario = x.Field <int>("ID_USUARIO"),
Usuario = x.Field <string>("USUARIO"),
Clave = x.Field <string>("CLAVE"),
Nombres = x.Field <string>("NOMBRES"),
Apellidos = x.Field <string>("APELLIDOS"),
Email = x.Field <string>("EMAIL"),
ForzarContraseña = x.Field <bool>("FORZAR_CAMBIO"),
Foto = x.Field <byte[]>("FOTO"),
IdEstado = x.Field <int>("ID_ESTADO"),
Roles = x.Field <string>("ROLES"),
IdUsuarioCreacion = x.Field <int>("ID_USUARIO_CREACION"),
IdUsuarioActualizacion = x.Field <int>("ID_USUARIO_ACTUALIZACION"),
FechaHoraCreacion = x.Field <DateTime>("FECHA_HORA_CREACION"),
FechaHoraActualizacion = x.Field <DateTime>("FECHA_HORA_ACTUALIZACION")
}).ToList();
}
}
return(listaUsuarios);
}
static void Main(string[] args)
{
Console.WriteLine("Start");
//Bil b = new Bil();
//try
//{
//}
//catch (Exception)
//{
//}
//finally
//{
// b.Dispose();
//}
using (Bil b = new Bil())
{
//b.gem
} // dispose bliver kaldt, og den
// skal sørge for at lukke og rydde op...
Console.WriteLine("S**t");
Bil t = new Bil();
t.Dispose();
Console.WriteLine();
//System.Data.SqlClient.SqlConnection cn = new System.Data.SqlClient.SqlConnection("...");
//cn.Open();
//cn.Dispose();
using (System.Data.SqlClient.SqlConnection cn = new System.Data.SqlClient.SqlConnection("..."))
{
cn.Open();
using (System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("select * ", cn))
{
} // dispose
}
//using (System.Random rnd = new Random())
//{
//}
var a = System.IO.File.ReadAllLines(@"c:\temp\data.csv");
}
public string ExportExcel(int userId, System.Collections.Hashtable filters, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
ReportDataObject ds = new ReportDataObject();
string ArticleCode = null;
string Description = null;
string Season = null;
if (filters.ContainsKey("ArticleCode"))
{
ArticleCode = filters["ArticleCode"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("Description"))
{
Description = filters["Description"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("Season") && filters["Season"] != null && !string.IsNullOrEmpty(filters["Season"].ToString()))
{
Season = filters["Season"].ToString().Replace("'", "''");
}
try
{
System.Data.SqlClient.SqlDataAdapter adap = new System.Data.SqlClient.SqlDataAdapter();
adap.SelectCommand = new System.Data.SqlClient.SqlCommand("StandardCostPriceOverviewRpt_function_ExportProduct", new System.Data.SqlClient.SqlConnection(Library.Helper.GetSQLConnectionString()));
adap.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
adap.SelectCommand.Parameters.AddWithValue("@Season", Season);
adap.SelectCommand.Parameters.AddWithValue("@ArticleCode", ArticleCode);
adap.SelectCommand.Parameters.AddWithValue("@Description", Description);
adap.TableMappings.Add("Table", "StandardCostPriceOverviewRpt_ProductSearchResult_View");
adap.Fill(ds);
ds.AcceptChanges();
return(Library.Helper.CreateReportFileWithEPPlus(ds, "StandardCostPriceOverviewRpt"));
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
{
notification.DetailMessage.Add(ex.InnerException.Message);
}
return(string.Empty);
}
}
//---------------------------------------------------------------------
void OtherSnips1()
{
//---------------------------------------------
System.Data.SqlClient.SqlDataAdapter SqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
System.Data.DataSet Dataset1 = new System.Data.DataSet();
Dataset1.Tables.Add(new System.Data.DataTable("Table1"));
//<Snippet26>
try
{
SqlDataAdapter1.Update(Dataset1.Tables["Table1"]);
}
catch (Exception e)
{
// Error during Update, add code to locate error, reconcile
// and try to update again.
}
//</Snippet26>
//---------------------------------------------
NorthwindDataSet northwindDataSet = new NorthwindDataSet();
//<Snippet12>
string xmlData = northwindDataSet.GetXml();
//</Snippet12>
//<Snippet13>
string filePath = "ENTER A VALID FILEPATH";
northwindDataSet.WriteXml(filePath);
//</Snippet13>
//---------------------------------------------
//<Snippet15>
NorthwindDataSetTableAdapters.RegionTableAdapter regionTableAdapter =
new NorthwindDataSetTableAdapters.RegionTableAdapter();
regionTableAdapter.Insert(5, "NorthWestern");
//</Snippet15>
//---------------------------------------------
//<Snippet16>
System.Data.SqlClient.SqlConnection sqlConnection1 =
new System.Data.SqlClient.SqlConnection("YOUR CONNECTION STRING");
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "INSERT Region (RegionID, RegionDescription) VALUES (5, 'NorthWestern')";
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
cmd.ExecuteNonQuery();
sqlConnection1.Close();
//</Snippet16>
}
public override int SetSchedule(string description, int id = 0)
{
System.Data.DataTable dt = new System.Data.DataTable();
string command = "CDM_SET_SCHEDULE";
System.Data.SqlClient.SqlConnection sqlcnn = new System.Data.SqlClient.SqlConnection(ConnectionString);
System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[2];
try
{
sqlcnn.Open();
parameters[0] = new System.Data.SqlClient.SqlParameter("@ID", id)
{
SqlDbType = System.Data.SqlDbType.Int,
Direction = System.Data.ParameterDirection.Input
};
parameters[1] = new System.Data.SqlClient.SqlParameter("@DESCRIPTION", description)
{
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 250
};
using (System.Data.SqlClient.SqlCommand sqlcmd = new System.Data.SqlClient.SqlCommand(command, sqlcnn))
{
sqlcmd.CommandTimeout = CmdTimeOut;
sqlcmd.CommandType = System.Data.CommandType.StoredProcedure;
if ((parameters != null))
{
sqlcmd.Parameters.AddRange(parameters);
}
using (System.Data.SqlClient.SqlDataAdapter sqlda = new System.Data.SqlClient.SqlDataAdapter(sqlcmd))
{
sqlda.Fill(dt);
}
}
if (dt.Rows.Count > 0)
{
return(int.Parse(dt.Rows[0][0].ToString()));
}
}
catch (Exception ex)
{
throw new Exception("Error al ejecutar la función SqlDataProvider.SetSchedule, " + ex.Message, ex);
}
finally
{
sqlcnn.Close();
}
return(0);
}
public static void setupShoppingCartAdapter()
{
con.ConnectionString = ConStr;
cartCmd.Connection = con;
cartCmd.CommandType = System.Data.CommandType.Text;
cartCmd.CommandText = "Select * from ShoppingCart order by ProductID";
cartAdapter = new System.Data.SqlClient.SqlDataAdapter(cartCmd);
cartAdapter.FillSchema(tblShoppingCart, System.Data.SchemaType.Source);
}
private System.Data.DataSet MyDataSet()
{
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(strCon);
con.Open();
dataAdap1 = new System.Data.SqlClient.SqlDataAdapter(sql_string, con);
System.Data.DataSet dataSet = new System.Data.DataSet();
dataAdap1.Fill(dataSet, "Table_Data_1");
con.Close();
return dataSet;
}
public static DataSet PDataset(string select_statement)
{
System.Data.SqlClient.SqlConnection _con = new System.Data.SqlClient.SqlConnection();
_con.ConnectionString = GetConnectionString();
System.Data.SqlClient.SqlDataAdapter ad = new System.Data.SqlClient.SqlDataAdapter(select_statement, _con);
DataSet ds = new DataSet();
ad.Fill(ds);
_con.Close();
return(ds);
}
public ActionResult startADODOTNETQuery()
{
string connectionstring = "Data Source=(localdb)\\LocalInstance;Initial Catalog=AdventureWorks2012;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework";
string QUERY = "SELECT * FROM RANDOMDATA";
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(QUERY, connectionstring);
DataSet SpoolClients = new DataSet();
adapter.Fill(SpoolClients, "RANDOMDATA");
return(View("Index"));
}
public DataTable check_ProductInstock(String qty)
{
connectdb();
sql = "Select * from check_ProductInStock where Qty <= '" + qty + "'";
cmd.CommandText = sql;
da = new System.Data.SqlClient.SqlDataAdapter(sql, cn);
DataTable get = new DataTable();
da.Fill(get);
return(get);
}
public static void setupRoleAdapter()
{
con.ConnectionString = ConStr;
roleCmd.Connection = con;
roleCmd.CommandType = System.Data.CommandType.Text;
roleCmd.CommandText = "Select * from RoleInfo order by RoleName";
roleAdapter = new System.Data.SqlClient.SqlDataAdapter(roleCmd);
roleAdapter.FillSchema(tblRoleData, System.Data.SchemaType.Source);
}
public DataTable Search_Data(string query)
{
Conexion conn = new Conexion();
conn.Begin_conexion();
System.Data.SqlClient.SqlDataAdapter qu;
DataSet ds = new DataSet();
qu = new System.Data.SqlClient.SqlDataAdapter(query, conn.conexion);
qu.Fill(ds);
conn.conexion.Close();
return ds.Tables[0];
}
public DataTable getProduct_instock()
{
connectdb();
sql = "Select *from check_ProductInStock";
cmd.CommandText = sql;
da = new System.Data.SqlClient.SqlDataAdapter(sql, cn);
DataTable get = new DataTable();
da.Fill(get);
return(get);
}
public static void setupUserDataAdapter()
{
con.ConnectionString = ConStr;
userCmd.Connection = con;
userCmd.CommandType = System.Data.CommandType.Text;
userCmd.CommandText = "Select * from UserData order by userID";
userAdapter = new System.Data.SqlClient.SqlDataAdapter(userCmd);
userAdapter.FillSchema(tblUserData, System.Data.SchemaType.Source);
}
public static void setupProdAdapter()
{
con.ConnectionString = ConStr;
prodCmd.Connection = con;
prodCmd.CommandType = System.Data.CommandType.Text;
prodCmd.CommandText = "Select * from product order by ProductID";
prodAdapter = new System.Data.SqlClient.SqlDataAdapter(prodCmd);
prodAdapter.FillSchema(product, System.Data.SchemaType.Source);
}
public System.Data.DataTable SelectUserData()
{
this.Query = "SELECT Name,Email,Job,convert(varchar, Date, 6) as Date FROM [dbo].[User]";
this.SqlConnection = new System.Data.SqlClient.SqlConnection(this.AzureDataBaseConnectionString());
this.SqlConnection.Open();
this.SqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(this.Query, this.SqlConnection);
System.Data.DataTable DataTable = new System.Data.DataTable();
this.SqlDataAdapter.Fill(DataTable);
this.SqlConnection.Close();
return(DataTable);
}
/// <summary>
/// Get the dataset returned by the SQL statement when executed on the connected database.
/// Original code from lecture slides:
/// <code>
/// // Get the data set generated by the sqlStatement
/// public DataSet getDataSet(string sqlStatement)
/// {
/// DataSetdataSet;
/// // create the object dataAdapterto manipulate a table from the database StudentDissertationsspecified by connectionToDB
/// dataAdapter= newSystem.Data.SqlClient.SqlDataAdapter(sqlStatement, connectionToDB);
/// // create the dataset
/// dataSet= newcSystem.Data.DataSet();
/// dataAdapter.Fill(dataSet);
/// //return the dataSet
/// return dataSet;
/// }
/// </code>
/// </summary>
/// <param name="sqlStatement">An SQL statement to execute in the database</param>
/// <returns>The dataset output by the input SQL statement</returns>
public System.Data.DataSet GetDataSet(string sqlStatement)
{
System.Data.DataSet dataSet;
// create the object dataAdapter
dataAdapter = new System.Data.SqlClient.SqlDataAdapter(sqlStatement, dbConnection);
// create the dataset
dataSet = new System.Data.DataSet();
dataAdapter.Fill(dataSet);
//return the dataSet
return(dataSet);
}
private System.Data.DataSet DataSet() //connects to the database and fills the dataset
{
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(strCon); //create a variable of sqlconnection type
con.Open(); //open the connection
da1 = new System.Data.SqlClient.SqlDataAdapter(sql_string, con); //setting the sql data adapter
System.Data.DataSet dat_set = new System.Data.DataSet(); //creating the data set
da1.Fill(dat_set, "Table_Data_1"); //filling the dataset and naming the fill table_data_1
con.Close(); //closing the connection
return(dat_set); //returning the dataset
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.cn = new System.Data.SqlClient.SqlConnection();
this.daInbox = new System.Data.SqlClient.SqlDataAdapter();
this.dsMessage1 = new LIMS.Message.dsMessage();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
((System.ComponentModel.ISupportInitialize)(this.dsMessage1)).BeginInit();
this.Message.InitializeRow += new Infragistics.WebUI.UltraWebGrid.InitializeRowEventHandler(this.Message_InitializeRow);
this.Del.Click += new Infragistics.WebUI.WebDataInput.ClickHandler(this.Del_Click);
//
// cn
//
this.cn.ConnectionString = "workstation id=QDMT;packet size=4096;user id=sa;integrated security=SSPI;data sou" +
"rce=\".\";persist security info=False;initial catalog=lims";
//
// daInbox
//
this.daInbox.InsertCommand = this.sqlInsertCommand1;
this.daInbox.SelectCommand = this.sqlSelectCommand1;
this.daInbox.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "收件箱", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("标题", "标题"),
new System.Data.Common.DataColumnMapping("日期", "日期"),
new System.Data.Common.DataColumnMapping("发件人", "发件人"),
new System.Data.Common.DataColumnMapping("已阅", "已阅"),
new System.Data.Common.DataColumnMapping("收件人ID", "收件人ID")
})
});
//
// dsMessage1
//
this.dsMessage1.DataSetName = "dsMessage";
this.dsMessage1.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT ID, 标题, 发送时间 AS 日期, 发件人, 已阅, 收件人ID FROM 收件箱";
this.sqlSelectCommand1.Connection = this.cn;
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO 收件箱(标题, 发送时间, 发件人, 已阅, 收件人ID) VALUES (@标题, @发送时间, @发件人, @已阅, @收件人ID);" +
" SELECT ID, 标题, 发送时间 AS 日期, 发件人, 已阅, 收件人ID FROM 收件箱";
this.sqlInsertCommand1.Connection = this.cn;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@标题", System.Data.SqlDbType.NVarChar, 1073741823, "标题"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@发送时间", System.Data.SqlDbType.DateTime, 8, "日期"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@发件人", System.Data.SqlDbType.NVarChar, 10, "发件人"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@已阅", System.Data.SqlDbType.Bit, 1, "已阅"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@收件人ID", System.Data.SqlDbType.Int, 4, "收件人ID"));
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.dsMessage1)).EndInit();
}
public DataTable EjecutarProcedimientoAlmacenado(string nombreProceso,string datos)
{
Conexion conn = new Conexion();
conn.Begin_conexion();
System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand(nombreProceso);
command.CommandType = CommandType.StoredProcedure;
string cadenaProcedimiento = nombreProceso + datos;
System.Data.SqlClient.SqlDataAdapter oAdapter = new System.Data.SqlClient.SqlDataAdapter(cadenaProcedimiento,conn.conex);
DataTable oTabla = new DataTable();
oAdapter.Fill(oTabla);
return oTabla;
}
private System.Data.DataSet MyDataSet()
{
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(strCon);
// SqlConnection will use our connection string in strCon to connect to the database.
con.Open();//we open a connection to the database.
da_1 = new System.Data.SqlClient.SqlDataAdapter(sql_string, con);//which records and which database
System.Data.DataSet dat_set = new System.Data.DataSet();//l hold all the records from the table.
da_1.Fill(dat_set, "Table_Data_1");
con.Close( );
return dat_set;
}
//this takes a SQL select and returns a dataset
public System.Data.DataSet GetDataSet(string SQL)
{
if (_connection.State != System.Data.ConnectionState.Open)
{
OpenConnection(connectionstring);
}
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter ();
System.Data.DataSet ds = new System.Data.DataSet();
_command.Connection = _connection;
_command.CommandText = SQL;
da.SelectCommand = _command;
da.Fill(ds);
return ds;
}
protected System.Data.DataTable getData(string sql)
{
try
{
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(sql, conNo);
System.Data.DataTable dtable = new System.Data.DataTable();
adapter.Fill(dtable);
return dtable;
}
catch(System.Exception ex)
{
conCloseNo();
return null;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection _SqlConnection = new System.Data.SqlClient.SqlConnection();
_SqlConnection.ConnectionString = "Server=tcp:iaz43o1slt.database.windows.net,1433;Database=NewCustomerDb2;User ID=Singhav@iaz43o1slt;Password=Tirlok_0173;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;";
System.Data.SqlClient.SqlCommand _SqlCommand = new System.Data.SqlClient.SqlCommand("Select * From customer", _SqlConnection);
System.Data.SqlClient.SqlDataAdapter _SqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter();
_SqlDataAdapter.SelectCommand = _SqlCommand;
DataTable _DataTable = new DataTable();
_DataTable.Locale = System.Globalization.CultureInfo.InvariantCulture;
_SqlDataAdapter.Fill(_DataTable);
GridView1.DataSource = _DataTable;
GridView1.DataBind();
}
private void cbxCategories_SelectedIndexChanged(object sender, EventArgs e)
{
if (!this.bBlockContent && !System.Convert.IsDBNull( this.cbxCategories.SelectedValue )){
Guid cat_id = (Guid)this.cbxCategories.SelectedValue;
System.Data.SqlClient.SqlCommand tp_cmd = Producer.ProductTypes.Select(cat_id);
tp_cmd.Connection = this.cConnection;
System.Data.SqlClient.SqlDataAdapter tpda = new System.Data.SqlClient.SqlDataAdapter(tp_cmd);
this.types_table = new System.Data.DataTable("Types");
tpda.Fill(this.types_table);
this.clbxTypes.DataSource = this.types_table;
this.clbxTypes.DisplayMember = "Name";
this.clbxTypes.ValueMember = "TypeId";
this.RefreshProductList(cat_id, null );
}
return;
}
private void ByMonths(object sender, EventArgs e)
{
try
{
System.Data.SqlClient.SqlCommand mnth = Statistics.Purchases.ByMonths();
mnth.Connection = this.connection;
System.Data.SqlClient.SqlDataAdapter sda = new System.Data.SqlClient.SqlDataAdapter(mnth);
System.Data.DataTable st = new System.Data.DataTable("Summary");
sda.Fill(st);
ZedGraph.GraphPane pane = this.zgcStatistics.GraphPane;
pane.CurveList.Clear();
pane.GraphObjList.Clear();
pane.YAxis.Title.Text = "Сумма, р";
ZedGraph.PointPairList list = new ZedGraph.PointPairList();
foreach (System.Data.DataRow row in st.Rows)
{
int year = 1970;
int month = 1;
if(!System.Convert.IsDBNull(row["Year"]) &&
!System.Convert.IsDBNull(row["Month"]) ){
year = (int)row["Year"];
month = (int)row["Month"];
System.DateTime dt = new DateTime(year, month, 1);
ZedGraph.XDate xDate = new ZedGraph.XDate(dt);
decimal val = (decimal)row["Summary"];
list.Add(xDate.XLDate, (double)val);
}
}
ZedGraph.BarItem curve = pane.AddBar("", list, Color.Blue);
// Для оси X установим календарный тип
pane.XAxis.Type = ZedGraph.AxisType.Date;
// pretty it up a little
pane.Chart.Fill = new ZedGraph.Fill(Color.White, Color.LightGoldenrodYellow, 45.0f);
pane.Fill = new ZedGraph.Fill(Color.White, Color.FromArgb(220, 220, 255), 45.0f);
// Tell ZedGraph to calculate the axis ranges
this.zgcStatistics.AxisChange();
this.zgcStatistics.Invalidate();
}catch (System.Exception ex){
MessageBox.Show(ex.Message);
}
return;
}
private void MakersListForm_Load(object sender, EventArgs e)
{
this.lvMakers.Columns.Add("№", 30);
this.lvMakers.Columns.Add("Идентификатор", 30);
this.lvMakers.Columns.Add("Наименование организации", 190);
this.lvMakers.Columns.Add("Тип", 50);
this.lvMakers.Columns.Add("Продавец", 50);
//this.lvMakers.Columns.Add("Создан", 50);
System.Data.SqlClient.SqlCommand cmd = Producer.Maker.Select(-1);
cmd.Connection = this.cConnection;
System.Data.SqlClient.SqlDataAdapter sda = new System.Data.SqlClient.SqlDataAdapter(cmd);
this.makers = new System.Data.DataTable("Makers");
sda.Fill(this.makers);
this.RefreshMakersList();
}
protected System.Data.DataTable doAddUpdateDelete(System.Data.SqlClient.SqlCommand sql, bool ReturnDataTable)
{
try
{
sql.Connection = conNo;
sql.CommandType = System.Data.CommandType.StoredProcedure;
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(sql);
System.Data.DataTable dtable = new System.Data.DataTable();
adapter.Fill(dtable);
return dtable;
}
catch (System.Exception ex)
{
conCloseNo();
return null;
}
}
private void EditCompanyForm_Load(object sender, EventArgs e)
{
System.Data.SqlClient.SqlCommand cmd = Brands.Companies.Select(Guid.Empty);
cmd.Connection = this.connection;
System.Data.SqlClient.SqlDataAdapter sda = new System.Data.SqlClient.SqlDataAdapter(cmd);
System.Data.DataTable companies = new System.Data.DataTable("Companies");
sda.Fill(companies);
DataRow dr = companies.NewRow();
dr["CompanyName"] = "Компания не выбрана";
dr["CompanyID"] = DBNull.Value;
companies.Rows.InsertAt(dr, 0);
this.cbxCompanies.DataSource = companies;
this.cbxCompanies.DisplayMember = "CompanyName";
this.cbxCompanies.ValueMember = "CompanyID";
if (this.parent != null)
this.cbxCompanies.SelectedValue = this.parent["CompanyID"];
else if (!System.Convert.IsDBNull(this.company["ParentID"]))
this.cbxCompanies.SelectedValue = this.company["ParentID"];
else
this.cbxCompanies.SelectedValue = DBNull.Value;
// A new company or existing?
if (this.company.RowState == DataRowState.Unchanged ||
this.company.RowState == DataRowState.Added)
{
this.Text = string.Format("Редактирование компании ID: {0}", this.company["CompanyID"]);
string col_name = "CompanyName";
if (!System.Convert.IsDBNull(this.company[col_name]))
this.tbxCompanyName.Text = (string)this.company[col_name];
col_name = "Address";
if (!System.Convert.IsDBNull(this.company[col_name]))
this.tbxAddress.Text = (string)this.company[col_name];
col_name = "WebSite";
if (!System.Convert.IsDBNull(this.company[col_name]))
this.tbxWebAddress.Text = (string)this.company[col_name];
col_name = "Phones";
if (!System.Convert.IsDBNull(this.company[col_name]))
this.tbxPhones.Text = (string)this.company[col_name];
}
else
{
this.Text = "Создание новой компании";
}
return;
}
