易截截图软件、单文件、免安装、纯绿色、仅160KB

帮我指点下SQL SERVER数据库链接问题,谢谢!

C# code:
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace Security
{

public class ValidateBase : System.Web.UI.Page
{
private string sqlConnStr;
private SqlConnection conn;
public ValidateBase()
{
this.sqlConnStr = "Data Source=192.168.1.102;Initial Catalog=didian_data;User=sa;Password=sa;";
}
public ValidateBase(string connStr)
{
this.sqlConnStr = connStr;
}
private void Open()
{
if (this.conn == null)
this.conn = new SqlConnection(this.sqlConnStr);
if (this.conn.State == ConnectionState.Closed)
this.conn.Open();
}
private void Close()
{
if (this.conn.State == ConnectionState.Open)
this.conn.Close();
if (this.conn != null)
this.conn.Dispose();
this.conn = null;
}
public void BuildParameters(SqlParameter[] param, ref SqlCommand comm)
{
//若参数不为空,则添加到命令对象
if (param != null


相关问答:

sql 问题

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......

SQL字段,横向展开

请问各位,如何将SQl中,某字段中的值横向展开呢,
CASE WHEN

具体问题具体分析,看你要怎么展开

姓名  科目      成绩
张三  英语    90
李四  英语&nb ......

C# 连接SQL数据库常用的连接字符串该如何写?

(1)string ConnString = "server=localhost;integrated security=sspi;database=pubs;";   
(2)string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......

dbf表导入到sql server2000表问题

请问:
1,如何将一张dbf表导入到sql server2000中的一张表。使用DTS该怎样实现?
2,使用网上代码:
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......

如何调试或输出带SqlParameter的sql语句?

如何调试或输出带SqlParameter的sql语句?
UP

调用存储过程,设置ParameterDirection.Output参数
exec运行sql语句,返回sql语句

设置断点,按 F11 单步跟踪..

ParameterDirection.Output
这个才对吧 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号