DotQuery: November 2019

Wednesday, November 20, 2019

sql server configuration

sql server configuration or sql server 2014 configuration or sql server 2014 lost configuration
find in window10

1. for sql server 14
SQLServerManager12.msc

2. other
SQLServerManager14.msc
SQLServerManager13.msc
SQLServerManager12.msc

Monday, November 18, 2019

Fire event in aspx page in asp.net

Fire event in aspx page in asp.net in jquery or Fire event in jquery in aspx page in asp.net or
aspx event in jquery

<html>
<asp:DropDownList ID="ContentPlaceHolder1_ddlGroup" runat="server" class="form-control" AutoPostBack="true"
OnSelectedIndexChanged="ddlGroup_IndexChanded" required >
</asp:DropDownList>
</html>

<script>

$("#ContentPlaceHolder1_ddlGroup").trigger("change");

or

$("#ContentPlaceHolder1_ddlGroup").trigger("click");
</script>

Export to excel in jquery with full width

https://www.aspsnippets.com/demos/1990/#

Monday, November 11, 2019

Filter DataTable or Find in DataTable

1. string type

DataRow[] rw = dt.Select("ManuName='masters'");

2. integer type

DataRow[] rw = dt.Select("Srno=1");

Othe example

if (dt.Rows.Count > 0)
{
DataRow[] rw = dt.Select("ManuName='masters'");
foreach (DataRow r in rw)
{
if (Convert.ToBoolean(r["view_"]) == true){
%>
<li><a href="<%=r["form_name"] %>"><i class="fa fa-circle-o"></i><%=r["form_name"] %></a></li>
<%}
}
}

DotQuery