C# Discussion Boards - CodeProject

prasadbuddhika8-Jul-09 18:43

prasadbuddhika

8-Jul-09 18:43

no i'm using oleDbDataAdapter1,dataSet11,oleDbConnection1 and following s the code

DataRow dr = dataSet11.Table1.NewRow();
           dr["ic"] = txt1.Text;
           dr["DES"] = txt2.Text;
           dr["STKBAL"] = txt3.Text;

           oleDbConnection1.Open();

           dataSet11.Table1.Rows.Add(dr);
           oleDbDataAdapter1.Fill(dataSet11);
           oleDbDataAdapter1.Update(dataSet11,"table1");
           oleDbConnection1.Close();

PIEBALDconsult8-Jul-09 20:07

PIEBALDconsult

8-Jul-09 20:07

Ummm... you're adding a DataRow to a DataTable in a DataSet then filling the DataSet with the contents of the database? Doesn't that wipe out the existing data in the DataSet? Confused | :confused:

Other than that; why are you using a DataSet and a DataAdapter? You probably just want to use ExecuteNonQuery to add the data.

MumbleB8-Jul-09 23:09

MumbleB

8-Jul-09 23:09

I would have thought that you might want to Open the Connection first??

Excellence is doing ordinary things extraordinarily well.

dan!sh 8-Jul-09 18:48

dan!sh

8-Jul-09 18:48

Check all the stored procedures/SQL queries that are fired on the DB until you close your application. If the data has been inserted, it can vanish only if some command that does so is run.

Had it been SQL server, Profiler would have helped you out. Don't know if it works with Access or there is something like that for Access DB too.

change directory access control for common application data folder failed.

Dino Mulahusic8-Jul-09 20:50

Dino Mulahusic

8-Jul-09 20:50

if you are running your application from visual studio and your access db file is added to project right click on your access db file, select properties, and set "copy to output directory" to "copy if newer"

hope it helps Smile | :)

Let there arise out of you a band of people inviting to all that is good, enjoining what is right, and forbidding what is wrong: They are the ones to attain felicity.

Āli-'Imrān (The Family of Imran), 104.

CooperWu8-Jul-09 17:46

Re: change directory access control for common application data folder failed.

8-Jul-09 17:46

Here is my code, and i tried same code for file access control, it works well. but doesn't work for common application data on Vista.

<code>

private static void GrantEveryoneFullControlRight(string directory)
        {
            try
            {
                if (!Directory.Exists(directory))
                    Directory.CreateDirectory(directory);

                DirectoryInfo dirInfo = new DirectoryInfo(directory);
                DirectorySecurity ds = dirInfo.GetAccessControl(AccessControlSections.Access);

                FileSystemAccessRule rule = new FileSystemAccessRule(
                    "Users", FileSystemRights.FullControl, AccessControlType.Allow);

                ds.AddAccessRule(rule);
                dirInfo.SetAccessControl(ds);


            }
            catch (Exception ex)
            {
                // Logger.WriteLog(LogType.Error, ex.ToString());
                Console.WriteLine(ex.ToString());
            }
        }
</code>

Glad to discuss with you and best wishes.

CooperWu10-Jul-09 0:03

Re: change directory access control for common application data folder failed.

10-Jul-09 0:03

nobody know how to solve this? Sigh | :sigh:

Glad to discuss with you and best wishes.

brian59821-Jul-09 9:52

brian598

21-Jul-09 9:52

I do something very similar except use "Everyone" in the access rule:

 <br />
<br />
string appDataPath = Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData);<br />
string _localUserDataPath = Path.Combine(appDataPath,"My Company\\MyApp\\");<br />
<br />
if (!Directory.Exists(_localUserDataPath))<br />
     {<br />
          DirectorySecurity ds = new DirectorySecurity();<br />
          ds.AddAccessRule(new FileSystemAccessRule("Everyone", FileSystemRights.FullControl, AccessControlType.Allow));<br />
          Directory.CreateDirectory(_localUserDataPath, ds);<br />
     }<br />
