|
I wasn't sure where to put this question, but I think the issue is based on what happens after I've queried the database, and what an ASP.net control is doing with the data.
I have a SqlDataSource linked to a Details View. It queries the DB (via a proc) to retreive a bunch of data about a specific record.
I'm having trouble with it, though. Sometimes certain values will return null. The proc left-joins several tables, and sometimes there won't be any results from the joined table (the "left" table is member information. The right table is image information, if there is a picture associated with that member).
I'm getting a Format Exception here (we're in the middle of an edit operation):
<br />
DataRowView rowView = (DataRowView)dvMember.DataItem;<br />
<br />
if (rowView["ImageID"] != null || rowView["ImageID"] != System.DBNull.Value)<br />
imageID = Int64.Parse(rowView.Row["ImageID"].ToString());<br />
Actual error message:
"System.FormatException: Input string was not in a correct format"
if the member in question has no image (this will be used for determining what I need to do for the rest of my updating). I don't know what I need to check for here. I thought null or DBNull would handle it. No dice. So what happens when you pull information from the DB into a datasource? What does it do to null values? Or is my DetailsView doing something to them (tricksome, they can be). I can't seem to find this information anywhere, and my good ADO books are all at home.
|
|
|
|
|
Hi there,
IMO, the simple way to figure out the root cause is to debug your application and have a look at the rowView.Row["ImageID"], then you can see what is the real value of it. Btw, when do you want to run the posted sample code? Does it run when you select data to the DetailsView control or when you update data?
|
|
|
|
|
I Forgot to mention that, sorry. The watch window is showing that rowView.Row["ImageID"] is null. This is contributing to my bafflement.
What happens on the page is this: user enters a search term in a text box, his search button. A Grid View is populated with matches for that search term. Basic information - name & email - is shown. There's a "view details" link button that makes dvMember visible when clicked, and populates dvMember with all of the individual information about that specific user (and we're doing all the retreival and binding right there). There's a datasource binding dvMember to gvMember & the selected index property (iirc, I'll double check at work monday).
In hindsight, I wouldn't use a second datasource there - part of the goal on this project for me was try and get comfortable with the controls. Since updates and deletes here are multi-table, I think the datasource is just in the way for the most part.
|
|
|
|
|
+ A quick fix is to replace the or (||) operator in the if condition with the and (&&) operator.
grandypeace wrote: There's a datasource binding dvMember to gvMember & the selected index property (iirc, I'll double check at work monday).
Yes, it should be the way you go.
grandypeace wrote: Since updates and deletes here are multi-table, I think the datasource is just in the way for the most part.
Because it's related to multiple tables, you may consider using the ObjectDataSource control.
|
|
|
|
|
minhpc_bk wrote: + A quick fix is to replace the or (||) operator in the if condition with the and (&&) operator.
Ugh, that's a stupid one to get myself into.
minhpc_bk wrote: Because it's related to multiple tables, you may consider using the ObjectDataSource control.
Well, I think if I was doing it all over again I'd probably do that. This is a small project - and it seemed to me at the start that doing actual objects would be a waste of time. Of course, once I got through most of it I had an additional requirement dropped on me - I had to map some of the data into a database in another application (so my multi-table operations became multi-table, multi-DB). I would have saved myself some trouble had I started differently. Live and learn.
|
|
|
|
|
|
This is what i tried:
<asp:HyperLinkColumn Text="View Details" ItemStyle-CssClass="table_text"></asp:HyperLinkColumn>
|
|
|
|
|
Hi
I am creating checkboxes dynamically. I want to catch the even when a checkbox is checked.
How can I do this. I know I need to create a method:
CheckBox1_CheckedChanged(object sender, System.EventArgs e)
But how do I attach this method to all the checkboxes I create dynamically. I cannot use OnCheckedChanged="CheckBox1_CheckedChanged"> as I am adding the checkbox dynamically.
thanks
|
|
|
|
|
The general format for programmatically assigning an event handler to a control in C# is:
ControlName.Event += new Delegate_Type(Name_Of_Procedure)
So given the CheckedChanged event of a checkbox requires an event handler of the delegate type System.EventHandler, you can use the following:
CheckBox1.CheckedChanged += new System.EventHandler(CheckBox1_CheckedChanged);
|
|
|
|
|
I know that it's possible to mix ASP & ASP.NET 1.1 in the same
website/application so long as they are in separate frames (iframes). This
also holds for mixing ASP & ASP.NET 2.0 pages. But what I haven't tried
is mixing ASP.NET 1.1 & ASP.NET 2.0 pages in the same website/application
but each page in different iframes.
I don't think it's possible to to have both ASP.NET 1.1 & 2.0 pages in
the same website since IIS defines which ASP.NET version to use. Does
anyone know a way to make IIS use ASP.NET 1.1 for certain pages, and
ASP.NET 2.0 for other pages?
Probably one can host the ASP.NET 1.1 website, and link in the iframes
of ASP.NET 2.0 pages from another website in the same IIS server. But
that's just looks clumsy.
|
|
|
|
|
Hi there,
You can configure some web pages in your ASP.NET 1.1 application to run under the .NET 2.0. You can follow the steps as below:
+ Move the web pages which you want to run with the ASP.NET 2.0 into a subfolder, say A.
+ In the IIS snap-in, right click A to open the Properties window.
+ In the Directory tab, click Create in the Application Settings section.
+ Switch to the ASP.NET tab, you now can see that the ASP.NET version dropdownlist is editable, and you can select the version 2.0 for the A, and click Apply.
+ You then can go back to the Directory tab, to click the Remove button, this step is optional as you also simply leave it as it is.
+ You finally click OK to close the Properties window and do your testing.
However, you should remember that the ASP.NET 2.0 supports 100% backward compatibility, so you can simply configure your application to run with the ASP.NET 2.0 and your old web pages still work properly.
|
|
|
|
|
I have a GridView defined as
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" Width="100%" BorderStyle="None" GridLines="None" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" OnRowCommand="GridView1_RowCommand" DataKeyNames="ID"><br />
>
and my template field is defined as
<asp:TemplateField HeaderText="Message Subject" ShowHeader="true" >
<ItemTemplate>
<asp:LinkButton ID="LinkTo" runat="server" CommandName="Select" CommandArgument='<%#Eval("ID") %>' Text='<%#Eval("Subject") %>' PostBackUrl="~/ViewPost.aspx"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
and my RowCommand is defined as in code
<br />
public void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)<br />
{<br />
if (e.CommandName == "GetEntries")<br />
{<br />
int i = 0;<br />
}<br />
}<br />
The problem is that the RowCommand never gets hit. The RowCreated does, but not the row command.
Anyone know why its not being hit?
Nick
1 line of code equals many bugs. So don't write any!!
|
|
|
|
|
Hi Nick. I noticed that your comparison is for a commandName of "GetEntries", but your LinkButton includes a commandName of "Select". Is it that simple?
|
|
|
|
|
yeah. I put a breakpoint on the if statement so I'm just trying to get there.
But, yeah it would be wrong.
thanks,
Nick
1 line of code equals many bugs. So don't write any!!
|
|
|
|
|
For anyone who cares or does a search to find this:
If you have the SelectedIndex changed wired. Which is kinda default to you double click. Delete it.
Then the grid will hit the RowCommand
It hints this in MSDN, but not fully.
Nick
1 line of code equals many bugs. So don't write any!!
|
|
|
|
|
I need to use response.redirect to a Word document that open with Word (Not IE prowser). When I type the "\\sitename\wwwroot\appfolder\file.doc" in IE address box, the document will be opened with Word. But when I use Response.Redirect("\\sitename\wwwroot\appfolder\file.doc") in my code the address in IE browser becomes to "href="http://siteurl/sitename/wwwroot/appfolder/file.doc" and get "the page can not be fount" error. How can fix the problem?
|
|
|
|
|
If the file.doc is in the same folder as your .aspx page, would it work to simply use the relative path Response.Redirect("file.doc")?
|
|
|
|
|
Response.Redirect("file.doc") will open the document in IE browser. I need to open the document in Word.
|
|
|
|
|
How it opens on the client is a choice the client gets to make (through their browser settings) - I'm not sure you can limit the client the way you're suggesting (I'd be happy to be proven wrong though)
|
|
|
|
|
Just like I said above, when I type the "\\sitename\wwwroot\appfolder\file.doc" in IE address box, the document will be opened with Word. Is there any way in a asp.net application that can do the same way?
|
|
|
|
|
if( File.Exists(Server.MapPath("...")) )
{
FileStream MyFileStream;
long FileSize;
MyFileStream = new FileStream(Server.MapPath("..."), FileMode.Open);
FileSize = MyFileStream.Length;
byte[] Buffer = new byte[(int)FileSize];
MyFileStream.Read(Buffer, 0, (int)FileSize);
MyFileStream.Close();
Response.ContentType = "application/msword";
Response.BinaryWrite(Buffer);
}
else
MessageBox.Show("File not found!");
This code fragment will ask user download this file. However user can open this file by press open button. Therefore, MSWord will be open.
Is there any suggestion?
|
|
|
|
|
A little history about the issue, I needed an .exe to fire based on the Web Users response. Then, I pick-up the output of the .exe and FTP it to a desired location while keeping an accurate audit trail of these events.
The process has been written and work famously on my localhost, while in debug mode. On the other had, when I run the process on my localhost as IUSER_, I will see the .exe appear in Task Manager but the .exe never executes.
I am about 95% sure it's a permissions issue and IIS config on the site. So, when trouble shouting the issue, I've went as far as allowing Everyone rights to the "C" drive with Full Control and open up IIS with:
Script source access
Read
Write
Directory browsing
I think I've opened up my testing PC as wide as it will go. My question is when within debug mode how do I impersonate IUSER_ permission so I can figure out when I need to add the correct permission for IUSER to execute the .exe? Or any ideas on working around the permission issue. Because, I don't really like the idea that I'm allowing a site to run executables onto my web server. Please help
Robert Fidler
Software/Web Developer
|
|
|
|
|
Hi there,
What do you mean by it's working in debug mode? Does that mean when you are debugging your application or the application is running with the debug attribute set to true in the web.config file. To run and read the standard output of an executable, your application normally requires the trust level, you can check this. Also, you may try to read the standard error from the StandardError property and see if you get any clue from it. Another work-around is to impersonate an window account which is available on the machine. You can configure the impersonation using the identity element in the web.config file or using the WindowsIdentity.Impersonate method in code.
|
|
|
|
|
What is the best way to define money such that sql server and asp.net agree? I have defined money in my sql tables as 'money' and values are stored with 4 places after the decimal point. In asp.net I'm using CompareValidator with DataTypeCheck of type 'currency'. This is raising a problem for me because asp.net permits only two places after the decimal point and throws up a validation error for money values i.e. because they have 4 places after the decimal point.
I would like to define money as having 2 places after the decimal point. How can I achieve this?
Thanks
Majella
|
|
|
|
|
Use a regex validator instead and validate for ^([0-9](\.{0,1})([0-9]{0,4}))$
If you are storing 4 dp in the database, then your users may want to see all four at some point, so you might want to use a decimal datatype in .net and have some sort of formatting function for the front end.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
