protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand sqlcmd1 = new SqlCommand("select make from cars ", con);
DropDownMake.DataSource = sqlcmd1.ExecuteReader();
DropDownMake.DataBind();
con.Close();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand sqlcmd2 = new SqlCommand("select model from cars ", con);
DropDownModel.DataSource = sqlcmd2.ExecuteReader();
DropDownModel.DataBind();
con.Close();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand sqlcmd3 = new SqlCommand("select style from cars ", con);
DropDownStyle.DataSource = sqlcmd3.ExecuteReader();
DropDownStyle.DataBind();
con.Close();
con.Close();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand sqlcmd4 = new SqlCommand("select year from cars ", con);
DropDownYear.DataSource = sqlcmd4.ExecuteReader();
DropDownYear.DataBind();
con.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["name"] == null)
{
Session["prevUrl"] = Request.Url;
Response.Redirect("~/loginPage.aspx");
}
else
{
string username = Session["name"].ToString();
this.Label8.Text = string.Format("Hi {0}", Session["name"].ToString() + "!");
string connString = ConfigurationManager.ConnectionStrings["tomms_prodConnectionString"].ConnectionString;
SqlConnection con = null;
try
{
con = new SqlConnection(connString);
/*For State Dropdown Load*/
string com = "Select RowID, ast_lvl_ast_lvl from ast_lvl (nolock)";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DropDownState.DataSource = dt;
DropDownState.DataBind();
DropDownState.DataTextField = "ast_lvl_ast_lvl";
DropDownState.DataValueField = "RowID";
DropDownState.DataBind();
DropDownState.Items.Insert(0, new ListItem("--Select--", "0"));
DropDownDistrict.Items.Insert(0, new ListItem("--Select--", "0"));
DropDownDocType.Items.Insert(0, new ListItem("PPM B03 & CHECKLIST", "1"));
// DropDownDocType.Items.Insert(0, new ListItem("PPM CHECKLIST", "2"));//commented by muruganantham
DropDownDocType.Items.Insert(0, new ListItem("--Select--", "0"));
freq_DropDownList1.Items.Insert(0, new ListItem("--Select--", "0"));
freq_DropDownList1.Items.Insert(1, new ListItem("1", "1"));
freq_DropDownList1.Items.Insert(2, new ListItem("2", "2"));
string com1 = "WITH Years(No , Year) AS ( SELECT 1, 2013 year UNION ALL SELECT No+1,year+1 FROM Years AS d where Year < Year(getdate())) SELECT No , Year FROM Years order by year desc";
SqlDataAdapter adpt1 = new SqlDataAdapter(com1, con);
DataTable dt1 = new DataTable();
adpt1.Fill(dt1);
DropDownYear.DataSource = dt1;
DropDownYear.DataBind();
DropDownYear.DataTextField = "Year";
DropDownYear.DataValueField = "No";
DropDownYear.DataBind();
DropDownYear.Items.Insert(0, new ListItem("--Select--", "0"));
}
catch (Exception ex)
{
//log error
//display friendly error to user
string msg = "Insert Error:";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
con.Close();
}
}
}
}