C# Discussion Boards - CodeProject

10-Jul-07 9:36

Hi All;

I'm working in VS2005, and have a DataGridView that draws from a datasource. Is there a way to change a column to be a link style column after the DataGridView populates? Here's how I populate it:

<br />
DataSet ds = new DataSet();<br />
dgvShipmentHistory.DataSource = null;<br />
SqlDataAdapter da = new SqlDataAdapter(mySQLClass.Query, mySQLClass.SqlCon);<br />
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;<br />
da.Fill(ds, "ShipmentHistory");<br />
dgvShipmentHistory.DataSource = ds.Tables[0];<br />
dgvShipmentHistory.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);<br />

I want to be able to change one of the columns to be a link type column so that users can click the hyperlink and I can throw up a page.

Thanks

Ketty Avashia10-Jul-07 9:48

10-Jul-07 9:48

Windows or web?

Ketty

rahvyn610-Jul-07 9:49

10-Jul-07 9:49

Windows.

Ketty Avashia10-Jul-07 10:02

10-Jul-07 10:02

Did u try using DataGridViewLinkColumn?

If ur grid id bound to datasource, goto properties -> Columns -> select the appropriate column from ur columns list -> and change ColumnType property

Let me know if that works or am i thinking too simple. Wink | ;)

Ketty

rahvyn610-Jul-07 10:13

10-Jul-07 10:13

The only property I can see is the CellStyle property, I dont see a ColumnType property on the datagridview column.

rahvyn610-Jul-07 10:28

10-Jul-07 10:28

There is a DataGridViewLinkColumn class, but dont know if that will help me once the grid has been populated already, as I'm unsure how to change the type of column.

Ketty Avashia10-Jul-07 10:29

10-Jul-07 10:29

This is simple Designer generated code.
How to reach that property.
1. Select ur DataGridView control on designer.
2. F4
3. Columns (collection)
4. Select <column1>
5 On right side u see all column properties.
6. Change ColumnType to DataGridViewLinkColumn

<br />
namespace WindowsApplication1<br />
{<br />
    partial class Form1<br />
    {<br />
        /// <summary><br />
        /// Required designer variable.<br />
        /// </summary><br />
        private System.ComponentModel.IContainer components = null;<br />
<br />
        /// <summary><br />
        /// Clean up any resources being used.<br />
        /// </summary><br />
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param><br />
        protected override void Dispose(bool disposing)<br />
        {<br />
            if (disposing && (components != null))<br />
            {<br />
                components.Dispose();<br />
            }<br />
            base.Dispose(disposing);<br />
        }<br />
<br />
        #region Windows Form Designer generated code<br />
<br />
        /// <summary><br />
        /// Required method for Designer support - do not modify<br />
        /// the contents of this method with the code editor.<br />
        /// </summary><br />
        private void InitializeComponent()<br />
        {<br />
            this.components = new System.ComponentModel.Container();<br />
            this.dataGridView1 = new System.Windows.Forms.DataGridView();<br />
            this.actionTypesBindingSource = new System.Windows.Forms.BindingSource(this.components);<br />
            this.fISM0702DataSet = new WindowsApplication1.FISM0702DataSet();<br />
            this.actionTypesTableAdapter = new WindowsApplication1.FISM0702DataSetTableAdapters.ActionTypesTableAdapter();<br />
            this.actionTypeDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewLinkColumn();            this.descriptionDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();<br />
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();<br />
            ((System.ComponentModel.ISupportInitialize)(this.actionTypesBindingSource)).BeginInit();<br />
            ((System.ComponentModel.ISupportInitialize)(this.fISM0702DataSet)).BeginInit();<br />
            this.SuspendLayout();<br />
            // <br />
            // dataGridView1<br />
            // <br />
            this.dataGridView1.AutoGenerateColumns = false;<br />
            this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;<br />
            this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {<br />
            this.actionTypeDataGridViewTextBoxColumn,<br />
            this.descriptionDataGridViewTextBoxColumn});<br />
            this.dataGridView1.DataSource = this.actionTypesBindingSource;<br />
            this.dataGridView1.Location = new System.Drawing.Point(213, 281);<br />
            this.dataGridView1.Name = "dataGridView1";<br />
            this.dataGridView1.Size = new System.Drawing.Size(240, 150);<br />
            this.dataGridView1.TabIndex = 3;<br />
            // <br />
            // actionTypesBindingSource<br />
            // <br />
            this.actionTypesBindingSource.DataMember = "ActionTypes";<br />
            this.actionTypesBindingSource.DataSource = this.fISM0702DataSet;<br />
            // <br />
            // fISM0702DataSet<br />
            // <br />
            this.fISM0702DataSet.DataSetName = "FISM0702DataSet";<br />
            this.fISM0702DataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;<br />
            // <br />
            // actionTypesTableAdapter<br />
            // <br />
            this.actionTypesTableAdapter.ClearBeforeFill = true;<br />
            // <br />
            // actionTypeDataGridViewTextBoxColumn<br />
            // <br />
            this.actionTypeDataGridViewTextBoxColumn.DataPropertyName = "ActionType";<br />
            this.actionTypeDataGridViewTextBoxColumn.HeaderText = "ActionType";<br />
            this.actionTypeDataGridViewTextBoxColumn.Name = "actionTypeDataGridViewTextBoxColumn";<br />
            this.actionTypeDataGridViewTextBoxColumn.Resizable = System.Windows.Forms.DataGridViewTriState.True;<br />
            this.actionTypeDataGridViewTextBoxColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic;<br />
            // <br />
            // descriptionDataGridViewTextBoxColumn<br />
            // <br />
            this.descriptionDataGridViewTextBoxColumn.DataPropertyName = "Description";<br />
            this.descriptionDataGridViewTextBoxColumn.HeaderText = "Description";<br />
            this.descriptionDataGridViewTextBoxColumn.Name = "descriptionDataGridViewTextBoxColumn";<br />
            // <br />
            // Form1<br />
            // <br />
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);<br />
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;<br />
            this.ClientSize = new System.Drawing.Size(636, 562);<br />
            this.Controls.Add(this.dataGridView1);<br />
            this.Name = "Form1";<br />
            this.Text = "Form1";<br />
            this.Load += new System.EventHandler(this.Form1_Load);<br />
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();<br />
            ((System.ComponentModel.ISupportInitialize)(this.actionTypesBindingSource)).EndInit();<br />
            ((System.ComponentModel.ISupportInitialize)(this.fISM0702DataSet)).EndInit();<br />
            this.ResumeLayout(false);<br />
<br />
        }<br />
