Dataset not being filled
<p>the follwing functions gives me an error:    </p>

<pre><code>FillFields("select Housemcode,Name, HP,Rateperhour ,Resource_H_Code FROM House_Machinery where Housemcode like '" + sSearch + "'");


public void FillFields(string sSQL)
    {
        sCommands.setSqldbCommand(sVariables.sDataSet, sVariables.sSqlDbDataAdapter, sSQL, "House_Machinery");
        DataRow sDataRow = sVariables.sDataSet.Tables["House_Machinery"].Rows[0];
        txtItemName.Text = sDataRow["Name"].ToString();
        txtrate.Text = sDataRow["HP"].ToString();
        txtrate.Text = sDataRow["Rateperhour"].ToString();
        Variables.StrResourceHeaderCode = sDataRow["Resource_H_Code"].ToString();

    }
</code></pre>

<p>the error is:
There is no row at position 0.</p>

<p>can any one give an insight on this?</p>
