SQLServer 增添,查询,删除,修改

    #region 查询
    string sql = "select * from Firstable;";
    DataTable data = DataSelet(sql);
    for (int i = 0; i < data.Rows.Count; i++)
    {
        Console.WriteLine($"{data.Rows[i]["UserName"]},{data.Rows[i]["PassWord"]},{data.Rows[i]["NickName"]}");
    }
    #endregion

    #region 删除
    string sqld = "delete from Firstable where UserName='55';";
    int count = EidtData(sqld);
    if (count > 0)
    {
        Console.WriteLine($"删除成功,删除{count}条数据");
    }
    else
    {
        Console.WriteLine("失败");
    }
    #endregion

    #region 增添
    string add = "insert into Firstable(UserName,PassWord,NickName)values('566','656565','张三');";
    int count = EidtData(add);
    if(count>0)
    {
        Console.WriteLine($"增添成功,增添{count}条数据");
    }
    else
    {
        Console.WriteLine("失败");
    }
    #endregion

    #region 修改
    string add = "update Firstable set UserName='555' where UserName='566';";
    int count = EidtData(add);
    if (count > 0)
    {
        Console.WriteLine($"修改成功,修改{count}条数据");
    }
    else
    {
        Console.WriteLine("失败");
    }
    #endregion

}
public  static DataTable DataSelet(string sql)
{
    SqlConnection con = new SqlConnection();
    con.ConnectionString = "Server=DESKTOP-N7C4QO5\\SQLEXPRESS;Database=Table;Trusted_Connection=true;";
    con.Open();
    SqlCommand cmd = con.CreateCommand();
    cmd.Connection = con;
    cmd.CommandText = sql;
    SqlDataAdapter dataAdapter = new SqlDataAdapter();
    dataAdapter.SelectCommand = cmd;
    DataSet set = new DataSet();
    dataAdapter.Fill(set);
    con.Close();
    DataTable dt =set.Tables[0];
    return dt;
}
public static int EidtData(string sql)
{
    int count = 0;
    SqlConnection con = new SqlConnection();
    con.ConnectionString = "Server=DESKTOP-N7C4QO5\\SQLEXPRESS;Database=Table;Trusted_Connection=true;";
    con.Open();
    SqlCommand cmd = new SqlCommand(sql,con);
    try
    {
        count = cmd.ExecuteNonQuery();
    }
    catch (Exception ex)
    {
        Console.WriteLine(ex);
    }
    con.Close();   
    return count;
}