如何将SQL数据库中的读取到DBGrid1控件中并完成相关操作
1)比如:
SQL数据库中有数据库名如下
TEXT0000000000001
TEXT0000000000002
ABCD0000000000003
ABCD0000000000004
我只想读取这些数据库名》》
2)我想将建立“数据库及表信息的createdb.sql”写成一个“资源文件”
数据库名称和路径部分是由“用户自定义的”
比如:
用户输入的数据库名为: ABBVBD
路径名为: d:\sqldbsys (d盘是存在的情况)
再调用那个“资源文件”并在指定的路径中建立数据库及表
1)比如:
SQL数据库中有数据库名如下
TEXT0000000000001
TEXT0000000000002
ABCD0000000000003
ABCD0000000000004
我只想读取这些数据库名》》
2)我想将建立“数据库及表信息的createdb.sql”写成一个“资源文件”
数据库名称和路径部分是由“用户自定义的”
比如:
用户输入的数据库名为: ABBVBD
路径名为: d:\sqldbsys (d盘是存在的情况)
再调用那个“资源文件”并在指定的路径中建立数据库及表
删除数据库
备份数据库
恢复数据库
压缩数据库
/****** Object: 建立数据库 Database [DemoTest] ******/
CREATE DATABASE [DemoTest] ON PRIMARY
( NAME = N'DemoTest_Data', FILENAME = N'D:\MSSQLDB\DemoTest_Data.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
LOG ON
( NAME = N'DemoTest_Log', FILENAME = N'D:\MSSQLDB\DemoTest_Log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 1024KB )
GO
ALTER DATABASE [DemoTest] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [DemoTest].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [DemoTest] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [DemoTest] SET ANSI_NULLS OFF
GO
ALTER DATABASE [DemoTest] SET ANSI_PADDING OFF
GO
ALTER DATABASE [DemoTest] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [DemoTest] SET ARITHABORT OFF
GO
ALTER DATABASE [DemoTest] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [DemoTest] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [DemoTest] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [DemoTest] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [DemoTest] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [DemoTest] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [DemoTest] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [DemoTest] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [DemoTest] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [DemoTest] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [DemoTest] SET DISABLE_BROKER
GO
ALTER DATABASE [DemoTest] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [DemoTest] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [DemoTest] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [DemoTest] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [DemoTest] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [DemoTest] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [DemoTest] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [DemoTest] SET READ_WRITE
GO
ALTER DATABASE [DemoTest] SET RECOVERY FULL
GO
ALTER DATABASE [DemoTest] SET MULTI_USER
GO
ALTER DATABASE [DemoTest] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [DemoTest] SET DB_CHAINING OFF
GO
/******建立表******/
USE [DemoTest]
GO
/****** Object: Table [dbo].[Table_Textstudent]10:46:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_Textstudent](
[Text_id] [smallint] IDENTITY(1,1) NOT NULL,
[Text_name] [nvarchar](50) NULL,
[Text_sex] [nvarchar](50) NULL,
[Text_nl] [nvarchar](50) NULL,
[Text_xh] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/////////////////////////////////////////////////////////////////////////
CREATE DATABASE [DemoTest] ON PRIMARY
( NAME = N'DemoTest_Data', FILENAME = N'D:\MSSQLDB\DemoTest_Data.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
LOG ON
( NAME = N'DemoTest_Log', FILENAME = N'D:\MSSQLDB\DemoTest_Log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 1024KB )
GO
-------------------------------------------------------------------------------
在这上七行代码中,我想动态的得到“数据库名称”---》DemoTest
路径---》D:\MSSQLDB
你怎么会这样呀,一点资料也没有留下呀》》》》》