main loop - Page 488 - Developer IT

lvalue Required

- by hopefulLLl

Can anyone tell me in simple words that what this L value is and why I'm coming across the error "L Value required in function main()"?

Cannot figure out how to take in generic parameters for an Enterprise Framework library sql statemen

I have written a specialized class to wrap up the enterprise library database functionality for easier usage. The reasoning for using the Enterprise Library is because my applications commonly connect to both oracle and sql server database systems. My wrapper handles both creating connection strings on the fly, connecting, and executing queries allowing my main code to only have to write a few lines of code to do database stuff and deal with error handling. As an example my ExecuteNonQuery method has the following declaration: /// <summary> /// Executes a query that returns no results (e.g. insert or update statements) /// </summary> /// <param name="sqlQuery"></param> /// <param name="parameters">Hashtable containing all the parameters for the query</param> /// <returns>The total number of records modified, -1 if an error occurred </returns> public int ExecuteNonQuery(string sqlQuery, Hashtable parameters) { // Make sure we are connected to the database if (!IsConnected) { ErrorHandler("Attempted to run a query without being connected to a database.", ErrorSeverity.Critical); return -1; } // Form the command DbCommand dbCommand = _database.GetSqlStringCommand(sqlQuery); // Add all the paramters foreach (string key in parameters.Keys) { if (parameters[key] == null) _database.AddInParameter(dbCommand, key, DbType.Object, null); else _database.AddInParameter(dbCommand, key, DbType.Object, parameters[key].ToString()); } return _database.ExecuteNonQuery(dbCommand); } _database is defined as private Database _database;. Hashtable parameters are created via code similar to p.Add("@param", value);. the issue I am having is that it seems that with enterprise library database framework you must declare the dbType of each parameter. This isn't an issue when you are calling the database code directly when forming the paramters but doesn't work for creating a generic abstraction class such as I have. In order to try and get around that I thought I could just use DbType.Object and figure the DB will figure it out based on the columns the sql is working with. Unfortunately, this is not the case as I get the following error: Implicit conversion from data type sql_variant to varchar is not allowed. Use the CONVERT function to run this query Is there any way to use generic parameters in a wrapper class or am I just going to have to move all my DB code into my main classes?

Search Results

Search found 28818 results on 1153 pages for 'main loop'.

Page 488/1153 | < Previous Page | 484 485 486 487 488 489 490 491 492 493 494 495 | Next Page >

- by hopefulLLl

- by KallDrexx

- by amit singh

- by nhaa123

- by al0ne evenings

- by mouthpiec

- by unknownthreat

- by Paul Tarjan

- by MSUDrew

- by Savitha

- by Elijah

- by Alper

- by justinhj

- by alokswain

- by elmaso

- by vincent jacquel

- by Bryan Ward

- by Clacke

- by Aaron Quince

- by sheepez

- by John

- by Justine

- by g-Off

- by Daniel

- by Isuru

< Previous Page | 484 485 486 487 488 489 490 491 492 493 494 495 | Next Page >