DotQuery

Sunday, April 5, 2020

a href # color or link color or blank link color

using with single cot or double cot

<style>
.dropdown-menu a[href='#'] {
background-color: yellow;
}
</style>

Tuesday, February 25, 2020

Srno in crystal report or Serial number in crystal report or srno in formula

numberVar f_sno=0;
stringVar f_booth="";
WhileReadingRecords;

if({command.booth_no} = f_booth) then
(
f_booth := {command.booth_no};
f_sno := f_sno + 1;
)
else
(
f_booth := {command.booth_no};
f_sno := 1;
)

Sunday, February 16, 2020

Direct landscape print in javascript or direct landscape print in jquery or direct landscape print in html

Tuesday, January 21, 2020

Sql Server left join with group, group left join

declare @date_from date='01-mar-2020',@date_to date='31-mar-2020'
select
datediff(month,cast(c.conn_date as date),@date_from),
datediff(month,cast(c.conn_date as date),@date_from)*c.cur_tax
,*
from Consumer_Conn c
left join
(bill_det d
join bill_mas m on m.b_code=d.b_code
join
(select dd.cons_code,max(mm.date_to) date_to from bill_mas mm
join bill_det dd on mm.b_code=dd.b_code
group by dd.cons_code)as a on a.date_to=m.date_to and a.cons_code=d.cons_code
) on d.cons_code=c.cons_code

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/#