sql 语句中涉及到unicode时,前面要加 N ,如 N'样式'
C#中的Hashtable 通过 ht[key] 形式查找 , 无法实现通过数组类似的位置索引定位
CONVERT(varchar(10),P2_2_4_InstallDate,120),sql 中用于日期类型数据长度缩小的函数形式
using System;
namespace ConsoleApplication1
{
/// <summary>
/// Class1 的摘要说明。
/// </summary>
class Class1
{
string connstring="server=dustin;uid=sa;Password=sa;database=hr93";
System.Data.SqlClient.SqlConnection conn;
System.Data.SqlClient.SqlCommand command;
string querystring;
private void write()
{
try
{
conn=new System.Data.SqlClient.SqlConnection(connstring);
System.IO.FileStream fs=new System.IO.FileStream(@"d:/project/c#/fulian/Bs/resume.rpt",System.IO.FileMode.Open);
byte[] nf=new byte[fs.Length];
fs.Read(nf,0,(int)fs.Length);
querystring="update skyCReports set report=@newvalue where id=100049";
command=new System.Data.SqlClient.SqlCommand(querystring,conn);
command.Parameters.Add("@newvalue",System.Data.SqlDbType.Image);
command.Parameters["@newvalue"].Value=nf;
conn.Open();
command.ExecuteNonQuery();
conn.Close();
}
catch(Exception ex)
{
Console.Write(ex.ToString());
}
}
private void read()
{
try
{
conn=new System.Data.SqlClient.SqlConnection(connstring);
System.IO.FileStream fs=new System.IO.FileStream(@"c:/resume1.rpt",System.IO.FileMode.Create,System.IO.FileAccess.ReadWrite);
querystring="select report from skyCReports where id=100049";
command=new System.Data.SqlClient.SqlCommand(querystring,conn);
conn.Open();
object temp=command.ExecuteScalar();
byte[] nf=(Byte [])temp;
fs.Write(nf,0,(int)nf.Length);
conn.Close();
}
catch(Exception ex)
{
Console.Write(ex.ToString());
}
}
/// <summary>
/// 应用程序的主入口点。
/// </summary>
[STAThread]
static void Main(string[] args)
{
Class1 c1=new Class1();
c1.write();
}
}
}