thiago costa

thiago costa

  • NA
  • 319
  • 0

How to execute a QUERY from BUTTON and DISPLAY results? I have a PICTURE example

Sep 25 2009 10:08 AM
I am so sorry, I am new here and I do not know how to move a post, I posted this in the c++ section by accident, I am so sorry, I need it in C# . Thank you.
------------------------------------------------------------------------------------------------------
Hello there, I am new here, and Thank you for taking the time to read this and hopefully I can get helped :) ... I will cross my fingers.

Please CLICK HERE to see what I have planned. then you will be able to understand the question. =D ... I want to make it simple to understand, don't want to make any body think toomuch. I feel bad.

I want to execute the QUERY below, by clicking on button1, and displaying result on Result Window. (I havent found out which result window would be more propper... DataGrid?)

-------------
USE [account];
GO
select * from user_profile where login_flag = 1100
----- OR -----
USE [cash];
UPDATE user_cash
SET amount=0
WHERE amount=294765
-------------

I want to, for example, click on BUTTON1 and execute the above query, and then show the results of the query in the RESULT window...

This is what is going on:
I have a SQL 2000 database, and I want that software to be able to:

Connect to my database thru IP, execute ANY queries and display results in RESULT WINDOW.
... I don't know, If i learn that, I think that would make me understand everything else easyer. I have no idea what I am doing, all I know how to do is ,

Click on NEW,PROJECT,C# Form Application. ><'' ... I wasnt able to go farther.

Answers (6)