Comments by super_user (Top 200 by date)

no..there is not any errors.. not event hard coding.. problem is post back works on local host but when i publish and check then post back not working on dropdown
@F-ES Sitecore

how to add where condition

ok ... but thanku now done.. i have another question related to this can i ask

and how to give name to this + re[i][1] + ' ' + re[i][2] + .. means 1 has header abc and 2 have header def then how i give new name .. Info . and then i want to these hide these two columns 1 and 2 and display new column name with data "Info"

how to call parameters Service_frequency ,Next_Service,Create_reminder in foreach loop

this is always public you may check updated question

this show error
Error 1 The best overloaded method match for 'string.Split(params char[])' has some invalid arguments
Error 2 Argument 1: cannot convert from 'string' to 'char[]'

check again .. this is exist

http://i.imgur.com/xmfiApI.gifv

check this GIF
http://i.imgur.com/xmfiApI.gifv

no... when i enter 10 numbers in horizontal and enter then error display An unhandled exception of type 'System.Exception' occurred in practise.exe
where as when i try to enter number in vertical i.e when i input number 12 then press enter then message display that not less than 10 ...where as i want to input 10 numbers then want to display message

I try this to get ID from webmethod


$(function () {

var RegNo = '';
var Status = '';
var latit = '';
var longi = '';
var ID = '<%=Session["ID"]%>'.val();
var obj = {};
obj.ID=ID;
getdata(obj);
return false;

});

function getdata(obj) {

$.ajax({
type: "POST",
url: "home.aspx/info",
contentType: "application/json;charset=utf-8",

data:JSON.stringify(obj.ID),
datatype: "json",
async: true,
cache: false,
success: function (result) {
//map code


},
error: function (error) {
alert(error);
alert("error");
}
});
}

i try to pass id through web method in this line data:JSON.stringify(obj.ID),

when i do this there is error on console

Uncaught TypeError: "442".val is not a function

and when i remove .val() this show error
Failed to load resource: the server responded with a status of 500 (Internal Server Error)

ok now i done with both marker now will you please tell me how i call id from web method to jquery in this line data: "{'id':'442'}",

beacuse i hard code id in this line but i want id through webmethod

in jsfiddle i think data is not populated .. so here i share separate links ..
this is link for

1 marker is display through this code
http://www.codesend.com/view/d15d5839083152a217071a168f38c1ef/


and this link for when both marker not display and also map not display


http://www.codesend.com/view/dce4c75055bc6fa461f86533c17f40b1/

when i try above code both marker not display

