Database

SELECT TOP(1) * FROM (
SELECT TOP(2) StartTime FROM dbo.RunSummary ORDER BY StartTime DESC
) T ORDER BY StartTime

Syafiqah Zahirah wrote:

what can I do?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

select max(Actuators.Date)
from table1
where Actuators.Date<(select max(Actuaors.Date) from t1);

AshwiniSH wrote:

Can anyone please provide me the connection string?

AshwiniSH wrote:

1. domain is created in my server.
2. Remote access is enabled for the sql server
3. TCP/IP port is also enabled.

From link[^]:

Basically, when you failed to connect to your SQL Server, the issue could be:
1) Network issue,
2) SQL Server configuration issue.
3) Firewall issue,
4) Client driver issue,
5) Application configuration issue.
6) Authentication and logon issue.

AshwiniSH wrote:

I am struggling for this since 3 days.

SELECT  c.FINVNO
       ,c.FCUSTNO
       ,c.FCOMPANY
       ,c.FSALESPN
       ,c.FSHIPVIA
       ,c.FORDDATE
       ,c.FSHIPDATE
       ,c.FNTAXAMT
       ,(SELECT a.FADDR1 FROM ARCUS01.dbf a WHERE c.FCUSTNO = a.FCUSTNO) as FADDR1
FROM    ARINV01.dbf c
WHERE   c.FORDDATE=@startDate

SELECT  c.FINVNO
,c.FCUSTNO
,c.FCOMPANY
,c.FSALESPN
,c.FSHIPVIA
,c.FORDDATE
,c.FSHIPDATE
,c.FNTAXAMT
,(SELECT a.FADDR1 FROM ARCUS01.dbf a WHERE c.FCUSTNO = a.FCUSTNO) AS FADDR1
,(SELECT e.FEMAIL1 FROM ARCEM01.dbf e WHERE c.FCUSTNO = e.FCUSTNO) AS FEMAIL1
FROM ARINV01.dbf c
WHERE c.FORDDATE=@startDate

string sql = "SELECT House, DateT, TempIn, tempOut, Humidity FROM Environmnets INNER JOIN TDevice ON Environmnets.Deviceid = TDevice.id INNER JOIN TMushroomHouse ON TDevice.MushroomHouseId = TMushroomHouse.id WHERE (Environmnets.DateT = (SELECT MAX(DateT) AS Expr1 FROM Environmnets AS Environmnets_1)) AND TMushroomHouse.Name = @MushroomHouseName";

using (SqlConnection con = new SqlConnection(strConnString))
using (SqlCommand cmd = new SqlCommand(sql, con))
{
    cmd.Parameters.AddWithValue("@MushroomHouseName", DropDownList1.Text);
    
    con.Open();
    
    using (SqlDataReader dr = cmd.ExecuteReader())
    {
        while (dr.Read())
        {
            HouseTextBox.Text = dr["House"].ToString();
            DateTTextBox.Text = dr["DateT"].ToString();
            TempInTextBox.Text = dr["TempIn"].ToString();
            TempOutTextBox.Text = dr["tempOut"].ToString();
            HumidityTextBox.Text = dr["Humidity"].ToString();
        }
    }
}

WHERE (Environmnets.DateT = (SELECT MAX(DateT) AS Expr1 FROM Environmnets AS Environmnets_1))

SELECT TOP 1 House, DateT, TempIn, tempOut, Humidity FROM Environmnets INNER JOIN TDevice ON Environmnets.Deviceid = TDevice.id INNER JOIN TMushroomHouse ON TDevice.MushroomHouseId = TMushroomHouse.id WHERE TMushroomHouse.Name = @MushroomHouseName ORDER BY Environmnets.DateT DESC

SELECT TOP 1 House, DateT, TempIn, tempOut, Humidity, TMushroomHouse.Name As MushroomHouseName FROM Environmnets INNER JOIN TDevice ON Environmnets.Deviceid = TDevice.id INNER JOIN TMushroomHouse ON TDevice.MushroomHouseId = TMushroomHouse.id WHERE TMushroomHouse.Name = @MushroomHouseName ORDER BY Environmnets.DateT DESC

while (dr.Read())
{
    ...
    MushroomHouseTextBox.Text = dr["MushroomHouseName"].ToString();
}