续上代码,热心人再请进
我是添加了一个用户近代件,,然后在这里做了一个datagrid.实现和数据库绑定.public int newsid
{
set
{
this.id=value;
}
}
private void Page_Load(object sender, System.EventArgs e)
{
if(!this.IsPostBack )
{
SqlConnection con=youth.cratecon ();
con.Open ();
SqlCommand cmd=new SqlCommand ("select newsty from newstype where newsid="+id,con);
string showtitle=Convert.ToString (cmd.ExecuteScalar ());
this.showtype .Text =showtitle;
//cmd.CommandText ="select * from newsword where newsid="+id;
//this.mygrid .DataSource =cmd.ExecuteReader ();
SqlDataAdapter sdr=new SqlDataAdapter ();
sdr.SelectCommand =new SqlCommand ("select * from newsword where newsid="+id,con);
DataSet ds=new DataSet ();
sdr.Fill (ds,"newsword");
this.mygrid .DataSource =ds.Tables ["newsword"];
this.mygrid .DataBind ();
}// 在此处放置用户代码以初始化页面
}
然后在新闻界面直接将这个用户控件拖放过去,
另外,在新闻界面的html里头<uc1:datagrid id="Datagrid1" runat="server" newsid=1调用></uc1:datagrid></TD>
大伙帮我看看吧,谢谢大家啦
数据库里有两张表,主表是newstype int primqry key
newstitle varchar notnull
从表是: newswordid int primary key
newsid int foregign key references newstype(newsid)
newstitle varchar (20)
newscontent varchar(1000)
newstime datatime not null
大体就这样了