i think i already done like this but this show no marker
success: function (result) {
// window.onload = function () {
alert("map2");

$("#tabledata").empty();

var table_data = JSON.parse(result.d).response;

console.log(JSON.parse(result.d));


$("#tabledata").empty();
if (table_data.length > 0) {
$("#tabledata").append(
"NoLongitudeLatitude");

for (var i = 0; i < table_data.length; i++) {
if (table_data[i] !== null) {
$("#tabledata").append("" +
table_data[i][0] + " " +
table_data[i][1] + " " +
table_data[i][2] + " ");

Status = table_data[i][2];
No = table_data[i][0];
}
}
}
else {
$("#tabledata").hide();
}



var center = new google.maps.LatLng(24.0895898, 67.0998546);

var map = new google.maps.Map(document.getElementById('map'), {
zoom: 3,
center: center,
mapTypeId: google.maps.MapTypeId.ROADMAP
});

var markers = [];
for (var i = 0; i < table_data.length; i++) {
var location = yourData.location[i];
var latLng = new google.maps.LatLng(location.latitude,
location.longitude);
var marker = new google.maps.Marker({
position: latLng
});
markers.push(marker);
}
var markerCluster = new MarkerClusterer(map, markers);

google.maps.event.addDomListener(window, 'load', initialize);

i am getting data -.. 2 rows

@Karthik Bangalore ok i done with this .. now the problem is there is two records in grid dt but on map this show only 1 record means there is no looping on map so how i loop this .. map code




$(function () {
var No = '';
var Status = '';


var obj = {};

obj.No = No;
obj.Status = Status;

getdata(obj);
return false;
});

function getdata(obj) {
$.ajax({
type: "POST",
url: "home.aspx/info",
contentType:"application/json;charset=utf-8",
data: "{'id':'CU-8442'}",
datatype: "json",
async: true,
cache: false,

success: function (result) {
alert("map2");

$("#tabledata").empty();

var table_data = JSON.parse(result.d).response;

console.log(JSON.parse(result.d).response);

$("#tabledata").empty();
if (table_data.length > 0) {
$("#tabledata").append(
"NoLongitudeLatitude");

for (var i = 0; i < table_data.length; i++) {
if (table_data[i] !== null) {
$("#tabledata").append("" +
table_data[i][0] + " " +
table_data[i][1] + " " +
table_data[i][2] + " " +
table_data[i][3] + " ");
Status = table_data[i][2];
No = table_data[i][0];
}
}
}
else {
$("#tabledata").hide();
}

var map;
debugger;
var latlng = new google.maps.LatLng(24.0895898, 67.0998546);
debugger;
var myOptions = {
zoom: 8,
center: latlng,
mapTypeId: google.maps.MapTypeId.ROADMAP
};
debugger;
map = new google.maps.Map(document.getElementById("map_canvas"), myOptions);

debugger;
var marker = new google.maps.Marker
(
{
position: new google.maps.LatLng(obj.latit,obj.longi),
map: map,
title: 'Click me'
}
);
debugger;
var infowindow = new google.maps.InfoWindow({
content: 'No:' + No + 'Status:' + Status,
title:'tr'
});
google.maps.event.addListener(marker, 'click', function () {
infowindow.open(map, marker);
});
},
error: function (error) {
alert(error);
alert("error");
}
});
}

i try 2-3 times but not getting result

but this is not working i guess

how???? @Karthik Bangalore

problem is not on these lines problem on these lines
var No ='<%=Session["No"]%>';
var longi = '<%=Session["Longitude"]%>';
var latit = '<%=Session["Latitude"]%>';

how?

ok i got marker through hard coded values through this jquery but the problem is i want to get values through method and still there is null value


$(function () {
var FID = '<%=Session["FID"]%>';
var ObID = '<%=Session["ObID"]%>';
var No ='<%=Session["No"]%>';
var longi = '<%=Session["Longitude"]%>';
var latit = '<%=Session["Latitude"]%>';


var obj = {};
obj.FID = ID;
obj.ObID = ObID;
obj.No = No;
obj.longi = longi;
obj.latit = latit;

getdata(obj);
return false;

});
function getdata(obj) {
$.ajax({
type: "POST",
url: "home.aspx/mapgriddata",
contentType: "application/json;charset=utf-8",
data:JSON.stringify(obj),
datatype: "json",
async: true,
cache: false,

success: function (result) {
// window.onload = function () {
alert("map2");

var map;
debugger;
var latlng = new google.maps.LatLng(27.0895898, 64.0998546);
debugger;
var myOptions = {
zoom: 8,
center: latlng,
mapTypeId: google.maps.MapTypeId.ROADMAP
};
debugger;
map = new google.maps.Map(document.getElementById("map_canvas"), myOptions);

debugger;
var marker = new google.maps.Marker
(
{
position: new google.maps.LatLng(35.19055,57.84629),
map: map,
title: 'Click me'
}
);
debugger;
var infowindow = new google.maps.InfoWindow({
content: 'FID:'+obj.FID,
title:'tr'
});
google.maps.event.addListener(marker, 'click', function () {
// Calling the open method of the infoWindow
infowindow.open(map, marker);
});
},
error: function (error) {
alert(error);
}
});
}


public static string mapgriddata(string FID,string ObjID)
{


try
{
string result = "";
FID = HttpContext.Current.Session["FID"].ToString();
ObID = HttpContext.Current.Session["ObID"].ToString();
Entities w = new Entities();
List(spgetdata_fid_Result) gt = w.spgetdata_fid(FID).ToList();

DataTable dt = new DataTable();
dt.Columns.Add("No", typeof(string));
dt.Columns.Add("Longitude", typeof(float));
dt.Columns.Add("Latitude", typeof(float));

foreach (var t in gt)
{
dt.Rows.Add(t.No, t.Longitude, t.Latitude);

t.No = Convert.ToString(HttpContext.Current.Session["No"]);
t.Latitude = Convert.ToSingle(HttpContext.Current.Session["Latitude"]);
t.Longitude = Convert.ToSingle(HttpContext.Current.Session["Longitude"]);
dt.Rows.Add(t.No, t.Latitude, t.Longitude);
}
result = DataSetToJSON(dt);
return result;

}
catch (Exception)

no?? how i do this ?

and when i click on that image then small content window display with lat and long values ..

i want display markers or any image according to these lat and long values var longi = '69.84629';
var latit = '21.19055'; if these values change then marker/image position must change

i mentioned rough lat and long values

yes sure this is link of screen shot http://i.imgur.com/0yx2sft.png

and this is the updated jquery code


$(function () {

var FID = '<%=Session["FID"]%>';
var ObjID = '<%=Session["ObjID"]%>';

var RegNo = '2345';
var longi = '69.84629';
var latit = '21.19055';

var obj = {};
obj.FID = FID;
obj.ObID = ObID;
obj.No = No;
obj.longi = longi;
obj.latit = latit;

getdata(obj);
return false;

});
function getdata(obj) {
$.ajax({
type: "POST",
url: "home.aspx/mapgriddata",
contentType: "application/json;charset=utf-8",
data:JSON.stringify(obj),
datatype: "json",
async: true,
cache: false,

success: function (result) {
// window.onload = function () {
alert("map2");

var map;
debugger;
var latlng = new google.maps.LatLng(67.0998546,24.0895898);
debugger;
var myOptions = {
zoom: 8,
center: latlng,
mapTypeId: google.maps.MapTypeId.ROADMAP
};
debugger;
map = new google.maps.Map(document.getElementById("map_canvas"), myOptions);

debugger;
var marker = new google.maps.Marker
(
{
position: new google.maps.LatLng(-38.397, 140.644),
map: map,
title: 'Click me'
}
);
debugger;
for (i = 0; i < obj.length; i++) {
var data = obj[i]
var myLatlng = new google.maps.LatLng(obj.latlng);
var marker = new google.maps.Marker({
position: myLatlng,
map: map,

});
debugger;
(function (marker, obj) {
google.maps.event.addListener(marker, "click", function (e) {
infoWindow.setContent(obj.FID, obj.No,obj.latit, obj.longi);
infoWindow.open(map, obj);
});
})(marker, data);
}
debugger;
google.maps.event.addListener(marker, 'click', function () {
// Calling the open method of the infoWindow
infowindow.open(map, marker);
});



},
error: function (error) {
alert(error);
}
});
}

ok i hard code value like this
var FFID = '2012';
var ObjectID = '0';

var RegNo = '2345';


var longi = '69.84629';
var latit = '21.19055';
but markers not display according to lat and long values

ok removed then ?

like this ?

$(function () {
var FID = '<%=Session["FFID"]%>';
var ObID = '<%=Session["ObjID"]%>';
var No = '<%=Session["No"]%>';
var longi = '<%=Session["Longitude"]%>';
var latit = '<%=Session["Latitude"]%>';

var obj = {};
obj.FID = FFID;
obj.ObjID = ObjID;

obj.No = No;
obj.longi = longi;
obj.latit = latit;
getdata(obj);
return false;

});
function getdata(obj) {
$.ajax({
type: "POST",
url: "home.aspx/mapgriddata",
contentType: "application/json;charset=utf-8",
data:JSON.stringify(obj),
datatype: "json",
async: true,
cache: false,

success: function (result) {
window.onload = function () {
alert("map2");
debugger;
var latlng = new google.maps.LatLng(12.0895898, 34.099);
debugger;
var mapOptions = {

center: new google.maps.LatLng(markers[0].lat, markers[0].lng),
zoom: 8,
center: latlng,
mapTypeId: google.maps.MapTypeId.ROADMAP
};
debugger;
var infoWindow = new google.maps.InfoWindow();
debugger;
var map = new google.maps.Map(document.getElementById("map_canvas"), mapOptions);
debugger;
for (i = 0; i < obj.length; i++) {
var data = obj[i]
var myLatlng = new google.maps.LatLng(obj.latlng);
var marker = new google.maps.Marker({
position: myLatlng,
map: map,

});
debugger;
(function (marker, obj) {
google.maps.event.addListener(marker, "click", function (e) {
infoWindow.setContent(obj.FID,obj.No, obj.latit,obj.longi);
infoWindow.open(map, obj);
});
})(marker, data);
}
}
},
error: function (error) {
alert(error);
}
});
}

yes in this line i got the values
dt.Rows.Add(t.No, t.Longitude, t.Latitude);
and then i try to save these values in session and then try to call this session in jquery but i did not get values in these lines
t.No = Convert.ToString(HttpContext.Current.Session["No"]);
t.Latitude = Convert.ToSingle(HttpContext.Current.Session["Latitude"]);
t.Longitude = Convert.ToSingle(HttpContext.Current.Session["Longitude"]);

means still i did not get values in these lines
t.No = Convert.ToString(HttpContext.Current.Session["No"]);
t.Latitude = Convert.ToSingle(HttpContext.Current.Session["Latitude"]);
t.Longitude = Convert.ToSingle(HttpContext.Current.Session["Longitude"]);

$(function () {
var FID = '2012';
var ObID = '0';
var No = '';

var longi = '';
var latit = '';


var obj = {};
obj.FID = FID;
obj.ObID = ObID;
obj.No = No;
obj.longi = longi;
obj.latit = latit;

getdata(obj);
return false;

});

i already do this correction still no markers is display on google map when i check sources jqyery look like

still i got this error on console . Uncaught ReferenceError: getdata is not defined

yes @Karthik Bangalore i am getting the list

check updated question please @Karthik Bangalore

when i try this ..
string No = Convert.ToString(HttpContext.Current.Session["No"]);
float latit = Convert.ToSingle(HttpContext.Current.Session["Latitude"]);
float longi = Convert.ToSingle(HttpContext.Current.Session["Longitude"]);

then No , latit and longi shows null like this ""

on these lines @Karthik Bangalore
string No = HttpContext.Current.Session["No"].ToString();
float Latitude = Convert.ToSingle(HttpContext.Current.Session["Latitude"]);
float Longitude = Convert.ToSingle(HttpContext.Current.Session["Longitude"]);

[WebMethod]
public static string mapgriddata(string FID,string ObID)
{
try
{
string result = "";
FID = HttpContext.Current.Session["FID"].ToString();
ObID = HttpContext.Current.Session["ObID"].ToString();
Entities w = new Entities();
List(spgetdata_ffid_Result) gt = w.spgetdata_ffid(FFID).ToList();
DataTable dt = new DataTable();
dt.Columns.Add("NO", typeof(string));
dt.Columns.Add("Longitude", typeof(float));
dt.Columns.Add("Latitude", typeof(float));


foreach (var t in gt)
{

dt.Rows.Add(t.No, t.Longitude, t.Latitude);
}
string No = HttpContext.Current.Session["No"].ToString();
float Latitude = Convert.ToSingle(HttpContext.Current.Session["Latitude"]);
float Longitude = Convert.ToSingle(HttpContext.Current.Session["Longitude"]);
result = DataSetToJSON(dt);
return result;

}
catch (Exception)
{
throw new Exception();
}
}

flow..
login.aspx --> wrong information--> login.aspx
|
correct info
|
Webform2.aspx

but when i do that through if else then when i enter wrong information then this redirect to page whereas i want to show error as i posted my code in question

ok so that means i check condition through if else?

@Karthik Bangalore i try this ..

updated

protected void Button1_Click(object sender, EventArgs e)
{
try
{
loginmethod(txt_us.Text, txt_pwd.Text);
FormsAuthentication.Initialize();
String strRole = Assignroles(txt_us.Text);
FormsAuthenticationTicket fat = new FormsAuthenticationTicket(1, txt_us.Text, DateTime.Now, DateTime.Now.AddMinutes(30), false, strRole, FormsAuthentication.FormsCookiePath);
Response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName,
FormsAuthentication.Encrypt(fat)));
loginmethod(txt_us.Text, txt_pwd.Text);
Response.Redirect("home.aspx");
}
catch
{
Label1.Text = ("Incorrect UserName/Password");
Label1.Visible = true;
}
txt_us.Text = "";
txt_pwd.Text = "";
}
login method

