22,207
社区成员
发帖
与我相关
我的任务
分享
protected void btnSave_Click(object sender, EventArgs e)
{
SqlParameter[] lsparam =
{
new SqlParameter("@server",YingSheName_500011.Text.Trim()),
new SqlParameter("@srvproduct",""),
new SqlParameter("@provider","SQLNCLI"),
new SqlParameter("@datasrc",ShuJuYuan_500011.Text.Trim())
};
ExecuteCommand("sp_addlinkedserver",lsparam);
SqlParameter[] lsLoginParam =
{
new SqlParameter("@rmtsrvname",YingSheName_500011.Text.Trim()),
new SqlParameter("@useself","true"),
new SqlParameter("@locallogin",null),
new SqlParameter("@rmtuser",txtLoginID.Text.Trim()),
new SqlParameter("@rmtpassword",txtPWD.Text.Trim())
};
ExecuteCommand("sp_addlinkedsrvlogin", lsLoginParam);
}
public static int ExecuteCommand(string procName,params SqlParameter[] values)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = Connection;
cmd.CommandText = procName;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(values);
int result = cmd.ExecuteNonQuery();
Connection.Close();
return result;
}