首先先建立连接还有登录名和密码。。
代码:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using System.Data.Sql;
namespace WindowsFormsApplication3
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
String strconn = "Data Source = wwh; Initial Catalog = myDatalog = myDatabase; uid = sa; pwd = sa";
SqlConnection conn = new SqlConnection(strconn);
try {
int i1, i2;
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "update BaseInfofrom set[name] = 'myName' where[No] = 3";
i1 = cmd.ExecuteNonQuery();
cmd.CommandText = "delete from BaseInfrom where No = 2";
i2 = cmd.ExecuteNonQuery();
MessageBox.Show("1");
MessageBox.Show("更改后有: " + i2.ToString() + "行数据改变受到影响\n" + "删除后有:" + i2.ToString() + "行数据受到影响!\n");
conn.Close();
}catch(Exception ex)
{
MessageBox.Show(ex.Message.ToString() + "打开数据库失败!");
}
}
}
}