Comments by anurag19289 (Top 200 by date)

ok I tried the below query.

select new BusinessUnit { UnitId = r.UnitId, Name = r.Name }).Distinct().Take(10).OrderBy(c => Convert.ToInt32(c.UnitId)).ThenBy(c => c.Name.StartsWith(StoreIdName)).ToList();


it works for unitid. But if I start with name it doesnot work. As orderby is mentioned first for unitid followed by name.

For example.

unitid name
121 sz
122 sa
122 sc

if I type 12 in my autocomplete textbox. I get correct result
unitid name
121 sz
122 sa
123 sc

but If I type 's' in the textbox
result:
unitid name
121 sz
122 sa
123 sc

--but when I type 's' the result should be
unitid name
122 sa
123 sc
121 sz


--so is it possible to do it?

user may enter either unitid or name. If UnitId is enterd order by unitId(Not by Name).
If Name is enterd then order by Name(not by UnitId)

--so in the below line i need to do order by UnitId and Name. how to do that.

select new BusinessUnit { UnitId = r.UnitId, Name = r.Name }).Distinct().OrderBy(x=>(Convert.ToInt32(x.UnitId))).Take(10).ToList();

how to include two columns in one order by. I m stuck here..

List<businessunit> data = (from r in GetStoreHierarchy().Where(p => p.ParentId != "1" && p.ParentId != null).ToList()
where r.UnitId.ToUpper().StartsWith(StoreIdName.ToUpper()) || r.Name.ToUpper().StartsWith(StoreIdName.ToUpper())
select new BusinessUnit { UnitId = r.UnitId, Name = r.Name }).Distinct().OrderBy(x=>(Convert.ToInt32(x.UnitId))).Take(10).ToList();
return data;

--i have done for one column.

var table = document.getElementById("successFailure");
var row = table.insertRow(2);
var cell1 = row.insertCell();
cell1.innerHTML = "Format and Store Type";

--in this line var cell1 = row.insertCell(); Here it inserts a cell. If i pass parameter as 1 or nothing then it creates a cell with border.

--Meanwhile let me check the links that you provided.

cool... :)

in this line itself i am getting error

public class Customer where T : Customer

so is it the only way to do so ?

i think as i m using visual studio 2008 probably it doesnot support...

I am getting error--> constraints are not allowed on non-generic declarations

I will try and get back to you

I am unable to do it. Can you help me giving me an example.

Let me try and revert you..

Can you give sample on mvc.
Like in asp.net it is rowdatabound, is there any rowdatabound in webgrid ?

When i a m passing a list to the view, so it should have displayed in the grid.I guess i dont need to loop... Or i am doing somewhere wrong here.

Thank you...

Now everything is clear. Simply Superb.

-->So compiler gernerates the parameterless constructor only if there is no other overloaded constructor

--> And you are right :) if we dont specity :base it is equivalent to base(). No default constructor. So error.

Kindly write this in solution I will accept the answer :) Thank you very much.

Once you start using calls to :base in a derived class, then, in general, you should make sure you have constructors in the base class whose signature match each of the constructors in 'Derivedclass, and, as you found out, you must provide a parameterless constructor in 'BaseClass.

--ok in case 2 of the question. I was missing the parameterless constructor of baseclass. So I got the error.

--------------------------------------------------------------------------------
Ok if I see case:4 of my question. I am not using base keyword. Then why did I get error here.

As per you

"in general, you should make sure you have constructors in the base class whose signature match each of the constructors in 'Derivedclass'"
which is matching

I m not clear with the sentence. Kindly elucidate.

Like can you explain in case 2 of my question where i am getting error.
i have created single parameter constructor in base class. And derived class default constructor is there.

Got it ... Thank you :)

That is really cool. But i have one doubt. As you said i corrected in this way.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace oops1
{
class Program
{
static void Main(string[] args)
{

string strdetail = "Anurag Nayak 8585916787";
string[] details = strdetail.Split(' ');
API p = new API(details);
}
}

}

----------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace oops1
{
public class API
{
string _firstname;
string _lastname;
string _mobilenum;

string[] words;
public API(string [] details)
{
_firstname = details[0];
_lastname = details[1];
_mobilenum = details[2];

}
}
}
--------------------------------
In the Main method now after this line how to retrieve here:

API p = new API(details);

--i i put a breakpoint and reach till the above line(over p) ...i could see the details.
now i want to print in the console all the details.

Actually i knew the above method...but i was exploring something new... like how to make use of object and is it possible to iterate..
Karthik explained a nice way

:) that is superb...

So is the only way to tackle such scenario.

I was getting only the message view. I dropped the table ..and created the table and function again. Now its working

yaa the method is declared in on in validate1().

My doubt is "why the textbox became empty ?" which is declared in onblur.

