c# 建库 建表的方法哪位高手能帮小弟我写一个类
c# 建库 建表的方法谁能帮我写一个类
c# 建库 建表的方法谁能帮我写一个类
------解决方案--------------------
private Boolean CreateDataBase(String name, SqlConnection sqlConnection)
{
String sqlCommandText = "create database " + name;
SqlCommand sqlCommand = new SqlCommand(sqlCommandText, sqlConnection);
try
{
sqlCommand.ExecuteScalar();
}
catch
{
return false;
}
return true;
}
private Boolean CreateTable(String dataBaseName, String tableName, Node NodeConfig, SqlConnection sqlConnection)
{
String sqlCommandText = "use " + dataBaseName;
SqlCommand sqlCommand = new SqlCommand(sqlCommandText, sqlConnection);
sqlCommand.ExecuteScalar();
sqlCommandText = "CREATE TABLE " + tableName;
int n = NodeConfig.Nodes.Count;
String PKs = "";
for (int i = 0; i < n; i++)
{
Node node = NodeConfig.Nodes[i];
String name = node.Property("name").Value;
String dateType = node.Property("dateType").Value;
String prec = node.Property("prec").Value;
String scale = node.Property("scale").Value;
String defalut = node.Property("defaultValue").Value;
Boolean IsNullable = node.Property("isNullable").Value == "true";
Boolean isPK = node.Property("isPK").Value == "true";
Boolean isIdentity = node.Property("isIdentity").Value == "true";
String identityStart = node.Property("identityStart").Value;
String identityStep = node.Property("identityStep").Value;
if (prec == ""
------解决方案--------------------
prec == "0")
{
prec = "128";
}
if (scale == "")
{
scale = "0";
}
c# 建库 建表的方法谁能帮我写一个类
------解决方案--------------------
private Boolean CreateDataBase(String name, SqlConnection sqlConnection)
{
String sqlCommandText = "create database " + name;
SqlCommand sqlCommand = new SqlCommand(sqlCommandText, sqlConnection);
try
{
sqlCommand.ExecuteScalar();
}
catch
{
return false;
}
return true;
}
private Boolean CreateTable(String dataBaseName, String tableName, Node NodeConfig, SqlConnection sqlConnection)
{
String sqlCommandText = "use " + dataBaseName;
SqlCommand sqlCommand = new SqlCommand(sqlCommandText, sqlConnection);
sqlCommand.ExecuteScalar();
sqlCommandText = "CREATE TABLE " + tableName;
int n = NodeConfig.Nodes.Count;
String PKs = "";
for (int i = 0; i < n; i++)
{
Node node = NodeConfig.Nodes[i];
String name = node.Property("name").Value;
String dateType = node.Property("dateType").Value;
String prec = node.Property("prec").Value;
String scale = node.Property("scale").Value;
String defalut = node.Property("defaultValue").Value;
Boolean IsNullable = node.Property("isNullable").Value == "true";
Boolean isPK = node.Property("isPK").Value == "true";
Boolean isIdentity = node.Property("isIdentity").Value == "true";
String identityStart = node.Property("identityStart").Value;
String identityStep = node.Property("identityStep").Value;
if (prec == ""
------解决方案--------------------
prec == "0")
{
prec = "128";
}
if (scale == "")
{
scale = "0";
}