Re: The process cannot access the file '' because it is being used by another process - C# Discussion Boards

Invalid attempt to call MetaData when reader is closed.

Vimalsoft(Pty) Ltd5-May-09 23:10

5-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/

Re: Invalid attempt to call MetaData when reader is closed.

Mycroft Holmes5-May-09 23:24

Mycroft Holmes

5-May-09 23:24

Never, ever, ever try to bind an open datareader to a form, while the data reader is open the connection is locked.

Change from using datareader to datatable (uses a datareader under the hood) and it should all fall into place

Vuyiswa Maseko wrote:
rd = cmdselect.ExecuteReader(CommandBehavior.CloseConnection);

I use this to return a table

				SqlCommand oCmd = new SqlCommand();<br />
				SqlDataAdapter oDA = new SqlDataAdapter();<br />
				DataSet oDS = new DataSet();<br />
<br />
				//load the parameters into the caommd object and set the connection<br />
				oCmd = CreateCommand(sProcedureName, arParam);<br />
<br />
				oDA.SelectCommand = oCmd;<br />
				oDA.Fill(oDS);<br />
<br />
				//close the connection<br />
				//oCmd.Connection.Close;<br />
<br />
				//reset the timeout in case it was changed<br />
				mvTimeOut = _TimeOut;<br />
				return oDS.Tables[0];<br />

Never underestimate the power of human stupidity
RAH

Re: Invalid attempt to call MetaData when reader is closed.

Vimalsoft(Pty) Ltd5-May-09 23:37

Vimalsoft(Pty) Ltd

5-May-09 23:37

Thanks Mycroft

Am trying to avoid using Datatable because of Performance. That is why i wanted to use a datareader.

Thanks

Re: Invalid attempt to call MetaData when reader is closed.

Mycroft Holmes6-May-09 14:16

Mycroft Holmes

6-May-09 14:16

You must have an extroadinary amount of throughput to be able to detect the performance difference between reader and table or is it theoretical peformance difference.

Never underestimate the power of human stupidity
RAH

Re: Invalid attempt to call MetaData when reader is closed.

Vimalsoft(Pty) Ltd7-May-09 3:08

Vimalsoft(Pty) Ltd

7-May-09 3:08

Its Cool, I used a Datatable

Thanks

The process cannot access the file '' because it is being used by another process

Member 39664155-May-09 22:59

Member 3966415

5-May-09 22:59

Hi all,

I am using windows application in C#.
Sometimes i am getting the below exception,

