Click here to Skip to main content
15,912,897 members
Home / Discussions / C#
   

C#

 
GeneralRe: Crystal report Pin
hitesh.kalra6-May-09 0:03
hitesh.kalra6-May-09 0:03 
GeneralRe: Crystal report Pin
Sun Rays6-May-09 0:28
Sun Rays6-May-09 0:28 
Questioncmd.exe standardinput problem, please help?!?! Pin
Druuler5-May-09 23:41
Druuler5-May-09 23:41 
AnswerRe: cmd.exe standardinput problem, please help?!?! Pin
12Code6-May-09 0:25
12Code6-May-09 0:25 
GeneralRe: cmd.exe standardinput problem, please help?!?! Pin
Druuler6-May-09 0:31
Druuler6-May-09 0:31 
GeneralRe: cmd.exe standardinput problem, please help?!?! Pin
12Code6-May-09 0:45
12Code6-May-09 0:45 
GeneralRe: cmd.exe standardinput problem, please help?!?! Pin
Druuler6-May-09 1:18
Druuler6-May-09 1:18 
QuestionExtended Ascii charaters are not written in the text file.... Pin
King Julien5-May-09 23:37
King Julien5-May-09 23:37 
AnswerRe: Extended Ascii charaters are not written in the text file.... Pin
OriginalGriff5-May-09 23:50
mveOriginalGriff5-May-09 23:50 
GeneralRe: Extended Ascii charaters are not written in the text file.... Pin
King Julien6-May-09 0:22
King Julien6-May-09 0:22 
GeneralRe: Extended Ascii charaters are not written in the text file.... Pin
OriginalGriff6-May-09 0:41
mveOriginalGriff6-May-09 0:41 
AnswerRe: Extended Ascii charaters are not written in the text file.... Pin
Guffa6-May-09 4:18
Guffa6-May-09 4:18 
GeneralRe: Extended Ascii charaters are not written in the text file.... Pin
King Julien6-May-09 4:37
King Julien6-May-09 4:37 
QuestionMouseDown Event? [modified] Pin
Megidolaon5-May-09 23:25
Megidolaon5-May-09 23:25 
AnswerRe: MouseDown Event? Pin
Alex@UEA5-May-09 23:40
Alex@UEA5-May-09 23:40 
AnswerRe: MouseDown Event? Pin
OriginalGriff6-May-09 0:00
mveOriginalGriff6-May-09 0:00 
GeneralRe: MouseDown Event? Pin
Megidolaon7-May-09 20:51
Megidolaon7-May-09 20:51 
GeneralRe: MouseDown Event? Pin
OriginalGriff7-May-09 21:58
mveOriginalGriff7-May-09 21:58 
AnswerRe: MouseDown Event? Pin
Member 3046636-May-09 6:54
Member 3046636-May-09 6:54 
QuestionExporting excel to pdf Pin
tauras815-May-09 23:15
tauras815-May-09 23:15 
AnswerRe: Exporting excel to pdf Pin
Mycroft Holmes5-May-09 23:26
professionalMycroft Holmes5-May-09 23:26 
GeneralRe: Exporting excel to pdf Pin
tauras816-May-09 0:14
tauras816-May-09 0:14 
QuestionInvalid attempt to call MetaData when reader is closed. Pin
Vimalsoft(Pty) Ltd5-May-09 23:10
professionalVimalsoft(Pty) Ltd5-May-09 23:10 
Good Day All

I have the Following Code in my DAL

public SqlDataReader  Get_Staff_Cycles_internal(String DB)
       {

           SqlDataReader rd = null;

           strcon = GetConnectionString(DB);

           con = new SqlConnection(strcon);

           cmdselect = new SqlCommand();

           cmdselect.CommandType = CommandType.StoredProcedure;

           cmdselect.CommandText = "[dbo].[sp_Get_Staff_Cycles_internal]";

           cmdselect.CommandTimeout = 0;

           cmdselect.Connection = con;

           try
           {
               con.Open();

               rd = cmdselect.ExecuteReader(CommandBehavior.CloseConnection);

           }
           catch (SqlException)
           {
               throw;
           }
           finally
           {
               if (con != null)
               {
                   con.Close();

               }
           }
           return rd;
       }


and Am using this code Like this In BLL

public SqlDataReader Get_Staff_Cycles(int ACTIVITY_ID, String DB)
       {
           DAL.DAL obj = new DAL.DAL();

           SqlDataReader rd = null;

           try
           {
               obj.Get_Staff_Cycles(ACTIVITY_ID, DB);

               rd = obj.Get_Staff_Cycles_internal(DB);

           }
           catch (SqlException)
           {
               throw;
           }
           finally
           {
               obj = null;

           }
           return rd;

       }


And am Calling it like this in PL(Presentation Layer)

private void Bind_Grid_For_Staff()
    {
        SqlDataReader rd = null;

        BLL.BLL obj = new BLL.BLL();

        try
        {
            if (Convert.ToString(Session["Selected_ID_Bind"]).Length > 6)
            {
                //If the Activities are multiselect

          String Activityid = Convert.ToString(Session["Selected_ID_Bind"]);

                    if (Activityid != null || Activityid != "")
                    {

              ArrayList Final_String = (ArrayList)Fixed_String_Multi(Activityid);

                        for (int i = 0; i < Final_String.Count; i++)
                        {
                            rd = obj.Get_Staff_Cycles(Convert.ToInt32(Final_String[i]), Convert.ToString(Session["ActiveDatabase"]));
                        }

                        if (rd != null)
                        {
                            while (rd.Read())
                            {

                                Gridstaff.DataSourceID = null;
                                Gridstaff.DataSource = rd;
                                Gridstaff.DataBind();
                            }
                        }
                    }
                    else
                    {
                        lblGridStaff.Text = "Could not Bind StaffGrid";
                        lblGridStaff.ForeColor = System.Drawing.Color.Red;
                    }
                


            }
            else
            {
                if (Convert.ToString(Session["Selected_ID_Bind"]) != null)
                {

                    String Activityid = Convert.ToString(Session["Selected_ID_Bind"]);

                    if (Activityid != null || Activityid != "")
                    {

                        ArrayList Final_String = (Fixed_String(Activityid));

                        for (int d = 0; d < Final_String.Count; d++)
                        {
                            rd = obj.Get_Staff_Cycles(Convert.ToInt32(Final_String[d]), Convert.ToString(Session["ActiveDatabase"]));
                        }
                   
                        if (rd != null)
                        {
                                
                                Gridstaff.DataSource = rd;
                                
                                Gridstaff.DataBind();
                                
                                rd.Close();
                            
                        }
                    }
                    else
                    {
                        lblGridStaff.Text = "Could not Bind StaffGrid";
                        lblGridStaff.ForeColor = System.Drawing.Color.Red;

                    }
                }
                else
                {
                    Response.Redirect("SubjectStaff.aspx", false);
                }
            }
        }
        catch (ApplicationException e)
        {
            lblStatus.Text = e.Message.ToString();
        }
    }


i get an Error

Invalid attempt to call MetaData when reader is closed.


and its Poiting to the part that Binds the gridview here

Gridstaff.DataBind();


Thank you

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

AnswerRe: Invalid attempt to call MetaData when reader is closed. Pin
Mycroft Holmes5-May-09 23:24
professionalMycroft Holmes5-May-09 23:24 
GeneralRe: Invalid attempt to call MetaData when reader is closed. Pin
Vimalsoft(Pty) Ltd5-May-09 23:37
professionalVimalsoft(Pty) Ltd5-May-09 23:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.