What is the C # equivalent of the "PHP sql_fetchrow" function and the following code?

Question

The following PHP code needs to be converted to C#.
Is there anyone who can provide me with a response in the form of output?

Thanks

Answer 1

if you want to consume some sql database you can use the different objects into System.Data name space
for example to retrieve some data you can use a sqlcommand and call the execute reader method its similar to use sql_fetchrow

command.ExecuteReader

example:
private static void ReadOrderData(string connectionString)
{
string queryString =
"SELECT OrderID, CustomerID FROM dbo.Orders;";
using (SqlConnection connection = new SqlConnection(
connectionString))
{
SqlCommand command = new SqlCommand(
queryString, connection);
connection.Open();
using(SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}",
reader[0], reader[1]));
}
}
}
}

please check the following documentatio for more info https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlcommand?view=dotnet-plat-ext-6.0