|
Etienne_123 wrote: Is there a way
Yes, it's called SQL Server after all.
However, I don't think storing passwords is a good idea.
|
|
|
|
|
Thanks. Just wanted to know before I started searching all over. I`m encrypting the passwords before storing them in the database though. Plus, its a prototype application run at an old age home, so security isn't my main priority, user-friendliness is.
|
|
|
|
|
If you are in the United States and "old folks home" qualifies as Health Care which means the data you are accessing, storing, and retrieving falls under HIPPA which is security intensive.
|
|
|
|
|
Ahem; HIPAA. But it only applies to health-related data; I don't think it applies to email passwords.
|
|
|
|
|
Ahem: he is writing software for an "old people's home", copying and pasting SQL Server database's and relying on storing email passwords in a database. Does any part of this not set off data security alarms? My post was a polite reminder that there are legal repercussions for such a cavalier attitude towards data security.
|
|
|
|
|
Ennis Ray Lynch, Jr. wrote: set off data security alarms
Absolutely, as I mentioned in my first post, but I don't think HIPAA is involved. I had a class on HIPAA last month. It's more a common sense issue -- don't write down passwords... anywhere. Especially where others can get them.
And don't trust a third party to keep them safe.
|
|
|
|
|
I am now working with an ERP application, but the database is getting bigger and bigger, my application have database with 300MB size after 6 months only!!! and the application is getting slower because huge amount of data, especially when user ask for a report or do some inquiries in screens, I am thinking about partial loading solution to load the data partially when user scroll the data, but I have problems with sorting and hanging when user scroll data, what is the best solution for my application,
The environment is
VB.NET 2008
3 tiers architecture
SQL SERVER 2008
Possibly using VPN connection (makes application give time out)
Any help is highly appreciated
|
|
|
|
|
300mb is not very big. Is the database well designed/properly normalized? Are all of the required indexes and relations in place? Have all of the stored procedures been optimized? There is more but start there and see how you go. There are plenty of Sql helper websites out there: here's one: SQLServerCentral.com[^]
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
You have asked this question in multiple forums, please don't. BTW - there is no C# component to your application there, so I don't know why you'd even think of choosing this forum.
"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
|
|
|
|
|
Rethink your design.
Mdallal84 wrote: when user scroll the data
Users shouldn't be scrolling data at all.
Mdallal84 wrote: partial loading
Like paging?
Why do I get the feeling you have one big DataGrid/View ? 
|
|
|
|
|
You were right  , A big datagridview !
I was about to say the same 
I know nothing , I know nothing ...
|
|
|
|
|
Thanks for your replies,
the database is 300 MB with 6 months, iam thinking about the size after 2 or 3 or even 10 years.
PIEBALDconsult wrote: Users shouldn't be scrolling data at all.
about user shouldnt scrolling data, the case is user can use some filters to search the data and the result of this search may be more than 5000 records and will be displayed in the datagrid.
PIEBALDconsult wrote: Mdallal84 wrote:
partial loading
Like paging?
and the partial loading i tried like paging yes but not like paging grid in the web and user should flip pages to view data i wanted to use paging through scrolling the grid( MS source safe 2005) use partial loading on scrolling i think.
after doing some search i found something called virtual mode in the datagrid but its not working with n-tiers
are there any solution to implement the partial loading or any idea to load these huge data (remember the slow connection of VPN)
thanks all
|
|
|
|
|
Hi
How I can create a text box that doesn't write in English. I want write in box in my language (Persian) without using Alt+Shift ?
|
|
|
|
|
You have to switch the default language for the system the application is running on.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
When the TextBox GetFoucs , or
When your Application Start ( recommended )
Run This Code
private void InitCurrentInputLanguage()
{
foreach (InputLanguage ArabicLang in InputLanguage.InstalledInputLanguages)
{
if (ArabicLang.LayoutName.Equals("Arabic (101)"))
{
InputLanguage.CurrentInputLanguage = ArabicLang;
}
}
}
I am sorry I don't know the Palestinian language code ,
How ever you can get it from Control Panel at "Religion and Option settings->Languages"
hope this help
I know nothing , I know nothing ...
|
|
|
|
|
Wow, that's something new:
"Religion and Option settings->Languages"
And when you select "Zen Buddhist" everything will go to /dev/null!
|
|
|
|
|
| ok
I know nothing , I know nothing ...
|
|
|
|
|
Stark DaFixzer wrote: Religion and Option settings->Languages
Huh ? are you meaning "Regional and Language Options" ?
Watched code never compiles.
|
|
|
|
|
I hope not. This one's much more metaphysical. can just imagine it telling me, "Error. Agnostic interface detected."
"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
|
|
|
|
|
|
Hi all,
I have a Windows Form Application. On the Form I have a PictureBox.
I want to zoom this image in picturebox and display the zoomed image again in picturebox.
For this i have written below code. I am new to C# and hence dont know why the below code is not working.
OnZoomButtonClick()
{
Bitmap b = (Bitmap) pictureBox1.Image;
Graphics g = Graphics.FromImage(b);
// 3x zoom
g.ScaleTransform(3, 3);
pictureBox1.Image = b;
pictureBox1.Refresh();
}
Thanks in advance.
|
|
|
|
|
Hi,
no that won't work, as the Matrix stuff and the Transform methods only have their effect on the draw commands such as Graphics.DrawImage().
This would work, for some control, based on class members x, y, scale:
private void myControl_Paint(object sender, PaintEventArgs e) }
Graphics g=e.Graphics;
g.ScaleTransform(scale, scaale);
g.DrawImage(myImage, x, y);
}
I would use a Panel for this, as a PictureBox is not helping a bit, all you need is a surface, a canvas, on which your drawing is happening. A PictureBox is meant for showing an image as is, not for drawing anything special.
|
|
|
|
|
I cannot use other controls. It has to be Picture Box.
But it is mandatory to call drawimage in Paint message.
I want to zoom the image on the button click and display the zoomed image in picture box.
If user clicks 2-3 time it should zoom 2-3 times.
|
|
|
|
|
Message Closed
modified 23-Nov-14 6:15am.
|
|
|
|
|
Hi I have modified the code as below and it is working: -
Bitmap originalBitmap = picturebox.Image;
Bitmap newBitmap = new Bitmap(originalBitmap);
//Creates a new Graphics object from the specified Image object.
Graphics g = Graphics.FromImage(newBitmap);
g.InterpolationMode = InterpolationMode.HighQualityBicubic;
g.ScaleTransform(Zoomfactor, Zoomfactor);
g.DrawImage(originalBitmap, 0, 0);
picturebox.Image = newBitmap;
Thanks a lot.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
