Showing posts with label form. Show all posts
Showing posts with label form. Show all posts

Thursday, March 29, 2012

formula in sql server

hi,
my users can make posts in my web application, i mean they fill a form and the information they filled will be saved in sql server 2000 and can be shown in web application,now i want to give each post an Id and save it in the database, how can i do that? does sql server have the abilities or i should do sth in my c# application

thanx

This is something that is best to let the database handle for you.

Set your ID column as an Identity column in your sql table.

Sql server will then set its value to a unique auto incrementing value automatically every time a new row is inserted.

Tuesday, March 27, 2012

Forms Authentication...Can it really be done?

I could really use help getting form authentication to work. I have a box with a web site and ReportingServices installed(which if I can get this working will be moved to the DMZ). The databases are on a different machine(which will on on our network).

I have been working with the sample provided with the install and this blog.

http://blogs.msdn.com/bimusings/archive/2005/12/05/500195.aspx

My problem is that I can logon and authenticate but when I call ListChildren() my System.Net.CredentialCache.DefaultCredentials is empty so I get nothing back from the call.

I know that I have a valid cookie because after I logon I can use the Reports and the ReportServer URL's and go directly to those pages.

Can someone tell me what I need to do to make ListChildren() work? Do I still call ListChildren()? Documentation is scarce and would appreciate any help provided.

Thanks

-JW

I was afraid I wouldn't get a response to this.

Can anyone help?

Forms authentication security

I have followed exactly what the MSDN white paper asked to implement the Form
based security. I have created the useraccount database,registered few new
users in there and then logged in the RS Report Manager and gave the browser
rights to the new users on a folder and reports which all works fine.But when
I log in with the new registered user I can log in the Report manager but the
page does not display any reports or folders!! what am I doing wrong please
help!!!Hi shabab where u got that information i.e formbased security.
can pls refer that link?
Thanks!
simmi
"shahab" wrote:
> I have followed exactly what the MSDN white paper asked to implement the Form
> based security. I have created the useraccount database,registered few new
> users in there and then logged in the RS Report Manager and gave the browser
> rights to the new users on a folder and reports which all works fine.But when
> I log in with the new registered user I can log in the Report manager but the
> page does not display any reports or folders!! what am I doing wrong please
> help!!!|||for example, Forms Authentication). Here's
a white paper that can get you started
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
also there is one very nice article extended on this white paper which is
published on devex. go to google and search for form based authentication in
MS RS...its by Harden ..let me know if you can find otherwise I will dig into
my favourites and let you know.
good luck
"simmi" wrote:
> Hi shabab where u got that information i.e formbased security.
> can pls refer that link?
> Thanks!
> simmi
> "shahab" wrote:
> > I have followed exactly what the MSDN white paper asked to implement the Form
> > based security. I have created the useraccount database,registered few new
> > users in there and then logged in the RS Report Manager and gave the browser
> > rights to the new users on a folder and reports which all works fine.But when
> > I log in with the new registered user I can log in the Report manager but the
> > page does not display any reports or folders!! what am I doing wrong please
> > help!!!

Monday, March 26, 2012

Formatting text within a text box

Trying to use this tool to create a form letter. I have a text box that has a paragraph of data within that paragraph I'd like to bold a word or underline a word. Is this just a gross misuse of this tool or is there a way to format text within the text box?Unfortunately, Reporting Services alone does not support richly formatted text, such as html or rtf. This is slated for a future release.

In the meantime, if you want to output to Word or Excel, you can use a 3rd party tool, OfficeWriter from SoftArtisans. OfficeWriter

lets you preserve all Excel and Word formatting.

http://officewriter.softartisans.com/officewriter-250.aspx

Ian|||I see other references to this being slated for a future release from last year. Do you know ballpark when that will be? Sometime 07 or later this year?|||

Hi Ran,

Can you tell us roughly when RTF feature would be available? In 6 months? One year? We're using Reporting Services extensively. The missing RTF feature is really painful.

Thanks!

Formatting text within a text box

Trying to use this tool to create a form letter. I have a text box that has a paragraph of data within that paragraph I'd like to bold a word or underline a word. Is this just a gross misuse of this tool or is there a way to format text within the text box?Unfortunately, Reporting Services alone does not support richly formatted text, such as html or rtf. This is slated for a future release.

In the meantime, if you want to output to Word or Excel, you can use a 3rd party tool, OfficeWriter from SoftArtisans. OfficeWriter

