|
I am a newbie at C#. Following code was generated mostly by the tool Visual Web Developer 2005 (with SQL Server 2008 express edition). It actually worked but now neither update nor delete work properly. There is no error message too. The database is very simple with a simple database table called 'Product'.
Any obvious gotchas - I have spent too much time on this already.
Thanks.
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" DataKeyNames="ProductId" DataSourceID="ObjectDataSource1">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
<asp:BoundField DataField="ProductId" HeaderText="ProductId" InsertVisible="False"
ReadOnly="True" SortExpression="ProductId" />
<asp:BoundField DataField="ProductDescription" HeaderText="ProductDescription" SortExpression="ProductDescription" />
<asp:BoundField DataField="ProductFamilyId" HeaderText="ProductFamilyId" SortExpression="ProductFamilyId" />
<asp:BoundField DataField="UnitPrice" HeaderText="UnitPrice" SortExpression="UnitPrice" />
<asp:BoundField DataField="StartDate" HeaderText="StartDate" SortExpression="StartDate" />
<asp:BoundField DataField="ExpirationDate" HeaderText="ExpirationDate" SortExpression="ExpirationDate" />
</Columns>
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" DeleteMethod="Delete"
InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData"
TypeName="ServiceDataSetTableAdapters.ProductTableAdapter" UpdateMethod="Update">
<DeleteParameters>
<asp:Parameter Name="Original_ProductId" Type="Int32" />
<asp:Parameter Name="Original_ProductDescription" Type="String" />
<asp:Parameter Name="Original_ProductFamilyId" Type="Decimal" />
<asp:Parameter Name="Original_UnitPrice" Type="Decimal" />
<asp:Parameter Name="Original_StartDate" Type="DateTime" />
<asp:Parameter Name="Original_ExpirationDate" Type="DateTime" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ProductDescription" Type="String" />
<asp:Parameter Name="ProductFamilyId" Type="Decimal" />
<asp:Parameter Name="UnitPrice" Type="Decimal" />
<asp:Parameter Name="StartDate" Type="DateTime" />
<asp:Parameter Name="ExpirationDate" Type="DateTime" />
<asp:Parameter Name="Original_ProductId" Type="Int32" />
<asp:Parameter Name="Original_ProductDescription" Type="String" />
<asp:Parameter Name="Original_ProductFamilyId" Type="Decimal" />
<asp:Parameter Name="Original_UnitPrice" Type="Decimal" />
<asp:Parameter Name="Original_StartDate" Type="DateTime" />
<asp:Parameter Name="Original_ExpirationDate" Type="DateTime" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ProductDescription" Type="String" />
<asp:Parameter Name="ProductFamilyId" Type="Decimal" />
<asp:Parameter Name="UnitPrice" Type="Decimal" />
<asp:Parameter Name="StartDate" Type="DateTime" />
<asp:Parameter Name="ExpirationDate" Type="DateTime" />
</InsertParameters>
</asp:ObjectDataSource>
</div>
</form>
</body>
</html>
|
|
|
|
|
try to use SqlDataSource
be a part of the solution, rather then problem
|
|
|
|
|
use sql datasource
when u configur ethe datasource and after u add your query go to advance options and select the update and delete checkboxes
|
|
|
|
|
I'm trying to upload a file in VB.NET using an HtmlInputFile, but everytime I upload, the HtmlInputFile's PostedFile is Nothing.
Here is my ASP.NET code:
<form id="Form1" method="post" runat="server" enctype="multipart/form-data">
<asp:DataGrid id="dgTitles" runat="server" OnUpdateCommand="dgUpdate" DataKeyField="ID">
<Columns>
<asp:TemplateColumn HeaderText="Title" >
<ItemTemplate>
<asp:Label ID="lTitle" Runat="server">
<%# DataBinder.Eval(Container, "DataItem.Title" )%>
</asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tTitle" Runat="server" text='<%# DataBinder.Eval(Container, "DataItem.Title" )%>'>
</asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Image">
<EditItemTemplate>
<input id='fuEditImage' type="file" name="fuEditImage" runat="server" enctype="multipart/form-data" />
</EditItemTemplate>
</asp:TemplateColumn>
<asp:EditCommandColumn UpdateText="Update">
</asp:EditCommandColumn>
</Columns>
</asp:DataGrid>
</form>
Here is my VB.NET code:
Sub dgUpdate(ByVal sender As Object, ByVal e As DataGridCommandEventArgs)
Try
Dim Title = CType(e.Item.FindControl("tTitle"), TextBox).Text
Dim fuUpload As System.Web.UI.HtmlControls.HtmlInputFile = CType(e.Item.FindControl("fuEditImage"), _
System.Web.UI.HtmlControls.HtmlInputFile)
If Not fuUpload.PostedFile Is Nothing Then 'This always = false
If Not fuUpload.PostedFile.FileName = "" Then
UploadImage(fuUpload)
End If
End If
Catch ex As Exception
'Handle Exception here
End Try
End Sub
When I upload a file, fuUpload is not Nothing, but fuUpload.PostedFile is.
The inputted "Title" text is recognized no problem.
I've also tried with FileUpload object and tag, instead of input tag and HtmlInputFile-- same result.
Can anyone tell me what I'm doing wrong? Why is PostedFile always nothing?
Thanks!
|
|
|
|
|
Hello Friends,
I want to download an image and set as background of my desktop.
|
|
|
|
|
.NET- India wrote: I want to download an image and set as background of my desktop.
Right click the image in and select "Set as background" (IE) or "Set as Desktop background" (FF)
|
|
|
|
|
how to get items count of cascading dropdownlist
coz items.count is giving default count as 1
|
|
|
|
|
Hello All
I'm using Crystal report Viewer for Reporting but it shows me an error i.e
Load report failed
Code is
protected void Button1_Click(object sender, EventArgs e)
{
CrystalReportViewer1.Visible = true;
rpt.Load(Server.MapPath("Itemmasterreport1.rpt"));
CrystalReportViewer1.ReportSource = rpt;
}
Any help will be appreciated
|
|
|
|
|
Hey dude it's Coding Block problem.
Look at Database binding Code. Some Where you do some wrong.
Can u paste your Whole Source Code here.
Let's Discuss .Net Problem [^]
K D Patel
|
|
|
|
|
Hi,
I am using popUpControlExtender ajax control in my asp.net 2.0 page.Its working fine on local machine with IE and Mozilla. On the remote server it works fine with IE but with Mozilla it shows error message :
RegisterDataItem can only be called during an async postback.
Please help me asap?
Thanks in advance.
|
|
|
|
|
Did you find solution to this problem? If yes please share
|
|
|
|
|
my pbm solved when i set my button's usesubmitbehaviour=false
|
|
|
|
|
I want to display a gridview with a blank row.
Also I have a Add button on click of which I want to add a new row to the gridview..
Can anyone help me do this?
Thanks and Regards
ARINDAM
|
|
|
|
|
Add a blank row in data set and then bind it with grid view. If you want to do it on button click do the same on button clicki.
The miracle is this--the more we share, the more we have.
|
|
|
|
|
Hello There,
you can do one tricks Declare One Datatable Fill this Datatable With your Data and Also In between with Empty String.
bind this datatable With Gridview.
Have u any Doubt ?
Let's Discuss .Net Problem[^]
K D Patel
|
|
|
|
|
In my web server I have two domain like www.abc.com and www.xyz.com, I uploaded a file called readme.html in both area. this file is simple to play flv file. readme.html file is working in www.zbc.com but same file is not working in another domain called www.xyz.com, everything i have checked a lot of time. but I do not understand what is the error.
|
|
|
|
|
If every thing is same then there may be compitability problem. Means the flv player on the server is not updated or some thing else. upload another vedio (and old flv) and check it...
The miracle is this--the more we share, the more we have.
|
|
|
|
|
There would be flv Player Version Problem with ur server Pls check or try any other Server which support urs Player.
|
|
|
|
|
hi
My project is hosted the site..
I have the link..if i click the link it will redirect to edit page..but the browser is locked..i could not edit the content..In that time HAND symbol and small Circle with cross like this (X) displayed..
Can u help me...
Regs
sara
Known Is Drop.Unknown Is Ocean
|
|
|
|
|
Hi, I read XML file from web site using with following code;
string Url = "http://www.abc.com/myfile.xml";
WebRequest webRequest = default(WebRequest);
WebResponse webResponse = default(WebResponse);
DataSet ds = new DataSet();
webRequest = WebRequest.Create(Url);
webResponse = webRequest.GetResponse();
Stream responseStream = webResponse.GetResponseStream();
ds.ReadXml(responseStream);
How can I add password protection for read this xml file from URI?
Best Regards...
|
|
|
|
|
you are responding the XML through a Handler I think....
If so, just when the request is made, you can place the password to the request header.. .
from the handler, check whether the request header contains the passkey or not.. .
|
|
|
|
|
|
In case of a Http error 500, how to retry the AJAX call one more time before displaying the error to the user
|
|
|
|
|
do that call again.. buddy...
but you need to create a new Object of XMLHttpRequest to make the call again.... .
Just when obj.status == 500 create a new object and call ajaxobj.send(null)... or whatever you need. ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Hi friends,
I have a datagrid with various radiobuttons binded in it. on clicking the radiobutton im using an to load the related page.
And also im doing the sorting on the data grid on clicking at the header of the grid column.
My problem is once i click on the radio button, i can able to see the page through <iframe>. After that, When i try to sort the grid the values in the grid are sorted out but the page i loaded through the radio click event disappears. The radio button which i clicked alone retains...
again if i click the same radio button or different one the page appears.. 
I need to retain the page as well after sorting.
Kindly help me on this.
Thanks in advance
Ashok
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
