16,004,678 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by ssd_coolguy (Top 145 by date)
ssd_coolguy
13-Jun-13 2:37am
View
yep... thanks.. i think we both solved at same time...:)
thank you for your support.. :)
ssd_coolguy
13-Jun-13 2:31am
View
reportviewer is not visible..hence report also not..
and when i set report to reportviewer through properties... report viewer and report both are visible...
ssd_coolguy
20-Feb-13 5:58am
View
please explain more... not sufficient information...
ssd_coolguy
20-Feb-13 5:48am
View
sorry but not understood your question.. :(
What i can understand is you need difference between current and last month then you can use..
between DATEADD(month,-1,getdate()) and getdate()
ssd_coolguy
20-Feb-13 5:28am
View
see my another solution 3
ssd_coolguy
19-Feb-13 4:51am
View
do your calculation in stored procedure and execute it through SQL JOB. :)
ssd_coolguy
19-Feb-13 4:44am
View
can you tell us.. what exactly that sql file contain..?
is there any query?
ssd_coolguy
5-Feb-13 3:49am
View
http://www.w3schools.com/js/js_obj_date.asp
try above link..
ssd_coolguy
27-Dec-12 7:20am
View
yet i am not clear with your question..
see you have total likes calculated for each month no? means oct and nov?
means your total likes for oct 254 and for nov 220..r8?
ssd_coolguy
27-Dec-12 6:56am
View
you just simply add perc.diff column in you @tbl1 table and insert query..
ssd_coolguy
27-Dec-12 6:52am
View
why don't you use single command to take backup of sql server..
backup database dbname to disk= 'F:\dbname.bak'
ssd_coolguy
19-Sep-12 4:38am
View
5++
ssd_coolguy
19-Sep-12 4:32am
View
bcoz..here you have different mail body for every mail id..and for that you need to set body every time..
ssd_coolguy
18-Sep-12 6:38am
View
explain more...............
ssd_coolguy
18-Sep-12 4:25am
View
you can use it in session start method..
ssd_coolguy
18-Sep-12 2:50am
View
not clear.. can you explain more...
ssd_coolguy
6-Sep-12 8:25am
View
Thanks Santosh..:-)
ssd_coolguy
5-Sep-12 8:46am
View
Deleted
Do yo uhave Google?
ssd_coolguy
5-Sep-12 8:46am
View
Do you have google...?
ssd_coolguy
5-Sep-12 6:25am
View
Thanks.. :)
ssd_coolguy
5-Sep-12 6:18am
View
i think it's not a single string. it's 3 different columns.
your function is correct when input is like '90,75,80'
ssd_coolguy
4-Sep-12 8:33am
View
see if i correctly understands you...
i have updated my answer
ssd_coolguy
4-Sep-12 8:29am
View
any 1 who downvoted. can you just expalin why... have you tested?
ssd_coolguy
4-Sep-12 7:46am
View
see now. i improved my answer..
ssd_coolguy
4-Sep-12 7:23am
View
yes.. now it will work.. just improve your solution.. :)
ssd_coolguy
4-Sep-12 7:12am
View
have you tried solution 2?
ssd_coolguy
4-Sep-12 7:11am
View
can you elaborate more...
ssd_coolguy
4-Sep-12 7:09am
View
i think you missed else part here...
ssd_coolguy
3-Sep-12 6:55am
View
not getting.. what you are trying to do... can you elaborate more?
ssd_coolguy
31-Aug-12 8:33am
View
can you elaborate more?
ssd_coolguy
31-Aug-12 8:10am
View
if i m correctly understands your problem then you need data like..
abc R1 .net high
abc R1 sql low
abc R1 jquery low
xyz R2 .net low
you can do it using join to...
ssd_coolguy
31-Aug-12 7:59am
View
can you elaborate more?
ssd_coolguy
31-Aug-12 7:48am
View
Can't you use loop here?
ssd_coolguy
29-Aug-12 2:48am
View
see my updated solution...
ssd_coolguy
29-Aug-12 2:43am
View
means you want month & year wise data right?
ssd_coolguy
25-Aug-12 2:17am
View
why don't you write insert staement into your store procedure..?
ssd_coolguy
24-Aug-12 5:29am
View
we can select only one database while opening new query window..
but we can go through diffrent database using below query..
use database_name
By the way you don't need to select two database while retriving data.
ssd_coolguy
24-Aug-12 3:28am
View
if we correcly understands your problem..then
see the 2nd solution for join..
else exlpain more...
you want data from two diffrent server??
ssd_coolguy
24-Aug-12 3:14am
View
currently you are using database1 and you want to retrive data from table1 from database2
then..
select * from database2.dbo.table1
ssd_coolguy
24-Aug-12 2:19am
View
you asked for course_no and paper_name
if you want course name then it requires table1..
ssd_coolguy
24-Aug-12 2:02am
View
what you have tried?
ssd_coolguy
24-Aug-12 1:47am
View
can you show us your code...
ssd_coolguy
23-Aug-12 5:05am
View
if i understands you correctly then.
you have table contains
1
2
3
4
.
.
n
records and you need only
2
3
4
.
.
n
not 1st record.. am i right?
ssd_coolguy
23-Aug-12 4:55am
View
can you elaborate more..
ssd_coolguy
23-Aug-12 1:26am
View
i am glad it's working..
accept the answer..
ssd_coolguy
23-Aug-12 1:04am
View
see the solution 2...
ssd_coolguy
23-Aug-12 0:54am
View
can you show us how you called your sp?
ssd_coolguy
22-Aug-12 2:45am
View
if i correctly understand your problem then...
you just need to pass the parameter to your report..
ssd_coolguy
21-Aug-12 5:37am
View
can you explain more...
ssd_coolguy
17-Aug-12 9:11am
View
hey..why don't to go for running sum query?...
ssd_coolguy
10-Aug-12 6:10am
View
what exactly you want.. can you expalin more...
ssd_coolguy
10-Aug-12 5:42am
View
can you explain more with example..
means how batchname contains filenames?
ssd_coolguy
27-Jul-12 7:44am
View
nice discussion in link....
ssd_coolguy
25-Jul-12 0:32am
View
Dude.. if you are using Mysql datatype in Oracle then how it is possible?
ssd_coolguy
23-Jul-12 0:57am
View
can you explain more..what you want to do?
ssd_coolguy
21-Jul-12 3:46am
View
can you exlpain more.. what actualy you want to do?
ssd_coolguy
21-Jul-12 3:30am
View
my 5!...
ssd_coolguy
21-Jul-12 3:30am
View
but see below query which returns incorrect result.
select (datediff(day,'2012-07-01','2012-07-06')/7)+1 as Saturday
it should be return 0 na??
ssd_coolguy
21-Jul-12 1:55am
View
it will not return correct answer..
ssd_coolguy
20-Jul-12 5:02am
View
my 5! nice blog..
ssd_coolguy
20-Jul-12 2:20am
View
hey you just have a look on link which i have provided for your previous quetion..
You will get all answers for validation
ssd_coolguy
19-Jul-12 8:28am
View
which error did you get? and on which line?
ssd_coolguy
19-Jul-12 8:24am
View
so remove order by clouse from the query...
ssd_coolguy
18-Jul-12 8:40am
View
have tried google?
ssd_coolguy
17-Jul-12 4:27am
View
glad it helps.. now lough.. :)
ssd_coolguy
17-Jul-12 3:46am
View
hey.. nothing to lough in it. i am just helping you.. html page is on your pc or remote pc? or do 1 thing you just keep that image in folder with your page and give image name only in path..
ssd_coolguy
17-Jul-12 3:26am
View
means i was trying :)
ssd_coolguy
17-Jul-12 3:21am
View
yes i got your point.. but can you show us byte of code. so we can help you. is there any browser dependent code? or you need to check browser setting..
ssd_coolguy
17-Jul-12 3:11am
View
hei.. i am not sure but this error comes when your string contains any blank space.. that's why you need to replace youre sting with " " to "+".
ssd_coolguy
17-Jul-12 2:51am
View
hei AlluvialDeposit..
yes you are right.. it's my mistake.. i tried it on oracle.. ;)
anyway. i modified it.
thank you very much.. :)
ssd_coolguy
17-Jul-12 2:36am
View
AlluvialDeposit... you are such a nice person ... :) i can't contorl :-D
hello project virus,
What you have tried??
ssd_coolguy
17-Jul-12 2:32am
View
Glad it helps...
ssd_coolguy
17-Jul-12 2:15am
View
Have you tried google?
ssd_coolguy
17-Jul-12 1:59am
View
hey Bhushan_f & mindbrink,
if your dataset contains multiple tables, you can save it in database as below.
create as DA for table where you wanna insert and update DA using
DA.update(DS,"TableName")
Don't forget to create cammandbuilder :)
ssd_coolguy
11-Jul-12 6:08am
View
thanks for reply..
when i add option explicit in it..it's working fine... :)
thanks.. i was fighting for this since 1 hr.. :(
ssd_coolguy
11-Jul-12 6:06am
View
thanks for reply..
ssd_coolguy
11-Jul-12 6:06am
View
thanks for reply..
yes.. you are right i can view it in view source. :) and when i replaced it with lt/gt.. then i am able to view it.. :)
ssd_coolguy
10-Jul-12 2:50am
View
thanks for reply... your links helped me lot... :)
i am about to solve this problem..:) soon i will update answer here..
ssd_coolguy
6-Jul-12 4:26am
View
can you explain more with your code..
ssd_coolguy
27-Jun-12 8:12am
View
your question is not clear...
can you explain more..what actually you want to do..
ssd_coolguy
26-Jun-12 9:05am
View
hey amol..
and which basis you are going to make slot of 5-5??
ssd_coolguy
26-Jun-12 9:04am
View
Deleted
hey amol..
and which basis you are going to make slot of 5-5??
ssd_coolguy
26-Jun-12 7:02am
View
hi..
is your table contains only 1 day data?
ssd_coolguy
26-Jun-12 5:48am
View
can you elaborate more..
show it is in tables..
ssd_coolguy
26-Jun-12 5:38am
View
not working means ?
you got an error?
can you elaborate more..
ssd_coolguy
26-Jun-12 5:30am
View
hey.. now i have updated link...
just check it..
ssd_coolguy
26-Jun-12 1:15am
View
sorry i didn't get your question..
can you elaborate more
ssd_coolguy
25-Jun-12 9:22am
View
i don't think there is too much diff in both..
ssd_coolguy
23-Jun-12 7:04am
View
hey.. let us know what you have tried?
ssd_coolguy
23-Jun-12 4:05am
View
let us know what you have tried?
ssd_coolguy
23-Jun-12 3:59am
View
hey.. let us know what you have tried?
ssd_coolguy
22-Jun-12 9:03am
View
hey thanks for help..see solution 3..;)
ssd_coolguy
22-Jun-12 9:03am
View
hey thanks for help..see solution 3..;)
ssd_coolguy
21-Jun-12 13:08pm
View
good one answer...
ssd_coolguy
21-Jun-12 13:02pm
View
hey dude let us know what u have tried..
and the main thing is... where is your question?
ssd_coolguy
21-Jun-12 12:57pm
View
hey thanks... for accepting solution
ssd_coolguy
21-Jun-12 7:58am
View
correct answer..
ssd_coolguy
21-Jun-12 7:53am
View
i installed vs2008 on server but still it is giving same error..
just ISAPI filters as updated as below:
RSIsapiPlugin & ASP.NET_2.0.50727.0
shall i need to update my iis??
ssd_coolguy
21-Jun-12 7:02am
View
hey..let us know what you have tried?
ssd_coolguy
21-Jun-12 6:55am
View
hey let us know...you are entering two people in same time or diff?
or you will update for second?
ssd_coolguy
21-Jun-12 6:30am
View
thank you... :)
ssd_coolguy
21-Jun-12 6:07am
View
thanks... for reply..
means i need to install 3.5 on server..
ssd_coolguy
21-Jun-12 5:10am
View
hey what do you mean "each epmloyee where doteofjoining is lowest"?
is there multiple records for employee...?
can you explain more...
ssd_coolguy
21-Jun-12 4:38am
View
hey ..let us know what you tried..
ssd_coolguy
20-Jun-12 9:18am
View
thank you..:)
ssd_coolguy
20-Jun-12 9:08am
View
hey let us know which language you are using?? asp,.net?
ssd_coolguy
20-Jun-12 9:02am
View
correct answer my 5!!
ssd_coolguy
18-Jun-12 9:30am
View
yes i will sure spend time to learn vb.net...
i got solution with below code also just check it...
intmax = nextno.ToString("TXT000000")
if intmax contians 14 then it will return TXT000014... :)Thanks..
ssd_coolguy
18-Jun-12 8:47am
View
yes.. i tried below code.... but no output :(
intmax = String.Format(intmax, "TXT00000")
ssd_coolguy
18-Jun-12 8:41am
View
Thanks for reply..
but can please give me example.
ssd_coolguy
7-Jun-12 2:56am
View
hey i don't think is there any way to add column in between two existing column using TSQL.for that you need to use temp table or Enterprise Manager will write all of the code for you...:)
ssd_coolguy
7-Jun-12 2:07am
View
hey can u please explain more.. what exactly you want?
ssd_coolguy
6-Jun-12 6:18am
View
hey shahin ...thanks for reply..
ssd_coolguy
6-Jun-12 6:10am
View
Hey.. thank you very much...
your version 2 solution is working fine.. :) :D
Thanks..
ssd_coolguy
5-Jun-12 13:21pm
View
hii..waiting for solution...:)
ssd_coolguy
5-Jun-12 9:42am
View
hey dude.. sorry please don't mide. sorry if i said anything. but actualy from morning i am trying to get answer but i can't hence..i am frustrated.. :(
Thanks for your reply...
ssd_coolguy
5-Jun-12 9:30am
View
hey you are saying about webmethods... and i am asking about class in webservice..
if you didn't get question then ask for more clarification..
please don't post it in answer...
ssd_coolguy
5-Jun-12 9:21am
View
hey nope...
see i have created webservice and created one class in that webservice (class clsxml) and now when i create object of that webservice that time i want to use that class(clsxml).. but how??
ssd_coolguy
5-Jun-12 9:04am
View
hey dude... please read my question carefully. i was not asked about how to add webservice in application.
ssd_coolguy
5-Jun-12 1:04am
View
hey i think we are going wrongway..
can you just see the conversation between me and JimJos.
i am trying to updated the dataset using dataadapter but my datasets source is xml file...
your help would be appreciable...
ssd_coolguy
5-Jun-12 0:49am
View
yes boss i think it will work..
but see my seanario..xml dataset conatins only 2 rows but another dataset contains many row..means do i need to make data relation between them?
i cleared xmldataset and added another dataset's datatable into it and tried but it giving same error..:(
ssd_coolguy
5-Jun-12 0:23am
View
hey.. i hav used refreshschema(). and i cheked with select *. but it asked for remaining fields..:(
my create query is like :-CREATE TABLE [Compalint] (
[UserID] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Name] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Password] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Email] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LoginID] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Type] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ACTIVE_FLG] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LAST_SIGN_IN] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LAST_PWD_CHG] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
PRIMARY KEY CLUSTERED ( [UserID] ) ON [PRIMARY] ) ON [PRIMARY]GO
ssd_coolguy
4-Jun-12 8:43am
View
hey sorry but how i can remove it from update list... i tried to remove from select but it's giving error as primary key needs to update statement..:(
ssd_coolguy
4-Jun-12 6:04am
View
hi shahin .. i am confused... :(
because.. when i seen the commandtext from cmdbld.GetUpdateCommand().commandtext() and i got below update command..
UPDATE [compalint] SET [userid] = @p1, [loginid] = @p2 WHERE (([userid] = @p3) AND ((@p4 = 1 AND [loginid] IS NULL) OR ([loginid] = @p5)))
update command is right.. but why it is giving error?? :( :(
ssd_coolguy
4-Jun-12 5:59am
View
yes right...
ssd_coolguy
4-Jun-12 5:20am
View
yeah Sir you are right we need to set the 'RowState' property is UPDATE mode..
As per you, we can't update the tabel if we not take dataset from that table only..
So is there any way to solve this problem??
Sorry for my poor english :(
ssd_coolguy
4-Jun-12 5:12am
View
thanks for reply..
what you mean improve the update command? i am not writing any updated command..
and my table contins only one primary key "uesrid".
Can you please explain more??
ssd_coolguy
4-Jun-12 5:03am
View
thanks for reply...
dataset ds1 contains userid and loginid. and it is getting from xml file.
and i want to update compalint table's loginid field only.. because userid is primary key..
is my dataadapter update code is wrong?
ssd_coolguy
1-Jun-12 6:06am
View
Anand.. use your date column for sort..
ssd_coolguy
1-Jun-12 5:57am
View
thanks... it solved my problem. :)
ssd_coolguy
30-May-12 8:54am
View
hey sanjeev
see the improoved question..
ssd_coolguy
30-May-12 8:50am
View
Deleted
hey sanjeev i used xmldoc.save("file.xml") and got data like
<complaints>
<Table>
<userid>1
<name>suhas
<Password>7DCB7FBA2B871F5E2A5D7A41A</Password>
<email>
<loginid>ssd
<type>Others
<active_flg>A
<last_sign_in>2008-06-20T10:23:28.717+05:30 <last_pwd_chg>2008-06-12T14:39:15.903+05:30
</Table>
ssd_coolguy
24-May-12 8:22am
View
hey thanks..
ssd_coolguy
22-May-12 6:00am
View
if you have backup file then you can restore you table with values..
ssd_coolguy
21-May-12 5:12am
View
Deleted
hey mido..
i have question on it..
how can you write DML statements in function??
ssd_coolguy
17-May-12 6:34am
View
welcome...
accept the solution ;)
ssd_coolguy
17-May-12 1:12am
View
1.Create dmp file without data and insert it into new account.
2.Create another dmp file for only those table for which you needs data too.(give table name while creating dmp file)
3.drop those tables from new account and insert another (step 2) dmp in new account.
hope above steps will helps..
ssd_coolguy
17-May-12 0:32am
View
you mentioned that you need data also.. :)
but if you don't want data then while ceating dmp file give rows='N' parameter.
ssd_coolguy
16-May-12 5:16am
View
hey dude, you can not use aggregate function in where clause.
if you want condition on aggregate function you can use group by clause.
ssd_coolguy
16-May-12 5:11am
View
if you want to transfering data from excle to SQL databse
you can go for DTS packages..
ssd_coolguy
15-May-12 7:23am
View
can you please explain more...
because if you want only phone no field from file then above code is not useful and if this is onetime activity then you can go for DTS package.
ssd_coolguy
15-May-12 0:11am
View
did you got any error while running your code?
how many fields .slv file contains?
ssd_coolguy
14-May-12 6:19am
View
hey prasad, thanks i got clue from your post.. :)
plz see my solution..
ssd_coolguy
14-May-12 5:47am
View
i think this issue might be access issue...because used password is in encrypted format.
ssd_coolguy
14-May-12 5:25am
View
thanks for reply.. :)
Show More