Hi muhammad12,
Refer below example.
Database
CREATE TABLE [AddressBook]
(
[UserId] INT NOT NULL,
[SenderName] VARCHAR(100),
[Sender_Contact] BIGINT,
[Designation] VARCHAR(100),
[Receiver_name] VARCHAR(100),
[Receiver_Contact] BIGINT,
[Address] VARCHAR(100),
[Date] Date
)
HTML
Login
<asp:TextBox ID="txtId" runat="server" />
<asp:Button ID="btnLogin" runat="server" Text="Login" OnClick="Login" />
Address
<asp:RadioButtonList runat="server" ID="rblAddress">
</asp:RadioButtonList>
<hr />
<asp:Button ID="btnAdd" runat="server" Text="Add New" OnClick="Add" />
<hr />
<asp:Panel runat="server" ID="pnlAddAddress" Visible="false">
<table>
<tr>
<td>Sender Name</td>
<td><asp:TextBox runat="server" ID="txtSenderName" />
</td>
</tr>
<tr>
<td>Sender Contact</td>
<td><asp:TextBox runat="server" ID="txtSenderContact" />
</td>
</tr>
<tr>
<td>Designation</td>
<td><asp:TextBox runat="server" ID="txtDesignation" />
</td>
</tr>
<tr>
<td>Receiver Name</td>
<td><asp:TextBox runat="server" ID="txtReceiverName" />
</td>
</tr>
<tr>
<td>Receiver Contact</td>
<td><asp:TextBox runat="server" ID="txtReceiverContact" />
</td>
</tr>
<tr>
<td>Address</td>
<td><asp:TextBox runat="server" ID="txtAddress" />
</td>
</tr>
<tr>
<td>Date</td>
<td><asp:TextBox runat="server" ID="txtDate" />
</td>
</tr>
</table>
<asp:Button ID="btnSave" runat="server" Text="Save" OnClick="Save" />
</asp:Panel>
Namespaces
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
Code
Login
protected void Login(object sender, EventArgs e)
{
Session["Id"] = txtId.Text;
Response.Redirect("Address.aspx");
}
Address
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
BindAddresses();
}
}
protected void Add(object sender, EventArgs e)
{
pnlAddAddress.Visible = true;
}
protected void Save(object sender, EventArgs e)
{
string senderName = txtSenderName.Text;
string senderContact = txtSenderContact.Text;
string designation = txtDesignation.Text;
string receiverName = txtReceiverName.Text;
string receiverContact = txtReceiverContact.Text;
string address = txtAddress.Text;
string date = txtDate.Text;
string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
string query = "INSERT INTO [AddressBook] VALUES (@Id, @Name, @Contact, @Designation, @ReceiverName, @ReceiverContact, @Address, @Date)";
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlCommand cmd = new SqlCommand(query, con))
{
cmd.Parameters.AddWithValue("@Id", Session["Id"]);
cmd.Parameters.AddWithValue("@Name", senderName);
cmd.Parameters.AddWithValue("@Contact", senderContact);
cmd.Parameters.AddWithValue("@Designation", designation);
cmd.Parameters.AddWithValue("@ReceiverName", receiverName);
cmd.Parameters.AddWithValue("@ReceiverContact", receiverContact);
cmd.Parameters.AddWithValue("@Address", address);
cmd.Parameters.AddWithValue("@Date", date);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
pnlAddAddress.Visible = false;
BindAddresses();
}
private void BindAddresses()
{
string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlCommand cmd = new SqlCommand("SELECT [SenderName] + '<br/>' + CAST([Sender_Contact] AS VARCHAR(10)) + '<br/>' + [Designation] + '<br/>' + [Receiver_name] + '<br/>' + CAST([Receiver_Contact] AS VARCHAR(10)) + '<br/>' + [Address] 'Address' FROM AddressBook WHERE UserId = @Id", con))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Id", Session["Id"]);
con.Open();
this.rblAddress.DataSource = cmd.ExecuteReader();
this.rblAddress.DataTextField = "Address";
this.rblAddress.DataTextField = "Address";
this.rblAddress.DataBind();
con.Close();
}
}
}
Screenshot