Hi,
I am using Microsoft Application Blocks and I have the following query.
//save the data
insertSQL = "INSERT INTO Table1 VALUES (" + unixTime + "," + CCR + ","
+ CCT + "," + CCT + ",'" + completedBy + "','" + id + "',100, 'test',
'test')";
SqlHelper.ExecuteNonQuery (objConnect, CommandType.Text, insertSQL);
Is there anyway to break up the above so it is cleaner and I just pass
the parameters instead of building the query? The above does do the
work but is not cleaner and I need to use the same query somewhere else
too.
Thanks for the help
Shahid