Vezes tvoj kombo box za tabelu baze podataka recimo

cboMesta.DataSource = tvojDataSet.Tables["nekatabela"];
cboMesta.ValueMember=tvojDataSet.Tables["nekatabela"].columns[0];
cboMesta.DisplayMember = tvojDataSet.Tables["nekatabela"].columns[1];

Tako nekako
poz

System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("select * from neka_tabela", connectionString);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);

foreach(DataRow dr in ds.Tables["neka_tabela"])
{
DropDownList1.Items.Add (new ListItem(dr["ime_Grad"],dr["ime_IdGrad"]));//prva kolona je ime, a druga vrijednost
}

i tako...

_{[Ovu poruku je menjao ntadic dana 01.12.2005. u 12:40 GMT+1]}

Ok radi ali sada imam sledeci problem imam proceduru koja se kaci na bazu i vadi podatke iz nje i stavlja u datagrid na osnovu odablane kategorije, ali ne radi!


public void dbConnect(string sqlTemp)
{
// connect to Access database
string accessPath = Application.StartupPath.ToString() + "/data.mdb";
string connectionString = "provider=Microsoft.JET.OLEDB.4.0; " + "data source = " + accessPath;

string commandString = "Select first_name, middle_name, last_name, phone1, mobile, e_mail, url, address, country from contact where id_groups ="+ sqlTemp+"";

OleDbDataAdapter DataAdapter = new OleDbDataAdapter(commandString, connectionString);
DataSet DataSet = new DataSet();
DataAdapter.Fill(DataSet,"contact");
DataTable dataTable = DataSet.Tables[0];
dataGrid.SetDataBinding(DataSet,"contact");
}


private void cmbBoxGroups_SelectedIndexChanged(object sender, System.EventArgs e)
{
dbConnect(this.cmbBoxGroups.SelectedValue.ToString());
}

trebalo bi da kada se iz comboboxa selektuje neka grupa da se rifresuje datagrid sa novim podacima.
Sto ovo ne radi?

Ja sam imao slican problem
probaj da odradis
DataAdapter.Update(dataSet,NameOfTable);

I pozoves ponovo Fill metod da se DataGrid napuni ponovo sa podacima iz baze

hm nece! ako si na ovo mislio.

public void dbConnect(string sqlTemp)
{
// connect to Access database
string accessPath = Application.StartupPath.ToString() + "/data.mdb";
string connectionString = "provider=Microsoft.JET.OLEDB.4.0; " + "data source = " + accessPath;

string commandString = "Select first_name, middle_name, last_name, phone1, mobile, e_mail, url, address, country from contact where id_groups ="+ sqlTemp+"";

OleDbDataAdapter DataAdapter = new OleDbDataAdapter(commandString, connectionString);
DataSet DataSet = new DataSet();

DataAdapter.Update(DataSet,"contact");

DataAdapter.Fill(DataSet,"contact");
DataTable dataTable = DataSet.Tables[0];
dataGrid.SetDataBinding(DataSet,"contact");
}

Umjesto :
DataSet DataSet = new DataSet();


Pokusaj:
DataSet dataSet = new DataSet();
ili
DataSet neki_naziv_razlicit_od_DataSet = new DataSet();

Neće:

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll

...
OleDbCommand command = new OleDbCommand();
OleDbConnection co = new OleDbConnection();
DataSet DS = new DataSet();
co.ConnectionString = connectionString;
command.Connection = co;
command.CommandType = CommandType.Text;
command.CommandText = commandString;
try
{
co.Open();
OleDbDataAdapter DataAdapter = new OleDbDataAdapter(command);
DataAdapter.Fill(DS);
dataGrid.DataSource = DS.Tables[0];
co.Close();
}
catch
{
MessageBox.Show("Neka poruka");
}
...

a kako da se ovo izvede rucno, dakle bez bindovanja ili navodjenja datasource-a.

Dakle kako da iz nekog niza napunim combobox i to svaki element sa dve vrednosti, jedna da bude value(id) a druga display(name)?

prostije receno: kako da za bilo koji item mogu upisati value item-a(u ovom slucaju baze:id)..ovo sam uspeo sa jos jednim nizom koji ima zajednicko sa combobox-om indeksiranje, ali da li moze sve da se "strpa" u kombo/list box kontrolu?

pozdrav

Marko

_{[Ovu poruku je menjao v.marko dana 23.12.2005. u 14:43 GMT+1]}