我如何执行SQL语句？ [英] How do I execute an SQL statement?

问题描述

我很新的节目，自学习的大部分。希望有人可以给我建议在codeS。

基本上，我遇到的问题是，我的SQL语句不执行从我的数据库retrive的数据。它只是分配userPermissionsOne与SELECT MemberOne FROM aspnet_Users WHERE MemberOne LIKE'的 _ 的'。

任何帮助非常多AP preciated。

 的userName = User.Identity.Name;
的userName = userName.ToUpper（）;
selectedUserName = betDropDownList.SelectedValue;
userPermissionsOne =SELECT MemberOne FROM aspnet_Users WHERE MemberOne LIKE'___';
userPermissionsTwo =SELECT MemberTwo FROM aspnet_Users WHERE MemberTwo LIKE'___';
userPermissionsThree =SELECT MemberThree FROM aspnet_Users WHERE MemberThree LIKE'___';如果（的String.Compare（用户名，selectedUserName，真）== 0 || User.IsInRole（管理员））
{
    hinzufugenButton.Enabled = TRUE;
    loschenButton.Enabled = TRUE;
    bearbeitenButton.Enabled = TRUE;
    betDropDownList.Enabled = TRUE;
}
否则，如果（用户名==ENL）
{
    如果（的String.Compare（userPermissionsOne，selectedUserName，真）== 0 ||
        的String.Compare（userPermissionsTwo，selectedUserName，真）== 0 ||
        的String.Compare（userPermissionsThree，selectedUserName，真）== 0）
    {
        hinzufugenButton.Enabled = TRUE;
        loschenButton.Enabled = TRUE;
        bearbeitenButton.Enabled = TRUE;
    }
    其他
    {
        hinzufugenButton.Enabled = FALSE;
        loschenButton.Enabled = FALSE;
        bearbeitenButton.Enabled = FALSE;
        betDropDownList.Enabled = FALSE;
    }
}
 

解决方案

您有很多在如何与.NET执行SQL语句的选项。阅读上对于初学者以下。这是前三个技术决定如何访问数据库时，我通常认为：

• ADO.NET


• 小巧玲珑


• 实体框架

从微软：

  

ADO.NET提供的.NET中的数据访问的最直接的方法
  框架。对于更高层次的抽象，允许应用程序
  对工作的概念模型，而不是底层存储
  型号，请参阅ADO.NET实体框架。

最近，我去到技术，数据库访问是小巧玲珑。它是快速，轻巧，和滑动方便code。与。

I am very new to programming, self-learnt most of it. hope someone can give me advice on the codes.

basically, the problem I am having is that my SQL statement does not execute to retrive the data from my database. it just assigns userPermissionsOne with SELECT MemberOne FROM aspnet_Users WHERE MemberOne LIKE '_'.

Any help is very much appreciated.

userName = User.Identity.Name;  
userName = userName.ToUpper();  
selectedUserName = betDropDownList.SelectedValue;  
userPermissionsOne = "SELECT MemberOne FROM aspnet_Users WHERE MemberOne LIKE '___'";  
userPermissionsTwo = "SELECT MemberTwo FROM aspnet_Users WHERE MemberTwo LIKE '___'";  
userPermissionsThree = "SELECT MemberThree FROM aspnet_Users WHERE MemberThree LIKE '___'";  

if (string.Compare(userName, selectedUserName, true) == 0 || User.IsInRole("Administrator"))
{
    hinzufugenButton.Enabled = true;
    loschenButton.Enabled = true;
    bearbeitenButton.Enabled = true;
    betDropDownList.Enabled = true;
}
else if (userName == "ENL")
{
    if (string.Compare(userPermissionsOne, selectedUserName, true) == 0 ||
        string.Compare(userPermissionsTwo, selectedUserName, true) == 0 ||
        string.Compare(userPermissionsThree, selectedUserName, true) == 0)
    {
        hinzufugenButton.Enabled = true;
        loschenButton.Enabled = true;
        bearbeitenButton.Enabled = true;
    }
    else
    {
        hinzufugenButton.Enabled = false;
        loschenButton.Enabled = false;
        bearbeitenButton.Enabled = false;
        betDropDownList.Enabled = false;
    }
}

解决方案

You have a lot of options in how to execute a SQL statement with .NET. Read up on the following for starters. These are the first three technologies I usually consider when deciding how to access the database:

• ADO.NET
• Dapper
• Entity Framework

From Microsoft:

ADO.NET provides the most direct method of data access within the .NET Framework. For a higher-level abstraction that allows applications to work against a conceptual model instead of the underlying storage model, see the ADO.NET Entity Framework.

Lately, my go-to technology for database access is Dapper. It is fast, lightweight, and plain convenient to code with.

这篇关于我如何执行SQL语句？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！