problem with inserting data to access db - C# Discussion Boards

Re: View Control (VS 2005 C#)

Pete O'Hanlon8-Jul-09 23:21

8-Jul-09 23:21

Of course, a decent naming convention helps here as well. As your control is called label13, you have no idea what it is or what context it has, hence your difficulty in finding it. If your control was called something like labEmailAddress it is obvious what the label is for, and would be much easier to find later on.

"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: View Control (VS 2005 C#)

half-life9-Jul-09 2:18

half-life

9-Jul-09 2:18

yep, but it was an example
my naming is with a prefix like lbl - for labels
txb - for TextBoses

so the naming is lbl"ControlName" Smile | :)

Have Fun
Never forget it

Like to add some more feature to my application

Vivek Vijayan8-Jul-09 18:40

Vivek Vijayan

8-Jul-09 18:40

My application enables desktop sharing between a system and a PDA through Wi-Fi.As the screen resolution is different i cannot do mouse movements.wht other features can i include in the project.

This code was posted by me...

Re: Like to add some more feature to my application

Henry Minute8-Jul-09 20:03

Henry Minute

8-Jul-09 20:03

Can you get it to make coffee?

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: Like to add some more feature to my application

Nagy Vilmos8-Jul-09 21:59

Nagy Vilmos

8-Jul-09 21:59

Vivek Vijayan wrote:
desktop sharing between a system and a PDA

If there was a bit more here then maybe, just maybe, you would get a sensible answer.

You cannot 'share' the mouse movement but you should be able to do something about clicks, showing menus and bunnies.

Panic, Chaos, Destruction.
My work here is done.

Re: Like to add some more feature to my application

Luc Pattyn8-Jul-09 22:31

Luc Pattyn

8-Jul-09 22:31

Vivek Vijayan wrote:
As the screen resolution is different i cannot do mouse movements

Why? can't you keep track of the mouse position in the coordinates of the other system, and show it scaled to your own resolution?
as in myMouseX=hisMouseX*myXmax/hisXmax;?

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: Like to add some more feature to my application

Vivek Vijayan9-Jul-09 4:46

Vivek Vijayan

9-Jul-09 4:46

ok i will try

can u suggest more features

This code was posted by me...

problem with inserting data to access db

prasadbuddhika8-Jul-09 18:09

prasadbuddhika

8-Jul-09 18:09

i'm trying to insert data to access db, and i did it, but the problem is after first insert when check the db data is there, then close the application and run it again the last inserted data is missing, what might be the problem.

Re: problem with inserting data to access db

Md. Marufuzzaman8-Jul-09 18:35

Md. Marufuzzaman

8-Jul-09 18:35

Actually the senerio is not clear, Probably you using a datatable with a disconnect recordset, Try to directly insert.

Md. Marufuzzaman

Re: problem with inserting data to access db

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();

Re: problem with inserting data to access db

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.

Re: problem with inserting data to access db

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.

Re: problem with inserting data to access db

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.

Re: problem with inserting data to access db

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.

change directory access control for common application data folder failed.

CooperWu8-Jul-09 17:46

CooperWu

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.

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

CooperWu10-Jul-09 0:03

CooperWu

10-Jul-09 0:03

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

Glad to discuss with you and best wishes.

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

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

CooperWu

22-Jul-09 15:23

does this work on Vista?

Glad to discuss with you and best wishes.

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

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

CooperWu

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

awaldro

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!

Re: C# and Large Images

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.

Re: C# and Large Images

awaldro9-Jul-09 4:08

awaldro

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...

Re: C# and Large Images

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.

Re: C# and Large Images

awaldro9-Jul-09 5:00

awaldro

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!

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