Hello,
I have made code, when you click on the button then the div show, but this is not working. I use jquery for to show the div.
Can someone help me?
How can I show the div showData (with data from the database) when you click on the button?
thanks in advance.
default.aspx
[CODE]
<form id=”form1″ runat=”server”>
<p>
<asp:Button ID=”btn_sort_naam” runat=”server” OnClick=”btn_sort_naam_Click” Text=”Order by name” />
</p>
</form>
<div id=”showData” runat=”server”>
<asp:PlaceHolder ID=”PlaceHolder1″ runat=”server”></asp:PlaceHolder>
</div>
default.aspx.cs
[CODE]
protected void btn_sort_naam_Click(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
//Populating a DataTable from database.
DataTable dt = this.GetData();
//Building an HTML string.
StringBuilder html = new StringBuilder();
//Table start.
html.Append(“<table id=’owntable’ border = ‘1’>”);
//Building the Header row.
html.Append(“<tr>”);
foreach (DataColumn column in dt.Columns)
{
html.Append(“<th>”);
html.Append(column.ColumnName);
html.Append(“</th>”);
}
html.Append(“</tr>”);
//Building the Data rows.
foreach (DataRow row in dt.Rows)
{
html.Append(“<tr>”);
foreach (DataColumn column in dt.Columns)
{
html.Append(“<td>”);
html.Append(row[column.ColumnName]);
html.Append(“</td>”);
}
html.Append(“</tr>”);
}
//Table end.
html.Append(“</table>”);
//Append the HTML string to Placeholder.
PlaceHolder1.Controls.Add(new Literal { Text = html.ToString() });
}
}
private DataTable GetData()
{
using (SqlConnection con = new SqlConnection(“Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Name\Documents\ASP\Folder\App_Data\Databse.mdf;Integrated Security=True”))
{
using (SqlCommand cmd = new SqlCommand(“SELECT * FROM Artikelen ORDER BY Naam”, con))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
return dt;
}
}
}
}
}
jquery
[CODE]
$(document).ready(function () {
$(“#btn_sort_naam”).click(function () {
$(“#showData”).slideToggle(“slow”);
});
});