ASP.NET

1. Read the question carefully
   
2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar
   
3. If a question is poorly phrased then either ask for clarification, ignore it, or mark it down. Insults are not welcome
   
4. If the question is inappropriate then click the 'vote to remove message' button
   

1. Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
    
   
2. Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
    
   
3. Keep the subject line brief, but descriptive. eg "File Serialization problem"
    
   
4. Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
    
   
5. Be careful when including code that you haven't made a typo. Typing mistakes can become the focal point instead of the actual question you asked.
    
   
6. Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you.
    
   
7. If you are posting source code with your question, place it inside <pre></pre> tags. We advise you also check the "Encode "<" (and other HTML) characters when pasting" checkbox before pasting anything inside the PRE block, and make sure "Use HTML in this post" check box is checked.
    
   
8. Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
    
   
9. Please do not post links to your question into an unrelated forum such as the lounge. It will be deleted. Likewise, do not post the same question in more than one forum.
    
   
10. Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
     
    
11. If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
     
    
12. No advertising or soliciting.
     
    
13. We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.

<asp:CustomValidator ID="CustomValidator1"  ClientValidationFunction="/^([_a-zA-Z0-9-]+)(\.[_a-zA-Z0-9-]+)*@([a-zA-Z0-9-]+\.)+([a-zA-Z]{2,3})$/" runat="server" 
                            ControlToValidate="txtUserName" ErrorMessage="CustomValidator" 
                            SetFocusOnError="True"></asp:CustomValidator>

<asp:DropDownList id="ddlcourseType" runat="server" 
                            onselectedindexchanged="ddlcourseType_SelectedIndexChanged" 
                            AutoPostBack="True">
                       <asp:ListItem Value="None">Please Select</asp:ListItem>
                       <asp:ListItem Value="Engl">English</asp:ListItem>
                       <asp:ListItem Value="Math">Math</asp:ListItem>
                       <asp:ListItem Value="Soci">Social Studies</asp:ListItem>
                       <asp:ListItem Value="Scie">Science</asp:ListItem>
                       <asp:ListItem Value="Hist">History</asp:ListItem>
                       </asp:DropDownList>

 protected void ddlcourseType_SelectedIndexChanged(object sender, EventArgs e)
    {
        OleDbConnection dbConn = null;
        OleDbCommand dbCmd;
        OleDbDataReader dr;
        String strConnection;
        String strSQL;
        string path = Server.MapPath("eAcademy_DB.mdb");
 
        string Teachable = Convert.ToString(ddlcourseType.SelectedValue);
        strConnection = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" + path;
        dbConn = new OleDbConnection(strConnection);
        dbConn.Open();
        strSQL = "select * from tblEmployee where canTeach=" + Teachable;
 
        dbCmd = new OleDbCommand(strSQL, dbConn);
        DataSet ds = new DataSet();
                
        dbConn.Close();
        ddlTeacher.DataSource = ds;
        ddlTeacher.DataTextField = "emp_ID";
        ddlTeacher.DataValueField = "emp_ID";
        ddlTeacher.DataBind();
        ddlTeacher.Items.Insert(0, new ListItem("--Select--", "0"));
        if (ddlTeacher.SelectedValue == "0")
        {
            ddlTeacher.Items.Clear();
            ddlTeacher.Items.Insert(0, new ListItem("--Select--", "0"));
        }
    }

(o => o.LognName == name) 
 

Expression<Func<Users_UserAccount, bool>> whereLogonName = LinqExtender.DynamicLinq.BuildOrTree<Users_UserAccount, string>(LogonName, UserAccount => UserAccount.LogonName);
            

(o => o.LognName == name && o.LogonPW == "12345") //dumb pw

 

Expression.Or
Expression.And

public static Expression<Func<TValue, bool>> BuildOrTree<TValue, TCompareAgainst>(
        IEnumerable<TCompareAgainst> wantedItems,
        Expression<Func<TValue, TCompareAgainst>> convertBetweenTypes)
        {
            ParameterExpression inputParam = convertBetweenTypes.Parameters[0];
 
            Expression binaryExpressionTree = BuildBinaryOrTree(wantedItems.GetEnumerator(), convertBetweenTypes.Body, null);
 
            return Expression.Lambda<Func<TValue, bool>>(binaryExpressionTree, new[] { inputParam });
        }
        
 

