Comments by Rambabu Sapa

Rambabu Sapa 25-Jul-13 4:56am View

Iam adding Controls Dynamically Which is shown below
cmbSource = new ComboBox[dtExelData.Columns.Count];
cmbDestination = new ComboBox[dtExelData.Columns.Count];
for (int i = 0; i <= dtExelData.Columns.Count - 1; i++)
{
cmbSource[i] = new ComboBox();
cmbSource[i].Name = Convert.ToString("cmbSource" + i);
cmbSource[i].Location = new Point(100, x);
this.Controls.Add(cmbSource[i]);
cmbSource[i].DataSource = lHeader;

// MessageBox.Show(cmbSource[i].Name.ToString());

cmbDestination[i] = new ComboBox();
cmbDestination[i].Name = Convert.ToString("cmbDest" + i);
cmbDestination[i].Location = new Point(400, x);
this.Controls.Add(cmbDestination[i]);
cmbDestination[i].DataSource = dsTblColumns.Tables[0];
cmbDestination[i].DisplayMember = "column_name";
cmbDestination[i].ValueMember = "column_name";
x = x + 40;
}

Rambabu Sapa 24-Jul-13 8:54am View

When files are received from banks, they will contain many fields. The values in those fields may not match the values which must be loaded into the database.
For example, one field which will be on many records is the State (related to address fields). The source data might contain CT or Connecticut. The target database will use an integer value for this field (in this case 8). This integer value will be stored in a field called AddressStateTC.

Rambabu Sapa 24-Jul-13 8:16am View

Example we have
FName , LName , DOB , SAL Columns in Excel
___________________________________________
Tabl1 :- LName,DOB , SAL
Table2 :- FName , SAL

Now I Have to map The exel Data into dataBase Tables Based On User Selection

Rambabu Sapa 24-Jul-13 7:55am View

Based On excel Column names i Generated Dynamic labels and same as fill the dropdownLists after That I Have to Map The Drop Down List Columns with exec Columns.
Thanks in Advance

Comments by Rambabu Sapa (Top 4 by date)