|
Hello,
Can anybody tell me here, how i can use StoredProcedures in a SQL Server CE Database? - Do the storedProcedures which i create in my VS.NET for my Smart Device Application automatically be transfered to the PocketPc when i will deploy it?
thx
regards
mat
|
|
|
|
|
mathon wrote:
Can anybody tell me here, how i can use StoredProcedures in a SQL Server CE Database?
SQL CE does not support stored procedures.
Regards,
João Paulo Figueira
Embedded MVP
|
|
|
|
|
Oh okay, are you sure? - because when i create a new replication i can choose to publish also the stored procedures??
Unfortunately i have a second question: Is it possible like normal databases of the SQL Server 2000 to create databases, tables in the Server Explorer of the VS.NET. Is it possible to create databases for the SQL Server CE also like this in VS.NET??
Regards
mathon
|
|
|
|
|
mathon wrote:
Oh okay, are you sure?
Pretty sure!
mathon wrote:
because when i create a new replication i can choose to publish also the stored procedures??
Did you see what happens to the replicated stored procedures?
mathon wrote:
Is it possible to create databases for the SQL Server CE also like this in VS.NET??
You will be able to do that with SQL Mobile, not with SQL CE 2.0. To help with this, I have developed a tool to help port databases to and from SQL CE. Have a look at it on my website:
Primeworks[^]
Regards,
João Paulo Figueira
Embedded MVP
|
|
|
|
|
HEy guys Ive made a program in C# and I want to open notepad when a user presses a particular button how do i do that
|
|
|
|
|
Usually this type of question goes purposely unanswered cuz its so easy to find the solution, but i'll give it to you...
System.Diagnostics.Process.Start("C:\windows\notepad.exe");
|
|
|
|
|
As AK suggested, you can just do a call to the process object:
System.Diagnostics.Process.Start(@"C:\windows\notepad.exe");
But, I'd suggest you rather "start" the file directly:
System.Diagnostics.Process.Start(@"C:\test.txt");
This way, the default text editor will be started with the file.
It saves a bit of code as you don't need to set up parameters to pass to the process, but it also gets around a issue when the admins install windows under a different folder or something similar.
HTH
Cheers,
Simon
sig :: "Don't try to be like Jackie. There is only one Jackie.... Study computers instead.", Jackie Chan on career choices.
article :: animation mechanics in SVG blog:: brokenkeyboards "It'll be a cold day in Hell when I do VB.NET...", Chris Maunder
|
|
|
|
|
hi
I have this code to retrive all users who are connected to a server . but i need to retrive the passwords of each user and i stucked their.
any one can help me ?
please help me !!
|
|
|
|
|
Passwords are not really ment to be given out anyway... so your probably going to have a hard time to get them... unless there's a security bug.
What server are you talking about?
|
|
|
|
|
What server i am talking about ?
What do you mean ?
|
|
|
|
|
Yes what server?
Are your clients connecting to a SQL server, or a custom implementation for some application? What is the server that the clients are connecting to?
|
|
|
|
|
they are connected to sql server , sorry if i didn't say that directly
|
|
|
|
|
Well i'll try to help you out. Some applications are designed very weak. You might be able to find a table with a list of user names and passwords.
That's if the default sql login was not used.
|
|
|
|
|
|
Is there anyway for me to update a client app about how fast the download is going, how far along it is, using .Net remoting. I know when i used sockets, i could detect how large the file wise and divide by the currently downloaded bytes *to get the current download percent* is there a way to do this in Remoting, since the bytes and underlying information is *seemingly* hidden.
Thanks you.
Jesse
The Code Project Is Your Friend...
|
|
|
|
|
Jesse,
Remoting is intended to be a replacement for DCOM. As such it supports remote method calls but it is not intended for downloading files. That is why the data is 'seemingly hidden'.
Michael
This signature left intentionally blank
|
|
|
|
|
TIA for any help!
i want to set an event handler for AfterCheck on my treeview.
i found this piece of code but am not sure how to set the name
of the event.
what is supposed to go in place of the word "node" in node_AfterCheck
private void node_AfterCheck(object sender, TreeViewEventArgs e)
{
becuause the event is not firing.
|
|
|
|
|
Basically, an event handler is just a function with specific parameters.
The thing that makes an event handler different, is when it's actually hooked up to an event on an object.
So, your node_AfterCheck is a function that isn't hooked up to anything.
Typically, the event handler is prefixed with the object's name.
To hook this up to a treeview called treeView1, do this:
this.treeView1.AfterCheck += new System.Windows.Forms.TreeViewEventHandler(this.treeView1_AfterCheck);
The easier way of doing this, is to double click the event you want in the object's properties window. This will automatically create the delegate assigning code as well as the stub method code.
Hope this helps.
Cheers,
Simon
sig :: "Don't try to be like Jackie. There is only one Jackie.... Study computers instead.", Jackie Chan on career choices.
article :: animation mechanics in SVG blog:: brokenkeyboards "It'll be a cold day in Hell when I do VB.NET...", Chris Maunder
|
|
|
|
|
Thanks that worked.
I put the line in the Form1 constructor. is there a better place to put
it?
also i first tried to take your advice:
The easier way of doing this, is to double click the event you want in the object's properties window. This will automatically create the delegate assigning code as well as the stub method code.
when i look at the the object's properties window (TreeView)
there is no event for AfterCheck. i couldn't find any events to select at all.
i see DataBindings,DynamicProperties,Name, AccessibleDescription...etc.
When i double click the object i get tvMenu_AfterSelect event
What am i missing?
TIA
|
|
|
|
|
In the design view of a form, double clicking an object will create the stub code for a default event that MS had in mind for the control.
eg: if you double click a form, the myForm_Load() event will be created for you.
When looking at the properties window for a treeview (in C#) select the small lightning bolt icon just below the object dropdown box at the top.
This switches the properties window into a "event listing" for the selected object.
Now you should be able to see the "AfterCheck" event under the behavior heading.
Cheers,
Simon
sig :: "Don't try to be like Jackie. There is only one Jackie.... Study computers instead.", Jackie Chan on career choices.
article :: animation mechanics in SVG blog:: brokenkeyboards "It'll be a cold day in Hell when I do VB.NET...", Chris Maunder
|
|
|
|
|
ahhh, a good dose of ego deflation.
Thanks!
|
|
|
|
|
Hi,
My application loads two assemblies. Now I want to transfer messages between the two loaded assemblies? Is it possible?
Cheers
CNU
|
|
|
|
|
Hi,
I am writing a Windows application using C#, in which I have to copy some files to the local web server's home directory (for ex. c:\inetput\wwwroot or something else). How can I find out the the local web server's home directory? Or is there any other work around?
Cheers
CNU
|
|
|
|
|
Open the IIS management console (Administrative Tools --> Internet Information Services) and select the website you want the root folder of (on Windows XP there is only the default website). Right-click the website, select properties from the menu. In the dialog select Home Directory, the information you want is on that tab.
Do you want to know more?
Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!
|
|
|
|
|
Thanks for the reply.
But I want to know the value of the Home Directory programmatically..
Is it possible?
Cheers
CNU
|
|
|
|