using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OracleClient;namespace WebApplication2
{
public partial class _Default : System.Web.UI.Page
{
protected OracleConnection conn = new OracleConnection ();
protected OracleCommand cmd = new OracleCommand();
//object a;
protected void Page_Load(object sender, EventArgs e)
{
try
{
string connstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;//"Data Source=orcl;User ID=lingbo;Password=zhuzhuzhu;Unicode=True";
string sqlcmd = "SELECT * FROM lb";
conn.ConnectionString = connstr;
conn.Open ();
Response.Write("数据库连接成功");
OracleDataAdapter adp = new OracleDataAdapter(sqlcmd, conn);
DataSet myds = new DataSet() ;
adp.Fill(myds, "lb");
//a = myds.Tables["lb"].Rows[1]["lastname"];
//GridView1.Rows[0].Cells[0].Text = myds.Tables["lb"].Rows[0]["id"].ToString;
GridView1.DataSource = myds.Tables["lb"].DefaultView;
GridView1.DataBind();
}
catch (Exception exp)
{
Response.Write("/n/r无法建立数据连接:" + exp.Message);
conn.Close();
}
finally
{
if (conn != null && conn.State != ConnectionState.Closed)
conn.Close();
}
}
}
}
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OracleClient;namespace WebApplication2
{
public partial class _Default : System.Web.UI.Page
{
protected OracleConnection conn = new OracleConnection ();
protected OracleCommand cmd = new OracleCommand();
//object a;
protected void Page_Load(object sender, EventArgs e)
{
try
{
string connstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;//"Data Source=orcl;User ID=lingbo;Password=zhuzhuzhu;Unicode=True";
string sqlcmd = "SELECT * FROM lb";
conn.ConnectionString = connstr;
conn.Open ();
Response.Write("数据库连接成功");
OracleDataAdapter adp = new OracleDataAdapter(sqlcmd, conn);
DataSet myds = new DataSet() ;
adp.Fill(myds, "lb");
//a = myds.Tables["lb"].Rows[1]["lastname"];
//GridView1.Rows[0].Cells[0].Text = myds.Tables["lb"].Rows[0]["id"].ToString;
GridView1.DataSource = myds.Tables["lb"].DefaultView;
GridView1.DataBind();
}
catch (Exception exp)
{
Response.Write("/n/r无法建立数据连接:" + exp.Message);
conn.Close();
}
finally
{
if (conn != null && conn.State != ConnectionState.Closed)
conn.Close();
}
}
}
}
解决方案 »
- 哪位高手知道我下面的页面效果是如何实现的?
- 请问如何在page以外的类里使用System.Web.HttpContext.Current.Session?
- 请教,怎样将小数的位数设置为6位,或小数部分不够6位,则自动补齐。谢谢
- 菜鸟问题:提示框问题??
- 请教:代码隐藏:Page指令的SRC属性
- 导出数据到Excel的问题
- 请教:TREEVIEW控件运行时添加项的问题?
- 怎样在cs文件里面控制在html里面直接输出&&,而不是&&
- 一个巨怪的问题,已经遇到两次了
- 为何总提示“用户代码未处理”的提示呢?谢谢!
- 高手看看,这是转义的问题,还是符号冲突?
- .NET向access数据库插入长日期格式的问题急急...
我见表的时候填入数据的,而且通过cmd可以看到。没问题
GridView1.DataBind();
后台设置数据源一定要DataBind()
GridView1.DataSource = myds.table["lb"];GridView1.DataBind();
gridview 你没给他数据源的时候, 在浏览器中查看,是看不到该控件的。GridView1.DataSource = myds;
GridView1.DataBind();
GridView1.DataBind();
断点没有填充,可以肯定,不是填充的问题,是那个sql语句执行的问题。
adp.Fill(myds);
//a = myds.Tables["lb"].Rows[1]["lastname"];
//GridView1.Rows[0].Cells[0].Text = myds.Tables["lb"].Rows[0]["id"].ToString;
GridView1.DataSource = myds;
GridView1.DataBind();