protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
con = new SqlConnection("Data Source=162.222.225.88;Initial Catalog=rcipune2017;user Id=rcinfotech;password=Rci@1234");
con.Open();
String cmd1 = "select cl_id,cl_name from rc_master";
SqlDataAdapter adpt = new SqlDataAdapter(cmd1, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
Drop_NamePers.DataSource = dt;
Drop_NamePers.DataBind();
Drop_NamePers.DataTextField = "cl_name";
//Drop_NamePers.DataValueField = "ID";
Drop_NamePers.DataBind();
//DropDownList1.DataSource = cmd.ExecuteReader();
//DropDownList1.DataTextField = "cl_name";
//DropDownList1.DataBind();
//con.Close();
txtDate.Text = DateTime.Now.Date.ToShortDateString();
txtTime.Text = DateTime.Now.ToString("hh:mm:ss tt");
Drop_NamePers.Items.Add(new ListItem("Select"));
Drop_NamePers.SelectedIndex = Drop_NamePers.Items.IndexOf(Drop_NamePers.Items.FindByValue("Select"));
}
}
protected void Tab3_Click(object sender, EventArgs e)
{
Tab1.CssClass = "Initial";
Tab2.CssClass = "Initial";
Tab3.CssClass = "Clicked";
MainView.ActiveViewIndex = 2;
txtClientId.Text = "";
txtCl_Name.Text = "";
txtAddress.Text = "";
txtCont_Person.Text = "";
SqlCommand cmdp;
con = new SqlConnection("Data Source=162.222.225.88;Initial Catalog=rcipune2017;user Id=rcinfotech;password=Rci@1234");
cmdp = new SqlCommand("select cl_name from rc_master", con);
con.Open();
Drop_NamePers.DataSource = cmdp.ExecuteReader();
Drop_NamePers.DataTextField = "cl_name";
Drop_NamePers.DataBind();
con.Close();
}
