Category: ASP.NET

28 Feb 2017 15:38

Joined:	17/07/2011
Level:	Silver
Points:	106

Points:	5

Pass value dynamic in main column

Here Main_Column_Names Column we are reterive two values (RS_BRANCH_CODE and BRANCH_CODE) And below my code i am just pass two value on index[0] & index[1].

var Main_Column_Names = ConfigurationManager.AppSettings["Main_Column_Name"].Split(',').Select(s => s.Trim()).ToList();

try
{
copylist = dtexcel.AsEnumerable().Select(s => s.Field<string>(Main_Column_Names[0])).Distinct().ToList();
strSelectedMainColName = Main_Column_Names[0];
}

catch (Exception ex)
{
copylist = dtexcel.AsEnumerable().Select(s => s.Field<string>(Main_Column_Names[1])).Distinct().ToList();

strSelectedMainColName = Main_Column_Names[1];
}

I do not want Main_Column_Names[0] or Main_Column_Names[1] , i want pass Main_Column_Names[] dynamically. how i can do it.

#768989

06 Mar 2017 07:32

Joined:	28/04/2006
Level:	Gold
Points:	29773

Points:	3

Hai Nitin,
I think you can use foreach loop and pass the collection as below:


var Main_Column_Names = ConfigurationManager.AppSettings["Main_Column_Name"].
Split(',').Select(s => s.Trim()).ToList();
try
{
 foreach(var colName in  Main_Column_Names)
 {
  copylist = dtexcel.AsEnumerable().Select(s => s.Field<string>(colName)).
Distinct().ToList();
  strSelectedMainColName = colName;
 }
}
catch (Exception ex)
{
 throw ex;
}

Hope it will be helpful to you.

Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com

#768996

06 Mar 2017 10:57

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	2

Hi,

I agree with Pawan, if you want to assign values with different rows dynamically then you have to loop each row and assign it as per you need.

--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/

#769030

11 Mar 2017 19:23

Joined:	30/04/2012
Level:	Gold
Points:	7233

Points:	3

You can use this Procedure to Pass value dynamic in main column in MySQL

CREATE PROCEDURE AvgCityProcedure(
IN colName VARCHAR(100),
OUT colAvg FLOAT)
BEGIN
SET @c1 = 0.0;
SET @M:= colName;
SET @QUERY:= CONCAT('SELECT AVG(',@M,') INTO @C1 FROM DemoTable');
PREPARE stmt FROM @QUERY;
EXECUTE stmt; 
SET colAvg:=@C1;
SELECT colAvg;
END

Pass value dynamic in main column

About dotnetspider.com

Quick Links

General

Services