Comments by ibrahim maher

ibrahim maher 10-May-18 3:36am View

Thanks for reply
answer the three questions :
1- yes the treeview deeply nested
2- yes
3-no
note : I Have use a dataSet object to relate between parent and child to fill the tree by using Account Code Field like :

dsTemp.Relations.Add("TempRepation", dtTemp.Columns[fldMainCode], dtTemp.Columns[fldSubCode])

and so I can't fill tree by Name Field

ibrahim maher 9-May-18 8:01am View

thank for reply

I want to sort(ascending order) child nodes after expand any Parent node because i want to sort all tree without root level

note : when the tree build-ed by data table (SQL String) I used an order by Code filed and so the tree appear now sorted by Code not by name but now i want to showing it sorted by name after expand any level (expand Event)

best regrades

ibrahim maher 6-Nov-17 1:31am View

thank you
I want a method can read and modify the text property for all controls or Objects in Form and I will Complete any other work

note : I am Visual basic 6 Developer with SQLServer database since 1998

best regards

ibrahim maher 5-Nov-17 7:52am View

thank for u effort
and i wait to show me the method

ibrahim maher 5-Nov-17 2:22am View

thank u

1- winforms

2- I have a SQLServer database Named Application_Caption already exist includes table named chartofcaption include data to all control in application forms like this :

MainCode parentcode ControlNameToUser ControlNameInForm
1 NULL Financial App NULL
11 1 Invoice NULL
111 11 Forms NULL
1111 111 Main Form frmMain
11111 1111 Code Form navAppCode
11112 1111 Basic Data navBasicDataContract
11113 1111 app setting navRepareDeduction

and i want to handle the text property for all control in the form to be able update it by previous data table

best regards

ibrahim maher 4-Nov-17 10:43am View

thank u

* my application is Windows application

* I have a Data Table save all application Caption Strutted by application and the forms and controls like :
-Accounting application code=1 and caption is "Account"
-Main Form code= 11 , Caption "Main Account Form" and ControlName ="frmMainAccount"
-save Button in this from Code=111 Caption "Save Trans asction " and ControlName ="btnSave" and so on

I want make a Class to read from the object on the form and change the text or caption property for the specified object dependence on the control name according in the data table

Node : some control on the form have a Chile object like datagrid have Columns

best regards

ibrahim maher 14-Sep-17 17:14pm View

where the Solution u are repeated the Question

ibrahim maher 13-Sep-17 11:08am View

thank fro help
the result appear true

ibrahim maher 6-Sep-17 15:51pm View

thank for help
I Moifay my code as the Following :

public class DataManager
{
public bool SelectFromTable( SqlConnection cnn, string SQLString, DataSet ds, string DataTabelName,params object[] Paramter)
{

SqlCommand command = new SqlCommand();
command.Connection = cnn;

int i = 0;
string[] ParameterName=new string[Paramter.Length];

if (Paramter.Length != 0)
{
foreach (string par in Paramter)
{
string Name = "@p" + i;
ParameterName[i] = Name;
command.Parameters.AddWithValue(Name, par);
i++;
}

SQLString = string.Format(CultureInfo.InvariantCulture, SQLString, ParameterName);
}

command.CommandText = "Select " + SQLString;

SqlDataAdapter da = new SqlDataAdapter(command);

da.Fill(ds, DataTabelName);

if (ds.Tables[DataTabelName].DefaultView.Count == 0)
return false;
else
return true;

}

it's good and succeed

but I don't understand the meaning of Statment:

SQLString = string.Format(CultureInfo.InvariantCulture, SQLString, ParameterName);
-spacific CultureInfo.InvariantCulture-

ibrahim maher 5-Sep-17 11:10am View

this is my code when passing a parameter
private void btnOpenTable_Click(object sender, EventArgs e)
{

string sqlString;

DataTable dt = new DataTable();
sqlString = "name,MainCode from banna.dbo.chartofaccounts where maincode like '1%' and db_confirm<>'=' order by MainCode";

if (vDataManager.SelectFromTable(ref errMeaage, cnMain, sqlString, ds, "T"))
{
dt = ds.Tables["T"];
textBox1.Text = dt.Rows[0]["name"].ToString();
dataGridView1.DataSource = dt;

}
else
{
if (errMeaage != null) { MessageBox.Show(errMeaage); } else { errMeaage = null; }
}

}

ibrahim maher 5-Sep-17 11:01am View

thank for help...
I Have 2 questions?
1- if I convert the method to void method how come I Know the Select statement returns a data or not?
2- I checked the error when running the method in main class if I made a Class to receive the error must run this class after the main class?

Comments by ibrahim maher (Top 11 by date)