ASP.NET

error creating control crystalreportsector.

3-Apr-07 21:47

This pronblem is solved by setting the frameborder=0 or frameborder=1, before I set it as frameborder=no.

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group

rutav3-Apr-07 19:00

rutav

3-Apr-07 19:00

hello,
i got error message while creating cotrol in visual studio 2003(ASP.NET)

what is GUID ?

siddisagar3-Apr-07 18:50

siddisagar

3-Apr-07 18:50

Hi All,

what is GUID ?

Thanks

Re: what is GUID ?

enjoycrack3-Apr-07 18:57

enjoycrack

3-Apr-07 18:57

hi there:
Short for Globally Unique Identifier, more information http://www.webopedia.com/TERM/G/GUID.html[^]

<< >>

8x Solutions Ltd

Need Answer

siddisagar3-Apr-07 18:00

siddisagar

3-Apr-07 18:00

Hi All,

What is the Difference between Unit Testing and UserAcceptanceTesting.
Tell me Briefly what we have to do in UserAcceptanceTesting.It is also related to Testing pages ?

Thanks inAdvance

Re: Need Answer

Colin Angus Mackay3-Apr-07 21:11

Colin Angus Mackay

3-Apr-07 21:11

siddisagar wrote:
What is the Difference between Unit Testing and UserAcceptanceTesting.

Unit testing is testing the individual units of an application, preferably in isolation. This ensures that all (or almost all) the code is exercised and producing the correct results.

User Acceptance Testing is just as the name suggests. It is testing performed by the users so that they may determine if the software is acceptable.

siddisagar wrote:
Tell me Briefly what we have to do in UserAcceptanceTesting

Give the software to the users. Ask them to perform the tasks that they wish to do with the software. Get them to report on anything that does not work.

Upcoming events:
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)
* Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects

My website

help me check my executescaler

neodeaths3-Apr-07 17:50

3-Apr-07 17:50

SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"));<br />
SqlCommand command = new SqlCommand("Select CurrentNo From LookUpID Where TypeID = 'AuctionSessionID'",conn);<br />
<br />
        string result = command.ExecuteScalar().ToString();<br />
        Label2.Text = result;

y does it keep saying Error 9 'System.Configuration.ConfigurationSettings.AppSettings' is a 'property' but is used like a 'method'

i am using asp.net2

and my web.config connection is:

<connectionStrings><br />
  <add name="HASDBConnectionString1" connectionString="Data Source=----\SQLEXPRESS;Initial Catalog=HASDB;Persist Security Info=True;User ID=---;Password=----"<br />
   providerName="System.Data.SqlClient" /><br />
 </connectionStrings>

enjoycrack3-Apr-07 17:59

enjoycrack

3-Apr-07 17:59

hi there:

try this ConfigurationSettings.AppSettings["ConnectionString"];

<< >>

8x Solutions Ltd

neodeaths3-Apr-07 18:46

3-Apr-07 18:46

SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);<br />
        SqlCommand command = new SqlCommand("Select CurrentNo From LookUpID Where TypeID = 'AuctionSessionID'",conn);<br />
        conn.Open();<br />
        string result = command.ExecuteScalar().ToString();<br />
        Label2.Text = result;<br />
        conn.Close();

error: The ConnectionString property has not been initialized

erm.. just to chk my ConfigurationManager.AppSettings["ConnectionString"]);
the connectionstring remain? in regards to my original post.

enjoycrack3-Apr-07 18:54

enjoycrack

3-Apr-07 18:54

there is no name ConnectionString in your web.config right?
I saw it was HASDBConnectionString1, so just try to use this name instead of ConnectionString

<< >>

8x Solutions Ltd

neodeaths3-Apr-07 19:37

3-Apr-07 19:37

its still the same saying it has not been initialise...

is executedscaler very hard to use?

i been trying out for veri long still cannot work

the asp.net2 developers makes displaying multiple data in datagrid so easy yet they forgot to make dispalying single data easy.....

Venkatesh Mookkan3-Apr-07 18:52

3-Apr-07 18:52

For,

neodeaths wrote:
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"));

Use,
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"]);

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group

neodeaths3-Apr-07 19:11

3-Apr-07 19:11

 SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"]);<br />
<br />
        SqlCommand command = new SqlCommand("Select CurrentNo From LookUpID Where TypeID = 'AuctionSessionID'",conn);<br />
        conn.Open();<br />
        string result = command.ExecuteScalar().ToString();<br />
        Label2.Text = result;<br />
        conn.Close();

error:Error 59 Argument '1': cannot convert from 'System.Configuration.ConnectionStringSettings' to 'string'

and

Error 58 The best overloaded method match for 'System.Data.SqlClient.SqlConnection.SqlConnection(string)' has some invalid arguments

now these 2 errors...

Venkatesh Mookkan3-Apr-07 19:42

3-Apr-07 19:42

Can you send the content of your web.config file? I have a doubt whether you have the key with name "ConnectionString"...

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group

neodeaths3-Apr-07 20:10

3-Apr-07 20:10

please know taht i am using asp.net2 (2005) with sql server 2005 thx

<?xml version="1.0" encoding="utf-8"?><br />
<configuration xmlns=<br />
"http://schemas.microsoft.com/.NetConfiguration/v2.0"><br />
  <connectionStrings><br />
    <add name="HASDBConnectionString1" connectionString="Data Source=------\SQLEXPRESS;Initial Catalog=HASDB;Persist Security Info=True;User ID=sa;Password=---"<br />
     providerName="System.Data.SqlClient" /><br />
  </connectionStrings><br />
  <system.web><br />
    <authorization><br />
      <allow roles="Registrator" /><br />
      <deny users="*" /><br />
    </authorization><br />
  </system.web><br />
