怎样在数据库中读取一项数据？

benniao2 2004-07-30 12:17:46

我想把下面查询出来的数据付给一个变量
select [biao].id from [biao] where [biao].name='abc'
怎样才能实现呢？用访问数据库的控件是不是太麻烦

...全文

74 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

aliketen 2004-07-30

打赏
举报

DataGrid绑定结果

benniao2 2004-07-30

打赏
举报

谢谢

lxcc 2004-07-30

打赏
举报

<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">

void Page_Load(object sender, EventArgs e) {
if(!IsPostBack)
{
BindGrid();
}
}

void Button1_Click(object sender, EventArgs e) {
BindGrid();
}

void BindGrid()
{
// TODO: Update the ConnectionString and CommandText values for your application
string ConnectionString = "server=(local);database=pubs;trusted_connection=true";
string CommandText = "select au_lname as [Last Name], au_fname as [First Name], Address, City, State from Authors";

SqlConnection myConnection = new SqlConnection(ConnectionString);
SqlCommand myCommand = new SqlCommand(CommandText, myConnection);

myConnection.Open();

DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
DataGrid1.DataBind();
}

</script>
<html>
<head>
</head>
<body style="FONT-FAMILY: arial">
<h2>Simple Data Report
</h2>
<hr size="1" />
<form runat="server">
<asp:datagrid id="DataGrid1" runat="server" CellSpacing="1" GridLines="None" CellPadding="3" BackColor="White" ForeColor="Black" EnableViewState="False">
<HeaderStyle font-bold="True" forecolor="white" backcolor="#4A3C8C"></HeaderStyle>
<ItemStyle backcolor="#DEDFDE"></ItemStyle>
</asp:datagrid>
<asp:Button id="Button1" onclick="Button1_Click" runat="server" Text="Button"></asp:Button>
</form>
</body>
</html>

zpisgod 2004-07-30

打赏
举报

不用控件，但是需要调用ado.net组件
以sqlserver数据库为例：
SqlConnection sconn=new SqlConnection("数据库链接字符串");//建立连接
SqlCommand scomm=new SqlCommand();
scomm.Connection=sconn;
scomm.CommandText="select [biao].id from [biao] where [biao].name='abc'";
//声明command对象并初始化
sconn.Open();//打开连接
SqlDataReader sdr=scomm.ExecuteReader();//声明datareader对象，并执行command对其填充
if(sdr.Read())
string id=sdr["id"].ToString(); //如果有数据则赋值给变量id
sdr.Close(); //关闭reader
sconn.Close();//关闭connection