Comments by TCS54321 (Top 130 by date)

i am trying to call postman public soap api "https://documenter.getpostman.com/view/8854915/Szf26WHn". and those api are working fine when i call through postman.

tried, but not working

tried, but not working

in swagger property name is already shows. i passed this [{"num":"test"}] also but it's not working

i am passing data like that:-

{
"num": "test"
}

i am passing values like that:
{
"num": "test123"
}

check the updated question

it's just a dummy code. here i did not get value in _testdto when u call my API

(ID, Name) should be a Key and (1,teststudent1/2,teststudent2) should be a value

thanx for you reply but your solution does not work in my case. i need the output look like this --->

"studentdata": [
{
"ID": "1",
"Name": "teststudent1"
},
{
"ID": "2",
"Name": "teststudent2"
}
]

thanx for your reply. but i got the better solution. i used linq query with join and assign the query result into my final list.

i did net get my list data into Dictionary. i used this code to convert list into dictionary
----->>> Dictionary<studentdata, studentdata=""> dict = mylist.ToDictionary(x=>x);

i want to convert my List into Dictionary. check my question. i updated my question

my issue resolved. thanx for your time.

thanx for the reply. i try following code and it's working fine for orderdetail list:-
-->
data = new List<orderdata> { new orderdata{ orderID = oid, Orderdetails = odData} }

thanx for your solution but i think you did not got my point. i will explain you.
here is my table sample data:-
digital_product_id product_type
1 --abc
1 --abc
--abc
4 --
4 --xyz
5 --xyz
6 --pqr
6 --

now when user pass product_type=abc then first 3 row will come.
if they pass productid=4 then 4th and 5th row will come.
now can you suggest any solution. i don't think so OR condition work here.

i install this font also. but it's not working.

i already used the same code of this link. it's not working for unicode.

i also try this.. but it's not working.
alter table MyTable
alter column MyColumn nvarchar(max) COLLATE Korean_90_CI_AI

tnx for your suggestion.

Thank you so much. it's working fine for me. You save my day.

thank you. it's working fine for me.

i want to do with sql dependency (when i execute any query notification send to user ). Article you suggest me not work for me.

it's work for me. Thank you so much.. you save my day.

basically i host 2 website on a same server. and i need to download a file that place inside a folder of my 1st website by using of my 2nd website. could you suggest me how can i do it.

i am using my own computer local drive. and set read write permission to everyone. but same error i got it.

tnx for your support. you suggestions work for me.

it's is only for showing Plus and Minus image when expand gridview. you just ignore this function.

thank you. its working perfectly.

you explain my problem very well. i remove data-toggle="modal" and i also remove bootstrap modal. but still facing the same issue.

ROW_NUMBER() is not working in mysql

i am using MySQL Workbench. you suggest me SQL query . It's not working for mysql. well thank you for your solution.

tnx.

i am using a database table in which i insert login userID and one bit column to store isLogin Value in 0 and 1.

you know my problem very well.. hope someone give solution also..

i want to logout previous login user with same credentials when someone login with that credentials.

Table1:

ID--Company
1-- HCL

Table2:

ID-- CompanyID -- Emp1 -- Emp2
1-- 1 -- '' -- 'Deepak'
2-- 1 -- 'Amit' -- ''

tnx for your comment

because i trust on Xbox more than Sony.

basically i am on development face. and run my application on localhost. i have no idea how can i request to facebook to approve manage_pages and publish_pages permissions. because i think this two permission is necessary to post on facebook by third party application.

here is my login page code:-

Protected Sub Login_Authenticate(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.AuthenticateEventArgs) Handles Login.Authenticate


Dim mprov As Veer.Membership.VeerMembershipProvider = Membership.Provider
Dim bool As Boolean = mprov.ValidateUser(Login.UserName, Login.Password)
Dim uname() As String = Roles.GetRolesForUser(Login.UserName)
If bool Then
If role.Count > 0 Then
e.Authenticated = Roles.IsUserInRole(Login.UserName, uname(0))