This is cool. But can you explain the above scenario.

Thanks thats a good idea to split and check.

Thanks..this works

definitely.. :)

uffffff got the result..

you were absolutely right.

I created a webservice. code in separate file this time.

the code got created in app_code. And asmx outside. But my aspx page was in separate folder Folder1(suppose).

So i copied the asmx and webservice.cs in folder1. exculded the webservice that were created in app_code and asmx that was created outside. Clean build and got the output.

Thank you tadit ji :) :)

i did copy and paste the webservice.asmx(code in the same asmx[didnot create separate file]).

excluded the service which are outside the folder.

clean rebuild

but no result :(

whenever i create a webservice..the webservice.cs is created inside app_code. How to avoid that

and one more doubt like :

in my project this is used but i dont find any service is called.

[AjaxPro.AjaxMethod]
public void fnReleaseLock()
{
TMS.API.Route.VO_Route_Lock Route_Lock = null;
TMS.Business.Masters.INT_Route objBizRoute = null;

try
{
ArrayList iStatus = null;
//release locks
objBizRoute = new TMS.Business.Masters.INT_Route();
Route_Lock = new TMS.API.Route.VO_Route_Lock();

Route_Lock.RouteID = "0";
Route_Lock.Locked = "0";
Route_Lock.LockedBy = Session[TMS.Common.CommonConstants.CONST_USER_ID].ToString();
Route_Lock.LockedTime = DateTime.Now.ToString();

iStatus = objBizRoute.LockRoute(Route_Lock, 1, 10);
//release locks

}
catch (Exception exp)
{
//throw exp;
LogError.WriteError(exp);
}
finally
{
Route_Lock = null;
objBizRoute = null;
}
}

Hello Tadit ji,

What i have understood so far from the links that you gave is

1)we have to add the dll
2)create a webservice
3)Add the specific attribute to the method with [AjaxPro.AjaxMethod].
4)Add the JavaScript function to call the method.
5)Create the call back function to deal with the returned data.

But there are some doubts like
-->when we sould use this(a real time example would be much better)
-->what is the advantage
-->One of the most worthy features of this framework is that it supplies a developer with only one method for call and, therefore, dramatically increases the productivity effect.
(what exactly this line means)

Dear Tadit ji,
kindly read and explain me please.

Hello Tadit ji,

Can i have an explanation in your words regarding this.

Superb...this works well too :) thank you

Hats off.. Thank you

actually the stored procedure is about 440 lines....so i thought it would create much confusion...so i didn't post

good links

so is it i have to use recursive cte or normal cte can do it? I will take an example and will try and then get back to you.

I have never used it. Will it solve the problem..can you suggest me a good site so that i can get a clear picture of it...

nopes....

Brother my email id

anurag.19289@gmail.com

I was doing file-->new website. then its not working
but when i do fiole-->new project. it works. can you clarify this doubt.

i was doing file-->new website. then its not working
but when i do fiole-->new project. it works. can you clarify this doubt.

i am doing in this way.... file-->new website
not file-->new project

no i am was trying to access in this way Gridcustom.DataSource= EmployeeAccessLayer.Employee;
but when i typed EmployeeAccessLayer. I was getting error

public static class EmployeeAccessLayer
{
public class Employee
{

public int id { get; set; }
public string name { get; set; }
public int age { get; set; }
public string sex { get; set; }
}

made the class static but not working

i have made it disabled as of now...once i get the correct logic i will make it enable for 150 and ...

kindly help

... and 150 is disabled
//pages.Add(new ListItem("...", "...", false));
//pages.Add(new ListItem(totalpages.ToString(), totalpages.ToString(), false));)

Thats what till this is correct..

i get like

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25...150

a)
... and 150 is disabled
//pages.Add(new ListItem("...", "...", false));
//pages.Add(new ListItem(totalpages.ToString(), totalpages.ToString(), false));)

b)if i don't restrict to 25 pages then the total page becomes 150. and it displays in three line starting from 1 to 150.

c)so i thought like i will display till 25 pages. and when i click on "..."
it should display like below
1...26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50...150

d)and when i click on "..." after 51 then i should get like
1...51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75...150

RyanDev, I have updated the question...

1)ddlhub_SelectedIndexChanged --> on selcection of dropdown the grid will be populated
BindGrid(0, GridZeroApprovedKm.PageSize);

2) this.RepeaterBind(pageindex, GridZeroApprovedKm.PageSize, recordcount);
this gets me the page number....

3)
for (int i = 1; i <= totalpages; i++)
{
if (i <= 25)
{
pages.Add(new ListItem(i.ToString(), i.ToString(), i != (pageindex + 1)));
}
else
{
pages.Add(new ListItem("...", "...", false));
pages.Add(new ListItem(totalpages.ToString(), totalpages.ToString(), false));
break;
}
}

