|
|
|
随笔分类 - C#常用代码
摘要：using System; 2using System.Data; 3using System.Configuration; 4using System.Collections; 5using System.Web; 6using System.Web.Security; 7using System.Web.UI; 8using System.Web.UI.WebControls; 9using System.Web.UI.WebControls.WebParts;10using System.Web.UI.HtmlControls;11using System.Data.SqlClient;
阅读全文
posted @ 2011-03-29 00:05
摘要：SqlCommand是sql命令,执行后通过sqlDataAdapter返回填入DataSet SqlDataAdapter 有不同的构造函数， SqlDataAdapter(SqlCommand)； SqlDataAdapter(string,SqlConnection)；SqlDataAdapter da=new SqlDataAdapter(); da.SelectCommand=new SqlCommand(); da.SelectCommand.CommandText=strSql; da.SelectCommand.CommandTimeout=60; da.SelectComma
阅读全文
posted @ 2011-03-29 00:04
摘要：1//DataReader的详细用法 2 cmd.CommandText = "GetInfo"; 3 cmd.CommandType = CommandType.StoredProcedure; 4 SqlParameter param = cmd.Parameters.Add("@Fid",16); 5 param = cmd.Parameters.Add("@Fname",SqlDbType.VarChar,8); 6 param.Direction = ParameterDirection.Output; 7 param =
阅读全文
posted @ 2011-03-29 00:03
摘要：直接贴代码出来：using System; using System.IO; using System.Data; using System.Data.OleDb; namespace ConsoleDataReader { /// <summary> /// Class1 的摘要说明。 /// </summary> class DataReaderClass { /// <summary> /// 应用程序的主入口点。 /// </summary> [STAThread] static void Main(string[] args) { st
阅读全文
posted @ 2011-03-29 00:02
摘要：using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using ZedGraph;namespace zedGraphTest{ public partial class frmZedGraph : Form { public frmZedGraph() { InitializeComponent(); zedGraph1.Title
阅读全文
posted @ 2011-03-29 00:00
摘要：非连接数据访问类是在客户应用程序中进行实例化的。在使用非连接类时必须使用DataTable对象。DataTable对象DataTable对象将表格化数据表示为内存中的一个包含行、列和约束条件的表。创建一个DataTable对象：DataTable 对象 = new DataTable(对象名);例：DataTable Student = new DataTable(“student”);上例就创建了一个对象名为Student的DataTable对象。注意：在vs2005中有时会出现这样的错误：““DataTable”是“命名空间”，但此处被当做“类型”来使用”。那是因为DataTable是命名
阅读全文
posted @ 2011-03-22 13:16
摘要：using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace hetaoTest{ public partial class Form1 : Form { static SqlConnection conn = null; public Form1() { Initia
阅读全文
posted @ 2011-03-20 23:10
摘要：try{ string NameStr=this.txtName.Text; string AgeStr =this.txtAge.Text; SqlConnection conn = new SqlConnection("Data Source=hetao;Initial Catalog=TestDB;Integrated Security=True"); conn.Open(); SqlCommand cmd=new SqlCommand("select count(*) as flag from T_UserName where name="+&q
阅读全文
posted @ 2011-03-20 19:08
摘要：using System;using System.Collections.Generic;using System.Text;namespace ConsoleShui{ class Program { /**********************输出菱形**********************/ static void Main(string[] args) { int i; int j; int k; for (i = 0; i <=10; i++) /*输出上面10行的*号*/ { for(j = 0; j <10 - i; j++) Console.Write(&q
阅读全文
posted @ 2011-03-20 15:18
摘要：窗体顶端private void button2_Click(object sender, EventArgs e)2 {3 if (lboxMenu.Items.Count > 0)4 {5 Append(lboxMenu, progressBar);// 附加数据库操作6 MessageBox.Show("提示：附加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);7 }8 else9 MessageBox.Show("请选择要附加的数据库！", &q
阅读全文
posted @ 2011-03-11 12:55
|
|