Task export on MSProject with error on blank/empty tasks

I created an Addin in C# VSTO to export tasks from MSProject to a SQLServer. My code works fine until the tasks in MSProject have an empty/blank entry.

I have no idea for a workaround. It seems, that die foreach isn't working here.

MsProject.Tasks tasks = Globals.ThisAddIn.Application.ActiveProject.Tasks;
using (SqlConnection cnn = new SqlConnection(connectionString))
{
try
{
// Open the connection to the database.
cnn.Open();
foreach (Microsoft.Office.Interop.MSProject.Task t in tasks)
{
DateTime start = (DateTime)t.Start;
DateTime finish = (DateTime)t.Finish;
using (SqlCommand cmd = new SqlCommand(sql, cnn))
{
// Create and set the parameters values
cmd.Parameters.Add("@id", SqlDbType.Int).Value = t.ID;
cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = t.Name;
cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = start;
cmd.Parameters.Add("@finish", SqlDbType.DateTime).Value = finish;
int rowsAdded = cmd.ExecuteNonQuery();
}
}
MessageBox.Show("Data transfered" );
}

In MSProject it looks like:

Does anyone have an idea how to loop over or include the blank/empty tasks?

Currently i only get NullPointerReference of the object as Error and the Third task won't be export to SQL Server.

Hello Sebastian, Please check code changes. Let me know if need any futher help, correct me if i understand wrong.

MsProject.Tasks tasks = Globals.ThisAddIn.Application.ActiveProject.Tasks;
using (SqlConnection cnn = new SqlConnection(connectionString))
{
try
{
// Open the connection to the database.
cnn.Open();
bool transfered=false;
foreach (Microsoft.Office.Interop.MSProject.Task t in tasks)
{
if(!string.IsNullEmpty(t.Name)) // if required check ID also
{
DateTime start = (DateTime)t.Start; // here you will get exception so do null check as above
DateTime finish = (DateTime)t.Finish; // here too
using (SqlCommand cmd = new SqlCommand(sql, cnn))
{
// Create and set the parameters values
cmd.Parameters.Add("@id", SqlDbType.Int).Value = t.ID;
cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = t.Name;
cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = start;
cmd.Parameters.Add("@finish", SqlDbType.DateTime).Value = finish;
int rowsAdded = cmd.ExecuteNonQuery();
if(rowAdded>=0)
{
transfered=true;
}
}
}
}
if(transfered)
{
MessageBox.Show("Data transfered" );
}
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar6y ago
Hello Sebastian, Please check code changes. Let me know if need any futher help, correct me if i understand wrong.
MsProject.Tasks tasks = Globals.ThisAddIn.Application.ActiveProject.Tasks;
using (SqlConnection cnn = new SqlConnection(connectionString))
{
try
{
// Open the connection to the database.
cnn.Open();
bool transfered=false;
foreach (Microsoft.Office.Interop.MSProject.Task t in tasks)
{
if(!string.IsNullEmpty(t.Name)) // if required check ID also
{

DateTime start = (DateTime)t.Start; // here you will get exception so do null check as above
DateTime finish = (DateTime)t.Finish;   // here too
using (SqlCommand cmd = new SqlCommand(sql, cnn))
{

// Create and set the parameters values
cmd.Parameters.Add("@id", SqlDbType.Int).Value = t.ID;
cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = t.Name;
cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = start;
cmd.Parameters.Add("@finish", SqlDbType.DateTime).Value = finish;
int rowsAdded = cmd.ExecuteNonQuery();
if(rowAdded>=0)
{
transfered=true;
}
}
}
}
if(transfered)
{
MessageBox.Show("Data transfered" );
}
}