public RoadGuide GetRoadByID(string Road_ID)
{
using (SqlConnection sqlConn = new SqlConnection(connectionString))
{
using (SqlCommand sqlCmd = sqlConn.CreateCommand())
{
sqlCmd.CommandText = "Select * from Road where Road_ID = @Road_ID";
sqlCmd.Parameters.AddWithValue("@Road_ID", Road_ID);
RoadGuide roads = new RoadGuide();
sqlConn.Open();
using (SqlDataReader sqlDR = sqlCmd.ExecuteReader())
{
while (sqlDR.Read())
roads = GetRoadGuideInfo(sqlDR);
if (sqlDR != null)
sqlDR.Close();
}
return roads;
}
}
}
public RoadGuide GetRoadGuideInfo(SqlDataReader sqlDR)
{
RoadGuide row = new RoadGuide();
row.Road_ID = (sqlDR["Road_ID"]).ToString();
row.Name = (sqlDR["Name"]).ToString();
row.Code = (sqlDR["Code"]).ToString();
row.Mnemocode = (sqlDR["Mnemocode"]).ToString();
return row;
}