Writing sqlhelper class example

高洛峰
Release: 2023-03-04 19:56:02
Original
1281 people have browsed it

Write SqlHelper yourself, please use it as a reference

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data; using System.Data.SqlClient;

namespace SqlHelper
{
    /// <summary>
    /// Window1.xaml 的交互逻辑
    /// </summary>
    public partial class Window1 : Window
    {
        public Window1()
        {
            InitializeComponent();
        }

        //只用来执行查询结果比较少的sql
        private void btnds_Click(object sender, RoutedEventArgs e)
        {
            SqlHelper.ExecuteNonQurey("insert into T_Student(Name,Age) values(&#39;张三&#39;,55)",
                new SqlParameter[0]);
            MessageBox.Show("添加成功");
        }

        private void btnDataSet_Click(object sender, RoutedEventArgs e)
        {
            DataSet ds= SqlHelper.ExecuteDataSet("select * from T_Student where hobbit=&#39;@hobbit&#39;",
                new SqlParameter[]{new SqlParameter("&#39;@hobbit&#39;","哈哈哈")});
            foreach(DataRow row in ds.Tables[0].Rows)
            {
                string name = (string)row["Name"];
                MessageBox.Show(name);
            }
        }
    }
}
Copy after login

For more articles related to writing sqlhelper class examples, please pay attention to the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!