Comments by Vivek.anand34 (Top 200 by date)

I tried simple html for audio.. its also not showing download option..

Thank you. its working.. am using this
lstCities.Sort();

S working fine.. but how to change order.. can i change order of the cities..
it showing not asc or desc all mixed.

without that button code executes well in pageload. with button didn't in pageload.

I gave that function like this its right..
$(document).ready(function () {
BindGridview();
});

No this is also not come in page load

No.

S I added but didn't work..

I updated the what i have tried..

i think its cache problem..

actually before append i cleared table and again bind.. now its ok.

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

no..

yes he default assigned for admin and users.. suppose i added one more role in db then how it executes.

I restrict in web.config then user cant access via url. it comes again to login page. Thats y am using this.

Why i use web. Config. The user directly type the url and open the screens. Thats why

I used like this:
SqlParameter[] parameters ={new SqlParameter("@Action","INSERT"),
new SqlParameter("@Location",fields.Location),
new SqlParameter("@CrBy",fields.CrBy),
new SqlParameter("@CompCode",fields.CompCode)};

Thank you, how i give parameter in another class..

can i add like this then, how to use this.
public int intSPExecuteNonQuery(string StoredProcName, sqlparamters[] param){
......
cmd.Parameters.Add(parameters);
}

above my code executed by how save into db means: for eg. I have 10 rows. 1 st columns saved in 10 rows 2nd columns saved in next 10 rows, 3rd column saved in next 10 rows like this... i think using is problem... pls. c my code above..

Yes..... its right.....

Ok.. I need send mail based on this date..........

Ya i added DATEADD(day,3,DATE_OF_COMPLAINT) function..

Above code its right.

Ok..

'strComplaintDate' is db date and check today. if yes then send mail and update date 3 days. its right.

what i have tried updated...

I updated question. plz. see it.

sorry, code is in error above this code thats why its not executed.. i solved that error. now executed...

I used code from this site: its executed..

https://www.codeproject.com/Tips/842832/How-to-Download-Large-Files-from-ASP-NET-Web-Forms

bytearray as not a member of system.io.filestream

Then how to download that kind of files.

What is doc here... Using ms As New MemoryStream(doc.ByteArray)

where i use int64 i not declared any int values

Yes, solved my issue.. Thank You... I updated solution above.

For Each MyControl As RepeaterItem In rptBackups.Items
Dim filePaths() As String = Directory.GetFiles("D:/FTP/DB Backup/")

Dim chkdelete As CheckBox = DirectCast(MyControl.FindControl("chkSelect"), CheckBox)
If chkdelete.Checked Then

End If
Next

thats only i don't know to check....

Yes, each rows contains filenames, download button, checkbox...

Actually its a single row delete code. i need to multiple rows delete option using checkbox. i modified that is an error. please can u modify it..
.

I solved issue by using this code:
Dim multi As String() = strMail.Split(",")
For Each ccs As String In multi
mm.CC.Add(New MailAddress(ccs))
Next

Executed this:

Dim multi As String() = strMail.Split(",")
For Each ccs As String In multi
mm.CC.Add(New MailAddress(ccs))
Next

I tried like this: this executed...

Dim multi As String() = strMail.Split(",")
For Each ccs As String In multi
mm.CC.Add(New MailAddress(ccs))
Next

Yes thank you... i solved issued by:

var test = new FormData();
var length1 = $("#tblInvoices2").children().length;
var fileUpload;
var files;

for (var i = 0; i < length1; i++) {
fileUpload= $("#tblInvoices2").find(".files").get(i);
files= fileUpload.files;
for (var j = 0; j < files.length;j++) {
test.append(files[j].name, files[j]);
}
}

then, how fb, twitter,... can get path for image upload.

How to overcome this.. now i need take path in my project.

I have filename and filepaths in html table... when i click 'send' button those files are attached and send mail.

Thank you. one attachement is working but i need to get multiple files from table..

no..

ya its executed.. Thank you....

ya its executed.. Thank you....

ya i added.

actually its check the row by row. for eg. check 1st row already exist message then check 2nd row not exist so values inserted...

else statement also execute after if condition

I want message file transfer while copying the file "please wait file is copying".

any link or some code..

