.NET 下用c#连接数据库 遇到的问题

来源:百度知道 编辑:UC知道 时间:2024/06/27 21:40:12
源码如下:
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;

namespace ConsoleApplication3
{
class Program
{
static void Main(string[] args)
{
try
{
SqlConnection mySqlConnection =
new SqlConnection(
"server = localhost;integrated security = SSPI;database = dzcw1"
);

SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
mySqlCommand.CommandText =
"SELECT ID,UserName" +
"FROM User_List" +
"WHERE UserName = 'epet'";

mySqlConnection.Open();

SqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();

mySqlCommand.CommandText =
"SELECT ID,UserName" +
"FROM User_List" +
"WHERE UserName = 'epet'";

应为:
mySqlCommand.CommandText =
"SELECT ID,UserName " +
" FROM User_List " +
" WHERE UserName = 'epet'";

注意空格(FROM WHERE 前面必须要有空格的。)

"SELECT ID,UserName FROM User_List WHERE UserName = 'epet'";
语句本身没有错
你确定在这里没有打错什么吗?
message是‘UuserName(在SQL语句中)’附近有语法错误。
UuserName是哪里的