Because I bought my mac pro after June I was entitled for a free update. I downloaded and installed LION like a charm. Every thing working except Xcode. As per Apple developer site, we need a different version for Lion.
Kutty
Because I bought my mac pro after June I was entitled for a free update. I downloaded and installed LION like a charm. Every thing working except Xcode. As per Apple developer site, we need a different version for Lion.
Kutty
The old DataGrid has a great feature, compared to new DatagridView, that it can display maste/detail relational data. We only have to load master table and detail table into a DataSet and set the relationship between them, then set DataGrid's DataSource property to the DataSet and DataMember property to the master table name. The DataGrid displays master table contents with a + sign and once you click the + sign, the relation name appears as a link if you click that the child content will appear. As you notice there is round trip to display the child records and master records. I want the datagrid to display master table records along with child table records INLINE that is: parent row, then beneath that child rows, then the next parent, so on.. Can anybody help me please? I am working on Windows.Forms.DataGrid
Kutty
Instead of where clause use ISNULL(FieldName,'1900-1-1') Good luck
Kutty
I found a solution during my googling. But it is not working in my case, can any body please check this code. this what I found: public partial class Form1 : Form { public static string ConnectionString = "" //your connection string here DataSet DS = new DataSet(); double TotalRows =0; double RowIndex = 1; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { OleDbConnection DBConn = new OleDbConnection(ConnectionString); OleDbDataAdapter DBAdapter = new OleDbDataAdapter(); DBAdapter.SelectCommand = new OleDbCommand("SELECT Count(*) from tblPersons", DBConn); DBConn.Open(); TotalRows = (int)DBAdapter.SelectCommand.ExecuteScalar(); //retrieve the nr. of rows in the DB Table DBConn.Close(); DBAdapter.SelectCommand.CommandText = "SELECT * from tblPersons"; DS.Tables.Add(new DataTable("Customers")); // Add event handler to the row changing event in the dataset DS.Tables["Customers"].RowChanging += new DataRowChangeEventHandler(Form1_RowChanging); DBAdapter.Fill(DS, "Customers"); dataGridView1.DataSource = DS.Tables[0]; } void Form1_RowChanging(object sender, DataRowChangeEventArgs e) { if (e.Action.ToString() == "Add") //check if the action is 'Add' (not 'Commit') { Thread.Sleep(500); progressBar1.Value = (int)Math.Round((double)(RowIndex / TotalRows) * 100); //update the progressbar progressBar1.Refresh(); RowIndex++; //count rows } } } }
Kutty
I want to load data from sql server table to a datagridview using threading and I want to display the loading progress in progressbar. Please help.
Kutty