End If
End If
If e.Authenticated Then
Session("User") = DirectCast(Membership.Provider, Veer.Membership.VeerMembershipProvider).GetUser(Login.UserName, True)
Session("role") = role(0)
End If
End Sub




Protected Sub Login_LoggedIn(ByVal sender As Object, ByVal e As System.EventArgs) Handles Login.LoggedIn

Dim rol As String = Session("role").ToString
Session("Host") = HttpContext.Current.Request.Url.Host
Response.Redirect(Veer.Utility.dbutility.HomePage(rol))

End Sub

tnx sir.. its working fine for me..

update folder set Folder.DefaultPhotoID=
(SELECT Gallery.PhotoID
FROM Folder INNER JOIN
Gallery ON Folder.FolderID = Gallery.FolderID)

its working. thank you karthik.

no.. if i paste textbox outside the TabContainer then its working fine but not inside.

news with group of dates. if 10 news save in same date then date show on top and 10 news in below of date..

no response when i click on download pdf icon in gridview

122.176.69.40:8085/login.aspx

this is my website url. Enter Username "Student" Password "1"

i think ur gf kick on your ass today.. that why you don't understand any shortcuts words.

if u have any solution then write.. otherwise don't waste your time to read my worthless description.

not working for me.

thanku sir.. its work for me..

my question not save without writing 30 words in what i have tried. its complicated to write what i have tried. thats why i am just typing this. u have any solution of my problem??

"Improve question" not working well..

sir i am using web.xml page in asp.net project to add menu in asp menu. it look very simple.. i need to add icon with each menu items.

i need to get date from '01/Aug/2015' to '03/Aug/2015' . if fromdate is '01/AUg/2015' and Todate is '05/AUg/2015' then i need to get date like

01/AUg/2015
02/AUg/2015
03/AUg/2015
04/AUg/2015
05/AUg/2015

not work for me

Thanku so much Sir.. Its work for me..

week Starting Date: 01/05/2015

no sir, suppose i have select "MAY" month and "2" week. then i get output:-
Starting Date:-04/May/2015
Ending Date:-09/May/2015

Now u read the question.. i hope now u understand the question.

ok.. i have Improve my question..

i have no idea how can i do it..

i want to do it from client side.

boths are working

Its Working.. tnx

1)Error converting data type varchar to float
2)'CONCAT' is not a recognized built-in function name
This is the errors

No one working

Any One Know That....

i have update my ques. how u get any solutions

so number of columns are not fix..

sir, AutogenrateColumns are TRUE in my gridview.

i need some ideas to do that by code.

why u not write code..

Error:Cannot perform an aggregate function on an expression containing an aggregate or a subquery.

Protected Sub BtnPrint2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BtnPrint2.Click

Dim sem As String
Dim str As String
Dim str1 As String
sql = "select distinct semid from matrix where courseid=" & DdlCourseWise.SelectedValue & ""
Dim dt As DataTable = Hari.Utility.db.GetRecodeDT(sql)
If dt.Rows.Count = 0 Then
dt.Dispose()
Amit.Messagebx.Alert(Me, "No Data Available")
Exit Sub
End If


For k = 0 To dt.Rows.Count - 1
sem += dt.Rows.Item(k)("semid").ToString + ","
Next
sem = Left(sem, sem.Length - 1)
Dim sid As String() = Split(sem, ",")

