Hi amitj,
I have created sample code which fulfill your requirement.
HTML
<form id="form1" runat="server">
<asp:ScriptManager runat="server" />
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:TextBox ID="txtshare" runat="server" MaxLength="50" Width="270px" TextMode="MultiLine"
Placeholder="Enter a Message here" />
<span style="align-content: center">
<asp:Button ID="btnShare" runat="server" Class="btn btn-success" Text="Share" OnClick="btnShare_Click" /></span>
<asp:DataList ID="dlMessage" runat="server">
<ItemTemplate>
<table>
<tr>
<td>
<a href="#">
<asp:Image ID="ShareImage" runat="server" ImageUrl="http://www.aspforums.net/Avatars/IndiaRush.jpg"
Height="60px" Width="50px" />
</a>
</td>
<td style="width: 200px">
<asp:Label ID="Label1" Text='<%#Eval("Name") %>' runat="server" />
</h4>
<br />
<asp:Label ID="Label2" Text='<%# Eval("Comment")%>' runat="server" />
<br />
<asp:Label ID="txtDate" Text='<%#Eval("CreateDate")%>' runat="server" />
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>
</ContentTemplate>
</asp:UpdatePanel>
</form>
C#
private string conString = ConfigurationManager.ConnectionStrings["constrtest"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.GetData();
}
}
private void GetData()
{
string conString = ConfigurationManager.ConnectionStrings["constrtest"].ConnectionString;
SqlConnection con = new SqlConnection(conString);
SqlCommand cmd = new SqlCommand("SELECT [Name],[Comment],[CreateDate] FROM [UserComments]", con);
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
dlMessage.DataSource = dt;
dlMessage.DataBind();
}
protected void btnShare_Click(object sender, EventArgs e)
{
string conString = ConfigurationManager.ConnectionStrings["constrtest"].ConnectionString;
SqlConnection con = new SqlConnection(conString);
SqlCommand cmd = new SqlCommand("INSERT INTO UserComments Values(@Name,@Comment,@CreateddDate)", con);
cmd.Parameters.AddWithValue("@Name", "Test");
cmd.Parameters.AddWithValue("@Comment", txtshare.Text.Trim());
cmd.Parameters.AddWithValue("@CreateddDate", DateTime.Now);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
this.GetData();
}