<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div style="text-align: left">
<asp:DetailsView ID="azuo" runat="server" Height="50px" Style="z-index: 100;
left: 341px; position: absolute; top: 93px" Width="125px" DefaultMode="Insert">
</asp:DetailsView>
<asp:DropDownList ID="Table" runat="server" Style="z-index: 101; left: 633px; position: absolute;
top: 51px">
<asp:ListItem>Fix_chengdu</asp:ListItem>
</asp:DropDownList>
<asp:Button ID="insert" runat="server" Height="20px" OnClick="insert_Click" Style="z-index: 102;
left: 323px; position: absolute; top: 198px" Text="插入" Width="50px" />
<asp:Button ID="Cancel" runat="server" Height="20px" OnClick="Cancel_Click" Style="z-index: 103;
left: 497px; position: absolute; top: 199px" Text="取消" Width="50px" />
<asp:Label ID="Messsge" runat="server" Style="z-index: 104; left: 423px; position: absolute;
top: 259px"></asp:Label>
</div>
</form>
</body>
</html>
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//创建数据库连接对象,连接Inphase数据库
SqlConnection thisConnection = new SqlConnection(@"Server=(local)/sqlexpress;Integrated Security=true;Database=Inphase");
thisConnection.Open();
//设置Sqlcommand命令
SqlCommand thisCommand = new SqlCommand();
thisCommand.CommandText = "select * from " + Table.SelectedValue.ToString();
thisCommand.Connection = thisConnection;
//设置SqlDataReader命令
SqlDataReader thisReader = thisCommand.ExecuteReader();
//绑定数据
azuo.DataSource = thisReader;
azuo.DataBind();
thisConnection.Close();
}
protected void insert_Click(object sender, EventArgs e)
{
//if (azuo.CurrentMode == DetailsViewMode.Insert)
//{
// Messsge.Text = azuo.Rows[0].Cells[1].Text.ToString();
//}
Messsge.Text = azuo.Rows[0].Cells[1].Text.ToString();
}
protected void Cancel_Click(object sender, EventArgs e)
{
Messsge.Text = azuo.Rows[0].Cells.Count.ToString();
}
}
怎么每次在Message里面都是空的?