在用C#创建数据库中表的时候遇到一个问题用sql语句创建的从数据库导出的表脚本为:
CREATE TABLE [dbo].[sys_Login](
[Fid] [nvarchar](50) NOT NULL,
[Fname] [nvarchar](50) NULL,
[F_Pwd] [nvarchar](250) NULL,
[F_Sex] [char](10) NULL,
[F_BM] [nvarchar](50) NULL,
[F_ZhiWei] [nvarchar](50) NULL,
[F_InDate] [nvarchar](50) NULL,
[F_Birthday] [nvarchar](50) NULL,
[F_Phone] [nvarchar](50) NULL,
[F_ZJType] [nvarchar](50) NULL,
[F_ZJNumber] [nvarchar](50) NULL,
[F_XL] [nvarchar](50) NULL,
[F_One] [nvarchar](4000) NULL,
[F_Two] [nvarchar](4000) NULL,
[F_Three] [nvarchar](4000) NULL,
[F_State] [int] NULL,
CONSTRAINT [PK_sys_Login] PRIMARY KEY CLUSTERED
(
[Fid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
SET ANSI_PADDING OFFALTER TABLE [dbo].[sys_Login] ADD CONSTRAINT [DF_sys_Login_F_State] DEFAULT ((0)) FOR [F_State]但是执行的时候 就要弄成一句话 把这些都用空格隔开 弄成一句比如:string sql="create........((0)) FOR [F_State]"有没有办法保持原来的样的
string sql="
CREATE TABLE [dbo].[sys_Login](
[Fid] [nvarchar](50) NOT NULL,
[Fname] [nvarchar](50) NULL,
[F_Pwd] [nvarchar](250) NULL,
[F_Sex] [char](10) NULL,
[F_BM] [nvarchar](50) NULL,
[F_ZhiWei] [nvarchar](50) NULL,
[F_InDate] [nvarchar](50) NULL,
[F_Birthday] [nvarchar](50) NULL,
[F_Phone] [nvarchar](50) NULL,
[F_ZJType] [nvarchar](50) NULL,
[F_ZJNumber] [nvarchar](50) NULL,
[F_XL] [nvarchar](50) NULL,
[F_One] [nvarchar](4000) NULL,
[F_Two] [nvarchar](4000) NULL,
[F_Three] [nvarchar](4000) NULL,
[F_State] [int] NULL,
CONSTRAINT [PK_sys_Login] PRIMARY KEY CLUSTERED
(
[Fid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
SET ANSI_PADDING OFFALTER TABLE [dbo].[sys_Login] ADD CONSTRAINT [DF_sys_Login_F_State] DEFAULT ((0)) FOR [F_State]"中间不用+号连接起来
CREATE TABLE [dbo].[sys_Login](
[Fid] [nvarchar](50) NOT NULL,
[Fname] [nvarchar](50) NULL,
[F_Pwd] [nvarchar](250) NULL,
[F_Sex] [char](10) NULL,
[F_BM] [nvarchar](50) NULL,
[F_ZhiWei] [nvarchar](50) NULL,
[F_InDate] [nvarchar](50) NULL,
[F_Birthday] [nvarchar](50) NULL,
[F_Phone] [nvarchar](50) NULL,
[F_ZJType] [nvarchar](50) NULL,
[F_ZJNumber] [nvarchar](50) NULL,
[F_XL] [nvarchar](50) NULL,
[F_One] [nvarchar](4000) NULL,
[F_Two] [nvarchar](4000) NULL,
[F_Three] [nvarchar](4000) NULL,
[F_State] [int] NULL,
CONSTRAINT [PK_sys_Login] PRIMARY KEY CLUSTERED
(
[Fid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
SET ANSI_PADDING OFFALTER TABLE [dbo].[sys_Login] ADD CONSTRAINT [DF_sys_Login_F_State] DEFAULT ((0)) FOR [F_State]但是执行的时候 就要弄成一句话 把这些都用空格隔开 弄成一句比如:string sql="create........((0)) FOR [F_State]"有没有办法保持原来的样的
string sql="
CREATE TABLE [dbo].[sys_Login](
[Fid] [nvarchar](50) NOT NULL,
[Fname] [nvarchar](50) NULL,
[F_Pwd] [nvarchar](250) NULL,
[F_Sex] [char](10) NULL,
[F_BM] [nvarchar](50) NULL,
[F_ZhiWei] [nvarchar](50) NULL,
[F_InDate] [nvarchar](50) NULL,
[F_Birthday] [nvarchar](50) NULL,
[F_Phone] [nvarchar](50) NULL,
[F_ZJType] [nvarchar](50) NULL,
[F_ZJNumber] [nvarchar](50) NULL,
[F_XL] [nvarchar](50) NULL,
[F_One] [nvarchar](4000) NULL,
[F_Two] [nvarchar](4000) NULL,
[F_Three] [nvarchar](4000) NULL,
[F_State] [int] NULL,
CONSTRAINT [PK_sys_Login] PRIMARY KEY CLUSTERED
(
[Fid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
SET ANSI_PADDING OFFALTER TABLE [dbo].[sys_Login] ADD CONSTRAINT [DF_sys_Login_F_State] DEFAULT ((0)) FOR [F_State]"中间不用+号连接起来
解决方案 »
- 【200】高分求如何做IP地址映射?
- c#导出数据到EXCEL,如何实现EXCEL滚动行为?
- C#打印问题?
- C#能开发分布式系统吗?要求具有异地实时同步
- string类型转换为时间类型的问题,在线等,急~~~~
- 如何方便的修改用C#编写的WebApplication中的100个Label控件的TOOLTIP属性的值?
- 如何对xml文件作查询?
- 我想截获键盘按下del的消息
- C#如何跳转到选择断点(像VB 的Ctrl+F9)(调试时)
- 谁有xtragrid的序列号啊?给高分的!我可以拿erstudio 6交换
- 上位机用USB与下位机通信,能用C#写上位机程序吗
- winfrom中把图片放入数据库和取出
"b"+
"c";
另一种是加@试试
string sql=@"
CREATE TABLE [dbo].[sys_Login](
[Fid] [nvarchar](50) NOT NULL,
[Fname] [nvarchar](50) NULL,
[F_Pwd] [nvarchar](250) NULL,
[F_Sex] [char](10) NULL,
[F_BM] [nvarchar](50) NULL,
[F_ZhiWei] [nvarchar](50) NULL,
[F_InDate] [nvarchar](50) NULL,
[F_Birthday] [nvarchar](50) NULL,
[F_Phone] [nvarchar](50) NULL,
[F_ZJType] [nvarchar](50) NULL,
[F_ZJNumber] [nvarchar](50) NULL,
[F_XL] [nvarchar](50) NULL,
[F_One] [nvarchar](4000) NULL,
[F_Two] [nvarchar](4000) NULL,
[F_Three] [nvarchar](4000) NULL,
[F_State] [int] NULL,
CONSTRAINT [PK_sys_Login] PRIMARY KEY CLUSTERED
(
[Fid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
SET ANSI_PADDING OFFALTER TABLE [dbo].[sys_Login] ADD CONSTRAINT [DF_sys_Login_F_State] DEFAULT ((0)) FOR [F_State]"