15,881,882 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 Python 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 The Doer (Top 140 by date)
The Doer
7-Jan-16 2:46am
View
Post your source code here.
The Doer
22-Nov-15 22:27pm
View
Yes , you are right . Re-sizing the window to support all your tags is supported in Bootstrap. You can implement Bootstrap to achieve this functionality.
The Doer
15-Jun-15 4:15am
View
I agree it not useful to store all values in a single column . But as per the question if suppose one has to save in single column then they must delimit.
These types of questions might ask in an interview to test the reasoning of one to solve this by hook or by crook
The Doer
15-Jun-15 4:07am
View
Peter can you explain how is this wrong?
The Doer
9-Jun-15 23:05pm
View
Isn't it be useful if they delimit it by delimiter?
The Doer
9-Jun-15 10:08am
View
What type of data are you pulling from database?
The Doer
20-Jan-15 2:10am
View
Yes Sunitha, that is the best practice to write your javascript just before your <body> tag ends.
The Doer
30-Apr-14 5:19am
View
Yes added.. but here insteat of that we need to add ToolScriptManager
The Doer
29-Apr-14 21:37pm
View
1. If i remove the ToolScriptManager manager from master page my Ajax control does not work.
2. Same if i add ScriptManager
The Doer
26-Dec-13 4:37am
View
Yes you are correct , finally i did this with the help of paramaters where User Name and password are in the plain text.
The Doer
19-Dec-13 23:37pm
View
(!row.IsNewRow) this will return OLD rows.
The Doer
19-Dec-13 23:34pm
View
if (!row.IsNewRow) This will return OLD data, Not the newly inserted one.
The Doer
18-Nov-13 2:35am
View
Yes you have to mention their ID's.
The Doer
19-Sep-13 22:19pm
View
Have your installed JQuery to your website?
The Doer
19-Sep-13 5:04am
View
What error are you getting?
The Doer
19-Sep-13 0:19am
View
i could not find the "WRITE" code for that !!
The Doer
19-Sep-13 0:04am
View
string operand = textBox2.Text.ToString();
{
Why you put braces there when you don't have any condition ?
The Doer
19-Sep-13 0:03am
View
Where is the error?
The Doer
25-Jul-13 4:46am
View
and then now as soon i change from EncryptSensitiveWithUserKey to EncryptSensitiveWithPassword , my package is not running- it shows error as-
Failed to acquire connection, Or you may not have the right permission on this connection.
Note:- Am deploying it in another Server. Does it cause any effect??
The Doer
25-Jul-13 4:44am
View
I changed now its displaying-
/FILE "H:\BOOGLE\BOOGLE\bin\Deployment\Package.dtsx" /DECRYPT /CHECKPOINTING OFF /REPORTING E
but it cause error as-
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'sa'.". End Error Error: 2013-07-25 16:39:27.10 Code: 0xC00291EC Source: Sales from MADPOS to B2Lingerie Execute SQL Task Description: Failed to acquire connection "172.16.3.10.AIMB_POS.sa". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:39:24 PM Finished: 4:39:27 PM Elapsed: 3.031 seconds. The package execution failed. The step failed.,00:00:03,0,0,,,,0
The Doer
25-Jul-13 1:42am
View
Hi Kuthuparakkal,
I am also facing the same problem i changed from EncryptSensitiveWithUserKey to EncryptSensitiveWithPassword . and done the modification as you writtten above, but ended up with the following error.
Missing argument for option "decrypt".
The command line parameters are invalid. The step failed.
The Doer
21-Jul-13 8:31am
View
Yeah thats alright, Cheers.
The Doer
19-Jul-13 4:27am
View
It may be because the location Rows[0][1] may not be the appropriate one. Please Check the dataset in your window has got values(1 or 2) or not.
The Doer
19-Jul-13 3:31am
View
couldnt update my previous answer , so posted as new Solution, Please check.
The Doer
19-Jul-13 2:55am
View
for that you have to alter your code a little bit, tell me how you distinguish user from Admin?
is it UserTypeID=1 for Admin
and
UserTypeID=2 For user?
The Doer
18-Jul-13 2:08am
View
show your code for Selected Change event, your binding has no error
The Doer
11-Jul-13 5:48am
View
what is adSource ,btnx and btnpv here?
The Doer
27-Jun-13 23:12pm
View
thanks prabu, but 1st where condition is enough i guess as _Amy specified.
Anyhow the Answer was correct so accepted.
The Doer
27-Jun-13 23:05pm
View
sahi he kamine , Jeete raho! +5
The Doer
26-Jun-13 5:17am
View
yelo bhai, tumare liye mera chota sa tofa-
http://www.codeproject.com/Questions/372390/How-to-insert-the-correct-range-in-sql-server
The Doer
25-Jun-13 5:25am
View
+5 good one Arun
The Doer
25-Jun-13 5:06am
View
Your Question is not appropriate please eloborate on "for example Var_str_Value or Var_str_Var_Variable or Var_str.Comment."
The Doer
25-Jun-13 4:47am
View
Your Code snippets please..
Make sure that you have chosen the appropriate table from DataSet.
The Doer
24-Jun-13 23:54pm
View
Do you want to enter those into some tables?
The Doer
24-Jun-13 22:21pm
View
what is the values of your TargetDirectory and memberID ??
The Doer
24-Jun-13 22:14pm
View
Make friendship with google first then with CP !
The Doer
24-Jun-13 21:55pm
View
Which types of files are these? Are they table data? In which form they do exists?
The Doer
24-Jun-13 21:48pm
View
Lack of Information.
"how to do this if it is calculate don the fly."
What this means??
"What is the stored procedure on how to do this"
Without knowing the table structure how one can help you writing the SP??
The Doer
24-Jun-13 5:02am
View
Why dont you go for Menu Control of ASP .net?
The Doer
24-Jun-13 2:21am
View
前需重新将 因为我不明白。?? 可以感谢 done!
The Doer
24-Jun-13 1:33am
View
when your solution works for you, do share those it may helps someone in need.
The Doer
21-Jun-13 6:01am
View
I suggest you to use the "Group by" container for all of your individual package.
And it seems there may be some exception cases(FileName) in your constraint that you have given to pass to next package(the one which is not executing), else it would have executed.
Filename mismatch aagirbhaudu, try madi nodi .
The Doer
21-Jun-13 3:48am
View
less information to support you Mr. XYZ, can u mention the bug/error msg that returning to u . Pleaase check your execution result pane.
The Doer
21-Jun-13 3:38am
View
What is the problem here? You are done with it, any errors?
The Doer
28-May-13 2:23am
View
where did you pasted your .dll file? browse through the add reference window and add it. is it .net assembly? if not then you cannot do it.
The Doer
6-Feb-13 10:08am
View
Is that solves your problem, if so accept this as an answer. if not post the solution if you find any such that it can help to others.
The Doer
28-Jan-13 20:09pm
View
Your question is not at all a question. Where goes the "?" and the above one is only a Statement? what exactly you want?
The Doer
25-Jan-13 4:32am
View
Do not be so infant, Asking a question and answering it for your own wish and later accepting it as AN answer. What is this? this is not your rough book to write anything whenever you want and to rub it on your wish. People here need the genuine questions and answers too. Mind it.
The Doer
25-Jan-13 4:02am
View
you welcome.
The Doer
25-Jan-13 2:57am
View
The way you have encrypted from RMC67-A49682-99237 to ÒÍö·Á´¹¶¸²¹¹²³·
the same way you suppose to decrypt to get back the original form.
Let us know how you have encrypted to unicode.
The Doer
21-Jan-13 4:13am
View
then how come u accepted your own answer? Make some other way to gain points rather accepting your fake answers. If some MVP person saw this, they will block you the next moment.
The Doer
21-Jan-13 4:11am
View
What problem you are getting, dont expect people here to do your home work.
The Doer
21-Jan-13 3:46am
View
If u have any doubt and queries, please use the Comment section rather using the Answer Section. The above one is not the solution, its just your query/Doubt.
The Doer
21-Jan-13 3:45am
View
Where goes your calender control??
If you donot want to use seperate calender Control, Yes you can do that using JQuery and can customize your textbox.
The Doer
21-Jan-13 1:10am
View
how your 01000100 converted to "1"??
Is there any algorithm ?
What if u have binarCode as "11110000" this would be 1 or 0??
InSufficient information..!
The Doer
19-Jan-13 10:59am
View
which CR version you are using?
The Doer
19-Jan-13 10:58am
View
Store your data in excel file and import the file to you database table with the column datatypes as mentioned above, watch this youtube video for importing from excel to sql.
http://www.youtube.com/watch?v=Z1vqhYlwcyA
The Doer
18-Jan-13 5:11am
View
How u resolved the issue?? Do answer for that. It may be a needy Stuff for others.
The Doer
18-Jan-13 3:21am
View
Please clarify your question more clearly , does it pop up some some parameters? Do you want to avoid those?
The Doer
18-Jan-13 2:04am
View
Are u sure sonu Solanki?
The Doer
18-Jan-13 2:00am
View
Offer him a glass of cold water, let him Emollient..
The Doer
17-Jan-13 23:31pm
View
Where you are writing these lines of code??
because of "dgvUserDetails.Columns.Add(cmbcaste) " it may add another combobox to your Grid, No need to specify this line, if you have already bound the comboBox to the Grid.
The Doer
17-Jan-13 22:59pm
View
What is the problem are you facing?
Is it that in your query execution you are getting 2 rows of data and in report 6 rows of data.
Which CR version you are using , My opinion to check your "SET LOCATION" and DSN for the report.
The Doer
17-Jan-13 5:02am
View
What is "hexvalue" here??
You are passing only one parameter to your INSERT statement while mentioning it as two.It astounds .. !
The Doer
25-Oct-12 7:09am
View
Under E-underwrite Code project too ?
The Doer
25-Oct-12 7:08am
View
Good going Amit..! my 5 !
The Doer
4-Oct-12 5:28am
View
my 5! was in same situtaion..
The Doer
27-Sep-12 6:01am
View
my 5 for lucid explanation..! dont know why ppl forget to mark their answer when it helps..!
The Doer
26-Sep-12 7:17am
View
Ask ur friend Google about this , He can give you any number of examples you want.
The Doer
26-Sep-12 7:15am
View
Deleted
Ask ur best friend Google about this..
http://www.google.com.my/#hl=en&output=search&sclient=psy-ab&q=parsing+in+sql+server&oq=parsing+in+sql+server&gs_l=hp.3..0j0i30l2j0i5l5j0i5i30l2.890.5656.1.5859.21.21.0.0.0.1.500.6470.0j4j7j5j4j1.21.0.les%3B..0.0...1c.1.Kyd6WYVDx5Q&psj=1&bav=on.2,or.r_gc.r_pw.r_qf.&fp=5d41a32613d2d6c6&biw=1024&bih=571
The Doer
3-Aug-12 6:14am
View
thanks Fotrosi :)
The Doer
31-Jul-12 6:44am
View
my 5 Amit Bhai ;)
The Doer
24-Jul-12 7:50am
View
Yes, its done bhai..! thanks.. :)
The Doer
24-Jul-12 7:42am
View
Deleted
Now working bhai, Thanks n miss u bhai...
The Doer
24-Jul-12 7:35am
View
arre bhai ruko yeh nahi aa raha saalaa....
The Doer
24-Jul-12 7:31am
View
Thanks Amit Bhai.. :)
The Doer
22-Jul-12 5:48am
View
Deleted
thanks Sandeep bhai..
The Doer
22-Jul-12 2:56am
View
thanks, Where to post my question??
The Doer
12-Jun-12 7:32am
View
thanks for appreciation !
The Doer
4-Jun-12 5:31am
View
what u want?? do you want to delete it from database too??
The Doer
2-Jun-12 2:27am
View
from where you want to retrieve data?? in which control??
The Doer
1-Jun-12 4:58am
View
code project has provided with a lot of widget, Pls USe them appropriately.
The Doer
25-May-12 6:07am
View
what type of event your GridView is raising??
The Doer
25-May-12 6:06am
View
how one by one u want to Display?? In Grid View or something else??
The Doer
15-May-12 6:58am
View
have you try with getElementById??
The Doer
27-Apr-12 8:31am
View
yes Its must to create a typed dataset(.xsd) This dataset ll be loaded into the report docunment then the report document will be binded to the Crystal Report Viewer.
Here the .xsd dataset should contains the same column name as of the column name in your table in the database.
Refer these point you may find some way ..
The Doer
27-Apr-12 4:38am
View
Use substring function to get the "demo Patient "..
(2) is not clear to me..
The Doer
27-Apr-12 3:12am
View
my 5! Quite Informative:)
The Doer
27-Apr-12 3:06am
View
how come t.startDate?? (timeSheet t) has no StartDate column..
The Doer
27-Apr-12 2:45am
View
what is the datatype of leaveType?? varchar or you are taking in number of hours??
The Doer
27-Apr-12 2:36am
View
Show Ur code, Then only someone can suggest you, And no need to raise same question more then once... You can update the same question.
The Doer
24-Apr-12 7:59am
View
sorry,am not using .net, its SQL server.
We can't use exists here because
Minimum=23 Maximum=30
is not exists still its invalid, and there's no function as overlap in SQL Server..
The Doer
12-Apr-12 2:48am
View
Its hard to suggest you any way , because your question is very brief..
The Doer
12-Apr-12 2:45am
View
my 5! Lucid Explanation..:-)
The Doer
3-Apr-12 2:59am
View
yeah thanks a its useful stuff:-)
The Doer
3-Apr-12 2:30am
View
Yeah absolutely,
But now my point of view is towards SQL validations..
We can use CHECK constraint also at database side.. If we can validate at client and server side,then what is the use of that CONSTRAINT in SQL SERVER??? And where this CHECK constraint is applicable??
The Doer
3-Apr-12 2:29am
View
We can use CHECK constraint also at database side.. If we can validate at client and server side,then what is the use of that CONSTRAINT in SQL SERVER???
And where this CHECK constraint is applicable??
The Doer
3-Apr-12 2:10am
View
if i use CHECK constraint , then whats the advantage/disadvantage of it?
The Doer
28-Mar-12 1:07am
View
can u show your textBox source file..
The Doer
21-Mar-12 7:59am
View
my exception is---
Violation of UNIQUE KEY constraint 'unique_User'. Cannot insert duplicate key in object 'dbo.UserDetails'. The statement has been terminated
how can i address this ?? if i want to print the message as 'User already exists"
The Doer
21-Mar-12 7:57am
View
even i can use like this,
catch (SqlException ex )
But Sql Exception can itself contain many more exceptions, so how to address any specified one there..??
The Doer
13-Mar-12 0:37am
View
5! great work...!
The Doer
6-Mar-12 4:32am
View
show your table structure, Let me see what i can do for you..
The Doer
3-Mar-12 1:31am
View
if you want employee name then use joins between those two tables
The Doer
2-Mar-12 2:22am
View
are you using SQL server?? or some other ??you tagged question as sql server, but syntax seems to differ..
so are you displaying hour in hh.mm format?? if it is so then the query has to be modifies, because here two fields are there i:e hh & mm
The Doer
2-Mar-12 1:55am
View
how you are storing totalhours in ur table??
I mean whether you have created any function or user only has to enter the 'totalhours' in the table
The Doer
1-Mar-12 4:02am
View
how your duration changes from 101.75 to 102.15???????/
The Doer
28-Feb-12 4:18am
View
how to add this code block?
The Doer
24-Feb-12 7:30am
View
how your result would be bum=20 when its previously 30 and you want to increase it by 10????
and cake=40 when its previously 10??
and bisckit=60 when its previously 40??
If u wanna increment thost by 10 and increase Chocolate by 5 then your result should be--
ProductName Price
Cake 20
Chocolate 30
bun 40
bisckit 45
use the query i have suggested..
The Doer
23-Feb-12 0:46am
View
whsich DSN have u created?? User or System or File??
The Doer
21-Feb-12 23:07pm
View
yeah Zorro.., if the application is for a particular client then we can specify that the application runs on the articular browser., for web sites we should have to do the survey as per the audience usage of the browser.
The Doer
21-Feb-12 22:53pm
View
Deleted
Reason for my vote of 5
coz it works:)
The Doer
21-Feb-12 9:26am
View
for 3: hey zorro i also not sure about the exact percentage.., but most of the people use the cafe or net parlor to browse.. where they have not usually upgrade their browser to newer version, so generally a common man will use the same browser.So isn't it better to create an application which will run on older versions??
The Doer
21-Feb-12 1:18am
View
amit..,bcoz none of the string ends with spaces so...
The Doer
21-Feb-12 1:17am
View
thanks andre,, i was not knowing such stuffs...
The Doer
21-Feb-12 1:09am
View
nice work out Nilesh...
ur procedure works fine but not for my table because here am dynamically assigning the valu to the 'tot','avg','result' field using functions see my table defination as
CREATE TABLE ttStudent(stdId INT PRIMARY KEY,m1 INT,m2 INT,m3 INT,tot AS(dbo.total(m1,m2,m3)),average AS (dbo.average(m1,m2,m3)),result AS (dbo.result(m1,m2,m3)))
but when u do the below lines in ur procedure -->
insert into TTSTUDENT (stdId,m1,m2,m3,tot,average,Result) values(@stdId,@m1,@m2,@m3,@tot,@average,@Result)
it raise error as
Msg 271, Level 16, State 1, Procedure spName, Line 22
The column "tot" cannot be modified because it is either a computed column or is the result of a UNION operator.
Msg 271, Level 16, State 1, Procedure spName, Line 22
The column "average" cannot be modified because it is either a computed column or is the result of a UNION operator.
Msg 271, Level 16, State 1, Procedure spName, Line 22
The column "result" cannot be modified because it is either a computed column or is the result of a UNION operator.
Msg 271, Level 16, State 1, Procedure spName, Line 24
The column "tot" cannot be modified because it is either a computed column or is the result of a UNION operator.
Msg 271, Level 16, State 1, Procedure spName, Line 24
The column "average" cannot be modified because it is either a computed column or is the result of a UNION operator.
Msg 271, Level 16, State 1, Procedure spName, Line 24
The column "result" cannot be modified because it is either a computed column or is the result of a UNION operator.
The Doer
21-Feb-12 1:03am
View
yeah man i have checked...
it shows the same rank to all those who have same total..
1 22 50 50 122 40 F 3 9
2 10 60 40 110 36 F 3 10
5 21 31 32 84 28 F 3 11
7 10 78 84 172 57 F 3 3
10 70 80 90 240 80 P 3 2
11 70 80 99 249 83 P 1 1
81 70 15 50 135 45 F 3 8
82 70 35 55 160 53 P 3 7
83 70 35 55 160 53 P 3 7
84 70 35 55 160 53 P 3 7
85 70 35 55 160 53 P 3 7
The Doer
21-Feb-12 0:33am
View
I have posted my procedure..,
as i am setting the substring value as seperated by 'spaces' hence it requires a space at the end of the string.
set @subString=left(@baseString,charindex(' ',@baseString)-1)
The Doer
21-Feb-12 0:24am
View
Nilesh it that class rank trigger works for me.., i have put 2 triggers over there.., in which u found difficulty?
The Doer
20-Feb-12 23:01pm
View
do u want total number of radio button checked among all 60*5 radio buttons??
The Doer
20-Feb-12 6:41am
View
no its not working..:(
The Doer
20-Feb-12 6:37am
View
no varun its not working.., am using mozilla..
The Doer
20-Feb-12 6:03am
View
yes Nilesh pls give...
The Doer
20-Feb-12 6:00am
View
U HAVE GOT ENOUGH SOLUTIONS DIVYA...:)
The Doer
20-Feb-12 5:25am
View
am trying hard to create that trigger but still undone :(
The Doer
20-Feb-12 5:22am
View
view may be but i want separate column..
The Doer
17-Feb-12 23:12pm
View
YEAH HERE I GOT THE REQUIRED OUTPUT..:)
THANK YOU SIR...!
The Doer
17-Feb-12 23:02pm
View
Deleted
my logic was this one.., some one has updated that wrongly..
b = (a + b) - (a = b);
if a=20;b=10;
b=(20+10)-(a=10);
b=(30)-(10) //here a has assigned value 10
b=20 //here b has assigned to 20
// hence that single statement interchanges two variable..
// hope i make some sense with this....
The Doer
17-Feb-12 23:02pm
View
Deleted
my logic was this one.., some one has updated that wrongly..
b = (a + b) - (a = b);
if a=20;b=10;
b=(20+10)-(a=10);
b=(30)-(10) //here a has assigned value 10
b=20 //here b has assigned to 20
// hence that single statement interchanges two variable..
// hope i make some sense with this....
The Doer
17-Feb-12 8:07am
View
THEN PLS GET ME THE QUERY TO GET THOSE 5 LAST VALUES...
The Doer
17-Feb-12 8:04am
View
I HAVE DONE THAT USING TEMPORARY TABLE...JUST WANT TO KNOW SOME OTHER WAYS..
The Doer
17-Feb-12 8:03am
View
I HAVE PUT THE CAPS KEY ON INTENTIONALLY... JUST AS TO BE THE FOCUSED ONE AMONG ALL COMMENTS ;)
The Doer
17-Feb-12 8:01am
View
HOW TO USE CLUSTURED INDEX HERE??WHEN I DON'T HAVE ANY PRIMARY KEY HERE..
The Doer
17-Feb-12 7:52am
View
OH OKAY, AM NEW HERE.. HENCE UNAWARE WITH THOSE CONVENTIONS...:(
COMMING TO THE SOLUTION PART:
IF I USE ORDER BY CLAUSE THEN THE ORDE CHANGES AND I WON'T GET THE REQUIRED OUTPUT..
The Doer
17-Feb-12 6:12am
View
HERE I HAVE ONLY 1 COLUMN, SUPPOSE I HAVE 20 + COLUMNS THEN WHAT WILL U DO?
The Doer
17-Feb-12 6:04am
View
THATS IT BUDDY...! 5!
The Doer
17-Feb-12 6:02am
View
IF THIS IS MY TABLE CONTENT, I DONT WANT THE ORDER TO BE CHANGED,AS U CHANGED USING ORDERbY CLAUSE..AGAIN I WANT FROM 6TH TO 9TH RECORD i:e B C D a..TRY SOME MORE..
a
B
C
D
E
B
C
D
a
B
C
D
a
B
C
D
E
The Doer
16-Feb-12 4:53am
View
eventhough its not.
The Doer
16-Feb-12 4:49am
View
no its not working..:(
The Doer
15-Feb-12 23:57pm
View
thanks Praveen , u made my way easySmile | :)
Show More