asp.net连接mysql怎么写登录代码
asp.net连接mysql怎么写登录代码
关键是把登录代码写在 类中
然后前台登录代码就只用就调用这个 类C# code:
using System;//这个类中要是有错请指出来，谢谢
using System.Data;
using System.Configuration;
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 System.Configuration;
using MySql.Data.MySqlClient;
/// <summary>
///UserInfo 的摘要说明
/// </summary>
public class UserInfo
{
public string user_name;
public string password;
public string str = System.Configuration.ConfigurationManager.AppSettings["strconn"];
MySqlConnection conn = new MySqlConnection();
MySqlCommand cmd = new MySqlCommand();
public string User_Name
{
get
{
return user_name;
}
set
{
user_name = value;
}
}
public string Password
{
get
{
return password;
}
set
{
password = value;
}
}
public bool CheckLogin()
{
conn = new MySqlConnection(str);
string sql = "Select count(user_name) from bg_user where username=? and password =?";
相关问答：
请问下能不能再windows下定期清空mysql一个表中的全部数据，用PHP实现！
谢谢各位了
就比如一个星期清空一次
比如每个星期六零点清空一次！
谢谢了
计划任务...php....sql...truncate....OK
你就这接在页� ......
先上错误
无法联接数据库
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
从数据库中查询一张表的数据
select 部门,姓名 from tb
如何才能生成下面的xml格式文件
<folder state="unchecked" label="全部">
<folder state="unchecked" isBra ......
C# code:
SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
