C#

lankaudaranga wrote:

this code work access databse but sql server 3.5 compact server notwork

lankaudaranga wrote:

reader.Read();
if (reader.HasRows == true)

if(reader.Read()) // Doesn't require HasRows
{
    // your code here
}

if (reader.Read())
{
    // There is data - do something
}
else
{
    // There is no data - do something else.
}

foreach (Form child in this.MdiChildren)
{
   if (child is ChildForm1)
   {
      ChildForm1 theChild = (ChildForm1)child;
      MessageBox.Show(theChild.SomeProperty);
      theChild.DoSomething();
   }
}

private MdiClient m_MdiClient;
public MdiClient MdiClient
{
    get
    {
        if (m_MdiClient != null)
            return m_MdiClient;
        foreach (Control control in Controls)
        {
            if (control is MdiClient)
            {
                m_MdiClient = (MdiClient)control;
                return m_MdiClient;
            }
        }
        throw new Exception("MdiClient control could not be found");
    }
}

// Set up the DataGridView.
            dataGridView1.Dock = DockStyle.Fill;

            // Automatically generate the DataGridView columns.
            dataGridView1.AutoGenerateColumns = true;

            // Set up the data source.
            bindingSource1.DataSource = GetData("Select * From Products");
            dataGridView1.DataSource = bindingSource1;

            // Automatically resize the visible rows.
            dataGridView1.AutoSizeRowsMode =
                DataGridViewAutoSizeRowsMode.DisplayedCellsExceptHeaders;

            // Set the DataGridView control's border.
            dataGridView1.BorderStyle = BorderStyle.Fixed3D;

            // Put the cells in edit mode when user enters them.
            dataGridView1.EditMode = DataGridViewEditMode.EditOnEnter;