else<br />
    {<br />
       // the directory exists - lets change security on it<br />
       DirectoryInfo di = new DirectoryInfo(_localUserDataPath);<br />
       DirectorySecurity ds = new System.Security.AccessControl.DirectorySecurity();<br />
       ds.AddAccessRule(new FileSystemAccessRule("Everyone", FileSystemRights.FullControl, AccessControlType.Allow));<br />
       di.SetAccessControl(ds);<br />
<br />
    }

Re: change directory access control for common application data folder failed.

CooperWu22-Jul-09 15:23

Re: change directory access control for common application data folder failed.

22-Jul-09 15:23

does this work on Vista?

Glad to discuss with you and best wishes.

brian59823-Jul-09 6:22

brian598

23-Jul-09 6:22

Well, I thought it was working on Vista but I must have been running my client in admin mode because I can't get it to work again. What does work is creating an installer package for my windows service that creates the directory in ProgramData. Using vs.net 2008 I added a custom folder called Common Application Data Folder (any name will work). I set the DefaultLocation property to [CommonAppDataFolder] and the Property property to COMMONAPPDATAFOLDER. Then I added my own folders to this folder (Company\commondir). When the install is run it creates the folders and adds "Users" to the security properties for those folders.

This seems to give "Users" enough permission to read/execute and write files to that location. My non-admin windows client can read/ write and execute from the folder and my windows service can as well.

Re: change directory access control for common application data folder failed.

CooperWu23-Jul-09 15:56

23-Jul-09 15:56

Thanks for your reply, we granted directory access right in installer too.
It works well. Laugh | :laugh:

Glad to discuss with you and best wishes.

C# and Large Images

awaldro8-Jul-09 17:31

8-Jul-09 17:31

I am working in C# and dealing with very large images - too large to load the entire image into memory (which is what GDI+ Bitmap class does). I wondered if anyone at has had a similar experience and if so - how was this type of issue solved?

Any ideas are much appreciated.
Thanks!

Luc Pattyn8-Jul-09 22:38

Luc Pattyn

8-Jul-09 22:38

Hi,

I would try and avoid such situation completely, probably by having a grid of smaller images to start from.

Except maybe for a database I wouldn't want to have objects that are larger than main memory.

What is the size of your image, what is its source, and what is your application?

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.

awaldro9-Jul-09 4:08

9-Jul-09 4:08

Unfortunately I can't really decrease the size of the images at least as they enter the software. Are there any other solutions that might work with super large images?

[further detail on the issue]
I'm working with scanned images. My users believe (incorrectly) that to get a good scan they need to work at 1000 dpi. Scanning an entire page yields a 250 MB image. I keep a the original intact for good measure and only work with a copy of it, which means another 250 MB. Finally, they are making numerous partial copies of the original image to do whatever they do, which means probably another 50 MB x 10 copies = 500 MB. Total memory for this scenario so far is somewhere around 1 GB. If the user applies filters in the software these can sip extra memory and push it over the edge.

Even if the software doesn't crash in a single scenario like that the user will probably proceed to do this a few times, and possibly in a few different tabs at once. Long story short, it takes some work to get the software to crash but sooner or later they swap the software with all the images they are using. No one seems to happy about the whole ordeal...

Alan Balkany9-Jul-09 4:46

Alan Balkany

9-Jul-09 4:46

Would compression help? TIFF images support LZW compression.

Maybe skip keeping the original intact to save 250 MB, and reload from disk when you want to restore it.

Another idea: Instead of partial copies, create a class that provides a virtual partial copy: A link to the whole image, and a Rectangle that defines a portion of the image.

If a page contains only black and white text, you could use one bit per pixel which would give you 32X compression and faster processing.

awaldro9-Jul-09 5:00

9-Jul-09 5:00

