用C#语言怎么实现sql语句 我要做一个想access一样但比较简单的数据库管理系统,但不知道怎么做,有经验的高手请帮帮我, 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 c#里写sql语句,楼主再把问题说清楚些 我说的不是使用sql语句,是自己做sql语句。具有select,insert,update一样的功能。使开发一种语言。我现在就不知道从哪开始。 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.OleDb;using System.Data.SqlClient;namespace RecoreLogin{ public class Login { public string ReadMyData(string Name, string WorkId, string PassWord) { string strConnection = "uid=pacific; password=pacific99; "; strConnection += "initial catalog=Pacific;Server=10.148.56.24;"; strConnection += "Connect Timeout=30"; SqlConnection myConnection = new SqlConnection(strConnection); string mySelectQuery = "SELECT * FROM RecordLogin where Name='" + Name + "'and" + " " + "WorkId='" + WorkId + "'and" + " " + " PassWord='" + PassWord + "'"; SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection); myConnection.Open(); SqlDataReader myReader; myReader = myCommand.ExecuteReader(); while (myReader.Read()) { if (myReader.GetString(0).Equals(Name)) { return "dd"; } } return "ok"; } }}这里有一段代码可供参考,是连接sql2005的 就是实现普通的增删改查 ado.net还是更复杂的? 如何实现winform下gridview 里通过滚轮上下选择记录? c# 前端问题 Socket 异步接收丢包问题(有代码) C#应用程序(PE)加区段工具 求一正则表达式,在线等 DataSet中设置一个自增加的主键! 什么时候,继承接口的函数需要加上接口的名字? 囚犯问题 哪位有Duwamish 7的详细中文文档? 请问在C#中如何将查询结果赋值??谢谢!!! 数据读取的“灵异”事件 出学.net 有个新手问题,求助!
楼主再把问题说清楚些
我现在就不知道从哪开始。
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.OleDb;
using System.Data.SqlClient;namespace RecoreLogin
{
public class Login
{
public string ReadMyData(string Name, string WorkId, string PassWord)
{
string strConnection = "uid=pacific; password=pacific99; "; strConnection += "initial catalog=Pacific;Server=10.148.56.24;"; strConnection += "Connect Timeout=30"; SqlConnection myConnection = new SqlConnection(strConnection);
string mySelectQuery = "SELECT * FROM RecordLogin where Name='" + Name + "'and" + " " + "WorkId='" + WorkId + "'and" + " " + " PassWord='" + PassWord + "'";
SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection); myConnection.Open();
SqlDataReader myReader;
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
if (myReader.GetString(0).Equals(Name))
{
return "dd";
}
} return "ok";
}
}
}
这里有一段代码可供参考,是连接sql2005的
还是更复杂的?