public bool InsertTable(string DatabaseName, string TableName, DataTable dt)
{
SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass();
SQLDMO.SQLServer svr = new SQLDMO.SQLServerClass();
string keyName = "";
try
{
svr.Connect(ServerName, UserName, Password);
SQLDMO.Database myDb = new SQLDMO.DatabaseClass();
myDb = (SQLDMO.Database)svr.Databases.Item(DatabaseName, "owner");
SQLDMO.Table myTb = new SQLDMO.TableClass();
myTb.Name = TableName;
foreach (DataRow dr in dt.Rows)
{
SQLDMO.Column column = new SQLDMO.ColumnClass();
column.Name = dr["ColumnName"].ToString();
column.Datatype = dr["ColumnType"].ToString();
column.Length = int.Parse(dr["ColumnSize"].ToString());
if (bool.Parse(dr["ColumnKey"].ToString()))
{
keyName = column.Name;
}
column.AllowNulls = bool.Parse(dr["ColumnNull"].ToString());
myTb.Columns.Add(column);
}
if (keyName != "")
{
SQLDMO.Key key = new SQLDMO.KeyClass();
key.Name = keyName;
key.Type = SQLDMO.SQLDMO_KEY_TYPE.SQLDMOKey_Primary;
key.KeyColumns.Add(keyName);
myTb.Keys.Add(key);
}
myDb.Tables.Add(myTb);
return(true);
}
catch (Exception e)
{
//throw (new Exception("连接数据库出错：" + e.Message));
ShowError("添加数据库失败!" + e.Message);
return(false);
}
finally
{
svr.DisConnect();
sqlApp.Quit();
}
}
public bool InsertTable(string DatabaseName, string TableName,DataTable dt)
{
SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass();
SQLDMO.SQLServer svr = new SQLDMO.SQLServerClass();
string keyName = "";
try
{
svr.Connect(ServerName, UserName, Password);
SQLDMO.Database myDb = new SQLDMO.DatabaseClass();
myDb = (SQLDMO.Database)svr.Databases.Item(DatabaseName, "owner");
SQLDMO.Table myTb = new SQLDMO.TableClass();
myTb.Name = TableName;
foreach (DataRow dr in dt.Rows)
{
SQLDMO.Column column = new SQLDMO.ColumnClass();
column.Name = dr["ColumnName"].ToString();
column.Datatype = dr["ColumnType"].ToString();
column.Length = int.Parse(dr["ColumnSize"].ToString());
if (bool.Parse(dr["ColumnKey"].ToString()))
{
keyName = column.Name;
}
column.AllowNulls = bool.Parse(dr["ColumnNull"].ToString());
myTb.Columns.Add(column);
}
if (keyName != "")
{
SQLDMO.Key key = new SQLDMO.KeyClass();
key.Name = keyName;
key.Type = SQLDMO.SQLDMO_KEY_TYPE.SQLDMOKey_Primary;
key.KeyColumns.Add(keyName);
myTb.Keys.Add(key);
}
myDb.Tables.Add(myTb);
return true;
}
catch (Exception e)
{
//throw (new Exception("�������ݿ�����" + e.Message));
ShowError("������ݿ�ʧ��!" + e.Message);
return false;
}
finally
{
svr.DisConnect();
sqlApp.Quit();
}
}
