how to insert datetime now and select the data that has been inserted on that day

Question

0.00/5 (No votes)

See more:

hi guys,

can you help me on this: i want to insert data into sql database and then i want to bind that latest data into gridview.latest means data that has been inserted in 1 process.not the last row in table.

so i come out with the idea insert a datetime.now into table sql database.and then i want to display the data that has been inserted.but i still got no solution.pls someone help me...

C#

protected void Button3_Click(object sender, EventArgs e)
    {
        SqlConnection cn0 = new SqlConnection(connectionString);
        cn0.Open(); 
        string l = "insert into approval (name_item, quantity, stock_last,name,staff_no,date) values (@name_item, @quantity, @stock_last, @name, @staff_no, @date)";
        SqlCommand c = new SqlCommand(l, cn0);

        //TextBox8.Text = dt.ToString();

        c.Parameters.Add("@name_item", SqlDbType.VarChar).Value = ddl1.SelectedItem.Text.Trim();
        c.Parameters.Add("@quantity", SqlDbType.Int).Value = TextBox7.Text.Trim();
        c.Parameters.Add("@stock_last", SqlDbType.Int).Value = kuantiti;
        c.Parameters.Add("@name", SqlDbType.VarChar,50).Value = TextBox3.Text.Trim();
        c.Parameters.Add("@staff_no", SqlDbType.Int).Value = TextBox2.Text.Trim();
        c.Parameters.Add("@date", SqlDbType.DateTime).Value = DateTime.Now;// = TextBox8.Text;// = TextBox8.Text;

        cd.ExecuteNonQuery();
        c.ExecuteNonQuery();
    }

protected void Button5_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(connectionString);
        conn.Open();

        DateTime dt = DateTime.Now;
        SqlConnection con0 = new SqlConnection(connectionString);
        string s = "select convert(varchar(11), date, 103)as date from approval where staff_no = '" + TextBox2.Text + "'";
        SqlCommand cm = new SqlCommand(s,conn);
        //cm.CommandText = 
        //cm.Connection = con0;
        //con0.Open();
        string name = ((string)cm.ExecuteScalar());
        TextBox8.Text = ((string)cm.ExecuteScalar());
        SqlDataAdapter sql = new SqlDataAdapter(s, conn);
        DataSet ds = new DataSet();

        sql.Fill(ds, "approval");
        GridView1.DataSource = ds.Tables["approval"].DefaultView;
        GridView1.DataBind();
    }

thanx in advance
musiw.

Posted 24-Jul-12 20:48pm

musiw

Updated 24-Jul-12 20:51pm

Prasad_Kulkarni

v2

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AshishChaudha · Answer 1 · 2012-07-24T22:26:00

Solution 3

Make a new field in your table named like CreatedDate of DateTime datatype and set its default value to getdate().

Posted 24-Jul-12 22:26pm

AshishChaudha

Updated 24-Jul-12 22:27pm

v2

Sebastian T Xavier · Answer 2 · 2012-07-24T21:03:00

Solution 1

Hi,
Think about adding a new column called "inserted_Order" in your table. Then increment that column value in each insert process. Then you will be able to retrieve record set you have inserted in each process.

Regards
Sebastian

Posted 24-Jul-12 21:03pm

Sebastian T Xavier

Comments

musiw 25-Jul-12 4:01am

i dont get it.can u explain how to implement it?

Aman Bhullar · Answer 3 · 2012-07-24T22:18:00

Solution 2

if your data type of date column in database is datetime then u can also use the getdate SQL function to insert date.

Try:
insert into approval (name_item, quantity, stock_last,name,staff_no,date) values (@name_item, @quantity, @stock_last, @name, @staff_no, getdate())

Posted 24-Jul-12 22:18pm

Aman Bhullar

Muhammad Shahid Farooq · Answer 4 · 2012-07-24T23:09:00

C#

protected void Button3_Click(object sender, EventArgs e)
    {
        SqlConnection cn0 = new SqlConnection(connectionString);
        cn0.Open(); 
        string l = "insert into approval (name_item, quantity, stock_last,name,staff_no,date) values (@name_item, @quantity, @stock_last, @name, @staff_no, getDate())";
        SqlCommand c = new SqlCommand(l, cn0);

        c.Parameters.Add("@name_item", SqlDbType.VarChar).Value = ddl1.SelectedItem.Text.Trim();
        c.Parameters.Add("@quantity", SqlDbType.Int).Value = TextBox7.Text.Trim();
        c.Parameters.Add("@stock_last", SqlDbType.Int).Value = kuantiti;
        c.Parameters.Add("@name", SqlDbType.VarChar,50).Value = TextBox3.Text.Trim();
        c.Parameters.Add("@staff_no", SqlDbType.Int).Value = TextBox2.Text.Trim();
        c.Parameters.Add("@date", SqlDbType.DateTime).Value = DateTime.Now;

        c.ExecuteNonQuery();
    }

    protected void Button5_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(connectionString);
        conn.Open();

        DateTime dt = DateTime.Now;
        SqlConnection con0 = new SqlConnection(connectionString);
        string s = "select convert(varchar(11), getdate(), 103)as date from approval where staff_no = '" + TextBox2.Text + "'";
        SqlCommand cm = new SqlCommand(s,conn);
        string name = ((string)cm.ExecuteScalar());
        TextBox8.Text = ((string)cm.ExecuteScalar());
        SqlDataAdapter sql = new SqlDataAdapter(s, conn);
        DataSet ds = new DataSet();

        sql.Fill(ds, "approval");
        GridView1.DataSource = ds.Tables["approval"].DefaultView;
        GridView1.DataBind();
    }

sandeep nagabhairava · Answer 5 · 2012-07-25T01:15:00

Solution 5

hi musiw
oncetry like this

SQL

string s = "select convert(varchar(11), date, 103)as date from approval where staff_no = '" + TextBox2.Text + "'" and date=max(date);

Thanks&Regards
sandeep

Posted 25-Jul-12 1:15am

sandeep nagabhairava