-- i m stuck here...as i am displaying only 25 pages.

you are right... let me update the question

i have updated the code..

Hello Tadit ji. I have updated the code.
Now in RepeaterBind function i am making it as 25 pages. If 150 pages then it was displaying in three rows which looked quite odd. So i restricted it to 25 pages. But how can i handle the things like this..


Question ==> I want to click on ... so that it displays as below


1...26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50...150

And when I click on ... after 50 it should display as


1...51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75...150

i will try that and get back to you

:)

Ok Vishal...now i am having my holidays.... i will try this once my holidays are over.... And i will let you know....

means once i search ..if no data is there then it should display as :

No Records found..

but in my case i m getting it as below inside a panel:

-------------------------------------------------------------------
No records found
-------------------------------------------------------------------


Is it possible to avoid that ...or not possible....

ohh sorry i was placing it inside column


getting the result ...but the "No Records found" is coming inside a panel.

How to avoid that

ohh sorry i was placing it inside column


getting the result now...but the "Data Not avaliable" is coming inside a panel.

How to avoid that

Getting this error :

System.Web.UI.WebControls.DataControlFieldCollection must have items of type 'System.Web.UI.WebControls.DataControlField'. 'emptydatatemplate' is of type 'System.Web.UI.HtmlControls.HtmlGenericControl'.

error :
System.Web.UI.WebControls.DataControlFieldCollection must have items of type 'System.Web.UI.WebControls.DataControlField'. 'emptydatatemplate' is of type 'System.Web.UI.HtmlControls.HtmlGenericControl'.

correct...

if (@COUNTLMS > @COUNTTAS )
begin

insert #temp2(userid,fromdatelms,todatelms,fromdatetas,todatetas)
select x.userid,x.fromdate,x.todate,y.fromdate,y.todate

from
(
select ROW_NUMBER() over(partition by l.userid order by l.userid) Sr, l.userid, l.fromdate, l.todate from tbl_LMS_Data l WITH(NOLOCK)
where l.FromDate > dateadd(dd,-30,getdate()) and l.FromDate < dateadd(dd,30,getdate())
and l.userid= @userid
) x
left outer join
(
select ROW_NUMBER() over(partition by t.userid order by t.userid) Sr, t.userid, t.fromdate, t.todate from tbl_TAS_Data t WITH(NOLOCK)
where t.FromDate > dateadd(dd,-30,getdate()) and t.FromDate < dateadd(dd,30,getdate())
and t.userid= @userid

) y
on x.Sr = y.Sr

end

else
begin
insert #temp2(userid,fromdatetas,todatetas,fromdatelms,todatelms)
select x.userid,x.fromdate,x.todate,y.fromdate,y.todate

from
(
select ROW_NUMBER() over(partition by t.userid order by t.userid) Sr, t.userid, t.fromdate, t.todate from tbl_TAS_Data t WITH(NOLOCK)
where t.FromDate > dateadd(dd,-30,getdate()) and t.FromDate < dateadd(dd,30,getdate())
and t.userid= @userid
) x
left outer join
(
select ROW_NUMBER() over(partition by l.userid order by l.userid) Sr, l.userid, l.fromdate, l.todate from tbl_LMS_Data l WITH(NOLOCK)
where l.FromDate > dateadd(dd,-30,getdate()) and l.FromDate < dateadd(dd,30,getdate())
and l.userid= @userid


) y
on x.Sr = y.Sr
end

But i have a doubt.... this scenario works...when in table1 we have more data and table2 has less data....... think of a situation where we don know which table has more data...may be table1 or table2 and we want that in single temporary table using the join..what i am doing is as per your suggestion

i am doing as below comment,..

end can you suggest on this ?

Thanks but i dont want this result..

And why i have kept id as same becuase...

there are two tables..

table1 [leaveapplied table]

[it contains more than one record for a userid]
userid leaveappliedfromdate leaveappliedtodate
123 12th nov 18th nov
123 25th dec 28th dec

And in another table the same userid

table2[travel table]
userid Travelfromdate Traveltodate
123 29th nov 1st dec


now i wanted to join these two tables ...last 60days and 60 days ahead....wanted to join in such away so to get the desired result as
userid leaveappliedfromdate leaveappliedtodate travelappliedfromdate travelappliedtodate
123 12th nov 18th nov 29th nov 1st dec
123 25th dec 28th dec null null

--No its not working...

declare @t table(id int, data1 int, data2 int)
declare @b table(id int, value1 int, value2 int)

insert into @t(id, data1, data2)
values(1, 100, 150)
insert into @t(id, data1, data2)
values(1, 200, 250)
insert into @t(id, data1, data2)
values(1, 300, 350)

