100点求一asp.net读写数据库（sql access）（C＃）的完整例子
100点求一asp.net读写数据库（sql, access）（C＃版）的完整例子
谢谢
问题点数：100、回复次数：15Top
1 楼cite（cite）回复于 2004-11-02 23:12:55 得分 0
我的mail:lcf@mail.lhjy.netTop
2 楼net_lover（【孟子E章】）回复于 2004-11-02 23:14:39 得分 0
http://dotnet.aspx.cc/ShowDetail.aspx?id=8ADE535F-AD40-4DE3-A962-A64B4FAF12C4Top
3 楼simonw（代码@痕记）回复于 2004-11-02 23:20:54 得分 10
ms sqlhelper 读取sqlserver的专用类
ACCESS数据库访问组件
http://dev.csdn.net/article/46/46738.shtm
dotnetnuke的那个组件也不错Top
4 楼cancersyf（fengzhimei）回复于 2004-11-03 00:11:55 得分 0
http://www.easerve.com/developer/tutorials/asp-net-tutorials-adding-records-database.aspx
http://www.w3schools.com/aspnet/aspnet_dbconnection.aspTop
5 楼jyunhu（Jerry）回复于 2004-11-03 08:48:08 得分 10
我刚刚开始研究asp.net
写了几个访问数据库的test
我发给你研究研究Top
6 楼xiaohutushen（程序人生）回复于 2004-11-03 08:52:08 得分 0
upTop
7 楼berlin8600（柏林）回复于 2004-11-03 10:40:04 得分 20
<%@ Page Debug="true" Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<head>
<title>DataGrid Demo- Auto Generate</title>
<script language="C#" runat="server" >
public void Page_Load()
{
//Create Connection object
string dataSource = "Data Source=localhost;";
string security = "user id=sa; password=;";
string initialCatalog = "initial catalog=pubs;";
string cnnString = dataSource + security + initialCatalog;
SqlConnection connection = new SqlConnection(cnnString);
// Create Data Command
string strSql = "select * from [authors]";
SqlCommand command = new SqlCommand(strSql, connection);
// Create Data Adapter
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
// Create DataSet
DataSet dataSet = new DataSet();
try
{
connection.Open();
adapter.Fill(dataSet);
}
catch(SqlException e)
{
Response.Write(e.ToString());
}
finally
{
connection.Close();
}
grid1.DataSource = dataSet.Tables[0];
grid1.DataBind();
}
</script>
</head>
<body>
<form id="form1" runat="server">
<h3>DataGrid Demo- Auto Generate</h3>
<asp:DataGrid id="grid1" runat="server" ShowHeader="true" GridLines="Both" AutoGenerateColumns="true">
<HeaderStyle BackColor="lightblue" Font-Name="Arial" Font-Bold="true" />
<ItemStyle BackColor="lightyellow"/>
</asp:DataGrid>
</form>
</body>
</html>
Top
8 楼lonelydreamsym（惊梦）回复于 2004-11-03 11:03:53 得分 30
<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">
// Insert page code here
void Page_Load(Object Sender,EventArgs e)
{
String str;
String sql;
SqlConnection objCon;
SqlCommand objCmd;
SqlDataReader objDr;
SqlDataAdapter objDa;
DataSet objDs;
objDs=new DataSet();
str="server=yoxun2;uid=sa;pwd=;database=friends";
sql="select * from friends order by id desc";
objCon=new SqlConnection(str);
objCmd=new SqlCommand(sql,objCon);
objDa=new SqlDataAdapter(sql,objCon);
objDa.Fill(objDs,"sym");
objCon.Open();
efun.DataSource=objCmd.ExecuteReader();
efun.DataBind();
objCon.Close();
DataView objDv;
objDv=new DataView(objDs.Tables["sym"]);
efun2.DataSource=objDv;
efun2.DataBind();
DataTable objDt;
DataRow objNewRow;
String strFirstName;
objDt=objDs.Tables["sym"];
objNewRow=objDt.NewRow();
objNewRow["id"]=34;
objNewRow["name"]="adasdfasd";
objNewRow["sex"]="True";
objNewRow["addr"]="adfadf";
objDt.Rows.Add(objNewRow);
efun3.DataSource=objDv;
efun3.DataBind();
SqlCommandBuilder objBuilder;
objBuilder= new SqlCommandBuilder(objDa);
objDa.Update(objDs,"sym");
}
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<!-- Insert content here -->
<asp:DataGrid id="efun" runat="server"></asp:DataGrid>
<br />
<asp:DataGrid id="efun2" runat="server"></asp:DataGrid>
<br />
<asp:DataGrid id="efun3" runat="server"></asp:DataGrid>
</form>
</body>
</html>Top
9 楼lonelydreamsym（惊梦）回复于 2004-11-03 11:04:42 得分 0
读写都在上面，自己看吧Top
10 楼lonelydreamsym（惊梦）回复于 2004-11-03 11:05:15 得分 0
我也刚学这东西没几天Top
11 楼zlc810821（卷心菜）回复于 2004-11-03 11:12:57 得分 20
using System;
using System.Data;
using System.Data.SqlClient;
namespace EcpCompete.admin.leaveWord
{
/// <summary>
/// LeaveWord 的摘要说明。
/// </summary>
public class LeaveWord: AdminBasePage
{
/// <summary>
/// 构造函数
/// </summary>
public LeaveWord()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
/// <summary>
/// 增加留言内容
/// </summary>
/// <param name="LeaveWordTitle">留言标题</param>
/// <param name="LeaveWordBody">留言内容</param>
/// <param name="isDisplay">是否显示</param>
/// <param name="ShowTime">显示时间</param>
/// <param name="ExamID">赛区ID</param>
/// <param name="UserID">用户ID</param>
/// <returns>返回是否成功</returns>
public bool addLeaveWord(
string LeaveWordTitle,
string LeaveWordBody,
string isDisplay,
string piFlag,
DateTime ShowTime,
int ExamID,
string UserID
)
{
// 过滤字符串
Strings strs = new Strings();
LeaveWordTitle = strs.filtrate(LeaveWordTitle );
LeaveWordBody = strs.filtrate2(LeaveWordBody );
string SQL = "insert T_leaveword("
+ "name," //留言标题
+ "examid," //赛区编号
+ "content," //留言内容
+ "outtime," //显示时间
+ "dinputtime," //录入时间
+ "userid," //录入账号
+ "ishot," //是否显示
+ "iflag,"
+ "spare)" //备用
+ " values('"
+ LeaveWordTitle + "',"
+ ExamID.ToString() + ",'"
+ LeaveWordBody + "','"
+ ShowTime.ToString() + "',"
+ "getDate(),'"
+ UserID + "','"
+ isDisplay +"','"
+ piFlag +"',"
+ "null)";
SqlDataBase sdb = new SqlDataBase();
SqlConnection dbConn = sdb.Connection();
dbConn.Open();
string _return = sdb.SqlNonExecute(SQL,dbConn);
dbConn.Close();
if ( _return=="" )
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 修改留言
/// </summary>
/// <param name="LeaveWordID">留言ID</param>
/// <param name="LeaveWordTitle">留言标题</param>
/// <param name="LeaveWordBody">留言体</param>
/// <param name="isDisplay">是否显示</param>
/// <param name="ShowTime">显示时间</param>
/// <returns>返回是否成功</returns>
public bool modifyLeaveWord(
int LeaveWordID,
string LeaveWordTitle,
string LeaveWordBody,
string piFlag,
string isDisplay,
DateTime ShowTime
)
{
// 过滤字符串
Strings strs = new Strings();
LeaveWordTitle = strs.filtrate(LeaveWordTitle);
LeaveWordBody = strs.filtrate2(LeaveWordBody);
string SQL = "update T_leaveword set "
+ "name='" + LeaveWordTitle + "'," //新闻标题
+ "content='" + LeaveWordBody + "'," //新闻内容
+ "outtime='" + ShowTime.ToString() + "'," //显示时间
+ "ishot='" + isDisplay + "', " //是否显示
+ "iflag='" + piFlag + "' "
+ "where id=" + LeaveWordID.ToString();
SqlDataBase sdb = new SqlDataBase();
SqlConnection dbConn = sdb.Connection();
dbConn.Open();
string _return = sdb.SqlNonExecute(SQL,dbConn);
dbConn.Close();
if ( _return=="" )
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 删除留言
/// </summary>
/// <param name="LeaveWordID">留言ID</param>
/// <returns>是否成功</returns>
public bool deleteLeaveWord(int LeaveWordID)
{
string SQL = "delete T_leaveword where id="+LeaveWordID.ToString();
SqlDataBase sdb = new SqlDataBase();
SqlConnection dbConn = sdb.Connection();
dbConn.Open();
string _return = sdb.SqlNonExecute(SQL,dbConn);
dbConn.Close();
if ( _return=="" )
{
return true;
}
else
{
return false;
}
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad (e);
sec.checkPageForUserRank(this.Page,"leaveWord",this.userRank);
}
}
}
Top
12 楼cite（cite）回复于 2004-11-12 16:00:40 得分 0
自己顶Top
13 楼cite（cite）回复于 2004-11-12 16:03:27 得分 0
dingTop
14 楼cite（cite）回复于 2004-11-12 16:07:22 得分 0
upTop
15 楼suntonycomm（太阳花）回复于 2004-11-12 16:12:16 得分 10
来一个最直观的.
--------------------------------------------------------------
插入数据
string sql=string.Empty;
OleDbCommand cmd;
StringBuilder sb= new StringBuilder();
ArrayList values = new ArrayList();
sb.Append("insert into members (M_Name,M_Code,M_Password,M_Email,M_Sig) ");
sb.Append("values('{0}','{1}','{2}','{3}','{4}')");
values.Add(txtName.Text);
values.Add(txtCode.Text);
values.Add(txtPwd.Text);
values.Add(txtMail.Text);
values.Add(txtSig.Text);
sql = string.Format(sb.ToString(),values.ToArray());
//Response.Write(sql);
//Response.Flush();
cmd = new OleDbCommand(sql,cnHelp);
cnHelp.Open();
cmd.ExecuteNonQuery();
-------------------------------------------------------------------------------------
查询
string sql;
sql = "select Member_ID from Members where M_Name='" +_Name+"' and M_Password='"+_Pwd+"'";
//Response.Write(sql);
cnHelp.Open();
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
if (cmd.ExecuteScalar()==null) //第一行第一列为null
else
//有记录
--------------------------------------------------------------------------
Top
相关问题
关键词
得分解答快速导航
相关链接
广告也精彩
反馈
