CODEWITHSUNDEEP
asp.net
Anup Rojekar
Anup Rojekar

Reputation: 1103

Object reference not set to an instance of an object

I am facing an issue while inserting some items into database in asp.net web service application.

Here is my code ..

 public void DoRequestLog(HttpRequest request)
        {
            string UserAgent = request.Headers["User-Agent"];
            string Date = "4/14/2011";//request.Headers["Date"];
            string HostIP = request.Headers["Host"];
            string URL = request.Headers["Referer"];
            string MethodName = request.HttpMethod;
            string VersionNo = "";
            string IMEINo = "";

        string dbString = Configuration.GetDBConnectionString();

        SqlConnection DardSqlConnection = new SqlConnection(dbString);

        DardSqlConnection.Open();

        SqlCommand log = DardSqlConnection.CreateCommand();

        log.CommandText = "insert into ConnectionLog values('"+UserAgent+"','"+Date+"','"+HostIP+"','"+URL+"','"+MethodName+"','"+VersionNo+"','"+IMEINo+"');";

        log.ExecuteNonQuery();

    }

Please Help Since I am new to .net environment.

Upvotes: 0

Views: 897

Answers (1)

Jeffrey L Whitledge
Jeffrey L Whitledge

Reputation: 59463

Try this:

public void DoRequestLog(HttpRequest request)
 {
     // We don’t need to log anything if there is no HTTP request.
     if (request == null)
         return;

     string UserAgent = request.Headers["User-Agent"];
     string Date = "4/14/2011";//request.Headers["Date"]; 
     ...

Upvotes: 2

Related Questions