<asp:gridview id="GridView1" runat="server" xmlns:asp="#unknown" />
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string connectionString = "server=SYS2;" + "integrated security=SSPI;" +
"database=ERPFinAccounting";
SqlConnection myConnection;
string str_Account_Select = "SELECT * FROM AccountsTable";
SqlCommand myCommand;
DataSet myDataSet;
myConnection = new SqlConnection(connectionString);
myConnection.Open();
myCommand = new SqlCommand(str_Account_Select, myConnection);
SqlDataAdapter mySQLDataAdapter;
myDataSet = new DataSet();
mySQLDataAdapter = new SqlDataAdapter(myCommand);
mySQLDataAdapter.Fill(myDataSet, "AccountsTable");
GridView1.DataSource = myDataSet;
GridView1.DataBind();
}
}