insert into @b(id, value1, value2)
values(1, 1000, 1050)

select t1.id,t1.data1,t1.data2,t2.value1,t2.value2 from @b t2
right join
@t t1 on t1.id = 1;

That is cool :) Thanks

i have just taken an example as id..

Let me try and get back to you

That is nice :)

Super...

:)

Kindly rate my answer and accept it if it helped you :)

Thanks you :)

Thanks for your response Tadit ji :) I have one doubt.

'select * from tbl_employee where first_name like'+ '''%tadit%'''

so in this case if we see
like'-->this is the end of first quote(unlike the above case)

And here first quote is start of second string. And the next two is behaving like single quote
'''%tadit%'''
And then next two quotes behaving as single quote. And the last one is close of second string.

Am i right ?

nice..thank you

:)

good1

unable to understand..improve your question

i tried this :

create table checksumcheck
(
value int
)

insert into checksumcheck
select 13
union all select 23
union all select 45
union all select 55
union all select 66

SELECT CHECKSUM_AGG(CAST(value AS int))
FROM checksumcheck

--i got o/p =66
--now how this 66 is the output.
--is it random

--when i update any one column .the o/p changes.
--Where this checksum_agg can be useful ? In what scenario ?

that is not clear...give me your own example

ok ok ....its divide acually

But when i am trying the dot in numlock section[numbers in right side of the keyboard]. Getting the error. But it works fine for the key near comma(,).

good1

Hi Nijboer- I faced a situation like....when i was opening a child window from a parent window...and doing somechanges in child window.....and then closing the child window.....and when again open child window.....i was unable to find the changes done on child window...

I tried this..<%@ OutputCache Location="None" VaryByParam="none" %> . Then it worked..

So what i understood from the link you gave is that ..
if location=None - This turns off the output cache. So it will not pick from the memory/client browser....when i make later requests...

Is my understanding correct ?

<%@ OutputCache Location="None" VaryByParam="none" %> .

This when i put in child window...now its working

Hi Sergey-

I asked my lead regarding this doubt.

He told me to put this code

<%@ OutputCache Location="None" VaryByParam="none" %> .

And it worked. But i m not clear exactly why we need this. It would be a greate help if you explain me this.

Parent page is refreshing but....if i click on parent page link button and check in child window the new item which i recently added..i dont find....

i log out and log in again and navigate to that page and click on linkbutton. I find the record is inserted....

what can be the issue...even if i hit search button and populate the grid and click on the link button ...i find the new data is not inserted......but if i close the application and login and navigate to the page and click on link button ..then i find that record

Hi bikram-

The in your child page just call opener.reloadParent(); in javascript after you finish your operation in child page.

where to write this exactly..

In the rowcommand event of gridview : the data is inserted

if (identityCreated > 0) {

ScriptManager.RegisterStartupScript(Page, typeof(Page), "", "alert('" + System.Configuration.ConfigurationSettings.AppSettings["Save_Record"].ToString() + "');", true);

BindShuttleDetails();

UpdatePanel1.Update();
}

Then shall i write after updatepanel1.update();? Kindly help

question updated : in parent page

lbtn.Attributes.Add("onClick", "var sFeatures='dialogHeight: 700px;dialogWidth: 1000px;'; window.showModalDialog('Shuttle_StopDetails.aspx?shuttlefacilityid=" + lblshuttlefacilityid.Text + "&facility=" + lblfacilityid.Text + "&Trip=" + lbltrip.Text + "','',sFeatures);window.document.forms[0].submit();");

then in child page on rowcommand adding a new item in the footer of grid view....and then closing the child window....and then clicking the linkbutton of parent window to check whether updated or not....

Let me try this and get back to you...

Got it :)

Thanks :)

Thank you :)

Ok thanks for the help VICK...
i will do more analysis on this..

Hi Vick-So what i have understood

1)when we are editing ,updating or cancelling in gridview...obviously we are binding the grid again...

So in this case we cant make the enable view state propery to be false

doubt : what happens if we make it false ?

2)if a grid is binding normally. we are not editing/updating/cancelling. In this case it would be wise to make it false

I have read in the article you have provided. It suggests that where ever its not required we should disable it.

So if in the second case is it like if its enabled ...then the hidden field value in view source increases....leading to performance issue


kindly correct me if i am wrong

Hi Zafar-

I will try this and revert you.

This seems interesting. I will try and get back to you

That is very nice explanation. Thank you :)

ok :)

Hi Tanweer-

What i understood is : Suppose you have a gridview as below. And on searchbutton the grid populates as below.

column1 is routecolumn2 is number of routes.

column3 is linkbutton which opens the popup.

column1 column2 column3

route1 4 linkbutton
route2 5 linkbutton

