Select Data from sql

Please give your table details and what you need from this table.

Or you can try this

select * from Product p where p.Id=1

I think you can got your Answer

Assuming That you are using SQL Server

using (SqlConnection cn = new SqlConnection(ConnectionString))
{
  cn.Open();

  SqlCommmand cmd = new SqlCOmmand();
  cmd.Connection = cn;
  cmd.commandText = "select * from Table where ProductID in {@value1, @value2, @value3}";
  cmd.parameters.Add(new SqlParameter("@value1", SqlDbType.Int).Value = 1;
  cmd.parameters.Add(new SqlParameter("@value2", SqlDbType.Int).Value = 2;
  cmd.parameters.Add(new SqlParameter("@value3", SqlDbType.Int).Value = 3;

  SqlDataReader rdr = cmd.ExecuteReader();
}

I would uses these as a reference

SQL Server Data Type Mappings[^]
SqlCommand Class[^]

if you are using sql server and you have connected to the server you can set a sql command like


select * from Whatever where ID = '1'


if you want to select from multiple tables it would look something like this


select * from whatever s, whoever d where s.id = d.id and s.id = '1'

if you are more used to innerjoint then id suggest you use that,


a way to connect to sql ... this is not usually the way i would connect but it helps to see if your sql is correct with the table also created correct

using System.Data.SqlClient;
using System.Data.Sql;


//Creating connection to local database (connection should be converted to vpn database connection)
SqlConnection cn = new SqlConnection(@"Data Source = " + connection + "; Initial Catalog = whatever; Integrated Security = True");

//Opening connection to local database (connection should be converted to vpn database connection)
cn.Open();

// creating statement o be called in sql
SqlCommand cmd = new SqlCommand("select * from whatever s, whoever d where s.id = d . id and s.id = '1'", cn);


SqlDataAdapter sqlDataAdap = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

sqlDataAdap.Fill(ds, "ss");
datagridview.DataSource = ds.Tables["ss"];

datagridview.Columns[2].Visible = false;
datagridview.Columns[3].Visible = false;

cn.Close();

like i said ... not the best way to connect depending on what you want to do ... also your select should be close to the way you created your table .... e.g.

create table whatever
(
1 varchar(100) not null, // this wil be a string input e.g 'anything' [select * from whatever where 1 = 'anything']
)

insert into whatever values ('anything')

this is a int

create table whatever
(
test int not null
)

insert into whatever values (1)

select * from whatever where test = 1

SELECT * FROM Table WHERE ProductId LIKE '1%'

SELECT * FROM tablename WHERE ProductID = 1