<br />
        #endregion<br />
<br />
        private System.Windows.Forms.DataGridView dataGridView1;<br />
        private FISM0702DataSet fISM0702DataSet;<br />
        private System.Windows.Forms.BindingSource actionTypesBindingSource;<br />
        private WindowsApplication1.FISM0702DataSetTableAdapters.ActionTypesTableAdapter actionTypesTableAdapter;<br />
        private System.Windows.Forms.DataGridViewLinkColumn actionTypeDataGridViewTextBoxColumn;<br />
        private System.Windows.Forms.DataGridViewTextBoxColumn descriptionDataGridViewTextBoxColumn;<br />
    }<br />
}<br />

Are you binding ur grid on runtime????

Ketty

rahvyn610-Jul-07 10:32

Execute User written Code

10-Jul-07 10:32

Yes, the grid is bound at runtime, so although I know what the columns will be for the most part, they could change.

Ketty Avashia10-Jul-07 9:34

10-Jul-07 9:34

I need to write a performance driven utility that allows user to write C# code in a text area. When they click on execute to see what is the final out, utility should complie and run the code written by user as if it is a function body.

e.g. I am trying to achieve:

<br />
private void ExecuteUser()//Function in Utility<br />
{<br />
<br />
/*<br />
-------Body of this function will be filled by User Code from text area at click of button.<br />
*/<br />
<br />
}<br />

I am not a C# coder for past few years Cry | :((

, so any code snippet would be awesome. We are using .Net 2.0. VS 2005.

Ketty

Guffa10-Jul-07 9:40

Guffa

10-Jul-07 9:40

You can't put code into an existing method. You have to compile the code into a new assembly.

Take a look at the Microsoft.CSharp.CSharpCodeProvider class.

---
single minded; short sighted; long gone;

Ketty Avashia10-Jul-07 10:05

10-Jul-07 10:05

Thanks, I did see an example of "Microsoft.CSharp.CSharpCodeProvider class" on CodeProject, if you or any body has used it. Is it performance promising?

Ketty

PhilDanger10-Jul-07 10:58

PhilDanger

10-Jul-07 10:58

private void ExecuteUser()//Function in Utility
{
      if(txtUserCode.Text != "while(true){}"){
        //run!
      }
}

Feel free to use this as a safeguard after you get the rest of it figured out Smile | :)

Ketty Avashia10-Jul-07 11:32

10-Jul-07 11:32

I am not quite sure if I understand the idea completely.
Please advice.

Ketty

PhilDanger11-Jul-07 2:58

PhilDanger

11-Jul-07 2:58

Just a joke about the dangers of letting users execute their own code -- the code I wrote "checks" for an infinite loop.

Ketty Avashia11-Jul-07 5:34

11-Jul-07 5:34

:-DJokes are fine but I am looking for serious comments on this issue

Ketty