Now you click the linkbutton of route1 and add one record. And when you close the popup. The count which was 4 for route1 is not increased to 5. So you peroform _dopostback before you close the window and pass searchbutton as event target value to the postback function and the grid populates again and the records are displayed correctly.

Kindly correct me if i am wrong.

link error

ok i replaced or by and.
SearchEmployee '','','',''
now the above execution give me all the result.


but when i try

SearchEmployee 'anurag','','',''

i get
select * from employee where Name=anurag
Msg 207, Level 16, State 1, Line 1
Invalid column name 'anurag'.

:( oops

so which edition i need to install ?

And then i tried to refresh the sql server log but i did not get that...

If i right click on sql server logs and click on view i get to see Database Mail(unchecked).But if i check and close but still the database mail node is not seen in sql server logs.

I tried this...



Exec sp_configure 'show advanced options',1
go
Reconfigure with override
go
Exec sp_configure 'Database Mail XPs',1
go
Reconfigure with override
go

Hi rohan-

in the textbox user can enter numbers as well as decimal. but the ascii of decimal was not working. But i got to know that the ascii of '.' is 190 but not 46

This is superb..... +5
NOw this is what i was looking for. Its working perfectly fine now.

Hi Gyan-

I have mentioned as not equal to.(!)
if (!((key == 8) || (key == 46) || (key >= 35 && key <= 40) || (key >= 48 && key <= 57) || (key >= 96 && key <= 105)))

ok coool :)

And then i tried searching ..how we can exactly use distinct and then put rownumber to it...i got this cte as a way...

with cte as(select distinct(t1.address_id),t1.hub_id from #temp2 t2
join #temp1 t1 on t2.address_id=t1.address_id
where t1.hub_id=20),
cte1 as
(select address_id, row_number() over (order by address_id) as row from cte)

select * from cte1

--now in this row is a header i am using in cte(select address_id, row_number() over (order by address_id) as row from cte)

Hi Sergey-

in this query its a part of #temp3

insert into #temp3(address_id,hub_id,row)
select distinct(t1.address_id),t1.hub_id, ROW_NUMBER() over (order by t1.address_id) as rownumber from #temp2 t2
join #temp1 t1 on t2.address_id=t1.address_id
where t1.hub_id=20

--i have created the #temp3 first(which i have not shown)

i have updated in the comment:

address_id facility_id
123 20

123 20

123 20


in tbl_geocode_address (tg)
address_id
123

name and address columns just i gave for example(like there are many columns in the table)...i have updated now..

Actually Maciej

In my actual query i got stuck in one join.......like the actual query in my project is like

insert into #approve(rownumber,address_id,hub_id,hub_name,geocode_address,distanceByOps,distanceByCtv)
(select ROW_NUMBER() over(order by tg.address_id) as Rownumber,distinct(tg.address_id) as address_id,hub_id,
@hub,distinct(isnull( Landmark,'') +' '+ isnull(Colony,'') +' ' +isnull(Sub_Colony,'')+' '+isnull(CITY,'')) as geocode_address,
distancebyops,distancebyctv
FROM
tbl_Geocode_Address tg with(nolock)
join tbl_user_master tum with(nolock) on tum.address_id=tg.address_id and tum.Facility_ID=@HUB_ID
left join APPROVED_KM_OPSCTV tak on tak.address_id=tg.Address_ID and tak.hub_id=@HUB_ID
WHERE
tg.ADDRESS_ID NOT IN(SELECT TO_ID FROM tbl_approved_distances with(nolock) WHERE FROMID=@HUB_ID) and mmim_key is not null
and tg.Hub_Ids like '%' + cast(@HUB_ID as varchar) +'%'
or tg.ADDRESS_ID IN(SELECT TO_ID FROM tbl_approved_distances with(nolock) WHERE FROMID=@HUB_ID and Distance=0))



--now

join tbl_user_master tum with(nolock) on tum.address_id=tg.address_id and tum.Facility_ID=@HUB_ID

in tbl_user_master (tum)

address_id facility_id
123 20

123 20

123 20


in tbl_geocode_address (tg)
address_id
123


i was joining these two tables....tum.address_id=tg.address_id and tum.Facility_ID=@HUB_ID (@hub_id=20)

--but i was getting 3 duplicate records...i wanted to avoid that...as rownum is also there.,,,it was tough for me ..like how to use distinct

i will try that and get back to you

I tried this too :

<script type="text/javascript">
$(function(){
$('[id*=chkbcopy]').click(function(){
var chkHeader = $(this);
if (chkHeader.is(":checked"))
{

$("[id*='GridZeroApprovedKm'] tr").each(function () {

$("[id*='txtdistancectv']").val($("[id*='txtdistanceops']").val());


});
}
else
{
$("[id*='txtdistancectv']").val('');

}


});

});


