ASP.NET

Jain Vijay2-Jun-09 20:11

Jain Vijay

2-Jun-09 20:11

Hi Goalie,
thank u very much. But problem is that template option "Web Control Library" is not in my copy of Visual studio.
Can you tell me that from where I can download it.

Regards...

Vijay Jain

"One thing you can't recycle is wasted time."

Goalie353-Jun-09 3:38

Goalie35

3-Jun-09 3:38

Vijay,

Which version of visual studio are you using? It looks like the standard edition doesn't have it for some reason, and I couldn't find any links that offered any type of download for it. Here's a link with more info:

http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/70da4b0d-9b89-414e-a1f8-700c2e7bb3c7[^]

Regards,
-Goalie35

Jain Vijay3-Jun-09 17:48

Jain Vijay

3-Jun-09 17:48

Hi Goalie,
thanx dear for your reply. Also i found the solution. In my copy of Visual studio instead of "Web control library", "Class library" template is available. In this object after adding System.web.dll, i m able to develop web custom control.

Regards...

Vijay Jain

"One thing you can't recycle is wasted time."

Re: BUG?- Username randomly appearing in Text Form Control (Only in Firefox)

Goalie353-Jun-09 18:25

Goalie35

3-Jun-09 18:25

Great Vijay! Glad it worked out for you!

Laugh | :laugh:

[Message Deleted]

R_L_H1-Jun-09 15:01

R_L_H

1-Jun-09 15:01

[Message Deleted]

RajeevKumarSharma1-Jun-09 23:12

RajeevKumarSharma

1-Jun-09 23:12

please try one thing.
just set the viewstate property false.

Rajeev Kr. Sharma
Sr. Software Engineer
E-Meditek Solutions Ltd.
http://www.emeditek.co.in/

Question about connection strings to an Oracle DB

Nostrom01-Jun-09 12:32

Nostrom0

1-Jun-09 12:32

Hello,

This question straddles the Oracle and ASP.NET worlds -- I hope this is the right place for it:

I'm trying to understand a legacy ASP.NET 2.0 website that uses an old Oracle database on the back-end. There is also an admin console wepapp which services the main website, but is a separate application, not an Admin subfolder.

The Oracle database has two "schemas", named WEBSITEADMIN and WEBSITEUSER, which have identical tables and stored procedures. Oracle seems to use the word "schema" to refer to groups of tables within a database - i.e. the two schemas seem to actually be distinct and seperate, as when I add columns to a table in the WEBSITEADMIN schema, the additions do not appear in the same table under the WEBSITEUSER schema.

The main webapp has an <appSettings> key pointing only towards the WEBSITEADMIN schema in the Oracle database, and indeed it appear to read and write only to that schema.

The admin console website, however, has the following in its web.config folder:

<appSettings>
    <add key="connectionString" value="user id=websiteadmin;data source=DATABASE;password=xxxxxx"/>
    <add key="DataConnection" value="user id=websiteadmin;data source=DATABASE;password=xxxxxx"/>
    <add key="domainName" value="adminsite.company.com"/>
    <add key="MachineName" value="mbd01235pd"/>
    <add key="Administrator" value="COMPANY\myemail"/>
    <add key="AdminAddress" value="myemail@company.com"/>
    <add key="ServerSideViewState" value="true"/>
</appSettings>
<connectionStrings>
    <add
        name="ConnectionString"
        connectionString="Data Source=DATABASE;User ID=WEBSITEUSER;Password=xxxxxxx;Unicode=True"
        providerName="System.Data.OracleClient"/>
</connectionStrings>

...so, the admin console webapp has an "appsettings" key referring to the WEBSITEADMIN schema, but the <connectionstrings> tag refers to the WEBSITEUSER scheme... erm... why?

Any idea why this app would have connections to both schemas if the main website appears to be only displaying data from one of those schemas?

Thanks for any advice.

Re: Question about connection strings to an Oracle DB

Colin Angus Mackay1-Jun-09 20:59

1-Jun-09 20:59

Nostrom0 wrote:
...so, the admin console webapp has an "appsettings" key referring to the WEBSITEADMIN schema, but the <connectionstrings> tag refers to the WEBSITEUSER scheme... erm... why?

This is a question for the person that built the application. We cannot answer this. You might get some speculation about why, but not a definitive answer.

Man who stand on hill with mouth open wait long time for roast duck to drop in

Authenticate users

hahii1-Jun-09 11:05

1-Jun-09 11:05

How to Authenticate Users with the SQL Server database table. I am using ling to entity data model.

Re: Authenticate users

Christian Graus1-Jun-09 11:29

1-Jun-09 11:29

I suggest you read the link in my sig. Or just buy a damn book instead of asking us to do your work for you.

Christian Graus

Driven to the arms of OSX by Vista.

Please read this[^] if you don't like the answer I gave to your question.

Re: Authenticate users

Colin Angus Mackay1-Jun-09 13:36

Insert statement (please read again.)

1-Jun-09 13:36

database tables are not an authenticaion mechanism. You can store data that can be used by your authentication mechanism, but it isn't a mechanism per se.

Your question, therefore, is larger than the scope of a forum reply. You would do well to find a tutorial on authentication in what ever OTHER technology (e.g. ASP.NET, WinForms, etc.) you are using and how to do that with SQL Server.

Man who stand on hill with mouth open wait long time for roast duck to drop in

hahii1-Jun-09 10:57

Re: Insert statement (please read again.)

1-Jun-09 10:57

