public void fillddl()
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
try
{
//string str = "select NPaper as Id from [Come2myCityDB].[dbo].[tbl_EventNews]";
string str = "select ID,Name from [Come2myCityDB].[dbo].[tbl_Main_ID] where Sub_ID='1'";
DataSet ds = new DataSet();
//SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter(str, con);
da.Fill(ds);
DDLNPaper.DataSource = ds.Tables[0];
if (ds.Tables[0].Rows.Count > 0)
{
DDLNPaper.DataTextField = "Name";
DDLNPaper.DataValueField = "Id";
}
DDLNPaper.DataBind();
DDLNPaper.Items.Add("Add New");
DDLNPaper.Items.Add("---Select---");
DDLNPaper.SelectedIndex = DDLNPaper.Items.Count - 1;
DDLNPaper.Items[DDLNPaper.Items.Count - 1].Value = "";
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Open();
}
}
public void txtchange(DropDownList ddl, TextBox tb)
{
string str = "insert into [Come2myCityDB].[dbo].[tbl_Main_ID](Sub_ID,Name,UserId)values('1','" + txtNPaper.Text + "','" + Convert.ToString(Session["User"]) + "')";
DataSet ds = new DataSet();
int stat = cc.ExecuteNonQuery(str);
string str1 = "select ID,Name from [Come2myCityDB].[dbo].[tbl_Main_ID] where Sub_ID='1'";
ds = cc.ExecuteDataset(str1);
DDLNPaper.DataSource = ds;
DDLNPaper.DataTextField = "Name";
DDLNPaper.DataValueField = "ID";
DDLNPaper.DataBind();
DDLNPaper.Items.Insert(0, new ListItem("Select", "0"));
DDLNPaper.SelectedIndex = 0;
ddl.Visible = true;
tb.Visible = false;
//ddl.Items.Add(tb.Text);
//ddl.SelectedValue = tb.Text;
//string str = "select * from [Come2myCityDB].[dbo].[tbl_EventNews] where UserId='"+Convert.ToString(Session["User"])+"'";
//DataSet ds = new DataSet();
//ds = cc.ExecuteDataset(str);
//string str2 = Convert.ToString(ds.Tables[0].Rows[0]["NPaper"]);
//string str1 = "insert into [Come2myCityDB].[dbo].[tbl_Main_ID](Name)values('" + str2 + "')";
//ds = cc.ExecuteDataset(str1);
////ddl.Items.Add(tb.Text);
////ddl.SelectedValue = tb.Text;
//ddl.Visible = true;
//tb.Visible = false;
}