I tried following this link:
http://www.c-sharpcorner.com/UploadFile/ansh06031982/bind-crystal-report-in-Asp-Net-application-and-export-pdf-a/

not page also loaded when i click button its cleared.

yes. what is the solution for that..

thank u. its useful for me.

I need in x axis in chart like this 10-20, 20-30, 30-40
I have values in database.. row by row, 10,20,30,40

Thank you..Now it executes.. i left form tag in masterpage its a problem. i solved it.. forms look like..

I copied full code not fully displaying in screen...

No.. its also same.. appended field did't sum...

Appended row can't add in the total.. how to resolve it..

Thank You its Executed...
when pagination comes it takes first page total only..

Ya.. Thank you.. I used like this. its executed....

$("table").delegate(".QtyReq", "keyup", function () {
$(this).addClass('selected').siblings().removeClass('selected');
var unitprice = $(this).closest("tr").find('.UnitPrice');
var qtyreq = $(this).closest("tr").find('.QtyReq');
var total = $(this).closest("tr").find('.Total');
total.val(unitprice.val() * qtyreq.val());
});

Hi.. anyone help this concept.still didn't solve this..

please can u send that code...

how to find the row....

and there what is json, and how i give in url..

i have given like this
var json = { "id": id, "itemname": itemname, "ircode": ircode, "icode": icode, "qtyreq": qtyreq };
var url1 = '@Url.Action("GetGrid", "MRD")';

I use in this site it executed:
http://stackoverflow.com/questions/17066636/parsing-json-objects-for-html-table

there accepted answer click jsfiddle..

$(document).ready(function () {
$.getJSON(url1, json,
function (json) {
var tr;
for (var i = 0; i < json.length; i++) {
tr = $('');
tr.append("" + json[i].id + "");
tr.append("" + json[i].itemname + "");
tr.append("" + json[i].itemcode + "");
tr.append("" + json[i].ircode + "");
tr.append("" + json[i].qtyreq + "");
$('#divgrid').append(tr);
}
});
});

am using this code to append but didn't append.. any error in this code.

see above comment grid coding that is row. i want to append in that row.. but there is no row id.. how to declare in that grid..

append means dynamically store values in grid right.. but i need it from db. suppose i want to update means i will update based on Id..

i will give my source and db can you see... my screen

This is my grid. how to append in this grid:
@grid.GetHtml(
htmlAttributes: new { id = "grid" },
fillEmptyRows: false,
mode: WebGridPagerModes.All,
firstText: "<< First",
previousText: "< Prev",
nextText: "Next >",
lastText: "Last >>",
columns: new[] {
grid.Column("Id", header: "ID", canSort: true),
grid.Column(header: "Item Name",format: @ @item.ItemName @Html.TextBox("Item_Name_" + (int)item.Id, (string)item.ItemName, new {@class="ItemName", @style = "display:none" })),
grid.Column(format: @ @item.IRateCode @Html.TextBox("ItemR_Code_" + (int)item.Id, (string)item.IRateCode, new { @class = "IRCode", @style = "display:none" })),
grid.Column(header: "Item Code",format: @ @item.ItemCode @Html.TextBox("Item_Code_" + (int)item.Id, (string)item.ItemCode, new { @class = "ItemCode", @style = "display:none" })),
grid.Column(header: "Unit Price",format: @ @item.UnitPrice @Html.TextBox("Unit_Price_" + (int)item.Id, (int)item.UnitPrice, new { @class = "UnitPrice", @style = "display:none" })),
grid.Column(header: "Qty Requested",format: @ @item.QtyRequested @Html.TextBox("Qty_Req_" + (int)item.Id, (decimal)item.QtyRequested, new { @style = "display:none" })),
// grid.Column(header: "MRNo",format: @ @item.MRNo @Html.TextBox("MR_No_" + (int)item.Id, (string)item.MRNo, new { @style = "display:none" })),
grid.Column(header: "Action",format:@<text> Edit
Update
Cancel
Delete)
})

can we bind data from db without append...

Ok I will try..

and were i declare that 'someValue'.

here propertyName means below 'mrno' right.
var mrno = $("#MRNo").val();

sorry, I am new to mvc can u send sample code how to read it..

above code is my save method code.. how to get values in success method.

How to attach file here.. and see above its my save code..

