ASP.NET

protected void  DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {  
       DataSet Ds=new DataSet();
        con = new SqlConnection("Data Source=.;Initial Catalog=abc;Integrated Security=True");
        cmd = new SqlCommand("select * from salescounts where ='"+DropDownList1.Text+"'", con);
        SqlDataAdapter DA = new SqlDataAdapter(cmd);
                DA.Fill(ds);  
          if(Ds.Tables[0].Rows.Count>0)
           {
                GridView1.DataSource = ds;
                GridView1.DataBind();
                Label1.Text = "Result found:" + GridView1.Rows.Count;

            }
            else
            {
                Label1.Text = "not found";
            }

            con.Close();
        
}

solo_gaurav wrote:

cmd = new SqlCommand("select * from salescounts where ='"+DropDownList1.Text+"'", con);

solo_gaurav wrote:

ow can i display data from datasource in tabular form when i select a bounded field of same data source in dropdownlist.

solo_gaurav wrote:

cmd = new SqlCommand("select * from salescounts where ='"+DropDownList1.Text+"'", con);

Ramesh Reddy11111 wrote:

my system did not contain machine.config is not there in the bellow path

C:\Windows\Microsoft.NET\Framework\v1.1.4322\CONFIG

if(Session["FName"] !=null)
 FName = Session["FName"].ToString();

if(Session["Variable"] == null)
{
        // Invalid Session, you must move to login page
        // You may also add Session.Add("Variable", "value);
}
else
{
       // Do your job.
}