|
It's not the update query that is the problem, but how much data you put in the database record.
Access has a limitation on the size of a data record. In Access 97 and Access 2000 it is 2048 bytes, but it seems that it has been increased to 4096 bytes.
If you want to put more data than that in a record, use the Memo data type. The actual data is stored outside of the record so you don't have to worry about the record size, and there is no size limit on the field. The entire database is limited to 2 GB, though, and each table is limited to 1 GB.
---
single minded; short sighted; long gone;
|
|
|
|
|
Thank you for the response and information. It seems unfortunate that the database is limited at 2GB with a 1GB table limit but since that is what I have to work with it'll have to do. I will work on changing to the memo type.
Thanks again for your time,
Blake M. Ward
|
|
|
|
|
Hi,
I've Microsoft .Net Framework SDK v 2.0 . I've downloaded some demo projects from codeprojects. But when i want to setup project it says that i need .Net Framework 1.1.4322 Is there any way to setup those projects in the current version of .Net ?
001
|
|
|
|
|
Just recompile them, the framework is backwards compatible.
|
|
|
|
|
How can i compile a windows installer package?? (I've only demo project, no source code)
001
|
|
|
|
|
The source code is hidden by the designers, you can build it by right clicking the project and selecting build from the Solution Explorer.
|
|
|
|
|
How is it possible to build an array of a generic type collection?
For example this is what I am to populate the ForwardCurves generic collection.
Notice that this is ok for the first loop.
For the following loops I wouls like to add to this generic collection i.e. ForwardCurves but would like to identify each loop separately in the generic collection.
Something like:
ForwardCurves[i].Add(forward);
Is this possible?
Thanks
Thsi is what I am doing now but you can not identify each table loop in the generic collection.
List<forward> ForwardCurves = new List<forward>();
foreach (DataRow row in table.Rows)
{
Forward forward = new Forward();
forward.IndexID = row["IndexID"].ToString();
ForwardCurves.Add(forward);
}
|
|
|
|
|
arkiboys wrote: Is this possible?
Yes
led mike
|
|
|
|
|
|
List<int>[] arrayOfIntLists = new List<int>[10];
|
|
|
|
|
Assuming there is a dataset i.e. ds
And there are tables in the dataset i.e. 10 but it can vary...
Then I think I should have a foreach loop to go through the tables and populate the collection.
foreach (DataTable table in dsMarketValuesCombinedByIndex.Tables)
{
Not sure what to put inside the foreach loop.
Thanks
|
|
|
|
|
List<List<BaseProvider>> providerMatrix = new List<List<BaseProvider>>();
led mike
|
|
|
|
|
Is this different?
List<BaseProvider>[] providerMatrix = new List<BaseProvider>[];
|
|
|
|
|
|
Hello!
I'm trying to write a tool that associates some data with the currently logged on Windows user account. I.e. the encryption key for the file is generated based on the user.
How can I do this?
Of course, just using the user name is bad, because it should also depend on the users password. Unfortunately I haven't found a function to get the user's password (is there one?).
I tried using the System.Security.Cryptography.ProtectedData.Protect function. The problem with this approach is that this function returns a byte array that includes a seed. I.e. when calling this function twice, you'll never get the same results. But this is a requirement, as I want to use its output only as key for my own encryption engine (which offers choice between different algorithms, like AES, Twofish, ...).
Best regards
Dominik
|
|
|
|
|
Using the users name is a bad idea because a user can change their name.
You also cannot use a users password because, for one, passwords expire and change, and two, there is no function to get the password.
About the only thing that doesn't change in a user object is it's SID.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I know that the SID is the only constant thing in a users account, but it is public isn't it?
An administrator can easily read all SIDs of users in a network. Therefore, using just the SID is a bad idea, too...
Any other way?
Thanks for your reply and best regards
Dominik
|
|
|
|
|
I've just found a solution and wanted to quickly let you know it, in case it's interesting for you, too:
First, a random byte array is generated using a cryptographically secure random number generator. This is the key used for encryption. It is protected using ProtectedData.Protect with the DataProtectionScope.CurrentUser option and written to the registry.
When loading, the protected key is retrieved from the registry, unprotected using ProtectedData.Unprotect and used as decryption key for our file.
I'm not sure what data ProtectedData is using, but it seems that the password can be changed, without making the ProtectedData behavior change, i.e. the user's password actually doesn't matter. Same applies to the user name. Probably Windows keeps some secret key for each user, which we can't access manually.
Best regards
Dominik
|
|
|
|
|
hi
i write my app with vc#2005 and crystal report for vs2005, i want to create setup package for my app, but how to do ??
thanks..
|
|
|
|
|
|
Hi,
A stored procedure runs three select queries.
Each of these select queries is being assigned to a table (See below).
The question is: In this case I know how many tables are returned so I use the "oDA.TableMappings.Add" three times. But what if I do not know how many tables are returned? How can I make a dynamic loop arouond "oDA.TableMappings.Add"?
Alternatively, Is it better to retrieve the whole of data into one dataset and then separate the data into datatables?
This is what I am doing at present:
SqlDataAdapter oDA = new SqlDataAdapter(oCmd);
//use Tablemappings to name the retrieved tables...
//otherwise have to use indexes to refer to each table...
oDA.TableMappings.Add("Table", "Curves1");
oDA.TableMappings.Add("Table1", "Curves2");
oDA.TableMappings.Add("Table2", "Curves3");
DataSet dsData = new DataSet();
oDA.Fill(dsData);
This is what I am trying to do:
SqlDataAdapter oDA = new SqlDataAdapter(oCmd);
int i = 0;
foreach(table in oDA)
{
oDA.TableMappings.Add("Table" + i, "Curves" + i);
}
DataSet dsData = new DataSet();
oDA.Fill(dsData);
|
|
|
|
|
Hi,
I'm new to C# and need some help with scrolling in panels.
I have a PictureBox (PB1) on a Panel in a Windows Forms appliction. PB1 is larger than the panel so scrollbars are needed on the panel. The Panel's AutoScroll property is set to true and the PictureBox's SizeMode is set to autosize. I have added a small PictureBox (PB2) on top of PB1 (in the upper left corner of PB1). So far, everything is ok and displayed as intended.
Now, I want to drag & drop PB2 from the upper left corner of PB1 to the lower right corner of PB1. But since I cannot see the right hand side of PB1 (it is larger than the panel) then the panel needs to scroll PB1 to the right and down when the dragged PB2 is close or on the right and lower borders of the panel.
Is there any information out there that can point me to the right direction how the scrolling can be implemented?
Regards,
|
|
|
|
|
hello,
I've got the following regexpression:
"<span .*bbc_underline.*>(.*)</span>"
and the following input string:
"this <span class="bbc_underline">is underlined <span class="bbc_strikethrough">and striked through</span>text.</span>"
when I do a replace on the expression, I get the following result:
"this text."
I'm quite new to regular expressions. the goal in the expression above is to yield the following result:
"this [u]is underlined [s]and striked through[/s]test.[u]"
but somehow, the first expression eats up more then it should. btw, I don't know if or what is nested. I just have a couple of span's with given classes, that will "turn into" square brackets. can somebody please help? A ton of thanks in advance.
/matthias
I love deadlines. I like the whooshing sound they make as they fly by. [Douglas Adams]
|
|
|
|
|
I would normally use:
"<span [^>]*bbc_underline[^>]*>([^<]*)</span>" The "^" within square-brackets says that the RE parser can match any character except the specified ones. I cannot remember if you need to use a backslash to escape the "<" character.
Your example text contains nest spans, so the above RE would match the inner "strickthrough" span on the first pass, then the outer "underline" span on the following pass.
You might find that the "Greedy and Lazy" section of http://www.codeproject.com/dotnet/RegexTutorial.asp[^] can simplify the expression.
Hope that helps.
Andy
|
|
|
|
|
hey andy,
lot of thanks for your reply. I've tried it out but the RE you've provided does not work. In the meantime, I came up with this expression
"<span .*?bbc_underline.*?>(.*?)</span>"
...but it does not work correctly either, since it matches the first occurence of </span> instead of the last.
In the case I did not explain it correctly: What I want to achive is to match the first occurence of <span SOMETHING "bbc_underline"> with the last possible occurence of </span> and replace everything within with [u]$1[/u]. I don't know how many nestings there are. The span classes I use come from a predefined list (bbc_underline, bbc_italic, bbc_strikethrough and the like)
I would greatly appreceate further help.
Matthias
/matthias
I love deadlines. I like the whooshing sound they make as they fly by. [Douglas Adams]
|
|
|
|