我写了存储过程,想要与Repeater一起用,怎样绑定,我只会用datalist. 怎样用repeater,请大家教教我。谢谢啦。下面是我的datalist与存储过程的绑定,怎样用repeater与存储过程绑定呢? string strConn = ConfigurationSettings.AppSettings["connectionstring"];
SqlConnection conn = new SqlConnection(strConn);
string strSQL = "proc_SearchCompanyKeyWordNew";
SqlCommand comm = new SqlCommand(strSQL, conn);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@keyword", Server.UrlDecode(keyword));
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = comm;
conn.Open();
DataSet ds = new DataSet();
da.Fill(ds, "table");
Datalist2.DataSource = ds;
Datalist2.DataBind();
conn.Close();
SqlConnection conn = new SqlConnection(strConn);
string strSQL = "proc_SearchCompanyKeyWordNew";
SqlCommand comm = new SqlCommand(strSQL, conn);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@keyword", Server.UrlDecode(keyword));
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = comm;
conn.Open();
DataSet ds = new DataSet();
da.Fill(ds, "table");
Datalist2.DataSource = ds;
Datalist2.DataBind();
conn.Close();
...
Reapter2.DataSource = ds;
Reapter2.DataBind();
Reapter2.DataSource = ds.Tables[0];
Reapter2.DataBind();