用Datagrid中的超链接传递一个主健,然后根据这个主健把该条信息的内容全部读出来对你所放的Label绑定,我给你提供代码,其传过来的主键是ID,如下 -----------------------System.Data.SqlClient.SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]); String Sql=@" SELECT SERIES, TYPE, STATUS FROM DJJ_JBXX WHERE (ID ='"+this.Request.QueryString["ID"].ToString();+"')"; System.Data.SqlClient.SqlDataAdapter Da=new SqlDataAdapter(Sql,myConnection); System.Data.DataSet ds= new DataSet(); myConnection.Open(); Da.Fill(ds,"DJJ_JBXX");this.Labelseries.Text=ds.Tables["DJJ_JBXX"].Rows[0][0].ToString(); this.Labeltype.Text=ds.Tables["DJJ_JBXX"].Rows[0][1].ToString(); this.Labelstatus.Text=ds.Tables["DJJ_JBXX"].Rows[0][2].ToString(); ----------------------------------------------------------------------------
String Sql=@" SELECT SERIES, TYPE, STATUS FROM DJJ_JBXX WHERE ID ='"+this.Request.QueryString["ID"].ToString()"'"; -------------------------sorry,应该这样---
-----------------------System.Data.SqlClient.SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
String Sql=@" SELECT SERIES, TYPE, STATUS FROM DJJ_JBXX WHERE (ID ='"+this.Request.QueryString["ID"].ToString();+"')";
System.Data.SqlClient.SqlDataAdapter Da=new SqlDataAdapter(Sql,myConnection);
System.Data.DataSet ds= new DataSet();
myConnection.Open();
Da.Fill(ds,"DJJ_JBXX");this.Labelseries.Text=ds.Tables["DJJ_JBXX"].Rows[0][0].ToString();
this.Labeltype.Text=ds.Tables["DJJ_JBXX"].Rows[0][1].ToString();
this.Labelstatus.Text=ds.Tables["DJJ_JBXX"].Rows[0][2].ToString();
----------------------------------------------------------------------------
-------------------------sorry,应该这样---
<asp:TemplateColumn HeaderText="详细信息"> <ItemTemplate> <asp:Label runat="server" Text='<%# "<A href=javascript:fun1(\"" + DataBinder.Eval(Container, "DataItem.你的主键") +"\")>显示详细记录</A>"%>' ID="Label5" NAME="Label5"></asp:Label></ItemTemplate>
</asp:TemplateColumn>然后在页面中写入这个JS函数:
function fun1(NO)
{
window.open('yourURL?id='+NO,'','' );
}写得清楚了吧?
从datagrid中取值我会!晕ing。。
我问的是怎样做一张表单,比如做一张“个人简历表”?
另外,怎样设定表单中的数据源?怎样填充?
拜托啦!!
SqlConnection cnn= new SqlConnection();
SqlCommand cmd =new SqlCommand(Sql,cnn); //sql 就是你的个人简历表中需要的数据的SQL语句
SqlDataReader sdr = cmd.Excute();
while(sdr.Read())
{
Label1.Text = sdr["姓名"]; //然后把你取出来的值放进你需要填充的位置就OK 了。
Label2.Text = sdr["年龄"];
Label3.Text = sdr["性别"];
Label4.Text = sdr["学历"];
}