An exception of type 'System.ArgumentException' occurred in System.Dat

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class AddStudentRecord : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Submit_Click(object sender, EventArgs e)
{
// string name = Name.Text;
}
protected void submit_Click(object sender, EventArgs e)
{
string con = " DataSource=BIJENDER-PC\\SQLSERVER;Initial Catalog = Batch_17028";
SqlConnection db = new SqlConnection(con);
db.Open();
//tring insert = "insert into tbl_user (u_fname,u_lname,u_contact,u_email) values ('"+txtFname.Text+"','"+txtLname.Text+"','"+txtContact.Text+"','"+txtEmail.Text+"')";
string insert = "insert into Student_Bio_Data (STD_Name) values ('" + name.Text +"')";
SqlCommand cmd = new SqlCommand(insert,db);
int m = cmd.ExecuteNonQuery();
if(m != 0)
{
//Response.Write("
//
//");
}
else
{
//Response.Write("
//
//");
}
db.Close();
}
}

NEXT ERROR IS : An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class AddStudentRecord : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Submit_Click(object sender, EventArgs e)
{
// string name = Name.Text;
}
protected void submit_Click(object sender, EventArgs e)
{
// string con = " DataSource=BIJENDER-PC\\SQLSERVER;Initial Catalog = Batch_17028";
string con = @"Data Source=BIJENDER-PC\SQLSERVER,1433;Persist Security Info=True;Initial Catalog = Batch_17028";
SqlConnection db = new SqlConnection(con);
db.Open();
//tring insert = "insert into tbl_user (u_fname,u_lname,u_contact,u_email) values ('"+txtFname.Text+"','"+txtLname.Text+"','"+txtContact.Text+"','"+txtEmail.Text+"')";
string insert = "insert into Student_Bio_Data (STD_Name) values ('" + name.Text +"')";
SqlCommand cmd = new SqlCommand(insert,db);
int m = cmd.ExecuteNonQuery();
if(m != 0)
{
//Response.Write("
//
//");
}
else
{
//Response.Write("
//
//");
}
db.Close();
}
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ashutosh Gupta5y ago
Accepted answer
try this
string con = @"Data Source=BIJENDER-PC\SQLSERVER,1433;Persist Security Info=True;Initial Catalog = Batch_17028"
0
Ashish sharma5y ago
NEXT ERROR IS : An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code
using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

public partial class AddStudentRecord : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Submit_Click(object sender, EventArgs e)

{

// string name = Name.Text;

}

protected void submit_Click(object sender, EventArgs e)

{

// string con = " DataSource=BIJENDER-PC\\SQLSERVER;Initial Catalog = Batch_17028";

string con = @"Data Source=BIJENDER-PC\SQLSERVER,1433;Persist Security Info=True;Initial Catalog = Batch_17028";

SqlConnection db = new SqlConnection(con);

db.Open();

//tring insert = "insert into tbl_user (u_fname,u_lname,u_contact,u_email) values ('"+txtFname.Text+"','"+txtLname.Text+"','"+txtContact.Text+"','"+txtEmail.Text+"')";

string insert = "insert into Student_Bio_Data (STD_Name) values ('" + name.Text +"')";

SqlCommand cmd = new SqlCommand(insert,db);

int m = cmd.ExecuteNonQuery();

if(m != 0)

{

//Response.Write("

//

//");

}

else

{

//Response.Write("

//

//");

}

db.Close();

}

}
0
Sachin Singh5y ago
copy the connection string properly from properties of database,
you are missing integrated security=true if you are using windows login if you use username and password then specify that, in other words copy connection string completely and paste full connectionstring.
0