源代码 如下:
protected void Page_Load(object sender, EventArgs e)
{ SqlConnection sqlcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["myConnString"]);
sqlcon.Open();
string sqltext = "Exec sp_helpdb";
SqlCommand sqlcom = new SqlCommand(sqltext ,sqlcon );
SqlDataReader dr = sqlcom.ExecuteReader();
DropDownList1.DataSource = dr;
DropDownList1.DataTextField = "name";
DropDownList1.DataBind();
sqlcon .Close ();
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection mysqlcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["myConnString"]);
mysqlcon.Open();
string sql = "backup database "+DropDownList1.SelectedItem .Value +" to disk = '"+TextBox1 .Text .Trim ()+".bak'";
try
{
if (File.Exists(this.TextBox1.Text.Trim()))
{
Response.Write("<script language=javascript>alert ('此文件已存在,请从新输入!');</script>"); return; }
SqlCommand sqlcomm = new SqlCommand(sql, mysqlcon);
sqlcomm.ExecuteNonQuery();
Response.Write("<script language=javascript>alert('备份数据成功!'); </script>");
}
catch (Exception ms)
{
Response.Write(ms.Message);
Response.Write("<script language=javascript>alert('备份数据失败!'); </script>"); }
finally
{
mysqlcon.Close();
}
mysqlcon.Close();
}
protected void Page_Load(object sender, EventArgs e)
{ SqlConnection sqlcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["myConnString"]);
sqlcon.Open();
string sqltext = "Exec sp_helpdb";
SqlCommand sqlcom = new SqlCommand(sqltext ,sqlcon );
SqlDataReader dr = sqlcom.ExecuteReader();
DropDownList1.DataSource = dr;
DropDownList1.DataTextField = "name";
DropDownList1.DataBind();
sqlcon .Close ();
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection mysqlcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["myConnString"]);
mysqlcon.Open();
string sql = "backup database "+DropDownList1.SelectedItem .Value +" to disk = '"+TextBox1 .Text .Trim ()+".bak'";
try
{
if (File.Exists(this.TextBox1.Text.Trim()))
{
Response.Write("<script language=javascript>alert ('此文件已存在,请从新输入!');</script>"); return; }
SqlCommand sqlcomm = new SqlCommand(sql, mysqlcon);
sqlcomm.ExecuteNonQuery();
Response.Write("<script language=javascript>alert('备份数据成功!'); </script>");
}
catch (Exception ms)
{
Response.Write(ms.Message);
Response.Write("<script language=javascript>alert('备份数据失败!'); </script>"); }
finally
{
mysqlcon.Close();
}
mysqlcon.Close();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货