how to fetch all rows inserted in datagridview in c#
I fetch maxid row to view in datagridview using the following code
public static DataTable GetMaximpID()
{
string strconn = AlShehabi.Properties.Settings.Default.NewSalariesDBConnectionString;
SqlConnection conn = new SqlConnection(strconn);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand command = new SqlCommand("select * from Imprests where Imprest_ID= (Select MAX(imprest_ID) FROM Imprests)", conn);
SqlDataAdapter adpater = new SqlDataAdapter(command);
DataTable dt = new DataTable();
try
{
adpater.Fill(dt);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
conn.Close();
return dt;
}
but I want to fetch all rows inserted and view in datagridview
for example if user insert 4 rows I want to view them in datagridview after insert them
using insertbutton_click