Click here to Skip to main content
12,300,021 members (59,270 online)
   

C#

 
GeneralRe: Decrypt E-Mail address Pin
Mathlab20-Nov-12 8:55
memberMathlab20-Nov-12 8:55 
GeneralRe: Decrypt E-Mail address Pin
Mathlab20-Nov-12 8:14
memberMathlab20-Nov-12 8:14 
GeneralRe: Decrypt E-Mail address Pin
Dave Kreskowiak20-Nov-12 8:16
mvpDave Kreskowiak20-Nov-12 8:16 
GeneralRe: Decrypt E-Mail address Pin
Mathlab20-Nov-12 8:19
memberMathlab20-Nov-12 8:19 
AnswerRe: Decrypt E-Mail address Pin
harold aptroot19-Nov-12 22:53
memberharold aptroot19-Nov-12 22:53 
QuestionGet data back from windows process Pin
tdcmystere19-Nov-12 2:42
membertdcmystere19-Nov-12 2:42 
AnswerRe: Get data back from windows process Pin
Eddy Vluggen19-Nov-12 3:10
memberEddy Vluggen19-Nov-12 3:10 
GeneralRe: Get data back from windows process Pin
tdcmystere19-Nov-12 3:19
membertdcmystere19-Nov-12 3:19 
GeneralRe: Get data back from windows process Pin
Eddy Vluggen19-Nov-12 3:42
memberEddy Vluggen19-Nov-12 3:42 
GeneralRe: Get data back from windows process Pin
tdcmystere19-Nov-12 4:17
membertdcmystere19-Nov-12 4:17 
AnswerRe: Get data back from windows process Pin
Eddy Vluggen19-Nov-12 4:37
memberEddy Vluggen19-Nov-12 4:37 
GeneralRe: Get data back from windows process Pin
tdcmystere19-Nov-12 5:21
membertdcmystere19-Nov-12 5:21 
SuggestionRe: Get data back from windows process Pin
Eddy Vluggen19-Nov-12 5:25
memberEddy Vluggen19-Nov-12 5:25 
QuestionC# 2010 Express - SQL Server 2008 Express connection "Login failed" Pin
bneveux18-Nov-12 23:39
memberbneveux18-Nov-12 23:39 
I am really new to C# .NET and SQL Server, I usually manage to find all my informations thanks to existing posts, but I have to admit I'm actually stuck and a bit lost with all the resources available.

I am actually developing a Windows Forms Application with Visual C# Express 2010 which would use (read/write) data from a SQL Server 2008 Express DB

I have created my DB with SQL Server Management Studio (2008 Express), I understand the instance is named ATLELAG786576\SQLEXPRESS My DB is called 'TEST'

Looking at my DB 'TEST' Properties in SQL Server Management Studio (2008 Express): Under Files, I am (ATLE\bneveux) the owner of the DB

Looking under Security, Logins, Mylogin (ATLE\bneveux) My default DB is 'TEST' Server roles are 'public' + 'sysadmin' User Mapping DB 'TEST' User 'dbo' Default Schema 'dbo'

In my C# application

app.config:
<?xml version="1.0" encoding="utf-8" ?> <configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add name="connectionStringTestDb"
            connectionString="Data Source=ATLELAG786576\SQLEXPRESS;Initial Catalog=D:\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\TEST.mdf;Integrated Security=True;Connect Timeout=30;User Instance=False"
            providerName="System.Data.SqlClient" />
    </connectionStrings> </configuration>

dbConnection.cs:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace SQLServerConnectionDemo
{
    class dbConnection
    {
        public static SqlConnection newCon;
        public static string connectionStringTestDb = ConfigurationManager.ConnectionStrings["connectionStringTestDb"].ConnectionString;
        public static SqlConnection GetConnection()
        {
            newCon = new SqlConnection(connectionStringTestDb);
            return newCon;
        }
    }
}
dbAccess.cs:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace SQLServerConnectionDemo
{
    class dbAccess
    {
        SqlConnection conn;
        public dbAccess()
        {
            conn = dbConnection.GetConnection();
        }
        //Method insert new in tblEmployees
        public void addEmployee(string Id, string Name, string Email)
        {
            if (conn.State.ToString() == "Closed")
            {
                conn.Open();
            }
            SqlCommand newCmd = conn.CreateCommand();
            newCmd.Connection = conn;
            newCmd.CommandType = CommandType.Text;
            newCmd.CommandText = "INSERT INTO tblEmployees VALUES ('"+ Id +"','"+ Name +"','"+ Email +"')";
            newCmd.ExecuteNonQuery();
        }
    }
}

in a form formEmployeeAdd.cs:
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;
namespace SQLServerConnectionDemo
{
    public partial class formEmployeeAdd : Form
    {
        dbAccess access = new dbAccess();
        public formEmployeeAdd()
        {
            InitializeComponent();
        }
        private void btnInsert_Click(object sender, EventArgs e)
        {
            access.addEmployee(txtId.Text, txtName.Text, txtEmail.Text);
            MessageBox.Show("Data successfully added");
        }
    }
}

And here the error message i always get when trying to run this process:
System.Data.SqlClient.SqlException (0x80131904): Cannot open database "D:\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\TEST.mdf" requested by the login. The login failed. Login failed for user 'ATLE\bneveux'.

Note that I have never really been able to add my Data Source in Visual C# 2010 Express so I could manage the DB from VS, I always get the following error message:
Unable to open the physical file "D:\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\TEST.mdf". Operating system error 32: "32(Le processus ne peut pas accéder au fichier car ce fichier est utilisé par un autre processus.)". An attempt to attach an auto-named database for file D:\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\TEST.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Thank you for your expertise

