数据网格分配问题 [英] deata grid assigning problem

问题描述

我想将孔数据库的行和列值分配给datagrid怎么可能?

i want to assign hole database row and column value into datagrid how can its possible?

推荐答案

using System;
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.SqlClient;


public partial class _Default : System.Web.UI.Page
{


    protected void Page_Load(object sender, EventArgs e)
    {
        string strSQLconnection = (@"Data Source=GRCPWS00051\MSSQLSERVER1;Initial Catalog=new;Integrated Security=True");

      SqlConnection sqlConnection = new SqlConnection(strSQLconnection);

      SqlCommand sqlCommand = new SqlCommand("select * from persons", sqlConnection);

  sqlConnection.Open();



     SqlDataReader reader = sqlCommand.ExecuteReader();



      GridView1.DataSource = reader;

      GridView1.DataBind();

    }


  }

您需要相应地更改您的数据，以获取表名...
很完美


在aspxpage
中

u need to change ur data sourse accordingly an table name......
it works perfect


in aspxpage

<asp gridview="" id="GridView1"  runat="server">

效果很好

it works fine

这篇关于数据网格分配问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！