using System; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Collections; 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 G_list : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) { string conn = System.Configuration.ConfigurationManager .AppSettings["strConn"].ToString(); SqlConnection con = new SqlConnection(conn); con.Open(); string sa = " select * from 公告表 where 类型 = '通知'"; SqlDataAdapter myCommand = new SqlDataAdapter( sa , con); DataSet myDataSet = new DataSet(); //填充DataSet myCommand.Fill(myDataSet); //关闭链接 GridView1.DataSource = myDataSet; //绑定 GridView1.DataBind(); con.Close(); string conn1 = System.Configuration.ConfigurationManager.AppSettings["strConn"].ToString(); SqlConnection con1 = new SqlConnection(conn1); con.Open(); string sa1 = " select * from 公告表 where 类型 = '消息'"; SqlDataAdapter myCommand1 = new SqlDataAdapter(sa1, con1); DataSet myDataSet1 = new DataSet(); //填充DataSet myCommand1.Fill(myDataSet1); //关闭链接 GridView2.DataSource = myDataSet1; //绑定 GridView2.DataBind(); con1.Close();
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
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 G_list : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string conn = System.Configuration.ConfigurationManager .AppSettings["strConn"].ToString(); SqlConnection con = new SqlConnection(conn);
con.Open();
string sa = " select * from 公告表 where 类型 = '通知'";
SqlDataAdapter myCommand = new SqlDataAdapter( sa , con);
DataSet myDataSet = new DataSet();
//填充DataSet
myCommand.Fill(myDataSet);
//关闭链接
GridView1.DataSource = myDataSet;
//绑定
GridView1.DataBind();
con.Close(); string conn1 = System.Configuration.ConfigurationManager.AppSettings["strConn"].ToString(); SqlConnection con1 = new SqlConnection(conn1);
con.Open();
string sa1 = " select * from 公告表 where 类型 = '消息'";
SqlDataAdapter myCommand1 = new SqlDataAdapter(sa1, con1);
DataSet myDataSet1 = new DataSet();
//填充DataSet
myCommand1.Fill(myDataSet1);
//关闭链接
GridView2.DataSource = myDataSet1;
//绑定
GridView2.DataBind();
con1.Close();
}
1路:A站(1)-D站(2)-C站(3)-M站(4)
每条线路的站点个数不确定!