i have below query :

Select txtPassword From CMS_Admin where intUserID=1

so now i want to execute this query by using ExecuteScaler()

i am using self servicing here.

so please help me how to execute this query??? so it will return current password

Use a Dynamic List

Walaa wrote:

Use a Dynamic List

thanks for your valuable reply. i have already it but i cant get some idea. so can you please give me some code for that.

i am doing as below :

IRetrievalQuery query = RetrievalProcedures.GetProcCmsAdminAuthenticateCallAsQuery("admin", "admin");

int i = Convert.ToInt32(query.ExecuteScalar());

but it gives error that no connection available.

Thanks again in advanced

Are you calling a Stored Procedure or fetching a single column/value from a table?

Walaa wrote:

Are you calling a Stored Procedure or fetching a single column/value from a table?

hi thanks again

well i am fetching a single column value from a table not from store procedure.

Thanks

Then Why were you using the following?

IRetrievalQuery query = RetrievalProcedures.....

That's for calling a SP. Please check the link I posted before, and use a DynamicList.

Also you might use the GetScalar method as shown here

Walaa wrote:

Then Why were you using the following?

IRetrievalQuery query = RetrievalProcedures.....

That's for calling a SP. Please check the link I posted before, and use a DynamicList.

Also you might use the GetScalar method as shown here

Hi Walaa

Thanks for your such good reply. i have refer but i am new in this LLBLGen. so can you please help me to give some two three line code for that.

see i have one table called : admin

it has Three field : username & Password & UserID

i want to executescaler query that username & password is entered, if it is match with username & Password, it will return UserID.

so i can get value in Integer.

Thanks Walaa.

i want to executescaler query that username & password is entered, if it is match with username & Password, it will return UserID.

I thought you needed to select the pswd given the id as you stated before:

i have below query :

Select txtPassword From CMS_Admin where intUserID=1

so now i want to execute this query by using ExecuteScaler()

Anyway, the code should look like the following For Adapter:

IPredicateExpression filter = new PredicateExpression();
filter.Add(CmsAdminFields.UserName == username);
filter.Add(CmsAdminFields.Password == pswd);

DataAccessAdapter adapter = new DataAccessAdapter();
int id = (int)adapter.GetScalar(CmsAdminFields.UserId, null, null, filter);

For SelfServicing:

IPredicateExpression filter = new PredicateExpression();
filter.Add(CmsAdminFields.UserName == username);
filter.Add(CmsAdminFields.Password == pswd);

CmsAdminCollection col = new CmsAdminCollection();
int id = (int)col.GetScalar(CmsAdminFields.UserId, null, null, filter);

Walaa wrote:

i want to executescaler query that username & password is entered, if it is match with username & Password, it will return UserID.

I thought you needed to select the pswd given the id as you stated before:

i have below query :

Select txtPassword From CMS_Admin where intUserID=1

so now i want to execute this query by using ExecuteScaler()

Anyway, the code should look like the following For Adapter:

IPredicateExpression filter = new PredicateExpression();
filter.Add(CmsAdminFields.UserName == username);
filter.Add(CmsAdminFields.Password == pswd);

DataAccessAdapter adapter = new DataAccessAdapter();
int id = (int)adapter.GetScalar(CmsAdminFields.UserId, null, null, filter);

For SelfServicing:

IPredicateExpression filter = new PredicateExpression();
filter.Add(CmsAdminFields.UserName == username);
filter.Add(CmsAdminFields.Password == pswd);

CmsAdminCollection col = new CmsAdminCollection();
int id = (int)col.GetScalar(CmsAdminFields.UserId, null, null, filter);

Thanks Walaa,

now it is working.

i cleared lot of misunderstanding from your example.

Thanks for your help.