--but the same result

Kindly help me ...

I tried this:

<script type="text/javascript">
$(function(){
$('[id*=chkbcopy]').click(function(){
var chkHeader = $(this);
if (chkHeader.is(":checked"))
{

$("[id*='txtdistancectv']").val($("[id*='txtdistanceops']").val());

}
else
{
$("[id*='txtdistancectv']").val('');

}


});

});



</script>


--but its copying the first row of gridview to all the text box.
--means if if in column1 the values are 3 4 5 6
--coulumn two values are fetched ike 3 3 3 3


--aspx page
<asp:TemplateField HeaderText="Approved Km By CTV" Visible="false">
<HeaderTemplate>
<asp:CheckBox ID="chkbcopy" runat="server" Text="Approved Km By CTV"/>
</HeaderTemplate>
<itemtemplate>
<asp:TextBox ID="txtdistancectv" MaxLength="6" class="test" CssClass="textBox_for6tds" runat="server">

<itemstyle horizontalalign="center">

I tried like this : Added class to both the textbox (test)

<asp:TemplateField HeaderText="Approved Km By Ops">
<itemtemplate>
<asp:TextBox ID="txtdistanceops" MaxLength="6" class="test" CssClass="textBox_for6tds" runat="server"
Text='<%#Bind("distanceByOps") %>'>

<itemstyle horizontalalign="center">

<asp:TemplateField HeaderText="Approved Km By CTV" Visible="false">
<itemtemplate>
<asp:TextBox ID="txtdistancectv" MaxLength="6" class="test" CssClass="textBox_for6tds" runat="server">

<itemstyle horizontalalign="center">


---then i tried in this way....not working
<script type="text/javascript">
$(function() {
$('.test').keydown(function(e) {
if (e.shiftKey || e.ctrlKey || e.altKey) {
e.preventDefault();
} else {
var key = e.keyCode;
if (!((key == 8) || (key == 46) || (key >= 35 && key <= 40) || (key >= 48 && key <= 57) || (key >= 96 && key <= 105)))
{
e.preventDefault();
alert("Please enter numeric value!");
$('[id*=txtdistanceops]').val('');

}
}
});
});

Thank you very much :) :)

i understood.....

you are awesome....

Thank you ... so the colum index starts from 0.
It's working :)

<script type="text/javascript">
$(function() {
$('[id*=txtdistanceops]').keydown(function(e) {
if (e.shiftKey || e.ctrlKey || e.altKey) {
e.preventDefault();
} else {
var key = e.keyCode;
if (!((key == 8) || (key == 46) || (key >= 35 && key <= 40) || (key >= 48 && key <= 57) || (key >= 96 && key <= 105)))
{
e.preventDefault();
alert("Please enter numeric value!");
$('[id*=txtdistanceops]').val('');

}
}
});
});
</script>


---now this is working

--now when gridview is having textbox i think we have to use $('[id*=txtdistanceops]').keydown(function(e) insetead of $('#txtdistanceops').keydown(function(e)

is it so ?

i m trying this in home..its working

but when i tried this in office as below its not working:


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ApprovingKm.aspx.cs" Inherits="TMSWeb.Masters_Route_ApprovedKm" %>

<%@ Register Src="../../UserControls/ContextMenu.ascx" TagName="ContextMenu" TagPrefix="uc3" %>
<%@ Register Src="../../UserControls/CustomDataView.ascx" TagName="CustomDataView"
TagPrefix="uc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<%HeaderHTML("Approving Km", 2, 0);%>
<body>
<link href="../../Utility/Style/TMS.css" rel="stylesheet" type="text/css" />

<script type="text/javascript" src="../../Utility/JavaScript/wz_tooltip.js"></script>

<script type="text/javascript" language="javascript"></script>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.8.2.js"></script>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
<style type="text/css">
body
{
font-family: Arial;
font-size: 10pt;
}
.selected
{
background-color: #A1DCF2;
}
</style>

<script type="text/javascript">
$(function() {
$('#txtdistanceops').keydown(function(e) {
if (e.shiftKey || e.ctrlKey || e.altKey) {
e.preventDefault();
} else {
var key = e.keyCode;
if (!((key == 8) || (key == 46) || (key >= 35 && key <= 40) || (key >= 48 && key <= 57) || (key >= 96 && key <= 105)))
{
e.preventDefault();
alert("Please enter numeric value!");
$('#txtdistanceops').val('');

}
}
});
});
</script>

And one more doubt
is src="http://code.jquery.com/jquery-1.8.2.js"

is this src standard ? is it going to work everywhere ?

one way is found --> reset the textbox after the alert message

<head runat="server">
<title></title>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.8.2.js"></script>
<script type="text/javascript">
$(function() {
$('#TextBox1').keydown(function(e) {
if (e.shiftKey || e.ctrlKey || e.altKey) {
e.preventDefault();
} else {
var key = e.keyCode;
if (!((key == 8) || (key == 46) || (key >= 35 && key <= 40) || (key >= 48 && key <= 57) || (key >= 96 && key <= 105)))
{
e.preventDefault();
alert("Please enter numeric value!");
$('#TextBox1').val('');

}
}
});
});
</script>


-->please let me know how we can display a message box error when any non numeric key is entered

<head runat="server">
<title></title>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.8.2.js"></script>
<script type="text/javascript">
$(function() {
$('#TextBox1').keydown(function(e) {
if (e.shiftKey || e.ctrlKey || e.altKey) {
e.preventDefault();
} else {
var key = e.keyCode;
if (!((key == 8) || (key == 46) || (key >= 35 && key <= 40) || (key >= 48 && key <= 57) || (key >= 96 && key <= 105)))
{
e.preventDefault();
alert("Please enter numeric value!");

}
}
});
});
</script>


-- i was trying to have an alert [message box] type error.

--but this is giving alert message but the character[like a] is entered in textbox

i m using <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>

and its visual studio 2008

Sampath-

when i write event then followed by .(dot)

i m not getting[preventDefault] event.preventDefault.

Am i missing anything.

its not working.

Thanks for the help :)

its working but i would like to know

var grid = $(this).closest("table");

what does this mean ?
var grid = $(this).closest("table");

cool its working... :)

