Storing binary data in MS Access database -- what do you think? - C# Discussion Boards

20-Jul-06 9:16

An interesting challenge. My initial thougth was sure, use the selectedText property, but damn it, it doesn't have that one Mad | :mad:

Only way I can think of is to handle the mouse events and calculate the position within the string based on the location of the event. Very complicated though.

Re: DateTime picker

Balaj_C20-Jul-06 9:26

Balaj_C

20-Jul-06 9:26

do know how to trap the events in the datetime control when the up or down arrow is clicked. I mean when the up arrow is clicked i want to do something or when down is click, i want to do something different and want to do it before the value changes because the value change will depend on the what i do on those events.

Re: DateTime picker

Not Active20-Jul-06 9:39

Storing binary data in MS Access database -- what do you think?

20-Jul-06 9:39

Unfortunately there is no OnBeforeChanged event. Can't you handle the ValueChanged event and either revert to a previous value or allow the change?

OnValueChanged(...)
{
if( out of range )
dateTimePicker = OldValue;
else
do something
}

xkx3220-Jul-06 7:06

xkx32

20-Jul-06 7:06

Hi there,

I'm coding a photo gallery desktop program and I'm planning to store the images in an MS Access DB (OLE field). The size of the images I got is around 600 MB... ~ 400 KB each.

What do think? Can MS Access handle it or I should look for an alternative?

Please advise. Your help would be greatly appreciated.

Alternative

Ennis Ray Lynch, Jr.20-Jul-06 7:12

Ennis Ray Lynch, Jr.

20-Jul-06 7:12

instead of storing the binary data in the access database store the location to the data. Either file names or URLs. I think such large amounts of data in access could cripple it.

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

Moving Toolbars

hamidreza_buddy20-Jul-06 5:56

hamidreza_buddy

20-Jul-06 5:56

hi i want to know how should i make thise kind of Toolbars which can move around and when drag it out of the main Toolbar they become like a DialogBox.

Re: Moving Toolbars

RizwanSharp20-Jul-06 6:14

RizwanSharp

20-Jul-06 6:14

Use ToolStrips in .Net 2.0

Rizwan

Full screen

-Yoyosh-20-Jul-06 5:41

20-Jul-06 5:41

I read the article
http://www.codeproject.com/csharp/fullscreenmode.asp[^]

but this is nasty way to do that. Maybe C# 2.0 has already FullScreen property in some class for I could use it?

Not Active20-Jul-06 5:50

20-Jul-06 5:50

You can set the WindowState property to Maximized. Or do you want the black backgound with your app in the center?

-Yoyosh-20-Jul-06 9:42

20-Jul-06 9:42

Full screen and maximized window are 2 different things, the solution below is correct.

Not Active20-Jul-06 11:42

20-Jul-06 11:42

Perhaps I'm missing something Confused | :confused:

I'm always looking to fill in the gaps in my knowledge. Both of these seem to produce the same results.

WindowState = FormWindowState.Maximized;
TopMost = true;

Bounds = Screen.AllScreens[0].Bounds;
TopMost = true;

-Yoyosh-20-Jul-06 12:44

20-Jul-06 12:44

First of all, u didnt said that I should used the line:
TopMost = true;
Second of all, the solution produced by that guy isn`t correct in 100% too. Maximization is an effect that u can achive by clicking appriopriate button on the top your window. Fullscreen gives ur application full screen, so no borders around, no start button, no the upper strip. U got every pixel on the screen up to u. Many computer games offer full screen, while many windows applications (form oriented) offers just a maximization.

cheers

Not Active20-Jul-06 14:30

20-Jul-06 14:30

-Yoyosh- wrote:
First of all, u didnt said that I should used the line:
TopMost = true;

Nor did you ask for TopMost.

-Yoyosh- wrote:
Maybe C# 2.0 has already FullScreen property in some class for I could use it?

You also didn't specify that you wanted no borders. We'll just say it was miscommunication and move on. Smile | :)

Sean8920-Jul-06 6:01

Sean89

20-Jul-06 6:01

This works for full screen mode for me:

private void Form1_Load(object sender, System.Windows.Forms.KeyEventArgs e)
{
this.Bounds = Screen.AllScreens[0].Bounds;
this.TopMost = true;
}

Does that help?

-Yoyosh-20-Jul-06 9:43

Re: Full screen [modified]

20-Jul-06 9:43

Yes, exactly, thank you Smile | :)

Do you maybe know how to get rid of window bounds and the upper strip with name of the form and min, max and close buttons?

Sean8920-Jul-06 11:43

Sean89

20-Jul-06 11:43

Set the FormBorderStyle property of your form to "None".

That should do it Laugh | :laugh:

-Yoyosh-20-Jul-06 12:48

Move Active Directory Computers w SQL Server datasource

20-Jul-06 12:48

oh yee it does Wink | ;)

thanx again

smoore420-Jul-06 5:21

smoore4

20-Jul-06 5:21

I am trying to move computers (n=450) from one OU to another by iterating through a list of computernames that I have stored in a SQL Server table. Accessing the data works fine. I cant seem to write a DirectoryEntry path as a combination of the data row and a string.

Is this impossible or does somebody know a workaround. Thanks!

Steve

*********************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.DirectoryServices;

namespace MoMA
{
class ChangeOU
{
static void Main(string[] args)
{
//Connect to database and get list of PC names
string connectionString = "server=localhost; Trusted_Connection=yes; database=Users";
string commandString = "SELECT computername FROM vwFinalUserListTest";
SqlDataAdapter sda = new SqlDataAdapter(commandString, connectionString);
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable dt = ds.Tables[0];

foreach (DataRow dr in dt.Rows)
{

string pc = (string)dr["computername"].ToString();
string movePath = "LDAP://CN="+pc+",OU=TestOU1,DC=MUSEUM,DC=MOMA,DC=ORG";
//Console.WriteLine(movePath);
// This writes out the path exactly as I want

// This works
DirectoryEntry deMoveFrom = new DirectoryEntry("LDAP://OU=TestOU2,DC=MUSEUM,DC=MOMA,DC=ORG");
DirectoryEntry deMoveTo = new DirectoryEntry(movePath);
// This is where it fails stating that the DirectoryEntry path is not valid
deMoveFrom.MoveTo(deMoveTo);

}

Console.WriteLine("Completed with success");

} //end Main
} //end class
} // end namespace

Regular Expression for sequence

seee sharp20-Jul-06 5:14

seee sharp

20-Jul-06 5:14

Hello,

I need to find sequence of number or alphabets using regular expression. Does anyone knows the required pattern.

Thanks in advance.

- ashish

Re: Regular Expression for sequence

Not Active20-Jul-06 5:54