C_数据库操作大全

1、/*using System.Data;using System.Data.SqlClie nt;*/using (SqlC onn ecti on cn = new SqlC onn ecti on( %1)/Con figurati onMan ager.C onn ection Stri ngsdb2C onn ection Stri ng.C onn ecti on Stri ng/Data Source=;l nitial Catalog=myDataBase;User Id=;Password=;SqlComma nd cmd = new SqlComma nd(

2、%2,cn); /Select Cou nt(*) From jobs cn. Ope n();%2=cmd.ExecuteScalar(); /Message.I nn erHtml2. 单值比较/*using System.Data;using System.Data.SqlClie nt;*/using (SqlC onnection cn = new SqlC onnection( %1)/Con figurati onMan ager.C onnection Stri ngsdb2C onnection Stri ng.C onn ecti on Stri ng /Data Sour

3、ce=;I nitial Catalog=myDataBase;User Id=;Password=;SqlComma nd cmd = new SqlComma nd(%2,cn); /Select Cou nt(*) From jobs cn. Ope n();%2=cmd.ExecuteScalar(); /Message.I nn erHtmlif(%2=%3)%43. 显示表格/*using System.Data;using System.Data.SqlClie nt;*/DataSet ds=null;using (SqlC onnection cn = ne

4、w SqlC onnection( %1)/Con figurati onMan ager.C onnection Stri ngsdb2C onnection Stri ng.C onn ecti on Stri ng/Data Source=;I nitial Catalog=myDataBase;User Id=;Password=;cn. Ope n();ds=new DataSet();cmd.Fill(ds,%3); 作者MyDataGrid.DataSource=ds.Tables(%3).DefaultView; / 作者”MyDataGrid.DataBi

5、nd();4. 操作表格/*using System.Data;using System.Data.SqlClie nt;*/using (SqlC onnection cn = new SqlC onnection( %1)/Con figurati onMan ager.C onnection Stri ngsdb2C onnection Stri ng.C onn ecti on Stri ng/Data Source=;l nitial Catalog=myDataBase;User Id=;Password=;cn. Ope n();SqlDataAdapter c

6、md=new SqlDataAdapter(%2,c n); /Select * From jobsds=new DataSet();cmd.Fill(ds,%2); 作者MyDataGrid.DataSource=ds.Tables(%2).DefaultView; / 作者”MyDataGrid.DataBi nd();5. 数值范围查询/*using System.Data;using System.Data.SqlClie nt;*/using (SqlC onnection cn = new SqlC onnection( %1)/Con figurati onMan ager.C

7、onnection Stri ngsdb2C onnection Stri ng.C onn ecti on Stri ng/Data Source=;l nitial Catalog=myDataBase;User Id=;Password=;cn. Ope n();int min = In t32.Parse(jcb1.selectedItem);int max = In t32.Parse(jcb2.selectedItem);SqlDataAdapter cmd=new SqlDataAdapter(Select count(*) as pro_count From

8、ProPrice whereprice betwee n ”+ min + and + max,c n);ds=new DataSet();cmd.Fill(ds,%2); 作者MyDataGrid.DataSource=ds.Tables(%2).DefaultView; / 作者”MyDataGrid.DataBi nd();6关闭时断开连接/*using System.Data;using System.Data.SqlClie nt;*/using (SqlC onnection cn = new SqlC onnection( %1)/Con figurati onMan ager.

9、C onnection Stri ngsdb2C onnection Stri ng.C onn ecti on Stri ng/Data Source=;l nitial Catalog=myDataBase;User Id=;Password=;7.执行命令/*using System.Data;using System.Data.SqlClie nt;*/using (SqlC onnection cn = new SqlC onnection( %1)/Con figurati onMan ager.C onnection Stri ngsdb2C onnection

10、 Stri ng.C onn ecti on Stri ng/Data Source=;I nitial Catalog=myDataBase;User Id=;Password=;SqlComma nd cmd = new SqlComma nd(%2,cn); /INSERT INTO Dept (DeptNo,Dn ame, Loc) values (50, TECHNOLOGY, DENVER)cn. Ope n();cmd.ExecuteN on Query();8.Oracle8/8i/9i/10g/11g 数据库(thin 模式)/*using System.D

11、ata;using System.Data.OracleClie nt;*/stri ng conn Stri ng =Data Source=MyOracleDB;User Id=;Password=;I ntegrated Security=n o;9.DB2数据库/*using System.Data;using System.Data.OleDb;*/string conn Stri ng =Server=:myPortNumber;Database=myDataBase;UID=;PWD=;10.SQL Server 数据库/*using System.Data;u

12、sing System.Data.OleDb;*/string connString =Data Source=;lnitial Catalog=myDataBase;User ld=;Password=;/*Server=;Database=myDataBase;User ID=;Password=;Trusted_C onn ecti on=False;*/10.2.SQL Server2005 数据库/*using System.Data;using System.Data.OleDb;*/stri ngconn Stri ng=DataSource=

13、;I nitialCatalog=myDataBase;Userld=myUsername;Password=myPassword;/*Server=;Database=myDataBase;User ID=;Password=;Trusted_C onn ecti on=False;*/11.Sybase数据库/*using System.Data;using System.Data.OleDb;*/stri ngconn Stri ng=DataSource=myASEserver;Port=5000;Database=myDataBase;Uid=my

14、User name;Pwd=myPassword; /Sybase Adaptive Server En terprisestri ngconn Stri ng=DataSource=myservermyvolumemypatmydd.add;UserID=;Password=;ServerType=REMOTE; /Sybase Adva ntage Database Server12.Informix 数据库/*using System.Data;using System.Data.OleDb;*/stri ng conn Stri ng =Database=myDataBase;Host

15、=;Server=db_e ngin e_tcp;Service=1492; Protocol=on soctcp;UID=;Password=;13.PostgreSQL 数据库/*using System.Data;using System.Data.OleDb;*/stri ng conn Stri ng =User ID=;Password=;Host=localhost;Port=5432;Database=myDataBase;Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=O;

16、14连接access数据库/*using System.Data;using System.Data.OleDb;*/stri ngconn Stri ng =Provider=Microsoft.Jet.OLEDB.4.0;DataSource=%0;UserId=admi n;Password=; *.mdb15. 连接MySql数据库/*using System.Data;using System.Data.OleDb;*/stri ngconn Stri ng=Server=;Database=myDataBase;Uid=myUser name;Pwd=myPass

17、word;16. 程序计时DateTimerun TimeCon vert.ToDateTime(System.C on figuratio n.Con figurati on Sett in gs.AppSett in gsTimerR un At);/运行时间TimeSpa n run Time = new TimeSpa n(run Time.Ticks);/现在时间TimeSpa n timeNow = new TimeSpa n( DateTime.Now.Ticks);/时间间隔TimeSpa n ts = run Time.Subtract(timeNow);如果运行时间与当前时

18、间的差大于0,则任务执行时间为当日if(ts.TotalMilliseconds 0)return ts.TotalMillisec on ds;如果运行时间与当前时间的差小于0,则任务执行时间为次日Else差值的绝对值应加 1天return ts.Durati on ().Add( new TimeSpa n(1,0,0,0,0).TotalMilliseco nds;17. 延时/using System.Threadi ng;Thread.Sleep(l nt32.Parse(%1);18. 连接Excel文件stri ng conn Stri ng = Provider=Microso

19、ft.Jet.OLEDB.4.0;DataSource=%0;Exte ndedProperties=Excel 8.0; *.xls19. GDI+ 时钟/*using System.Data;using System.Draw ing;using System.Drawi ng.Drawi ng2D;*/private Point mickeyMouse = new Poin t(0, 0);private void Form1_Pa in t(object sen der, Pain tEve ntArgs e)DrawClock(e.Graphics);timer1.Start();p

20、rivate void DrawClock(Graphics g)/cen tre(120, 130);Recta ngle outRect = new Recta ngle(0, 0, 240, 260);Rectangle midRect = new Rectangle(7, 7, 226, 246);Rectangle inRect = new Rectangle(10, 10, 220, 240);Li nearGradie ntBrushoutlBlueBrush = newLin earGradie ntBrush(outRect,Color.FromArgb(0, 0, 100)

21、,Color.FromArgb(0, 0, 255), Li nearGradie ntMode.BackwardDiago nal);Lin earGradie ntBrushmidlBlueBrush = new Li nearGradie ntBrush(midRect,Color.FromArgb(0, 0, 255),Color.FromArgb(0, 0, 100), L in earGradie ntMode.BackwardDiago nal);Li nearGradie ntBrushin IBIueBrush= newLin earGradie ntBrush(i nRec

22、t,Color.FromArgb(0, 0, 100),Color.FromArgb(0, 0, 255), Li nearGradie ntMode.BackwardDiago nal);g.FillEllipse(outlBlueBrush, outRect); g.FillEllipse(midlBlueBrush, midRect); g.FillEllipse(i nlBlueBrush, i nRect); outlBlueBrush.Dispose(); midlBlueBrush.Dispose();in IBIueBrush.Dispose();Font myFont = n

23、ew Font(Arial, 20, FontStyle.Bold);g.DrawString(12, myFont, whiteBrush, 100, 10);g.DrawString(6, myFont, whiteBrush, 110, 223);g.DrawString(3, myFont, whiteBrush, 210, 120);g.DrawString(9, myFont, whiteBrush, 10, 120);g.DrawString(1, myFont, whiteBrush, 160, 26);g.DrawString(2, myFont, whiteBrush, 1

24、94, 64);g.DrawString(5, myFont, whiteBrush, 156, 210);g.DrawString(4, myFont, whiteBrush, 192, 174);g.DrawStri ng(11, myFo nt, whiteBrush, 55, 28);g.DrawStri ng(10, myFo nt, whiteBrush, 22, 66);g.DrawString(7, myFont, whiteBrush, 64, 210);g.DrawStri ng(8, myF ont, whiteBrush, 28, 174);myFon t.Dispos

25、e();whiteBrush.Dispose();/DateTime;g.Tra nslateTra nsform(120, 130, MatrixOrder.Appe nd);Pen hourPen = new Pen (Color.White, 6);hourPe n.SetLi neCap(Li neCap.Ro undAn chor,Lin eCap.ArrowA nchor,DashCap.Flat);Pen minu tePen = new Pen (Color.White, 4);mi nu tePe n. SetLi neCap(Li neCap.Ro undAn chor,L

26、in eCap.ArrowA nchor,DashCap.Flat);Pen sec on dPe n = new Pen( Color.Red, 2);int sec = DateTime.Now.Sec ond;int min = DateTime.Now.Mi nu te;int hour = DateTime.Now.Hour;double seco ndA ngle = 2.0 * Math.PI * sec / 60.0;double min uteA ngle = 2.0 * Math.PI * (min + sec / 60.0) / 60.0;double hourA ngl

27、e = 2.0 * Math.PI * (hour + min / 60.0) / 12.0;Point centre = new Poin t(0, 0);Point hourHand = new Point(int)(40 * Math.Sin(hourAngle),(in t)(-40 * Math.Cos(hourA ngle);g.DrawL in e(hourPe n, cen tre, hourHa nd);Point minHand = new Point(int)(80 * Math.Sin(minuteAngle),(in t)(-80 * Math.Cos(mi nute

28、A ngle);g.DrawLine(minutePen, centre, minHand);Point secHand = new Point(int)(80 * Math.Sin(secondAngle),(in t)(-80 * Math.Cos(seco ndA ngle);g.DrawL in e(sec on dPe n, cen tre, secHa nd);hourPe n.Dispose();minu tePe n.Dispose();sec on dPe n.Dispose();private void timer1_Tick(object sender, EventArg

29、s e)this .In validate。；private void hideToolStripMe nuItem_Click(object sen der, Even tArgs e) if (co ntextMe nuStrip1.ltems0.ToStri ng() = Hide)this.Hide();con textMe nuStrip1.ltems0.Text = Show;return;if (co ntextMe nuStrip1.ltems0.ToStri ng() = Show)this.Show();con textMe nuStrip1.ltems0.Text = H

30、ide;return;private void Form1_MouseDow n(o bject sen der, MouseEve ntArgs e)mickeyMouse = new Poi nt(-e.X, -e.Y);private void Form1_MouseMove(object sen der, MouseEve ntArgs e)if (e.Button = MouseButto ns.Left)Point mousePos = Con trol.MousePositi on;mousePos.Offset(mickeyMouse.X, mickeyMouse.Y);Loc

31、ati on = mousePos;private void no tifyIc on 1_DoubleClick(object sen der, Even tArgs e)if (co ntextMe nuStrip1.ltems0.ToStri ng() = Show)this.Show();con textMe nuStrip1.ltems0.Text = Hide;20数据库存入二进制字段数据 /*using System.Data;using Syste m.IO;using System.Data.SqlClie nt;*/private string File=;if(ope n

32、FileDialog1.ShowDialog()=DialogResult.OK)pictureBox1 .Im age=new Bitmap(ope nFileDialog1.FileName);FileName=ope nF ileDialog1.FileName;tryDataSet ds=new DataSet();sqlDataAdapter1.Fill(ds,%1); dbDataTable MyTable=ds.Tables0;DataRow MyRow=MyTable.Rows.Cou nt+1;MyRow%2=MyTable.NewRow(); /idMyRow%3=%5;

33、/FileNameMyRow%4=%6; /DescriptionFileStream fs=new FileStream(FileNmae,FileMode.Ope nO rCreate,FileAccess.Read); byte MyData=new bytefs.Length;fs.Read(MyData,0,(i nt)fs.Le ngth);MyRow%7=MyData; /FileDataMyTable.Rows.Add(MyRow);sqlDataAdapter1.Update(ds,%1);ds.AcceptCha nges();/存储成功catch(Excepti on e

34、x)/ex.Message.ToStri ng()21. 数据库取出二进制字段数据/*using System.Data;using Syste m.IO;*/private System.Wi ndows.Forms.Bi ndi ngMa nagerBase_Bi nd();private DataSet ds=new DataSet();sqlDataAdapter1.Fill(ds,%1); db_Bi nd=Bi ndi ngCo ntextds,%1;textBox1.DataBindings.Add(Text,ds,%1.%3); /filename textBox2.DataB

35、indings.Add(Text,ds,%1.%4); /description if(_B in d.Cou nt!=O)tryif(pictureBox1 .Im age!=null)pictureBox1 .Im age.Dispose();pictureBox1 .Im age=n ull;sqlDataAdapter1.SelectComma nd.Comma ndText=Select*From%1Where %2=+Co nvert.ToStri ng(i ndex); /idDataSet dataSet=new DataSet();sqlDataAdapter1.Fill(d

36、ataSet,%1);byte MyData=(byte)dataSet.Tables0.Rows0%5; /FileDataIn t32 size=MyData.GetUpperBou nd(0);FileStream fs=n ew FileStream(%6,FileMode.Ope nOrCreate,FileAccess.Wrtie); /temp.bmp fs.Write(MyData,0,size+1);fs.Close();pictureBox1 .Im age=new Bitmap(%6);catch(Excepti on ex)/ex.Message.ToStri ng()

37、22. 批量执行SQL和存储过程/ /储存过程- 删除；/ / / public DataTable GetTable(int id)DataTable dt = new DataTable();SqlC onn ecti on con = new SqlC onnection (server=.;database=master;User id=sa;pwd=sa); SqlCommand com = new SqlCommand(proc_Shoping, con); / 连接数据库执行存储过程 com.Comma ndType = Comma ndType.StoredProcedure;

38、/执行存储过程SqIParameter param; /添加一个输入参数param = new SqlParameter(id, SqlDbType.lnt); / 设置类型为输入类型，并传入参数；param.Directio n = ParameterDirectio n.l nput;param .Value= id; /当前参数的值param.Value =10;com.Parameters.Add(param); 将设置好的 sqlparameter 对象添加到 da 中da.Fill(dt);return dt; /返回 Datatable23. 自动填入数据C#模拟按键研究usin

39、g System;using System.Collect ion s.Ge neric;using System.Comp onen tModel;using System.Data;using System.Draw ing;using System.Linq;using System.Text;using System.Wi ndows.Forms;using System.Diag no stics;usi ng Microsoft.Wi n32;using System.R un time.I nteropServices;n amespace FindWindowpublic pa

40、rtial class Form1 : Formpublic Form1()In itializeComp onen t();此处用于取得计算器窗口的句柄System.Ru ntime.I nteropServices.DllImport(user32.dll,E ntryPoi nt = Fin dWi ndow) public static exter n int FindWin dow(stri ng lpClassName,stri ng lpWi ndowName);此处用于向窗口发送消息DllImport(user32.dll)public static exter n int Sen dMessage(I ntPtr hWnd, int Msg, int wParam, int lParam);System.R un timenteropServices.DlllmportCuser32.dll)public static extern bool SetWi ndowPos(l ntPtr hWnd,int hWndI nsertAfter,int X,int Y,int cx, int cy, int uFlags);/ 窗口置前public static void SetWi ndowPos(l ntPtr hWnd)/SetWi ndowPos(hWnd, -