kindly post that too

ok bro..

Ok Ok...Is there any other way to write this query ?

ok but union is going to give me duplicate values i guess..

and i need a query other than union or union all...

This is working brilliantly :)

Thanks bro :)

yes i am using update panel

Hello KR-

It's working....But it seems its taking much time as compared to what javascript does....allow paging i have made to true in gridview. And 10 records are displayed per page.

and in code behind i have shortened the code as :

protected void sellectAll(object sender, EventArgs e)
{

foreach (GridViewRow row in GridZeroApprovedKm.Rows)
{
((CheckBox)row.FindControl("chkb2")).Checked = ((CheckBox)sender).Checked;
}
}


--so using the update panel and content template....why its taking much time ?

let me try and get back to you...

This will work...But is it possible to do without using javascript.

Hi this is the same thing you have written what i have written above... but the page is refreshing.

i want to do this without using javascript...kindly help

so if i want to do it through server side...then this autopostback property has to be true ? is it correct ?

Thats why i always i say you "you are simply awsome". A perfect explanation. This is what i was looking for :) cheers +5

So you mean to say that the best way to solve the problem is to create a permanent table ...and insert into that permanent table as per if condition...And finally that permanent table will be inserted in temporary table....And i can work with that temporary table in the cursor....Is there any other way ?

Thanks :) it worked

Awsome Mike...It worked...:)

Let me try that tomorrow and get back to you

ok mubin let me try that in office tomorrow...and i will get back to you

Mike -

set @NEW_ROUTEID = @@identity
PRINT '@NEW_ROUTEID:' + CAST(@NEW_ROUTEID AS VARCHAR(50))

INSERT INTO TBL_ROUTE_STOP_DETAIL (Route_ID,Stop_Number,Address_ID)VALUES(@NEW_ROUTEID,1,@FROM_ADDRESS)

This statement is correct right. A identity i m storing in @NEW_ROUTEID and that i am using immediately after in the insert statement. Is this correct ?

Hello Mike- When i execute this no exception is raised..



I have never used interactive debugger.. i m using print statement to debug..how to use this interactive debugger


i get in message as :


TYPE:P
fromdate:Sep 7 2013 12:00AM
todate:Sep 7 2013 12:00AM
@USERID-->51333357
@APPDATE-->Sep 7 2013 6:30AM
@FROM_ADDRESS-->206950
@TO_ADDRESS-->65597
@TO_FACILITY_ID-->639

@NEW_ROUTEID:880315


--finally after the completion of my cursor there is a select statement..
--but i m not getting any result

Let me try and get back to you

Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".

The OLE DB provider "MICROSOFT.JET.OLEDB.12.0" has not been registered.

let me try and get back to you

i think it is possible to do in sql server 2005. In later version it doesnot allow.

ok....

In one of my table i have around 20 columns. The 18th number column is most needed for me. Everytime i have to write in this way.
select status,* from tbl_route_detail where route_id=23324 and userid='24524524'

so i thought if i can change the ordinal position...then directly i can see that column

It's simple Bro... I want to copy data from excel sheet to sql table. In excel sheet i have the same header column as per the table. Then i am executing the above commands. Hope its cleared.