private bool loginmethod(string UserName, string Password)
{
if((txt_us.Text!="NA") && (txt_pwd.Text!= "NA"))
{
login_class lg_class = new login_class();
Entities2 login = new Entities2();
string logn = Convert.ToString(lg_class.loginfunction(UserName, Password).Rows[0]["id"]);
Session["ID"] = logn.ToString();
return (logn);
}
else
{
return false;
}

}


private string Assignroles(string username)
{
if ((txt_us.Text !=string.Empty) && (txt_pwd.Text!= string.Empty))
return "";
else
return string.Empty;
}
when i try above code and when i login with wrong username and password then this show error incrrect username and password

but when i enter correct information i.e. username and password then this always show incorrect username and password where as i want to redirect another page when info is correct

issue is when i enter wrong username and password and click on button then this redirect to WebForm2.aspx page whereas i want to show message on login page i.e. incorrect username and password when wrong information is entered

yes @Karthik Bangalore

dt returns id .. this return id against username and password

you are right i need this :/ please suggest some good books

check update question

check update question

check update question

ok now i do that ..
private string loginmethod(string UserName, string Password)
{
login_class lg_class = new login_class();

try
{

Entities2 login = Entities2();


lg_class.loginfunction(UserName, Password);
Session["ID"]

return ;
}
catch (Exception ex)
{

throw new Exception();

}

Error 4 An object of a type convertible to 'string' is required

want to open form2.aspx as a new page in new tab

thanku now working when i try this

ok i try this ..

if (!Page.IsPostBack)
{
if (Session["UserName"] == "admin")
{
regiondrop.DataSource = tea.spadminlist().ToList();
regiondrop.DataTextField = "Region";
regiondrop.DataValueField = "Region";
regiondrop.DataBind();
Label4.Visible = false;

}
else
{
var list = tea.tblReg.AsEnumerable()
.Where(x => !x.Region.Any(char.IsDigit) && (x.Region != ""))
.GroupBy(x => x.Region)
.Select(x => new { Region = x.Key, Value = x.Key })
.ToList();
regiondrop.DataSource = list;
regiondrop.DataTextField = "Region";
regiondrop.DataValueField = "Region";
regiondrop.DataBind();
Label4.Visible = false;
}

}


this show warning.. Warning 3 Possible unintended reference comparison; to get a value comparison, cast the left hand side to type 'string'

in login.aspx i save username is session

Session["UserName"] = txt_us.Text;
in form.aspx

Here first i create sp

ALTER procedure [dbo].[spadminlist]
as
select Region from tblReg
where Region in ('Factory')
then i add this sp in form.aspx

//this linq query for selecting all values

var list = tea.tblReg.AsEnumerable()
.Where(x => !x.Region.Any(char.IsDigit) && (x.Region != ""))
.GroupBy(x => x.Region)
.Select(x => new { Region = x.Key, Value = x.Key })
.ToList();
//this is for admin

if (Session["UserName"] = "admin")
{
List <spadminlistresult> admin = tea.spadminlist().ToList();
}
and filling dropdown

if (!Page.IsPostBack)
{
regiondrop.DataSource = list;
regiondrop.DataTextField = "Region";
regiondrop.DataValueField = "Region";
regiondrop.DataBind();

Label4.Visible = false;



}
but this show error and also how i fill dropdown with admin sp because there is queries

Error 3 Cannot implicitly convert type 'object' to 'bool'. An explicit conversion exists (are you missing a cast?)
how i do this ?

ok how i sepcify that when admin login then show these values otherwise when user login then show these values .. how i configure my dropdown linq query or sp login..
ALTER procedure [dbo].[splogin]
@UserName nvarchar(50),
@Password nvarchar(50)
as
select UserName , Password from tbllogin
where
UserName=@UserName and Password=@Password

but how to select specific values for admin and user

yes i know that but the problem is all values are in one table and i use this query for filling drodown

var list = tea.tblReg.AsEnumerable()
.Where(x => !x.Region.Any(char.IsDigit) && (x.Region != ""))
.GroupBy(x => x.Region)
.Select(x => new { Region = x.Key, Value = x.Key })
.ToList();




if (!Page.IsPostBack)
{
regiondrop.DataSource = list;
regiondrop.DataTextField = "Region";
regiondrop.DataValueField = "Region";
regiondrop.DataBind();

Label4.Visible = false;



}

but dropdown list control is in form.aspx and login code is in login.aspx.. . there is several values in dropdown which i fetch from database and fill in dropdown using linq query ..

@Richard Deeming check update please

ok thanku for useful information

beacuse in highcharts jsfiddle data in series display like this name: 'Tokyo', data: [7.0, 6.9, 9.5, 14.5, 18.4, 21.5, 25.2, 26.5, 23.3, 18.3, 13.9, 9.6] },

