Comments by Mastersev (Top 59 by date)

thank you

The IDs are not important right now, it's not even triggering. The alert() method is not being displayed when I check the checkboxes.

I'm using this in wordpress(php) it's not asp.net but I will try

SAK I will accept your solution. Thank you for helping out as always.

Spasiba!

I managed to get the type and sort the list:
list.Cast<mytypeclass>().OrderBy(t => t.Name).ToList();

It's a collection of objects and sort has to be in ascending order

Thx

I was able to fix it myself.

var query = from c in list.OfType<object>()
select c;

Yea it was a typo get over it.

OK I get the type as following:

Type[] listTypes = list.GetType().GetGenericArguments();
Type listType = null;

if (listTypes.Length > 0)
{
listType = listTypes[0];
}
but how can I create a new list with this type?

It's an Interface

I'll vote 5 because you helped me.

Many thanks to phil.o and Sakryukov

string[] parts = value.Split(new char[] {'(', ')'}, System.StringSplitOptions.RemoveEmptyEntries);
string numeric = parts[parts.Length-1];
numeric = Convert.ToDecimal(numeric).ToString("#0.00");
while(numeric.Length < 9)
{
numeric = "0" + numeric;
}
return numeric;

Looks like I got it:
string[] parts = value.Split(new char[] {'(', ')'}, System.StringSplitOptions.RemoveEmptyEntries);
string numeric = parts[parts.Length-1];
numeric = Convert.ToDecimal(numeric).ToString("#0.00");
while(numeric.Length < 9)
{
numeric = "0" + numeric;
}
return numeric;

Ok I tried this and now I got 37913.00

return Convert.ToDecimal(numeric).ToString("#0.00");

Note: The left side is always 6 digits if less then zeros must be added to the front
The right side is always 2 digits

Ok I tried this and now I got 37913.00

return Convert.ToDecimal(numeric).ToString("#0.00");

Note: The left side is always 6 digits if less then zeros must be added to the front
The right side is always 2 digits

string numeric = parts[parts.Length-1]; //sic!
return numeric.ToString("#0.00");

Error: Argument 1: cannot convert from 'string' to 'System.IFormatProvider'
The best overloaded method match for 'string.ToString(System.IFormatProvider)' has some invalid arguments

string value = "White BOX, Inc. (037913.00)";
string[] parts = value.Split(new char[] {'(', ')'}, System.StringSplitOptions.RemoveEmptyEntries);
string numeric = parts[parts.Length-1]; //sic!
double d = double.Parse(numeric);

This returns a double ---> 37913
I need --> 037913.00

nope :(

well in my case these are IDs. I think there is no way to achieve this :(

it grabs the 37913

Code:
string value = "White BOX, Inc. (037913.00)";
string[] parts = value.Split(new char[] {'(', ')'}, System.StringSplitOptions.RemoveEmptyEntries);
string numeric = parts[parts.Length-1]; //sic!
double d = double.Parse(numeric);

It just grabs the 37913 from "White BOX, Inc. (037913.00)"

It just grabs the 37913 from "White BOX, Inc. (037913.00)"

Yea in case of "White BOX, Inc. (037913.00)" it does not work.

Thanks Ninja your answer is the best answer so far. But there is something new I forgot to mention. Some of the numbers have zeros before them. i.e. 00333.33

They are IDs :(

Yes

I have 130000 records I cannot check them one by one

Double and int

What if it's "YYY(33345.002)(gg)YYYY"?

no can be anything

Sorry for the confusion but it may be "BADLands(O)(33345.002)". No fix length.

thx

I will have to do it in c# and I will have to go through every single row (total 130000 rows). I have been advised to use hashtables to detect the difference faster in rows and update the target database row. I have to keep 2 databases synced using this application.

Please improve your question

what if in the second record A3 is null, this wont work.

post the full error description my friend.

from c in dc.Test
where Convert.ToString(postdate) == Convert.ToString(DateTime.Now.Date)
group c by c.Name into g
select new { Count = g.Count() , Name = g.Key }

where is the count?

thank you very much sir

Imagine a DataTable that is filled with data, I need the TSQL script that creates that TABLE and INSERTS the data in SQL server.

I know it is possible with SQL server but I need to export the INSERT script along with the Table data in C#, I need the C# code.

please explain more, the provided explanation in not clear to the reader.

just fixed it, the name of the datatable field in the DATASET was wrong, I changed it too the exact name in the query and it worked.

the call date is fixed. I changed the textbox format to d.

thank you, you were right.

there is no error, the multiple filters function wrong, sometimes I might have both or all of them with the IF statements.

ok so how can I have multiple filters applied in one method?

because of the autogenerate clumns

dataGridView1.AutoGenerateColumns = true;

GROUP BY tbl_Loans.loanID OR GROUP BY tbl_Borrowers.loanID???
and can you show me where to put the count(*) exactly in the script?