doubt in asp.net please solve it

Question

1.00/5 (1 vote)

See more:

i need to display the companyprofile created by a company whem a employer type his username and click on view company profile button.I need to check the username and display the company profile. i written the code as below... but it showing some error.please correct the error...
connectionstring : RegConnectionString
TableName;CompanyProfile

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

public partial class viewcompanyprofile : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CRegConnectionString"].ConnectionString);
SqlCommand com = new SqlCommand("select * from CompanyProfile", con);
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(com);
con.Open();
string uname = com.ExecuteScalar().ToString();
DataSet ds = new DataSet();
if (uname == TextBox9usernam.Text)
{
try
{

com.ExecuteNonQuery();
da.Fill(ds, "CompanyProfile");
con.Close();
TextBox1cmpynm.Text = ds.Tables["CompanyProfile"].Rows[0]["CompanyName"].ToString();
TextBox2briefprofle.Text = ds.Tables["CompanyProfile"].Rows[0]["BriefProfile"].ToString();
TextBox3addr.Text = ds.Tables["CompanyProfile"].Rows[0]["Address"].ToString();
TextBox4state.Text = ds.Tables["CompanyProfile"].Rows[0]["State"].ToString();
TextBox5country.Text = ds.Tables["CompanyProfile"].Rows[0]["Country"].ToString();
TextBox6phno.Text = ds.Tables["CompanyProfile"].Rows[0]["PhoneNo"].ToString();
TextBox7website.Text = ds.Tables["CompanyProfile"].Rows[0]["Website"].ToString();
TextBox8emailid.Text = ds.Tables["CompanyProfile"].Rows[0]["EmailID"].ToString();
con.Close();
}
catch (Exception er)
{
Response.Write("Something really bad happend .....Please try again");
}
}
else
{

Response.Write("some problem");
}
}
}
it is not showing error .and also it is not fetching data and displaying it the textbox...
i give
Company Name:(TextBox)
brief details:(TextBox)

Posted 23-Dec-13 20:07pm

Member 10467514

Updated 24-Dec-13 0:40am

v3

Add a Solution

Comments

thatraja 24-Dec-13 2:11am

what's the error message? Always include that in your question

Member 10467514 24-Dec-13 3:37am

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

public partial class viewcompanyprofile : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegConnectionString"].ConnectionString);
SqlCommand com = new SqlCommand("select * from CompanyProfile", con);
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(com);
string uname = com.ExecuteScalar().ToString();
DataSet ds = new DataSet();
if (uname == TextBox9usernam.Text)
{
try
{
con.Open();
com.ExecuteNonQuery();
da.Fill(ds, "CompanyProfile");
con.Close();
TextBox1cmpynm.Text = ds.Tables["CompanyProfile"].Rows[0]["CompanyName"].ToString();
TextBox2briefprofle.Text = ds.Tables["CompanyProfile"].Rows[0]["BriefProfile"].ToString();
TextBox3addr.Text = ds.Tables["CompanyProfile"].Rows[0]["Address"].ToString();
TextBox4state.Text = ds.Tables["CompanyProfile"].Rows[0]["State"].ToString();
TextBox5country.Text = ds.Tables["CompanyProfile"].Rows[0]["Country"].ToString();
TextBox6phno.Text = ds.Tables["CompanyProfile"].Rows[0]["PhoneNo"].ToString();
TextBox7website.Text = ds.Tables["CompanyProfile"].Rows[0]["Website"].ToString();
TextBox8emailid.Text = ds.Tables["CompanyProfile"].Rows[0]["EmailID"].ToString();
con.Close();
}
catch (Exception er)
{
Response.Write("Something really bad happend .....Please try again");
}
}
else
{

Response.Write("some problem");
}
}
}
"InvalidoperationException was unhandled by usercode
ExecuteScalar requires an open and available connection .The connection's current state is closed"

JoCodes 24-Dec-13 2:44am

Debug , check the error msg and add to question.

3 solutions

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)

Karthik_Mahalingam · Answer 1 · 2013-12-23T21:27:00

Solution 1

Hi Add these lines.

C#

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegConnectionString"].ConnectionString);
       SqlCommand com = new SqlCommand("select * from CompanyProfile", con);
       System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(com);
       DataSet ds = new DataSet();
       con.Open();
       com.ExecuteNonQuery();
       da.Fill(ds, "CompanyProfile");
       con.Close();

Posted 23-Dec-13 21:27pm

Karthik_Mahalingam

Comments

Member 10467514 24-Dec-13 3:37am

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

