using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace Mining
{
public partial class halo : System.Web.UI.Page
{
protected void Bind()
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = " Server=.;DataBase=Mining Data;Uid=sa;Pwd=123";
string strSql = "Select * From UnitFile Where ID=" + Request.QueryString["ID"];
SqlDataAdapter myda = new SqlDataAdapter(strSql, conn);
DataSet myds = new DataSet();
myda.Fill(myds, "UnitFile");
DataRowView mydrv = myds.Tables["UnitFile"].DefaultView[0];
txtID.Text = Convert.ToString(mydrv.Row["ID"]);
txtCod.Text = Convert.ToString(mydrv.Row["Cod"]);
txtName.Text = Convert.ToString(mydrv.Row["UnitName"]);
txtTime.Text = Convert.ToString(mydrv.Row["Time"]);
}
protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack==true)
{
Bind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = " Server=.;DataBase=Mining Data;Uid=sa;Pwd=123";
conn.Open();
string sqlUp = "Update UnitFile Set Cod='" + txtCod.Text + "','UnitName='" + txtName.Text + "','Time='" + txtTime.Text + "' where ID='" + txtID.Text + "'";
SqlCommand cmd = new SqlCommand(conn, sqlUp);
conn.Close();
}
}
}
本代码的用意是使用textbox进行sql的数据修改，但是写到sqlcommand的时候里面的参数显示无法转换
conn无法从System.Data.Sqlclient.Sqlconnection转换为string，sqlUp无法从string转换为System.Data.Sqlclient.Sqlconnection！！！！
各位大神帮我看看是什么问题！求详解 急! 爱你们！呜呜呜呜
