在Winform應(yīng)用程序中連接SQL數(shù)據(jù)庫(kù),通??梢允褂靡韵虏襟E:
以下是一個(gè)示例代碼,演示如何在Winform應(yīng)用程序中連接SQL數(shù)據(jù)庫(kù):
using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
namespace WinformApp
{
public partial class Form1 : Form
{
private SqlConnection sqlConnection;
public Form1()
{
InitializeComponent();
InitializeSqlConnection();
}
private void InitializeSqlConnection()
{
string connectionString = "Data Source=YourServerAddress;Initial Catalog=YourDatabaseName;User ID=YourUsername;Password=YourPassword";
sqlConnection = new SqlConnection(connectionString);
try
{
sqlConnection.Open();
MessageBox.Show("Connection successful");
}
catch (Exception ex)
{
MessageBox.Show("Connection failed: " + ex.Message);
}
}
private void ExecuteQuery()
{
string query = "SELECT * FROM YourTableName";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
SqlDataAdapter dataAdapter = new SqlDataAdapter(sqlCommand);
DataTable dataTable = new DataTable();
dataAdapter.Fill(dataTable);
// Display query result in a DataGridView
dataGridView1.DataSource = dataTable;
}
private void button1_Click(object sender, EventArgs e)
{
ExecuteQuery();
}
}
}
在上面的示例代碼中,我們首先創(chuàng)建一個(gè)SqlConnection對(duì)象并打開(kāi)數(shù)據(jù)庫(kù)連接。然后定義了一個(gè)執(zhí)行查詢(xún)的方法ExecuteQuery(),該方法中執(zhí)行了一個(gè)簡(jiǎn)單的SELECT查詢(xún)語(yǔ)句,并將結(jié)果顯示在一個(gè)DataGridView中。最后,通過(guò)按鈕的Click事件調(diào)用ExecuteQuery()方法來(lái)執(zhí)行查詢(xún)操作。