lets you preserve all Excel and Word formatting.

http://officewriter.softartisans.com/officewriter-250.aspx

Ian|||I see other references to this being slated for a future release from last year. Do you know ballpark when that will be? Sometime 07 or later this year?|||

Hi Ran,

Can you tell us roughly when RTF feature would be available? In 6 months? One year? We're using Reporting Services extensively. The missing RTF feature is really painful.

Thanks!

Friday, March 23, 2012

Formatting part of a text box

hey all,

does anyone know of a way to format part of a text box in sql reporting services 2005? i am creating a form letter and need to concatenate static text with a column and need just the column value to be bold. like this:

"This letter is confirmation that Acme Agency has been chosen..."

my expression to build this is:

="This letter is confirmation that " + Fields!agency_name.Value + " has been chosen..."

Is there a way to apply formatting just to Fields!agency_name.Value ?

thanks!

jen

Sorry, this is currently not supported.

-- Robert

|||Unable to format individual words within a text is avoiding us to totally move from Business Objects and Crystal Reports to SSRS. Is there a workaround or is it expected in a future release?

Thanks,

Jeroen van der Wal
BI Consultant

|||

It is on the list for a future release. You might want to check out related threads on the SSRS 2008 forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1

-- Robert

Formatting part of a text box

hey all,

does anyone know of a way to format part of a text box in sql reporting services 2005? i am creating a form letter and need to concatenate static text with a column and need just the column value to be bold. like this:

"This letter is confirmation that Acme Agency has been chosen..."

my expression to build this is:

="This letter is confirmation that " + Fields!agency_name.Value + " has been chosen..."

Is there a way to apply formatting just to Fields!agency_name.Value ?

thanks!

jen

Sorry, this is currently not supported.

-- Robert

|||Unable to format individual words within a text is avoiding us to totally move from Business Objects and Crystal Reports to SSRS. Is there a workaround or is it expected in a future release?

Thanks,

Jeroen van der Wal
BI Consultant

|||

It is on the list for a future release. You might want to check out related threads on the SSRS 2008 forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1

-- Robert

Formatting part of a text box

hey all,

does anyone know of a way to format part of a text box in sql reporting services 2005? i am creating a form letter and need to concatenate static text with a column and need just the column value to be bold. like this:

"This letter is confirmation that Acme Agency has been chosen..."

my expression to build this is:

="This letter is confirmation that " + Fields!agency_name.Value + " has been chosen..."

Is there a way to apply formatting just to Fields!agency_name.Value ?

thanks!

jen

Sorry, this is currently not supported.

-- Robert

|||Unable to format individual words within a text is avoiding us to totally move from Business Objects and Crystal Reports to SSRS. Is there a workaround or is it expected in a future release?

Thanks,

Jeroen van der Wal
BI Consultant

|||

It is on the list for a future release. You might want to check out related threads on the SSRS 2008 forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1

-- Robert

sql

Sunday, February 19, 2012

Form with 20,500 Fields

I'm running SQL Server 2000. I have an interesting form I am creating for a client which has on it literally 20,500 fields that need to be stored in the system which I then have to create reports off of for statistics and trends.

I'm not sure how I should go about storing that large amount of information in SQL Server with the limitations of the size of a table. Would it be best to create 20 some tables to store it, or is there a better fashion to store it. 90% of the fields are numbers ranging from 0 to 100.

Thanks for any suggestions you can come up with!What the hell does the form do?

Does anyone enter 20k+ fields?

If not and you populate it, who's gonna read it?

Anyway, what language are you using?

Sounds like you are thinking that the form is like 1 row...Is there anything else about the data that looks like a Key?

Is it really n sets of info tied together with the pageid?

I guess it goes back to what the form contains...

WOW

Never seen this before...|||20,500 fields ...

Man... i would really go down to sleep filling such a big form :)|||Believe it or not we're not going to populate it. We're a mysteryshopping firm and we're going to be paying an auditor to collect sales trend information and they're going to be going online and submitting this information. Typically we're using VB/ASP for coding. There is a JobID that is used for a key and is referenced throughout the DB, and a StoreID that is going to be used to link to our properties that can't really break up the large amount of data I need to collect.

The form is created already, I just don't know the best way to try and store it since it is all pertaining to one area of information, sale prices and percentages.|||Got a data modeler on staff?

You located in the Northeast?

