16,021,181 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 Visual Basic questions
View Javascript 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 Atyant Srivastava (Top 20 by date)
Atyant Srivastava
21-Aug-14 4:58am
View
First understand what your formula is doing in real time, and build your logic accordingly.
Atyant Srivastava
9-Aug-14 0:16am
View
your code is working fine at my end, please paste the snapshot of the error.
Are you entering some string in the textbox resultTextbox.
Or you can check the resultTextbox.Text value whether it is null or blank before converting it into decimal.
Atyant Srivastava
22-Jul-14 13:46pm
View
Your question is not clear and instead of selecting several no. of times you can do like this:
select @FAKTLEVNR=FAKTLEVNR ,
@FAKTNR=FAKTNR ,
@FAKTDATO=FAKTDATO ,
@FAKT_BEL_TOTAL=FAKT_BEL_TOTAL ,
@URN_NO=URN_NO ,
@Order_No=Order_No ,
@Dessin_No=Dessin_No ,
@Reason=Reason ,
@Variance_Amount=Variance_Amount ,
@EDI_LAGERNR=EDI_LAGERNR ,
@PRISRET_ART=PRISRET_ART ,
@AFST_ART=AFST_ART ,
@STATUS_DATO=STATUS_DATO ,
@STATUS=STATUS ,
@DEVIATION_RECEIVED=DEVIATION_RECEIVED ,
@SPLIT_ORDER=SPLIT_ORDER ,
@Email_ID=Email_ID ,
@RETURN_ORDER=RETURN_ORDER ,
@RESPONSE_RECEIVED=RESPONSE_RECEIVED ,
@Email_ID=Email_ID ,
@RESPONSIBILITY=RESPONSIBILITY ,
@KREDITDAGE=KREDITDAGE ,
@OPR_ID_DATO=OPR_ID_DATO ,
@DUE_DATE=DUE_DATE ,
@AGEING_DUE_DATE=[AGEING(DUE_DATE)] ,
@LAST_SYSTEM_DATE=LAST_SYSTEM_DATE ,
@AGEING_LAST_DATE=[AGEING(LAST_DATE)] ,
@AUTOID = AUTOID
from inserted
Atyant Srivastava
21-Jul-14 7:18am
View
you cant store in datetime as it will have default value.
Atyant Srivastava
21-Jul-14 0:17am
View
Dave!! Coolest reply...
Atyant Srivastava
21-Jul-14 0:11am
View
hi, what you are passing in @vYEAR, please trying removing YearNo IN (['+@vYEAR+'])) to
YearNo IN ('+@vYEAR+'), i hope you are using comma in the input as i have suggested above, please make sure SET @Year = '[2008],[2009],[2010],[2011],[2012],[2013],[2014],[2015],[2016],[2017],[2018],[2019],[2020]' goes like this only.
Atyant Srivastava
18-Jul-14 8:14am
View
Please use debugger to debug the same. For where exactly it is throwing error.
First of all your dataset s1 does not have any table named Customer as per your code.
Atyant Srivastava
18-Jul-14 1:17am
View
you can call the same way you have called the above sp.
string spName = "spupdateItem";
string spNameInsert = "spinsertitem";
DbCommand dbCommandInsert = db.GetStoredProcCommand(spNameInsert);
DbCommand dbCommand = db.GetStoredProcCommand(spName);
//add parameters
db.ExecuteScalar(dbCommandInsert );
db.ExecuteScalar(dbCommand);
Atyant Srivastava
18-Jul-14 1:12am
View
As suggested by Nirav you can call above method in your page load event(or whatever event you wants to call it). Save the data in some collection and then fill the appropriate controls with the same.
Atyant Srivastava
17-Jul-14 6:13am
View
you can do this logic before binding your DataGridView, then bind the result set with DataGridView
Atyant Srivastava
16-Jul-14 4:48am
View
hi, but here also i am using a single table only, there is no second table involved.
CROSS APPLY is used to join table and function. Here alias B is representing your function.
Atyant Srivastava
9-Jul-14 13:26pm
View
change the datatype to character so it will save the desired value, but in that case you have to do the conversion in case on it is required for calculation.
Atyant Srivastava
9-Jul-14 0:31am
View
variables defined is just for reference purpose please use the variable length accordingly.
As you asked in your question this is the way you can do it dynamically. Hope this helps!!
Please accept as Solution if solves the Purpose.
Atyant Srivastava
7-Jul-14 13:59pm
View
It is due to the TAB index,you might have AutoCheck set to True, simply put lowest TAB index to some other control and your radio button would not be selected by default.
This is just the another way.
Atyant Srivastava
5-Jul-14 2:38am
View
Please check whether your Sql Server agent is running or not.
command for the same is xp_servicecontrol 'querystate', 'SQLSERVERAGENT'
Atyant Srivastava
5-Jul-14 2:16am
View
i suppose this will work for dates only not in the case of integer as mark could be a integer field not a date field.
Atyant Srivastava
5-Jul-14 0:50am
View
Please check what is the final query getting generated from the above code through quick watch and copy that query to sql and see whether it is running. you will get the issue.
Also just want to know what value you label.text is having?
Atyant Srivastava
5-Jul-14 0:40am
View
Use integer value and increment it for each line, once done store the last value and next time get that value to start with. You need to store the last generated value.
Atyant Srivastava
5-Jul-14 0:33am
View
Please paste your full code. You must be calling the above code from somewhere or mayb consuming it directly check whether it is in any kind of loop.
Atyant Srivastava
4-Jul-14 0:24am
View
From where you are calling the code. Please check whether you are not calling it in loop.
Show More