void fillAuthorPublisherValues()
{
try
{
SqlConnection conn = new SqlConnection(strConn);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand sqlCmd = new SqlCommand(@"SELECT author_name FROM author_master_table;", conn);
SqlDataAdapter dataAdapter = new SqlDataAdapter(sqlCmd);
DataTable dt = new DataTable();
dataAdapter.Fill(dt);
AuthorNameDropDownList.DataSource = dt;
AuthorNameDropDownList.DataValueField = "author_name";
AuthorNameDropDownList.DataBind();
sqlCmd = new SqlCommand("SELECT publisher_name FROM publisher_master_table;", conn);
dataAdapter = new SqlDataAdapter(sqlCmd);
dt = new DataTable();
dataAdapter.Fill(dt);
PublisherNameDropDownList.DataSource = dt;
PublisherNameDropDownList.DataValueField = "publisher_name";
PublisherNameDropDownList.DataBind();
}
catch (Exception ex)
{
}
}
void fillAuthorPublisherValues()
{
try
{
SqlConnection con = new SqlConnection(strcon);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("SELECT author_name FROM author_master_tb1;", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
AuthorNameDropDownList.DataSource = dt;
AuthorNameDropDownList.DataValueField = "author_name";
AuthorNameDropDownList.DataBind();
cmd = new SqlCommand("SELECT publisher_name FROM publisher_master_tb1;", con);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
PublisherDropDownList.DataSource = dt;
PublisherDropDownList.DataValueField = "publisher_name";
PublisherDropDownList.DataBind();
//con.Close();
}
catch (Exception ex)
{
Response.Write("<script language='javascript'>alert('" + ex.Message + "');</script");
}
}