adam_k

[CODE]select security into [/CODE] will result in a table with a column named security. Unfortunately this will only run once, as the second time around the table will exist and you'll receive an error. If you intend user_sec to be a variable, you need to declare it and use the …

I'm guessing the program you want to hide is the keylogger in your previous post?

You are not showing what you are using to populate calldate, so I'm skipping it. Instead go with getdate(), but use it with [CODE]convert(char(10),getdate(), )[/CODE] and add the appropriate date style. You can look it up here [url]http://msdn.microsoft.com/en-us/library/aa226054(v=sql.80).aspx[/url]

I'll agree with the settings approach, but it will take a bit more than that. Start by going to your project properties, select the settings tab and create a new setting, naming it hide_panel for now Go the "Settings" form and use this code [CODE] If CheckBox1.Checked = True Then …

use both Unhnd_Exception's posts to get your results. You need both the & and the vbcrlf (or just a space before where) AND single quotes around BASIC MIDWIVES.

I'm getting outside my area of expertise here, so this could be completely rubish... Would handling this data (code, date, value) as dimensions of a cube solve this need?

Try running your program as Administrator. It should be one of the security features that is stopping you. You could try working in the documents folder, in order to avoid having to run it as Administrator.

What is GCR_ICDataSet1 and how is this connected to your table?

Sounds like your sproc is expecting the @pFilePathName parameter, which you are not providing. It could just be that you've declared the filename as @pFilePathName in your sproc and you are passing it as @pCSVFile in your VB.

My guess is that you've gone wrong here: [CODE] ElseIf ViewState.Item("Getnameload").ToString = "True" Then[/CODE] I can't really see a path where the getname would fire as I can't find where [CODE]ViewState.Item("nameload").ToString = "True"[/CODE] this would result in TRUE, but so I can't find a path where the elseif condition would …

I believe that you are getting the error because you are starting the transaction in the SQL command and not the connection. I don't have .Net available right now to check and present you the code, but I would try to start the transaction with the connection and use that …

Why don't you create a local batch file, containing the pushd command and the batchfile and execute it locally?

In MS SQL Server Management Studio: Right click the view and select script view as > create to > New Query Editor Window. A more "advanced" approach is to visit sys.sql_modules (I'm not sure about the modules part of the table).