[ Crazy shadow @ 13.05.2008. 18:36 ] @
Evo ja probao da podatke iz baze stavim u label ali ima neka greska.Sad mene zanima kako da ove podatke stavim u 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(); |