帮忙

最新推荐文章于 2024-09-20 16:06:21 发布

azuo19850524

最新推荐文章于 2024-09-20 16:06:21 发布

阅读量227

点赞数

文章标签： server insert asp object button xhtml

本文链接：https://blog.csdn.net/azuo19850524/article/details/4075605

版权

<%@ 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();
    }
}