For k = 0 To dt.Rows.Count - 1
str += "R" + dt.Rows.Item(k)("semid").ToString + ".RowNumber as Sno," + "R" + dt.Rows.Item(k)("semid").ToString + ".AdmissionNo," + "R" + dt.Rows.Item(k)("semid").ToString + ".RoomNo" + ","
If str1 Is Nothing Then
str1 += "(Select RoomNo,AdmissionNo, ROW_NUMBER() OVER (ORDER BY Matrix.CourseId) 'RowNumber' FROM Matrix inner join student on student.studentid=matrix.studentid WHERE Matrix.CourseId = " & DdlCourseWise.SelectedValue & " and Matrix.SemId = " + dt.Rows.Item(k)("semid").ToString + ") AS " + "R" + dt.Rows.Item(k)("semid").ToString + ""
Else
str1 += " FULL OUTER JOIN (select RoomNo,AdmissionNo, ROW_NUMBER() OVER (ORDER BY Matrix.CourseId) 'RowNumber' FROM Matrix inner join student on student.studentid=matrix.studentid WHERE Matrix.CourseId = " & DdlCourseWise.SelectedValue & " and Matrix.SemId = " + dt.Rows.Item(k)("semid").ToString + ") AS " + "R" + dt.Rows.Item(k)("semid").ToString + "" + " ON R" & sid(0) & ".RowNumber = R" & dt.Rows.Item(k)("semid").ToString & ".RowNumber"
End If
Next

dt.Dispose()

sql = " SELECT " & _
"" & str & " " & _
" FROM " & _
" " & str1 & ""
Dim dt1 As DataTable = Hari.Utility.db.GetRecodeDT(sql)
Gridview2.DataSource = dt1
Gridview2.DataBind()
dt1.Dispose()
End Sub

tnx for ur effort shweta ji.. i am using both solutions. but not getting right output.

yes rajesh ji.. u r right..

i tried this. but its not give right output. its give me a cartesian product of table.

this is a single table. and i tried join but its not give right output..

again thank you shwetaa ji..

ur welcome shwetaa ji..

ohk..

tnxx shwetaaaaa.. ;)

its increase and decrease as situation.

Number of Image Column are not fix. And name of image column are also not fix.

for example:- if i select course that name b.tech(csc) then only 1,3 and 6 sem checkbox color will be change

there are 10 sem in 2nd column. i need that when i select a course only particular sem checkbox color will be change.

my gridview code is:-

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width="100%"
CssClass="EU_DataTable" HeaderStyle-HorizontalAlign="Center"
HeaderStyle-Font-Bold="True" HeaderStyle-Height="32px" Font-Size="10pt" >
<columns>


<asp:TemplateField Visible="False">
<itemtemplate>
<asp:Label ID="lblCourseid" runat="server" Text='<%# Bind("Courseid") %>'>



<asp:TemplateField HeaderText="Course/Sem">
<itemtemplate>
<asp:CheckBox ID="ChkIn" runat="server" AutoPostBack="true" OnCheckedChanged="Color"/>
<asp:Label ID="lblcourse" runat="server" Text='<%# Bind("Course") %>'>
<br />





<asp:TemplateField HeaderText="Sem" SortExpression="Sem">
<itemtemplate>
<asp:CheckBoxList ID="chkSem" runat="server" DataSourceID="SqlSem"
DataTextField="Serial" DataValueField="Semid" RepeatColumns="5" RepeatDirection="Horizontal">





<HeaderStyle BackColor="Gray" ForeColor="White" HorizontalAlign="Left" />

thanku mam..

i need the code in vb.net

yes sir.. its working.. thanku

sir, 100 is a hardcode. every time it take 100 in place of total??

ok

sir, its not working, it said invalid column

sir, i want to say that in place of 24 i want that value of total.. like in first time 6 set in place of 24, then 7 set, then 5 and so on.

i solve it.. thanks

my query:-




