From sql datatable to string variable

Question

I have a SQL Server Express database with tables

I use this code to store into a table

SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=E:\Company Management System\DBConn.mdf;Integrated Security=True;User Instance=True;");
con.Open();

SqlCommand cmd = new SqlCommand("INSERT INTO [GATE Activity] (activity, date)VALUES ('" +"Closed" + "','" + dateTimePicker1.Value.ToString("dd/MM/yyyy hh:mm:ss tt") + "')", con);

cmd.ExecuteNonQuery();

con.Close();

but now I need to do the exact opposite. I have a table called PASSWORDS with the first column called password

I want to copy the value from the last row into a string in C# called pass from example

Please tell me you're not storing passwords in clear text in your database!! — marc_s
– marc_s, Commented Sep 28, 2014 at 18:17

Arindam Nayak · Accepted Answer · 2014-09-28 17:20:47Z

3

You can do this. Here is my solution, provided you have a primary key in Password table with int or identity or any field to recognize the order of record, identity is handy one, or some other column like createddate.

  SqlCommand cmd = new SqlCommand(" select top 1 password from [PASSWORDS] order by <ID> desc", con);
  SqlDataReader sdr = cmd.ExecuteReader();
  string last_pass = sdr["password"].ToString();
  if (!sdr.IsClosed) sdr.Close();

Here is the field that i was referring earlier.

edited Sep 28, 2014 at 17:20

answered Sep 28, 2014 at 17:09

Arindam Nayak

7,4924 gold badges36 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

15 Comments

Majid M. Alzariey Over a year ago

is this the way to use it coz im getting alot of errors here SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=E:\Company Management System\DBConn.mdf;Integrated Security=True;User Instance=True;"); con.Open(); SqlCommand cmd = new SqlCommand(" select top 1 password from [PASSWORDS] order by <ID> dec", con); SqlDataReader sdr = cmd.ExecuteReader(); string last_pass = sdr["password"].ToString(); if (!sdr.IsClosed) sdr.Close(); con.Close();

Arindam Nayak Over a year ago

What are errors you are getting?, Please replace <ID> with your primary key first, Right way, is to put Connection string in Config. And then write stored proc to execute DB calls.Then put all these codes DB access layer.

Majid M. Alzariey Over a year ago

Error 5 Invalid token '(' in class, struct, or interface member declaration E:\Company Management System\Form2.cs 26 33 Company Management System

Majid M. Alzariey Over a year ago

sorry i forgot to ask what is <ID> key

Arindam Nayak Over a year ago

I had told you that it should be primary key of PASSWORDS table.

|

Collectives™ on Stack Overflow

From sql datatable to string variable

1 Answer 1

15 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

15 Comments

Your Answer

Sign up or log in

Post as a guest

Related