Thanks for these great ideas - Just a few thoughts on these ideas.

   + I'm not sure about compression, I shall have to try it

   + I have a cache already. I shall check this to make sure it operates correctly

   + Sometimes my users delete the "original" from the screen. "Virtual"
      copies wouldn't work well, then.

   + The "1bpp" is probably the best idea but all of the filters I have right now
      only work on 32 bpp argb Frown | :(

I shall have to rewrite these so I can directly
modify a 1bpp picture. By the way, can .NET/GDI+ work directly with 1bpp?

Keep the ideas coming!

Huxley Stronghead10-Jul-09 4:00

10-Jul-09 4:00

awaldro wrote:
I'm working with scanned images. My users believe (incorrectly) that to get a good scan they need to work at 1000 dpi. Scanning an entire page yields a 250 MB image.

If I may ask, what is on their pages that would require such a resolution?

The last time I scanned with such a resolution, I could count almost every single atom! If you know what I mean. OMG | :OMG:

awaldro10-Jul-09 4:28

10-Jul-09 4:28

I certainly do - the resolution you can get from a reasonable scanner is quite amazing! The users are scanning latent prints from crime scenes and lift cards. Unfortunately, none of them (or you) would be happy with a invalid positive id - "inclusion" - so they use 1000 dpi. Additionally there is a standards board that regulates the latent software market that 'requires' 1000 dpi. Its really funny - some users think they are going "above and beyond" by scanning at 1200 dpi!

I believe I am going to try writing my own C++ code (piecing together parts of FreeImage and a few other free libraries I have found). Who knows how this experiment shall turn out.

Of course, if there are any other ideas - I am still open!

Huxley Stronghead10-Jul-09 8:42

10-Jul-09 8:42

Why is 1GB memory a problem? Are you talking about RAM memory? Confused | :confused:

I came, saw, and then coded.

awaldro10-Jul-09 9:21

10-Jul-09 9:21

The problem isn't "1 GB". The problem is "1 GB per Tab" - which is a bit different!

Huxley Stronghead10-Jul-09 11:25

10-Jul-09 11:25

Oh, yes, the tabs you have mentioned. How much RAM do they have? 3GB RAM plus Virtual Memory, may still be enough. Have a look at the Virtual Memory, if that fills up then you have a problem.

I came, saw, and then coded.

awaldro13-Jul-09 4:08

13-Jul-09 4:08

The computers have 4 GB of physical memory (32 bit cpu), but I certainly don't get 4GB of memory. Actually it seems like I get roughly 1.1 GB. I presumed this was a .NET thing. Is there a site anywhere that actually says how much memory the .NET runtime can allocate?

Huxley Stronghead13-Jul-09 7:11

13-Jul-09 7:11

I have found something here after a short google: http://bytes.com/groups/net-vb/381325-2gb-memory-limit[^]

Apperantly .Net can only use maximum of 2GB because of two user modes which do split the total memory. ... so I got it.

And yeah, 4GB on a 32Bit Windows actually is only 3GB total. I don't know why Windows swallows one. Confused | :confused:

I came, saw, and then coded.

Huxley Stronghead11-Jul-09 0:22

11-Jul-09 0:22

OK, I have my doubts that you actually have a problem here but this could be a solution if you really want to code something ...

Now this idea I already has been mentioned. But I shall explain it a bit deeper and I would like to call it the Google Map approach. It is about cutting the big monster image into smaller pieces, store those pieces on the HDD as temporary files and only load those that are within the view. Which means you will require some sort of zooming function too. Also you will have to calculate the actual visible pixel in the view and the pixel of your image pieces you use. I think this way you could determine whether an image downsize could help. Of course the downsize only will happen to the loaded pieces in the RAM, neither the original nor the cut version on the HDD. If they apply a filter then you should load all the image pieces from HDD, process them and save back.

There may occur some lag because of the image loading time from HDD but hey, they want to work with monster images! However, this approach is some sort of streaming which means you really only load that what you need to work with and not the entire thing. I never coded it before but I think Google did. Sniff | :^)

I came, saw, and then coded.

awaldro13-Jul-09 4:13