How to save ONLY month and year in MSAccess database

Israel

11y1kLearn iOS Programming

Hi!

I need to save in my database from my datetimepicker only the MONTH and YEAR. But its doesnt works.

Then see what I do and help me to resolv my problem please:

conn = new OleDbConnection(connstr);

comm = new OleDbCommand();

conn.Open();

OleDbParameter name = new OleDbParameter("@name", SqlDbType.VarChar);

OleDbParameter monthyear = new OleDbParameter("@monthyear", SqlDbType.VarChar);

comm.Parameters.Add(name);

comm.Parameters.Add(monthyear);

name.Value = txtName.Text;

monthyear .Value = txtMonthYear.Text;

comm.Connection = conn;

comm.CommandText = "insert into DBTest ([name],[monthyear]) values(@name,@monthyear)";

if(MessageBox.Show("Are you sure to save?","Windows for Save",MessageBoxButtons.YesNo) == DialogResult.Yes)

{

try

{

comm.ExecuteNonQuery();

MessageBox.Show("Saved...");

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

finally

{

conn.Close();

}

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeesh Menoth11y ago
Accepted answer
Hi,

Ref this :
1) http://www.functionx.com/access/Lesson22.htm

2) http://answers.microsoft.com/en-us/office/forum/office_2010-access/enter-and-display-a-date-as-monthyear/99960760-1a04-4d62-879a-c6c34ac714a7?auth=1
0
Rajeesh Menoth11y ago
Hi,

Welcome Israel bro :)
0
Israel11y ago
@Rajeesh Many thanx!
0
Israel11y ago
what I need to?
The way I dont want is this (in red):

Name | MonthYear
Opra | 01 Jul 2014
Shilo | 05 Agu 2014
Bran | 16 Jan 2015
The way I want is like this (in blue):

Name | MonthYear
Opra | Jul 2014
Shilo | Agu 2014
Bran | Jan 2015

When I save its appear as full date (for instance, 05-08-2015) . Its should appear ONLY like this Agu 2015. I already wrote the codes!
0
Upendra Pratap Shahi11y ago
you have send monthyear and name parameter,

You have send two parameter and want to save this.
0
Upendra Pratap Shahi11y ago
Share your data which you want to save here.
0
Israel11y ago
@Upendra Did you understand well my question. I need to save in my database only the month and year
0
Upendra Pratap Shahi11y ago
Hello Use Like this-

public static void InsertFileLog(string fileName,DateTime crDate,DateTime modDate,DateTime uploadTime)

{

OleDbConnection conn = GetConnection();

string strQuery1 = @"insert into FileLog(FileName,CreateDate,ModifiedDate,UploadedOn) values('" + fileName + "','"+crDate+"','"+modDate+"','"+uploadTime+"')";

OleDbCommand olCommond1 = new OleDbCommand(strQuery1, conn);

olCommond1.ExecuteNonQuery();

conn.Close();

}

0