SqlDataAdapter as Object value?

Question

Hello guys I have got this SqlDataAdapter which finds the highest value:

DataTable dt = new DataTable();             
SqlDataAdapter SDA = new SqlDataAdapter("Select MAX (ID_K) FROM klient", spojeni);
SDA.Fill(dt);


spojeni.Close();

If it selects I need its result add +1 and insert it as object value into this parameter.

prikaz2.Parameters.AddWithValue("@val4", ); // here should be SDA +1

I tried to insert to object value whole SqlDataAdapter but it was nonsense. Is there any way to achieve that?

Thanks in advance

Yes, that is nonsense. What makes you think the SqlDataAdapter is a number? — catfood
– catfood, Commented Jul 17, 2013 at 13:01

Soner Gönül · Accepted Answer · 2013-07-17 12:59:11Z

3

You can use SqlCommand.ExecuteScalar() method for getting this value because;

Executes the query, and returns the first column of the first row in the result set returned by the query.

Since your command returns only maximum value of ID_K column, that is exactly what we want.

SqlCommand command = new SqlCommand("Select MAX (ID_K) FROM klient");
SqlDataAdapter SDA = new SqlDataAdapter(command, spojeni);
int max = (int)command.ExecuteScalar();
prikaz2.Parameters.AddWithValue("@val4", max + 1);

edited Jul 17, 2013 at 12:59

answered Jul 17, 2013 at 12:46

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

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

Comments

Claudio Redi · Accepted Answer · 2013-07-17 12:43:04Z

3

int maxID = (int)comm.ExecuteScalar();
prikaz2.Parameters.AddWithValue("@val4", maxID + 1);

answered Jul 17, 2013 at 12:43

Claudio Redi

68.6k15 gold badges138 silver badges161 bronze badges

Collectives™ on Stack Overflow

SqlDataAdapter as Object value?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related