Comments by Pradeep Arthanari

Pradeep Arthanari 8-Jan-18 3:45am View

Check if the firewall ports are opened between your machine and the SMTP server - 118.67.248.63:25

You can check that by doing a telnet <ip> <port> from the source machine.

Pradeep Arthanari 3-Jan-18 2:06am View

I would suggest you to use one common check box instead of radio button to select/unselect. you can try the below code for that:

private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
for (int i = 0; i < routeNamesListView.Items.Count; i++)
{
if (checkBox1.Checked)
routeNamesListView.Items[i].Checked = true;
else
routeNamesListView.Items[i].Checked = false;
}
}

And enable your checkbox in the page load itself as your listview is checked by default.

checkBox1.Checked = true;

Pradeep Arthanari 3-Jan-18 1:57am View

Try to keep the ListView and radio button check in Sync. I mean check your check box on page load itslef as your listview is checked by default.

t1RadioButton.Checked = true;

Pradeep Arthanari 3-Jan-18 1:28am View

Could you copy your code.

Pradeep Arthanari 3-Jan-18 0:56am View

Pls refer my above code. It has got a radio button to select/deselect all the checkboxes in the list view control.

You need to add a radio button and add the 2 events for the radio button given above (Checkchanged & Click)

Pradeep Arthanari 2-Jan-18 7:56am View

Check if the values of ROUTE_BUTTON is properly populated in schemaTable. If its there in schemaTable it should be displayed in list and also make sure you have the routeNamesListView.View is set to View.Details.

routeNamesListView.View = View.Details;

Pradeep Arthanari 2-Jan-18 5:41am View

You may try this:


        public string connString;

        DataTable schemaTable;

        DataTable ContentTable;

        private void button1_Click(object sender, EventArgs e)
        {
            string filePath = string.Empty;
            string fileExt = string.Empty;

            string fileName = "D:\\00Latitude\\00InfyTFS\\Standard Interface\\ExcelRepository\\GPB 14-4-17.xls";

            connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
            DataTable schemaTable = ReadFile();
            

            routeNamesListView.Columns.Add("IPCNODEID");
            routeNamesListView.Columns.Add("IPC");
            for (int i = 0; i < schemaTable.Rows.Count; i++)
            {
                DataRow drow = schemaTable.Rows[i];

                // Only row that have not been deleted
                if (drow.RowState != DataRowState.Deleted)
                {
                    // Define the list items
                    ListViewItem lvi = new ListViewItem(drow[0].ToString());
                    for (int j = 1; j < schemaTable.Columns.Count; j++)
                    {
                        lvi.SubItems.Add(drow[j].ToString());
                    }
                    routeNamesListView.Items.Add(lvi);
                }
            }
            routeNamesListView.View = View.Details;
            routeNamesListView.CheckBoxes = true;

        }


        private DataTable ReadFile()
        {
            OleDbConnection conn = new OleDbConnection(connString);

            schemaTable = new DataTable();
            OleDbCommand Oledbcmd = new OleDbCommand();
            Oledbcmd.Connection = conn;
            conn.Open();
            Oledbcmd.CommandText = "Select IPCNODEID,IPC from [daily data$]";

            Oledbcmd.CommandType = CommandType.Text; //--------------

            OleDbDataAdapter da = new OleDbDataAdapter(Oledbcmd);
            ContentTable = new DataTable();
            da.Fill(ContentTable);
            OleDbDataReader dr = Oledbcmd.ExecuteReader();
            dr.Close();
            conn.Close();
            conn.Dispose();

            return ContentTable;

        }

Comments by Pradeep Arthanari (Top 7 by date)