Comments by DARK__FOXX

DARK__FOXX 4-Sep-20 9:53am View

Thanks for reply. I didn't know that Msgbox doesn't work with ASP.NET,so where can I find some resource about how to display error through server?

I only want to try to make this method work, I have tried them all and tried to follow your advices based on my basic knowledge.

DARK__FOXX 4-Sep-20 6:48am View

(Code moved to question)

DARK__FOXX 3-Sep-20 9:30am View

Can I ask how do I run it to see if it works or not? Thanks

DARK__FOXX 3-Sep-20 9:24am View

EXP_DATE isn't default value , but a value that will be insert with a Textbox.
Table_X have ID_CUSTOMER and COMPANY_NAME that are ANCDCF and ANRGSO of Table_Y, but as you can see they have different names.

DARK__FOXX 3-Sep-20 4:48am View

But this code isn't in a post back inside load_page but in a class that it will call inside a click event

DARK__FOXX 3-Sep-20 2:50am View

Why does my unused variable always return 0 and not the text box value instead?

DARK__FOXX 2-Sep-20 11:13am View

MyParm = cmd.Parameters.Add("@CD_CUSTOMER", SqlDbType.Int)
MyParm.Value = Int32.TryParse(txt_CD_CUSTOMER.Text, unused)
MyParm = cmd.Parameters.Add("@COMPANY_NAME", SqlDbType.NVarChar)
MyParm.Value = lbl_COMPANY_NAME.Text.ToString
MyParm = cmd.Parameters.Add("@EXP_DATE", SqlDbType.Date)
MyParm.Value = DateTime.ParseExact(txt_EXP_DATE.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture)

Tried this solution but doesn't work

DARK__FOXX 2-Sep-20 10:17am View

Deleted

MyParm = cmd.Parameters.Add("@CD_CUSTOMER", SqlDbType.Int)
MyParm.Value = Int32.TryParse(txt_CD_CUSTOMER.Text, unused)
MyParm = cmd.Parameters.Add("@COMPANY_NAME", SqlDbType.NVarChar)
MyParm.Value = lbl_COMPANY_NAME.Text.ToString
MyParm = cmd.Parameters.Add("@EXP_DATE", SqlDbType.Date)
MyParm.Value = DateTime.ParseExact(txt_EXP_DATE.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture)

Tried this solution but doesn't work

DARK__FOXX 2-Sep-20 9:54am View

I'm sorry,I wanted to understand how to try to solve it.
I don't have much knowledge of vb and asp.net

DARK__FOXX 2-Sep-20 9:28am View

I explain better these values are automatically inserted into a form that I created.
Both ID_CUSTOMER and COMPANY name are values from a table that I joined with a new table where the EXP_DATE column is located.
These values are displayed inside a repeater.
The user must enter only the expiration field, if this field is already there, do not enter at the most, modify the date otherwise enter the expiration date.

DARK__FOXX 2-Sep-20 9:00am View

@CD_CUSTOMER int,
@COMPANY_NAME nvarchar(50),
@EXP_DATE date,
@DTINIT DATETIME
AS

IF EXISTS(SELECT 'True' FROM TABLE WHERE CODE_CUSTOMER = @CODE_CUSTOMER)
BEGIN
SELECT 'FIELD EXIST'
END
ELSE
BEGIN
SELECT 'Record ADD'
INSERT INTO TABLE
(
CD_CUSTOMER,
COMPANY_NAME,
EXP_DATE,
DTINIT
)

VALUES
(

@CD_CUSTOMER,
@COMPANY_NAME,
@EXP_DATE,
@DTINIT
)
END

DARK__FOXX 2-Sep-20 8:31am View

I have a parse issue with date value and I don't know if this procedure it's correct

DARK__FOXX 2-Sep-20 2:31am View

Ok I instantiated Repeater by adding New in the declaration and I run the debug mode but I don't understand why my table is not displayed.

So I searched on Web and I saw that a lot of add this method below load Page, but I need to create a class.

Comments by DARK__FOXX (Top 13 by date)