Comments by Atyant Srivastava

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.

Comments by Atyant Srivastava (Top 20 by date)