Comments by itsathere (Top 162 by date)

binary string

An exception occurs on Response.End();
and the exception is
ex = {Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack.}

If you need more information, I can share that too.

I am using .net and I am not able to insert data more than 32,767 characters

You have neither understand the question nor you have readout the question carefully that's why you are asking these question. Just read the question carefully and here is the link for you https://www.nuget.org/packages/jquery-globalize/

All would be valid but conversion to date happen on region basis. If I will try to convert another region format into my region then it will return invalid date.

can you explain it with example

I want to remove space and line breaks too. As I have mentioned the format above.

No, I am not building it. I am getting json format and inserting it to database and again trying to use that json and getting exception.

Yes. Now, I have got solution.

Thanks

It's known thing, I need proper solution that's why I have posted it here.

Thanks

@Html.DropDownListFor(m => Model.UserId, (Model.GetUsers == null ? Enumerable.Empty<selectlistitem>() : Model.GetUsers.Select(a => new SelectListItem { Text = a.Name, Value = a.ID.ToString() })), new { @class = "form-control" })

Yes and still trying to find.

But I need it dyanamic try to understand the situation.Btw thanks for your valuable time.

Thanks for suggestion.I am trying to figure it out.

I have dynamic lots of data to bind in header not only 7.When 1st time I load calendar then fullcalendar binds data correctly because I am providing json databut on search it should be change dynamically.So, header will be dynamic.

Yes, header should be like your mentioned image url.

But I have lots of column to bind in header but there is only 7 days in a week then how will I handle lots of data in your scenario.

City1 city2 city3 city4 city5 ... these are dynamic header in place of Sun/Mon/Tue/Wed/Thu/Fri/Sat

and I need to change it dynamically onchange in dropdownlist.
below is url of snap shot
http://imgur.com/FnHkZ7x

Yes. below is url of snap shot
http://imgur.com/FnHkZ7x

I don't know to how to post screen shot but I am an example below

City1 city2 city3 city4 city5 ... these are dynamic header in place of Sun/Mon/Tue/Wed/Thu/Fri/Sat

and I need to change it dynamically onchange in dropdownlist.

If you see the demo fullcalendar header of calendar show Sun/Mon/Tue/Wed/Thu/Fri/Sat.In my case all these days are places which is dynamic and I need to change it dynamically.

If you see the demo fullcalendar header of calendar show Sun/Mon/Tue/Wed/Thu/Fri/Sat.In my case all these days are places which is dynamic and I need to change it dynamically.

On dropdownlist change I need to refresh data of calendar where header and event of calendar is dynamic.I am able to change event title but unable to change it's header value

thanks, I have done it by myself before you have provided the solution.

It's same solution I have tried and given link of stackoverflow, have few modifications that's it. btw thanks.

http://stackoverflow.com/questions/1146789/rendering-a-hierarchy-of-options-in-a-select-tag

Trying to implement the same.

loop will take time.Is it possible or not?

It's windows authentication not active directory authentication.

I have got the solution by putting @@ at @.Thanks for your reply.
previous version

