将SQL数据库连接到c#

本文关键字:数据库连接 SQL | 更新日期: 2023-09-27 18:16:37

我有一个小问题与SQL,它说"公共Form1();在代码的最顶部,根据我所遵循的初学者指南,应该有一个带有3个点的小框(就像这样[…]),而不是";"

public Form1();
        System.Data.SqlClient.SqlConnection con;
        private void Form1_Load(object sender, EventArgs e)
        {
            con = new System.Data.SqlClient.SqlConnection();
            con.ConnectionString="Data Source=.''SQLEXPRESS;AttachDbFilename=C:''Users''Wee                                                                    Jimmy''Documents''MyWorkers.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
            con.Open();
            MessageBox.Show("Open");
            con.Close();
            MessageBox.Show("Closed");
谁来帮帮我,我已经准备认输了。错误提示:错误1 'SQL_Connection.Form1.Form1()'必须声明一个主体,因为它没有标记为抽象、extern或部分c:'用户' Jimmy'Documents'Visual Studio 2010'Projects'SQL Connection'SQL Connection'Form1.cs 15 16 SQL Connection

将SQL数据库连接到c#

改变第一行:

public Form1();

:

public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
    }
}

试试这个——

public Form1()
{
    System.Data.SqlClient.SqlConnection con; 
    private void Form1_Load(object sender, EventArgs e) 
    { 
        con = new System.Data.SqlClient.SqlConnection(); 
        con.ConnectionString="Data Source=.''SQLEXPRESS;AttachDbFilename=C:''Users''Wee Jimmy''Documents''MyWorkers.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; 
        con.Open(); 
        MessageBox.Show("Open"); 
        con.Close(); 
        MessageBox.Show("Closed"); 
    }
}