public bool UpdateStored(string DataBaseName, string StoredName, string StoredText)
{
SQLDMO.SQLServer svr = new SQLDMO.SQLServerClass();
try
{
svr.Connect(ServerName, UserName, Password);
if (StoredName == "")
{
SQLDMO.StoredProcedure spd = new SQLDMO.StoredProcedureClass();
spd.Text = StoredText;
svr.Databases.Item(DataBaseName, "owner").StoredProcedures.Add(spd);
}
else
{
SQLDMO.Database dbs = new SQLDMO.DatabaseClass();
SQLDMO.StoredProcedure spd = new SQLDMO.StoredProcedureClass();
dbs = (SQLDMO.Database)svr.Databases.Item(DataBaseName, "owner");
foreach (SQLDMO.StoredProcedure sp in dbs.StoredProcedures)
{
if (sp.Name == StoredName)
{
spd = sp;
}
}
spd.Alter(StoredText);
}
return(true);
}
catch (Exception err)
{
//throw (new Exception("！" + err.Message));
ShowError("修改存储过程失败!" + err.Message);
return(false);
}
finally
{
svr.DisConnect();
}
}
public bool UpdateStored(string DataBaseName, string StoredName,string StoredText)
{
SQLDMO.SQLServer svr = new SQLDMO.SQLServerClass();
try
{
svr.Connect(ServerName, UserName, Password);
if (StoredName == "")
{
SQLDMO.StoredProcedure spd = new SQLDMO.StoredProcedureClass();
spd.Text = StoredText;
svr.Databases.Item(DataBaseName, "owner").StoredProcedures.Add(spd);
}
else
{
SQLDMO.Database dbs = new SQLDMO.DatabaseClass();
SQLDMO.StoredProcedure spd = new SQLDMO.StoredProcedureClass();
dbs = (SQLDMO.Database)svr.Databases.Item(DataBaseName, "owner");
foreach (SQLDMO.StoredProcedure sp in dbs.StoredProcedures)
{
if (sp.Name == StoredName)
spd = sp;
}
spd.Alter(StoredText);
}
return true;
}
catch (Exception err)
{
//throw (new Exception("��" + err.Message));
ShowError("�Ĵ洢����ʧ��!" + err.Message);
return false;
}
finally
{
svr.DisConnect();
}
}