ok

.NET AND PLEASE CHECK UPDATE QUESTION

I did not find thats why i post here :/

there is no rule actually when i try to execute query individually like this

select distinct
tblRv.Owner,

count(tblVv.VName) as data
from tblRe
inner join tblRv
on tblRe.RID=tblRv.RID
inner join tblVv
on tblRv.ID=tblVv.MID
where tblRv.Owner='roh' and
tblRe.StartDate = '2016-06-01 00:00:00'
AND tblRe.EndDate <= '2016-06-30 23:59:59'
and VName <> ''
and tblRe.region='uk'
group by
tblRv.Owner,
order by tblRv.Owner

so this show data e.g. in the month of june data is "1"
owner data
roh 1

no ok now i get the idea but if use pivot then result is same like this 3,10,6 but i want result like this 3,1,0 . this does not effect on result i think?

how to use pivot ? will you please describe because i never use this before

i already try through sql profiler but i did not find search_Data method or griddata in SQL profiler

my sp return 24 rows

check update @Suvendu Shekhar Giri

@F-ES Sitecore check this image i set return type int .. http://i.imgur.com/TXonGOp.png

type of return data?

i only add this line in sp WHERE tblReg.StartDate >= @startdate AND
tblReg.EndDate <= @enddate
and tblReg.Region = @region

