Let me explain the situation..

I have a datagrid with values coming from a table. This table has a number of non-descriptive columns. How could when grid is displayed, these non-descriptive values can be replaced with descriptive vales read from a different table.

For example, the table's columns are

LocationId, StateId, CityId
HY1 AL HY
HY9 MNYU

The descriptive values of these mnemonics are stored in different tables, one for location, one for state and one for city.

How the values can be automatically transferred to the grid without using a complex join? I want a simple sql so that records can still be inserted into table using dataadapter.

Any help is appreciated.

I don't think without join query you can display meaningful name in the grid.


If by chance you are interested in join query then you can use following one

SELECT L.LocationName, S.StateName, C.CityName 
FROM [MainTable] M
JOIN Location L ON L.LocationID = M.LocationID
JOIN State S ON S.StateID = M.StateID
JOIN City C ON C.CityID = M.CityID

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

namespace WindowsApplication1

{

public partial class DataTableForm : Form

{

#region Do not modify code in this region

/// <summary>

/// Required designer variable.

/// </summary>

private System.ComponentModel.IContainer components = null;

/// <summary>

/// Clean up any resources being used.

/// </summary>

/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

protected override void Dispose(bool disposing)

{

if (disposing && (components != null))

{

components.Dispose();

}

base.Dispose(disposing);

}

#region Windows Form Designer generated code

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.dataGridView1 = new System.Windows.Forms.DataGridView();

((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();

this.SuspendLayout();

//

// dataGridView1

//

this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;

this.dataGridView1.Dock = System.Windows.Forms.DockStyle.Fill;

this.dataGridView1.Location = new System.Drawing.Point(0, 0);

this.dataGridView1.Name = "dataGridView1";

this.dataGridView1.Size = new System.Drawing.Size(292, 266);

this.dataGridView1.TabIndex = 0;

this.dataGridView1.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridView1_CellContentClick);

//

// DataTableForm

//

this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);

this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

this.ClientSize = new System.Drawing.Size(292, 266);

this.Controls.Add(this.dataGridView1);

this.Name = "DataTableForm";

this.Text = "DataTableForm";

this.Load += new System.EventHandler(this.DataTableForm_Load);

((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();

this.ResumeLayout(false);

}

#endregion

private System.Windows.Forms.DataGridView dataGridView1;

#endregion

DataTable dataTable;

BindingSource bindingSource;

public DataTableForm()

{

InitializeComponent();

this.Load+=new EventHandler(DataTableForm_Load);

this.dataTable = new DataTable();

}

public DataTableForm(DataTable table)

: this()

{

table.Locale = System.Globalization.CultureInfo.InvariantCulture;

this.dataTable = table;

}

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)

{

}

private void DataTableForm_Load(object sender, EventArgs e)

{

this.bindingSource = new BindingSource();

this.bindingSource.DataSource = this.dataTable;

this.dataGridView1.DataSource = this.bindingSource;

dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);

return;

}

}

}

That demonstrates how to bind a DGV to a DataTable.