country state city drop down list in asp.net with calendar 2017:-
Aspx page code:-
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Registration.aspx.cs" Inherits="countrystatewithsearchbar.Registration" %>
<%@RegisterAssembly="AjaxControlToolkit"Namespace="AjaxControlToolkit" TagPrefix="Ajax" %>
<!DOCTYPE html>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<Ajax:ToolkitScriptManager ID="DOB" runat="server"></Ajax:ToolkitScriptManager>
<div>
<table>
<tr>
<td>Name:</td>
<td><asp:TextBox ID="Textname" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>Country:</td>
<td><asp:DropDownList ID="ddlcountry"runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlcountry_SelectedIndexChanged"></asp:DropDownList></td>
</tr>
<tr>
<td>State:</td>
<td><asp:DropDownListID="ddlstate"runat="server"AutoPostBack="true"OnSelectedIndexChanged="ddlstate_SelectedIndexChanged"></asp:DropDownList></td>
</tr>
<tr>
<td>City:</td>
<td><asp:DropDownListID="ddlcity"runat="server" AutoPostBack="true"OnSelectedIndexChanged="ddlcity_SelectedIndexChanged"></asp:DropDownList></td>
</tr>
<tr>
<td>Gender:</td>
<td><asp:RadioButtonList ID="rblgender" runat="server" RepeatColumns="3">
<asp:ListItem Text="Male" Value="1"></asp:ListItem>
<asp:ListItem Text="Female" Value="2"></asp:ListItem>
<asp:ListItem Text="Other" Value="3"></asp:ListItem>
</asp:RadioButtonList></td>
</tr>
//calendar control in asp.net c# with example//
<tr>
<td>DOB:</td>
<td><asp:TextBox ID="Textdob" runat="server"></asp:TextBox></td>
<Ajax:CalendarExtender ID="clender" runat="server" TargetControlID="Textdob" PopupButtonID="Textdob" PopupPosition="BottomRight"></Ajax:CalendarExtender>
</tr>
<tr>
<td>Hobbies:</td>
<td><asp:CheckBoxList ID="cblhobbies" runat="server" RepeatColumns="3">
<asp:ListItem Text="Football" Value="1"></asp:ListItem>
<asp:ListItem Text="Cricket" Value="2"></asp:ListItem>
<asp:ListItem Text="Ballyball" Value="3"></asp:ListItem>
<asp:ListItem Text="Music" Value="4"></asp:ListItem>
<asp:ListItem Text="Dancing" Value="5"></asp:ListItem>
<asp:ListItem Text="Movies" Value="6"></asp:ListItem>
</asp:CheckBoxList></td>
</tr>
<tr>
<td>File_upload:</td>
<td><asp:FileUpload ID="Textfn" runat="server" /></td>
</tr>
<tr>
<td></td>
<td><asp:Button ID="btnsave" runat="server" Text="Save" OnClick="btnsave_Click" /></td>
</tr>
<%--<tr>
<td></td>
<td><asp:TextBox ID="Textsearch" runat="server"></asp:TextBox><asp:Button ID="btnsearch" runat="server" Text="Search" OnClick="btnsearch_Click" /></td>
</tr>--%>
</table>
//how to bind data in datagridview in asp.net//
<table border="1" style="background-color:pink">
<tr>
<td><asp:GridViewID="grd"runat="server"AutoGenerateColums="false" OnRowCommand="grd_RowCommand">
<Columns>
<asp:TemplateField HeaderText="Employee Name">
<ItemTemplate>
<%#Eval("Name") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Country">
<ItemTemplate>
<%#Eval("Cname") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="State">
<ItemTemplate>
<%#Eval("Sname") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="City">
<ItemTemplate>
<%#Eval("Ctname") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Gender">
<ItemTemplate>
<%#Eval("Gender").ToString() == "1" ? "Male" : Eval("Gender").ToString()=="2" ? "Female" : "Other" %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Date Of Birth">
<ItemTemplate>
<%#Eval("DOB") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Employee Hobbies">
<ItemTemplate>
<%#Eval("Hobbies") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="File_Upload">
<ItemTemplate>
<asp:Image ID="img" runat="server" ImageUrl='<%#Eval("File_Upload","~/File_Upload/{0}") %>' Width="70px" Height="60px" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="lbkbtndelete" runat="server" CommandName="Del" Text="Delete" CommandArgument='<%#Eval("Empid") %>'></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="lnkbtnedit" runat="server" Text="Edit" CommandName="Edt" CommandArgument='<%#Eval("Empid") %>'></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView></td>
</tr>
</table>
</div>
</form>
</body>
</html>
.CS page code:-
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.IO;
namespace countrystatewithsearchbar
{
public partial class Registration : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Fill_Country();
ddlstate.Items.Insert(0, new ListItem("--Select--", "0"));
ddlcity.Items.Insert(0, new ListItem("--Select--", "0"));
Fill_grd();
}
}
public void Fill_Country()
{
con.Open();
SqlCommand cmd = new SqlCommand("usp_country_get", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
ddlcountry.DataValueField = "Cid";
ddlcountry.DataTextField = "Cname";
ddlcountry.DataSource = ds;
ddlcountry.DataBind();
ddlcountry.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
public void Fill_State(string cid)
{
con.Open();
SqlCommand cmd = new SqlCommand("usp_state_get", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Cid", cid);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
ddlstate.DataValueField = "Sid";
ddlstate.DataTextField = "Sname";
ddlstate.DataSource = ds;
ddlstate.DataBind();
ddlstate.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
public void Fill_City(string Sid)
{
con.Open();
SqlCommand cmd = new SqlCommand("usp_City_get", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Sid", Sid);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
ddlcity.DataValueField = "Ctid";
ddlcity.DataTextField = "Ctname";
ddlcity.DataSource = ds;
ddlcity.DataBind();
ddlcity.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
public void Fill_grd()
{
SqlCommand cmd = new SqlCommand("usp_employee_get", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
grd.DataSource = ds;
grd.DataBind();
}
else
{
grd.DataSource = null;
grd.DataBind();
}
}
protected void ddlcountry_SelectedIndexChanged(object sender, EventArgs e)
{
Fill_State(ddlcountry.SelectedValue);
}
protected void ddlstate_SelectedIndexChanged(object sender, EventArgs e)
{
Fill_City(ddlstate.SelectedValue);
}
protected void ddlcity_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void btnsave_Click(object sender, EventArgs e)
{
//How to insert checkbox in asp.net//
string HOB = "";
for (int i = 0; i < cblhobbies.Items.Count; i++)
{
if (cblhobbies.Items[i].Selected == true)
{
HOB += (cblhobbies.Items[i].Text + ',');
}
}
HOB = HOB.TrimEnd(',');
//how to add file upload control in asp.net//
string FN = "";
FN = Path.GetFileName(Textfn.PostedFile.FileName);
Textfn.SaveAs(Server.MapPath("File_Upload" + "//" + FN));
if (btnsave.Text == "Save")
{
con.Open();
SqlCommand cmd = new SqlCommand("usp_employee_insert", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", Textname.Text);
cmd.Parameters.AddWithValue("@Country", ddlcountry.SelectedValue);
cmd.Parameters.AddWithValue("@State", ddlstate.SelectedValue);
cmd.Parameters.AddWithValue("@City", ddlcity.SelectedValue);
cmd.Parameters.AddWithValue("@Gender", rblgender.SelectedValue);
cmd.Parameters.AddWithValue("@DOB", Textdob.Text);
cmd.Parameters.AddWithValue("@Hobbies", HOB);
cmd.Parameters.AddWithValue("@File_Upload", FN);
cmd.ExecuteNonQuery();
Fill_grd();
con.Close();
}
else if (btnsave.Text == "Update")
{
con.Open();
SqlCommand cmd = new SqlCommand("usp_employee_update", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Empid", ViewState["abc"]);
cmd.Parameters.AddWithValue("@Name", Textname.Text);
cmd.Parameters.AddWithValue("@Country", ddlcountry.SelectedValue);
cmd.Parameters.AddWithValue("@State", ddlstate.SelectedValue);
cmd.Parameters.AddWithValue("@City", ddlcity.SelectedValue);
cmd.Parameters.AddWithValue("@Gender", rblgender.SelectedValue);
cmd.Parameters.AddWithValue("@DOB", Textdob.Text);
cmd.Parameters.AddWithValue("@Hobbies", HOB);
cmd.Parameters.AddWithValue("@File_Upload", FN);
cmd.ExecuteNonQuery();
Fill_grd();
con.Close();
}
}
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Del")
{
con.Open();
SqlCommand cmd = new SqlCommand("usp_employee_delete", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Empid", e.CommandArgument);
cmd.ExecuteNonQuery();
Fill_grd();
}
else if (e.CommandName == "Edt")
{
con.Open();
SqlCommand cmd = new SqlCommand("usp_Employee_edit", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Empid", e.CommandArgument);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
Textname.Text = ds.Tables[0].Rows[0]["Name"].ToString();
ddlcountry.SelectedValue = ds.Tables[0].Rows[0]["Country"].ToString();
Fill_State(ddlcountry.SelectedValue);
ddlstate.SelectedValue = ds.Tables[0].Rows[0]["State"].ToString();
Fill_City(ddlstate.SelectedValue);
ddlcity.SelectedValue = ds.Tables[0].Rows[0]["City"].ToString();
rblgender.SelectedValue = ds.Tables[0].Rows[0]["Gender"].ToString();
Textdob.Text = ds.Tables[0].Rows[0]["DOB"].ToString();
//how to select multiple items in checkboxlist in asp.net c#//
string[] arg = ds.Tables[0].Rows[0]["Hobbies"].ToString().Split(',');
cblhobbies.ClearSelection();
for (int i = 0; i < cblhobbies.Items.Count; i++)
{
for (int j = 0; j < arg.Length; j++)
{
if (cblhobbies.Items[i].Text == arg[j])
{
cblhobbies.Items[i].Selected = true;
break;
}
}
}
btnsave.Text = "Update";
ViewState["abc"] = e.CommandArgument;
}
con.Close();
}
}
}
}
3 comments:
Good work rock programmer
database code
CREATE PROCEDURE [dbo].[Vender_Proc_Get_MyBooking]
@VendorId BIGINT = 0,
@VendorGroundId INT = 0 ,
@UserLoginId BIGINT = 0 ,
@selectedDate INT = 0
AS
BEGIN
SELECT * , (TotalAmount - PaidAmount) AS BalanceAmount FROM
(
SELECT u.Id AS BookedId , CONVERT(NVARCHAR(12) , BookedOn , 7) AS BookedOn ,
ISNULL(TotalAmount , 0) AS TotalAmount,C.Name, ISNULL((SELECT SUM(PaidAmount) FROM UserTransaction_1 WHERE UserBookedSlotId = U.Id AND Status = 'Success'), 0) AS PaidAmount
FROM UserBookedSlot_1 as U inner join Customers as C on U.CustomerId = C.Id
WHERE VendorGroundId = 1
AND u.BookedOn= '2021-01-27 13:40:06.850'
)A
ORDER BY A.BookedId DESC
END
Post a Comment