mysql dataset_小白访问Mysql数据库方法及利用DataSet更新数据库

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using MySql.Data.MySqlClient;

public partial class checkvisible : System.Web.UI.Page

{

protected

void Page_Load(object sender, EventArgs e)

{

int id =

Convert.ToInt32(Request.QueryString["id"].ToString());

String mysqlStr = "Database=mynetsite;Data Source=127.0.0.1;User

Id=root;Password=tjwyNIC;pooling=false;CharSet=gb2312;port=3306";

MySqlConnection mysqlcon = new MySqlConnection(mysqlStr);

String sqlstr = "select * from news where newsid="+id;

<