Show me the last record after saving and on time....

Israel

Hi!

These codes allow me to save without problem.

But what I want to know it's after saving my record. I would like to see the latest record (only one culumn as I specify in my code) appear on my label just AFTER SAVING and ON TIME.

Please have a look:

private void btnGravar_Facturacao_Click(object sender, EventArgs e)

{

conn = new SqlConnection(connstr);

comm = new SqlCommand();

conn.Open();

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

SqlParameter data = new SqlParameter("@datafact", SqlDbType.Date);

comm.Parameters.Add(numberprint);

comm.Parameters.Add(data);

numberprint.Value = lblNumberprint.Text;

data.Value = DateTime.Today;

comm.Connection = conn;

comm.CommandText = "insert into facturacao1 values(@numberprint,@datafact)";

//////////////////////////////////It's here where I try to write the code to show the latest record saving and every time on time//////////////////

string connectionString = @"Data Source=localhost\sqlexpress;Initial Catalog=master;Integrated Security=True";

SqlConnection sqlCon = new SqlConnection(connectionString);

sqlCon.Open();

string commandString = "select * from facturacao1 where numberprint ='" + lblNumberprint.Text + "'";

SqlCommand sqlCmd = new SqlCommand(commandString, sqlCon);

SqlDataReader read = sqlCmd.ExecuteReader();

if (read.HasRows)

{

while (read.Read())

{

lblNumberprint.Text = read["numberprint"].ToString();

}

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////

try

{

comm.ExecuteNonQuery();

MessageBox.Show("Saved");

}

catch (Exception)

{

MessageBox.Show("Not saved");

}

finally

{

conn.Close();

}

12 Replies

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

Vulpes12y ago
Accepted answer
But, if the code's working, you are getting the last saved value of 'numberprint' in the label.

That's what this is doing:

while (read.Read())
{
lblNumberprint.Text = read["numberprint"].ToString();
}

Do you want the 'datafact' column value to be shown as well?
Israel12y ago
Vulpes, let me say THANX please. Its works!
Israel12y ago
ok, let's think together step by step:
1. this line of code works without problem.
2. I just want see the last record of this column appear on this label "lblNumberprint.Text". THAT'S ALL
3. when the last record should appear? Just when after saving.

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

SqlParameter numberprint = new SqlParameter("@numberprint", SqlDbType.NChar);
SqlParameter data = new SqlParameter("@datafact", SqlDbType.Date);
comm.Parameters.Add(numberprint);
comm.Parameters.Add(data);

numberprint.Value = lblNumberprint.Text;
data.Value = DateTime.Today;

comm.Connection = conn;

comm.CommandText = "insert into facturacao1 values(@numberprint,@datafact)";
comm.ExecuteNonQuery();

comm.CommandText = "select * from facturacao1 where numberprint = @numberprint and data = @datafact";
SqlDataReader read = comm.ExecuteReader();
if (read.HasRows)
{
while (read.Read())
{
lblNumberprint.Text = read["numberprint"].ToString();
}

MessageBox.Show("Saved");
}
else
{
MessageBox.Show("Not saved");
}

read.Close();
conn.Close();

}
Vulpes12y ago
Well, without further clarification, I don't think I can improve on what I said in my previous post.

Are you saying that it isn't working?
Israel12y ago
Please I am sturking, Can You help resolving my problem. I need your support. Read me first in what I post. Then you will understand. Otherwise I can explain it in other way.
Israel12y ago
PLEASE, I need help on my preocupation to help also others.
Vulpes12y ago
If you only save a maximum of one record per day, you could change this code:

comm.Parameters.Remove(data);
comm.CommandText = "select * from facturacao1 where numberprint = @numberprint";

to:

comm.CommandText = "select * from facturacao1 where numberprint = @numberprint and data = @data";

which would retrieve the last one saved.

Otherwise, you really need to save both the date and the time to the 'data' column (i.e. DateTime.Now rather than DateTime.Today) and change the column type to datetime2 rather than date.

You can then sort in descending order on this field and select the 'top' 1 to get the latest added.
Israel12y ago
EXACTLY Vulpes! Every times after saving should show ONLY the last record value on this label "numberprint". But on time!!!
Vulpes12y ago
Just to be clear, are you saying that there may be multiple records in the database which have the same value for the numberprint column and you want to retrieve the last one added?
Israel12y ago
yes, yours codes work well! But I need the last record of the column "numberprint" always appearing on the label "lblnumberprint" after saving and on time. I know why Vulpes (don't worry!)
Vulpes12y ago
Well, you could actually reuse the SqlCommand object to check that the record has been saved:

private void btnGravar_Facturacao_Click(object sender, EventArgs e)
{
conn = new SqlConnection(connstr);
comm = new SqlCommand();
conn.Open();
SqlParameter numberprint = new SqlParameter("@numberprint", SqlDbType.NChar);
SqlParameter data = new SqlParameter("@datafact", SqlDbType.Date);
comm.Parameters.Add(numberprint);
comm.Parameters.Add(data);
numberprint.Value = lblNumberprint.Text;
data.Value = DateTime.Today;
comm.Connection = conn;
comm.CommandText = "insert into facturacao1 values(@numberprint,@datafact)";
comm.ExecuteNonQuery();

// now retrieve saved record
comm.Parameters.Remove(data);
comm.CommandText = "select * from facturacao1 where numberprint = @numberprint";
SqlDataReader read = comm.ExecuteReader();
if (read.HasRows)
{
while (read.Read())
{
lblNumberprint.Text = read["numberprint"].ToString();
}

MessageBox.Show("Saved");
}
else
{
MessageBox.Show("Not saved");
}

read.Close();
conn.Close();
}

However, it's not really necessary to check that the record has been saved in this way because the ExecuteNonQuery() method returns the number of rows affected. So if this is more than zero, then the record has been saved.
Israel12y ago
Please I need your help to continue with my project. In this way I will learn more...