C# SQL Connection class

yeah MessageBox.Show would work... where would the code go ?

I am creating a new thread :D thanks man <3

Your code used a console so I assumed it is a console program. You cannot use a console in a Windows Forms application, or at least it is too advanced to do. So the simple answer to the question of where to put a message such as "CONNECTED" is to put it into a text box. If you want a lengthier answer then it will be better to create a new thread for that.

Ok, I think I am connected to the database :D

Thanks man !!!! now, I added a datagrid1 to my form...

How do I execute this querry to display in the datagrid 1 ??

select * from pinfo(table name)

how do I display that in datagrid 1 ?? 

Ooops, I forgot one thing.

You can use Settings, also called application Properties, to make things easier. A console application does not have a Settings.Settings file unless you create one. Go to the Solutions Explorer and look for a Properties node. If you open the Properties node then you will probably only see an AssemblyInfo.cs file there. So right-click on the project and click on Properties. Those properties are for the project, not the application. Confusing? Yes, very. So after clicking on the Properties in the context menu, you will get a big box showing project properties. In the left side will be tabs; click on the Settings tabs. You will get a table with columns for Name, Type, Scope and Value. For the name, use ConnectionStringSetting. In the dropdown box for Type, select "(ConnectionString)". The Scope will automatically be set to Application. Click in the Value column for the row and then in the far right there will be an ellipsis thing ("...") shown.

I hope you have been able to follow me so far. If you have, you will get a form for interactively creating a connection string. If you create the connection string that way then the code I showed above will use the connection string.

Ok, this is how the class you gave me ended up

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;


namespace Database2
{
    class DBC
    {
       
       
        SqlConnection myConnection;
   
        public DBC()
        {
            try
            {
                myConnection = new SqlConnection("user id=sa;" +
                                               "password=t12457859;server=98.118.57.8;" +
                                               "Trusted_Connection=yes;" +
                                               "database=Account; " +
                                               "connection timeout=30");
            }
            catch (Exception ex)
            {
                throw new ApplicationException("SQL Connection creation failed", ex);
            }
            try
            {
                myConnection.Open();
            }
            catch (Exception ex)
            {
                throw new ApplicationException("SQL Open failed", ex);
            }
        }


        public void Close()
        {
            myConnection.Close();
        }


        internal string State()
        {
            return myConnection.State.ToString();
        }
   
    }


}


is that valid ? ...


and this is my connect button

 public void button1_Click(object sender, EventArgs e)
        {
           
            DBC db;
           
            try
            {
                db = new DBC();
            }
            catch (Exception ex)
            {
               Console.WriteLine("Error: {0}", ex);
                return;
            }
            Console.WriteLine("State: {0}", db.State());
            db.Close();
       
           
        }


Where would I put the code to set a label as CONNECTED if it worked ??

I would use label1.Text = "CONNECTED !!"; where would I put it ?

AHHH !!! also, since you put console.writeline, maybe this is the right time to ask... How do I put a console inside my form ??? so I can have something like a DEBUG WINDOW kind of thing.. it'd be lovely to have a console INSIDE the form. if possible. But I am not too worryed about having a console inside my form at the moment. 


<3 <3 thanks alot man

Thanks for the reply man !!!

I got the following error:

Error1'Database2.Properties.Settings' does not contain a definition for 'ConnectionStringSetting' and no extension method 'ConnectionStringSetting' accepting a first argument of type 'Database2.Properties.Settings' could be found (are you missing a using directive or an assembly reference?)c:\users\ultrax\documents\visual studio 2010\Projects\Database2\Database2\DBC.cs1778Database2


Also, I am doing a form application with a datagrid. 

I had trouble reading the code you gave, I wouldn't find a section for me to put my credentials, ... maybe the Database2.Properties.Settings has it ? how do I access that so I can instert the credentials? Also, how do I keep the credentials on the code... ??

I am trying to use as much code as possible, and as little settings as possible so I can get used to typing it.

Thanks a lot man !!

I really need help I am stuck..

by the way, my database is up (mssql 2008 enterprize) that's what I am trying to connect to. It has a database called Account, and it has 3 colums, Fname, Lname, age
which I am using for testing... I was able to connect used the "add datasource wizzard" but, I really want to stay away from that, I want the code to do it all :D


Once again thanks.. :D

Ok cool... This is what I did...

I created a class called DBC
the file is DBC.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;


namespace Database2
{
    class DBC
    {


        SqlConnection myConnection = new SqlConnection("user id=sa;" +
                                           "password=t124578r4rt7;server=98.118.57.8;" +
                                           "Trusted_Connection=yes;" +
                                           "database=Account; " +
                                           "connection timeout=30");
   
   
    }
}


then, on my other section (the main form) this is how I did the Button1, which is the connect button:



try { myConnection.Open(); } catch(Exception e) { Console.WriteLine(e.ToString()); }

But I got an error... I do not thing the code above is being able to access the class, how do I do it ??? :'( ...

ERROR 1



Thanks guys

Wow, thanks guys, thanks for the code sample <3, thank you for the link ...

Thank you so much guys. I will see what I can stablish ! thanks tons

There are many very useful classes in .Net and in many articles in this web site. My article Database Table Update in a DataGridView without Writing Code is one of very many. Spend some time familiarizing yourself with the vast resources of this web site.

Here are few code samples to get you going :

Establish the connection with SQL