Compilation error in line no 1 in vb.net

Question

1.00/5 (1 vote)

See more:

Dear friends I am getting compilation error line no 1, please make the correction,

Thank you.

VB

Imports System.Collections.Generic
Imports System.Linq
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Data.SqlClient
Imports System.Configuration

Public Partial Class Registration
	Inherits System.Web.UI.Page
	Protected Sub Page_Load(sender As Object, e As EventArgs)

	End Sub
	Protected Sub Button1_Click(sender As Object, e As EventArgs)
		Dim conn As New SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename="|DataDirectory|Copy of Regstr.mdf";Integrated Security=True;User Instance=True")
		conn.Open()

		Dim cmd As New SqlCommand((((((((("insert into Register values ('" + DropDownListdept.Text & "','") + txtempname.Text & "','") + DropDownListDesign.Text & "','") + DropDownListdays.Text & "','") + txtfrm.Text & "','") + txtto.Text & "','") + DropDownListleave.Text & "','") + txtresonforleav.Text & "','") + txtincharge.Text & "')", conn)


		cmd.ExecuteNonQuery()
		conn.Close()

		Label1.Text = "Your Data Stored Successfully"
	End Sub
End Class

Posted 7-Sep-12 23:11pm

Shiva from Bangalore, Karnataka

Updated 8-Sep-12 0:06am

André Kraak

v2

Add a Solution

Comments

bbirajdar 8-Sep-12 5:34am

At this line 'Imports System.Collections.Generic' ?

Menon Santosh 8-Sep-12 6:03am

post your error

Shiva from Bangalore, Karnataka 9-Sep-12 0:21am

this is error;

Server Error in '/Mahesh' Application.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0116: A namespace cannot directly contain members such as fields or methods

Source Error:

Line 1: Option Explicit On
Line 2: Imports Microsoft.VisualBasic
Line 3: Imports System.Collections.Generic

[no name] 8-Sep-12 9:14am

Probably somewhere in this horrid line of code: Dim cmd As New SqlCommand((((((((("insert into Register values ('" + DropDownListdept.Text & "','") + txtempname.Text & "','") + DropDownListDesign.Text & "','") + DropDownListdays.Text & "','") + txtfrm.Text & "','") + txtto.Text & "','") + DropDownListleave.Text & "','") + txtresonforleav.Text & "','") + txtincharge.Text & "')", conn)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thomas Daniels · Answer 1 · 2012-09-08T04:17:00

The problem is in this line:

VB

Dim conn As New SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename="|DataDirectory|Copy of Regstr.mdf";Integrated Security=True;User Instance=True")

Change that into this:

Dim conn As New SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=""|DataDirectory|Copy of Regstr.mdf"";Integrated Security=True;User Instance=True")

Hope this helps.