ASP.NET

Trouble accessing a non-secure custom error page from a secure page.

15-Jun-06 10:24

I've had several posts here and there. I am VERY green so if someone can point me in the right direction.

I have an app where the user enters a part number. A datagrid comes back with info based on what the user entered. Okay, that part I have down.

Question 1: I want the screen to come back and say 'no part exists' and display a BLANK ROW where the user can start to enter information about the new part number. How do I do this?

Question 2: I found an article here that discussed using a reusable databinding function. Based on some other feedback here it got tweeked. It requires two parameters:

private void BindGrid (SqlCommand command, System.Web.UI.WebControls.DataGrid DGrid)<br />
		{<br />
			SqlDataAdapter adapter = new SqlDataAdapter(command);<br />
			DataSet ds = new DataSet();<br />
			adapter.Fill(ds);<br />
			DGrid.DataSource = ds;<br />
			DGrid.DataBind();<br />
<br />
		}

So for example, when I click the button to retrieve the data, I call it like this:

private void btnSearch2_Click(object sender, System.EventArgs e)<br />
		{<br />
			strPartNumberInput2 = txtSearchPart2.Text;<br />
			string SQLString = "SELECT c.cost, pt.description, dd.DrawingNumber, dd.DrawingRevision, dd.DwgPath FROM costs c INNER JOIN Parts p ON c.PartID = p.Id INNER JOIN PartTypes pt on pt.ID = p.PartTypeID LEFT JOIN DraftingData dd on dd.PartID = p.ID WHERE p.PartNumber = @PartID";<br />
			SqlCommand cmd = new SqlCommand();<br />
			cmd.Connection = new SqlConnection(strConnectSQL);<br />
			cmd.CommandText = SQLString;<br />
			cmd.Parameters.Add ("@PartID", strPartNumberInput2);<br />
			BindGrid(cmd, DataGrid2);<br />
		}

Now I'm getting into the edit, update, cancel functions (again looking at documentation out there) such as:
public void DataGrid2_edit (object sender, DataGridCommandEventArgs e)

{<br />
			DataGrid2.EditItemIndex = e.Item.ItemIndex;<br />
			BindGrid();<br />
		}

In this example there are no parameters.

How would I pass the parameters? Do I have to repeat all the sql command and connection stuff each time?

vic0215-Jun-06 7:38

vic02

15-Jun-06 7:38

Hi.
I have an application which requires a secure channel for just certain pages. I was able to do this selectively in IIS with no problem, except that the (non-secure) custom error page I defined in my web.config no longer works when an exception is thrown in one of the secure pages. It wants me to authenticate (even though these pages are set to allow anonymous access), after which I'll get the standard access is denied error.

I tried setting the defaultRedirect property in the web.config file to include the full Url, i.e., defaultRedirect="https://myDomain/myApp/genericErrorPage.htm", but then the non-secure pages have trouble accessing the custom error page. I get an HTTP 401.2 error:
"You do not have permission to view this directory or page using the credentials that you supplied because your Web browser is sending a WWW-Authenticate header field that the Web server is not configured to accept."

Is there a way to have non-secure and secure pages within the same app, while using custom error pages?

Code for retrieving multiple files

priyankardatta15-Jun-06 6:35

priyankardatta

15-Jun-06 6:35

Please could anyone help me out on this.

I need HTML code to store multiple file name in the database when multiple browse buttons are used.
the HTML page should have multiple browsers, for example Prof Signature field will have one browse button and Dean Signature field will have another browse button, the values selected values of these two should be stored in the database.

