Click here to Skip to main content
15,065,328 members

Comments by TCS54321 (Top 110 by date)

TCS54321 12-Apr-21 8:59am View
   
i install this font also. but it's not working.
TCS54321 12-Apr-21 8:25am View
   
i already used the same code of this link. it's not working for unicode.
TCS54321 22-Mar-21 5:56am View
   
i also try this.. but it's not working.
alter table MyTable
alter column MyColumn nvarchar(max) COLLATE Korean_90_CI_AI
TCS54321 22-Jan-21 5:29am View
   
tnx for your suggestion.
TCS54321 3-Sep-20 5:55am View
   
Thank you so much. it's working fine for me. You save my day.
TCS54321 13-Aug-20 6:07am View
   
thank you. it's working fine for me.
TCS54321 1-Aug-20 7:51am View
   
i want to do with sql dependency (when i execute any query notification send to user ). Article you suggest me not work for me.
TCS54321 29-Jul-20 6:21am View
   
it's work for me. Thank you so much.. you save my day.
TCS54321 11-Jul-20 12:14pm View
   
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.
TCS54321 11-Jul-20 11:48am View
   
i am using my own computer local drive. and set read write permission to everyone. but same error i got it.
TCS54321 20-Jun-20 1:15am View
   
tnx for your support. you suggestions work for me.
TCS54321 19-Jun-20 8:19am View
   
it's is only for showing Plus and Minus image when expand gridview. you just ignore this function.
TCS54321 13-Jun-20 7:53am View
   
thank you. its working perfectly.
TCS54321 3-Apr-20 4:36am View
   
you explain my problem very well. i remove data-toggle="modal" and i also remove bootstrap modal. but still facing the same issue.
TCS54321 22-Jan-20 3:57am View
   
ROW_NUMBER() is not working in mysql
TCS54321 22-Jan-20 3:07am View
   
i am using MySQL Workbench. you suggest me SQL query . It's not working for mysql. well thank you for your solution.
TCS54321 12-Dec-19 7:05am View
   
tnx.
TCS54321 12-Mar-19 7:12am View
   
i am using a database table in which i insert login userID and one bit column to store isLogin Value in 0 and 1.
TCS54321 12-Mar-19 6:58am View
   
you know my problem very well.. hope someone give solution also..
TCS54321 12-Mar-19 6:08am View
   
i want to logout previous login user with same credentials when someone login with that credentials.
TCS54321 24-Aug-18 0:45am View
   
Table1:

ID--Company
1-- HCL

Table2:

ID-- CompanyID -- Emp1 -- Emp2
1-- 1 -- '' -- 'Deepak'
2-- 1 -- 'Amit' -- ''
TCS54321 22-Aug-18 0:47am View
   
tnx for your comment
TCS54321 24-Jul-18 6:09am View
   
Deleted
because i trust on Xbox more than Sony.
TCS54321 24-Jul-18 6:09am View
   
because i trust on Xbox more than Sony.
TCS54321 19-Jul-18 0:25am View
   
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.
TCS54321 19-Jan-18 4:07am View
   
Deleted
tnx sir.
TCS54321 17-Jan-18 6:33am View
   
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
TCS54321 13-Jan-18 2:22am View
   
tnx sir.. its working fine for me..
TCS54321 13-Jan-18 2:16am View
   
update folder set Folder.DefaultPhotoID=
(SELECT Gallery.PhotoID
FROM Folder INNER JOIN
Gallery ON Folder.FolderID = Gallery.FolderID)
TCS54321 7-Nov-17 4:50am View
   
its working. thank you karthik.
TCS54321 7-Nov-17 4:46am View
   
no.. if i paste textbox outside the TabContainer then its working fine but not inside.
TCS54321 6-Jul-17 3:54am View
   
news with group of dates. if 10 news save in same date then date show on top and 10 news in below of date..
TCS54321 28-Dec-16 8:25am View
   
no response when i click on download pdf icon in gridview
TCS54321 26-Dec-16 8:43am View
   
122.176.69.40:8085/login.aspx

this is my website url. Enter Username "Student" Password "1"
TCS54321 7-Oct-16 2:40am View
   
