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

Question

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.

Roei Bar · Answer

you can also use sharpdevelop http://www.icsharpcode.net/OpenSource/SD/ its an Open Source C# Development UI, which has almost all features like Visual Studio and capble of running Visual Studio Projects

thiago costa · Answer

I can't do this :( some one please help me :( I didnt know it would be so hard to execute a query and display result into DATAGRID or LISTBOX :( I am literally crying... Please help me, I will send paypal money for any classes if anyone is interested in being my personal teacher =D ... I am poor but I can pay EDIT ... Problem Solved. FORM ing System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using DatabaseExec; namespace WindowsFormsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); SQLDataAccess.ServerName = "SERVER IP"; SQLDataAccess.UserName = "dklogin2"; } private void buttonLogin_Click(object sender, EventArgs e) { string password = textBoxPassword.Text; if (SQLDataAccess.ValidateConnection("Account", password) == true) { SQLDataAccess.Password = password; MessageBox.Show("Login Successful"); textBoxPassword.Text = ""; textBoxPassword.UseSystemPasswordChar = false; } else { MessageBox.Show("Login failed"); } } private void buttonExecute_Click(object sender, EventArgs e) { SQLDataAccess dataAccess = new SQLDataAccess(); dataAccess.Select("Account", "SELECT user_no, login_flag from USER_PROFILE WHERE login_flag=1100"); dataGridView1.DataSource = dataAccess.Data; labelCountRows.Text = dataAccess.Data.Rows.Count.ToString() + " rows returned"; } private void buttonBanUser_Click(object sender, EventArgs e) { DataTable dt = SQLDataAccess.Execute("Character", "SELECT user_no from user_character WHERE character_name='"+textBoxPassword.Text+"'"); if(dt.Rows.Count == 0) { MessageBox.Show("Character not found"); return; } string user_no = dt.Rows[0]["user_no"].ToString(); SQLDataAccess.ExecuteNoReturn("Account", "Update USER_PROFILE SET login_flag = 1200 WHERE user_no='" + user_no + "'"); //DataTable dt1 = SQLDataAccess.Execute("Account", "Update USER_PROFILE SET login_flag = 1200 WHERE user_no='" + user_no + "'
SELECT @@ROWCOUNT"); //if (dt1.Rows.Count == 0) //{ // MessageBox.Show("Account for the Character not found"); // return; //} //SQLDataAccess.Execute("Account", String.Format("Update USER_PROFILE SET login_flag = 1200 WHERE user_no='{0}'", user_no)); } private void Form1_Load(object sender, EventArgs e) { } } } SQLdataacess: using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; namespace DatabaseExec { public class SQLDataAccess { public static string ServerName; public static string UserName; public static string Password; public DataTable Data; private DataSet DsData; private SqlDataAdapter mDataAdapter; private SqlCommandBuilder mCmdBuilder; public void Select(string databaseName, string cmdToExecute) { DsData = new DataSet(); SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.DataSource = SQLDataAccess.ServerName; builder.InitialCatalog = databaseName; builder.UserID = SQLDataAccess.UserName; builder.Password = SQLDataAccess.Password; mDataAdapter = new SqlDataAdapter(); mDataAdapter.SelectCommand = new SqlCommand(cmdToExecute, new SqlConnection(builder.ConnectionString)); mCmdBuilder = new SqlCommandBuilder(mDataAdapter); mDataAdapter.Fill(DsData); Data = DsData.Tables[0]; } public void SaveChanges() { mDataAdapter.Update(Data); } public static DataTable Execute(string databaseName, string cmdToExecute) { DataSet ds = new DataSet(); SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.DataSource = SQLDataAccess.ServerName; builder.InitialCatalog = databaseName; builder.UserID = SQLDataAccess.UserName; builder.Password = SQLDataAccess.Password; using(SqlDataAdapter da = new SqlDataAdapter(cmdToExecute, new SqlConnection(builder.ConnectionString))) { da.Fill(ds); } return ds.Tables[0]; } public static void ExecuteNoReturn(string databaseName, string cmdToExecute) { SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.DataSource = SQLDataAccess.ServerName; builder.InitialCatalog = databaseName; builder.UserID = SQLDataAccess.UserName; builder.Password = SQLDataAccess.Password; using (SqlConnection conn = new SqlConnection(builder.ConnectionString)) { using (SqlCommand cmd = new SqlCommand(cmdToExecute, conn)) { conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } } } public static bool ValidateConnection(string databaseName, string password) { SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.DataSource = SQLDataAccess.ServerName; builder.InitialCatalog = databaseName; builder.UserID = SQLDataAccess.UserName; builder.Password = password; using (SqlConnection conn = new SqlConnection(builder.ConnectionString)) { try { conn.Open(); } catch (SqlException) { return false; } return true; } } } } Thank is how I made it work with a little help of my Indian friend Vinnoth =D Thank you all SOMUCH . This is so complicated, I will not give up.

thiago costa · Answer

[QUOTE] Hi Thiago, Its a little more complicated than you want... You set up a System.Data.Common.DataAdapter with the SELECT query. You call Fill to get the results of the query into a System.Data.DataTable Then: You set up a DataGridView and set it's DataSource property to the above DataTable Voila... Please mark this post as an answer if it helps you Nir[/quote] So sorry, I am home now, I have the compiler open... when you said to setup System.Data.Common.DataAdapter , what did you mean? I WANT TO CRY :'( ... After researching, i decided that I need to activate a connection before anything works anyways, like... a CONNECT button, then the other buttons can execute the queries ..... This is my program: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsFormsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;database=account;server=IPxx.xxx.57.x;user id=sa;password=flamxxxssdf;Connect Timeout=30"; myConnection.Open(); try { myConnection.Open(); } catch (Exception x) { Console.WriteLine(x.ToString()); } } } } I clicked on BUTTON 1, and I don't know if it is connecting or not ... It did not give me ANY messages at all :( something I did wrong so far?

Nir Bar · Answer

Express edition is more than enough Good luck Please mark this post as an answer if it helps you Nir

thiago costa · Answer

Thank you so so much for the quick reply =D ... I am at work, when I get home today, I will google on how to setup that stuff... Then I will post the results here, Thank you so much... Right now I am using Visual C# EXPRESS ... is it good enough? or will I require visual studio 2008? ... Thank you !!!

Nir Bar · Answer

Hi Thiago, Its a little more complicated than you want... You set up a System.Data.Common.DataAdapter with the SELECT query. You call Fill to get the results of the query into a System.Data.DataTable Then: You set up a DataGridView and set it's DataSource property to the above DataTable Voila... Please mark this post as an answer if it helps you Nir

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

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)