title: one parameter not supplied exception
body: <p>When i login by giving username and password, I get an exception: </p>
  
  <blockquote>
    <p>"The parameterized query '(@username nvarchar(4000),@password12
    nvarchar(4000))SELECT   me' expects the 
        parameter   '@username', which was not supplied."</p>
  </blockquote>
  
  <p>through code:</p>
  
  <pre><code>public DataSet showoption1(seter set)
  {         
     string sql = "SELECT   menue.menuename,roleid, [right].rightname,        
       role.rolename, employee.employeename, employee.password FROM  [right] INNER JOIN 
       permission ON [right].rightid = permission.rightid INNER JOIN  role ON  
       permission.roleid   = role.roleid INNER JOIN emp_men INNER JOIN employee ON 
       emp_men.employeeid = employee.employeeid ON role.roleid = employee.roleid 
       INNER JOIN menue ON emp_men.menueid = menue.menueid 
       where employee.employeenamee=@username 
       AND employee.password=@password12";
  
     SqlCommand cmd = new SqlCommand(sql, con);
     cmd.Parameters.AddWithValue("@username",set.Username);
     cmd.Parameters.AddWithValue("@password12",set.Password);
     SqlDataAdapter adptr = new SqlDataAdapter(cmd);
  
     DataSet ds = new DataSet();
     adptr.Fill(ds);
     int id=  Convert.ToInt32( ds.Tables[2].Rows[0]["rooleid"]);
  
     st.Username=  Convert.ToString(ds.Tables[2].Rows[id]["roolename"]);
  
     adptr.Dispose();
  
     return ds;
  
     }
  </code></pre>