have two tables. Roles and Users. In Roles I have three columns iID(PK), Role(varchar), Description(varchar).

In User table I have columns ID(PK,FK), Username(varchar), Password(varchar), Role(int).
First I fill data in Roles table then now I am trying to insert data in User
table it is giving me following error.

Msg 547, Level 16, State 0, Line 1
The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_User_Role". The conflict occurred in database "DataFeed", table
"dbo.Role", column 'Id'.
The statement has been terminated.

Christian Graus1-Jun-09 11:30

Re: Insert statement (please read again.)

1-Jun-09 11:30

The reason you're posting a ton of questions, is that you have no idea what you're doing. Add a book on SQL to your list. Do you know what this error means ? If not, you should NOT be working on database code. But, that's the point, isn't it ?

Christian Graus

Driven to the arms of OSX by Vista.

Please read this[^] if you don't like the answer I gave to your question.

Colin Angus Mackay1-Jun-09 13:32

Re: Insert statement (please read again.)

1-Jun-09 13:32

I have read this and you have not asked a question. You have supplied a series of incomplete, random and contradictory statements.

In one statement you say that in the table "Roles [you] have three columns iID(PK)...". However, the error message says the conflict is on "table
"dbo.Role", column 'Id'."

Please provide the CREATE TABLE statement for the Roles and Users tables, also provide the INSERT statement that failed.

Man who stand on hill with mouth open wait long time for roast duck to drop in

Colin Angus Mackay1-Jun-09 13:38

1-Jun-09 13:38

Just realised I'm in the ASP.NET forum - Why are you asking this here? It is a database question!

Man who stand on hill with mouth open wait long time for roast duck to drop in

hahii1-Jun-09 10:50

1-Jun-09 10:50

Hi,

I am using Login control in my login.aspx page. I have a user table in my sql databas where user name and password are stored. After filling username and password in login page I want to check if it matches with the username and password with the data in the user table. How can I do that.

Regards,

Re: login controls

Christian Graus1-Jun-09 11:30

Sending values of GridView, Datatable in asp.net in session

1-Jun-09 11:30

Use SQL

Christian Graus

Driven to the arms of OSX by Vista.

Please read this[^] if you don't like the answer I gave to your question.

ashutosh_karna1-Jun-09 10:29

ashutosh_karna

1-Jun-09 10:29

Hello Friends, I am new to ASP.net.
I want to make an asp.net page (which look like a spreadsheet)wherein, the user enters some data in one or more columns. Clicks the button, & the required result is displayed on another page.

I made a simple editable gridview in asp.net (default.aspx) and put some numeric data & clicked the button.

Now how can I pass the values ( as an array) stored in one or more columns to another page(result.aspx) to carry out further analysis.

I want to call following method to data array(values stored in column of previous page)

public static double Mean(double [] data) //DATA IS THE COLUMN OF GRIDVIEW
{
int n = data.length;
double mean = Sum(data)/n;
return mean;
}

Please Help with Proper Coding for storing GridviewColumn in session & then retrieve it onto another page to call the method above.

PLEASE HELP

Re: Sending values of GridView, Datatable in asp.net in session

Christian Graus1-Jun-09 11:31

How to create HyperLink for field in Crystal CrossTab report ?

1-Jun-09 11:31

ashutosh_karna wrote:
Please Help with Proper Coding for storing GridviewColumn in session & then retrieve it onto another page to call the method above.

You should read the link in my sig.

The most common way to do what you want, is to store the data in a database, and pass an id on the URL to a page that uses that id to read and display the data

Christian Graus

Driven to the arms of OSX by Vista.

Please read this[^] if you don't like the answer I gave to your question.

GridView Editing

MacIntyre1-Jun-09 10:18

MacIntyre

1-Jun-09 10:18

(VS 2005)
Is there any way to have 1 column available for editing for all rows at the same time using GridView?
If you know how to do this a code snipet would be appreciated.

Thanks Chuck

Re: GridView Editing

ToddHileHoffer1-Jun-09 10:26

ToddHileHoffer

1-Jun-09 10:26

I don't have a code snippet but you can use a template column in edit mode. Put all the fields in one template.

I didn't get any requirements for the signature

David Mujica1-Jun-09 10:14

David Mujica

1-Jun-09 10:14

Given that I have a crystal crosstab report with salesmen on the left column and months across the top, with the intersection being the number of sales made that month.

      Jan  Feb  Mar
Joe    5    7    4
Mary   12   6    8

How can I make the number of sales made for a given salesman / month combination a hyperlink with the corresponding query parameters ?

Something like this, "http://myserver/myapp/mySubreport.aspx?User=Joe&Month=Feb"

I'm currently using a formula in the "HyperLink" section of crosstab to generate a URL, however the URL that is generated by the function is the same value regardless of which "count of sales" field I click on.

For example, if I click on the first count,5, the URL is "http://myserver/myapp/mySubreport.aspx?User=Joe&Month=Jan" (good)
However, when I click on any of the other counts, say 7,4,12,6 or 8, the exact same URL is being generated.

How can I write the HyperLink formula to generate the desired values ?

OR

How else can I solve this problem ? Basically, I'm looking to create a crosstab report with the ability to drill-through to a more detailed report.

Thanks in advance.
David

Re: How to create HyperLink for field in Crystal CrossTab report ?

Member 204565326-Feb-11 9:22

Member 2045653

26-Feb-11 9:22

what is your solution?

i have the same issue.

Tommy

Insert into table

hahii1-Jun-09 10:14