actually the grid values comes from database.. when i click the save button in grid it saved and show in grid.

How to append it.. can u sample code..

Actually in script window.location.replace("ShowData"); without this line. save but didn't bind in grid. with this line binded. but header textbox cleared.

3 days am trying not resolve this problem.. please anyone help...
am save using javascript and [HTTPGET] in controller.

I have updated my question. above show data function I gave Remarks="Vivek" its executed. but i need what i enter in remarks textbox..

Ok i will try......

actually without enter the mandantory field when i click the save button the item name fields are cleared in the dynamically added textbox

Display it : echo "You are visitor number $counterVal to this site";

I have used this code it executed... Thanks...

session_start();
$counter_name = "counter.txt";
// Check if a text file exists. If not create one and initialize it to zero.
if (!file_exists($counter_name)) {
$f = fopen($counter_name, "w");
fwrite($f,"0");
fclose($f);
}
// Read the current value of our counter file
$f = fopen($counter_name,"r");
$counterVal = fread($f, filesize($counter_name));
fclose($f);
// Has visitor been counted in this session?
// If not, increase counter value by one
if(!isset($_SESSION['hasVisited'])){
$_SESSION['hasVisited']="yes";
$counterVal++;
$f = fopen($counter_name, "w");
fwrite($f, $counterVal);
fclose($f);
}

that letter is for eg. i said

number

s s Thank u... i changed to this.
$(document).ready(function () {
setupAutoComplete();
});
autocomplete is working now.. but selected value changed is changing first row values...

I put function like this:
var setupAutoComplete = function () {
//Autocomplete code
}

i give setupAutocomplete(); from 2nd row its works.. Now frst row didn't work.
how to put this fn in page load. now i gave button event so from 2nd row its working.

remove row function are worked in all row.. but this autocompletes not working.

c above code "Add row" script. any autocomplete function can add in that.

NO. its too first row only execute.

i used class also. but its too execute 1st row only

1st row is textbox like this @Html.TextBox("[0].ItemName", null, new { @class = "form-control", autocomplete = "off" })

from 2nd row like this: <input type="text" id="[' + rowCount + '].ItemName" name="[' + rowCount + '].ItemName" class="form-control" />

any prob in this.

