我想用按钮去控制数据库的插入、修改、删除的功能来实现修改数据的目的。

可是用
private void button1_Click(object sender, EventArgs e)
        {
            this.sTableAdapter.Update(this.kCSZDataSet1.S);
            
        }

这段代码无法实现修改的功能。求教如何修改？

新手没什么分..请见谅 谢谢善心的大神们..

在线等待...

唉..就你一个回答的,你提供的这个是一种方法 不过太复杂了..

还是 谢谢你

你的方法很好，我最后用的是LINQ to SQL但是调试时出现数据库连接错误，sa账户已经打开..

我是刚学不到2天

 string url = "data source=.;initial catalog=<数据库名>;user id=sa";

这句话里面的 data source  和  initial catalog 还有和Database   哪一个是连数据库的？

分别都是干什么用的可以说一下吗？谢谢

我新手 说的太简单 我看不懂 我也知道用 insert  update  delete  但是如何用代码实现？
现在的问题是 数据库 连接问题 调试的时候连不上》如图..

现在又遇到了新的问题.执行查找 操作后在表中显示的是空的表。。请问是哪里错了

using System;
using System.Collections.Generic;
using
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace t4
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        string strCon = "Data Source=PC-20120811LXRE\\SQLEXPRESS;Initial Catalog=KCSZ;Persist Security Info=True;User ID=sa;Password=123456789";
        linqtosqlClass linq;
            
        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: 这行代码将数据加载到表“kCSZDataSet.S”中。您可以根据需要移动或删除它。
           this.sTableAdapter.Fill(this.kCSZDataSet.S);
           // BindInfo();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            BindInfo();
        }
        #region  //查询
        private void BindInfo()
        {
            linq = new linqtosqlClass(strCon);
            if (txtKeyWord.Text == "")
            {
                var result = from info in linq.S
                             select new
                             {
                                 学号 = info.ID,
                                 姓名 = info.Name,
                                 性别 = info.Sex
                             };
                dgvInfo.DataSource = result;
            }
            else
            {
                switch (cboxCondition.Text)
                {
                    case "学号":
                        var resultid = from info in linq.S
                                       where info.ID == txtKeyWord.Text
                                       select new
                                       {
                                           学号 = info.ID,
                                           姓名 = info.Name,
                                           性别 = info.Sex
                                       };
                        dgvInfo.DataSource = resultid;
                        break;

                    case "姓名":
                        var resultname = from info in linq.S
                                         where info.Name.Contains(txtKeyWord.Text)
                                         select new
                                         {
                                             学号 = info.ID,
                                             姓名 = info.Name,
                                             性别 = info.Sex
                                         };
                        dgvInfo.DataSource = resultname;
                        break;

                    case "性别":
                        var resultsex = from info in linq.S
                                        where info.Sex == txtKeyWord.Text
                                        select new
                                        {
                                            学号 = info.ID,
                                            姓名 = info.Name,
                                            性别 = info.Sex
                                        };
                        dgvInfo.DataSource = resultsex;
                        break;


                }
            }
        }
        #endregion

        private void button2_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }
    }
}

谢谢  我已经自己解决了  是数据库的问题 。。你的例子很不错 就是我还看不太懂..

谢谢  问题应经全部解决

谢谢  问题已经解决