|
you mean your putting username/password in connection string? if so you need to set up database on server with useraccount that matches those value, does not matter if they stored in any table
My opinion is... If someone has already posted an answer, dont post the SAME answer
|
|
|
|
|
I think there's something wrong in the security settings. Are you sure that SQL Client is placed in GAC? Also do you start your program from trusted folder? SQL Server Client needs pretty much privileges.
|
|
|
|
|
My project is a windows application. After i install the setup file of this project. I am getting the first form, i need to select from four options i,e. four buttons. When i press a button, next form is displayed asking for username and password. After giving username and password, when i press login button then i am getting that exception. If i run normally in visual studio 2005 , it is executing .
|
|
|
|
|
Good day helpers
I'm not sure how to embedded my code to a PDA.
|
|
|
|
|
Pardon?
Regards,
Rob Philpott.
|
|
|
|
|
I'm craeting a prafic system as my third year project. Now I want to embedde that code in my PDA device.
|
|
|
|
|
I meant a trafic not profic
|
|
|
|
|
PDA is a Personal Digital Assistant that a person can use as a portable computer. Do you get me?
|
|
|
|
|
We get you, we just don't know WTF you need help with... did you start coding at all? Where is your error?
|
|
|
|
|
When they talking of a lumpan they discribe ppl like u
|
|
|
|
|
Go learn English, you have a better chance of passing then you do of coding.
|
|
|
|
|
|
Don't forget, you fail.
Next time you want work done for free, go to class or better yet, support real programmers and go to this site[^] so at least the people who contracted to you get something for their money, jerkoff.
|
|
|
|
|
Member 3916856 wrote: PDA is a Personal Digital Assistant that a person can use as a portable computer.
My god, If only I had known that earlier. That makes everything clear. A portable computer, YES! Like... like a Nintendo gameboy?
|
|
|
|
|
Ja its more like that, I haven't started my code. I was wondering if is there any material that u guys can provide. Or where i can get hepl from. Thnx
|
|
|
|
|
*sigh* I'll probably get downvoted for this, but here you go.
The only way I know how to do this is with Visual Studio and using C# because I presume you knew that this is a C# forum, right? Don't ask me how to use this with Embedded Visual C.
1) Use Visual Studio to set up a smart device project
2) Connect PDA with tether - you may need to use ActiveSync
3) Build/Test using the emulator
4) Deploy with VS to device when you're satisfied with results
Scott P
"Simplicity carried to the extreme becomes elegance."
-Jon Franklin
|
|
|
|
|
No downvote here. This is a perfect breakdown of the process and covered with remarkable patience.
|
|
|
|
|
Thanx, if u know what material I can use for this plz send it to me as a URL or site-address
|
|
|
|
|
Me neither. Did you mean to ask how to upload a program to a PDA?
|
|
|
|
|
that as will, I haven't start-up with my code thou
|
|
|
|
|
The project I am currently working on retrieves a tree structure from the DB, keeping it in a data set. I am trying to find a faster way of getting rows back, as if the tree has 100k relationships, this takes some time (around the 4min mark).
I currently use dataSet.Tables[0].Select("[Parent] = " + parent); . I read on the web that Rows.Find(key); is faster, however, since I am building a tree, I need to retrieve the parents, which isn't a key.
So the question is, does anyone know of a better method to retrieve data from a data table?, or any other suggestions, I could look into not using a data table.
Cheers.
Regards,
Gareth.
(FKA gareth111)
|
|
|
|
|
why dont you go throught the table sequencially and put the value where you need it in the tree?
My opinion is... If someone has already posted an answer, dont post the SAME answer
|
|
|
|
|
Do you already use recursion. You would start with rows having parent equal to null and then search the data recursively (while building the tree).
Perhaps if you could explain a bit more about the problem it would be easier to make suggestions.
|
|
|
|
|
Yes I do use recursion. I'll try to explain it more in depth. I am building a graph using a 3rd party DLL (see: yWorks.com). The model builds around 4k relationships every 10 seconds when viewing a large amount of data (95k relationships). The model is built on levels, e.g: when the user first opens the program, it retrieves all the data for the whole model, and builds 2 levels. The user can then expand to as many levels as they like.
Below is a quick sample of the code I use to build the model.
private void BuildModel(Node node, int currentLevel)
{
if ((currentLevel + 1) > _modelLevel)
return;
currentLevel++;
DataRow[] matchingRows = _relationshipDataSet.Tables[0].Select("[" + PARENT + "] = '" + node.Name + "'");
if (matchingRows == null || matchingRows.Length == 0)
return;
foreach (DataRow row in matchingRows)
{
string childName = row[CHILD].ToString();
string nodeHashCode = childName + node.Name + node.GetHashCode().ToString();
if (!_graphNodeHashSet.Contains(nodeHashCode))
{
_graphNodeHashSet.Add(nodeHashCode);
BuildModel(childNode, currentLevel);
}
else
{
List<node> nodeList = new List<node>();
bool isValid = _nodeDictionary.TryGetValue(childName, out nodeList);
if (isValid)
{
foreach (Node childNode in nodeList)
{
BuildModel(childNode, currentLevel);
}
}
}
}
}</node></node>
Hope this helps some more. I am also using .NET 2.
Regards,
Gareth.
(FKA gareth111)
modified on Friday, February 6, 2009 4:48 AM
|
|
|
|
|
Gareth H wrote: retrieves a tree structure
Are you building a TreeView?
If so, I would likely do it as:
0) Query the root-level data (parents)
1) Iterate those values
1.0) Insert the value to the TreeView
1.1) Query for the children of that value
1.2) Iterate the children
1.2.0) Add the child to the parent's node
... and so on
(You do have an index for the parents, yes?)
Or, perhaps, this way (which uses more resources):
0) Query all the data, as you do now
1) Iterate the parents
1.0) Insert the value to the TreeView
1.1) Also add the parent's ID and node to a Dictionary<id,node>
2) Iterate the children
2.0) Get the Parent's node from the Dictionary
2.1) Add the child to the parent's node
2.2) If the children have children, add the node to a Dictionary (the same one or another, depending on your schema)
... and so on
|
|
|
|