select ROW_NUMBER() OVER (ORDER BY t.studentid) AS SNo,max(t.roll_no) as RollNo,max(t.student) as Student ,
max([MST1(10)]) as [1 MST1(10)],max([MST2(20)]) as [2 MST2(20)], ([MST1(10)] + [MST2(20)]) as Total
From
( select t.studentid,'' as roll_no,'' as student,'' as subject ,'' as course,t.sem ,
[1] as [MST1(10)],[2] as [MST2(20)],'' as total
from exammarksheet
pivot
(max (obtMarks) for ExamID in ([1],[2])) as t where (t.subjectid = 2 And t.courseid = 1492 And t.sem = 3 And t.classesid = 17 And t.sessionid = 20142015)
union all
select distinct student.studentid, roll_no,student ,subjectall.code as subject,course.code as course,exammarksheet.sem , '' as a,'' as a,'' as a from student
inner join exammarksheet on student.studentid=exammarksheet.studentid
inner join course on student.courseid=course.courseid
inner join subjectall on exammarksheet.subjectid=subjectall.subjectid
where exammarksheet.subjectid = 2 And exammarksheet.courseid = 1492 And exammarksheet.sem = 3
and exammarksheet.sessionid=20142015 And exammarksheet.classesid = 17 ) as t group by t.sem,t.studentid,t.total

Msg 8120, Level 16, State 1, Line 2
Column 't.MST1(10)' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Line 2
Column 't.MST2(20)' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

when i click on image button to show file name in this textbox:-

<asp:TemplateField HeaderText="File Name" HeaderStyle-HorizontalAlign="Center">
<itemtemplate>
<asp:TextBox ID="txtFName" Width="100px" runat="server" >



then filename from Fileupload button are missing.

this is my code :


<asp:TemplateField HeaderText="Upload File" HeaderStyle-HorizontalAlign="Center">
<itemtemplate>
<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="conditional" >
<Triggers>
<asp:PostBackTrigger ControlID="ImgFileName" />
</Triggers>
<contenttemplate>

<asp:FileUpload ID="FileUpload1" runat="server" />
<asp:ImageButton ID="ImgFileName" CausesValidation="False" ImageUrl="~/Images/arrow.png" Width="17px" runat="server" OnClick="x" />







but its not working..

yes.. but its not working

not working

i am using only fileupload button. how can i call a mathod to click on fileupload button

TxtCollegeName.Text = dt.Rows(0)("collegename").ToString

i am using this to show the store address in database when i am click on edit button.if a have 2 textbox to store address then how can i show it in text box

in my checkboxlist there are some classes like 1-b.tech(cse) 2-b.tech(it) 3-b.tech(ece) 4-b.tech(me) when i select when i select b.tech(ece) it give the correct classid of b.tech(ece) and then i select b.tech(me) it give the classid of b.tech(me) again if i select b.tech(it) or b.tech(cse) then it give right classid. basically it pick the first selected classid in cleckbox list. how can i pick the current selected classid on each selection?

tnx

its working.. thanku

its not working

but in text area how can i take value using vb.net that i can use in input textbox.

strb.Append("<input id=""Text1"" style="" width=""50px"" text-align: center;"" class=""txt"" type=""text"" name='value_""1""_txb' value=""class:" & k & """/>")

i am using this in vb.net

i am using inputbox. how can i do it in inputbox. or if i will use textbox how can i take value field in textbox.

in my checkboxlist there are some classes like
1-b.tech(cse) 2-b.tech(it) 3-b.tech(ece) 4-b.tech(me)

when i select when i select b.tech(ece) it give the correct classid of b.tech(ece) and then i select b.tech(me) it give the classid of b.tech(me) again if i select b.tech(it) or b.tech(cse) then it give right classid. basically it pick the first selected classid in cleckbox list. how can i pick the current selected classid on each selection?

its working... thanku

Conversion failed when converting the varchar value ',' to data type int.

this is a error when i run this query

basically i want a print a exam seating plan report. In which if we have 60 student then it split into 10-10 student in 6 column.can it posible..

roomid seatno classid studentid
1 1 17 101
1 2 18 102
1 3 17 103
1 4 18 104

hahaha..

i want to show grid row value to a textbox. for this i take a button in grid. when i click on that button grid row value show in textbox.but my grid is move for there position. gridview position are not set at one place. for each click gridview is moving up and for next click down.