Re: Probelm with role management - ASP.NET Discussion Boards

Re: Finding a control in Grid View

Sun Rays13-Dec-07 18:05

Sun Rays

13-Dec-07 18:05

Reddy Prakash wrote:
string USL = ((TextBox)gvLimit.FooterRow.FindControl("txtAssUSL")).Text.ToString();

Hi,
no need to convert into string again bcoz Textbox's Text property is returning string only.
Just write below line

string USL = ((TextBox)gvLimit.FooterRow.FindControl("txtAssUSL")).Text

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Flowchart Control Recommendation

Bob X13-Dec-07 15:59

Bob X

13-Dec-07 15:59

I'm looking for a flowchart control but can't find one that doesn't cost a fortune.

Does anyone know of a good flowcharting control, that is preferably free?

Thanks

Validation

kenexcelon13-Dec-07 15:39

kenexcelon

13-Dec-07 15:39

I have added some validation controls to my page. Sometimes, when the input is valid, the submit button will do nothing except when I click it twice. When the input is invalid, it will work when the page first loads but will not when a user will click cancel. Validations seems to work almost as it should. I have the search form and the cancel confirmation all on the same page on a multiview. Any idea as to what could cause having to click submit twice before valid input is accepted?

Thanks

EasyCGI?

sergeyv200213-Dec-07 11:31

sergeyv2002

13-Dec-07 11:31

Does anyone have experience with EasyCGI (windows) hosting?
I am particularly interested to know if there is a delay when sending an email from your ASP.NET application.

Re: EasyCGI?

Christian Graus13-Dec-07 16:54

Christian Graus

13-Dec-07 16:54

I'd say a lot of bulk hosts can have email delays, because they run a lot of sites and they all share a mail server.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Probelm with role management

Zoltan Aszalos13-Dec-07 9:07

Zoltan Aszalos

13-Dec-07 9:07

Hello!

