|
public void LoadSQL_DB(TreeNode DB)
{
DataTable table = new DataTable();
SqlConnection sqlConnection1 = new SqlConnection();
TreeNode treeNode;
int count = 0;
SqlCon = new SqlConnection("Data Source= Localhost; Integrated security=True;database=master ");
SqlCon.Open();
SqlCom = new SqlCommand();
SqlCom.Connection = SqlCon;
SqlCom.CommandType = CommandType.StoredProcedure;
SqlCom.CommandText = "sp_databases";
SqlCom.Connection = SqlCon;
SqlDR = SqlCom.ExecuteReader();
table = ReaderToTable(SqlDR);
foreach (DataRow row in table.Rows)
{
treeNode = new TreeNode();
treeNode.Text = row["DATABASE_NAME"].ToString();
DB.Nodes.Add(treeNode);
DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes.Add("Tables");
DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes.Add("Stored Procedure");
DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes.Add("Views");
DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes.Add("Roles");
if (DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes[count].Text == "Tables")
{
LoadSQL_Tables(DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes[count], treeNode.Text);
if (DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes[count+1].Text == "Stored Procedure")
LoadSQL_StoedProcedures(DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes[count + 1], treeNode.Text);
if (DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes[count + 2].Text == "Views")
LoadSQL_Views(DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes[count + 2], treeNode.Text);
}
}
SqlDR.Close();
SqlCon.Close();
}
thanks for the help
regards,
|
|
|
|
|
|
ok thanks again
regards,
mariam
|
|
|
|
|
Hi All,
i want to create the moving chart in windows application like it is displaying the current data getting from any hardware device,how will it be possible.
Please help
Thanks and Regards,
Lalit Narayan
|
|
|
|
|
|
|
Hi All,
I'm just working with the Dns class and have a need to use IP addresses. At the moment I'm just retrieving a list of IP addresses using the GetHostByName method and then validing the format of each IP address.
The issue is that I'm then going to use this as a base for producing some service endpoints. I want to make sure that the IP address I use is correct for the machines identity on our network rather than just grabbing the first IP address in the list which seems a bit random.
Should I be calling a domain controller and confirming with it that the IP address I plan to use is the 'correct' one?
Cheers,
|
|
|
|
|
I'd imagine if the Dns class returned the IP address for the hostname you were looking for (or the other way around), then that would be the correct IP address. If it is the wrong IP address, the host you are looking for either changed names or is offline.
|
|
|
|
|
Hi,
Actually I'm using IPEntry on the machine I want to get the network IP for. When using IPEntry you get back IPAddress[] so currently I'm just taking the entry at position 0 which to me seems a bit prone to errors to rely on there being the actual machine network IP address at position 0.
Cheers,
|
|
|
|
|
i have a question about DCT..actually it's sound like silly question but it's important for me..
The question is:
1. Why on DCT the function use a cosine function, if we see on the image and the
function there is no connection with angle.
2. Why the function using cosine, why not using sine or tangen? what is the influence
for the compression ratio?.
3. Is it true that we using the pixel depth for making 8x8 matix as the input for DCT,
if it's true how to get a pixel depth on image in C# so we could make the 8x8 matrix.
thanks.. God bless you
|
|
|
|
|
Hi,
with a general question like that, you should do some research first. Here[^] is something worth reading.
1. because it works well
2. sine could be used equally well, tangent would be harder to use due to it frequently becoming infinite
3. No
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
I need some Idea to implement this .
1.User will download One exe from my web sites. [Windows Application ]
2.When user run that exe, It will perform some operation on client system and it will call one of my web services to update my database with some information.
Is it possible to create the dynamic build with each user ID. Means I need to identify that user that who is calling my web services and based on that I will update my database.
Say when it call my webmethod updateDB, it will call like
updateDB(int userID, string systeminfo)
Here I need to identify the UserID.
Any Suggestion or any other idea to achieve this ?
Thanks in advance !!
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Just reformulating your question, to verify that I've understood the question. You want to embed some UserID-marker in your excutable/class library, before it gets downloaded and installed?
I are troll
|
|
|
|
|
Eddy Vluggen wrote: You want to embed some UserID-marker in your excutable/class library, before it gets downloaded and installed?
Exactly Eddy  . And its a windows application. Any idea
Thanks in advance !!
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
My original suggestion would be to read the MAC-address once you're on the client, and send that back, but that's private information of the customer, and in some countries you'd need the clients' consent to do so. That's one option down.
Another approach would be to compile a personalized version, build and create a setup, prior to downloading. That would mean that there's a delay in the download, and possibly a rather huge load on your webserver. That's two options down.
Perhaps you can download an addendum after the first install? That wouldn't delay the initial download, and you could easily compile a small classlibrary. The application shouldn't be able to run without this library, and it should be signed (to prevent tampering).
Perhaps you can even delay the compiling and the building; if you were to download the sourcecode for your custom key-classlibrary, you could compile once it's downloaded. That would make it harder to sign that classlib, but would remove the compilingprocess from your server and onto the client-machine.
I hope that someone can give some idea's that are more efficient/easier to implement
I are troll
|
|
|
|
|
First of all thanks for your time
Eddy Vluggen wrote: approach would be to compile a personalized version, build and create a setup, prior to downloading.
How will I do that? Suppose user click on download and I generate the userID as U123. Now how do i embed it with that exe, and I need to use the same from exe to call my web service and database based on userID.
Please help.
Thanks!
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
I've never done this, but have seen something similar in ASP.NET. You can catch the moment that someone wants to download a file. First, you'd have to encrypt the string and embed it in your sourcecode. The WebApp can only compile your application if it has access to the source-code of what it's supposed to compile. That's why I suggested that you put it in a classlibrary, besides the applications' executable.
The steps involved would be something like this;
- Generate a key, crypt it, and add the key to the DB as "taken".
- Write the source for a dll that returns this key on demand
When you start your executable;
- Check if your classlibrary is in place, if not:
- Start the download of the class-library (from code, or manual)
- The WebApp gets requested to download a file, compiles the classlib with the embedded string and push the generated file.
I'll try to build a small prototype to do this thing, might take a while
I are troll
|
|
|
|
|
Eddy Vluggen wrote:
When you start your executable;
- Check if your classlibrary is in place, if not:
- Start the download of the class-library (from code, or manual)
- The WebApp gets requested to download a file, compiles the classlib with the embedded string and push the generated file.
Eddy thats sounds good. and am starting some prototyping. Thanks again.
Eddy Vluggen wrote: I'll try to build a small prototype to do this thing, might take a while
Not a Issue. Please update me on same.
Thanks!!!![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Eddy, one question
Eddy Vluggen wrote: compiles the classlib with the embedded string and push the generated file.
How will I get that string? If in-between of that one more request come then what happen?
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Well, that's the string that's unique for the download. You can base that on the browser-information, or you might want to use a query-string variable to set it. You should be able to trackback this information to previously entered registration-details.
In other words, in that place you'd typically want the reference to the user that's currently logged in
I are troll
|
|
|
|
|
How about creating a GUID and putting it into a config file that then gets downloaded with the application? Or are you trying to implement some kind of licensing scheme?
|
|
|
|
|
Hi,
I want to develop cards game (.jpg,.jpeg) using C#. Please let me know is C# is a better way to do it. If any one have sample source code which loads one main image in a background and other card images as per the logic on that will help.
Thnks
|
|
|
|
|
There's a cards.dll on your machine that contains a deck that you only need to shuffle. C# and VB.NET are both viable choice's, pick the one that you're experienced with. The links below use the cards.dll, instead of jpg images.
There's a card-game starterkit on MSDN. You can download the C# version here[^], or the VB.NET version here[^]. There are also some good examples on CodeProject and a cool C# tutorial can be found here[^].
Good luck and Happy programming
I are troll
|
|
|
|
|
So far I can get all computers in an active directory:
DirectoryEntry entry = new DirectoryEntry("LDAP://" + thisDomain.Name);
DirectorySearcher mySearcher = new DirectorySearcher(entry);
mySearcher.Filter = ("(objectClass=computer)");
foreach (SearchResult resEnt in mySearcher.FindAll())
{
MessagBox.Show(resEnt.GetDirectoryEntry().Name.ToString() );
}
And I can get all Organizaitonal units:
DirectorySearcher mySearcher2 = new DirectorySearcher(entry);
mySearcher2.Filter = ("(objectClass=organizationalUnit )");
foreach (SearchResult resEnt2 in mySearcher2.FindAll())
{
MessageBox.Show( resEnt2.GetDirectoryEntry().Name.ToString());
}
Now how can I get a computer and its organizational unit? Any suggestions?
|
|
|
|
|
THIS IS KARAM..
WHICH WILL BE THE APT ALGORITHM TO IMPLEMENT TEETH SEGMENTATION AND EXTRACTION?
modified on Wednesday, April 1, 2009 8:19 AM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
