//private SalesLeadsRepository _repo;
//private SalesLeadsRepository repo
//{
// get
// {
// if (_repo == null)
// {
// _repo = new SalesLeadsRepository();
// }
// return _repo;
// }
//}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!IsPostBack)
{
SqlCommand cmd = new SqlCommand();
if (!Page.IsPostBack)
{
LeadNameDropDownList.Items.Add(new ListItem("--Select Lead Name--", ""));
LeadNameDropDownList.AppendDataBoundItems = true;
String strConnString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=DataStore;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
String strQuery = "select * from SalesLeads";
SqlConnection con = new SqlConnection(strConnString);;
cmd.CommandType = CommandType.Text;
cmd.CommandText = strQuery;
cmd.Connection = con;
try
{
con.Open();
LeadNameDropDownList.DataSource = cmd.ExecuteReader();
LeadNameDropDownList.DataTextField = "Company_Name";
LeadNameDropDownList.DataValueField = "ID";
LeadNameDropDownList.DataBind();
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
}
//if (!IsPostBack)
//{
// string sql;
// Session["update"] = Server.UrlEncode(System.DateTime.Now.ToString());
// sql = "Select ID, Location from Location WHERE ID = '3' OR ID = '2' OR ID = '6' OR ID = '5' ORDER BY Location ASC";
// cmd = new SqlCommand(sql, sqlConnection);
// sqlConnection.Open();
// StartingLocationDropDownList.Items.Add(new ListItem("--Please Select--", ""));
// StartingLocationDropDownList.AppendDataBoundItems = true;
// StartingLocationDropDownList.DataSource = cmd.ExecuteReader();
// StartingLocationDropDownList.DataTextField = "Location";
// StartingLocationDropDownList.DataValueField = "ID";
// StartingLocationDropDownList.DataBind();
// sqlConnection.Close();
//}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
TextBox1.Text = "Test";
if (!IsPostBack)
{
SqlCommand cmd = new SqlCommand();
if (!Page.IsPostBack)
{
LeadNameDropDownList.Items.Add(new ListItem("--Select Lead Name--", ""));
LeadNameDropDownList.AppendDataBoundItems = true;
String strConnString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=DataStore;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
String strQuery = "select * from SalesLeads";
SqlConnection con = new SqlConnection(strConnString);;
cmd.CommandType = CommandType.Text;
cmd.CommandText = strQuery;
cmd.Connection = con;
try
{
con.Open();
LeadNameDropDownList.DataSource = cmd.ExecuteReader();
LeadNameDropDownList.DataTextField = "Company_Name";
LeadNameDropDownList.DataValueField = "ID";
LeadNameDropDownList.DataBind();
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
}
}
}