Comments by rahulDer (Top 32 by date)

here is my queries ..i want this result in single query:
select count(followupid) from erp.followupmaster where followupby=28 and followupmode='call'
select count(followupid) from erp.followupmaster where followupby=28 and followupmode='Housecall'

I also needed same thing for followup in my ERP so please do share with us, so that we can also implement it.

its workable, but it takes 30 rows for each student and it cause memory issues for 1000+ students

ya but problem is that, this code even does not allow me to debug my project and showing error like this :
Error 33 The name 'grd_InstallView_ctl02_txt_Install' does not exist in the current context E:\WorkingProjects\ERP_upd\Admin\RecieptMaster.aspx 22

still not getting ..:(

thank you ..but this code does not help me..it's for autocomplete textbox but I need to perform calculation with textbox value.

thank you for youa valuable answer ..
i appreciate it ,but i have solved it by easy way ..
here t is ..

for (int i = 0; i <= int.Parse(txt_bank1.Text); i++)
{
DateTime dtchk = Convert.ToDateTime(txt_dated.Text);

DateTime InstallDate = dtchk.AddMonths(1);

DataTable dt = conn.filldatatable("ERP.sp_InstallmentMaster_Insert '" + txt_enqno.Text + "'," + Convert.ToDecimal(txt_monthInstall.Text) + ",'" + InstallDate + "','0'," + Convert.ToDecimal(txt_monthInstall.Text) + ",'True'");
txt_dated.Text = InstallDate.ToString();
}

EXCEPTION ERROR :Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack.

yes,i have done debugging ,i got value in role as super admin and so it passes IF condition but inside if condition,that respose.redirect not works and directly go to catch part.

it dosnt display any error,directly go to catch part

yes , i got value in role as super admin and so it passes IF condition but inside if condition,that respose.redirect not works and directly go to catch part.

is there any other way to deal with this ?

i have also tried with sp_addlinkedserver but not worked..

not useful still..

no its not working on button click,but it is called when textbox text changed ,
here is the aspx code:
<asp:TextBox ID="txtenqdate" name="textbox" runat="server" CssClass="Textbox" Width="200px"
onfocus="if(this.value=='dd/mm/yyyy') this.value='';" onblur="if(this.value=='') this.value='dd/mm/yyyy';"
Text="dd/mm/yyyy" onchange="javascript:checkdate();">
<%--<ajaxToolkit:CalendarExtender ID="txtenqdate_CalendarExtender" runat="server" TargetControlID="TextBox2" >

--%>
<ajaxToolkit:CalendarExtender ID="CalendarExtender2" runat="server" TargetControlID="txtenqdate">

..

still giving same error..nd that +2 is for allowing to select one past date..

whichever date i select,this give me popup alert of second If condition like "Case File date must be less than current date"..

ya u are rite, nd m doing same but still not having result..

and in debugger I found this line
var dt = document.getElementById('ContentPlaceHolder1_txtenqdate').value;
what it means ?

ya buddy,recently checked,but it all times go to second If condition and display its related msgs..

yes..i am used to use Id..no name

both ids are equal..

Now "Dostuff" eroor is gone but
TypeError: document.getElementById(...) is null
is continuing ..

that I also dont know..is it any type of property in javascript ?

thank you KARTHIK..
but still this is giving same error in inspect element side :(

thnq for this reply but my cCalendarExtender does not suuport StartDate or EndDate properties ..
so if it is possible to deal with javascript thaen plz do tell..

its still not working ..cookies are deleted but the thing is that,when my page is loaded it brings all datas of controls of the page in a Url bar...
And by debugging ,i came to know dat it shows error related to ajaxControl like
"AjaxControlTOllkit.DLL!AjaxControlTOllkit.Extender.Base.ExtenderControlBase()line146"

and thid error continues for several F11 keys..:(