using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Linq;
using System.Text;namespace GPSdata0617_Data
{
class ReadSqlServerData
{
private const String connString =
@"Data Source=121.**.***.***;Initial Catalog=GPSdata;Integrated Security=True";
private const String SQL =
@"
SELECT
TOP 3
ROW_NUMBER() OVER (ORDER BY GpsDateTime DESC) AS NO
FROM
GPSdata0617_Data
GROUP BY
VehicleID
ORDER BY
GpsDateTime DESC";
private const String DATATABLE_XML_FILE = "datatable.xml";
private const String DATATABLE_SCHEMA_XML_FILE = "datatable_schema.xml";
public void ReadDataToDataSet()
{
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter adapter = new SqlDataAdapter(SQL, conn);
DataSet testDataSet = new DataSet();
adapter.Fill(testDataSet, "result_data");
conn.Close();
foreach (DataRow testRow in testDataSet.Tables["result_data"].Rows)
{
Console.WriteLine("NO:{0} ",
testRow["NO"]
);
}
testDataSet.Tables["result_data"].WriteXmlSchema(DATATABLE_SCHEMA_XML_FILE);
testDataSet.Tables["result_data"].WriteXml(DATATABLE_XML_FILE);
DataTable newDt = new DataTable();
newDt.ReadXmlSchema(DATATABLE_SCHEMA_XML_FILE);
newDt.ReadXml(DATATABLE_XML_FILE);
foreach (DataRow testRow in newDt.Rows)
{
Console.WriteLine("NO:{0} ",
testRow["NO"]
);
}
}
public void ReadDataByReader()
{
SqlConnection conn = new SqlConnection(connString);
conn.Open();
SqlCommand testCommand = conn.CreateCommand();
testCommand.CommandText = SQL;
SqlDataReader testReader = testCommand.ExecuteReader();
while (testReader.Read())
{
Console.WriteLine("NO:{0} ",
testReader["NO"]);
}
testReader.Close();
conn.Close();
}
}
}
程序报错了,但是不知道为什么,求助大神们帮帮忙看一下
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Linq;
using System.Text;namespace GPSdata0617_Data
{
class ReadSqlServerData
{
private const String connString =
@"Data Source=121.**.***.***;Initial Catalog=GPSdata;Integrated Security=True";
private const String SQL =
@"
SELECT
TOP 3
ROW_NUMBER() OVER (ORDER BY GpsDateTime DESC) AS NO
FROM
GPSdata0617_Data
GROUP BY
VehicleID
ORDER BY
GpsDateTime DESC";
private const String DATATABLE_XML_FILE = "datatable.xml";
private const String DATATABLE_SCHEMA_XML_FILE = "datatable_schema.xml";
public void ReadDataToDataSet()
{
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter adapter = new SqlDataAdapter(SQL, conn);
DataSet testDataSet = new DataSet();
adapter.Fill(testDataSet, "result_data");
conn.Close();
foreach (DataRow testRow in testDataSet.Tables["result_data"].Rows)
{
Console.WriteLine("NO:{0} ",
testRow["NO"]
);
}
testDataSet.Tables["result_data"].WriteXmlSchema(DATATABLE_SCHEMA_XML_FILE);
testDataSet.Tables["result_data"].WriteXml(DATATABLE_XML_FILE);
DataTable newDt = new DataTable();
newDt.ReadXmlSchema(DATATABLE_SCHEMA_XML_FILE);
newDt.ReadXml(DATATABLE_XML_FILE);
foreach (DataRow testRow in newDt.Rows)
{
Console.WriteLine("NO:{0} ",
testRow["NO"]
);
}
}
public void ReadDataByReader()
{
SqlConnection conn = new SqlConnection(connString);
conn.Open();
SqlCommand testCommand = conn.CreateCommand();
testCommand.CommandText = SQL;
SqlDataReader testReader = testCommand.ExecuteReader();
while (testReader.Read())
{
Console.WriteLine("NO:{0} ",
testReader["NO"]);
}
testReader.Close();
conn.Close();
}
}
}
程序报错了,但是不知道为什么,求助大神们帮帮忙看一下
程序“C:\Users\Administrator\Documents\Visual Studio 2008\Projects\ConsoleApplication4\ConsoleApplication4\obj\Debug\ConsoleApplication4.exe”不包含适合于入口点的静态“Main”方法
去加个main方法,程序问题了。