如何动态生成数据库表 建立一个连接,然后用操作数据库的command对象执行一条create table的sql语句就可以了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 StringBuilder CreateSql = new StringBuilder();CreateSql.Append( "CREATE TABLE "+ TableName +" ( " );CreateSql.Append( "id NUMBER NOT NULL ," );CreateSql.Append( "AccessoryName VARCHAR2 ( 200 ) NULL ," );CreateSql.Append( "AccessoryURL LONG RAW NULL," );CreateSql.Append( "StreetID NUMBER NULL, " );CreateSql.Append( "IsSB NUMBER NULL " );CreateSql.Append( ") " );m_Connection = new SqlConnection( ConnStr );m_Connection.Open();m_Command = new SqlCommand( CreateSql.ToString() , m_Connection );m_Command.ExecuteNonQuery(); 向gridview中追加数据 membership加密方式求助 求用正则表达式更改图片路径? 高分求解水晶报表不显示数据的问题(顶贴有分) dropdownlist控件,为何我得到的值总是默认的值? 为什么页面什么都不显示呢,莫名其妙? 层被ActiveX 控件挡住了怎么办? 怎样给datagrid里的HyperLinkColumn加个TIP之类的提示信息? 有返回值的存储过程怎么用啊 我的开发区域无法看到sqlconnection,sqldataadapter那两个组件的图表了? 在.NET环境下将报表导出Excel和Word ? 用户控件问题
CreateSql.Append( "CREATE TABLE "+ TableName +" ( " );
CreateSql.Append( "id NUMBER NOT NULL ," );
CreateSql.Append( "AccessoryName VARCHAR2 ( 200 ) NULL ," );
CreateSql.Append( "AccessoryURL LONG RAW NULL," );
CreateSql.Append( "StreetID NUMBER NULL, " );
CreateSql.Append( "IsSB NUMBER NULL " );
CreateSql.Append( ") " );
m_Connection = new SqlConnection( ConnStr );
m_Connection.Open();
m_Command = new SqlCommand( CreateSql.ToString() , m_Connection );
m_Command.ExecuteNonQuery();