16,006,768 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 sachin10d (Top 50 by date)
sachin10d
27-Jul-12 3:17am
View
Can you elaborate on what exactly you want to achieve
sachin10d
24-May-12 3:23am
View
I don't want any short cut way, but a best standard, to reduce code repetition.
sachin10d
24-May-12 3:08am
View
Try to run SQL server using Run As administrator.
or please give the error details.
sachin10d
4-May-12 3:38am
View
Changes made for the above error.
sachin10d
28-Mar-12 7:31am
View
while loop continues till there are records in datareader so no need to worry about the row2 column1 your code will access all the records.
sachin10d
28-Mar-12 7:29am
View
This should work fine
can you please explain more on this
sachin10d
27-Mar-12 7:30am
View
you are having a xHawk database and your creating a table named xHawk in that database
is it right?
sachin10d
23-Feb-12 7:35am
View
Query looks fine.
can you please give the detail error message.
sachin10d
20-Feb-12 3:08am
View
welcome
sachin10d
13-Feb-12 0:36am
View
yes, It is possible
sachin10d
18-Nov-11 6:43am
View
in Add your solution here select the lines which you want to set as code
an
Add your solution here>>Code>>select the appropriate language
sachin10d
10-Nov-11 6:27am
View
thanks ravi
sachin10d
10-Nov-11 6:26am
View
thanks
sachin10d
21-Oct-11 7:54am
View
please specify what actually you want to do
sachin10d
21-Oct-11 2:20am
View
Good One!!!
sachin10d
20-Oct-11 9:03am
View
check query output time required in sql server first.
sachin10d
20-Oct-11 3:48am
View
give the error details
sachin10d
20-Oct-11 2:13am
View
get {
if (!string.IsNullOrEmpty(statusMessage.Message))
return statusMessage.Message;
return null;
}
sachin10d
19-Oct-11 8:14am
View
you can google it instead of asking for a solved example.
try some thing and we can help you
sachin10d
18-Oct-11 2:34am
View
give some more details
sachin10d
14-Oct-11 9:17am
View
Changed elseif line and now it works fine
sachin10d
11-Oct-11 8:27am
View
thanks digimanus
sachin10d
10-Oct-11 8:10am
View
can you show datagridview binding code
sachin10d
10-Oct-11 8:09am
View
deleting data from foreign key table having primary key is possible
what problem are you facing?
sachin10d
3-Oct-11 6:34am
View
what is the problem?
sachin10d
30-Sep-11 7:12am
View
select top 10 voucherno,entrydate,transectiondate,saleman,itmcode,itmname,cash,aprtycode,issue_qty,amount,given_t0,balance,itm_part,total_amount
from myTable
sachin10d
28-Sep-11 6:15am
View
grouping the date on shift can also show the sift wise data
sachin10d
27-Sep-11 2:37am
View
good link!!!
sachin10d
27-Sep-11 0:03am
View
use this query to truncate all your tables.
select 'truncate table ' + table_name from INFORMATION_SCHEMA.TABLES
sachin10d
24-Sep-11 11:36am
View
Post the Error details please
sachin10d
23-Sep-11 8:46am
View
if there is no identity column in destination table then select * from will work.
sachin10d
23-Sep-11 8:44am
View
select * from will work fine only if all the columns are to be inserted
if you do have any identity column then you will have to specify all the columns except the identity column as identity column will be auto filled.
sachin10d
22-Sep-11 8:47am
View
start>>run>>cmd
C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
for details refer http://msdn.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
sachin10d
22-Sep-11 8:43am
View
please reffer your earlier post
http://www.codeproject.com/Questions/258615/i-have-create-virtual-directory
sachin10d
22-Sep-11 8:41am
View
unchecked "Allow IIS to control password" checkbox in IIS settings
sachin10d
22-Sep-11 8:37am
View
please post the error details for log entry
sachin10d
20-Sep-11 7:16am
View
check this
http://msdn.microsoft.com/en-us/library/bb510680.aspx
sachin10d
20-Sep-11 7:14am
View
Change your database Compatibility level to higher version
right click on database>>properties>>Options>>Compatibility level change the compatibility
sachin10d
19-Sep-11 13:22pm
View
can you please tell the error.
sachin10d
19-Sep-11 13:21pm
View
HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause.
A HAVING clause is like a WHERE clause, but applies only to groups as a whole, whereas the WHERE clause applies to individual rows. A query can contain both a WHERE clause and a HAVING clause. The WHERE clause is applied first to the individual rows in the tables . Only the rows that meet the conditions in the WHERE clause are grouped. The HAVING clause is then applied to the rows in the result set. Only the groups that meet the HAVING conditions appear in the query output. You can apply a HAVING clause only to columns that also appear in the GROUP BY clause or in an aggregate function
sachin10d
19-Sep-11 12:50pm
View
insert into TestDestination.dbo.Employee (Column1, Column2, ...)
select (Column1, Column2, ...) from TestSource.dbo.Employee
Where Id > 10 and Id < 20
sachin10d
19-Sep-11 12:49pm
View
specify all the columns name comma separate and eliminate the Identity column
in both insert and select part
sachin10d
19-Sep-11 12:30pm
View
Dictionary should be used instead of hashtable.
sachin10d
16-Sep-11 6:53am
View
nice article digimanus!
sachin10d
16-Sep-11 6:38am
View
We can copy database to new database and save that in given location.
but we cannot give the same name to the new database.
sachin10d
12-Sep-11 23:49pm
View
change the strSql statment as
set @strSql = ' declare @sum int '
set @strSql = @strSql + 'SELECT @SUM = SUM(table1.id) FROM table1 '
sachin10d
12-Sep-11 7:52am
View
make connection using master database. Then only restore will work
sachin10d
12-Sep-11 6:17am
View
Can you give the error details.
sachin10d
21-Jun-11 3:56am
View
Deleted
Reason for my vote of 1
Could be problem when finding word in string
sachin10d
13-Jun-11 4:06am
View
Deleted
Reason for my vote of 5
Good framework wise trick
Show More