App_Code/chaxun.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

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;

/// <summary>
/// Chaxun 的摘要说明,用于取值
/// </summary>
public class Chaxun
{
    SqlConnection connection1;
    SqlCommand command1;
    SqlDataReader datareader1;
    
	public Chaxun()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
        connection1 = new SqlConnection();
        command1 = new SqlCommand();
	}
    public string chazhao(string text) {
        string a="0";
        connection1.ConnectionString = "Data Source=.;Initial Catalog=information;Integrated Security=True";
        command1.CommandText = text;
        command1.Connection=connection1;
        connection1.Open();
        datareader1 = command1.ExecuteReader();
        if (datareader1.Read())
        {
            for (int i = 0; i <= datareader1.FieldCount - 1; i++)
               a= Convert.ToString(datareader1.GetValue(i));
           connection1.Close();

        }
        else
        { a= "-1";
        connection1.Close();
    }
        return a;

    }
}