从数据库获取名称 [英] get name from database

问题描述

我如何显示此查询的输出到文本框

Me.KasriTableAdapter.Adapter.SelectCommand.CommandText =从kasri中选择名称

其中id = 1"


我需要一个名称，其id = 1

并将其发送到文本框!!

how can i show this query''s output to a textbox

Me.KasriTableAdapter.Adapter.SelectCommand.CommandText = "SELECT name FROM kasri

where id=1"


i need a name that its id = 1

and send it to a text box !!

推荐答案

尝试此

try this

Con = new SqlConnection("Your Connection string ");
            Con.Open();
            Cmd = new SqlCommand("SELECT Name from kasri WHERE Id = @ID", Con);
            Cmd.Parameters.AddWithValue("@ID", ID);
            dr = Cmd.ExecuteReader();

            if (dr.Read())
            {
               strCountryName = dr["Name"].ToString();
            }

您也可以这样做

you also can do this

Con = new SqlConnection("Your Connection string ");
Con.Open();
Cmd = new SqlCommand("SELECT Name from kasri WHERE Id = @ID", Con);
Cmd.Parameters.AddWithValue("@ID", ID);
string strName = Cmd.ExecuteScalar();
strCountryName = strName.toString();

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