没分见谅,但是问题太奇怪,想得到各位支持,多谢了.
一个客户有SQL SERVER 2000数据库,已经打了SP4,有一表,表内一字段为DATETIME,我在客户那用SQL SERVER 的企业管理器查询数据都没问题,比如一条记录那个日期字段显示为"2012-11-16 23:59:59".
现在我写了一个WEBSERVICE,具体代码如下:
public SqlConnection connect_db(string con_str)
{
SqlConnection db_con = new SqlConnection();
db_con.ConnectionString = con_str;
try
{
db_con.Open();
}
catch
{
db_con = null;
}
return db_con;
}
public System.Data.DataSet get_data(SqlConnection con_db, string sql_str, string table_name)
{
System.Data.DataSet ds = new System.Data.DataSet();
try
{
SqlDataAdapter mydata = new SqlDataAdapter(sql_str, con_db);
mydata.Fill(ds, table_name);
}
catch
{
ds = null;
}
return ds;
}
[WebMethod]
public System.Data.DataSet get_pos(string pj)
{
System.Data.DataSet ds = new System.Data.DataSet();
SqlConnection db_con = new SqlConnection();
db_con.ConnectionString="server="+dbsource+";database="+dbname+";integrated security=SSPI";
try
{