Could not load file or assembly 'Assembly Name' or one of its dependencies. The system cannot find the path specified.

One Way to solve this Error is

1. Go to C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files
2. Here You can find Folder named Your Application name e.g. "MyWeb"
3. So first Stop ISS Web server.
4. and Close Visual Studio 2005.
5. Now Try to remove Folder "MyWeb" 
6. After Deleting this folder  again open  Visual  Studio.. and
7. Do Rebuild Website /Project

Wooppieie Error Gone...

Powered by ScribeFire.

How to select all Table Fields or Table Column Names in Asp.net & Sql Server 2000/2005

From many days i was Searching for A Source Code Which can return a Column Name of Selected Table. So Finally After a little bit of Effort i did it.



Here is Code To do it.



Before Using Code please Change Connection String and Give Respactive TableName in CommandText.



VB

Dim dr As SqlDataReader

Dim cmd As SqlCommand = New SqlCommand

Dim conn As SqlConnection = New SqlConnection("Server=Server\sqlexpress;Database=PragatiDataServer;Uid=dev_user;Pwd=password;")

conn.Open

cmd.Connection = conn

cmd.CommandType = CommandType.Text

cmd.CommandText = "select * from table_ads"

dr = cmd.ExecuteReader(CommandBehavior.SchemaOnly)

dr.Read

Dim dt As DataTable = dr.GetSchemaTable

Dim i As Integer = 0

While i < dt.Rows.Count

 Response.Write(dt.Rows(i).ItemArray(0) + "<br>")

 System.Math.Min(System.Threading.Interlocked.Increment(i),i-1)

End While

dr.Close

conn.Close



C#







SqlDataReader dr;

SqlCommand cmd = new SqlCommand();

SqlConnection conn = new
                  SqlConnection("Server=Server\\sqlexpress;Database=PragatiDataServer;Uid=dev_user;Pwd=password;");

conn.Open();

cmd.Connection = conn;

cmd.CommandType = CommandType.Text;

cmd.CommandText = "select * from table_ads";

dr = cmd.ExecuteReader(CommandBehavior.SchemaOnly);

dr.Read();

DataTable dt = dr.GetSchemaTable();

for (int i = 0; i < dt.Rows.Count; i++)

    {


         Response.Write(dt.Rows[i].ItemArray[0] + "<br>");


    }

dr.Close();

conn.Close();





Powered by ScribeFire.