I have a serious problem. I'm working on a web application which uses an oracle database connection. I have three kind of users and I would like to restrict some users to access some pages on the server. I've overriden the RoleProvider class and implemented some functionality in it but the problem is that I can't make it work. It gives me an error message that it can't establish a connection with sql server (I don't even use it). So, my questions are the following:
- if I use an implemented RoleProvider class, will I be able to distinguish to users which belong to different roles and therefore deny access to some resources on the server?
- can I use the OracleClient class as usual to implement the specific methods needed?
- is any other way to implement this kind of functionality?
I've search the web for a day and I haven't find anything useful yet, I've found some documentation about how to implement this stuff using an ms sql server but what about an oracle database, I could ask.
So, any help is very appreciated! Thanks in advance!

Re: Probelm with role management

pmarfleet13-Dec-07 11:12

pmarfleet

13-Dec-07 11:12

AFAIK, you would have to write your own custom providers in order to store Membership data in an Oracle database.

However after a quick web search I found the following article[^] which contains a ready-built provider for Oracle.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: Probelm with role management

Zoltan Aszalos13-Dec-07 20:57

Zoltan Aszalos

13-Dec-07 20:57

I've already written a RoleProvider implementation for my application but I can't make it work. I've looked at the article you mentioned but I don't really see the point there. All I need is to deny access to some users to see some specific pages on my site.

adding items from datagrid to a table

nigel200013-Dec-07 7:27

nigel2000

13-Dec-07 7:27

hi guys, i have added a button into a datagrid which contains the products table from northwind database. when the user presses it, it will put the row data in to a table, can someone please tell me how to do this,thanks,

Re: adding items from datagrid to a table

pmarfleet13-Dec-07 10:57

pmarfleet

13-Dec-07 10:57

nigel2000 wrote:
it will put the row data in to a table

What do you mean? A database table or a HTML table?

What part of the problem are you specifically stuck with? What have you tried to do yourself?

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: adding items from datagrid to a table

nigel200013-Dec-07 20:51

nigel2000

13-Dec-07 20:51

i am developing a shopping cart, i am using a table from the northwind database to practice with(Products table) i have loaded this table in to a datagrid and have addded a button called "Add" so when the user clicks the button it will put that row into a table which is the cart so then the user can view what he/she is buying.

GridView, DetailsView and multiple primary keys.

Fernando A. Gomez F.13-Dec-07 6:32

Fernando A. Gomez F.

13-Dec-07 6:32

Hello all. I have a GridView and a DetailsView which is bounded to the first one, so that when I click in the Grid's "select" command, it shows the related data in the DetailsView. So far, this is working smoothly.

However, now I have a table with two primary keys. I changed the declaration of my asp:GridView tag and edited the DataKeyNames to include both primary keys. So I run the ASP.NET. So far, I have this data:

PK1      PK2       DESC
=========================
1        1         Desc1
1        2         Desc2
1        3         Desc3

where both PK1 and PK2 are primary keys. The grid shows the data correctly. When I select the first item, the DetailsView displays the data correctly. However, when selecting the second or third row, it does not select anything (furthermore, not even the controls --textboxes-- are shown).

So I believe it has something to do with the fact of having two primary keys, even though I specified them in the GridView control.

I'm I missing something here? Has anybody ran into the same problem? A clue? I've googled and so far I've found sites saying that multiple primary keys are allowed, yet they do not remark any particular aspect for doing so.

Thanks in advance.

FG.

Hope is the negation of reality - Raistlin Majere

Re: [solved] GridView, DetailsView and multiple primary keys.

Fernando A. Gomez F.13-Dec-07 8:11

Fernando A. Gomez F.

13-Dec-07 8:11

So, I solved it. What I did was to capture the GridView's SelectedIndexChanged. There, I placed the following code:

DataKey dataKey = CatalogGridView.SelectedDataKey;

_detailsDataSource.SelectParameters["IdAtributo"].DefaultValue = 
    dataKey["IdAtributo"].ToString();
_detailsDataSource.SelectParameters["IdRol"].DefaultValue = 
    dataKey["IdRol"].ToString();
_catalogDetailView.DataBind();

where _detailsDataSource is the... well, the data source associated to the DetailsView _catalogDetailView. Before this, I had the following declaration of my data source's select parameters:

<SelectParameters>
	<asp:ControlParameter Name="IdAtributo" Type="String" Size="5"  ControlID="_catalogGridView"/>
	<asp:ControlParameter Name="IdRol" Type="String" Size="5"  ControlID="_catalogGridView"/>
</SelectParameters>

While this works perfectly when having only one primary key (the GridView passes the selected index to this data source and hence the DetailsView is updated automatically), for some unexplained reason it is not working with multiple primary keys. Thus, I just passed the values manually in the GridView's SelectedIndexChanged and DataBinded the control manually.

Now it is working perfectly. Notice however that the parameters cannot be of type asp:ControlParameter, but rather they must be simple asp:Parameter.

Thanks anyway.

Hope is the negation of reality - Raistlin Majere

App not sending all values in the textbox to the database

Jedidah13-Dec-07 5:00

Jedidah

13-Dec-07 5:00

A textbox that is supposed to accept comments from users and send it to the db is accepting only 150 char from the textbox no matter how many chars the user enters.I have checked all the properties of the textbox and all the path to the db,sp,components atall.I cannot find where or why all the values are not sent.Please any clue from anybody?

Re: App not sending all values in the textbox to the database

Christian Graus13-Dec-07 9:45

Christian Graus

13-Dec-07 9:45

Did you check how long the field in the DB is ?

HTML.FileInput in ASP.net 1.1 Project

JonathanMX13-Dec-07 4:08

JonathanMX

13-Dec-07 4:08

Hello All,

I have a boggling question (For myself anyway)

First of all, here is the code.

If Not FILE1 Is Nothing Then
If Not FILE1.PostedFile.FileName = "" Then

Dim sFile As String
'sFile = UID & "_" & Replace(FILE1.PostedFile.FileName.Substring(FILE1.PostedFile.FileName.LastIndexOf("\")), "\", "")
sFile = UID & "_" & FILE1.PostedFile.FileName
'spath = Server.MapPath("\files\") & UID & Path.GetFileName(FILE1.PostedFile.FileName)

FILE1.PostedFile.SaveAs(Server.MapPath("../Files/" & sFile))
sql = "update events set eventfile='" & sFile & "' where eventid=" & UID
myCom = New SqlCommand(sql, myCon)
myCom.ExecuteNonQuery()
Else
sql = "update events set eventfile= '' where eventid=" & UID
myCom = New SqlCommand(sql, myCon)
myCom.ExecuteNonQuery()

End If
End If

The problem is, most machines (All to my knowledge with the exception of one) work fine with this code. They can upload files with no problems, shove the path in a DB, and carry on like normal.

One client cannot. The error she recieves is looking like instead of passing the filename as sole, it is passing her local filepath as well..

Here is the error:

Server Error in '/' Application.

--------------------------------------------------------------------------------

'../Files/210_G:\OH&S Certification Training\Marketing Info\Spring 2008.doc' is not a valid virtual path.
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.Web.HttpException: '../Files/210_G:\OH&S Certification Training\Marketing Info\Spring 2008.doc' is not a valid virtual path.

The String '../Files/210_G:\OH&S Certification Training\Marketing Info\Spring 2008.doc' should simply be '../Files/210_Spring 2008.doc'

Any ideas on why this client is having such a problem? All help is greatly appreciated.. and if possible I would email some brewskies. Big Grin | :-D

Thanks in advance.

Ajax error!

Agweet13-Dec-07 3:42

Agweet

13-Dec-07 3:42

Hi,

can anyone help me, i have a page which uses ajax, im trying to print but every time i click print my table(which is a server control) gives me this error message

(Extender control is not a registered extender control. Extender controls must be registered using RegisterExtenderControl() before calling RegisterScriptDescriptors().)

can anyone help me?

thanks in advance

living life on the flip side

Re: Ajax error!

Sam Xavier13-Dec-07 22:33

Sam Xavier

13-Dec-07 22:33

Are you using the inbuild extender controls?
If not, have you created your own extender control?
Do let us know this info so that we can move forward..

Best Regards,
Sam Xavier
www.componentone.com

Re: Ajax error!

Agweet13-Dec-07 22:53

Agweet

13-Dec-07 22:53

Im using interior controls, its a filterTextBoxExtender.

living life on the flip side

Re: Ajax error!

Sam Xavier14-Dec-07 0:23

Sam Xavier

14-Dec-07 0:23

Are you rendering the controls? If yes, try to use Controls.Add method and see if it helps.
The follwoing link should resolve this issue:
http://weblogs.asp.net/scottgu/archive/2006/11/26/tip-trick-how-to-register-user-controls-and-custom-controls-in-web-config.aspx[^]

Best Regards,
Sam Xavier
www.componentone.com

Re: Ajax error!

Agweet14-Dec-07 0:56

Agweet

14-Dec-07 0:56

Thanks alot for all your help, i will check out that link now and give feed back.

Thanks a mil Big Grin | :-D

living life on the flip side

Crystal Reports in asp.net 2005

zareee13-Dec-07 0:46

zareee

13-Dec-07 0:46

Hi,

i have created a dataset named Dataset1.xsd
i have added a new crystalreport file to my apps named CrystalReport.rpt
i have configured the same with my dataset.
I get the tables n columns of my dataset in the FieldExplorer
I drag n drop the required columns in my rpt file

Then in my webform i drag n drop the crystalreportviewer
and map the CrystalReport.rpt source as the source for viewer.

When i execute i get this...

The report you requested requires further information
Dataset1
Server :Dataset
Database:
Username:
Password:
Integrated Security
and a logon button

can nebody help me???

zari

Re: Crystal Reports in asp.net 2005

zareee13-Dec-07 19:33

zareee

13-Dec-07 19:33

Does no body knows whats the pbm??

zari

Re: Crystal Reports in asp.net 2005

Elizma13-Dec-07 19:47

Elizma

13-Dec-07 19:47

Hi,

1. Tell me, when you created your report, did you use the dataset that you created, or did you connected directly to the database?

2. When creating the Dataset, dropping the tables from the database on the dataset, have you deleted the fill objects at the bottom of the table?

3. Have you created an instance of your dataset and fill the tables in the dataset with the code from the database?

4. Lastly you have to set the datasource for this report to the dataset instance that you created and filled.

Let me know if you need assistance. I struggled myself with this in the beginning.

Kind Regards,

Elizma

How to get it?

Imran Khan Pathan12-Dec-07 21:05

Imran Khan Pathan

12-Dec-07 21:05

Hi friends
I have one table called attributes
Fields like this

ID qty1 price1 qty2 price2 qty3 pirce3 qty4 price4 qty5 price5.....
1 1 20 10 15 50 10 100 8 200 6

If I enter qty 5 thens it returns prices 20 and 15 and if I enter qty 150 it returns prices 100 and 200.

Can any know sql quiry for this?
or
How to do it using code in asp.net if I get all records of each row?

thanks in advance

please don't forget to vote on the post that helped you.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.