C#显示SQL语句格式

页面导航:首页 > 软件编程 > C#教程 > C#显示SQL语句格式

C#显示SQL语句格式

来源: 作者: 时间:2016-01-15 14:58 【

--SQL SERVER生成测试环境:Create database Test; goUSE [Test]GOif OBJECT_ID( 39;Tab 39;, 39;U 39;) is not nulldrop table TabgoCREATE TABLE [dbo] [Tab]([ID] [int] NOT

--SQL SERVER生成测试环境:

 

Create database Test; 
go
USE [Test]
GO

if OBJECT_ID('Tab','U') is not null
	drop table Tab
go
CREATE TABLE [dbo].[Tab](
	[ID] [int] NOT NULL  CONSTRAINT [PK_Tab] PRIMARY KEY CLUSTERED ,
	[name] [sysname] NOT NULL
)


--打开Visual Studio—创建项目—选择【控制台应用程序】

 

 

#region Using Directives
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
#endregion

namespace TestShowSql
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection thisConnection = new SqlConnection(@Server=(Local);Integrated Security=True;Database=Test);
            //thisConnection.Open();
            SqlDataAdapter thisAdapter = new SqlDataAdapter(SELECT ID,NAME FROM TAB,thisConnection);
            SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
            Console.WriteLine(SQL Select Command is :
{0}
, thisAdapter.SelectCommand.CommandText);
            SqlCommand updateCommand = thisBuilder.GetUpdateCommand();
            Console.WriteLine(SQL UPDATE Command is :
{0}
,updateCommand.CommandText);
            SqlCommand insertCommand = thisBuilder.GetInsertCommand();
            Console.WriteLine(SQL INSERT Command is :
{0}
,insertCommand.CommandText);
            SqlCommand deleteCommand = thisBuilder.GetDeleteCommand();
            Console.WriteLine(SQL DELETE Command is :
{0}
,deleteCommand.CommandText);
            thisConnection.Close();
            Console.WriteLine(Program finished,Press Enter/Return to continue:);
            Console.ReadLine();
        }
    }
}

--按F5运行结果:

 

/

 

 

Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<