How to Access a Database using SQL

Question

0.00/5 (No votes)

See more:

Hello everybody, I am new to the database access so please forgive me for these question and if the seem basic.
I have been following some examples how to access a database using the sql commands.
However I do not quite understand firstly how to create a database "FreezerTemps", and what information I am required to add in the SqlConnection in order to get access to it.

I create the database using the Microsoft Visual C# 2010 Express, this is located in the directory of the code itself. I believe the Microsoft SQL Server 2008 is running as well but did not change anything there, as I am very new to this concept.

I attach the code I am using below.

Thank you for reading my question and code.

Kind regards,
Stelios.

C#

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 WebDatabase
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {

            SqlConnection cs = new SqlConnection("Data Source=nemesisfc; Initial Catalog=FreezerTemps; Integrated Security=TRUE");
            cs.Open();
            MessageBox.Show(cs.State.ToString());
            cs.Close();


         }
    }
}

Posted 7-Apr-11 16:38pm

Member 7808930

Add a Solution

3 solutions

Solution 1

C#

SqlConnection cs = new SqlConnection("Data Source=servername; Initial Catalog=databasename; Integrated Security=TRUE");
            cs.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "write ur sql query here";
            cmd.ExecuteNonQuery();// for inser/delete/update
            cs.Close();
            //-------------------------------------------------

            SqlConnection cs1 = new SqlConnection("Data Source=nemesisfc; Initial Catalog=FreezerTemps; Integrated Security=TRUE");
            SqlCommand cmd1 = new SqlCommand();
            cs1.Open();
            cmd1.CommandText = "write ur sql select query here";
            DataSet dtst = new DataSet();
            SqlDataAdapter dp = new SqlDataAdapter(cmd1);
            dp.Fill(dtst);// for select query

            cs1.Close();

[edit]code wrapped in pre tags[/edit]

Posted 7-Apr-11 17:59pm

anvas kuttan

Updated 7-Apr-11 18:54pm

v2

Solution 3

Hi,

I understood that you have questions about SQL Server itself and how to create a database in it. For a small tutorial, have a look at this site: http://www.quackit.com/sql_server/sql_server_2008/tutorial/[^]

And to manage Sql Server this one is a 'must' download: Microsoft® SQL Server® 2008 Management Studio Express [^]

As already suggested you can use also server explorer to see the connection string to use in the application. Also one good source for connection strings is: http://www.connectionstrings.com/[^]

And for using ADO.NET, have a look at these documents: http://msdn.microsoft.com/en-us/library/kb9s9ks0.aspx[^]

Posted 7-Apr-11 18:52pm

Wendelius

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Uday Kumar B R · Accepted Answer · 2011-04-07T18:15:00

Solution 2

Follow the steps...
1.Click on Server Explorer on right side
2.Right click on you database file *.mdf and click on properties
3.Right side of your IDE properties of *.mdf will be available Copy the Connection string and paste it on your SQL Connection() as shown

SqlConnection cs1 = new SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Users\bruda\Documents\Visual Studio 2008\WebSites\sqldemo\App_Data\Database.mdf";Integrated Security=True;User Instance=True");

This is the solution for your question Do not forget to mark it as answer If possible rate this answer

Thank you :-)

Posted 7-Apr-11 18:15pm

Uday Kumar B R

Comments

Member 7808930 8-Apr-11 5:55am

Thank you Uday,
I have tried your method
As suggested I did the following

1. For my version Database Explorer
2. Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\nemesis\Desktop\WebDatabase\WebDatabase\Database1.mdf;Integrated Security=True;User Instance=True
3. SqlConnection cs = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Users\\nemesis\\Desktop\\WebDatabase\\WebDatabase\\Database1.mdf;Integrated Security=True;User Instance=True");

And the server opens the database, I will try to write to it later this evening.
Thank you so much for you time and effort.

I will try the other methods and suggestions as well.

Thank you.
Stelios