Brice
AnswerRe: C# 2010 Express - SQL Server 2008 Express connection "Login failed" Pin
bneveux19-Nov-12 0:04
memberbneveux19-Nov-12 0:04 
QuestionWrite and read a paragraph in XML format string ? Pin
taibc18-Nov-12 16:29
membertaibc18-Nov-12 16:29 
AnswerRe: Write and read a paragraph in XML format string ? Pin
n.podbielski18-Nov-12 20:07
membern.podbielski18-Nov-12 20:07 
GeneralRe: Write and read a paragraph in XML format string ? Pin
taibc18-Nov-12 20:21
membertaibc18-Nov-12 20:21 
GeneralRe: Write and read a paragraph in XML format string ? Pin
n.podbielski18-Nov-12 21:06
membern.podbielski18-Nov-12 21:06 
GeneralRe: Write and read a paragraph in XML format string ? Pin
taibc18-Nov-12 21:10
membertaibc18-Nov-12 21:10 
GeneralRe: Write and read a paragraph in XML format string ? Pin
n.podbielski18-Nov-12 21:19
membern.podbielski18-Nov-12 21:19 
GeneralRe: Write and read a paragraph in XML format string ? Pin
taibc18-Nov-12 21:28
membertaibc18-Nov-12 21:28 
GeneralRe: Write and read a paragraph in XML format string ? Pin
n.podbielski18-Nov-12 21:34
membern.podbielski18-Nov-12 21:34 
GeneralRe: Write and read a paragraph in XML format string ? Pin
taibc18-Nov-12 21:36
membertaibc18-Nov-12 21:36 
AnswerRe: Write and read a paragraph in XML format string ? Pin
PIEBALDconsult20-Nov-12 4:18
memberPIEBALDconsult20-Nov-12 4:18 
GeneralRe: Write and read a paragraph in XML format string ? Pin
n.podbielski20-Nov-12 5:44
membern.podbielski20-Nov-12 5:44 
GeneralRe: Write and read a paragraph in XML format string ? Pin
PIEBALDconsult20-Nov-12 6:29
memberPIEBALDconsult20-Nov-12 6:29 
GeneralRe: Write and read a paragraph in XML format string ? Pin
n.podbielski20-Nov-12 7:43
membern.podbielski20-Nov-12 7:43 
GeneralRe: Write and read a paragraph in XML format string ? Pin
PIEBALDconsult20-Nov-12 10:45
memberPIEBALDconsult20-Nov-12 10:45 
GeneralRe: Write and read a paragraph in XML format string ? Pin
n.podbielski20-Nov-12 11:03
membern.podbielski20-Nov-12 11:03 
GeneralRe: Write and read a paragraph in XML format string ? Pin
PIEBALDconsult20-Nov-12 13:45
memberPIEBALDconsult20-Nov-12 13:45 
GeneralRe: Write and read a paragraph in XML format string ? Pin
taibc20-Nov-12 14:30
membertaibc20-Nov-12 14:30 
GeneralRe: Write and read a paragraph in XML format string ? Pin
PIEBALDconsult20-Nov-12 17:08
memberPIEBALDconsult20-Nov-12 17:08 
GeneralRe: Write and read a paragraph in XML format string ? Pin
taibc20-Nov-12 17:33
membertaibc20-Nov-12 17:33 
GeneralRe: Write and read a paragraph in XML format string ? Pin
PIEBALDconsult20-Nov-12 18:08
memberPIEBALDconsult20-Nov-12 18:08 
Question[Help] C# .txt Pin
mumbot18-Nov-12 14:03
membermumbot18-Nov-12 14:03 
AnswerRe: [Help] C# .txt Pin
Rags151218-Nov-12 18:30
memberRags151218-Nov-12 18:30 
GeneralRe: [Help] C# .txt Pin
mumbot18-Nov-12 19:43
membermumbot18-Nov-12 19:43 
GeneralRe: [Help] C# .txt Pin
V.19-Nov-12 0:37
memberV.19-Nov-12 0:37 
GeneralRe: [Help] C# .txt Pin
PIEBALDconsult23-Nov-12 9:46
memberPIEBALDconsult23-Nov-12 9:46 
AnswerRe: [Help] C# .txt Pin
omisheikh18-Nov-12 21:04
memberomisheikh18-Nov-12 21:04 
GeneralRe: [Help] C# .txt Pin
mumbot18-Nov-12 21:13
membermumbot18-Nov-12 21:13 
GeneralRe: [Help] C# .txt Pin
omisheikh18-Nov-12 21:19
memberomisheikh18-Nov-12 21:19 
GeneralRe: [Help] C# .txt Pin
mumbot18-Nov-12 21:31
membermumbot18-Nov-12 21:31 
GeneralRe: [Help] C# .txt Pin
omisheikh18-Nov-12 21:40
memberomisheikh18-Nov-12 21:40 
GeneralRe: [Help] C# .txt Pin
mumbot18-Nov-12 22:15
membermumbot18-Nov-12 22:15 
GeneralRe: [Help] C# .txt Pin
Zac Greve18-Nov-12 22:32
memberZac Greve18-Nov-12 22:32 
GeneralRe: [Help] C# .txt Pin
omisheikh18-Nov-12 22:34
memberomisheikh18-Nov-12 22:34 
GeneralRe: [Help] C# .txt Pin
mumbot19-Nov-12 0:02
membermumbot19-Nov-12 0:02 
AnswerRe: [Help] C# .txt Pin
Mathlab19-Nov-12 7:54
memberMathlab19-Nov-12 7:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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


Advertise | Privacy | Mobile
Web02 | 2.8.160525.2 | Last Updated 29 May 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid