How to run sql file in asp.net

Do not run this file manually. You may want to check if the sql server agent is installed and if so check if it is disabled by going into the services list. The content you requested has been removed. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. It's unclear what the type if pic is - you are passing a string but I can;t tell of the column stores a file path or if you are indending to serialize the file and store it in a pinary field.

Please check take a look at your Insert statement, it looks like that you provided password value twice. You have the wrong number parameters in your insert statement.

For clarity, why not use string. Format to keep everything uniform? Assuming these are all string types. However, it also looks like you probably want to include that 5th parameter as well - just extend the format :.

Since most of the answers failed to address the SQL Injection vulnerability, here's an example with parameterized queries.

In addition to preventing SQL Injection attacks, it also makes it easier to troubleshoot these types of issues, and you don't need to worry about quoting or not quoting parameters. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 5 years, 9 months ago. Active 5 years, 9 months ago. Viewed 5k times. But when I run the code, I get this Exception on: command.

ExecuteNonQuery ; Description : An unhandled exception occurred during the execution of the current web request. OleDbConnection ; connection. OleDbCommand ; command. Open ; command. Name required. Follow Following. Ben Join other followers. Sign me up.

Already have a WordPress. Log in now. Loading Comments Email Required Name Required Website. Post was not sent - check your email addresses!

See more: C. I have a. How can i run this. For ex: state. Can any one help.. Posted Mar am Minaxi Sajwan. Add a Solution. Accept Solution Reject Solution. You need to specify file name and then first read it's content in a string and then execute CommandText command. PS: this will work as long you don't have GO statement in your sql script. Since SQL Server , one can use smo library to do this operation and not use batch command and osql connection as previously.

Here is how to do it: C. Copy Code.