What type of information are they going to be enetering?

You'll also need to think about data retrieval and data mining probably...

Man that's a BIG denormalized form|||You seriously need to rethink your design.

Seriously.|||NW Ohio is where we are located. They open the form with a JobID that has been assigned to them. The form opens displaying the location they were to have gone to and collected information about throughout the week.

They enter in each rack type encountered in a store (rolling racks, clearence racks, round racks) things that would hold stock (be it clothing or clocks) this is a dropdown of all the different types of racks and is being stored as a number.

Each rack then has associated sale amounts stored in either an Original Price, and sale percentage, the markdown price, and sale percentage, or just the sale percentage itself. Then the density of each rack is stored as a number (1 - 10) and a description dropdown is available containing the types of items they will encounter (given values 1-37). This data comprises about 20,000 of the rows.

The other 500 are mostly yes/no questions pertaining to the sales.|||Somebody's actually gonna fill up the fields ... wow !!!|||OK...when you say 20,000 rows...there you go...

Each row seems to be made up of only a handful of elements...those elements seem to describe a "rack"

You'll need a table for your rack

I'm laughing when I'm typing this now...wow what a rack...

anyway, you'll have other ancillary tables that hold the rack type, store id, ect...

First thing to do is list all of the unique elemenst, then categorize them in to entities...they'll became your tables...

Make sense?|||Yes and no... I was hoping to get around having to create 10 tables to store and reference the data. It seems like it would be easier to have a table with these columns:

Job ID, Rack_Type1_1, Rack_Density1_1, Rack_Items1_1, Rack_Org_Price1_1, Rack_Markdown_Price1_1, Rack_Markdown_Percentage1_1, Rack_Descriptor1_1, Rack_Type1_2, Rack_Density1_2, Rack_Items1_2, Rack_Org_Price1_2, Rack_Markdown_Price1_2, Rack_Markdown_Percentage1_2, Rack_Descriptor1_2

and so on... until I got to Rack_Type5_500, Rack_Density5_500, Rack_Items5_500, Rack_Org_Price5_500, Rack_Markdown_Price5_500, Rack_Markdown_Percentage5_500, Rack_Descriptor5_500

assuming 5 possible stores in the mall selected out of 12, and up to 500 different sales for the racks in each store.

Even if I break it down into 5 tables holding individual store data, it's still too many columns. That would still be 4,000 columns.|||You know EXECL right?

Your'e thinking Horizontally...you need to think vertically...

CREATE TABLE [WhatARack!] (
StoreId int
, RackId int
, Rack_Price money
, Rack_Density int
. Rack_WhateverPropertyYouNeedToCapture varchar(10)
)

Where you say _1 that would be an INSERT and 1 row would go in..._500 would be an insert and that would be row 500

Is there a way to id the racks?

If not, maybe you can use IDENTITY...but I usually like to define natural keys (things that make a unique description about things)

Make sense?|||Originally posted by bornweb
NW Ohio is where we are located.

You blind dude...go hope in the car and help this guy/gal out...|||I think I know what you mean. Just seems kind of strange.

Guess i'm used to the normal one page forms they throw at me here where I create one small client_name table with 75 fields or so that I link to my Invoices, Clients, Contacts, Properties, Auditors table for reporting.

Now to have to create a few tables to replace the normal client_name table and having to link those into the other tables I listed above to store and view data, well that just seems evil!

But that's cool. Better than the other suggestion I got from a programmer here. ("Oh just make an array.")

Thanks again,
Nickolas Smith|||Originally posted by bornweb
I think I know what you mean. Just seems kind of strange.

Guess i'm used to the normal one page forms they throw at me here where I create one small client_name table with 75 fields or so that I link to my Invoices, Clients, Contacts, Properties, Auditors table for reporting.

Now to have to create a few tables to replace the normal client_name table and having to link those into the other tables I listed above to store and view data, well that just seems evil!

But that's cool. Better than the other suggestion I got from a programmer here. ("Oh just make an array.")

Thanks again,
Nickolas Smith

Dude,

What language is the fron end written in?

Are you using recordsets?|||One giant web application wrote in VB and Java. Using ASP and ADO.

If you're referring to just this one form it's basically an ASP page submitting to itself where i'm going to use VBS/ADO to insert the objects.|||All I can say, Damn! I'm glad I'll never have to deal with this database...

