I want only save Month and Year not save date

Accepted answer

You can't store just the month and year with DateTime column in sql server. Better make it varchar.

In C# exctract the month and year from

thanks to all

If you want year month separately

You can check this article, how to working with datetime. You can also dowload code according to your requirement.

https://www.c-sharpcorner.com/UploadFile/mahesh/working-with-datetime-using-C-Sharp/

I don't know it is the correct way but you can Convert your DateTime field into a string variable and store your string value in nvarchar

DateTime.Now.ToString("MM/yyyy");