my model extension is .edmx

i also re add this..

so what should i use instead of var

problem solved

check this fiddle.. this does not work ..
https://jsfiddle.net/2oc7gxov/3/

i already try this but not work

i try to create through jquery .. like this .. success: function (result) {
var final = JSON.parse(result.d).response;

console.log(JSON.parse(result.d).response);
$("#tabledata").empty();

if (final.length > 0) {
$("#tabledata").append(
"<tr><th>ID</th><th>Owner</th><th>RegNo</th></tr>");

for (var i = 0; i < final.length; i++) {

if (final[i] !== null) {
$("#tabledata").append("<tbody><tr><td>" +
final[i][0] + "</td> <td>" +
final[i][1] + "</td> <td>" +
final[i][2] + "</td></tr></tbody>");

}
}
$("#tabledata tr:first").addClass('GridviewScrollHeader');
$("#tabledata tr").addClass('GridviewScrollItem');


}

ok now this worked.. success: function (result) {

if(result !==null && result.length >0){
strarr = result.d;
var myarr = strarr;
$("#divcontainer").dialog('open');
Drewchart(myarr);
}
else{
$("#<%=Label4.ClientID%>").text('No data found')
$("#tabledata").hide();
$("#divcontainer").dialog('hide');
}
} ,

when i run this table is hide and message is show but pop is display where there is no data so how i hide pop up when i add line $("#divcontainer").dialog('hide'); this show error jquery.min.js:2 Uncaught Error: no such method 'hide' for dialog widget instance

when i set debugger adn when i check f12 this show like that where there is no data..http://oi68.tinypic.com/2ic2t75.jpg and where there is data this show like this .. http://oi68.tinypic.com/2rxh2wx.jpg

have you check my recent comment?

when i set debugger adn when i check f12 this show like that where there is no data..http://oi68.tinypic.com/2ic2t75.jpg and where there is data this show like this .. http://oi68.tinypic.com/2rxh2wx.jpg

this is show now error .Uncaught TypeError: Cannot read property 'length' of undefined

@F-ES Sitecore ok i try your answer.. i try this .. success: function (result) {
var myData = JSON.parse(result.d);
if (myData.length == 0 && myData!==null) {
$("#Label4").text('No data found')
return;
}
strarr = result.d;
var myarr = strarr;
Drewchart(myarr);
},
this show not any error but this also not show any message. e.g. No data found

error is same "Sequence contains no elements" this means there is no data.. so how i handle this when there is no data then i want to show message no break the code

when i try this this show this.. check please https://media.giphy.com/media/26gJznDimxRyV0zi8/giphy.gif

problem solved

@Suvendu Shekhar Giri check update

yes i add links and there is error on console.. WebForm3.aspx:34 Uncaught TypeError: Cannot read property 'value' of null

and your link did not help

i already bind in jquery.. if you check jquery which i posted and this is the webmethod..

[WebMethod]
public static string search_data(DateTime fromdate, DateTime todate, string regiondrop)
{
try
{
string result = "";
TrackDataEntities1 ts = new TrackDataEntities1();

var dq = (from table name ........ .. .ToList();
DataTable dt = new DataTable();

dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("OwnerName", typeof(string));
foreach (var c in dq)
{
dt.Rows.Add(c.ID, c.ownername);
}

result = DataSetToJSON(dt);

return result;
}
catch (Exception)
{
throw new Exception();


}

}
public static string DataSetToJSON(DataTable dt)
{

Dictionary<string, object=""> dict = new Dictionary<string, object="">();

object[] arr = new object[dt.Rows.Count + 1];

for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
arr[i] = dt.Rows[i].ItemArray;
}


dict.Add("response", arr);

JavaScriptSerializer json = new JavaScriptSerializer();
return json.Serialize(dict);
}

hi.. when i add this .. <asp:Repeater ID="gridata" runat="server">
<HeaderTemplate>
<table cellspacing="0" rules="all" border="1">
<tr>
<th>
</th>

</tr>
</HeaderTemplate>
<itemtemplate>
<tr>
<td>
</td>
</tr>

<footertemplate>
</table>


then this repeater not display on page

when i try this $("#GridView1").append("<tr><th class='GridviewScrollHeader'>ID ... and when i check there is no effect in header... and this is css class. .

.GridviewScrollHeader TH, .GridviewScrollHeader TD
{
padding: 5px;
font-weight: bold;
white-space: nowrap;
border-right: 1px solid #AAAAAA;
border-bottom: 1px solid #AAAAAA;
background-color: #EFEFEF;
vertical-align: bottom;
text-align: left;
}
.GridviewScrollItem TD
{
padding: 5px;
white-space: nowrap;
border-right: 1px solid #AAAAAA;
border-bottom: 1px solid #AAAAAA;
background-color: #FFFFFF;
}
.GridviewScrollItem .Freeze
{
background-color: #EFEFEF;
}
.GridviewScrollItemHover TD
{
padding: 5px;
white-space: nowrap;
border-right: 1px solid #AAAAAA;
border-bottom: 1px solid #AAAAAA;
background-color: #CCCCCC;
cursor: pointer;
}
.GridviewScrollItemHover .Freeze
{
background-color: #CCCCCC;
}
.GridviewScrollItemSelected TD
{
padding: 5px;
white-space: nowrap;
border-right: 1px solid #AAAAAA;
border-bottom: 1px solid #AAAAAA;
background-color: #999999;
color: #FFFFFF;
}
.GridviewScrollItemSelected .Freeze
{
background-color: #999999;
}
.GridviewScrollPager
{
border-top: 1px solid #AAAAAA;
background-color: #FFFFFF;
}
.GridviewScrollPager TD
{
padding-top: 3px;
font-size: 14px;
padding-left: 5px;
padding-right: 5px;
}
.GridviewScrollPager A
{
color: #666666;
}

.GridviewScrollPager SPAN
{
font-size: 16px;
font-weight: bold;
}

if i use html table like this <table>
<tr>
<th>Firstname</th>
</tr>
<tr>
<td>Jill</td>
</tr>
</table>
then i dont want to insert data manually i fetch data from database so what i write instead of first name and jill

DirectoryInfo.Refresh? purpose of this folder is updated on every 2 mint so i refresh folder through code

@OriginalGriff have you check my update question and errors?

@OriginalGriff check my updated code in question i update webmethod and jquery when i build this show errors

beacuse of LONG JQUERY i post in 2-3 parts please check ... so i use two webmethod on one button when i build the code and click on button then nothing happens so when i check console by F12 this shows " Uncaught ReferenceError: from is not defined"

in dq when i check data is .. [0] = { ID = 1, OName = "Khan", RegNo = "AJ-24",Speed = "124" } [1] = { ID = 2, OName = "Shah", RegNo = "AL-91",Speed = "95" }

in dq there is json data now i try to display this data in gridview

howw

because i want to display data in gridview

i try to achieve display data is girdview so for this now i use datatable instead of string..

i can not get last access file of folder abc and def. where as today is 1-07-2016 when i set breakpoint i got date 6/30/2016

In your code, there is no code that send SMS so it is not possible to tell you where the problem is. However, it would be very easy for you to put a breakpoint on the code that does send the SMS and see why a message is sent.
------sms is sending from database so forget about sms sending--------


That being said, why would you check every 4 seconds? If you need such accuracy, would not using a FileSystemWatcher be more appropriate (FileSystemWatcher Class (System.IO)[^])?
-----yes i need that such accuracy how i do that. i want to check every 5 mint-------


I think that one problem with your code is that you add a item in the table every 4 seconds so you would send a lot of SMS if you send one for each row in the table. You probably need to remember if a SMS was sent and only sent one if no SMS where sent. Otherwise, you would have a lot of message to send.
----yes that is the problem sms sending continuously .. when i check my cell phone there is about 12+ sms .. where as i want when file is not created with in 5 seconds then want to insert record in table only one time ---


and i set path address in app.config file i.e.C:\Users\Administrator\Desktop\abc

actually msg is sent from database. here i just insert the row in table and from that table msg is sending.. when i set break point i see that 5 mint not over and data is sending to table ... how i modified the code? @Philippe Mori

when is select UK from drop-down and select these dates from calendar
from date '2014-02-01' AND
to date '2014-02-28'.. i am getting these values but i can not get data in gridview

yes i am getting these values

WHY THIS ?blvv.MID = 1 where as i want to get result when user select region from drop-down and dates from calendar?

sorry this table tblRegionVehicles_Uni is same as tblRV .. check update and there is ID in both tables

NOW CHECck

check update please i post columns of both tables

There is drop-down with region names and there is two calendars i place with fromdate and todate ID..


<asp:Label ID="Label3" runat="server" Text="Select Region">
<asp:DropDownList ID="regiondrop" runat="server" AutoPostBack="True"
onselectedindexchanged="regiondrop_SelectedIndexChanged">

<br /><br />

<asp:Label ID="Label1" runat="server" Text="From Date">
<input ID="fromdate" value="dd/mm/yyyy" runat="server" clientidmode="static" />
<br />

<asp:Label ID="Label2" runat="server" Text="To Date">

<input ID="todate" value="dd/mm/yyyy" runat="server" clientidmode="static" />



<br /><br />
<input type="button" ID="search_data" runat="server" class="sear_btn" value="Search Data" />
<br /><br />

hi when i try this ..
[WebMethod]
public static string GetVo(DateTime fdate, DateTime tdate, string region)
{
string data2 = "[";
try
{


T1 DB = new T1();

var rea = (from rv in DB.tblRV
join Reg in DB.tblRe on rv.RegionID equals Reg.RegionID
join vv in DB.tblVV on rv.ID equals vv.ID

where
Reg.Region==region
&& (vv.VName != "")
&& Reg.StartDate == fdate &&
Reg.EndDate == tdate

group vv by vv.VName into g
select new
{
Name = g.Key,
cnt = g.Select(t => t.Name).Count()
}).ToList();
data2 += rea.ToList().Select(x => "['" + x.Name + "'," + x.cnt + "]")
.Aggregate((a, b) => a + "," + b);
data2 += "]";


}
catch (Exception ex)
{
throw new Exception();
System.Web.HttpContext currentContext = System.Web.HttpContext.Current;
currentContext.Response.Write("<script>alert('" + currentContext.Server.HtmlEncode(ex.ToString()) + "')</script>");
}
return data2;

}

this shows ERROR

Sequence contains no elements

sorry i solve this .. and i update question.. i think during my update you post this please update your answer as per my question

///

/// No Metadata Documentation available.
///

[EdmEntityTypeAttribute(NamespaceName="TrackDataModel", Name="t1")]
[Serializable()]
[DataContractAttribute(IsReference=true)]
public partial class t1: EntityObject
{
#region Factory Method

///

/// Create a new t1 object.
///

/// <param name="regionID">Initial value of the RegionID property.</param>
public static t1 Createt1(global::System.Int32 regionID)
{
t1t1 = new t1();
t1.RegionID = regionID;
return t1;
}

#endregion
#region Primitive Properties

///

/// No Metadata Documentation available.
///

[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
[DataMemberAttribute()]
public global::System.Int32 RegionID
{
get
{
return _RegionID;
}
set
{
if (_RegionID != value)
{
OnRegionIDChanging(value);
ReportPropertyChanging("RegionID");
_RegionID = StructuralObject.SetValidValue(value);
ReportPropertyChanged("RegionID");
OnRegionIDChanged();
}
}
}
private global::System.Int32 _RegionID;
partial void OnRegionIDChanging(global::System.Int32 value);
partial void OnRegionIDChanged();




///

/// No Metadata Documentation available.
///

[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
[DataMemberAttribute()]
public global::System.String Region
{
get
{
return _Region;
}
set
{
OnRegionChanging(value);
ReportPropertyChanging("Region");
_Region = StructuralObject.SetValidValue(value, true);
ReportPropertyChanged("Region");
OnRegionChanged();
}
}
private global::System.String _Region;
partial void OnRegionChanging(global::System.String value);
partial void OnRegionChanged();

///

/// No Metadata Documentation available.
///

[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
[DataMemberAttribute()]
public Nullable<global::system.datetime> StartDate
{
get
{
return _StartDate;
}
set
{
OnStartDateChanging(value);
ReportPropertyChanging("StartDate");
_StartDate = StructuralObject.SetValidValue(value);
ReportPropertyChanged("StartDate");
OnStartDateChanged();
}
}
private Nullable<global::system.datetime> _StartDate;
partial void OnStartDateChanging(Nullable<global::system.datetime> value);
partial void OnStartDateChanged();

///

/// No Metadata Documentation available.
///

[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
[DataMemberAttribute()]
public Nullable<global::system.datetime> EndDate
{
get
{
return _EndDate;
}
set
{
OnEndDateChanging(value);
ReportPropertyChanging("EndDate");
_EndDate = StructuralObject.SetValidValue(value);
ReportPropertyChanged("EndDate");
OnEndDateChanged() <div id="Edit

is there any other easy method ??

ok this is done but i dont understand these lines.. Dictionary<int, string=""> dict = new Dictionary<int, string="">();
foreach (var item in list1.OrderBy(k=>k.Region))
{
if(!dict.ContainsValue(item.Region))
dict.Add(item.RegionID, item.Region);
}

protected void Page_Load(object sender, EventArgs e)
{
T1 tea = new T1();
var list1 = tea.t1.ToList();
Dictionary<int, string=""> dict = new Dictionary<int, string="">();
foreach (var item in list1.OrderBy(k => k.Region))
{
if (!dict.ContainsValue(item.Region))
dict.Add(item.RegionID, item.Region);
}
var output = dict.Select(k => new { RegionId = k.Key, Region = k.Value }).ToList();




if(!Page.IsPostBack)
{
regiondrop.DataSource = list;
regiondrop.DataTextField = "Region";
regiondrop.DataValueField = "RegionID";
regiondrop.DataBind();

}

}

this shows same output like repeated values in dropdown

when i try this .
protected void Page_Load(object sender, EventArgs e)
{

T1 tea = new T1();
var list1 = tea.table1.ToList();
var list = from ta in list1
group ta by ta.Region into newgroup
orderby newgroup.Key
select newgroup;

this shows same output like repeated values in dropdown



if(!Page.IsPostBack)
{
regiondrop.DataSource = list;
regiondrop.DataTextField = "Region";
regiondrop.DataValueField = "RID";
regiondrop.DataBind();

}

}

hi.. it works but calendar formatting is out.. when i try calendar look like this please check link.. http://oi66.tinypic.com/opxr0k.jpg

and i want this http://oi64.tinypic.com/169oy8j.jpg

2nd link calendar appear but functionality is not perform whereas 1st link calendar appear below the 2nd link calendar and functionality perform .. and i need 2nd link calendar with functionality ....

thanks you much

which changes?

i post select beacuse i want to clarify that i want to do like that in linq

in foreach loop?

yes exaclty

cehck update and comment

check update

i edit this

For Each p1 As PointLatLng In parallelLines3
s2 += p1.Lat.ToString() + "," + p1.Lng.ToString()

oSheet.Range("A1").Value() = p1.Lat.ToString(s2)
oSheet.Range("B1").Value() = p1.Lng.ToString(s2)
Next
but file not save

i try this but file not save

so how i done this

i already declared ...
Dim worksheet As Excel.Worksheet
Dim workbook As Excel.Workbook
Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object
Dim s1 As String = ""

please check update question

first i write this ... Dim parallelLines3 As New List(Of PointLatLng)
Dim parallelLines4 As New List(Of PointLatLng)

..

"usin" this is "using"..

thank a lot

updated .. please check

yearValue.Selectedvalue .. select value from drop down
and yearp is the parameter which i pass in function

i want in if that when any value select from dropdown then data is displayed..

and i displayed data in alert box

there is a dropdown in page and in that drodown i fill values from db .. so the value i selected in dropdown must be in yearp

yearp is a parameter

i cannot post complete code.. now please check updated question

yes

but did not work

k

this is function is for blue line .. now if i want to create another line opposite of this then is this possible?

now i want to draw another 2 lines.. one line is in right and other in left with -500 lag and -500 lat

like this

lat line main line lag line

| | |

check update

i this part .Select(s=>new{
Catg_type=s
})

how i call this Catg_type.Catg_type,Program_type.Prog_name ,Year_info.year,

ok now i try this
var query=a.Std_info
.Join(a.Catg_type,catg=>catg.Catg_id,std=>std.Catg_id,(catg,std)=>new{catg=catg,std=std})
.Join(a.Program_type,pg=>pg.catg.Prog_id,pt=>pt.Prog_id,(pg,pt)=>new{pg=pg,pt=pt})
.Join(a.Year_info,yr=>yr.pg.catg.year_id,yi=>yi.year_id,(yr,yi)=>new{yr=yr,yi=yi})
.Select(s=>new{
Catg_type=s
})

now how to pass parameter "year_p" in linq?

i try this var re = (from stdtable in a.Std_info
join catg in a.Catg_type on stdtable.Catg_id equals catg.Catg_id
join prog in a.Program_type on stdtable.Prog_id equals prog.Prog_id
join yea in a.Year_info on stdtable.year_id equals yea.year_id
group stdtable by new { catg.Catg_type1, prog.Prog_name, yea.year, stdtable.Catg_id } into z
select new
{
Catg_type1 = z.Key.Catg_type1,
Prog_name = z.Key.Prog_name,
year = z.Key.year,
Catg_id = z.Key.Catg_id
}).ToList();

var result = new
{
Total = re.Select(p => p.Catg_id).Distinct().Count()
};

i call this path in code like this
string abc="";
abc= ConfigurationManager.AppSettings.Get("abcpath");

i know this is not valid IP address. i mention rough IP address

if i do this
connectionString="Data Source=\\122.324.234\Logs\asdslog;uid=abc; password=123"

then is this right?

well .. will you please tell me how to store?

ok thanku

i mean at runtime i want to refresh folder..

so now i declare var result = a.spstdinfo(year);
and now error shows
foreach statement cannot operate on variables of type 'int' because 'int' does not contain a public definition for 'GetEnumerator'

which property

thanku for suggestion

please check update question

[Inappropriate code sample removed — SA]
1) Use "Improve question" and format code;
2) The method in question is not shown anyway.

if u check varaible a at the top ProjectdbEntities a = new ProjectdbEntities(); and spstdinfo is store procedure ... i create classes through database so all properties are in ProjectdbEntities and also i call store procedure

george please explain briefly

it shows error Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

please explain more little bit

curretn data is in this format
the last time 5/11/2016 11:23 am
the last time 5/11/2016 11:25 am

this is only for abc .. how i dispaly for def

and when i use this path = ConfigurationManager.AppSettings.Get("def"); then how i i identity data when i run this application

i already share

if i add this then path same name exist in this line
path = ConfigurationManager.AppSettings.Get("abc");

THIS is test so firstly i want to check

actually i want to achieve that when someone create a new file in new folder then i want that modified date time to check when new file is created in this folder.. hope u understand

no..

ok if i create any new file in new folder .and i want that file date time then what i can do .. i also remove db.txt from path then when i create new file in folder and then i run to display date time then this shows error Access to the path 'C:\Users\Administrator\Desktop\New folder' is denied.

through this line i try to show date time when the file is created/modified

i dont want current date time .. i want the time when file is created / modified in folder

OH HO .... thanku ;)