Model the thing like Brett has suggested otherwise it's going to hell in a hand cart real fast...|||The database isn't that bad and is split-up into many tables, the database itself has presently 13,423 tables in it storing data, and data in one table is rarely repeated in another.

Just never had an instance like this where I had so many fields relating to the same thing that wasn't easily decernable into seperate tables.|||Well you should definately split things so that rack is a seperate table and location...

not sure what else without re-reading...|||No offense to bornweb,
But I'm betting no one will use the form!. 20K fields????
Heck even a hundred is unimaginable.......

Again..just voicing out.....don't bother me...|||:) You'd be surprised what people with no other job than mysteryshopping will do for money, especially when they're paid by hour (including the time it takes to fill out the online form).

And I should note that not all 20k fields are required. It is possible that their would only be a hundred or so. But there is the possibility that much much more data can be collected.|||They may use the form, but experience shows that the more difficult, arduous, and confusing the data entry process is, the lower the quality of data you receive.

A from with 20,000+ fields? A database with 13,000+ tables? I went to your website (it looks cool) and got the impression that this database will be accessed not only by your mystery shoppers, but also by your customers for both canned and ad-hoc reporting. Problems in your database design are definitely going to affect both the performance and functional limitations of this client-facing database.

If this database is as critical to your business as it appears, I strongly encourage you to seek the assistance of an experience database designer before interface development locks you into a schema.|||Guys/Gals,

It's NOT 20K Columns...it's ROWS...

