仅从数据库的列连接 [英] Connectivity of only column from database

问题描述

我的Emp表存储在sql server中，包括列ID，名称，年龄和地址。

我想在年龄为25的文本框中显示员工姓名。

如何为这样的任务连接数据库。

解决方案

这看起来像一个非常基本的问题。如果您不熟悉ADO.net，请阅读这些CP文章。

为初学者使用ADO.NET [ ^ ]

面向初学者的ADO.NET数据库操作 [ ^ ]

初学者理解ADO.NET的教程 [ ^ ]

Hi


您可以使用下面的m管理数据库的方法：

公共类DBManagement 
 {
 public SqlConnection OpenConnection（）
 {
 string connectionString =Data Source = [ServerName];初始目录= [DatabaseName];用户ID = [SqlUserName];密码= [SqlUserPassword]; 
 
 SqlConnection connection = null; 
 
 try 
 {
 connection = new SqlConnection（connectionString）; 
 connection.Open（）; 
} 
 catch 
 {
 Console.WriteLine（DataBase无法访问......）; 
} 
 
返回连接; 
 
} 
 
 public DataTable Execute（string queryString）
 {
 SqlConnection connection = OpenConnection（）; 
 
 SqlCommand query = new SqlCommand（queryString，connection）; 
 
 DataTable resultTable = new DataTable（）; 
 
 SqlDataAdapter adopter = new SqlDataAdapter（query）; 
 
 adopter.Fill（resultTable）; 
 
 connection.Close（）; 
 
返回resultTable; 
} 
} 

现在你可以从DBManagement创建实例并通过send调用execute方法bellow string az查询：

 string query =从YourTableName中选择姓名，其中年龄= 25; 
 DBManagement manage = new DBManagement（）; 
 
 DataTable result = manage.Execute（query）; 

我希望它有用。

My Emp table is stored in sql server which consist of columns ID,Name,Age & adress.
I want to Display the name of employee in textboxes whose age is 25.
how shoul I connect the database for such a task.

解决方案

This looks like a very basic question. If you are not familiar with ADO.net go through these CP articles.
Using ADO.NET for beginners[^]
Database Manipulation with ADO.NET for beginners[^]
A Beginner''s Tutorial for Understanding ADO.NET[^]

Hi
You can Use from bellow method for manage Database:

public class DBManagement
{
    public SqlConnection OpenConnection()
    {
        string connectionString = "Data Source = [ServerName]; Initial Catalog = [DatabaseName]; User ID = [SqlUserName]; Password = [SqlUserPassword]";

        SqlConnection connection = null;

        try
        {
            connection = new SqlConnection(connectionString);
            connection.Open();
        }
        catch
        {
            Console.WriteLine("DataBase is not reachable....");
        }

        return connection;

    }

    public DataTable Execute(string queryString)
    {
        SqlConnection connection = OpenConnection();

        SqlCommand query = new SqlCommand(queryString, connection);

        DataTable resultTable = new DataTable();

        SqlDataAdapter adopter = new SqlDataAdapter(query);

        adopter.Fill(resultTable);

        connection.Close();

        return resultTable;
    }
}

Now you can create instance from DBManagement and call execute method by send bellow string az query:

string query = "Select Name From YourTableName Where Age = 25";
DBManagement manage = new DBManagement();

DataTable result = manage.Execute(query);

I hope it''s helpful.

这篇关于仅从数据库的列连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！