Details View
evo koda koj sam probao za label
string connectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=Baza;Integrated Security=True";
SqlConnection mySqlConnection=new SqlConnection(connectionString);
string selectString = "SELECT *" + "FROM Oglasi" + "WHERE ID >= '10'";
SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
mySqlCommand.CommandText = selectString;
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
mySqlDataAdapter.SelectCommand = mySqlCommand;
DataSet myDataSet = new DataSet();
mySqlConnection.Open();
string dataTableName = "Oglasi";
mySqlDataAdapter.Fill(myDataSet, dataTableName);
DataTable myDataTable = myDataSet.Tables[dataTableName];
foreach (DataRow myDataRow in myDataTable.Rows)
{
Label1.Text += "Baza" + myDataRow["*"];
}
mySqlConnection.Close();