如何获取表中特定列的长度 [英] How to get length of a specific column in a table
问题描述
我试图获取表中特定列的长度,该表来自Visual Studio C#表单应用程序中名为 Users
的数据库.首先,我知道它与 column.length
命令有关,但是由于搜索了这些示例,所以我迷路了.
I am trying to get the length of a specific column in a table which table is from a database called Users
in a visual studio C# form application. First of all i know it has to do with the column.length
command but since those examples i have a searched i got lost.
有人可以告诉我一种简单的方法来实现这一目标吗?对于更具体的信息,我有一个名为 user_info
的表,它包含一个名为 searches
的列.我想将搜索的长度计入单个变量
Can someone tell me a simple way to get this happen? For more specific information i have a table called user_info
and it contains a column which name is searches
. I want to get the length of searches into a single variable
推荐答案
这是从数据库中提取列大小所需的C#代码.确保更新connString变量以包含您自己的SQL Server连接字符串.
Here is the C# code that you need to pull the column size from the database. Make sure you update the connString variable to contain your own SQL server connection string.
示例:持久性安全信息= False;集成安全性= true;初始目录=罗斯文;服务器=(本地)"
Int32 columnSize = 0;
string sql = "SELECT CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'user_info' AND COLUMN_NAME = 'searches'";
string connString = "Your Sql Server Connection String";
using (SqlConnection conn = new SqlConnection(connString))
{
SqlCommand cmd = new SqlCommand(sql, conn);
try
{
conn.Open();
columnSize = (Int32)cmd.ExecuteScalar();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
这篇关于如何获取表中特定列的长度的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!