Copying Particular Columns from one table to another table without using Loop

Dim columns As String() = {"colA", " colB", "colC", "colD ", "colE"}

Here ds is original dataset

If Not ds Is Nothing Then

  dsDet = ds.Clone

  'Copying only particular columns which is specify in the above string array

  dtDet = ds.Tables(0).DefaultView.ToTable("newTableName", False, columns)

  dsDet.Tables.Add(dtDet)

 'Removing the original table

  dsDet.Tables.RemoveAt(0)

End If

Return dsDetails

Create Numeric Text box using JavaScript

We can create numeric textbox using JavaScript, below code will create numeric text using JavaScript.

Convert Array to Array List

I have created one method with two parameters (Array, ArrayList) which is used to convert the Array to ArrayList

C#

public static ArrayList ConvertArrayToArrayList(string[] strarray, ArrayList arrlstArray)

{

  arrlstArray.AddRange(strarray);

  return arrlstArray;

}

VB

Public Shared Function ConvertArrayToArrayList(ByVal strarray() As String, ByVal arrlstArray As ArrayList) As ArrayList

  arrlstArray.AddRange(strarray)

  Return arrlstArray

End Function

I hope this article will be very helpful to all. Thanks for reading this article.

“Keep reading and share the knowledge”  

“Grow more trees to save Earth”

How to Read of web.config by using XML in asp.net

We can read the web.config file explicitly by using XML Namespace.

<appSettings>

    <add key="OracleConnection" value="Data Source=TORCL;User Id=myUsername;Password=myPassword;"/>

    <add key="SqlServerConnection" value="Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;"/>

  </appSettings>

We can read this web.config by using below code

Asp.net 2.0

string connStr = ConfigurationSettings.AppSettings("OracleConnection");

Asp.net 3.0 and above

string connStr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;

But  sometime if you want to read the config file any other purpose then we can use this code before use this code you need to include the following namespaces

System.Configuration;

System.Web.Configuration;

System.Xml;

C#

string webconfigpath = string.Empty;

XmlDocument xdoc = new XmlDocument();

XmlNodeList xnodes;          

string oracleconnetion = string.Empty;

string sqlconnection = string.Empty;

               

webconfigpath = GetWebconfigPath();

xdoc.Load(webconfigpath);

xnodes = xdoc.GetElementsByTagName("add");

foreach(XmlNode node in xnodes)

{

  if (node.Attributes["key"].Value == "OracleConnection")

   {

     oracleconnetion= node.Attributes["value"].Value;

   }

  if (node.Attributes["key"].Value == "SqlServerConnection")

    {

     sqlconnection = node.Attributes["value"].Value;

    }

}

/// <summary>

/// Get Path of the Web.config File which is reside in server side

/// </summary>

/// <returns></returns>

public string GetWebconfigPath()

{

 Configuration config ;

 string path = string.Empty;

 config = WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);

 path = config.FilePath;

 return path;

}

VB

Dim xdoc As New XmlDocument

Dim webconfigpath As String

Dim nodes As XmlNodeList

Dim oracleconnetion As String = String.Empty

Dim sqlconnection As String = String.Empty

webconfigpath = GetReportLookupPath()

xdoc.Load(webconfigpath)

nodes = xdoc.GetElementsByTagName("add")

For Each xmlnode As XmlNode In nodes

 If (xmlnode.Attributes("key").Value = "OracleConnection") Then

    oracleconnetion = xmlnode.Attributes("value").Value

 End If

 If (xmlnode.Attributes("key").Value = "SqlServerConnection") Then

     sqlconnection = xmlnode.Attributes("value").Value

 End If

Next

''' <summary>

''' Get Path of the Web.config File which is reside in server side

''' </summary>

''' <returns></returns>

''' <remarks></remarks>

Public Function GetReportLookupPath() As String

Dim config As Configuration

Dim path As String

config = WebConfigurationManager.OpenWebConfiguration(System.Web.HttpContext.Current.Request.ApplicationPath)

path = config.FilePath

Return path

End Function

I hope this article will be very helpful to all. Thanks for reading this article.

“Keep reading and share the knowledge”  

“Grow more trees to save Earth”

How to Read path of web.config in asp.net

You can get the path of the web.config which is available in the server.

Configuration config ;

string path = string.Empty;

config = WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);

path = config.FilePath;

path will have path of web.config file which is available in the server

I hope this article will be very helpful to all. Thanks for reading this article.

“Keep reading and share the knowledge”  

“Grow more trees to save Earth”