{"The process cannot access the file 'C:\\Documents and Settings\\suq31399\\Local Settings\\Temp\\IHSPublisher\\d954cc77-2722-41c3-9efa-3b20e11003cf.txt'
because it is being used by another process."}
[System.IO.IOException]: {"The process cannot access the file
'C:\\Documents and Settings\\suq31399\\Local Settings\\Temp\\IHSPublisher\\d954cc77-2722-41c3-9efa-3b20e11003cf.txt'
because it is being used by another process."}
Data: {System.Collections.ListDictionaryInternal}
HelpLink: null
InnerException: null
Message: "The process cannot access the file
'C:\\Documents and Settings\\suq31399\\Local Settings\\Temp\\IHSPublisher\\d954cc77-2722-41c3-9efa-3b20e11003cf.txt'
because it is being used by another process."
Source: "IHSPublisher"
StackTrace: "
at IHSPublisher.Publisher.p_GetDocumentByFileIdentifierCompleted(Object sender, GetDocumentByFileIdentifierCompletedEventArgs e) in D:\\Ashok\\Projects\\PCN2.3\\newpublisher_080808\\IHSPublisher\\Publisher.cs:line 319\r\n
at IHSPublisher.PCNAlert.Service.Publishing.Publisher.OnGetDocumentByFileIdentifierOperationCompleted(Object arg) in D:\\Ashok\\Projects\\PCN2.3\\newpublisher_080808\\IHSPublisher\\Web References\\PCNAlert.Service.Publishing\\Reference.cs:line 486"
TargetSite: {Void p_GetDocumentByFileIdentifierCompleted(System.Object, IHSPublisher.PCNAlert.Service.Publishing.GetDocumentByFileIdentifierCompletedEventArgs)}

Can anyone help me to solve this exception.

Thanks,
Ashok

Re: The process cannot access the file '' because it is being used by another process

Mycroft Holmes5-May-09 23:19

Mycroft Holmes

5-May-09 23:19

So presumably another process is writing the file to the location, I am assuming you are trying to read it while some other process is still writing. Build in a delay for x seconds the first time you see the file and try again.

Never underestimate the power of human stupidity
RAH

Re: The process cannot access the file '' because it is being used by another process

ToolMaker20078-May-09 0:58

ToolMaker2007

8-May-09 0:58

Hi,

I get the same error. I'm using a FileInfo object with a file name passed to the constructor upon creating the FileInfo object. I check if the file exist and if so I delete it and recreat it. Al works fine first time but when I click on the button again to do the same functionality over again I get same error mentioned. The is NO close method on the FileInfo object nor Dispose. I tried the Refresh() in desprate attemps but still error. Please see a snipplet below:

private void button2_Click(object sender, EventArgs e)
{
FileInfo fileInfo = new FileInfo(label2.Text + ".TMP");
if (fileInfo.Exists)
{
fileInfo.Delete();
}
fileInfo.Create();
int y = 0;
}

Re: The process cannot access the file '' because it is being used by another process

ToolMaker20078-May-09 1:06

ToolMaker2007

8-May-09 1:06

Hi Guys,

Mine was a dumbass developer faullt...well... din't realy knew once you create the file the creat method returns a stream Laugh | :laugh:

so yea just changed my line of code abit

FileStream stream = fileInfo.Create();
stream.Close()

Hope your problem is as simple as this...

Re: The process cannot access the file '' because it is being used by another process

Member 33520014-Aug-10 21:45

Member 3352001

4-Aug-10 21:45

string FilePath = "C:\\Users\\VijayaShyam\\Documents\\Visual Studio 2008\\Projects\\UdayPowerSystems\\UdayPowerSystems\\PrintPage.txt";
System.Security.AccessControl.FileSecurity FS = new System.Security.AccessControl.FileSecurity("PrintFile.txt",System.Security.AccessControl.AccessControlSections.Access);

// string temp = "D:"; //System.IO.Path.GetTempPath();

FileStream fStream = File.Open(FilePath,FileMode.OpenOrCreate,FileAccess.ReadWrite,FileShare.ReadWrite);
fStream.SetAccessControl(FS);
// System.Security.AccessControl.DirectorySecurity dSec = Directory.GetAccessControl(fStream.Name);

fStream.GetAccessControl();

/// Which OS Your using

with out exponent value need in float

Member 38798815-May-09 22:58

Member 3879881

5-May-09 22:58

Hi guys i am getting my double values like:

3.1489789798E-6

Now i want this values in exact value lie:

0.003 some thing like this with out exponential...,

How its possible i searched in google i didnt get idea,

pla help me out in this,

Thanks & Regards,
Member 3879881,
please don't forget to vote on the post

Re: with out exponent value need in float

OriginalGriff5-May-09 23:19

OriginalGriff

5-May-09 23:19

http://www.lmgtfy.com/?q=c%23+string+format+decimal+point[^]

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

SqlBulkCopy that can do UPDATE

lakhwinder.ghuman5-May-09 22:00

lakhwinder.ghuman

5-May-09 22:00

Can we Update records in the table using SqlBulkCopy

Re: SqlBulkCopy that can do UPDATE

Mycroft Holmes5-May-09 22:27

Mycroft Holmes

5-May-09 22:27

No Unless you bulkcopy into another table and execute a proc to do the update

Never underestimate the power of human stupidity
RAH

Re: SqlBulkCopy that can do UPDATE

Member 33520014-Aug-10 21:47

Member 3352001

4-Aug-10 21:47

yes u can do, bring all data into DataTabel...

Hmm... External Methods?

jas0n235-May-09 21:47

jas0n23

5-May-09 21:47

Hello!

I know how to do extension methods and I'm pretty sure I could teach my cat to do them too, but is there a way to somehow have one external method, and use it in several different projects simply by referencing the file it is contained in? Would this be done in a class file ir DLL file? I'm pretty new to this stuff, and would appreciate any suggestions. Thanks for readin'.

Regards,
Jase

private void Yay()
{
DirectoryInfo Di = new DirectoryInfo("J:\\");
FileInfo[] Files = Di.GetFiles("*.*");

foreach( FileInfo file in Files )
{
// Do something constructive.
}
}

Re: Hmm... External Methods?

Pete O'Hanlon5-May-09 22:18

Pete O'Hanlon

5-May-09 22:18

Either way could work, to be honest. It's up to you whether you want the overhead of an extra DLL, or you're happy having the code included as a link.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Hmm... External Methods?

jas0n236-May-09 0:45

jas0n23

6-May-09 0:45

Thank you Pete. Smile | :)

foreach( inch on Jason )
{
Girlfriend.IsHappier();
}

How i use the connection string for making a connection object..

ddravin20005-May-09 21:33

ddravin2000

5-May-09 21:33

Hi ,

   i made a connection string in app.config file. and i want to use this into my .cs file while creating connection object...

      objSqlConnection1.ConnectionString = ?

please post the solution..

Re: How i use the connection string for making a connection object..

Member 44703545-May-09 21:42

Member 4470354

5-May-09 21:42

if your connection string is like this

add name="conn1" connectionString="string1"

ur access will be like this.

string conn = ConfigurationManager.ConnectionStrings[conn1].ConnectionString;

Re: How i use the connection string for making a connection object..

ddravin20005-May-09 21:54

ddravin2000

5-May-09 21:54

thanks !

but it gives an error "ConfigurationManager" does not exist into current context

Re: How i use the connection string for making a connection object..

Member 44703545-May-09 22:01

Member 4470354

5-May-09 22:01

add a reference in ur class file.

using System.Configuration;

Problem with Datagrid

yueru5-May-09 21:30

yueru

5-May-09 21:30

It's said that "Don't have par(my table)" and alway have error with sql_cmd.ExecuteNonQuery(); coz my file have # it can't read #
<pre>
private SQLiteConnection sql_con;
private SQLiteCommand sql_cmd;
private SQLiteDataAdapter DB;
private DataSet DS = new DataSet();
private DataTable DT = new DataTable();

private void SetConnection()
{
sql_con = new SQLiteConnection("Data Source=pare.db;Version=3;New=False;Compress=True;");
// sql_con = new SQLiteConnection("Data Source=pare.db;Version=3;New=True;Compress=True;"); if I want to create new database
}

private void ExecuteQuery(string txtQuery)
{
<big> sql_con.Open();</big>
sql_cmd = sql_con.CreateCommand();
sql_cmd.CommandText = txtQuery;
<big> sql_cmd.ExecuteNonQuery(); </big>
sql_con.Close();
}
</pre>

<pre>
private void LoadData()
{
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
string CommandText = "select * from par";
DB = new SQLiteDataAdapter(CommandText, sql_con);//นำข้อมูลออกมา
DS.Reset();
DB.Fill(DS);//นาม ข้อมูลปายส่ายนาย ดาต้าเซด
DT = DS.Tables[0];
dataGridView1.DataSource = DT;
sql_con.Close();
}

private void button2_Click(object sender, EventArgs e)
{
SetConnection();
LoadData();
}
</pre>
It has error on the BIG D'Oh! | :doh:

NO MORE TEAR

Re: Problem with Datagrid

Mycroft Holmes5-May-09 21:34

Mycroft Holmes

5-May-09 21:34

indicates you have a problem with your connection string. Probably an invalid path for pare.db Try putting in the fully qualified path as this will be looking in the folder where the exe is created (debug).

Never underestimate the power of human stupidity
RAH

Re: Problem with Datagrid

yueru5-May-09 22:02

yueru

5-May-09 22:02

I've already tried
It's still "no such table: par"
And what the problem with the # in sql_cmd.ExecuteNonQuery();

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