数据库操作都在这里了,呵呵,用的多了自然就会了
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
/// <summary>
///Class1 的摘要说明
/// </summary>
public class DataBase
{
public DataBase()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
private static SqlConnection con = new SqlConnection();
private static SqlCommand cmd = new SqlCommand();
public static bool getConnection()
{
con.ConnectionString = "server=.;database=db_web;uid=sa;pwd=123";
try
{
con.Open();
return true;
}
catch (Exception ee)
{
return false;
}
}
public static int exeCmd(string str)
{
cmd.Connection = con;
cmd.CommandText = str;
try
{
return cmd.ExecuteNonQuery();
}
catch (Exception ee)
{
return -2;
}
}
public static int exeSqlDataReader(string str)
{
cmd.Connection = con;
cmd.CommandText = str;
try
{
return (Int32)(cmd.ExecuteScalar());
}
catch (Exception ee)
{
return 0;
}
}
public static string exeScalar(string str)
{
cmd.Connection = con;
cmd.CommandText = str;
try
{
return Convert.ToString(cmd.ExecuteScalar());
}
catch (Exception ee)
{
return null;
}
}
public static void closeConnection()
{
con.Dispose();
}
public static SqlDataAdapter getData(string str)
{
cmd.Connection = con;
cmd.CommandText = str;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
return sda;
}
public static DataTable getDataTable(string str)
{
cmd.Connection = con;
cmd.CommandText = str;
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
return dt;
}
}
---------------------- Windows Phone 7手机开发、.Net培训、期待与您交流! ----------------------详细请查看:http://net.itheima.com/