hi
i used my code in below way it works fine..
i missed using
using (LQTransSeaFreightDataContext DB = new LQTransSeaFreightDataContext())
once included it works gud..
thanks for all who helped me
public void BindLCLGrid()
{
try
{
UPLCL.Update();
string SFRID = TXTSRFID.Text;
using (LQTransSeaFreightDataContext DB = new LQTransSeaFreightDataContext())
{
var LCL = from C in DB.TB_TransSeaLCLs
where C.tSLC_NUIsActive == 1 && C.tSLC_tSEA_NUPKId == mobjGenlib.ConvertInt(SFRID)
select new { tSLC_NUPKId = C.tSLC_NUPKId, tSLC_tSEA_NUPKId = C.tSLC_tSEA_NUPKId, tSLC_VCVolume = C.tSLC_VCVolume, tSLC_mUOM_NUPKId = C.tSLC_mUOM_NUPKId, tSLC_VCBuyRate = C.tSLC_VCBuyRate, tSLC_VCSellRate = C.tSLC_VCSellRate };
dgLCL.DataSource = LCL;
dgLCL.DataBind();
}
}
catch (Exception ex)
{
}
}