Select specific row in SQL Server

Question

I´m starting to develop in C# and SQL Server, I don´t know how to extract information from one excel specific colum.

I have this code working, but what i need it´s to compare a textbox with a specific column and get the data:

Example

Select * 
From T_Empleado 
Where "Specific column" = "textbox".

public void mostrarExcel()
{
    String name = "Sheet1";
    String constr = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + "C:\\Users\\alegriad\\Desktop\\sample\\Book2.xlsx" + "; Extended Properties='Excel 12.0 XML;HDR=YES;';";

    OleDbConnection con = new OleDbConnection(constr);
    OleDbCommand oconn = new OleDbCommand("Select * From [" + name + "$]'", con);
    con.Open();

    OleDbDataAdapter sda = new OleDbDataAdapter(oconn);
    DataTable data = new DataTable();
    sda.Fill(data);
    dgv_Reporte.DataSource = data;
}//mostrarExcel

Thank you.

Because you have to make a select the information inside of the excel file and then look where´s equal to a specific field in a data base in SQL Server — Daniel Alegría
– Daniel Alegría, Commented Dec 19, 2016 at 22:08

Seminda · Accepted Answer · 2016-12-20 05:17:52Z

1

You can write your query like this

 OleDbCommand oconn = new OleDbCommand("Select * From [" + name + "$] where columnName = '"+ YourTextboxValue+ "'" , con);

I try with sample excel like below

And my query like this

 OleDbCommand oconn = new OleDbCommand("Select * From [" + name + "$] WHERE Name = 'T1'", con);

This works for me.

edited Dec 20, 2016 at 5:17

answered Dec 19, 2016 at 22:55

Seminda

1,77312 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Daniel Alegría Over a year ago

columName it´s the header of the column in the excel file, already try that way but didin´t work either :D

Daniel Alegría Over a year ago

I try it again, and that work, THANK YOU SO MUCH :DD

Collectives™ on Stack Overflow

Select specific row in SQL Server

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related