sql.cs

来自「This program is compare the data in sql 」· CS 代码 · 共 32 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;


namespace SQLDataCompare
{
    class sql
    {
        public DataTable sqlsorgu(string sorgu,string constr)
        {

            DataTable dt = new DataTable();
            try
            {
                SqlConnection con = new SqlConnection();
                con.ConnectionString = constr;
                con.Open();
                SqlCommand cmd = new SqlCommand(sorgu, con);

                SqlDataReader dr = cmd.ExecuteReader();
                dt.Load(dr);
                dr.Close();
                con.Close();
            }
            catch
            {
                return dt;
                //richTextBox2.Text += DateTime.Now.ToString() + "  --> Have some problems.(I am sorry Bunu denememi