using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls;using System.Data.Odbc; using System.Data.SqlClient; using CoreLab.MySql;public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { string connstr = "Data Source=192.168.123.100;Password=wtuitxia;User ID=haijiang;database=qianfukeji"; string sqlstr="select * from userinfo"; // OdbcConnection odbcconn = new OdbcConnection(connstr); // odbcconn.Open(); MySqlConnection mysqlconn = new MySqlConnection(connstr); MySqlDataAdapter mysqlda = new MySqlDataAdapter(sqlstr, connstr); DataSet ds = new DataSet(); mysqlda.Fill(ds, "userinfo");
//sqlstr = "insert into userinfo values ('fdfsd','f','地方');"; //MySqlCommand mysqlcmd = new MySqlCommand(sqlstr, mysqlconn); //mysqlconn.Open(); //mysqlcmd.ExecuteNonQuery();
} }我用的局域网中的另一台机子为服务器
using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls;using System.Data.Odbc; using System.Data.SqlClient; using CoreLab.MySql;public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { // string connstr = "Data Source=192.168.123.100;Password=wtuitxia;User ID=haijiang;database=qianfukeji";
string connstr = "Driver={MySQL ODBC 3.51 Driver};server=192.168.123.100;database=qianfukeji;user=haijiang;password=wtuitxia;option=3;STMT=set CHARACTER SET gbk"; string sqlstr="select * from userinfo"; OdbcConnection odbcconn = new OdbcConnection(connstr);
// odbcconn.Open(); //MySqlConnection mysqlconn = new MySqlConnection(connstr); //MySqlDataAdapter mysqlda = new MySqlDataAdapter(sqlstr, connstr); OdbcDataAdapter odbcda = new OdbcDataAdapter(sqlstr, connstr); DataSet ds = new DataSet(); odbcda.Fill(ds, "userinfo");
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;using System.Data.Odbc;
using System.Data.SqlClient;
using CoreLab.MySql;public partial class _Default : System.Web.UI.Page
{ protected void Page_Load(object sender, EventArgs e)
{
string connstr = "Data Source=192.168.123.100;Password=wtuitxia;User ID=haijiang;database=qianfukeji";
string sqlstr="select * from userinfo";
// OdbcConnection odbcconn = new OdbcConnection(connstr);
// odbcconn.Open();
MySqlConnection mysqlconn = new MySqlConnection(connstr);
MySqlDataAdapter mysqlda = new MySqlDataAdapter(sqlstr, connstr);
DataSet ds = new DataSet();
mysqlda.Fill(ds, "userinfo");
Response.Write(ds.Tables["userinfo"].Rows[0]["name"].ToString());
//sqlstr = "insert into userinfo values ('fdfsd','f','地方');";
//MySqlCommand mysqlcmd = new MySqlCommand(sqlstr, mysqlconn);
//mysqlconn.Open();
//mysqlcmd.ExecuteNonQuery();
}
}我用的局域网中的另一台机子为服务器
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;using System.Data.Odbc;
using System.Data.SqlClient;
using CoreLab.MySql;public partial class _Default : System.Web.UI.Page
{ protected void Page_Load(object sender, EventArgs e)
{
// string connstr = "Data Source=192.168.123.100;Password=wtuitxia;User ID=haijiang;database=qianfukeji";
string connstr = "Driver={MySQL ODBC 3.51 Driver};server=192.168.123.100;database=qianfukeji;user=haijiang;password=wtuitxia;option=3;STMT=set CHARACTER SET gbk";
string sqlstr="select * from userinfo";
OdbcConnection odbcconn = new OdbcConnection(connstr);
// odbcconn.Open(); //MySqlConnection mysqlconn = new MySqlConnection(connstr);
//MySqlDataAdapter mysqlda = new MySqlDataAdapter(sqlstr, connstr); OdbcDataAdapter odbcda = new OdbcDataAdapter(sqlstr, connstr);
DataSet ds = new DataSet();
odbcda.Fill(ds, "userinfo");
//Response.Write(ds.Tables["userinfo"].Rows[0]["name"].ToString()); this.GridView1.DataSource = ds.Tables["userinfo"];
this.GridView1.DataBind();
//sqlstr = "insert into userinfo values ('fdfsd','f','地方');";
//MySqlCommand mysqlcmd = new MySqlCommand(sqlstr, mysqlconn);
//mysqlconn.Open();
//mysqlcmd.ExecuteNonQuery(); //OdbcCommand odbccmd = new OdbcCommand(sqlstr, odbcconn);
//odbcconn.Open();
//odbccmd.ExecuteNonQuery();
}
}谢谢各位了,我终于找到答案了,问题全解决..
加编码试试
我在网上找到了一个ODBC连接字符串,能解决,显示正常,也能插入字符串..
Conn.execute(sqlStr)