This is my code i want to sort dropdownlist in alphabetically format ,
I am very new beginner of c# & asp.net,
Kindly explain in detail
What I have tried:
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class Index : System.Web.UI.Page
{
JRDSQL jsql = new JRDSQL();
JRDPopup jpop = new JRDPopup();
SqlConnection con = new SqlConnection(@"Data Source=xxx.xxx.xxx.xxx,1434; Initial Catalog=apbills_Anay;UId=apbills_Anay;Pwd=Lootbazzar@12345;");
protected void Page_Load(object sender, EventArgs e)
{
bool blogin = false;
if (Session["SID"] != null)
{
if (Convert.ToInt32(Session["SID"].ToString()) > 0)
{
blogin = true;
}
}
if (blogin == true)
{
if (!IsPostBack)
{
}
}
else
{
Response.Redirect("Login.aspx", false);
}
if (con.State == ConnectionState.Closed)
{
con.Open();
}
if (!Page.IsPostBack)
{
BindCountry();
fillDDSMN();
}
}
protected void ddlcountry_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int locationId = Convert.ToInt32(ddlcountry.SelectedValue);
SqlDataAdapter adp = new SqlDataAdapter("select * from tbdealerlist where locationid= " + locationId, con);
DataSet ds = new DataSet();
adp.Fill(ds);
ddlstate.DataSource = ds;
ddlstate.DataTextField = "Dealer_Name";
ddlstate.DataValueField = "Dealer_Id";
ddlstate.DataBind();
ddlstate.Items.Insert(0, new ListItem("--Select--", "0"));
}
catch (Exception ex)
{
Response.Write("Error occured: " + ex.Message.ToString());
}
finally
{
con.Close();
}
}
protected void BindCountry()
{
try
{
SqlDataAdapter adp = new SqlDataAdapter("select * from Location", con);
DataSet ds = new DataSet();
adp.Fill(ds);
ddlcountry.DataSource = ds;
ddlcountry.DataTextField = "Location";
ddlcountry.DataValueField = "LocationId";
ddlcountry.DataBind();
ddlcountry.Items.Insert(0, new ListItem("--Select--", "0"));
ddlstate.Items.Insert(0, new ListItem("--Select--", "0"));
}
catch (Exception ex)
{
Response.Write("Error occured : " + ex.Message.ToString());
}
finally
{
con.Close();
}
}
private void fillDDSMN()
{
SqlParameter[] paramdg = {new SqlParameter("@Mode","product")
};
jpop.PopupCombo(DDSMN, "sp_Registration", paramdg);
}
protected void submit_Click(object sender, EventArgs e)
{
try
{
SqlParameter[] paramsave = { new SqlParameter("@Mode","sale"),
new SqlParameter("@sale_Invoice",txtslinvoice.Text.Trim()),
new SqlParameter("@Dealer_Name",ddlstate.SelectedValue),
new SqlParameter("@SProduct_name",DDSMN.SelectedValue),
new SqlParameter("@Model_name",DDSMN.SelectedValue),
new SqlParameter("@SProduct_Qty",txtslmdlqty.Text.Trim()),
new SqlParameter("@sale_rate",txtslrate.Text.Trim()),
new SqlParameter("@Scash",nmbcsh.Text.Trim()),
new SqlParameter("daily_scash",nmbcsh.Text.Trim()),
};
int id = 0;
id = jsql.execStoredProcudure("sp_sale", paramsave);
if (id > 0)
{
JRDMessage.UserMessage(this, "Data submitted successfully !!!");
}
}
catch (Exception ex)
{
JRDMessage.UserMessage(this, ex.Message);
}
}
}