public partial class viewcompanyprofile : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegConnectionString"].ConnectionString);
SqlCommand com = new SqlCommand("select * from CompanyProfile", con);
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(com);
string uname = com.ExecuteScalar().ToString();
DataSet ds = new DataSet();
if (uname == TextBox9usernam.Text)
{
try
{
con.Open();
com.ExecuteNonQuery();
da.Fill(ds, "CompanyProfile");
con.Close();
TextBox1cmpynm.Text = ds.Tables["CompanyProfile"].Rows[0]["CompanyName"].ToString();
TextBox2briefprofle.Text = ds.Tables["CompanyProfile"].Rows[0]["BriefProfile"].ToString();
TextBox3addr.Text = ds.Tables["CompanyProfile"].Rows[0]["Address"].ToString();
TextBox4state.Text = ds.Tables["CompanyProfile"].Rows[0]["State"].ToString();
TextBox5country.Text = ds.Tables["CompanyProfile"].Rows[0]["Country"].ToString();
TextBox6phno.Text = ds.Tables["CompanyProfile"].Rows[0]["PhoneNo"].ToString();
TextBox7website.Text = ds.Tables["CompanyProfile"].Rows[0]["Website"].ToString();
TextBox8emailid.Text = ds.Tables["CompanyProfile"].Rows[0]["EmailID"].ToString();
con.Close();
}
catch (Exception er)
{
Response.Write("Something really bad happend .....Please try again");
}
}
else
{

Response.Write("some problem");
}
}
}
i added that code and make some changes.then it showed the error
"InvalidoperationException was unhandled by usercode
ExecuteScalar requires an open and available connection .The connection's current state is closed"

Karthik_Mahalingam 24-Dec-13 3:41am

remove these lines
string uname = com.ExecuteScalar().ToString();
if (uname == TextBox9usernam.Text)

Member 10467514 24-Dec-13 3:53am

i made a textbox to enter username.after that i placed the view profile button.to check the user i placed the if(uname....)

Member 10467514 24-Dec-13 3:54am

inside the view profile button i written these codes

Karthik_Mahalingam 24-Dec-13 4:55am

ExecuteScalar will gives you an integer values.
there is no point of comparing this value with the textbox value...
so remove it..

Karthik_Mahalingam 24-Dec-13 4:56am

comment this line

if (uname == TextBox9usernam.Text)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2013-12-23T21:42:00

Solution 2

Quote:
"InvalidoperationException was unhandled by usercode
ExecuteScalar requires an open and available connection .The connection's current state is closed"

It is quite clear.

C#

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegConnectionString"].ConnectionString);
SqlCommand com = new SqlCommand("select * from CompanyProfile", con);
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(com);

con.Open(); // You should open the connection before any ADO.NET Operation.

string uname = com.ExecuteScalar().ToString();

Posted 23-Dec-13 21:42pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Member 10467514 24-Dec-13 4:02am

I addded the con.open(); above the string uname =......
and then debugg it shows again an error.my database name is database.mdf
An attempt to attach an auto-named database for file C:\Users\IT\Documents\Visual Studio 2010\WebSite\Website nw\App_Data\Databasenw.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 24-Dec-13 5:14am

Any of the following may be the problem.

-> Connection String is wrong.
-> The mdf file is corrupted.
-> The file/folder/directory does not have sufficient permission for .NET framework.

An@nd Rajan10 · Answer 3 · 2013-12-23T22:10:00

Solution 3

please mention your error with line and also you write connection in your question because i think error in database, that's may helps get accurate answer..

i will update my answer!!!

Posted 23-Dec-13 22:10pm

An@nd Rajan10

Comments

Member 10467514 24-Dec-13 4:36am

this error msg shown near con.open();

An@nd Rajan10 24-Dec-13 5:12am

con.open(); i did't find the line !! check your code and write your connection string ? please ..

Member 10467514 24-Dec-13 6:41am

i need to display the companyprofile created by a company whem a employer type his username and click on view company profile button.I need to check the username and display the company profile. i written the code as below... but it showing some error.please correct the error...
connectionstring : RegConnectionString
TableName;CompanyProfile

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

public partial class viewcompanyprofile : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CRegConnectionString"].ConnectionString);
SqlCommand com = new SqlCommand("select * from CompanyProfile", con);
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(com);
con.Open();
string uname = com.ExecuteScalar().ToString();
DataSet ds = new DataSet();
if (uname == TextBox9usernam.Text)
{
try
{

com.ExecuteNonQuery();
da.Fill(ds, "CompanyProfile");
con.Close();
TextBox1cmpynm.Text = ds.Tables["CompanyProfile"].Rows[0]["CompanyName"].ToString();
TextBox2briefprofle.Text = ds.Tables["CompanyProfile"].Rows[0]["BriefProfile"].ToString();
TextBox3addr.Text = ds.Tables["CompanyProfile"].Rows[0]["Address"].ToString();
TextBox4state.Text = ds.Tables["CompanyProfile"].Rows[0]["State"].ToString();
TextBox5country.Text = ds.Tables["CompanyProfile"].Rows[0]["Country"].ToString();
TextBox6phno.Text = ds.Tables["CompanyProfile"].Rows[0]["PhoneNo"].ToString();
TextBox7website.Text = ds.Tables["CompanyProfile"].Rows[0]["Website"].ToString();
TextBox8emailid.Text = ds.Tables["CompanyProfile"].Rows[0]["EmailID"].ToString();
con.Close();
}
catch (Exception er)
{
Response.Write("Something really bad happend .....Please try again");
}
}
else
{

Response.Write("some problem");
}
}
}
it is not showing error .and also it is not fetching data and displaying it the textbox...
i give
Company Name:(TextBox)
brief details:(TextBox)
Improve question Permalink

An@nd Rajan10 24-Dec-13 5:19am

Please update your question