var pwd = /^(?=.*[a-zA-Z])(?=.*\d)(?=.*[!@#$%^&*()_+])[A-Za-z\d][A-Za-z\d!@#$%^&*()_+]{6,}$/

new version

var pwd = /^(?=.*[a-zA-Z])(?=.*\d)(?=.*[!@@#$%^&*()_+])[A-Za-z\d][A-Za-z\d!@@#$%^&*()_+]{6,}$/

@ not support in mvc view due to razor engine. I have checked regex
var pwd = /^(?=.*[a-zA-Z])(?=.*\d)(?=.*[!@#$%^&*()_+])[A-Za-z\d][A-Za-z\d!@#$%^&*()_+]{6,}$/
if you are able to modify, reply.

Yes, it fine but what about if i use regular expression like below but getting error ""#" is not valid at the start of a code block. Only identifiers, keywords, comments, "(" and "{" are valid." due to razor

var pwd = /^(?=.*[a-zA-Z])(?=.*\d)(?=.*[!@#$%^&*()_+])[A-Za-z\d][A-Za-z\d!@#$%^&*()_+]{6,}$/

on button click call call controller action method using ajax/json. You will get many code on google search.I think, it will be better for you.

I have created a desktop application and used below code System.Diagnostics.Process.Start("http://localhost:2042/Admin/EmailDatabase/Sendeamil");
to redirect url in browser it will help to reach the method at particular time .It's working after clicking that shortcut of executable file but after scheduling and attachment of the shortcut file not working the same.

Yes, Its working.Thanks for explanation.

Explain please.

what is 'key'='a'

No, from database. I think it does't matter.

Yes.

I can't attach image here because i think there is no way to upload image in codproject and link is not shareable.

when i try those link header comes in a multiple line and rows mix with another rows and all looks hazy.

In csv file, I am watching below format

A B C D E
1 COLUMN1 COLUMN2 COLUMN3 COLUMN4
2 col val col val col val col val
3 col val col val col val col val
4 col val col val col val col val

after export, Table data is like below format

csvfileName#csv.E1 csvfileName#csv.E2 csvfileName#csv.E3 csvfileName#csv.E4

1 - s @
1 4 c f

using (OleDbCommand cmd = new OleDbCommand(string.Format
("SELECT * FROM [{0}]", file.Name), con))
{
con.Open();

// Using a DataReader to process the data
using (OleDbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
// Process the current reader entry...
// I don't understand
}
}

// Using a DataTable to process the data
using (OleDbDataAdapter adp = new OleDbDataAdapter(cmd))
{
DataTable tbl = new DataTable("MyTable");
adp.Fill(tbl);

foreach (DataRow row in tbl.Rows)
{
// Process the current row...
// I don't understand
}
}
}

In current situation csv file is reading but Column Name is not matching with exact .csv file column and column value is also not same. MyTable datatable value is in different format or something goes wrong.

Your suggested url is good but i am not getting the column name and row values matches with csv file.What to do for?

I am able to read the csv file from my above code but main problem is column have sentences with , separated and StreamReader is reading all column with comma separated so,

If I have column

"Column1" "column2" "column3" "column4" "My, Name"

In above i have 5 column

after result i am getting "Column1","column2","column3","column4","My","Name"

and if I split column with ,

then i am getting 5 column ("Column1","column2","column3","column4","My","Name")

so, can you explain me how to split column with ",

Did you check the indexes?

explain please

still takes 30 seconds and my query takes 23 seconds

select ID, ErrorDescription, ErrorPage, IpAddress,
PageEvent, Status, CONVERT(varchar(50),CreatedDate,103) as CreatedDate,
(case when Status=1 then 'Open' when Status=0 then 'Resolved' end) as IsActive from dbo.ExceptionLog order by ID desc


this query takes above 60 seconds on execution

Table have foreign keys. Btw thanks again.

I have done that. Thank you.

THANKS.

getting Incorrect syntax near '('.Ok, I am able to resolve error but what about paging if we remove where clause.

Incorrect syntax near '('.

ALTER PROCEDURE [dbo].[Profile_GETCity]
@PageSize int = null,
@CurrentPage int = null,
@SortExpression nvarchar(max) = null

AS

BEGIN
SET NOCOUNT ON

DECLARE @SqlString nvarchar(max)
Declare @UpperBand int
Declare @LowerBand int

SET @LowerBand = (@CurrentPage - 1) * @PageSize
SET @UpperBand = (@CurrentPage * @PageSize) + 1

BEGIN


SET @SqlString='
WITH
aliases as (
SELECT
[ID],
[Name],
state=(select Name from State_District where City.StateId=State_District.ID),
District=(select Name from State_District where City.DistrictId=State_District.ID),
[PinCode],
[status] = CASE [IsActive]
WHEN 1 THEN ''label label-sm label-success''
WHEN 0 THEN ''label label-sm label-danger'' END,
[commandname] = CASE [IsActive]
WHEN 1 THEN ''Active''
WHEN 0 THEN ''InActive'' END
FROM [dbo].[City]
),
tempProfile AS
(
SELECT
[ID],
[Name],
state,
District,
[PinCode],
[status],
[commandname]
ROW_NUMBER() OVER (ORDER BY '+ @SortExpression+', ID ) AS RowNumber
FROM aliases
)

SELECT
[ID],
[Name],
state,
District,
[PinCode],
[status],
[commandname]
FROM
tempProfile '



end
EXEC sp_executesql @SqlString
END

Yes, I am trying for paging with sorting in asp.net webforms.After removing where clause I am getting error incorrect syntax near '('

I have already tried this is not working.

this query is not returning any data.

Your idea is quite good but i have done it by onkeyup method.

Thanks.

I wanna click event to redirect details page on image click using anchor tag.

Use?.If you have idea then reply.Why should you reply if u r unable to explain.

yes.

on postback event in Page_Load i have recreated that panel again and if i try to delete from same panel then it's not working but if i delete from another panel it's working fine.

create a hidden field and in onchange method of dropdown/textbox store dropdown/textbox value.Finally, on model popup click assign that hidden field value.

when i placed '>' this link working but image link not working.you can see the below code

><img src=cid:companylogo/>

I have updated my question details.

autocomplete works fine but have word arrangement problem on search. when i put a in textbox it's not showing all values start with a.

thanks.

Yes.I have created a alert message after for loop; alert also showing data but autopopulate..

after json result i have checked arrylist on mouse over on records[], it shows array like availableTags but autopopulate not working on records[].

above solution does not match requirement.I want to implement that in "Gridviewscroll demo".
btw thanks for comment.

var receiveDetails = objDB.GetAllReceivedDetails()
.Where(a =>
a.ReceiveDate.Value.Date == DateTime.Now.Date &&
((DateTime.Now - a.ReceiveDate.Value).TotalHours <=1));

U have done mistake

btw Thanks.

Thanks.

whatever u have written i think, it's sql command to backup database.

In same machine works locally but not from server.I have changed our app to 32 bit but still have same error

You did not get the point i have written..Actually, I want to show 2 different view from same controller one for list page another target blank(new tab).

It wil be better if i use Timespan

DateTime recentTime = DateTime.Now;
TimeSpan timespan = new TimeSpan(10, 30, 00);
DateTime Exdt = recentTime.Date.Add(timespan);
if(DateTime.Now>Exdt )
{

}

Btw Thanks.

Q.can we add time in date?

Example:
Date=6/10/2015+10:30 AM

please explain..

it's not exact solution..i have to do it dynamically or on database value
btw yesturday, i have solved it by myself.

Thanks.

how will i insert UTC time into sql and after insertion how will i get the actual time in different time zone.

Good Idea..
thank u.

var Physiciandetails = objDb.SelectAll().ToList();

Physiciandetails is a list where all table data is available. Now, i want a where clause like below to search FacilityId

var Physiciandetails = objDb.SelectAll().ToList().Where(a=>a.FacilityId==16);

but FacilityId column shows result is like 16,17,14,2,10

Is it possible to search FacilityId within where clause.If yes, then how will i convert particular column to array and will use the array to exact search

If it's not possible to search within list then explain the store procedure for similar result.

I have a list which contains many rows.So, please explain me to convert particular column of list to array

data.Contains(16) not working properly..it gives result of 6 and 16.

actually it'll be better if u explain it in linq otherwise whatever u want.
thanks

I have updated actual linq.
now, i want hour difference between two datetime using below code
DeliveryLateTime = (DateTime.Now - Convert.ToDateTime(item.CreatedDate)).Hours,

I have checked database CreatedDate is not null and also checked like item.CreatedDate.Value but still error is same

I am using Model to insert,update data and model is like below code
public DateTime? CreatedDate { get; set; }

afterward i m using it.
before using Convert.ToDateTime it shows because of it's type DateTime?

elaborate please..

type of item.CreatedDate is DateTime. Actually, without using TimeSpan it may not be possible to get the difference and in linq if i will implement it then coding will be complex that's y i use another static method to get exact difference.

<script src="http://code.jquery.com/jquery-1.9.1.js"></script>
<script>
$(document).ready(function () {
var interval = setInterval("ReloadPage()", 60000);
});

function ReloadPage() {
location.reload();
}
</script>

In above script 60000 is time interval in miliseconds.

Thanks.

Thanks.

it's 2 hours early in chicago..I have change it locally by changing different time zone it works fine but someone sitting at chicago is saying "it's 2 hours early".What to do now.

if u have problem with my script then forget about above script and reply me new javascript

if u have problem with my script then modify and reply me the exact solution

Thanks.

it's clear and above javascript working but there is time difference at different country or zone.I have to show time with am/pm that's y i did it part wise(hour ,mins,ampm )

yeah, anyways thanks.

I have done it myself

Below is the javascript
<script>
function fnchkFlow() {
debugger;
var str = "1,2";
var items = $('#<% = chkFlow.ClientID %> input:checkbox');
for (var i = 0; i < items.length; i++)
{
if (items[0].checked == true) {
items[i].checked = true;
break;
}
else {
items[1].checked = false;
}
}

}
</script>

<table id="chkFlow" >
<tbody><tr>
<td><input id="chkFlow_0" type="checkbox" name="chkFlow$0" value="1"><label for="chkFlow_0">Flow</label></td><td><input id="chkFlow_1" type="checkbox" name="chkFlow$1" value="2"><label for="chkFlow_1">STAT</label></td>
</tr>
</tbody></table>

var optionStat = $(listbox).find("option[value='2']");

optionStat shows below

context: undefined
length: 0
prevObject: jQuery.fn.jQuery.init[1]
selector: "option[value='2']"
__proto__: jQuery[0]

var optionFlow = $(listbox).find("option[value='1']");

optionFlow shows like below
context: undefined
length: 0
prevObject: jQuery.fn.jQuery.init[1]
selector: "option[value='1']"
__proto__: jQuery[0]

It never go inside
if(optionFlow && optionFlow.length && optionStat && optionStat.length)
condition.When i remove the above condition then it always follow below else condition

if($(optionFlow).is(":checked"))
{
$(optionStat).prop('disabled',false);
}
else
{
$(optionStat).prop('checked',false);
$(optionStat).prop('disabled',true);
}

Yea i m testing it on chrome.

Have u test the javascript.It's not working

I need this in javascript because i have tried code behind.Code behind take time to check and uncheck that's why i wanna use javascript.

in javascript (clientside)

what do u mean?
If u have idea give then give me the javascript of the logic of onchange event

1. if listitem "Flow" will be checked then i can check "STAT" also.but without checking "Flow" i can not check "STAT".

2. If i have checked "Flow" and "STAT" also and then when i will uncheck "Flow" then i have to uncheck "STAT" also because without checking "Flow" i can not check "STAT".

it's was not working.Now, I have changed the code by making a new class object and providing data.d.ObjName and it's working fine.

Thanks.

thank you very much.. :)

thanks.

Your generated FacilityId inside while is not getting checked.what if next generated FacilityId inside while loop matches the database FacilityID.

what if nextFacilityId inside while loop also exist in database.How will i check it again and again till new nextFacilityId.

I did it..Thanks

<li>
<asp:ImageButton ID="btndBlue" runat="server" OnClick="btnDarkblue_Click" ImageUrl="images/Dark_Blue.jpg"
Width="30" Height="30" /></li>

<li>
<asp:ImageButton ID="btndBlue" runat="server" OnClick="btnDarkblue_Click" ImageUrl="images/Dark_Blue.jpg"
Width="30" Height="30" /></li>

There is nothing like that.You can check the button code

when and where i'll use ur if condition..
I have below method in javascript

<script type="text/javascript">
$("#ContentPlaceHolder1_ddlCountry").change(function () {
debugger;
var end = this.value;
$('#<%=hdnCountry.ClientID%>').val(end);
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "ProfileEdit.aspx/GetState",
//url: '<%= ResolveUrl("~/ProfileEdit.aspx/GetState") %>',
data: "{'countryID':'" + end + "'}",
dataType: "json",
success: function (data) {
debugger;
$('#<%=ddlState.ClientID%>').empty();
$('#<%=ddlState.ClientID%>').append($("<option></option>").val(0).html('--Select--'));
$.each(data.d, function (key, value) {
$('#<%=ddlState.ClientID%>').append($("<option></option>").val(value.ID).html(value.Name));
});
var items = $("#ContentPlaceHolder1_ddlState option").length;
if (items == 1) {
$('#<%=ddlCity.ClientID%>').empty();
$('#<%=ddlLocality.ClientID%>').empty();
$('#<%=ddlCity.ClientID%>').append($("<option></option>").val(0).html('--Select--'));
$('#<%=ddlLocality.ClientID%>').append($("<option></option>").val(0).html('--Select--'));
}
},

error: function (data) {
alert("Error");
}
});
});
</script>

and below is the code behind method

//[WebMethod]
[System.Web.Services.WebMethod]
public static StateDetails[] GetState(string countryID)
{
List<statedetails> details = new List<statedetails>();
try
{
int cid = Convert.ToInt32(countryID);
HttpResponseMessage response = objCRUD.Get("api/CountryState/0/0/" + cid); // Controller Name
if (response.IsSuccessStatusCode)
{
var Module = response.Content.ReadAsAsync<List<countrystatemodel>>().Result;
if (Module.Count() > 0)
{
DataTable dt = ToDataTable(Module);
foreach (DataRow dtrow in dt.Rows)
{
StateDetails state = new StateDetails();
state.ID = Convert.ToInt32(dtrow["ID"].ToString());
state.Name = dtrow["Name"].ToString();
details.Add(state);
}
}
}
return details.ToArray();
}
catch (Exception ex)
{
throw ex;
}
}

if(diV.Style["display"] == "block")

I also checked that not working..

i am using style="display: none" to hide div and then i want to check that's all.

not working..

both of the above comment i have checked already..not working

thanks for your valuable comments

I have done it with stored procedure btw many many thanks.

u have great idea but LeaveDate will be null sometime if employee is still working..

on change in query

var emplouee = objempBL.GetAllEmployeeDetails().Where(a => (Convert.ToDateTime(a.DOJ).Year >= 2009 && Convert.ToDateTime(a.DOJ).Year <= Convert.ToInt32(ddlyear.SelectedValue) && (a.DOL == null || Convert.ToDateTime(a.DOL).Year <= Convert.ToInt32(ddlyear.SelectedValue)))).ToList();

var emplouee = objempBL.GetAllEmployeeDetails().Where(a => (Convert.ToDateTime(a.DOJ).Year >= 2009 && Convert.ToDateTime(a.DOJ).Year <= Convert.ToInt32(ddlyear.SelectedValue) && (Convert.ToDateTime(a.DOL).Year == null || Convert.ToDateTime(a.DOL).Year <= Convert.ToInt32(ddlyear.SelectedValue)))).ToList();

sorry, it's working in sql but same condition not working in linq

still not working..

all i need is A AND (B OR C)

thanks for comment

i have done it with below code

Int32 year = Convert.ToInt32(ddlyear.SelectedValue);
DateTime fromdate = Convert.ToDateTime(year + "-" + "01" + "-" + "01");
DateTime Todate = Convert.ToDateTime(year + "-" + "12" + "-" + "31");

it's not aspx page above code is in usercontrol.ascx

i already checked that and also checked

http://msdn.microsoft.com/en-us/library/system.security.allowpartiallytrustedcallersattribute.aspx

but on changes page show many errors

btw thanks..its working

on your changes still table shows multiple date of different time interval

but every server doesn't contain job schedular..is there any code behind metod to do so

mssql server 2008

yeah, how to load a method once in a day or at a particular time ?

multiple times..

please read the code carefully..grid is binding in row command but not showing

i want to know with am-pm convertion not 14:00 that will be 2:00 pm

create appointment means 'arrangement for meeting'..
I have,
from time: 10:00 am
to time: 2:00 pm

duration between meeting is 20 minutes
then 1st meeting time will be at 10:00 am, 2nd will be at 10:20 and so on..

now problem is how to create the time duration gap of 20 minutes by for loop or while loop

u mean it's not possible..

i m sending web request to controller..actually i m able to add and edit using api controller but unable to delete or update..

HttpResponseMessage response = await client.DeleteAsync(strApiKey).Result;

r u saying the about above code

i m beginner that's y i post it here..actually i m bit confused about the topic need help..if u can i'll be thankful to u..

thanks for your solution..

your query shows last 5 details of OrderNo but not showing multiple sales with same order..

In my table fields are SaleID(Primary key), CustomerID, MachineID, OriginalPrice,
OrderNo(Unique generated by code), Salesdate, SalesPrice, Quantity, VAT_CST, Discount, Status

here 1 OrderNo may contaion multiple sale..now i want to fetch last 5 OrderNo..
here OrderNo will be repeated multiple or single times it depend on sale at a single time..If u have solution of my question then help me plz..


Thank u..

i want last five orderNo details..1 orderno contain sigle or multiple sale

thanks..it's working..