Comments by Manish Dalwadi (Top 60 by date)

i am gotting errors (row_number, over(),etc..,etc..) if you knew then can you plese tell me how to handle this sp in mysql i request you coz i am working in mysql first time, and tried google but not geting result as i want

which code you given , it will display like "octomber", not "oct"
i want month like "oct", "sep" in czech republic culture

String was not recognized as a valid DateTime.

in data i got "AddStudentModel,StudentModal,ClearForm"
but i want just only "addstudentmodal" in data

i use this type of dialog box

http://nakupanda.github.io/bootstrap3-dialog/

but i cant focus on "cancel" button

dr, i alrdy gien time but not worked..
and i just show you that what i done for focus

dear i want solution in my script

i wrote this yesterdaybut no effect

i wrote this yesterdaybut no effect

no, there are different button for open different iframe
and one some iframe its works but some are not works on press esc...close

<div class="modal bootstrap-dialog type-primary" id="ShowVendor" tabindex="-1">
<div class="modal-dialog" style="width: 90%;">
<div class="modal-content">
<div class="modal-header">
<div class="bootstrap-dialog-header">
<span class="glyphicon glyphicon-remove"></span>

@Resource.VendorList

</div>
</div>
<div class="modal-body">
<div class="row">
<div class="col-md-12">
<iframe id="VendorframeID" name="VendorframeID" src="/vendor/IframeVendorlist/?isIframetype=search" style="width: 100%; min-height: 500px;"></iframe>
</div>
</div>
</div>
</div>
</div>
</div>

i use iframe id and its
div tag id for close iframe in all frame popup lke above example
give me a soution

thank you friends for give me your best time and give me response
i searched and tried once again and i solved it with this
______________________
select CourseName
, Sum([Week0]) as [Week Start - 07 Nov 14]
, Sum([Week1]) as [Week Start - 14 Nov 14]
, Sum([Week2]) as [Week Start - 21 Nov 14] from (select CourseName
, case when StartDate >= '11/03/2014' and StartDate < '11/10/2014' then COUNT(CourseName) else 0 end as [Week0]
, case when StartDate >= '11/10/2014' and StartDate < '11/17/2014' then COUNT(CourseName) else 0 end as [Week1]
, case when StartDate >= '11/17/2014' and StartDate < '11/24/2014' then COUNT(CourseName) else 0 end as [Week2]from GL_BookingList bl
inner join GL_MasterPriceDefaultSelection mpds on bl.PriceItemId=mpds.PriceItemId
inner join GL_Course on GL_Course.CourseID= mpds.SelectionId where (GL_Course.StartDate >= '11/03/2014' and GL_Course.StartDate < '11/29/2014') group by CourseName,GL_Course.StartDate)as t group by CourseName with rollup

thanx dr. for give me your time and your response
i did it
thank you so much again for response me

my dear,
i want data in this format
coursename, firstweekdata secondweekdata thisrdweekdata
---------- ------------- -------------- --------------
c language 3 5 10

this digits are count of coursename

for binding dropdownlist i wrote this code,
i used petapoco + my class file
controller
----------
public ActionResult Binddropdownlist()
{
Countries c1 = new Countries();

DataProvider dp = new DataProvider();

List<SelectListItem> selectitem = new List<SelectListItem>();
List<countries> items = (List<countries>)dp.getdata().Data;

foreach (var i in items)
{
selectitem.Add(new SelectListItem
{
Text = i.FirstName,
Value = Convert.ToString(i.StudentId)
});
}
ViewBag.fname = selectitem;

return View();
}
---------
View
---------
@model MVC_Controls.Models.Countries
@{
ViewBag.Title = "Binddropdownlist";
}

Binddropdownlist

@using (Html.BeginForm())
{
@Html.DropDownList("ddlfirstname", (IEnumerable<SelectListItem>)ViewBag.fname, "Select First Name")
<label id="fname">
dtd</label>

<input id="btnsend" type="button" value="Send" />
}
<script src="~/JS/jquery-2.1.1.min.js" type="text/javascript"></script>
<script type="text/javascript" language="javascript">

$("#ddlfirstname").change(function () {
debugger;
$.ajax({
url: "Home/getdata",
method: "POST",
data: "StudentId=" + $(this).val(),
dataType: "json",
success: function (response) {
window.location.reload();

// handle
}
});
});

thanks

i done it,

window.setTimeout(function () {
window.location.href = "frmprint.aspx";
}, 0);

thank you sir.

private string AssignImage(string profileimage)
{
return !string.IsNullOrEmpty(profileimage) ? profileimage : "images/default_profile.png";
}