i think ur gf kick on your ass today.. that why you don't understand any shortcuts words.
TCS54321 30-Sep-16 9:18am View
   
if u have any solution then write.. otherwise don't waste your time to read my worthless description.
TCS54321 4-Aug-16 7:08am View
   
not working for me.
TCS54321 14-Jun-16 4:44am View
   
Deleted
my Menu Code:-

<asp:Menu ID="mnuNavigation" runat="server" Orientation="Horizontal" StaticEnableDefaultPopOutImage="False">
<staticmenustyle cssclass="StaticMenuItem">
<staticmenuitemstyle cssclass="StaticMenuItemStyle">
<statichoverstyle cssclass="StaticHoverStyle">
<staticselectedstyle cssclass="StaticSelectedStyle">
<dynamicmenuitemstyle cssclass="DynamicMenuItemStyle">
<dynamichoverstyle cssclass="DynamicHoverStyle">
<dynamicselectedstyle cssclass="DynamicSelectedStyle">
TCS54321 21-May-16 8:01am View
   
thanku sir.. its work for me..
TCS54321 21-May-16 7:55am View
   
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??
TCS54321 22-Apr-16 8:42am View
   
"Improve question" not working well..
TCS54321 21-Feb-16 5:11am View
   
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.
TCS54321 21-Feb-16 4:22am View
   
Deleted
<asp:Menu ID="mnuNavigation" runat="server" Orientation="Horizontal"
StaticEnableDefaultPopOutImage="False">
<staticmenustyle cssclass="StaticMenuItem">
<staticmenuitemstyle cssclass="StaticMenuItemStyle">
<statichoverstyle cssclass="StaticHoverStyle">
<staticselectedstyle cssclass="StaticSelectedStyle">
<dynamicmenuitemstyle cssclass="DynamicMenuItemStyle">
<dynamichoverstyle cssclass="DynamicHoverStyle">
<dynamicselectedstyle cssclass="DynamicSelectedStyle">
TCS54321 21-Feb-16 4:22am View
   
Deleted
<asp:Menu ID="mnuNavigation" runat="server" Orientation="Horizontal"
StaticEnableDefaultPopOutImage="False">
<staticmenustyle cssclass="StaticMenuItem">
<staticmenuitemstyle cssclass="StaticMenuItemStyle">
<statichoverstyle cssclass="StaticHoverStyle">
<staticselectedstyle cssclass="StaticSelectedStyle">
<dynamicmenuitemstyle cssclass="DynamicMenuItemStyle">
<dynamichoverstyle cssclass="DynamicHoverStyle">
<dynamicselectedstyle cssclass="DynamicSelectedStyle">
TCS54321 7-Aug-15 2:19am View
   
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
TCS54321 24-Jun-15 7:58am View
   
not work for me
TCS54321 6-May-15 1:55am View
   
Thanku so much Sir.. Its work for me..
TCS54321 6-May-15 1:35am View
   
week Starting Date: 01/05/2015
TCS54321 4-May-15 8:38am View
   
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
TCS54321 4-May-15 8:29am View
   
Now u read the question.. i hope now u understand the question.
TCS54321 4-May-15 8:22am View
   
ok.. i have Improve my question..
TCS54321 4-May-15 8:09am View
   
i have no idea how can i do it..
TCS54321 22-Apr-15 1:04am View
   
i want to do it from client side.
TCS54321 9-Apr-15 2:33am View
   
boths are working
TCS54321 9-Apr-15 2:32am View
   
Its Working.. tnx
TCS54321 9-Apr-15 2:30am View
   
1)Error converting data type varchar to float
2)'CONCAT' is not a recognized built-in function name
This is the errors
TCS54321 9-Apr-15 2:28am View
   
Deleted
No one Working
TCS54321 9-Apr-15 2:28am View
   
No one working
TCS54321 1-Apr-15 3:30am View
   
Any One Know That....
TCS54321 22-Dec-14 3:09am View
   
i have update my ques. how u get any solutions
TCS54321 12-Dec-14 4:45am View
   
so number of columns are not fix..
TCS54321 12-Dec-14 4:44am View
   
sir, AutogenrateColumns are TRUE in my gridview.
TCS54321 10-Dec-14 1:30am View
   
