Want to save date using time system not C# tool date

Israel

Hi!

All these codes work very well. I put all here to give you a good understanding to help me.

I have a table I can save safelly without problem. But I would like to learn how can I among these code to save my current time system directly in the column of my sql table (time of my computer). In other word, if its will mess to much in my code then which value can I for the date.

private void btnSave_Facturacao_Click(object sender, EventArgs e)

{

conn = new SqlConnection(connstr);

comm = new SqlCommand();

conn.Open();

SqlParameter S = new SqlParameter("@S", SqlDbType.NChar);

SqlParameter data = new SqlParameter("@dataFact", SqlDbType.Date);// here

SqlParameter nomecliente = new SqlParameter("@nc", SqlDbType.NChar);

SqlParameter designacao = new SqlParameter("@desig", SqlDbType.NChar);

SqlParameter codigo = new SqlParameter("@cod", SqlDbType.VarChar);

SqlParameter quantidade = new SqlParameter("@quant", SqlDbType.NChar);

SqlParameter precocompra = new SqlParameter("@precocompra", SqlDbType.NChar);

SqlParameter precosaida = new SqlParameter("@precosaida", SqlDbType.NChar);

SqlParameter total = new SqlParameter("@total", SqlDbType.NChar);

SqlParameter lucrovenda = new SqlParameter("@lucrovenda", SqlDbType.NChar);

SqlParameter troco = new SqlParameter("@troco", SqlDbType.NChar);

SqlParameter utilizador = new SqlParameter("@utilizador", SqlDbType.NChar);

comm.Parameters.Add(S);

comm.Parameters.Add(data);//here

comm.Parameters.Add(nomecliente);

comm.Parameters.Add(designacao);

comm.Parameters.Add(codigo);

comm.Parameters.Add(quantidade);

comm.Parameters.Add(precocompra);

comm.Parameters.Add(precosaida);

comm.Parameters.Add(total);

comm.Parameters.Add(lucrovenda);

comm.Parameters.Add(troco);

comm.Parameters.Add(utilizador);

S.Value = "*";

data.Value = dateTimePicker1.Value;//here

nomecliente.Value = nomeClienteFactu.Text;

designacao.Value = artigoFactu.Text;

codigo.Value = leituraCodFactu.Text;

quantidade.Value = quantidadeFactu.Text;

precocompra.Value = precocompraFactu.Text;

precosaida.Value = precosaidaFactu.Text;

total.Value = totalFactu.Text;

lucrovenda.Value = lucrovendaFactu.Text;

troco.Value = trocos.Text;

utilizador.Value = utilizadores.Text;

//total.Value = totalFactu.Text;

//lucrovenda.Value =

//troco

//utilizador

comm.Connection = conn;

comm.CommandText = "insert into fact values(@s,@datafact,@nc,@desig,@cod,@quant,@precocompra,@precosaida,@total,@lucrovenda,@troco,@utilizador)";

try

{

comm.ExecuteNonQuery();

MessageBox.Show("saved");

nomeClienteFactu.Clear();

/*artigoFactu.Text = "";

quantidadeFactu.Clear();

precoFactu.Clear();

totalFactu.Clear();*/

}

catch (Exception)

{

MessageBox.Show("Not saved");

}

finally

{

conn.Close();

}

private void Facturacao_Load(object sender, EventArgs e)

{

}

8 Replies

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

Vulpes12y ago
Accepted answer
I'm not sure whether you're saying your latest code executed successfully or not but, if it didn't, one thing I've noticed is that the Data column is of type DateTime in the database.

This corresponds to SqlDbType.DateTime, not SqlDbType.Date, as it includes a time component as well.
Israel12y ago
Thanx Vulpes, I have been little bit stupid without realize it. Very small think can make many nights without resolving nothing. Many thanx.
Israel12y ago
I am not sure what happen? But I do recreate another table with only one date column to see where the problem. But without success (very strange): Table name: "Test"
]Table structure:
Column name: Data Date type: Datetime

private void button2_Click(object sender, EventArgs e)
{
{
conn = new SqlConnection(connstr);
comm = new SqlCommand();
conn.Open();

SqlParameter Data = new SqlParameter("@dataFact", SqlDbType.Date);

comm.Parameters.Add(data);

data.Value = DateTime.Today;

comm.Connection = conn;

comm.CommandText = "insert into test values(@dataFact)";

try
{
comm.ExecuteNonQuery();
MessageBox.Show("saved");

}
catch (Exception)
{
MessageBox.Show("Not saved");
}
finally
{
conn.Close();

}
}
}
}
}
Vulpes12y ago
Sorry but I don't understand what you mean.

You can set the parameter value to any date you like and it will be inserted into the database with the values of the other columns.

If you want to read the date from a textbox, rather than a datetimepicker, in a robust way, you can do:

DateTime dt;
bool isValid = DateTime.TryParse(dataFactu.Text, out dt);

if(isValid)
{
dt = dt.Date;
}
else
{
dt = DateTime.Today; // default date say
}

data.Value = dt;
Israel12y ago
Vulpes, did you see well that line of code. When I put dateTimePicker1 means its on my "form". Then I want to use it for saving on my database. Now with DateTime.Today; how I will redirect it to my database? I cant!
Vulpes12y ago
If you want to save the current date in the database, then change this line:

data.Value = dateTimePicker1.Value;

to this:

data.Value = DateTime.Today;

The other two lines should be OK.
Israel12y ago
Hi! Thanx to give me this site. But its make me a little bit "confuse". Please there is a way to correct my code where colored in red. Because I need to learn how to save date in table. Which value can I use? Thanx, Israel.
Nilanka Dharmadasa12y ago
Hi Israel,

You can use 'Datetime' , 'time', etc.. based on your requirement. For more details check this.
http://technet.microsoft.com/en-us/library/ms186724.aspx

Convert the time to GMT before saving and then convert back to your local time zone when reading.

Or you can use 'Datetimeoffset' type to save your time. Using that type, you can save both time zone information and the time.