VS2008窗体应用程序，链接数据库之后，怎样使用SQL语句。

你是不是想把结果显示在表格里面？还是读取数据就行了？给你个例子

public void ReadDataToDataSet()

{

string connString =

@"Data Source=localhost\SQLEXPRESSInitial Catalog=SampleIntegrated Security=True"

SqlConnection conn = new SqlConnection(connString)

string SQL = "Select * from table1"

SqlDataAdapter adapter = new SqlDataAdapter(SQL, conn)

// 创建DataSet，用于存储数据.

DataSet testDataSet = new DataSet()

// 执行查询，并将数据导入DataSet.

adapter.Fill(testDataSet, "result_data")

conn.Close()

// 处理DataSet中的每一行数据.

foreach (DataRow testRow in testDataSet.Tables["result_data"].Rows)

{

Console.WriteLine("NO:{0} Date:{1} Money:{2} ",

testRow["NO"], testRow["SALE_DATE"], testRow["SUM_MONEY"]

)

}

还有一个用sqldataread的例子：

public void ReadDataByReader()

{

Console.WriteLine("使用DataReader，逐行对查询结果进行处理。[处理过程必须保持数据库连接正常]")

SqlConnection conn = new SqlConnection(connString)

conn.Open()

SqlCommand testCommand = conn.CreateCommand()

testCommand.CommandText = SQL

// 执行SQL命令，结果存储到Reader中.

SqlDataReader testReader = testCommand.ExecuteReader()

// 处理检索出来的每一条数据.

while (testReader.Read())

{

Console.WriteLine("NO:{0} Date:{1} Money:{2} ",

testReader["NO"], testReader["SALE_DATE"], testReader["SUM_MONEY"]

)

}

testReader.Close()

conn.Close()

}

用vs2008 只会写C#的。。

C++不会啊

这是我C#的更新 *** 作

public void EditAccount(Account bankAccount)

{

StringBuilder strSql = new StringBuilder()

strSql.Append("update BankAccount set ")

strSql.Append("AccountName=@AccountName,")

strSql.Append("CurrentAmount=@CurrentAmount,")

strSql.Append("IsCanceled=@IsCanceled")

strSql.Append(" where CardNo=@CardNo ")

SqlParameter[] parameters = {

new SqlParameter("@AccountName", SqlDbType.NVarChar,1024),

new SqlParameter("@CurrentAmount", SqlDbType.Decimal,9),

new SqlParameter("@IsCanceled", SqlDbType.Bit,1),

new SqlParameter("@CardNo", SqlDbType.NVarChar,100)}

parameters[0].Value = bankAccount.Cname

parameters[1].Value = bankAccount.Csum

parameters[2].Value = bankAccount.Cfreeze

parameters[3].Value = bankAccount.Cid

using (SqlConnection connection = new SqlConnection(connectionString))

{

using (SqlCommand cmd = new SqlCommand())

{

try

{

cmd.CommandType = CommandType.Text

connection.Open()

cmd.Connection = connection

cmd.CommandText = strSql.ToString()

foreach (SqlParameter parameter in parameters)

{

cmd.Parameters.Add(parameter)

}

int rows = cmd.ExecuteNonQuery()

cmd.Parameters.Clear()

}

catch (System.Data.SqlClient.SqlException e)

{

throw e

}

}

}

}

---