[ djmrky @ 05.04.2005. 11:31 ] @
Kako se u c#-u moze podesiti sirina kolone u DataGrid-u, ali pri povezivanju sa bazom iz koda, znaci kad iz koda kreiram i konekciju i DataSet i DataAdapter i onda samo namestim odgovarajuci DataSource za zeljeni DataGrid.
Evo parce koda:

OleDbConnection oledbconnection = new OleDbConnection("Provider=Microsoft.Jet OLEDB.4.0;Data Source=.\\Check.mdb");
string sSelectAll = "SELECT * FROM BANKA";
string sSelectNaziv = "SELECT NAZIV FROM BANKA";

OleDbCommand CommandSelectAll = new OleDbCommand();
CommandSelectAll.Connection = oledbconnection;

CommandSelectAll.CommandText = sSelectAll;
OleDbDataAdapter AdapterSelectAll = new OleDbDataAdapter();
AdapterSelectAll.SelectCommand = CommandSelectAll;

OleDbCommand CommandSelectNaziv = new OleDbCommand();
CommandSelectNaziv.Connection = oledbconnection;

CommandSelectNaziv.CommandText = sSelectNaziv;
OleDbDataAdapter AdapterSelectNaziv = new OleDbDataAdapter();
AdapterSelectNaziv.SelectCommand = CommandSelectNaziv;

DataSet ds = new DataSet();

oledbconnection.Open();

AdapterSelectAll.Fill(ds, "Banke");
AdapterSelectNaziv.Fill(ds, "Nazivi");

oledbconnection.Close();

dgBanke.DataSource = ds.Tables["Banke"];
dgNazivBanke.DataSource = ds.Tables["Nazivi"];
--------------------------------------------------

i kako sad da promenim sirine kolona ovog dgBanke kad je on vec popunjen podacima

Hvala
[ sekretar @ 05.04.2005. 12:55 ] @
Recimo ovako:
Kreiraj novi datatablegridstyle
<code>
dataGrid1.DataSource = dataSet;
dataGrid1.DataMember = "ImeTabele";
DataGridTableStyle dgts = new DataGridTableStyle();
dgts.MappingName = "ImeTabele";
dataGrid1.TableStyles.Add(dgts);
//pozivas func za setovanje sirine
SetColWidth(dgts,0,150);
SetColWidth(dgts,1,60);
//.. itd itd
//ovdje ti je primjer sa cim se jo� mo�e� igrati...
dgts.AllowSorting = true;
dgts.BackColor = System.Drawing.Color.Honeydew;
dgts.HeaderBackColor = System.Drawing.Color.LightCyan;
dgts.AlternatingBackColor = System.Drawing.Color.Ivory;
dgts.SelectionBackColor = System.Drawing.Color.LightGreen;
dgts.GridLineColor = System.Drawing.Color.White;
dgts.HeaderBackColor = System.Drawing.Color.LightCyan;
dgts.ForeColor = System.Drawing.Color.Black;
dgts.SelectionForeColor = System.Drawing.Color.Black;
</code>
a evo i func
<code>
public void SetColWidth(DataGridTableStyle tableStyle, int colNum, int width)
{
try
{
tableStyle.GridColumnStyles[colNum].Width = width;
tableStyle.DataGrid.Refresh();
}
catch{}
}
</code>


--
Signature:
(appended at the end of all outgoing messages)
[ djmrky @ 05.04.2005. 14:45 ] @
Zahvaljujem se puno na savrseno brzom odgovoru i sto je najbitnije, savet je pomogao

Dusan