how to get selected column datatype in grid

Question

0.00/5 (No votes)

See more:

Hi all,

Here my problem is i am like to get the datatype of column that i selected in grid . still now i am using

object st = Args.SortExpression.GetType().name;

But here always it return string only..

Thanks in Advance..
seshu

Posted 15-May-11 21:48pm

hiseshu

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

nit_singh · Answer 1 · 2011-05-15T23:23:00

Solution 5

try now

public void Sort_Grid(object Src, DataGridSortCommandEventArgs Args) 
        { 
            // Here i like to get the selected column data type.. like args.sortexpression.gettype(); 
            Type t = null; ;
            foreach (DataGridViewColumn dc in dgvMappedData.Columns) 
            { 
                if (dc.Name == Args.SortExpression) 
                    t = dc.ValueType; 
            }
            switch (t)
            {
                case typeof(string):
                    // TODO your code goes here
                    break;
                default:
                    break;
            }
        }

Posted 15-May-11 23:23pm

nit_singh

Comments

hiseshu 16-May-11 5:55am

Hi nit_singh

here i am unable to get dc.Name and dc.ValuType instead of dc.Name i used dc.SortExpression and dc.ValuType i used dc.sortexpression.getvalue();

HELP me singh i am new for this ...

sorry to say it wont works still it returns string type only for any data type...

Seshu

nit_singh 16-May-11 5:57am

If still it didn't work than check your Columns DataType. they Should be string only.

Can you paste the code of the binding part of the grid

hiseshu 16-May-11 6:04am

Dataview dv = log.DefaultView;

private void BindGrid()
{
MyDataGrid.DataSource = dv;
MyDataGrid.DataBind();
}

private DataTable log
{
get
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("No", typeof(string)));

dt.Columns.Add(new DataColumn("Type", typeof(string)));
dt.Columns.Add(new DataColumn("Date", typeof(DateTime)));
dt.Columns.Add(new DataColumn("Status", typeof(string)));
dt.Columns.Add(new DataColumn("Remarks", typeof(string)));

DB_RecordsetReadOnly rs = new DB_RecordsetReadOnly(stSQL);
SqlDataReader tbMySQL = rs.Recordset;

hiseshu 16-May-11 6:37am

Hi

did u checked my code.. if possible once check it and let me know for changes please

Seshu

Wayne Gaylard · Answer 2 · 2011-05-15T21:55:00

Solution 1

If you want to get the Type you should do this

C#

Type t = Args.SortExpression.GetType();

The *.GetType().Name returns a string.

Posted 15-May-11 21:55pm

Wayne Gaylard

Comments

hiseshu 16-May-11 3:59am

Hi

Thanks for spending time .. still my problem is same i am getting string as output...

hiseshu 16-May-11 4:00am

This is the function where i am trying to use it is

public void Sort_Grid(object Src, System.Web.UI.WebControls.DataGridSortCommandEventArgs Args)
{
type t=args.sortExpression.GetType();
}
but it return a sting ...

Wayne Gaylard 16-May-11 4:10am

What exactly are you trying to do once you have the Type ?

hiseshu 16-May-11 4:25am

Hi

Here based on the type of the column i like to sort...

Seshu

ambarishtv · Answer 3 · 2011-05-15T22:16:00

Solution 2

try this
DataGridViewColumn.ValueType Property[^]

Posted 15-May-11 22:16pm

ambarishtv

nit_singh · Answer 4 · 2011-05-15T22:17:00

Solution 3

Try that way

dgvMappedData.Columns.Cast<DataGridViewColumn>().ToList().Find(dc =>dc.Name == Args.SortExpression).ValueType

It should work

Args.SortExpression contains the name of the column as string so you will get string as the type.

Posted 15-May-11 22:17pm

nit_singh

Updated 15-May-11 22:19pm

v2

Comments

hiseshu 16-May-11 4:35am

hi nit_singh

Thanks for spending. It wont works here can u suggest if there is any alternative for getting the type particular column from a grid ..

Seshu

nit_singh 16-May-11 4:47am

Why is it not working? What errors you are getting. Explain..

hiseshu 16-May-11 4:56am

hi

MyDataGrid.Columns.Cast<args.sortexpression>().ToList().Find(dc=>dc.Name==Args.SortExpression).valueType;

i am getting error near by >

Is this code correct...

Seshu

nit_singh 16-May-11 4:59am

Yes Seshu, Which .net version u r using. This is lambda expression.

hiseshu 16-May-11 5:02am

i am using 2.0

nit_singh 16-May-11 5:04am

ok...thaty it is not working for you. This is new feature in 3.5

nit_singh 16-May-11 5:04am

Use the another solution which I added Just now

hiseshu 16-May-11 5:05am

I will give u the details of this.. my function is

public void Sort_Grid(object Src, System.Web.UI.WebControls.DataGridSortCommandEventArgs Args)
{
// Here i like to get the selected column data type..
like
args.sortexpression.gettype();

}

based on the type i like to write sort technique can u help me

Seshu

nit_singh 16-May-11 5:08am

foreach (DataGridViewColumn dc in dgvMappedData.Columns)
{
if (dc.Name == Args.SortExpression)
return dc.ValueType;
}

nit_singh · Answer 5 · 2011-05-15T23:03:00

Solution 4

Try that way

Type t = dgvMappedData.Columns.Cast<datagridviewcolumn>().ToList().Find(
                            delegate(DataGridViewColumn dc)
                            {
                                return dc.Name == "Name";
                            }
                          ).ValueType;
</datagridviewcolumn>

Posted 15-May-11 23:03pm

nit_singh

Comments

hiseshu 16-May-11 5:11am

The type or namespace name 'args.sortexpression' could not be found (are you missing a using directive or an assembly

getting this error.. can u once check the last comment once about how function i am using..

Thanks
seshu