Monday, November 14, 2022

Find single number in Array ASP.NET C# - returns boolean

 var tt = final.ToList();

                

                if(tt.Exists(o=> o == Convert.ToInt64(DataBinder.Eval(e.Row.DataItem, "ID"))))

                        {

                    e.Row.BackColor = System.Drawing.ColorTranslator.FromHtml("#0000ff");

                }



reference:- https://www.geeksforgeeks.org/c-sharp-check-if-an-array-contain-the-elements-that-match-the-specified-conditions/

How to convert ASP.NET grid datasource to datatable C# - grid data copy

  var dt = GridView1.DataSource as DataTable;

ASP.NET Ajax autocomplete extender

aspx page


  <div class="dropdown col-md-2">

            <asp:TextBox runat="server" ID="txtSearchByName" CssClass="col-md-12 form-control input-sm"></asp:TextBox>

            <ajaxToolkit:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="txtSearchByName"

                CompletionSetCount="10" CompletionInterval="100" MinimumPrefixLength="3" ServiceMethod="getData">

            </ajaxToolkit:AutoCompleteExtender>

        </div>





aspx.cs page


 [System.Web.Script.Services.ScriptMethod()]

        [System.Web.Services.WebMethod]

        public static List<string> getData(string prefixText, int count)

        {

            return getAdvanceSearchAutocompleteData(prefixText, count);

        }

        public static List<string> getAdvanceSearchAutocompleteData(string prefixText, int count)

        {

            List<string> Name = new List<string>();

            SqlParameter[] param = { new SqlParameter("prefix", prefixText) };


            DataTable dt = new DataAccess().Read("autosuggest_name", param).Tables[0];

            foreach (DataRow dr in dt.Rows)

            {

                Name.Add(dr["Name"].ToString());

            }

            return Name;

        }


Bootstrap dropdown with label with row

<div class="row">

 <div class="col-md-1">Discipline (Select)</div>

        <div class="col-md-2">

            <asp:DropDownList runat="server" ID="ddlDisciplines" CssClass="col-md-12 form-control input-sm"></asp:DropDownList>

        </div>

</div>

we can increase the width by changing the class col-md-1 to col-md-2 or col-md-3

or decrease by col-md-5 to col-md-2

Friday, November 11, 2022

Grouping with max in linq ASP.NET

 var ProcessAudList = ProcessAudService.Where(x => x.Active == "Y")

.GroupBy(x => x.ProjectSeq, (key,g)=>g.OrderByDescending(e=>e.ProjectValue).First());