Click here to Skip to main content
15,887,746 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionAll day event in .ics Pin
nitin_ion18-Oct-11 1:15
nitin_ion18-Oct-11 1:15 
AnswerRe: All day event in .ics Pin
Anuj Banka18-Oct-11 19:40
Anuj Banka18-Oct-11 19:40 
GeneralRe: All day event in .ics Pin
nitin_ion18-Oct-11 19:42
nitin_ion18-Oct-11 19:42 
GeneralExt.NET - New component framework Pin
AditSheth17-Oct-11 20:42
AditSheth17-Oct-11 20:42 
GeneralRe: Ext.NET - New component framework Pin
Richard MacCutchan17-Oct-11 23:12
mveRichard MacCutchan17-Oct-11 23:12 
GeneralRe: Ext.NET - New component framework Pin
AditSheth17-Oct-11 23:40
AditSheth17-Oct-11 23:40 
GeneralRe: Ext.NET - New component framework Pin
Richard MacCutchan18-Oct-11 0:16
mveRichard MacCutchan18-Oct-11 0:16 
QuestionGeneric list in Business layer Pin
Member 322226417-Oct-11 19:38
Member 322226417-Oct-11 19:38 
Hi,
Hi,
I need to call 3 tables in business layer by using List Collection.

1)I NEED QUERY Clntmast table with clientname.Column
Returned are clientid,cl_Colno# etc.

2)Then i need to query Colector table with cl_Colno#.

how to proceed


BAL:
C#
        #region   ShowDetails based on client dropdown change event
        public System.Collections.Generic.List<SpecialUser> ShowDetails(string strClientName)
        {
            SearchClientDataAccess user = new SearchClientDataAccess();
            System.Collections.Generic.List<SpecialUser> lstSpecialUser = new System.Collections.Generic.List<SpecialUser>();
 
            lstSpecialUser = user.ShowClientDetails(strClientName);
 
            foreach (SpecialUser specialUser in lstSpecialUser)
            {
                if (specialUser.cl_Cred != "")
                {
                  
                    specialUser.cl_Colno = user.GetCredMastDetails(specialUser.cl_Cred.ToString().Trim());
                }
 
                if (specialUser.cl_Colno != "")
                {
                     user.GetColectorDetails(specialUser.cl_Colno.ToString().Trim());
                }
 
            }
 
            return lstSpecialUser;
 
            // return user.ShowClientDetails(strClientName);

 

        }
 

        #endregion
Entities for Special user:  

<pre><pre lang="c#">
public class SpecialUser
    {
        public string ClientName { get; set; }
        public string ClientId { get; set; }
        public string Time { get; set; }
        public string Role { get; set; }
        public string User { get; set; }
        //public int cl_Cred { get; set; }

        #region VARIABLES READ FROM CLNMAST TABLE
        public string HeadClientName { get; set; }
        public string cl_client { get; set; }
        public string cl_clntie { get; set; }
        public string cl_Clname { get; set; }
        //FROM CREDMAST TABLE 
        public string CM_Req { get; set; }
        public string CM_Cname { get; set; }
        public string Ext { get; set; }
        public string HCredMgrName3 { get; set; }
        public string cl_Cred { get; set; }
        public string cl_Colno { get; set; }
        //FROM COLLECTOR TABLE
        //public string cl_Colno { get; set; }
        public string CO_Req { get; set; }
        public string CO_Colnam { get; set; }
       // public string Ext { get; set; }
        public string HCollectorName3 { get; set; }
        #endregion

Will the list will return all columns of Credmast and collector table?

ShowClientDetails method will get cl_Cred etc.

Based on cl_Cred value then call another method GetCredMastDetails
The return lstSpecialUser will get whole columns for 3 methods.

Thanks
Guhananth.S.
QuestionInternal project mappings no longer work Pin
CTaylor8917-Oct-11 13:55
CTaylor8917-Oct-11 13:55 
QuestionOnly domain users can use the site????? Pin
Arpikusz17-Oct-11 11:46
Arpikusz17-Oct-11 11:46 
GeneralCreating and Deploying SharePoint Solution Files Pin
Member 832518917-Oct-11 0:21
Member 832518917-Oct-11 0:21 
GeneralWrong forum, wrong solution and not a question Pin
Not Active17-Oct-11 3:58
mentorNot Active17-Oct-11 3:58 
QuestionUsing Generic List in business layer Pin
Member 322226416-Oct-11 22:39
Member 322226416-Oct-11 22:39 
AnswerRe: Using Generic List in business layer Pin
Not Active17-Oct-11 4:02
mentorNot Active17-Oct-11 4:02 
QuestionHow to keep the root path in the browser's addressbar Pin
impeham16-Oct-11 16:04
impeham16-Oct-11 16:04 
AnswerRe: How to keep the root path in the browser's addressbar Pin
Anuj Banka16-Oct-11 20:51
Anuj Banka16-Oct-11 20:51 
GeneralRe: How to keep the root path in the browser's addressbar Pin
impeham18-Oct-11 2:38
impeham18-Oct-11 2:38 
GeneralRe: How to keep the root path in the browser's addressbar Pin
Anuj Banka18-Oct-11 8:45
Anuj Banka18-Oct-11 8:45 
QuestionEmbedding excel file in web application Pin
Uma Kameswari16-Oct-11 1:09
Uma Kameswari16-Oct-11 1:09 
AnswerRe: Embedding excel file in web application Pin
CodingLover18-Oct-11 18:59
CodingLover18-Oct-11 18:59 
Questionweb part vs js Pin
mehrdadc4815-Oct-11 21:07
mehrdadc4815-Oct-11 21:07 
AnswerRe: web part vs js Pin
CodingLover18-Oct-11 18:53
CodingLover18-Oct-11 18:53 
QuestionHow to display detail information of each particular product in database? Pin
vanillaET15-Oct-11 20:35
vanillaET15-Oct-11 20:35 
Question2010 checkbox list control Pin
sc steinhayse15-Oct-11 10:46
sc steinhayse15-Oct-11 10:46 
Question2010 data context object Pin
sc steinhayse15-Oct-11 10:44
sc steinhayse15-Oct-11 10:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.