Database

Name Flag Queue

A     Y     1

B     X     2

C     X     3

D     X     4

E     X     5

public class DBConnection
{
    string connectionPath = "Data Source=SUMERUSYS135\\SQLEXPRESS;Initial Catalog=test;Integrated Security=True";
    string command = string.Empty ;

	public DBConnection()
	{
		//
		// TODO: Add constructor logic here
		//
	}

    public DataTable FetchRecord()
    {

        SqlDataAdapter adapter = new SqlDataAdapter();
        SqlConnection connection = new SqlConnection(@connectionPath);
        command = "Select * from AlternateTable";
        connection.Open();
        SqlCommand sqlCom = new SqlCommand(command, connection);
        adapter.SelectCommand = sqlCom;
        DataTable table = new DataTable();
        table.Locale = System.Globalization.CultureInfo.InvariantCulture;
        adapter.Fill(table);
        return table;
    }
}

Step 1: Create a custom datatable(say CustomDt) with the column 
                  names that are to be exposed.

          Step 2: Get all the records from the database and place it 
                   inside a datatable(say OriginalDt).

         Step 3:  Loop thru the second record of the datatable(OriginalDt)
                  till the end.

         Step 4: Check if a even row has come or not from the OriginalDt.
 
                 If it is true, then add the first record of the 
                 datasource to the Custom Datatable after adding the even 
                 row from the Original Data Table.

                 Else, add the other records of the original datasource to 
                 the Custom Datatable.

         Step 5: Make the Custom Datatable as the source for the gridview

protected void Page_Load(object sender, EventArgs e)
    {
        DBConnection objdbconnection = new DBConnection();

        //Original datasource
        DataTable OriginalDt = objdbconnection.FetchRecord();

        #region Final Custom Datatable

        DataTable CustomDt = new DataTable();
        CustomDt.Columns.Add("Name");
        CustomDt.Columns.Add("Flag");
        CustomDt.Columns.Add("Queue");

        #endregion


        for (int i = 1; i < OriginalDt.Rows.Count; i++)
        {
            if (i % 2 == 0)
            {
                CustomDt.Rows.Add(OriginalDt.Rows[i][0], OriginalDt.Rows[i][1], OriginalDt.Rows[i][2]);
                CustomDt.Rows.Add("A", "Y", "1");
            }
            else
            {
                CustomDt.Rows.Add(OriginalDt.Rows[i][0], OriginalDt.Rows[i][1], OriginalDt.Rows[i][2]);
            }
            
        }

        grdAlternateRow.DataSource = CustomDt;
        grdAlternateRow.DataBind();

    }

shankbond wrote:

he application works fine

Mycroft Holmes wrote:

You will probably need to change from integrated security (using your windows logon) to a SQL userid and password for the app to connect ans include them in the connection string.

Mycroft Holmes wrote:

You will need to set up the SQL user with adequate permissions on your database. That's it.

         Jan   Feb   Mar   Apr
         ---   ---   ---   ---
Budget   10    10    10    10
Actual   10    5     10    0
...      0     0     0     0
...      0     0     0     0
...      0     0     0     0