private void button1_Click(object sender, System.EventArgs e){string ConnectionString="Data Source=sky;user=diamond;password=diamond;"; //写连接串OracleConnection conn=new OracleConnection(ConnectionString); //创建一个新连接OracleCommand cmd= new OracleCommand("select * from ETAM_USERS",conn);DataSet ds = new DataSet();OracleDataAdapter oda=new OracleDataAdapter();oda.SelectCommand=cmd;oda.Fill(ds);conn.Close();dg.DataSource=ds.Tables[0].DefaultView;}
{dim datestr as date=today;} to_date('" & datestr & "','yyyy-mm-dd')就可将其转变为oracle认同的日期格式了。
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18