private void Button1_Click(object sender, System.EventArgs e)
{
//
// 例一:通过System.Data.SqlClient连接SQL Server插入图片与时间
// 建表语句
// if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TABLE1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
// drop table [dbo].[TABLE1]
// GO
//
// CREATE TABLE [dbo].[TABLE1] (
// [a] [int] IDENTITY (1, 1) NOT NULL ,
// [b] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
// [c] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
// [d] [datetime] NULL ,
// [e] [text] COLLATE Chinese_PRC_CI_AS NULL ,
// [f] [image] NULL
// ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
// GO
//
// ALTER TABLE [dbo].[TABLE1] ADD
// CONSTRAINT [PK_TABLE1] PRIMARY KEY CLUSTERED
// (
// [a]
// ) ON [PRIMARY]
// GO
//
//
//
// sqlConnection1.Open();
// SqlCommand sqlCommand1=new SqlCommand();
// sqlCommand1.Connection=sqlConnection1;
// sqlCommand1.CommandText="insert into table1 (b,c,d,e,f) values(@b,@c,@d,@e,@f)";
//
// byte[] ib=new Byte[60000];
// FileStream fs=new FileStream(@"G:/dot.gif",FileMode.Open ,FileAccess.Read );
// fs.Read(ib,0,60000);
//
// sqlCommand1.Parameters.Add("@b",SqlDbType.VarChar);
// sqlCommand1.Parameters.Add("@c",SqlDbType.VarChar);
// sqlCommand1.Parameters.Add("@d",SqlDbType.DateTime);
// sqlCommand1.Parameters.Add("@e",SqlDbType.Text);
// sqlCommand1.Parameters.Add("@f",SqlDbType.Image,(int)fs.Length);
// sqlCommand1.Parameters["@b"].Value="Jack";
// sqlCommand1.Parameters["@c"].Value="Fred";
// sqlCommand1.Parameters["@d"].Value="2001-01-23 12:23:45";
// sqlCommand1.Parameters["@e"].Value="skklelkwe";
// sqlCommand1.Parameters["@f"].Value=ib;
// sqlCommand1.ExecuteNonQuery();
// sqlConnection1.Close();
// 例二:通过System.Data.OleDb连接SQL Server插入图片与时间
// oleDbConnection1.Open();
// OleDbCommand OleDbCommand1=new OleDbCommand();
// OleDbCommand1.Connection=oleDbConnection1;
// OleDbCommand1.CommandText="insert into table1 (b,c,d,e,f) values(?,?,?,?,?)";
//
// byte[] ib=new Byte[60000];
// FileStream fs=new FileStream(@"G:/dot.gif",FileMode.Open ,FileAccess.Read );
// fs.Read(ib,0,60000);
//
// OleDbCommand1.Parameters.Add("@b",OleDbType.VarChar);
// OleDbCommand1.Parameters.Add("@c",OleDbType.VarChar);
// OleDbCommand1.Parameters.Add("@d",OleDbType.Date);
// OleDbCommand1.Parameters.Add("@e",OleDbType.VarChar);
// OleDbCommand1.Parameters.Add("@f",OleDbType.VarBinary);
// OleDbCommand1.Parameters["@b"].Value="Jack";
// OleDbCommand1.Parameters["@c"].Value="Fred";
// OleDbCommand1.Parameters["@d"].Value="2001-01-23 12:23:45";
// OleDbCommand1.Parameters["@e"].Value="skklelkwe";
// OleDbCommand1.Parameters["@f"].Value=ib;
// OleDbCommand1.ExecuteNonQuery();
// oleDbConnection1.Close();
// 例三:通过System.Data.OracleClient连接Oracle插入图片与时间
oracleConnection1.Open();
OracleCommand OracleCommand1=new OracleCommand();
OracleCommand1.Connection=oracleConnection1;
OracleCommand1.CommandText="insert into table1 (a,b,c,d) values(:a,:b,:c,:d)";
byte[] ib=new Byte[60000];
FileStream fs=new FileStream(@"G:/sx.bmp",FileMode.Open ,FileAccess.Read );
fs.Read(ib,0,60000);
OracleCommand1.Parameters.Add("a",OracleType.VarChar);
OracleCommand1.Parameters.Add("b",OracleType.VarChar);
OracleCommand1.Parameters.Add("c",OracleType.DateTime);
OracleCommand1.Parameters.Add("d",OracleType.Blob);
OracleCommand1.Parameters["a"].Value="Jack";
OracleCommand1.Parameters["b"].Value="Fred";
OracleCommand1.Parameters["c"].Value="2001-01-23 12:23:45";
OracleCommand1.Parameters["d"].Value=ib;
OracleCommand1.ExecuteNonQuery();
oracleConnection1.Close();
}
{
//
// 例一:通过System.Data.SqlClient连接SQL Server插入图片与时间
// 建表语句
// if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TABLE1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
// drop table [dbo].[TABLE1]
// GO
//
// CREATE TABLE [dbo].[TABLE1] (
// [a] [int] IDENTITY (1, 1) NOT NULL ,
// [b] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
// [c] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
// [d] [datetime] NULL ,
// [e] [text] COLLATE Chinese_PRC_CI_AS NULL ,
// [f] [image] NULL
// ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
// GO
//
// ALTER TABLE [dbo].[TABLE1] ADD
// CONSTRAINT [PK_TABLE1] PRIMARY KEY CLUSTERED
// (
// [a]
// ) ON [PRIMARY]
// GO
//
//
//
// sqlConnection1.Open();
// SqlCommand sqlCommand1=new SqlCommand();
// sqlCommand1.Connection=sqlConnection1;
// sqlCommand1.CommandText="insert into table1 (b,c,d,e,f) values(@b,@c,@d,@e,@f)";
//
// byte[] ib=new Byte[60000];
// FileStream fs=new FileStream(@"G:/dot.gif",FileMode.Open ,FileAccess.Read );
// fs.Read(ib,0,60000);
//
// sqlCommand1.Parameters.Add("@b",SqlDbType.VarChar);
// sqlCommand1.Parameters.Add("@c",SqlDbType.VarChar);
// sqlCommand1.Parameters.Add("@d",SqlDbType.DateTime);
// sqlCommand1.Parameters.Add("@e",SqlDbType.Text);
// sqlCommand1.Parameters.Add("@f",SqlDbType.Image,(int)fs.Length);
// sqlCommand1.Parameters["@b"].Value="Jack";
// sqlCommand1.Parameters["@c"].Value="Fred";
// sqlCommand1.Parameters["@d"].Value="2001-01-23 12:23:45";
// sqlCommand1.Parameters["@e"].Value="skklelkwe";
// sqlCommand1.Parameters["@f"].Value=ib;
// sqlCommand1.ExecuteNonQuery();
// sqlConnection1.Close();
// 例二:通过System.Data.OleDb连接SQL Server插入图片与时间
// oleDbConnection1.Open();
// OleDbCommand OleDbCommand1=new OleDbCommand();
// OleDbCommand1.Connection=oleDbConnection1;
// OleDbCommand1.CommandText="insert into table1 (b,c,d,e,f) values(?,?,?,?,?)";
//
// byte[] ib=new Byte[60000];
// FileStream fs=new FileStream(@"G:/dot.gif",FileMode.Open ,FileAccess.Read );
// fs.Read(ib,0,60000);
//
// OleDbCommand1.Parameters.Add("@b",OleDbType.VarChar);
// OleDbCommand1.Parameters.Add("@c",OleDbType.VarChar);
// OleDbCommand1.Parameters.Add("@d",OleDbType.Date);
// OleDbCommand1.Parameters.Add("@e",OleDbType.VarChar);
// OleDbCommand1.Parameters.Add("@f",OleDbType.VarBinary);
// OleDbCommand1.Parameters["@b"].Value="Jack";
// OleDbCommand1.Parameters["@c"].Value="Fred";
// OleDbCommand1.Parameters["@d"].Value="2001-01-23 12:23:45";
// OleDbCommand1.Parameters["@e"].Value="skklelkwe";
// OleDbCommand1.Parameters["@f"].Value=ib;
// OleDbCommand1.ExecuteNonQuery();
// oleDbConnection1.Close();
// 例三:通过System.Data.OracleClient连接Oracle插入图片与时间
oracleConnection1.Open();
OracleCommand OracleCommand1=new OracleCommand();
OracleCommand1.Connection=oracleConnection1;
OracleCommand1.CommandText="insert into table1 (a,b,c,d) values(:a,:b,:c,:d)";
byte[] ib=new Byte[60000];
FileStream fs=new FileStream(@"G:/sx.bmp",FileMode.Open ,FileAccess.Read );
fs.Read(ib,0,60000);
OracleCommand1.Parameters.Add("a",OracleType.VarChar);
OracleCommand1.Parameters.Add("b",OracleType.VarChar);
OracleCommand1.Parameters.Add("c",OracleType.DateTime);
OracleCommand1.Parameters.Add("d",OracleType.Blob);
OracleCommand1.Parameters["a"].Value="Jack";
OracleCommand1.Parameters["b"].Value="Fred";
OracleCommand1.Parameters["c"].Value="2001-01-23 12:23:45";
OracleCommand1.Parameters["d"].Value=ib;
OracleCommand1.ExecuteNonQuery();
oracleConnection1.Close();
}