C#

Priya Prk wrote:

the problem is that if the file is open, then im getting a exception.

conn = new SqlConnection("Data Source=|DataDirectory|TMCDataBase.sd;Persist Security Info=False");

conn = new SqlCeConnection("Data Source=|DataDirectory|TMCDataBase.sd;Persist Security Info=False");

arnold_w wrote:

but the print out says there are zero rows in the table. Why is that?

arnold_w wrote:

I want to obtain other information about rows and cells (such as their locations), how do I do that?

d@nish wrote:

arnold_w wrote:
but the print out says there are zero rows in the table. Why is that?


There has to be some problem with your printing code. Try debug that or post it here.

d@nish wrote:

arnold_w wrote:
I want to obtain other information about rows and cells (such as their locations), how do I do that?


Try using GetCellDisplayRectangle method.

try
{
  Rectangle cellRectangle = dataGridView1.GetCellDisplayRectangle(0, 0, true);
  Console.WriteLine("The cell is located at " + cellRectangle.X + ", " + cellRectangle.Y + ".");
}
catch (ArgumentOutOfRangeException e)
{
  Console.WriteLine("ArgumentOutOfRangeException. Additional info: " + e.Message);
}

arnold_w wrote:

The code is posted here and the printing code is the second row from the end

DataGridView dataGridView2 = new DataGridView();
      DataTable dataTable = new DataTable();
      dataTable.Columns.Add("My Column");
      dataTable.Rows.Add("My Cell Value");
      dataGridView2.DataSource = dataTable;

public Form1()
{
  InitializeComponent();
  this.Load += new EventHandler(Form1_Load);
}


private void Form1_Load(object sender, System.EventArgs e)
{
  DataGridView dataGridView1 = new DataGridView();
  DataTable dataTable = new DataTable();
  dataTable.Columns.Add("My Column");
  dataTable.Rows.Add("My Cell Value");
  dataGridView1.DataSource = dataTable;
  this.Controls.Add(dataGridView1);
  Console.WriteLine("There are " + dataGridView1.Rows.Count + " rows in your table.");
}

d@nish wrote:

1. Get rid of binding source and use this:

DataGridView dataGridView2 = new DataGridView();
DataTable dataTable = new DataTable();
dataTable.Columns.Add("My Column");
dataTable.Rows.Add("My Cell Value");
dataGridView2.DataSource = dataTable;

DataView dv = dataTable.DefaultView;
dv.RowFilter = ...