How to get data into the dropdown list from database table(c#)

pitturamakrishna15-Jun-06 5:08

pitturamakrishna

15-Jun-06 5:08

please help me to get data into dropdownlist from the database table.

Re: How to get data into the dropdown list from database table(c#)

albCode15-Jun-06 5:11

albCode

15-Jun-06 5:11

SqlConnection c = new SqlConnection(stringconection);<br />
c.Open();<br />
DataSet ds = new DataSet();<br />
SqlDataAdapter da= new SqlDataAdapter ("select command",c);<br />
da.Fill(ds);<br />
Dropdownlist1.DataSource = ds.Tables[0];<br />
Dropdownlist1.DataValueField = "Column1";<br />
Dropdownlist1.DataTextField = "Column2";<br />
c.Close();

Re: How to get data into the dropdown list from database table(c#)

varshavmane15-Jun-06 5:34

varshavmane

15-Jun-06 5:34

Goto DropdownList's properties and DataValueField put the PK of Database and DataTextField put the column name which u want to display form Database.
Then Write Method as:

DataSet ds = GetValuesFromDB();
DropdownList1.DataSource = ds;
DropdownList1.DataBind();
ListItem lst = new ListItem("All Values", "0");
DropdownList1.Items.Insert(0, lst);

Where GetValuesFromDB() will contain sql which will return Dataset.The query will have PK and the column name which u want to display.

I hope this will help u.
Thanks and Regards.

Static instances

Dario Solera15-Jun-06 4:33

Dario Solera

15-Jun-06 4:33

Hi, I have this question about static instances of classes:
Is a static instance of a class unique at the Application level, or there is a different instance for every session?

In other words, does a static field of a non-static class behave like it was in the Application["..."] object dictionary?

Thanks.

______________________________________
Tozzi is right: Gaia is getting rid of us.
My Blog [ITA] and the ScrewTurn Software experiment

Colin Angus Mackay15-Jun-06 5:17

Colin Angus Mackay

15-Jun-06 5:17

Appliation level. All sessions share the same static classes/methods/fields/properties.

If you update a static in one session, the update will instantly be available to all sessions.

Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Dario Solera15-Jun-06 5:23

Dario Solera

15-Jun-06 5:23

Thanks, in fact I have did a test and it behaves that way. Cool.

______________________________________
Tozzi is right: Gaia is getting rid of us.
My Blog [ITA] and the ScrewTurn Software experiment

Guffa15-Jun-06 5:22

Guffa

15-Jun-06 5:22

A static instance is just a static reference to a regular instance of the class. Therefore it has the same scope as any static variable.

A static variable is unique at the application level.

---
b { font-weight: normal; }

How to point to localhost?

Dario Solera15-Jun-06 5:24

Dario Solera

15-Jun-06 5:24

Guffa wrote:
A static variable is unique at the application level.

Cool. I did a test and in fact it works that way.
Thank you.

______________________________________
Tozzi is right: Gaia is getting rid of us.
My Blog [ITA] and the ScrewTurn Software experiment

leckey15-Jun-06 4:19

15-Jun-06 4:19

I am working on an ASP.NET project where I make a call to a database. I know how to create a key in the web.config file to point to the actual server, but I made a copy of the database on my local computer and want it to point to that.

Real Server:
<add key="ConnectionString" value="Data Source=SERVER-SQLSC1;Initial Catalog=Parts;User ID=user;Password=morecowbell" />

What I tried for localhost:
<add key = "ConnectionString" value = "Data Source = localhost;Initial Catalog=PartsDB;"/>
(I named the copy PartsDB to avoid confusion.)

What am I doing wrong here?

Paddy Boyd15-Jun-06 4:21

15-Jun-06 4:21

Just raise your arm and extend your finger in the direction of your pc...

or use server=(local)

leckey15-Jun-06 4:25

15-Jun-06 4:25

add key = "ConnectionString" value = "Server=(local);Initial Catalog=PartsDB;"

Like that?
I've been having problems pasting...

Paddy Boyd15-Jun-06 4:26

Re: How to point to localhost? [modified]

15-Jun-06 4:26

You can try wrapping your code in code tags (formatting below the entry textbox).

And yes.

leckey15-Jun-06 4:28

15-Jun-06 4:28

Then I get this error...

System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection

-- modified at 10:29 Thursday 15th June, 2006

What user do I use?

Paddy Boyd15-Jun-06 4:31

15-Jun-06 4:31

How are you connecting to your other db? You'll need to supply a db user name and password (probably sa and blank)...

Big Grin | :-D

leckey15-Jun-06 4:33

15-Jun-06 4:33

Real server:
add key="ConnectionString" value="Data Source=SERVER-SQLSC1;Initial Catalog=Parts;User ID=aspuser;Password=crlamo5"

Trying:
add key = "ConnectionString" value = "Server=(local);Initial Catalog=PartsDB; User ID = aspuser; Password=crlamo5

Get error:

System.Data.SqlClient.SqlException: Login failed for user 'aspuser'. Reason: Not associated with a trusted SQL Server connection

Paddy Boyd15-Jun-06 4:31

15-Jun-06 4:31

you might want to have a look at this:

http://www.connectionstrings.com/[^]

leckey15-Jun-06 4:36

15-Jun-06 4:36

Good site...what I can't figure out is why the "aspuser" works on the real server but not on localhost. I can't find anything different with permissions.

Paddy Boyd15-Jun-06 4:37