DBHelper类的编写

用sql语句来修改sa用户的登陆密码

分类:C#重要代码

方法１不要旧密码：

alter login sa with password='sa'
go

方法２：

exec sp_password  null, 'cw'
go

方法3:
windows验证登陆进入后,在登陆名下的sa属性里面直接可以改

登陆不进去，错误２２３，１８４５的解决办法

两个地方加重启

１服务器属性-安全性-sql server和windows身份验证模式

２登陆名下的sa属性-状态-登陆-启用

３然后把mssql server服务重启一下重要！！

2010.11.19 14:23 作者：chenwei 引用:0 | 收藏 | 评论：0

qq窗体抖动代码

分类:C#重要代码

            Random ran = new Random((int)DateTime.Now.Ticks);
            Point point = this.Location;
            for (int i = 0; i < 40; i )
            {
                this.Location = new Point(point.X ran.Next(8) - 4, point.Y ran.Next(8) - 4);
                System.Threading.Thread.Sleep(15);
                this.Location = point;
            }

2010.11.19 14:20 作者：chenwei 引用:0 | 收藏 | 评论：0

DBHelper类的编写

分类:C#编程

    public class DBHelper
    {
        //连接字符串,引用自app.config
        private static string connStr = ConfigurationSettings.AppSettings["CONNSTR"];
        static SqlConnection con;
        static SqlCommand cmd;

        public static void OpenDatabase()
        {
            con = new SqlConnection(connStr);
           if(con.State!=ConnectionSatte.OPen)
            con.Open();
        }

        private static void PrepareCmd(string strCmd, CommandType type, SqlParameter[] parms)
        {
            cmd = new SqlCommand();
            OpenDatabase();
            cmd.Connection = con;
            cmd.CommandType = type;
            cmd.CommandText = strCmd;
            if (parms != null)
            //cmd.Parameters.AddRange(parms));
            {
                foreach (SqlParameter sp in parms)
                {
                    if (sp != null)
                    {
                        cmd.Parameters.Add(sp);
                    }
                }
            }
        }

             *
             有连接的查询,他的connection对象是常打开的,要通过dataReader的read方法向数据库请求数据,
             * 也就是,每次用read方法他就找数据库 要一条数据,它是一种只进流的形式读取,每次都是往下读取,
             * 而不能返回读取.如果说他用read方法读取到了数据,那么将数据填充到dataReader对象里,并read方法返回true,
             * 否则dataReader对象中没有数据,read方法返回为false.
             *
             无连接查询它是用dataAdapter对象将此查询的所有记录一次性接收填充到dataset里,那么这里的connection对象在发送数据之后就可以关闭.
             *

        //返回dataReader对象
        public static SqlDataReader GetDataReader(string strCmd, CommandType cmdType, SqlParameter[] parms)
        {
            PrepareCmd(strCmd, CommandType.Text, parms);
            SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            return reader;
        }
        //增删改,没有返回结果.
        public static int ExecuteNoQuery(string strCmd, CommandType type, SqlParameter[] parms)
        {
            PrepareCmd(strCmd, CommandType.Text, parms);
            int result = cmd.ExecuteNonQuery();
            con.Close();
            return result;
        }
        //查询用,返回第一行的第一列数据   
        public static object GetScalar(string strCmd, CommandType cmdType, SqlParameter[] parms)
        {
            PrepareCmd(strCmd, CommandType.Text, parms);
            object result = cmd.ExecuteScalar();
            con.Close();
            return result;
        }

        //无连接查询,返回一个dataTable
        public static DataTable GetDataTable(string strCmd, CommandType type, SqlParameter[] parms)
        {
            PrepareCmd(strCmd, CommandType.Text, parms);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            con.Close();
            return ds.Tables[0];
        }

        //重载,1个参数时使用
        public static int ExecuteNoQuery(string strCmd)
        {
            return ExecuteNoQuery(strCmd,null) ;
        }

        public static object GetScalar(string strCmd)
        {
            return GetScalar(strCmd,null);
        }

        public static DataTable GetDataTable(string strCmd)
        {
            return GetDataTable(strCmd,null);
        }

        public static SqlDataReader GetDataReader(string strCmd)
        {
            return GetDataReader(strCmd,null);
        }

        //重载,2个参数时使用
       public static int ExecuteNoQuery(string strCmd, SqlParameter[] parms)
       {
          return ExecuteNoQuery(strCmd, CommandType.StoredProcedure, parms);
       }
       public static object GetScalar(string strCmd, SqlParameter[] parms)
       {
          return GetScalar(strCmd, CommandType.StoredProcedure, parms);
       }
       public static DataTable GetDataTable(string strCmd, SqlParameter[] parms)
       {
          return GetDataTable(strCmd, CommandType.StoredProcedure, parms);
       }

      public static SqlDataReader GetDataReader(string strCmd, SqlParameter[] parms)
       {
          return GetDataReader(strCmd, CommandType.StoredProcedure, parms);
       }