C#：“标题/用户名”等内容从数据库中获取数据

具体效果见最下面图片

前台：

<asp:Label ID="Label1" runat="server"></asp:Label><asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
<asp:Label ID="Label2" runat="server"></asp:Label><asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><br />
<asp:Button ID="Button1" runat="server" />

后台：

string Con = ConfigurationManager.ConnectionStrings["Shujuku"].ConnectionString;
SqlConnection conn = new SqlConnection(Con);
SqlDataAdapter sda = new SqlDataAdapter("select * from TitleTable", conn);
DataSet ds = new DataSet();
sda.Fill(ds);
Label1.Text = ds.Tables[0].Rows[0]["TitleName"].ToString();
Label2.Text = ds.Tables[0].Rows[1]["TitleName"].ToString();
Button1.Text=ds.Tables[0].Rows[2]["TitleName"].ToString();