Question

c#怎么返回所有插入数据库的数据

Answer 1

c#怎么返回所有插入数据库的数据
string str = "Data Source=.;Initial Catalog=data;Integrated Security=True";
SqlConnection conn = new SqlConnection(str);
string sql = "insert into person (Age,Name) output inserted.Id values(20,'name');select @@identity";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
int i=(int)cmd.ExecuteScalar();
conn.close();
MessageBox.Show(i.ToString());