Change FileAccess/FileShare permissions on a FileStream - C# Discussion Boards

misCafe22-May-09 16:43

22-May-09 16:43

Well, I have commented on //for (int i = 0; i < sReader.FieldCount; i++ ) so, it isn't used.
Exactly, if we do a right code, it will display a correct recode (only four records on listview). In db it has only four records. After I have coded (code i have posted), it displays many records (duplicate records) on the listview. One record in db it shows many records on listview.

Do you make sense? Smile | :)

Chuon Visoth
Angkor Wat - Cambodia
asp.net - c sharp beginner

Re: _ID field goes wrong

fly90422-May-09 17:10

fly904

22-May-09 17:10

misCafe wrote:
Do you make sense?

Yes he does, you on the other hand don't.

It seems that you are confussing 'records' and 'fields', records are the rows in the database and fields are the columns. The code that you have provided shows that you are adding the same row for every field (column) you have. sReader is the record (row), sReader[i] is the field (column). Hence why you go through the DataReader record by record (sReader.ReadLine()), and for each record you then go through it field by field, as shown in my other post.

I hope that clears things up.

My failometer is detecting vast quantities of FAIL!

"Its SQL - hardly programming..." (Caslen)

Re: _ID field goes wrong

Luc Pattyn22-May-09 17:18

Luc Pattyn

22-May-09 17:18

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: _ID field goes wrong

Luc Pattyn22-May-09 17:19

Luc Pattyn

22-May-09 17:19

you have two for loops, only one of them is commented out.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: _ID field goes wrong

fly90422-May-09 16:34

fly904

22-May-09 16:34

misCafe wrote:
while (sReader.Read() == true)
{
_ID.Add(sReader[0].ToString());

for (int i = 0; i < _ID.Count; i++)
//for (int i = 0; i < sReader.FieldCount; i++ )
{
lstItems = new ListViewItem((i + 1).ToString());
lstItems.SubItems.Add(sReader[1].ToString());
lstItems.SubItems.Add(sReader[2].ToString());
lstItems.SubItems.Add(sReader[3].ToString());
lstItems.SubItems.Add(sReader[4].ToString());
lstItems.SubItems.Add(sReader[5].ToString());
this.lsv_user.Items.Add(lstItems);
}
}

With that, you are adding the same record to the ListView n(sReader.FieldCount) times. Your problem is the line in bold, you are adding the same ID/name ((i + 1).ToString()) for each record. Each ListViewItem should have a different name or be blank (no parameter).

I think I know what you are trying to do, so I hope this helps:

if (sReader.FieldCount > 0)
{
    _ID.Add(sReader[0].ToString());
    lstItems = new ListViewItem(sReader[0].ToString()); //Notice: If this is your ID column then it should be unique each record.
    for (int i = 1; i < sReader.FieldCount; i++)
    {
        lstItems.SubItems.Add(sReader[i].ToString());
    }
    this.lsv_user.Items.Add(lstItems);
}

You just need to replace the content of your while loop.

My failometer is detecting vast quantities of FAIL!

"Its SQL - hardly programming..." (Caslen)

Re: _ID field goes wrong

misCafe22-May-09 17:27

misCafe

22-May-09 17:27

Thank you very much again.

I understand what you said and it is solved now.

Smile | :)

Chuon Visoth
Angkor Wat - Cambodia
asp.net - c sharp beginner

windows installer user interface checkbox to disable next button

Member 202095122-May-09 11:07

Member 2020951

22-May-09 11:07

hi guys,
in the setup project i added checkboxes dialog to user interface section. i have two checkboxes to install two products accordingly.
if the user unchecks the both of the checkboxes, i want the next button to be disabled.
do you know how to do that?
thanks

Change FileAccess/FileShare permissions on a FileStream

Dan Neely22-May-09 10:18

Dan Neely

22-May-09 10:18

Is there anyway to do this without closing/reopening the file?

I found this in some code I wrote a few years, and after cringing and hitting google, failed to do so.

m_fsXMLLib = new FileStream(m_fileName, FileMode.Create, FileAccess.ReadWrite, FileShare.None);
// stuff that writes to the file



//there doesn't appear to be any way to change FileAccess values while the stream is open,
//and the risk of a steal occuring here is much lower than a read attempt in midwrite.
m_fsXMLLib.Close();
m_fsXMLLib = new FileStream(m_fileName, FileMode.Open, FileAccess.ReadWrite, FileShare.Read);

My intent is to keep anyone from trying to read the file while it's being written and in an inconsistent state. After saving the file, I want it kept open to prevent anyone else from being able to modify it while letting them have read only rights.

