Beispiel #1
0
 public void bind()
 {
     sqlString = "select * from TB_Scenic;";
     ds        = db.GetDataSet(sqlString);
     GV_ShowScenic.DataSource   = ds;
     GV_ShowScenic.DataKeyNames = new string[] { "ScenicID" };
     GV_ShowScenic.DataBind();
 }
Beispiel #2
0
    private void GetDataTable()
    {  // string select = "SELECT [CompID], [CompName], [CompMail],[CompPwd] FROM [TB_Company] where CompMail =" + "'" + CompMail + "'" + ";";
        string select = "SELECT [ScenicID], [ScenicName], [ScenicLocal],[ScenicShow] FROM [TB_Scenic] ";

        ds = db.GetDataSet(select);
        // dt = ds.Tables[0];

        GV_ShowScenic.DataSource = ds;
        GV_ShowScenic.DataBind();
    }