:: problem in use UPDATE statement :: - C# Discussion Boards

Guillermo Rivero13-Dec-03 11:22

13-Dec-03 11:22

What exactly do you want to do ??

I used the ActiveX on a windows form application, but I've never used it on a web page, just saw the example that came with the package.

If you give me a little description about what you want to do, may be I can give you a hand.

Free your mind...

Re: display word file on form

hazzem elrefai13-Dec-03 12:55

hazzem elrefai

13-Dec-03 12:55

never mind Guillermo i desided to use it with windows form
but plz allow me to contact u after this. coz i have some problems in this project coz most of my experience in the web field with java(jsp) & asp.net(c#)
thnx so much

namespace curiosity

Member 76049710-Dec-03 21:39

Member 760497

10-Dec-03 21:39

Hi to all and compliments about the site

Is possible in VC#, no with the alias, to make so that the compiler uses in automatic the short name of namespace.

Es instead of:
using System.Window.Forms
public class MainForm: System.Window.Forms.Form
{}

Directly:
using System.Window.Forms
public class MainForm: Form
{}

In this way the code is simpler to read

Thanks Pino D'Oh! | :doh:

Re: namespace curiosity

Heath Stewart11-Dec-03 3:27

Heath Stewart

11-Dec-03 3:27

You definitely should read the C# language specification in the .NET Framework SDK documentation, and should at the very least take a look at some examples. It's important to understand what is in the .NET class library, but it's even more important to know the language you'll be programming in! By far!

What you're looking for is:

using System.Windows.Forms; // Notice the ;
public class MainForm : Form
{
  // ...
}

Like most languages, C# statements most often end with a semi-colon (;) and use curly brackets for blocks.

-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----

"database wizard"

brain2cpu10-Dec-03 21:39

brain2cpu

10-Dec-03 21:39

In old days In FoxPro could generate a page for a given table with edit boxes for every field, some navigation buttons, add, delete, find - all this without too much typing
Is there something like that for C# ?
Datagrid is not an option here because of validations, auto-calculated fields and user preferences Mad | :mad:

I have a lot of tables with a lot of columns and to create all forms is just overkill.
Any hints please?
Thanks

Re: "database wizard"

Heath Stewart11-Dec-03 3:24

Heath Stewart

11-Dec-03 3:24

C# is a programming languages that targets the Common Languages Runtime. FoxPro is a complete database application environment so it has a lot of bells and whistles like that.

The DataGrid can do all those things you want by overriding key functionality. I suggest you thoroughly examine the methods and properties of the DataGrid. As far as user preferences are concerned, this is not even an issue. As with all preferences, you change the the object in question when either initializing or update it when preferences change.

Windows Forms uses data-bound controls. You can drag-and-drop a table to your form which will create the necessary connection and command objects (although it'd be better to create a new DataSet class (Add New->Class->DataSet) in your project and drag the tables to the designer's surface, then drag the DataSet component from the Component toolbox and select your strongly-typed DataSet. Then you add the appropriate controls to your form, go to the DataBindings category and click the "..." button. The UI is pretty intuitive.

You can find more information by reading some of the articles in the .NET Framework SDK.

open forms in virtual display

Günther Meusburger10-Dec-03 20:25

Günther Meusburger

10-Dec-03 20:25

hallo

i posted a similarly message a few days before in the vb-forum but unsuccessfully.

is it possible to create a virtual display device?
is it possible to open a form in this virtual device?

i need to do this, because i like to make a screenshot of this form but the form should not be visible for the user. i tryed to make a screenshot, when the form is out of the screen or when it is invisible but of course this doesn't work.

any idea...

regards
bernd

:: problem in use UPDATE statement ::

Nazila Naderi10-Dec-03 16:08

Nazila Naderi

10-Dec-03 16:08

I want to do something like below(in ASP.NET & C#):

string strupdate = "UPDATE table SET field = field + intvariable WHERE otherfield = yes";

but i don't know how i can do (add a variable value to a numerical field in a ACCESS database).

Please tell me the right string that i can use.

Re: :: problem in use UPDATE statement ::

Heath Stewart11-Dec-03 3:10

Heath Stewart

11-Dec-03 3:10

I don't understand your question. Are you asking how to add (or concatenate) two values, or how to execute the UPDATE statement?

As far as adding or concatenating values, what you typed works fine so long as the field and intvariable are of the same type or are convertable to the same type.

To execute the statement for an Access database, look at the System.Data.OleDb namespace, specifically OleDbConnection, OleDbCommand, and OleDbParameter. Using parameters in your statement makes it easy to execute a statement multiple times by only changing the values of parameters and executing the statement, and saves you from having to do string concatenation (very inefficient if you just use +) and proper quoting and escaping.

Re: :: problem in use UPDATE statement ::

KevinMac11-Dec-03 10:20

KevinMac

11-Dec-03 10:20

Nazila I thought I might give you a different twist on your question. I write classes that overloaded the toString()'s (if I am being lazy I make them methods) so that I can always get my variables back with the correctly. Example

public class AccessDb
{ //in my data object
public int pInt(int intIn) // This is the lazy way
{// this is only an example I would use inherited base classes and
// overloading the toString it is so much cleaner.

return "'" + intIn.toString() + "'"
}
}

// then later in your Business object code
AccessDB db = new AccessDb();
db.Update("update table set field=" + db.pInt(intvariable)+ "where otherfield=yes");

I started doing this so I don't get caught recoding everytime the database gets switched from Access to MySql or something else happens. I really like insulating the data objects from the business objects and this is a big help in making generic interfaces. My applications can switch database backends by setting preferences which makes my life much better. It is very important to read up on your database access in .Net and get your design down solid first you will need this when you are setting up the data classes. There are a couple of really cool articles on how to implement this.

Let me know what you think of the idea.

Kevin

Perl has made me soft.

ambulopod10-Dec-03 14:25

ambulopod

10-Dec-03 14:25

Hi,
I'm working with Arrays of strings for which I don't know the Length beforehand. Because I have a boatload of code that needs to index these arrays, I don't want to embed every single line in a try{} block or have an if() statement on every line without looking at other approaches that would save me some syntax. Basically, I want my program to return zero instead of throwing IndexOutOfRangeException. Can anybody point me in the right direction for this?

Thanks,
John

Re: Perl has made me soft.

Christian Graus10-Dec-03 15:07

Christian Graus

10-Dec-03 15:07

The only way to do this AFAIK is to create a wrapper class for the array that gives you the behaviour you want. If it's an array of strings, why/how can you return 0, or do you mean an empty string ?

Christian

I have drunk the cool-aid and found it wan and bitter. - Chris Maunder

Re: Perl has made me soft.

ambulopod10-Dec-03 15:15

ambulopod

10-Dec-03 15:15

Yes, I meant to write empty string. Which leads to my next question, is there some way I can use the Convert.ToInt32, Convert.ToDouble, etc, and have them return 0 if the string is unrecognized?

I spent a minute writing a class that derives from Array but got an error "cannot inheret from special class System.Array." But I'll research that route more thoroughly now.

Re: Perl has made me soft.

Christian Graus10-Dec-03 15:17

Christian Graus

10-Dec-03 15:17

Same answer - you can't inherit, you need to contain, your class HAS an array, you can't write a class that IS A array.

So you need a class with static methods that call Convert.ToWhatever, and handle failure the way you want them to.

I'm not suggesting this is a good idea.

Christian

I have drunk the cool-aid and found it wan and bitter. - Chris Maunder

Re: Perl has made me soft.

ambulopod10-Dec-03 15:20

ambulopod

10-Dec-03 15:20

Okay, that makes sense. I'll try that. Thanks.

Re: Perl has made me soft.

Hovel10-Dec-03 22:30

Hovel

10-Dec-03 22:30

Perl has made me very soft.
c# is sharpening me up again.

Rgds,
Ian

Networking Question

Spiros10-Dec-03 12:17

Spiros

10-Dec-03 12:17

Hi everybody

I an all the examples that I have studied so far with regards to remoting there is a server and many clients that communicate with it using either TCP/IP or HTTP. What kind of communication protocol can we use for the case of windows forms that communicate with other windows forms and need to pass data to them. So instead of having a pool of sockets to connect, we have the server (window form father) to create and then send data to the new window form (window form child) and then wait until the child window returns some results. If we use TCP/IP and config files all child processes will use the same port. From my small exeprience I believe that this is at least incorrect. So my question is: does anyone know am effective way to perform that type of communication?

Thank you very much for your time.

Spiros Prantalos
Miami the place to be!!

One More Detail

Spiros10-Dec-03 12:32

Spiros

10-Dec-03 12:32

The whole application runs on Window Terminal Server

Spiros Prantalos
Miami the place to be!!

Re: Networking Question

Heath Stewart10-Dec-03 12:37

Heath Stewart

10-Dec-03 12:37

Using a TcpChannel is typical for remoting between app domains on the same machine. There is far less overhead than with HTTP (a protocol over TCP/IP). Using a .config file for remoting configuration (by calling RemotingConfiguration.Configure) does offer benefits over manual configuration, but you can still specify ports. Each application will have it's own configuration file (named yourappname.exe.config) so you can configure clients to use the same or different ports. Of course, applications that need to communicate with each other via remoting must use the same port. Also note that with remoting, you don't have to use the typical client-server setup. Clients can talk to each other as well as can servers; in essence, each application acts as a client and server (sending requests and getting responses back for both applications).

You should pick up the book ".NET Remoting" from MSPress. It's a good introduction to remoting and covers lots of intermediate and some advanced techniques and topics.

Re: Networking Question

Spiros10-Dec-03 12:44

Spiros

10-Dec-03 12:44

Thank you for your help.

After some research I found the following:
--
Let's assume you have two Windows Forms applications, running on a single machine and you want the two applications to be able to communicate with each other. Or suppose you have a Windows service which should exchange data with your GUI application. Which protocol can you use? Remoting!

This is one of the cases where the TCPChannel is extremely helpful as it allows you to specify rejectRemoteRequests="true" upon its construction which limits all incoming connections to the ones originating from your own machine. No need to take too many precautions about security in this case.

However: If you use fixed port numbers for WinForms to WinForms communication, you might run into troubles when running on Windows Terminal Services with two or more users trying to use your application at the same time
--

Unfortunately this is my case.

Spiros Prantalos
Miami the place to be!!

Re: Networking Question

Heath Stewart10-Dec-03 13:02

Heath Stewart

10-Dec-03 13:02

Okay, sorry, didn't understand quite what you were asking in the first post.

You could have a remoting object that merely keeps track of which ports are currently being used by a pair of applications, and perhaps even hands out ports to use. Of course, you'd have to configure the remote objects yourself, but this isn't a difficult thing (just more difficult to change since you have to recompile for some things).

If security is an issue, you could assign each user a key (if you have ActiveDirectory with Certificate Services installed and setup, just use the user's key) to communicate between application domains. If you configure the apps to use the same port, of course only the first user would be able to run it.

Finally, if you use a client-server type setup, you could use single call well-known objects so that multiple users don't interact with each other's sessions.

Just a couple of thoughts.

on is asctive or not ... how to find out if caplock is active or not

datainjector10-Dec-03 8:32

datainjector

10-Dec-03 8:32

Hi i am inetrested in finding out if the caplock button is active or not ... Thats when the form loads... or if there is a way to like toggle the button to disable when it loads ...

Thanks
DaIn

Re: on is asctive or not ... how to find out if caplock is active or not

Heath Stewart10-Dec-03 9:58

Heath Stewart

10-Dec-03 9:58

P/Invoke the native function GetKeyState:

[DllImport("user32.dll")]
private static extern short GetKeyState(int virtKey);

You would then pass 20 (VK_CAPITAL) to get the CAPS LOCK key state. Fortunately (for good reason), the System.Windows.Forms.Keys enumeration members match up with the virtual key constants defined in winuser.h, so you can use (int)Keys.CapsLock instead for more readable code:

short value = GetKeyState((int)Keys.CapsLock);
bool on = (value & 0x0001) != 0;
myButton.Enabled = !on;

It's important to mask out the high-order bit so you can check the status of the low-order bit. This is documented in the Platform SDK documentation for the GetKeyState, see so that for more information.

Stream Socket + SSL Class

Adrian Hall10-Dec-03 6:08

Adrian Hall

10-Dec-03 6:08

Before I go re-inventing the wheel, can anyone tell me if they have an SSL Stream Socket class? I already use TCP based cleartext socket communications to a server and want to enable SSL support for the same protocol going through an SSL proxy.

Re: Stream Socket + SSL Class

Anonymous10-Dec-03 7:29

Anonymous

10-Dec-03 7:29

Mentalis.org (http://www.mentalis.org/soft/projects/seclib/) has a SSL Socket Class Library. It implements a SSL version of the Socket, NetworkStream, TcpClient, and TcpListener classes.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.