It is a truth universally acknowledged that a zombie in possession of brains must be in want of more brains.
-- Pride and Prejudice and Zombies

Re: Change FileAccess/FileShare permissions on a FileStream

Luc Pattyn22-May-09 11:21

Luc Pattyn

22-May-09 11:21

Hi Dan,

interesting question.

IMO a pure .NET solution does not exist. This is what I would try:
- create the FileStream with Share.None
- write and flush the data
- now P/Invoke to CreateFile, specify Share.Read and a zero FileMode (which .NET compiles but refuses to run) as explicitly allowed here[^]
- finally close the original FileStream.

That may run all right and yield a file readable for others.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: Change FileAccess/FileShare permissions on a FileStream

Dan Neely22-May-09 15:52

Dan Neely

22-May-09 15:52

Thanks, I'll give it a shot when I get back into the office on tuesday.

It is a truth universally acknowledged that a zombie in possession of brains must be in want of more brains.
-- Pride and Prejudice and Zombies

How to get the roles for a user other than the current one

MGoetz22-May-09 8:22

MGoetz

22-May-09 8:22

I am writing a web application that I want to use windows authentication for. The only problem is that the users using it may not always be running it from there own machine. I want to check the roles for the current windows user and if they have the required role take them directly into the application. If the current user does not have the required role I will take them to a sign-on page so they can enter their windows user i.d. and password. Then I will check if that user has the required role. The problem is that I can only find a way to check the roles for the current windows user.

Is there a way to validate the user that signs in to the application rather than the windows user and check the roles or groups they are in?

Thank you
Marty

Re: How to get the roles for a user other than the current one

0x3c022-May-09 8:48

0x3c0

22-May-09 8:48

Use the techniques from this article to impersonate the user given their username and password. Create a new System.Security.Principle.WindowsIdentity object from the token you'll get back from LogonUser. Use my code from this post, where currentPrinciple is the WindowsIdentity you created

Re: How to get the roles for a user other than the current one

MGoetz22-May-09 9:13

MGoetz

22-May-09 9:13

Thank you, I will try this as soon as possible.

Marty

Re: How to get the roles for a user other than the current one

MGoetz26-May-09 4:44

MGoetz

26-May-09 4:44

Thank you this helped greatly.

Marty

external database?

benjamin yap22-May-09 6:55

benjamin yap

22-May-09 6:55

Hi, i want to create an application that can be loaded into anyone computer.. But the database has to be consistent, so i was thinking of using my web server mysql database.

but how do i use the database from the application i created?

Re: external database?

EliottA22-May-09 7:06

EliottA

22-May-09 7:06

Use a webservice to communicate with the database and have some sort of authentication system for your client.

Check out the CodeProject forum Guidelines[^]

Re: external database?

benjamin yap22-May-09 7:09

benjamin yap

22-May-09 7:09

can give me some idea of what web service?

Re: external database?

EliottA22-May-09 7:14

EliottA

22-May-09 7:14

~~Did google break for you too?~~

I feel nice From codeproject.[^]
Another link[^]

Check out the CodeProject forum Guidelines[^]

Re: external database?

benjamin yap22-May-09 7:21

benjamin yap

22-May-09 7:21

dont quite understand..

anyway can use mysql connection string? den replace localhost with my server ip?

Re: external database?

EliottA22-May-09 7:27

EliottA

22-May-09 7:27

check out this site[^] as it's the leader with connectionstrings, but yes that's pretty much it.

Check out the CodeProject forum Guidelines[^]

Re: external database?

ameeen22-May-09 8:52

ameeen

22-May-09 8:52

how do work program database in c# with sql server

Re: external database?

EliottA22-May-09 9:36

EliottA

22-May-09 9:36

Go buy a book on basics, a forum post can't nearly cover this topic.

Check out the CodeProject forum Guidelines[^]

Re: external database?

Ennis Ray Lynch, Jr.22-May-09 7:59

Ennis Ray Lynch, Jr.

22-May-09 7:59

Enable external connections and use a connection string from your application.

http://www.connectionstrings.com/mysql[^]

Need custom software developed? I do C# development and consulting all over the United States.

A man said to the universe:
"Sir I exist!"
"However," replied the universe,
"The fact has not created in me
A sense of obligation."
--Stephen Crane

ByteA Column in PostGreSQL

xcorporation22-May-09 6:49

xcorporation

22-May-09 6:49

Hi There,

Any code snippet in C# on how i can insert a string value in a ByteA column in PostGreSQL ?

Reagrds,
X

Yeee

how to create function in c# ?

xingselex22-May-09 5:55

xingselex

22-May-09 5:55

in VB . a class can have constructor and funstion or sub. so how to create a function return a value in C# class ?

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