摘要:
use ITwebgoif exists(select * from sysobjects where name='bank') --判断是否存在这个表 drop table bank --存在的话删除if exists(select * from sysobjects where name='transInfo')--判断是否存在这个表 drop table transInfo --存在的话删除gocreate table bank( customerName char(8) not null, --顾客姓名 cardID char(10) not null, 阅读全文
摘要:
<HTML> <HEAD> <title>年月日三联动下拉框</title> <meta http-equiv='Content-Type' content='text/html; charset=gb2312'> <meta name='author' content='http://singlepine.cnblogs.com/'> </HEAD> <body> <form name="form1"> 阅读全文
摘要:
private DataTable CreateTable() { DataTable dt = new DataTable("dirName"); #region table column DataColumn columnID = new DataColumn(); //创建一列 columnID.DataType = System.Type.GetType("System.Int32"); //数据类型 columnID.ColumnName = "ID"; //列名 columnID.AutoIncrement = true; 阅读全文