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 db_conn
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void seBtn_Click(object sender, EventArgs e)
{
string sql = "select * from list";
//访问MySql数据库服务器所需要的登录信息:根据具体情况来定
string serverIP = "192.168.4.152";//服务器的IP地址
string userID = "sa";//访问数据库服务的用户名
string password = "Abc123";//用户密码
string dataBaseName = "info";//要访问的数据库名称
SqlConnection sqlConn = new SqlConnection();
sqlConn.ConnectionString = "Data Source="+serverIP+";User ID="+userID+";Password="+password+";Initial Catalog="+dataBaseName;
sqlConn.Open();
SqlDataAdapter dat = new SqlDataAdapter(sql, sqlConn);
DataSet ds = new DataSet();
dat.Fill(ds);
seBtn.Text = ds.Tables[0].Rows[1][1].ToString();
sqlConn.Close();
}
}
}
C#连接SQL SERVER数据库
最新推荐文章于 2024-04-22 14:41:20 发布