Create a request for examples and/or further explanations

Go to support page

User requested the following:

I downloaded the component and want to try it and check whether it suits our requirement. So kindly give the steps for adding the columns and the ways for connect to the Sql DB.

Support Answered:

In order to connect to a SQL Server database you can use normal .NET framework objects and commands from the System.Data.SqlClient namespace:

SqlConnection

SqlDataReader

ExecuteReader

SqlCommand

In our demos we use System.Data.OleDb which connects to an Access 2003 database. We do this for ease of installation only, because most Windows operating systems handle Access seamlessly. Setting up a SQL Server, Oracle or DB2 for demo purposes would involve a lot of permission issues.

But System.Data.OleDB and System.Data.SqlClient are practically identical in their interface:

OleDbConnection = SqlConnection

OleDbDataReader = SqlDataReader

ExecuteReader = ExecuteReader

OleDbCommand = SqlCommand

In our demos we encapsulate commands to avoid repeating code, so in the demos we call:

g_DST_ACCESS_ExecuteNonQuery("DELETE FROM some_table WHERE bID = " & SomeID);

Instead of having to create a connection, open it, then create a command, then execute that command and close the connection.

These are commands that are external to ActiveGanttCSA. And the source code is present in the demos:

        public static void g_DST_ACCESS_ExecuteNonQuery(string sSQL)
        {
            using (OleDbConnection oConn = new OleDbConnection(g_DST_ACCESS_GetConnectionString()))
            {
                OleDbCommand oComm = null;
                oConn.Open();
                oComm = new OleDbCommand(sSQL, oConn);
                oComm.ExecuteNonQuery();
                oConn.Close();
            }
        }

The above applies to all versions of the ActiveGantt component (ActiveGanttVBN, ActiveGanttVC, etc.).

I'm not sure exactly know what you are referring to by "adding the columns". We now have a small tutorial on how to make a simple ASP.NET application with the ActiveGanttCSA component:

Getting Started with the ActiveGanttCSA Gantt Chart Scheduler Component

At the very end it has some code on how to add Columns, Rows and Tasks. Maybe this is what you are looking for.