网站地图
【www.gdgbn.com--php与数据库】
private static void 使用原始sql命令打印字段值()
{
sqlconnection conn = new sqlconnection(@"data source=.sqlexpress;initial catalog=图库;integrated security=true");
try
{
conn.open();
console.writeline("sucess");
}
catch (exception)
{
console.writeline("打开失败");
}
sqlcommand comm = conn.createcommand();
comm.commandtext = "select * from 会员数据";
sqldatareader reader = comm.executereader();
while (reader.read())
{
console.writeline("你要打印的数据:{0}", reader.getsqlint16(reader.getordinal("年龄")));
}
}
想使用上面数据库教程用程序来得到所有的年龄,结果老是出错,说是指定的转换无效,自己研究了下,原来数据库中的int字段在转换时需要使用int32,而不是int16
改成int32程序就正确运行了
console.writeline("你要打印的数据:{0}", reader.getsqlint32(reader.getordinal("年龄")));
<script type=text/网页特效>
if ($ != jquery) {
$ = jquery.noconflict();
}
var islogined = false;
var cb_blogid = 86376;
var cb_entryid = 2015465;
var cb_blogapp = "angestudy";
var cb_bloguserguid = "f5220c74-9fe6-df11-ac81-842b2b196315";
var cb_entrycreateddate = "2011/4/13 23:00:00";
</script>