private static Expression BuildBinaryOrTree<T>(
        IEnumerator<T> itemEnumerator,
        Expression expressionToCompareTo,
        Expression expression)
        {
            if (itemEnumerator.MoveNext() == false)
                return expression;
 
            ConstantExpression constant = Expression.Constant(itemEnumerator.Current, typeof(T));
            BinaryExpression comparison = Expression.Equal(expressionToCompareTo, constant);
 
            BinaryExpression newExpression;
 
            if (expression == null)
                newExpression = comparison;
            else
                newExpression = Expression.OrElse(expression, comparison);
 
            return BuildBinaryOrTree(itemEnumerator, expressionToCompareTo, newExpression);
        }
 

.yakoutb
{
    font-family: 'Yakout W20 Bold';
}

Public Shared Function AddDisbursement(ByVal DocType As String, ByVal Rim As Int32, ByVal CustomerName As String, ByVal RSMName As String, ByVal BranchNo As Int32, ByVal Business As String, ByVal InputDate As String, ByVal Category As String, ByVal DeferralDetails As String, ByVal DeferredDays As String, ByVal DefExpDate As String, ByVal DefDate As String, ByVal RMComments As String, ByVal CreatorId As String, ByVal App_Authority As String, ByVal Item As String) As String
        Dim logger As SKLogger = New SKLogger
        Dim connMosaic As String = System.Web.HttpContext.Current.Session("connStr").ToString()
        Dim cmdText As String
 
        cmdText = "INSERT INTO at_ip_disbursement(" & _
                    "doc_type, " & _
                    "rim_no, " & _
                    "customer_name, " & _
                    "rsm_name, " & _
                    "branch_no, " & _
                    "business_unit, " & _
                    "input_dt, " & _
                    "Category, " & _
                    "deferral_details, " & _
                    "days_deferred, " & _
                    "Deff_Expdt, " & _
                    "Deferred_Dt, " & _
                    "rm_comments, " & _
                    "creator_id, " & _
                    "status, " & _
                    "App_Authority, " & _
                    "item_type) " & _
                "VALUES (" & _
                    "?," & _
                    "?," & _
                    "?," & _
                    "?," & _
                    "?," & _
                    "?," & _
                    "?," & _
                    "?," & _
                    "?," & _
                    "?," & _
                    "?," & _
                    "?," & _
                    "?," & _
                    "?," & _
                    "'A'," & _
                    "?," & _
                    "?)"
 
        Dim conn As OdbcConnection = New OdbcConnection(connMosaic)
        Dim cmd As OdbcCommand = New OdbcCommand(cmdText, conn)
 
        cmd.Parameters.Add("@DocType", OdbcType.VarChar).Value = DocType
        cmd.Parameters.Add("@Rim", OdbcType.Int).Value = Rim
        cmd.Parameters.Add("@CustomerName", OdbcType.VarChar).Value = CustomerName
        cmd.Parameters.Add("@RSMName", OdbcType.VarChar).Value = RSMName
        cmd.Parameters.Add("@BranchNo", OdbcType.Int).Value = BranchNo
        cmd.Parameters.Add("@Business", OdbcType.VarChar).Value = Business
        cmd.Parameters.Add("@InputDate", OdbcType.Date).Value = InputDate
        cmd.Parameters.Add("@Category", OdbcType.VarChar).Value = Category
        cmd.Parameters.Add("@DeferralDetails", OdbcType.VarChar).Value = GetNull(DeferralDetails)
        cmd.Parameters.Add("@DeferredDays", OdbcType.Int).Value = DeferredDays
        cmd.Parameters.Add("@DefExpDate", OdbcType.Date).Value = DefExpDate
        cmd.Parameters.Add("@DefDate", OdbcType.Date).Value = GetNull(DefDate)
        cmd.Parameters.Add("@RMComments", OdbcType.VarChar).Value = GetNull(RMComments)
        cmd.Parameters.Add("@CreatorId", OdbcType.VarChar).Value = GetNull(CreatorId)
        cmd.Parameters.Add("@App_Authority", OdbcType.VarChar, 1200).Value = GetNull(App_Authority)
        cmd.Parameters.Add("@Item", OdbcType.VarChar).Value = GetNull(Item)
 
        Try
            conn.Open()
            cmd.ExecuteNonQuery()
        Catch ex As Exception
            logger.LogException("AddDisbursement", ex.ToString())
            AddDisbursement = ex.Message
        Finally
            cmd.Dispose()
            conn.Close()
        End Try
 
        'Return True
    End Function