<telerik:gridtemplatecolumn xmlns:telerik="#unknown">
<itemtemplate>
<asp:ImageButton ID="Image1" Height="50" Width="50" CommandName="ViewDetails" CommandArgument='<%#Eval("Reg_Id") %>'
ImageUrl='<%# AssignImage(Eval("profileimage").ToString()) %>' AlternateText="No Image"
runat="server" />

m sorry
i never done this type of coding...so please help me for solve this
its showing error..
.
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0122: 'frm_admin_Edit_User_Details.AssignImage(string)' is inaccessible due to its protection level

friendrequest
-------------
my coding is check that
someone send me request or not
if i already a member of someon then i cant see "send interest" button otherwise i can se it

so when i login my account then that time my session id is passed in member id
and someones id geting from request.querystring and pass in senderid variable.
and
if check that senderid==dt.rows[0]["reg_id".tostring())
then
btn have to visible=false,

request_id reg_id memberid
----------- ------- ---------
1 8 9
2 8 10
3 10 9
4 11 9
5 12 9


reg_id is a sender

hey dr...
thank you thank you so so so much..

okay its done...
error solved...
thanks dr.

okay

sorry to say but i want sql code my dr.
please help me u can
coz i dont know how to do

my dr. i have no idea for retrive date from database...so i asking you..
important id display date...for me.

thanx dr.

thank you so much dr.

thank you so much dr.

no dr...
not this i want.
my details display from database table.
then i want to add this

tried but not success..
if any code then please tell me

dr.
coding for insert is perfect

if i used two buttons for moving items then that time this coding is perfectly running and inserting selected items in database

but here
when i click on submit button for insert listbox item
that time problem occured...
because..
i used javascript for moving listbox item (on doubleclick event move items)
so when i submit items not pass in serverside..

thanks

okay

<embed> is not worked in asp.net
i tried it

clsregisterinfo is a claas file in this i pass these selected items
and Dtstd is a datatable property in classfile..i pass the datatable in dtstd in classfile clsregisterinfo..

.

dr.
i think problem is theere..that
i moving items from lst_leftstar to lst_rightstar using javascript(double click event)

<script type="text/javascript"> /* star */
function lst_left_star_DblClicked() {
var left_lst = document.getElementById("<%=lst_leftstar.ClientID%>");
var right_lst = document.getElementById("<%=lst_rightstar.ClientID%>");

for (var i = 0; i < left_lst.length; i++) {
if (left_lst.options[i].selected == true) {
right_lst.options[right_lst.length] =
new Option(left_lst.options[i].text,
left_lst.options[i].value);
left_lst.options[i] = null;
i = i - 1;
}
}
return;
}
</script>
javascript is completely work and other coding is above

but may be its a client side ...not convert into server side...
i have no idea about this..

sorry dr...i forgot to tell you..that
i move items from lst_leftstar to lst_rightstar using javascript(doubleclick)
.
this coding is just only for insert lst_rightstar items un database..
and i have this problem(for loop)


protected void btnsumit_partner_details_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();

dt.Columns.Add("Star_Id");

for (int i = 0; i < lst_rightstar.Items.Count; i++)
{
dt.Rows.Add("");

dt.Rows[i]["Star_Id"] = lst_rightstar.Items[i].Value;
}

clsregisterinfo.Dtstd = dt;
clsregisterinfo.insert_data();
}

please chek it again

thanks dr.

thanx dr.but i want tooltip like shaadi.com in easi steps..
pls help
thanks

i use it as
INSERT INTO birthdate (dob) VALUES (CONVERT(date, @dob, 13));
..
query is complete but date is inserted as
1990-02-02

and i want it as 02-02-1990.
.
pls help

"@date date" is my stored procedure's parameter and "dob" is my table's field
and i tried it but showing me an error.

INSERT INTO birthdate (dob) VALUES (CONVERT(@dob, 'dd-mm-yyyy', 13));

i know i am wrong...
its first time for me...
sir, so pls avoid my mistakes

thanx

its showing error :=
==>> cannot use local variable 'i' before it is used
==>> A local variable named 'i' cannot be declared in this scope because it would give a different meaning to 'i', which is already used in a 'parent or current' scope to denote something else

thank you so so much karthik sir..

okay thanks

i have no idea...about this...
can you give me a simple coding....
then i do it my self....

no dr..

i want to say that
after hosting website i want to open my "webiste projects's" any page and modify it

no dr. its not ...which i want
.
i want that
when we click on product then we can see that current on which link we are present..
if we click on about us and we go in about us page...then we can see that in menu that we clicked on about us link
"about us" link displayed as "yellow" color
if we clicked on home then "home" link displayed as yellow color .
.
i give a one link for demo please see that website and its menu...and clicked two three link..you got an idea that what i want
.
http://www.vaniyamatrimony.com/
.

thanks