Read data from a column through C#

Question

Read data from a column through C#

Asked 8 years, 6 months ago

Viewed 881 times

-2

I have a postcode and divided into 2 variables: the first, where the first 4 numbers appear and the second where the last 3 appear.

Ex.:

4300-234 - first = 4300; second = 234.

I have a table in the database that has 3 columns referring to postal codes. A PC4, where the first 4 numbers appear, the PC3 where the last 3 and the Desc, where the corresponding description appears, that is, where these postal codes are from.

What I need is to compare my first variable with the column PC4, compare the second variable to the column PC3 and then when my variables are equal to the columns PC4 and PC3, I want to receive the corresponding data from the column DESC.

But at what point do you want to do it? Num query right in the bank? Run a query by its C# code using some ORM or the SqlCommand? Please be more specific.

– Jéf Bueno

2017/04/18 at 16:00
I want to do this in code c#

– D C

2017/04/18 at 16:02
It’s something I’ve never done, I’ve researched and I can’t figure out how to do

– D C

2017/04/18 at 16:03
1

Okay, it’s okay that you don’t know, but at least try a little bit to explain to us how do you want to do that.

– Jéf Bueno

2017/04/18 at 16:04
I tried to explain as best I could. I have 2 variables, variable1 has the first 4 numbers of the postal code, variable2 has the last 3. I need to compare variable1 with column PC4 and variable2 with PC3, when variable1 = PC4 and variable2 = PC3, I want to receive)

– D C

2017/04/18 at 16:08
Let’s try again. Do you know how to connect to the database? Your project already connects to the database?

– Jéf Bueno

2017/04/18 at 16:09
Yes, I have everything connected, I have already entered values in the database through the c# and everything.

– D C

2017/04/18 at 16:12
Okay, we got to the part I wanted. How do you input (and read) database data?

– Jéf Bueno

2017/04/18 at 16:13
through INSERT and SELECT

– D C

2017/04/18 at 16:14
Okay, okay, let’s try it again. What you do select and Insert I know, after all there’s no other natural way to do it. Now, what I want to know is: what code you use to make a select in the database?

– Jéf Bueno

2017/04/18 at 16:24
1

@Dc post the code, read this and rephrase the question https://answall.com/help/mcve, see that it is an official Help recommendation of the site and not mine. So you avoid your question being closed

– Guilherme Nascimento

2017/04/18 at 16:24
@jbueno the problem is this ! do not know how to formulate my code to make a select !

– D C

2017/04/18 at 16:26
@DC You already consult some data in the bank. Do not consult?

– Jéf Bueno

2017/04/18 at 16:27
@jbueno The only thing I did in this project was to enter data in the database

– D C

2017/04/18 at 16:28
And what code do you use to "enter data into the database"?

– Jéf Bueno

2017/04/18 at 16:30
Conn. Open(); Com.Commandtext = "INSERT INTO Table(column1, column2, ...) VALUES (value1, value2, ...)"; Com.Executenonquery(); Conn.Close();

– D C

2017/04/18 at 16:33

Show 11 more comments

1 answer

Browser other questions tagged c# sql-server

You are not signed in. Login or sign up in order to post.

by Diego Farias • **909** points · Answer 1 · 2017-04-18T23:14:59+00:00

This is an idea of how you can do, there are n ways to do it, I believe you can return some data to go testing.

Within select you can implement a WHERE clause where you will return only records that satisfy that condition. The comparison return I added in a variable, you can add in a list or do some operation if necessary.

In the comparison part I passed a type Int32 without knowing what is its value in fact, then you need to adapt the code to your need.

public void SelectDescricao()
{
    try
    {
        using(SqlConnection conn = new SqlConnection("Sua string de conexão"))
        {
             using (SqlCommand cmd = new SqlCommand("SELECT coluna1, coluna2, coluna3_Descricao FROM Tabela", conn))
             {
                cmd.CommandType = CommandType.CommandText;

                using (SqlDataReader rd = cmd.ExecuteReader())
                {
                    if (rd.HasRows)
                    {
                        while (rd.Read())
                        {
                            if( variavel1 == Convert.ToInt32(rd["coluna1"].ToString()) && variavel2  == Convert.ToInt32(rd["coluna2"].ToString()))
                            {
                                varDescricao = Convert.ToInt32(rd["coluna3_Descricao"].ToString());                                        
                            }
                        }
                    }
                }
            }  
        }                         
    }
    catch (SqlException ex)
    {
        // tratamento da exceção
    }
}