两个程序的连接！

Question

// "uid=sa":连接数据库的用户名为sa.
            // "password=":连接数据库的验证密码为空.他的别名为"pwd",所以我们可以写为"pwd=".
            // "initial catalog=Northwind":使用的数据源为"Northwind"这个数据库.他的别名为"Database",本句可以写成"Database=Northwind".
            // "Server=YourSQLServer":使用名为"YourSQLServer"的服务器.他的别名为"Data Source","Address","Addr".
            // " Connect Timeout=30":连接超时时间为30秒.(根据情况添加)
            // PS:
            //  1.你的SQL Server必须已经设置了需要用户名和密码来登录,否则不能用这样的方式来登录.如果你的SQL Server设置为Windows登录,那么在这里就不需要使用"uid"和"password"这样的方式来登录,而需要使用"Trusted_Connection=SSPI"来进行登录.
            //  2. 如果使用的是本地数据库且定义了实例名,则可以写为"Server=(local)\实例名";如果是远程服务器,则将"(local)"替换为远程服务器的名称或IP地址.
            string strConnection = "Trusted_Connection=SSPI;";
            strConnection += "database=NTF_Navision_enlistment60;Server=CAIXIATA-6BE823;";
            strConnection += "Connect Timeout=30";

Answer 1

 <add connectionString="Provider=SQLOLEDB;server=.;database=tanda;uid=tanda;pwd=123456" name="con" /> 
  </connectionStrings>在web.config

Answer 2

直接在程序中写啊
  public class DBM
    {
        /// <summary>
        /// 返回连接
        /// </summary>
        public static SqlConnection Conn
        {
            get
            {
               //return new SqlConnection(@"server=192.168.1.104\sqlexpress;uid=sa;pwd=123;database=BSCYDZ");
                return new SqlConnection(@"server=.\sqlexpress;uid=sa;pwd=main;database=BSCYDZ");
            }
        }        /// <summary>
        /// 单表查询操作
        /// </summary>
        /// <param name="sql">Select语句</param>
        /// <returns></returns>
        public static DataTable getTable(string sql)
        {
            SqlDataAdapter dap = new SqlDataAdapter(sql, DBM.Conn);
            DataTable dt = new DataTable();
            dap.Fill(dt);
            return dt;
        }
        /// <summary>
        /// 多表查询操作
        /// </summary>
        /// <param name="sql">Select语句</param>
        /// <returns></returns>
        public static DataSet getDataSet(string sql)
        {            SqlDataAdapter dap = new SqlDataAdapter(sql, DBM.Conn);
            DataSet ds = new DataSet();
            dap.Fill(ds);
            return ds;
        }        /// <summary>
        /// 单表分页查询
        /// </summary>
        /// <param name="sql">Select语句</param>
        /// <param name="start">开始</param>
        /// <param name="size">个数</param>
        /// <returns></returns>
        public static DataTable getTable(string sql, int start, int size)
        {            SqlDataAdapter dap = new SqlDataAdapter(sql, DBM.Conn);
            DataSet ds = new DataSet();
            dap.Fill(ds, start, size, "tmp");
            return ds.Tables["tmp"];
        }
        /// <summary>
        /// 执行命令
        /// </summary>
        /// <param name="sql">Insert Update Delete语句</param>
        /// <returns></returns>
        public static int Execute(string sql)
        {
            SqlCommand cmd = new SqlCommand(sql, DBM.Conn);
            cmd.Connection.Open();
            SqlTransaction tran = cmd.Connection.BeginTransaction();
            cmd.Transaction = tran;
            try
            {
                int rows=  cmd.ExecuteNonQuery();
                tran.Commit();
                return rows;
            }
            catch
            {
                tran.Rollback();
                return 0;
            }
            finally
            {
                cmd.Connection.Close();
            }
        }        /// <summary>
        /// 调用存储过程(无结果集)
        /// </summary>
        /// <param name="mp"></param>
        /// <returns></returns>
        public static Exception CallProc(MakeParameter mp)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = mp.ProcName;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection = DBM.Conn;            for (int i = 0; i < mp.List.Count; i++)
            {
                cmd.Parameters.Add(mp.List[i]);
            }
            foreach (object key in mp.Table.Keys)
            {
                cmd.Parameters.Add(mp.Table[key]);
            }            cmd.Connection.Open();
            SqlTransaction tran = cmd.Connection.BeginTransaction();
            cmd.Transaction = tran;
            try
            {
                cmd.ExecuteNonQuery();
                tran.Commit();
            }
            catch (Exception ex)
            {
                tran.Rollback();
                return ex;
            }
            finally
            {
                cmd.Connection.Close();
            }            return null;
        }        /// <summary>
        /// 调用存储过程(有结果集)
        /// </summary>
        /// <param name="mp"></param>
        /// <returns></returns>
        public static DataSet CallProcWithDataSet(MakeParameter mp)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = mp.ProcName;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection = DBM.Conn;            for (int i = 0; i < mp.List.Count; i++)
            {
                cmd.Parameters.Add(mp.List[i]);
            }
            foreach (object key in mp.Table.Keys)
            {
                cmd.Parameters.Add(mp.Table[key]);
            }            SqlDataAdapter dap = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();            try
            {                dap.Fill(ds);            }
            catch
            {
            }
            finally
            {
                if (cmd.Connection.State != ConnectionState.Closed)
                    cmd.Connection.Close();
            }            return ds;
        }    }
public class MakeParameter
    {
        private ArrayList list;
        private Hashtable table;
        private string procname;
        
        //DAO写DBM读
        /// <summary>
        /// 存储过程名
        /// </summary>
        public string ProcName
        {
            get
            {
                return procname;
            }
            set
            {
                procname = value;
            }
        }        public MakeParameter(string procName):this()
        {
            this.procname = procName;
        }
        public MakeParameter()
        {
            list = new ArrayList();
            table = new Hashtable();
            SqlParameter para = new SqlParameter("@tmp", SqlDbType.Int);
            para.Direction = ParameterDirection.ReturnValue;
            list.Add(para);
        }        //DAO写
        /// <summary>
        /// 增加输入参数
        /// </summary>
        /// <param name="name"></param>
        /// <param name="value"></param>
        public void addInputParameter(string name, object value)
        {
            SqlParameter para = new SqlParameter(name, value);
            list.Add(para);
        }
        /// <summary>
        /// 增加输出参数
        /// </summary>
        /// <param name="name"></param>
        /// <param name="type"></param>
        /// <param name="size"></param>
        public void addOutputParameter(string name, SqlDbType type, int size)
        {
            SqlParameter para = new SqlParameter(name, type, size);
            para.Direction = ParameterDirection.Output;
            table.Add(name, para);
        }
        //DBM读
        /// <summary>
        /// 得到参数据列表
        /// </summary>
        public ArrayList List
        {
            get
            {
                return list;
            }
        }
        /// <summary>
        /// 得到输出参数 DBM用
        /// </summary>
        public Hashtable Table
        {
            get
            {
                return table;
            }
        }
        //DAO读
        /// <summary>
        /// 获得返回值
        /// </summary>
        /// <returns></returns>
        public object getReturnValue()
        {
            SqlParameter para = (SqlParameter)list[0];
            return para.Value;
        }
        /// <summary>
        /// 获得输出值 DAO读取
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public object getOutputValue(string name)
        {
            SqlParameter para = (SqlParameter)table[name];
            return para.Value;
        }
             
        //执行调用 DAO调用
        public Exception Execute()
        {
            
            return DBM.CallProc(this);
        }        public DataSet ExecuteWithDataSet()
        {
            
            return DBM.CallProcWithDataSet(this);
        }
    }