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