i need some ideas to do that by code.
TCS54321 10-Dec-14 1:30am View
   
why u not write code..
TCS54321 8-Dec-14 2:58am View
   
Error:Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
TCS54321 22-Nov-14 2:11am View
   
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
TCS54321 18-Nov-14 6:42am View
   
tnx for ur effort shweta ji.. i am using both solutions. but not getting right output.
TCS54321 18-Nov-14 5:44am View
   
yes rajesh ji.. u r right..
TCS54321 18-Nov-14 5:28am View
   
i tried this. but its not give right output. its give me a cartesian product of table.
TCS54321 18-Nov-14 5:25am View
   
this is a single table. and i tried join but its not give right output..
TCS54321 13-Nov-14 5:16am View
   
Deleted
:)
TCS54321 13-Nov-14 5:10am View
   
again thank you shwetaa ji..
TCS54321 13-Nov-14 5:04am View
   
ur welcome shwetaa ji..
TCS54321 13-Nov-14 4:48am View
   
ohk..
TCS54321 12-Nov-14 7:53am View
   
tnxx shwetaaaaa.. ;)
TCS54321 22-Oct-14 3:05am View
   
its increase and decrease as situation.
TCS54321 22-Oct-14 3:05am View
   
Number of Image Column are not fix. And name of image column are also not fix.
TCS54321 18-Sep-14 8:53am View
   
for example:- if i select course that name b.tech(csc) then only 1,3 and 6 sem checkbox color will be change
TCS54321 18-Sep-14 8:51am View
   
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" />
TCS54321 2-Sep-14 9:23am View
   
thanku mam..
TCS54321 1-Sep-14 9:30am View
   
i need the code in vb.net
TCS54321 29-Aug-14 8:55am View
   
yes sir.. its working.. thanku
TCS54321 29-Aug-14 8:52am View
   
sir, 100 is a hardcode. every time it take 100 in place of total??
TCS54321 29-Aug-14 8:42am View
   
ok
TCS54321 29-Aug-14 8:41am View
   
sir, its not working, it said invalid column
TCS54321 29-Aug-14 8:40am View
   
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.
TCS54321 29-Aug-14 7:51am View
   
i solve it.. thanks
TCS54321 29-Aug-14 2:03am View
   
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
TCS54321 29-Aug-14 2:00am View
   
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.
TCS54321 27-Aug-14 6:40am View
   
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.
TCS54321 27-Aug-14 6:39am View
   
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..
TCS54321 27-Aug-14 1:23am View
   
yes.. but its not working
TCS54321 26-Aug-14 9:44am View
   
not working
TCS54321 26-Aug-14 8:18am View
   
i am using only fileupload button. how can i call a mathod to click on fileupload button
TCS54321 25-Apr-14 1:45am View
   
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
TCS54321 18-Apr-14 3:59am View
   
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?
TCS54321 18-Apr-14 1:13am View
   
tnx
TCS54321 17-Apr-14 8:19am View
   
its working.. thanku
TCS54321 17-Apr-14 8:06am View
   
its not working
TCS54321 17-Apr-14 8:01am View
   
but in text area how can i take value using vb.net that i can use in input textbox.
TCS54321 17-Apr-14 6:01am View
   
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
TCS54321 17-Apr-14 6:00am View
   
Deleted
strb.Append("<input id=""Text1"" textmode=""multiline"" style="" width=""50px"" text-align: center;"" class=""txt"" type=""text"" name='value_""1""_txb' value=""class:" & k & """/>")


i am using this in vb.net
TCS54321 17-Apr-14 4:52am View
   
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.
TCS54321 17-Apr-14 1:13am View
   
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?
TCS54321 11-Apr-14 9:16am View
   
its working... thanku
TCS54321 11-Apr-14 9:05am View
   
Conversion failed when converting the varchar value ',' to data type int.

this is a error when i run this query
TCS54321 9-Apr-14 1:10am View
   
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..
TCS54321 9-Apr-14 1:06am View
   
roomid seatno classid studentid
1 1 17 101
1 2 18 102
1 3 17 103
1 4 18 104
TCS54321 4-Apr-14 2:24am View
   
hahaha..
TCS54321 27-Feb-14 1:58am View
   
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.