1 ///
2 /// 得到某个表中某字段的数据类型 例如:DateTime,Varchar,int,
3 ///
4 /// 表名
5 /// 字段名
6 ///
7 public string GetFieldDataType(string sTableName, string sFieldName)
8 {
9 string sSQL;
10 string sDataType;
11 sSQL =" select sys.types.name typeName ";
12 sSQL+=" from sys.syscolumns ";
13 sSQL+=" inner join sys.types ";
14 sSQL+=" on sys.types.system_type_id=sys.syscolumns.xtype ";
15 sSQL += " where object_id('"+sTableName+"')=id and sys.syscolumns.name='"+sFieldName+"' ";
16 DataTable objDt = oDBConn.GetDataTable(sSQL);
17 if (objDt.Rows.Count > 0)
18 sDataType = objDt.Rows[0]["typeName"].ToString().Trim();
19 else
20 sDataType = "";
21 return sDataType;
22 }
2 /// 得到某个表中某字段的数据类型 例如:DateTime,Varchar,int,
3 ///
4 /// 表名
5 /// 字段名
6 ///
7 public string GetFieldDataType(string sTableName, string sFieldName)
8 {
9 string sSQL;
10 string sDataType;
11 sSQL =" select sys.types.name typeName ";
12 sSQL+=" from sys.syscolumns ";
13 sSQL+=" inner join sys.types ";
14 sSQL+=" on sys.types.system_type_id=sys.syscolumns.xtype ";
15 sSQL += " where object_id('"+sTableName+"')=id and sys.syscolumns.name='"+sFieldName+"' ";
16 DataTable objDt = oDBConn.GetDataTable(sSQL);
17 if (objDt.Rows.Count > 0)
18 sDataType = objDt.Rows[0]["typeName"].ToString().Trim();
19 else
20 sDataType = "";
21 return sDataType;
22 }