TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
B M Suchitra
NA
507
418.7k
Please suggest me how to separate out the data in ArrayList
Nov 24 2011 12:52 AM
Hi all.
private string GenerateInsertQRY(string TableName, ArrayList mCol)
{
string strColumnName = "";
string strColumnValue = "";
string strInsertQRY = null;
try
{
foreach (ClsDMLProperties Columns in mCol)
{
if (!string.IsNullOrEmpty(strColumnName))
{
strColumnName = strColumnName + ",";
}
if (!string.IsNullOrEmpty(strColumnValue))
{
strColumnValue = strColumnValue + ",";
}
strColumnName = strColumnName + Columns.Col_Name;
if (Columns.ReplaceBlankWithNull == false)
{
if (Columns.IsNumeric == true)
{
strColumnValue = strColumnValue + Columns.Col_Value;
}
else
{
strColumnValue = strColumnValue + "'" + Columns.Col_Value+"'";
}
}
else
{
if (string.IsNullOrEmpty(Columns.Col_Value))
{
strColumnValue = strColumnValue + "NULL";
}
else if (Columns.IsNumeric == true)
{
strColumnValue = strColumnValue + Columns.Col_Value;
}
else
{
strColumnValue = strColumnValue + "'" + Columns.Col_Value+"'";
}
}
}
}
catch (Exception ex)
{
}
}
===========================
In this method I want to separate out strColumnValue and strColumnName to use them somewhere else.. How can i do this ?
Reply
Answers (
3
)
View in ASP.NET MVC application
How to read the mobile sms into system