C#中如何对数据库的应用
在C#中如何对数据的更新,修改,删除,插入等操作的代码如何写 --------------------编程问答--------------------这个基础知识要先百度了才有价值 --------------------编程问答-------------------- ADO.NET数据库操作
看看msdn和sqlhelper
--------------------编程问答-------------------- ADO.NET或者用最新的c#3.0 linq --------------------编程问答-------------------- 首先要先连接数据库,database,pwd,user_id,data sourse,还有sqlconnection,sqlcommand......
然后是对数据的查找、插入、删除、更新...的操作!慢慢学吧,我也是个小菜鸟! --------------------编程问答--------------------
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace RoomType.DAL.SQLServer
{
internal class DBHelper
{
private static readonly string connString=
ConfigurationManager.ConnectionStrings["HotelManageConnectionString"].ConnectionString;
public static DataSet ExecuteDataSet(string sql)
{
SqlDataAdapter sda = new SqlDataAdapter(sql,connString);
DataSet ds = new DataSet();
sda.Fill(ds, "HotelManage");
return ds;
}
public static SqlDataReader ExecuteDataReader(string sql, CommandType type, params SqlParameter[] ps)
{
SqlConnection connection = new SqlConnection(connString);
SqlCommand command = new SqlCommand(sql,connection);
command.CommandType = type;
if (ps != null)
command.Parameters.AddRange(ps);
connection.Open();
return command.ExecuteReader(CommandBehavior.CloseConnection);
}
public static int ExecuteNonQuery(string sql, CommandType type, params SqlParameter[] ps)
{
SqlConnection connection = new SqlConnection(connString);
SqlCommand command = new SqlCommand(sql, connection);
command.CommandType = type;
if (ps != null)
command.Parameters.AddRange(ps);
connection.Open();
int i = command.ExecuteNonQuery();
connection.Close();
return i;
}
public static object ExecuteScalar(string sql, CommandType type, params SqlParameter[] ps)
{
SqlConnection connection = new SqlConnection(connString);
SqlCommand command = new SqlCommand(sql, connection);
command.CommandType = type;
if (ps != null)
command.Parameters.AddRange(ps);
connection.Open();
object obj = command.ExecuteScalar();
connection.Close();
return obj;
}
}
}
给你一个帮助类!这个类就是对在C#中如何对数据的更新,修改,删除,插入 --------------------编程问答-------------------- 先看ADO.NET吧 --------------------编程问答-------------------- 不错,楼上很详细! --------------------编程问答-------------------- 嗯,建议先看看ADO.NET,然后再用一下,就很清楚了。 --------------------编程问答-------------------- 我一般是这么写的
//连接数据库
SqlConnection connection = new SqlConnection(“…………”);
connection.Open();
//定义SQL语句
string sql = "SELECT * from ...";
//执行SQL语句
SqlCommand cmd = new SqlCommand(sql, connection);
//填充数据集
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
connection.Close();
--------------------编程问答-------------------- 给个连接数据库“删”的实例给你,大都都是这个格式,照这个套就是了。
public static bool DeleteIncomeToDatabase(int DeleteNum)
{
SqlConnection con = new SqlConnection(_ConString);
try
{
//连接数据库中
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
cmd.CommandText = string.Format("delete from U" + _LogedUserName + "Income where Num={0}", DeleteNum);
cmd.ExecuteNonQuery();
return true;
}
catch (Exception)
{
return false;
}
finally
{
//关闭连接
con.Close();
}
}
【如果我的答复对你有所帮助,请到下列地址http://download.csdn.net/source/2247484 下载原创家庭记账软件,并给出宝贵意见!】 --------------------编程问答-------------------- 看看MSDN上的SqlConnection, SqlCommand, SqlDataAdapter对象以及相关例子,这是sql server数据,其他的数据库,可以看看oledconnection...或者oracleconnecion, odbcconnection..等 --------------------编程问答-------------------- 啥也不说了,接分 --------------------编程问答-------------------- 楼上几位的代码不错,lz可以参考下 --------------------编程问答-------------------- 看看这个帖子吧:
[img=http://topic.csdn.net/u/20100515/20/e78ec082-8c7d-42a0-a5c9-30be285be57e.html][/img] --------------------编程问答-------------------- http://topic.csdn.net/u/20100515/20/e78ec082-8c7d-42a0-a5c9-30be285be57e.html
补充:.NET技术 , C#