thanks i put my question in many forum of programing but i just now my question in janus forum.

my problem resolved my code: [php] private void Form2_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'phonebookDataSet.moshtarakin_hoghoghi' table. You can move, or remove it, as needed. this.moshtarakin_hoghoghiTableAdapter.Fill(this.phonebookDataSet.moshtarakin_hoghoghi); SqlConnection ConSub = new SqlConnection("Data Source=.;Initial Catalog=phonebook;Integrated Security=True"); ConSub.Open(); SqlDataAdapter Adapter = new SqlDataAdapter("Select * from State", ConSub); DataTable State = new DataTable(); Adapter.Fill(State); multiColumnCombo1.DataSource = State; Adapter.SelectCommand.Connection = ConSub; Adapter.SelectCommand.CommandText = "Select * from StateCity where State_Id='" + Convert.ToInt32(multiColumnCombo1.Value.ToString()) + "'"; DataTable StateCity = new DataTable(); Adapter.Fill(StateCity); multiColumnCombo2.DataSource = StateCity; Adapter.SelectCommand.Connection = ConSub; Adapter.SelectCommand.CommandText = "Select * from groh"; DataTable groh = new DataTable(); Adapter.Fill(groh); multiColumnCombo3.DataSource = groh; Adapter.SelectCommand.Connection = ConSub; Adapter.SelectCommand.CommandText = "Select * from activity where code_groh='" + Convert.ToInt32(multiColumnCombo3.Value.ToString()) + "'"; DataTable activity = new DataTable(); Adapter.Fill(activity); multiColumnCombo4.DataSource = activity; } private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) { moshtarakinhoghoghiBindingSource.AddNew(); if (phonebookDataSet.moshtarakin_hoghoghi.Compute("max(SysCode)+1", null).ToString() != null) editBox1.Text = phonebookDataSet.moshtarakin_hoghoghi.Compute("max(SysCode)+1", null).ToString(); else editBox1.Text = 1.ToString(); editBox3.Text = ""; editBox2.Text = ""; editBox4.Text = ""; multiColumnCombo1.Text = ""; multiColumnCombo2.Text = ""; multiColumnCombo3.Text = ""; multiColumnCombo4.Text = ""; uiComboBox1.Text = ""; } private void multiColumnCombo1_TextChanged(object sender, EventArgs e) {

please help me. i am wating guide for solve problem. best regards

i have one table with 3 column=code,name,code_b and in form i have a bindingnavigator that addnewitem=none and bindingsource=fatemebinding and in gridex datasourc=fatemebinding and in gridex allownew=addnew and rowheader=true and headercontent =rowposition and in griddesignert click in createroottable and retrive table and then column table ceated and then code envirement newiconbinding: [php] try { fatemeBindingSource.AddNew(); codmax = Convert.ToInt32(fatemeTableAdapter.maxcode()); codmax = codmax + 1; gridEX1.CurrentRow.Cells["code"].Value = codmax; ((DataRowView)fatemeBindingSource.Current).Row["code"] = codmax; } catch { MessageBox.Show("لطفا اطلاعات را وارد کنید"); } [/php] and save iconbindingnavator: [php] private void toolStripButton1_Click(object sender, EventArgs e) { fatemeBindingSource.EndEdit(); fatemeTableAdapter.Update(this.baziDataSet1.fateme); } [/php] but in run name and code_b value to be null how to asign data column please help me

that value methoad max code= SELECT ISNULL(MAX(code),0) AS ID FROM fateme that in dataset table can not show record added in grid and how record added in grid i have in selected record i should be in find row of grid record to be add but i dont. pleeeeeeeeeeese help meeeeeeeeeeee

very thanks for guides.

thanks for guide i will looking component that control custom image that propertis hover ,over click color and ,... , and that espical efect .i was download graphic32 but i have n't control . i want looking component that control in tools .for example tms component have control dbgid . i will make a button custom that is enable that have one effect and when disabled another effect .what this do ? please help me best regards

thanks for your guides

thanks for guide i am understand that i dont might transfer in offline. i am need how to transfer data bulk in file in c#? very very thanks for guide . i am need example code for this do. please frther guides me. best regards

very thanks for your help i will study your link best regards