i put unique id ("ItemName[0],ItemName[1]...) but now 1st line also didn't work..

Actually, $("#ItemName") its a 'Id' or 'name'.. Its Id means all Id in textbox same right.

I have updated my script code. its not auto increment row count.

i found one solution for that but its static: i give input name field like this.
<input type="text" name="[0].IRateCode" />
<input type="text" name="[1].IRateCode" />
<input type="text" name="[2].IRateCode" />

now its saved. but how to auto increment that number in javascript.

What Function is this: OnBegin = "onBeginFunctionHere",
OnSuccess = "onSuccessFunctionHere",
OnFailure = "onFailureFunctionHere",
OnComplete = "onCompleteFunctionHere"

Yes Now Errors solved... Thank You Very Much......

I have updated my overall code above.. Error: The model item passed into the dictionary is of type 'System.Collections.Generic.List`1[Telecom.ViewModel.VwModel]', but this dictionary requires a model item of type 'Telecom.ViewModel.VwModel'.

I have updated overall code above..

public ActionResult Create()
{
MRHdr objMRHdr = new MRHdr() { MRNo = "", MRDate = DateTime.Now };
MRDtl objMRDtl = new MRDtl() { IRateCode = "", ItemCode = "", QtyRequested = 0 };
List model = new List();
model.Add(new VwModel { MRHdr = objMRHdr, MRDtl = objMRDtl });

return View(model);
}

public ActionResult Create()
{
MRHdr objMRHdr = new MRHdr() { MRNo = "", MRDate = DateTime.Now };
MRDtl objMRDtl = new MRDtl() { IRateCode = "", ItemCode = "", QtyRequested = 0 };
List<vwmodel> model = new List<vwmodel>();
model.Add(new VwModel { MRHdr = objMRHdr, MRDtl = objMRDtl });

return View(model);
}

Same Error: u see above view, that given model is correct or not..

The model item passed into the dictionary is of type 'System.Collections.Generic.List`1[Telecom.ViewModel.VwModel]', but this dictionary requires a model item of type 'Telecom.ViewModel.VwModel'.

s am using this only..

Same Error: u see above view, that given model is correct or not..

The model item passed into the dictionary is of type 'System.Collections.Generic.List`1[Telecom.ViewModel.VwModel]', but this dictionary requires a model item of type 'Telecom.ViewModel.VwModel'.

How to initialize properties in object for eg.

Thanks.. But Error like this:
The model item passed into the dictionary is of type 'System.Collections.Generic.List`1[Telecom.ViewModel.VwModel]', but this dictionary requires a model item of type 'Telecom.ViewModel.VwModel'.

I don't know how to use multiple modal in single view.. for eg.. I need to save Text box value and Grid values are two different tables... can you send any links.

Thank U.. But another error comes now. CS1501: No overload for method 'Write' takes 0 arguments
@{Html.RenderPartial("_MRDtls");}

I didn't done code... i don't knw how to do it.. use one table means i done.. here two table how to two modals in one screen.

<p class="itemcode"> @Html.Display("ItemCode") </p>
$('.itemcode').html(data.icode);

this type working.. but showing validation error "Required Item code"

s. I found the problem. but solution can u tell me.. I gave ItemCode field is [Required] but values didn't comes to display field thats problem.

I have updated my question.. actually when click the submit button the page loads and cleared all the fields..

Ya i change code little bit now executed:
[HttpPost]
public ActionResult Edit(Vw_Items itemrates)
{
if (ModelState.IsValid)
{
var currentPerson = db.ItemRates.FirstOrDefault(p => p.Id == itemrates.Id);
currentPerson.UnitPrice = itemrates.UnitPrice;
currentPerson.GetDate = DateTime.Now;
currentPerson.GetUser = Session["LogedUser"].ToString();
db.Entry(currentPerson).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(itemrates);
}

How to resolve this problem.. anyone tell idea please..

I think its take all columns to update.. but i want to update 'ItemCode' and 'Unit Price' that is the prob. i think. And All fields are display fields ItemCode and Unit Price only textbox field

thank you. but this error: System.Data.SqlClient.SqlException: View or function 'dbo.Vw_Items' is not updatable because the modification affects multiple base tables.

if any you have done before send some concepts...

der posted 4 years before and that is accepted soln. so don't know they are reply or not. tats y i ask with u all.. what is the soln for that.

Then.. IEnumerable dynamictable.models.tblcustomerinformation
here DynamicTable is "The Type or namespace name could not be found error message.

Thank u... What is DemoEntity in HomeController code...

Ok thank u....

I updated my question. what i have done..

actually in server system place power off won't be able to use the application. its right.. any solution for this problem. or install application in client system also then if it possible.

can't update when click the logout button... logout button sp and code above i given.

s i got... but suppose he sold to others then how we know that..

Actually we do project for another company. we need to host software in his server. But they can't take that software from server to another server.. i.e, he didn't sell our software to others..

its web application, Actually i hosted application in server.. They need not take a copy of application to another server.

Actually i hosted application in server.. They need not take a copy of application to another server.

I have hosted application in server. i need to restrict to copy of application or can't install in another server.
anyone help me..

can i restrict the copy of application in server to another server..

how to bind.. if gridview then gridview1.datasouce=dt; gridview1.databind();
here div1.datasource is not possible.. can u send any samples

yes, but i bind values from database.. how to bind values inside that div.

Its in css.. i need asp .net c# code

Sorry No time to try its urgent work tats y..

It showing in config manager but I can't enable it.. "The Request failed or the service didn't respond in a timely fashion. consult the event log or other applicable error logs for details" message showing When i start the agent services in config mgr.

i stored like this then.. how i show like

Weeks 1 2 3 4 5 6
-------------------------------------
Monday Eng Sci Maths Social Biology

no. how to debug it..

Actually, when i open screen and Enter the value then click save, its works fine. Enter the next record the calculation is not working..

Keyup means keyboard keyup ryt.. But, y 2nd time its not execute.. i no need on load event.. without pageload i need, thats why i choose java script code.

above tat code 'txtFeesAmt' enter the amount. the total values is to be display in footer.

i have updated question.. but its not properly displaying.. so part of Item template tag.

I have solved this problem... Actually, I created same temp table in code and database. I deleted temp table in code, now its working. that is a problem

I have downloaded from this site:
http://phpexcel.codeplex.com/

'Exportexcel' is downloaded from online. and attach in third-party folder.

Code moved to OP's question.

no text empty line in tat..

Ya it solved now...

i have reduced fields in 'chef_orders_pending_temp' view to what i need. Now reduced execution time...

I need Which Table They Modified and time, IPAddress.

I don't knw about Events.. I want to knw what is Event?

Thanks For Help

Actually its My Mistake I converted the datetime to date its a problem. I solved it.. acutally in db i put datetime format. and Textbox (MM/dd/yyyy) format. It executes now...

yyyy-MM-dd is not good for client.. thats why am trying dd/MM/yyyy format... I will InvariantCulture Property above link...

in database its saved yyyy-mm-dd with time format...

firewall is off mode in both systems.

no network problem.. how to increase timeout..

top 1 is only one row return.. but i need every Items minimum id..

Then Top clause is an error.. when i put top(100) then only executed...

This is also same problem.. all Rows returns..

CTE Means

sql server agent is not showing in my sql server 2008 R2

On my Solution Explorer > Reference > Right click > Add Reference > Project Tab
I add 2 references: 1. ClosedXML dll and
2. DocumentFormat.OpenXML dll

Now Works Well.. Thank You for you reference.

please can u send some code...

anyone help me.............

not execute means values entered in the textbox then didn't filter the values in gridview. please see above link.

Thank You its working now....

actually in where condition i put 2 methods:
1. DCNO=@dc then "Must declare the scalar variable "@dc"."
2. if i put DCNo=' + @dc+ ' then "Invalid Column name error shown"

DECLARE @cols AS NVARCHAR(MAX),
@colsName AS NVARCHAR(MAX),
@query AS NVARCHAR(MAX),
@dc as nvarchar(MAX)

select @cols = STUFF((SELECT distinct ',' + QUOTENAME(ItemCode +'_'+c.col)
from Vw_InOutWard
cross apply (
select 'TotalCount' col union all select 'TotalAmount') c
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)') ,1,1,'')
select @colsName = STUFF((SELECT distinct ', ' + QUOTENAME(ItemCode +'_'+c.col) +' as [' + ItemCode + case when c.col = 'TotalCount' then ']' else ' Rate]' end
from Vw_InOutWard
cross apply
(select 'TotalCount' col union all select 'TotalAmount') c
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'),1,1,'')
set @query = 'SET @DCNo ='+Cast(@dc as VARCHAR)+'; SELECT DCNo,DCDate,FromSupName,FromAddress,FromContNo,ToSupName,ToAddress,ToContNo,RefferedBy, ' + @colsName + ' from (select DCDate, DCNo,FromSupName,FromAddress,FromContNo,ToSupName,ToContNo,RefferedBy,ToAddress, ItemCode +''_''+col col, value from(select DCDate, ItemCode, DCNo,FromSupName,FromAddress,FromContNo,ToSupName,ToAddress,ToContNo,RefferedBy,cast(Qty as numeric(10, 2)) totalcount,cast(Rate as numeric(10, 2)) totalamount
from Vw_InOutWard where DCNo=@dc) src
unpivot(value for col in (totalcount, totalamount)) unpiv ) s pivot
(sum(value) for col in (' + @cols + ')) p '
execute(@query)

cmd = new SqlCommand("TEST", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@dc", txtDCNo.Text);
cmd.Connection = con;
cmd.ExecuteNonQuery();

Iput this line in front end:
cmd.Parameters.AddWithValue("@DcNo", txtDCNo.Text);

object reference not set an instance of an object is displayed

ya i put tat line.. but underlined the @DCNO ' must declare the scalar variable @DCNO '

actually here dc no field is there.. i need to retrieve Where DCNo='DC-001'
or give parameter @dcno then how to call this paramter in asp .net c# code i.e, textbox value.

Yes Yes.. I Solved.. now Ouput came exactly..
Thank You for your response..

Thanks. but y i put two times in this line:
for col in ([10prdp_rate], [10prdp_mtqty], [10p_rate], [10p_mtqty], [D-Clamp_rate], [D-Clamp_mtqty], [D_C_rate], [D_C_mtqty])