Just curious, how long have you been a developer...(and I'm really trying hard not to sound like an ass...I know, I know, somethings are really hard for me...)

Been a LONG time from doing front end work, but really, You should have 1 row, ...they do entry, bam, commit it....

And back to the part about retrieval...how can the edit the data when the f-ck up?

And you know they're gonna...|||REally. It sounds like someone needs to learn how to design dynamic forms. Either what Bret suggested, or, something like...

Click Add button adds an editable row with Save and Cancel buttons.

After save, existing rows are displayed with Edit button on each for correction.

Again, click Add button for new row of data.

You could even have a grid display the existing data and a more intuative data entry form layout for new/edit data.

Oh, and the "just make an array" guy should be canned. Proper object oriented design should meld well with database design.|||Originally posted by bpdWork
Oh, and the "just make an array" guy should be canned. Proper object oriented design should meld well with database design.

Actually, don't the 2 NOT blend...I don't mind the array thing (although with 20k, you should worry about memory..)

You'd just loop throu the INSERTS...

PLEASE use sprocs though...

on second thought a singleton INSERT is an INSERT and probably would see an perf boost...

Where's the web site?

Can I get a deal on a new ski jacket?

How about a Margaritta set?

Or forget the set, how about a deal on a 1.75 of to-kill-ya

Form view/sqlexpress/

i getting the following error message in runtime, i have no idea what my username and password is for my computer, does anyone know what this error message means, and how i can get my username and password.

Server Error in '/' Application.

Cannot open user default database. Login failed.
Login failed for user 'ACER-0BCB4DEC3A\ASPNET'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'ACER-0BCB4DEC3A\ASPNET'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:

[SqlException (0x80131904): Cannot open user default database. Login failed.Login failed for user 'ACER-0BCB4DEC3A\ASPNET'.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735107 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102



Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

P.s Also does any one know how to enable cookies for the login control on website.

i have noticed within the objectdatasource wizard, that something called profile is there, and this is where you specify the cookies, sessions etc. But i dont know where to start with this. Can anyone help?

thanks

andy

Your SQL problem could be a number of things.

You can try things like right clicking on your connection to the database inside VS2005 express and choosing close connection to see if maybe you're taking up the only connection, or you can create a new user for your sql express file and then change your connection string to use that instead of (presumably) integrated security.

Do you have SQL server studio express, with it you can probably get a better handle on your SQL express installation, including setting up users/passwords.

http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en

In regards to your cookies, by default they are enabled, but the forms authentication timeout defaults to 0 seconds, meaning that as soon as you close your browser it will go away. If you add/change your timeout value like I've done below, you'll have cookies able to last for as long as you set it (I choose 20160 for 2 weeks).

<

formsname=".ASPXAUTH"loginUrl="login.aspx"defaultUrl="default.aspx"protection="All"timeout="20160"path="/"requireSSL="false"slidingExpiration="true"cookieless="UseDeviceProfile"domain=""enableCrossAppRedirects="false">

</

forms>|||Do I put this inside the web.config file or my login.aspx file|||

Here is an example web.config, hope this helps!

<!-- Note: As an alternative to hand editing this file you can use the web admin tool to configure settings for your application. Use the Website->Asp.Net Configuration option in Visual Studio. A full list of settings and comments can be found in machine.config.comments usually located in \Windows\Microsoft.Net\Framework\v2.x\Config --><configuration> <appSettings/> <connectionStrings> <add name="MainConnectionString" connectionString="Password={password};Persist Security Info=True;User ID={userid};Initial Catalog={databasename};Data Source={ipaddress of server or what have you}" providerName="System.Data.SqlClient"/> </connectionStrings> <system.web><!-- Set compilation debug="true" to insert debugging symbols into the compiled page. Because this affects performance, set this value to true only during development. Visual Basic options: Set strict="true" to disallow all data type conversions where data loss can occur. Set explicit="true" to force declaration of all variables. --> <compilation debug="false" strict="false" explicit="true" /> <pages> <namespaces> <clear /> <add namespace="System" /> <add namespace="System.Collections" /> <add namespace="System.Collections.Specialized" /> <add namespace="System.Configuration" /> <add namespace="System.Text" /> <add namespace="System.Text.RegularExpressions" /> <add namespace="System.Web" /> <add namespace="System.Web.Caching" /> <add namespace="System.Web.SessionState" /> <add namespace="System.Web.Security" /> <add namespace="System.Web.Profile" /> <add namespace="System.Web.UI" /> <add namespace="System.Web.UI.WebControls" /> <add namespace="System.Web.UI.WebControls.WebParts" /> <add namespace="System.Web.UI.HtmlControls" /> </namespaces> </pages><!-- The <authentication> section enables configuration of the security authentication mode used by ASP.NET to identify an incoming user. --> <authentication mode="Forms" > <forms name=".ASPXAUTH" loginUrl="login.aspx" defaultUrl="default.aspx" protection="All" timeout="20160" path="/" requireSSL="false" slidingExpiration="true" cookieless="UseDeviceProfile" domain="" enableCrossAppRedirects="false"></forms> </authentication><!-- The <customErrors> section enables configuration of what to do if/when an unhandled error occurs during the execution of a request. Specifically, it enables developers to configure html error pages to be displayed in place of a error stack trace. <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm"> <error statusCode="403" redirect="NoAccess.htm" /> <error statusCode="404" redirect="FileNotFound.htm" /> </customErrors> --> </system.web></configuration>
|||

This is my web config file now, what do i put in the form name and path fields?:

<?

xmlversion="1.0"?>

<

configurationxmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<

connectionStrings>

<

addname="ASPNETDBConnectionString"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

<

addname="ASPNETDBConnectionString2"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

<

addname="ASPNETDBConnectionString3"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

</

connectionStrings>

<

system.web>

<

roleManagerenabled="true" />

<

authenticationmode="Forms" >

<

formname=".ASPXAUTH"loginUrl="Login.aspx"defaultUrl="threecolumn.aspx"protection="All"timeout="20160"path="/"requireSSL="false"slidingExpiration="true"cookieless="UseDeviceProfile"domain=""enableCrossAppRedirects="false">

</

form>

</

authentication>

<

compilationdebug="true"/>

<

anonymousIdentificationenabled="true" />

<

profile>

<

properties>

<

addname="PostalCode"type="System.String"allowAnonymous="true" />

</

properties>

</

profile>

</

system.web>

<

system.net>

<

mailSettings>

<

smtpfrom="andy.hillyard@.ntlworld.com">

<

networkhost="smtp.ntlworld.com"password=""userName="" />

</

smtp>

</

mailSettings>

</

system.net>

</

configuration>

i

am|||

This is my web config file now, what do i put in the form name and path fields?:

<?

xmlversion="1.0"?>

<

configurationxmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<

connectionStrings>

<

addname="ASPNETDBConnectionString"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

<

addname="ASPNETDBConnectionString2"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

<

addname="ASPNETDBConnectionString3"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

</

connectionStrings>

<

system.web>

<

roleManagerenabled="true" />

<

authenticationmode="Forms" >

<

formname=".ASPXAUTH"loginUrl="Login.aspx"defaultUrl="threecolumn.aspx"protection="All"timeout="20160"path="/"requireSSL="false"slidingExpiration="true"cookieless="UseDeviceProfile"domain=""enableCrossAppRedirects="false">

</

form>

</

authentication>

<

compilationdebug="true"/>

<

anonymousIdentificationenabled="true" />

<

profile>

<

properties>

<

addname="PostalCode"type="System.String"allowAnonymous="true" />

</

properties>

</

profile>

</

system.web>

<

system.net>

<

mailSettings>

<

smtpfrom="andy.hillyard@.ntlworld.com">

<

networkhost="smtp.ntlworld.com"password=""userName="" />

</

smtp>

</

mailSettings>

</

system.net>

</

configuration>

i

am getting this error message at run time:|||

This is my web config file now, what do i put in the form name and path fields?:

<?

xmlversion="1.0"?>

<

configurationxmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<

connectionStrings>

<

addname="ASPNETDBConnectionString"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

<

addname="ASPNETDBConnectionString2"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

<

addname="ASPNETDBConnectionString3"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

</

connectionStrings>

<

system.web>

<

roleManagerenabled="true" />

<

authenticationmode="Forms" >

<

formname=".ASPXAUTH"loginUrl="Login.aspx"defaultUrl="threecolumn.aspx"protection="All"timeout="20160"path="/"requireSSL="false"slidingExpiration="true"cookieless="UseDeviceProfile"domain=""enableCrossAppRedirects="false">

</

form>

</

authentication>

<

compilationdebug="true"/>

<

anonymousIdentificationenabled="true" />

<

profile>

<

properties>

<

addname="PostalCode"type="System.String"allowAnonymous="true" />

</

properties>

</

profile>

</

system.web>

<

system.net>

<

mailSettings>

<

smtpfrom="andy.hillyard@.ntlworld.com">

<

networkhost="smtp.ntlworld.com"password=""userName="" />

</

smtp>

</

mailSettings>

</

system.net>

</

configuration>

i

am|||

This is my web config file now, what do i put in the form name and path fields?:

<?

xmlversion="1.0"?>

<

configurationxmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<

connectionStrings>

<

addname="ASPNETDBConnectionString"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

<

addname="ASPNETDBConnectionString2"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

<

addname="ASPNETDBConnectionString3"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

</

connectionStrings>

<

system.web>

<

roleManagerenabled="true" />

<

authenticationmode="Forms" >

<

formname=".ASPXAUTH"loginUrl="Login.aspx"defaultUrl="threecolumn.aspx"protection="All"timeout="20160"path="/"requireSSL="false"slidingExpiration="true"cookieless="UseDeviceProfile"domain=""enableCrossAppRedirects="false">

</

form>

</

authentication>

<

compilationdebug="true"/>

<

anonymousIdentificationenabled="true" />

<

profile>

<

properties>

<

addname="PostalCode"type="System.String"allowAnonymous="true" />

</

properties>

</

profile>

</

system.web>

<

system.net>

<

mailSettings>

<

smtpfrom="andy.hillyard@.ntlworld.com">

<

networkhost="smtp.ntlworld.com"password=""userName="" />

</

smtp>

</

mailSettings>

</

system.net>

</

configuration>

i

am getting this error message at run time:

Server Error in '/' Application.

Configuration Error

Description:An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message:Unrecognized element 'form'.

Source Error:

Line 12: <roleManager enabled="true" />Line 13: <authentication mode="Forms" >Line 14: <form name=".ASPXAUTH" loginUrl="Login.aspx" defaultUrl="threecolumn.aspx" protection="All" timeout="20160" path="/" requireSSL="false" slidingExpiration="true" cookieless="UseDeviceProfile" domain="" enableCrossAppRedirects="false">Line 15: </form>Line 16: </authentication>

|||

This is my web config file now, what do i put in the form name and path fields?:

<?

xmlversion="1.0"?>

<

configurationxmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<

connectionStrings>

<

addname="ASPNETDBConnectionString"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

<

addname="ASPNETDBConnectionString2"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

<

addname="ASPNETDBConnectionString3"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

</

connectionStrings>

<

system.web>

<

roleManagerenabled="true" />

<

authenticationmode="Forms" >

<

formname=".ASPXAUTH"loginUrl="Login.aspx"defaultUrl="threecolumn.aspx"protection="All"timeout="20160"path="/"requireSSL="false"slidingExpiration="true"cookieless="UseDeviceProfile"domain=""enableCrossAppRedirects="false">

</

form>

</

authentication>

<

compilationdebug="true"/>

<

anonymousIdentificationenabled="true" />

<

profile>

<

properties>

<

addname="PostalCode"type="System.String"allowAnonymous="true" />

</

properties>

</

profile>

</

system.web>

<

system.net>

<

mailSettings>

<

smtpfrom="andy.hillyard@.ntlworld.com">

<

networkhost="smtp.ntlworld.com"password=""userName="" />

</

smtp>

</

mailSettings>

</

system.net>

</

configuration>|||

This is my web config file now, what do i put in the form name and path fields?:

<?

xmlversion="1.0"?>

<

configurationxmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<

connectionStrings>

<

addname="ASPNETDBConnectionString"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

<

addname="ASPNETDBConnectionString2"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

<

addname="ASPNETDBConnectionString3"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Inetpub\wwwroot\vwd test\web-css-take-it-further - modified in vwd\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />

</

connectionStrings>

<

system.web>

<

roleManagerenabled="true" />

<

authenticationmode="Forms" >

<

formname=".ASPXAUTH"loginUrl="Login.aspx"defaultUrl="threecolumn.aspx"protection="All"timeout="20160"path="/"requireSSL="false"slidingExpiration="true"cookieless="UseDeviceProfile"domain=""enableCrossAppRedirects="false">

</

form>

</

authentication>

<

compilationdebug="true"/>

<

anonymousIdentificationenabled="true" />

<

profile>

<

properties>

<

addname="PostalCode"type="System.String"allowAnonymous="true" />

</

properties>

</

profile>

</

system.web>

<

system.net>

<

mailSettings>

<

smtpfrom="andy.hillyard@.ntlworld.com">

<

networkhost="smtp.ntlworld.com"password=""userName="" />

</

smtp>

</

mailSettings>

</

system.net>

</

configuration>

i

am getting this error message at run time:

Server Error in '/' Application.

Configuration Error

Description:An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message:Unrecognized element 'form'.

Source Error:

Line 12: <roleManager enabled="true" />Line 13: <authentication mode="Forms" >Line 14: <form name=".ASPXAUTH" loginUrl="Login.aspx" defaultUrl="threecolumn.aspx" protection="All" timeout="20160" path="/" requireSSL="false" slidingExpiration="true" cookieless="UseDeviceProfile" domain="" enableCrossAppRedirects="false">Line 15: </form>Line 16: </authentication>

|||Very strange, are you using .net 2.0 or 1.1? Are you testing your project using the internal VS2005 web server or IIS?|||visual web developer express, iis|||

Ok,Its possible your web application in IIS isn't set to asp.net 2.0.

In IIS, if you right click on the site and choose properties, you should see an ASP.NET tab. You should make sure its set to ASP.NET version 2.0.50727

If you're using IIS on your local box then that should be it. If you're using IIS on a web server, then you might have multiple web applications. If you "do" have multiple web applications on an external web server inside of IIS, you have to make sure that your 2.0 apps aren't sharing the same Application_pool with a 1.1 application. I can give you more info once I get a better handle on what you're doing.

Thanks

|||

yes i am using the latest version of asp.net.

using iis web server on my local box - http//localhost.

On your last point, this may be the case, as i have created more than one virtual directory in vwd.

|||

ACK! I apologize, I didn't notice at first that you left off the S from forms. its meant to be.

<

formsname=".ASPXAUTH"loginUrl="login.aspx"defaultUrl="default.aspx"protection="All"timeout="20160"path="/"requireSSL="false"slidingExpiration="true"cookieless="UseDeviceProfile"domain=""enableCrossAppRedirects="false">

<

credentialspasswordFormat="SHA1"/>

</

forms>

I think it was one of those things where it was "so" close to being right I couldn't immediately notice the problem. Hopefully that helps.

Form type reports... Possible?

I need to create data reporting forms that does not necesserily have
repeating rows, but are composed of field names (test labels) and values
(read/calculated from database fields) scattered on page (similar to a manual
data entry form). I can do this with Cristal Reports but is this possible
with the SQL Server Reportsing Services? Thank you very much for your
opinions.
DDAbsolutely - just set up you dataset (or datasets) and drag the fields from
the field browser directly onto the page. Add labels and you're done!
"Dursun" wrote:
> I need to create data reporting forms that does not necesserily have
> repeating rows, but are composed of field names (test labels) and values
> (read/calculated from database fields) scattered on page (similar to a manual
> data entry form). I can do this with Cristal Reports but is this possible
> with the SQL Server Reportsing Services? Thank you very much for your
> opinions.
> DD

Form to create formula

Is it possible to create a form / pop up table for users to input criteria to search upon.

I am trying to set up a template to search, for example, for serial numbers where {contsupp.contact} = "serial number" (with other set criteria)is it possible to have this set up for users who are not familiar with crystal reporting so that they are prompted to insert a serial nuimber #1234 in a field which then populates the "serial number" area and runs the search?If you create a parameter field, you can set it in the select expert as the field you want (so, for example if you have serialnumber as a field, the parameter field (?serial) would be set up to use that field and then in the select expert you would select
{whatevertable.serialnumber}=?serial

Then, the crystal viewer will pop up a parameter select form automatically.

Form that creates a temporal table

Hey,
I have a kind-of-newbie question.
I need to create a form that will eventually produce a report in html /
asp.
while in access that would not be a problem, I'm learning my ways
through this project in the asp world.
So, I created an access database that should hold the information
entered by the form and then the report will be just retieval of
information from it.
The thing is that the form is built in the way that you select a few
options and then click "submit" and that's one line in the database,
after you click "produce" it should take all that information you
loaded into the database and make it a report.
How will the report's query look like? how will it know what
information was enterd by that specific user at that time? is there a
way to make a temporal table that starts with the first "submit" and
ends when you click "produce" ?
Thanks,
Tomer.The answer is: primary key.
The procedure that inserts the data should return the primary key of the
newly inserted row after the insert, then you can use the primary key to
retrieve the row(s) that you want to display in the report.
In SQL 2005 this is even simpler - use the OUTPUT statement.
ML

Form submission showing null values

I have designed a for to submit some info to a sql database, but when i enter the information to the form fields and click submit, I get an error saying that a null value cannot be submitted, when it should not be null.

Not to sound whiney, but i really need a code fix, not links to msdn pages that define properties (usually dont do this, but i have a deadline to submit this to my tech admin of my company's site)

Here is the code, and THANK YOU to anyone who helps me with this!!

<%

@.PageLanguage="VB"MasterPageFile="~/MasterPage.master" %>

<

scriptrunat="server">PrivateSub Submitdata(ByVal SourceAsObject,ByVal eAs EventArgs)

SqlDataSource1.Insert()

EndSub' Submitdata

</

script>

<

asp:ContentID="Content1"runat="server"ContentPlaceHolderID="ContentPlaceHolder1"><asp:sqldatasourceid="SqlDataSource1"runat="server"connectionstring="<%$ ConnectionStrings:clientInfoConnectionString %>"selectcommand="SELECT Client Name,Client Address FROM Clients"insertcommand="INSERT INTO Clients (ClientName,ClientAddress) VALUES (@.CName,@.CAddress)"><insertparameters><asp:formparametername="CName"formfield="Namebox"/><asp:formparametername="CAddress"formfield="Addressbox"/></insertparameters></asp:sqldatasource> Name:<br/><asp:TextBoxID="Namebox"runat="server"/><br/>

<asp:RequiredFieldValidatorID="RequiredFieldValidator1"runat="server"ControlToValidate="Namebox"ErrorMessage="Please Enter A Name"></asp:RequiredFieldValidator>

<br/>Address:<br/><asp:TextBoxID="Addressbox"runat="server"/><br/>

<asp:RequiredFieldValidatorID="RequiredFieldValidator2"runat="server"ControlToValidate="Addressbox"ErrorMessage="Please Enter An Address"></asp:RequiredFieldValidator>

<br/><asp:ButtonID="Submitbtn"runat="server"Text="Submit"OnClick="Submitdata"/><br/>

</

asp:Content>

Thanks,

The King

If the columns accept null values your code without any change will work.To Insert into a column wich donot accept null this is the work around.

Make a small change in your code to make it work.

Remove the input parameter specified in the design and add the same in your code .so this part

<insertparameters>

<asp:formparametername="CName"formfield="Namebox"/>

<asp:formparametername="CAddress"formfield="Addressbox"/>

</insertparameters>

can be removed.

In the submit click add this code

SqlDataSource1.InsertParameters.Add(

"CName", Namebox.Text)

SqlDataSource1.InsertParameters.Add(

"CAddress", Addressbox.Text)

Now you are done.

|||

All I can say is

Thank You!!!!!!

It finally works!

Thanks so much,

The King