But the above command is not working.

Microsoft Office Excel 2010

Brother i am little confused... i have updated the question

just now i saw your answer... i have posted the below answer..and then i saw your answer...

Thanks Tadit.. Yes i am accepting your answer... and i am deleting the below answer...

You are really genius :) Both are working perfectly fine... :) :) i liked the first approach

Hi Rohan-

The two querries were not identical. I think i should have elaborated it more clearly.

select * from #tempmonthly with(nolock) order by hub_id desc

Rohan- i have the hub id as
12
20
136
9
1
652
and so on.

but if i do order by hub_id desc
i will get output like

652
136
20
12
9
1
in this way...

but actually i wanted in this way : 12 ,20,136,9,1,652

so i searched google for this. from one article i got a solution like

order by decode( sorted, 'F',1, 'C',2, 'A',3, 'B',4, 'G',5, 'D',6, 'E',7, 8 )--he was trying to order the letters as per his wish

--so i thought i can use this

select * from #tempmonthly with(nolock) order by hub_id (sorted,12,1,20,2,136,3,9,4,1,5,652,6)

but i was unable to do....

question is improved...

i tried to google it ,,, i got that sorted part...so immediatey after order by (sorted,)

this starts... but this is not working

thanks for your comment.. let me clear it..

query 1
select * from #tempmonthly with(nolock) order by hub_id (sorted,12,1,20,2,136,3,9,4,1,5,652,6,672,7,129,8,240,9,17,10,14,11,627,12,18,13,574,14,158,15,145,16)

query 2
select * from #tempmonthly with(nolock) order by hub_id

I got the solution..we have to use sum and average like this as below

Hi Manas-

the above query will not fetch me the exact result.

like the above query the output will be :

SalesPersonId Numbers Average
1 24 24
2 72 36
3 72 36
4 72 72
5 24 24
6 18 18

but the average i am looking for is the average of second column:
24
72
72
72
24
18

that is 47. so i need to write that query in such a way that i will get 47 as output. Now this can be done using CTE. But i wanted to write a query without cte. Please try and let me know.

As both the triggers are there which inserts one in test1 and the other in test2. How it selects 7. that is trigger parentins[trigger] is preferred over parentinns[trigger]. This is the doubt..

doubt regarding @@IDENTITY

scenario:
create table test1
(
id int identity(1,1),
name varchar(50)
)

create table test2
(
id int identity(1,1),
name varchar(50)
)

CREATE TRIGGER Parentinss ON test1 FOR INSERT

AS

BEGIN

insert into test1 values('usa')

END;

CREATE TRIGGER Parentins ON test1 FOR INSERT

AS

BEGIN

insert into test2 values('india')

END;


insert into test1 values('ANURAG')
insert into test1 values('abhishek')
insert into test2 values('japan')
insert into test1 values('china')

select * from test1
select * from test2

select SCOPE_IDENTITY()
select @@IDENTITY

--There are two triggers. Now both triggers is on test1. one trigger inserts into test1 and the other on test2.
--select SCOPE_IDENTITY()
select @@IDENTITY

@@identity gives me the output as 7 . why ?
why doesnt it give me 6.

ooops oops oops... i got it .... thanks

Thanks.. its working now :)

Superb,,,,:) thanks :)

ok.. thanks..

So you mean to say like :

if string s is null


and s.trim will give nullreference exception...


so i can avoid it by writing like this

if (string.IsNullOrEmpty(s))
{
s= string.empty;
}
else
{
s= s.trim();
}

but can textbox.text return null ever ?
I thing if the text box is empty then it will always be--> "" [which is nothing but string.empty]

So is the code below is useful ? correct me if i am wrong...


string.IsNullOrEmpty(txt_Token_ID.Text) ? string.Empty : txt_Token_ID.Text;

yes Maciej is correct....

ok ok okkkkkk.... got it,,,,, :) thanksssss

i want to do it in backend

Adarsh Maciej has given a good answer. But that will not work if i want the number whose occurencce is more will come first[like 800].

Requiremnt is something ike: i have two drop down.like example in dropdown1

1)facility12)facility23)facility3under facility1 we have so many claim amount

1)8002)8003)8004)8005)4006)4007)6)400 6008)600

similarly for facility2 some values and for facility3 some values...

so as soon as i select facililty1 in dropdown1 in dropdown2 it will be like800 400

600

And then search button is there ... as per the list populated in dropdown2... we select.. and manipulate the things,,,, i hope you got it what i am looking for,.,, for this dropdown2 ..i am working ,,, so i want some simle query in back end which will do my purpose


Like in dropdown2 the number which comes in top...its and indication to the user that under facility1 ,,,,the maximum number of employees are claiming 800 rs
then 400 rs
then 600 rs

its an answer