</configuration>

the above is my web.config in the subfolder where the page i am working on is

<?xml version="1.0"?><br />
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"><br />
	<connectionStrings><br />
  <add name="HASDBConnectionString1" connectionString="Data Source=---\SQLEXPRESS;Initial Catalog=HASDB;Persist Security Info=True;User ID=sa;Password=---"<br />
   providerName="System.Data.SqlClient" /><br />
 </connectionStrings><br />
 <system.web><br />
<br />
   <membership defaultProvider="MyMembershipProvider"><br />
     <providers><br />
       <add name="MyMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="HASDBConnectionString1" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" /><br />
     </providers><br />
   </membership><br />
   <br />
<br />
     <br />
     <br />
		<roleManager enabled="true" defaultProvider="MyMembershipProvider"><br />
     <providers><br />
       <add name="MyMembershipProvider" connectionStringName="HASDBConnectionString1" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /><br />
       <add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /><br />
     </providers><br />
   </roleManager><br />
		<authentication mode="Forms" /><br />
		<compilation debug="true"/><br />
    <authorization><br />
<br />
      <deny users="?" /><br />
    </authorization><br />
   <br />
  </system.web>  <br />
  <system.net><br />
<br />
    <mailSettings><br />
<br />
      <smtp><br />
        <network host="my.mail.server" /><br />
      </smtp><br />
    </mailSettings><br />
  </system.net><br />
</configuration>

this is the web.config of my main project

SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionStrings"]);<br />
        SqlCommand command = new SqlCommand("Select CurrentNo From LookUpID Where TypeID = 'AuctionSessionID'",conn);<br />
        conn.Open();<br />
        string result = command.ExecuteScalar().ToString();<br />
        Label2.Text = result;<br />
        conn.Close();

The ConnectionString property has not been initialized.

neodeaths3-Apr-07 20:38

3-Apr-07 20:38

SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["connectionStrings"]);

by the way for my knowledge =P

what does the above code the part where i underline stand for?

is it something in the web.config?
or an variable?

Venkatesh Mookkan3-Apr-07 21:14

3-Apr-07 21:14

neodeaths wrote:
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["connectionStrings"]);

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["HASDBConnectionString1"]);

Do not use ~~ConfigurationManager.AppSettings~~ as you have placed the key inside connectionStrings section of the configuration file.

neodeaths wrote:
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionStrings"]);

The ConnectionString is the key name you specified in the web.config file in the connectionStrings section. In your configuration file you are using HASDBConnectionString1 as the key name.

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group

neodeaths3-Apr-07 21:23

3-Apr-07 21:23

firstly:

after i change it to<br />
 SqlConnection conn = new SqlConnection("HASDBConnectionString1 ");<br />
        SqlCommand command = new SqlCommand("Select CurrentNo From LookUpID Where TypeID = 'AuctionSessionID'",conn);

i changed it to the above code and a new error appear at runtime.

Format of the initialization string does not conform to specification starting at index 0.

2nd:
so if i get u rite the configurationmanager.appsetting is a method that will use the specified connectionstring which is in the root folder?

3rd: i appreciated ur pateint with my noobish question =)

Venkatesh Mookkan3-Apr-07 21:34

3-Apr-07 21:34

neodeaths wrote:
SqlConnection conn = new SqlConnection("HASDBConnectionString1 ");

This is wrong. I am afraid whether you know .NET or not.

Use like this,
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["HASDBConnectionString1"]);

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group

neodeaths3-Apr-07 21:43

3-Apr-07 21:43

!! it works now thx
SqlConnection conn = new SqlConnection((ConfigurationManager.ConnectionStrings["HASDBConnectionString1"]).ToString());

and by the way the first argument need to be change to a string first be4 used

but thx for everything really appreiciated it

at the mean time i am gonna go read and test the executescaler method more thx alot

Colin Angus Mackay3-Apr-07 21:14

Colin Angus Mackay

3-Apr-07 21:14

It is something in the web.config. If it doesn't exist then your code won't work. You really should abstract that kind of all out into a configuration class that can handle events such as missing configuration elements.

Upcoming events:
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)
* Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects

My website

Accessing IIS server from other computers..

meghak3-Apr-07 21:47

meghak

3-Apr-07 21:47

hi,
If you are using Asp.Net 2.0 your code
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"));

should be
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToString());

next I dont know abt the code you are using in web.config if it can work that way but here is what I use
<configuration>
<appSettings>
<add key="connectionString" value="initial catalog=----;data source=---;user id=---;password=---;">
</add>
</appSettings>
</configuration>

try by changing the first code only see if that works

Regards,
Maggi

MinhajuddinK3-Apr-07 16:28

MinhajuddinK

3-Apr-07 16:28

Hi there!
I have deployed my site on an IIS server.
And its working fine.
But I don't know how to access it from other machines..
I have tried accessing by

http://192.168.1.28
where the number is the IP of the IIS server.
Thanks for your help..

You don't have to be ~~AFRAID!~~

Re: Accessing IIS server from other computers..

N a v a n e e t h3-Apr-07 17:11

N a v a n e e t h

3-Apr-07 17:11

Try like this

http://192.168.1.28/yourvirtualdirectory/home.aspx

OR

http://yoursysname/yourvirtualdirectory/home.aspx

printf("Navaneeth!!")

www.w3hearts.com

Re: Accessing IIS server from other computers..

Venkatesh Mookkan3-Apr-07 18:56