c#调用 SQL SERVER

来源：互联网发布：windows arm模拟器编辑：程序博客网时间：2024/06/12 00:23
using System;  using System.Collections.Generic;  using System.Linq;  using System.Text;  using System.Windows;  using System.Windows.Forms;  using System.Drawing;  using System.IO;  using System.Collections;  using System.Configuration;  using System.Data;using System.Data.SqlClient;    class Program    {        static void Main(string[] args)        {            string coonString = "server=192.168.30.10;database=ykhc;uid=sa;pwd=hc2008";            SqlConnection conn = new SqlConnection(coonString);            SqlCommand cmd = conn.CreateCommand();            //sql语句                 cmd.CommandText = "SELECT goodsname, Basebarcode, saleprice, categorycode from \"000\".tbgoods";            //打开连接                 conn.Open();            //执行sql                 //cmd.ExecuteNonQuery();                 //若要创建 SqlDataReader，必须调用 SqlCommand 对象的 ExecuteReader 方法，而不要直接使用构造函数               SqlDataReader dr =  cmd.ExecuteReader();            while (dr.Read())            {                Console.Write(dr[0] + "\t");                Console.Write(dr[1] + "\t");                Console.Write(dr[2] + "\t");                Console.Write(dr[3]);                Console.WriteLine();            }            dr.Dispose();            //关闭连接                 conn.Close();        }    }
阅读全文
0 0