|
I had created a Accessdatasource and a gridview to display data from a table and update it when neccessary.
Please have a look at the below code....
Displaying and updating is working fine after lot of efforts...
Now what i want to do is, update only three fields from the table, so i mentioned the first(ENo) field to readonly, in this case the updation is not taking place.
If the readonly is removed the data is updated properly, but i dont want the user to change the value in first field(ENo). As it will update other rows with that no.
How should i accomplish this... Please help...
<br />
<asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/App_Data/abc.mdb"<br />
SelectCommand="SELECT * FROM [Holiday] ORDER BY [ENo]" UpdateCommand="UPDATE [Holiday] SET [EName] = ?, [EDate] = ?, [EDay] = ? WHERE [ENo] = ?" DeleteCommand="DELETE FROM [Holiday] WHERE [ENo] = ?" InsertCommand="INSERT INTO [Holiday] ([ENo], [EName], [EDate], [EDay]) VALUES (?, ?, ?, ?)"><br />
<DeleteParameters><br />
<asp:Parameter Name="ENo" Type="Int32" /><br />
</DeleteParameters><br />
<UpdateParameters><br />
<asp:Parameter Name="EName" Type="String" /><br />
<asp:Parameter Name="EDate" Type="String" /><br />
<asp:Parameter Name="EDay" Type="String" /><br />
<asp:Parameter Name="ENo" Type="Int32" /><br />
</UpdateParameters><br />
<InsertParameters><br />
<asp:Parameter Name="ENo" Type="Int32" /><br />
<asp:Parameter Name="EName" Type="String" /><br />
<asp:Parameter Name="EDate" Type="String" /><br />
<asp:Parameter Name="EDay" Type="String" /><br />
</InsertParameters><br />
</asp:AccessDataSource><br />
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" BackColor="White"<br />
BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="AccessDataSource2"<br />
Height="8px" Style="left: 0px; position: relative; top: 0px" Width="512px"><br />
<FooterStyle BackColor="White" ForeColor="#000066" /><br />
<Columns><br />
<asp:BoundField DataField="ENo" HeaderText="No." /><br />
<asp:BoundField DataField="EName" HeaderText="Event Name" /><br />
<asp:BoundField DataField="EDate" HeaderText="Date" /><br />
<asp:BoundField DataField="EDay" HeaderText="Day" /><br />
<asp:CommandField ShowEditButton="True" /><br />
</Columns><br />
<RowStyle ForeColor="#000066" /><br />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" /><br />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" /><br />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" /><br />
</asp:GridView><br />
The only thing i need is How to make the field(ENo) read only and update rest of the fields successfully.
Plz avoid my grammer, i am not so good at it.
Jats
|
|
|
|
|
<Columns>
<asp:BoundField DataField="ENo" HeaderText="No." ReadOnly="true" />
<asp:BoundField DataField="EName" HeaderText="Event Name" />
<asp:BoundField DataField="EDate" HeaderText="Date" />
<asp:BoundField DataField="EDay" HeaderText="Day" />
<asp:CommandField ShowEditButton="True" />
</Columns>
|
|
|
|
|
Hi Friends,
I m using html file field control to take image from user..
now i want to save this image to the database in binary format..
how can i do this..
Please help me..
Thanks in Advance
Amit Metkar
3i-infotech, Mumbai.
|
|
|
|
|
if (File1.PostedFile != null)
{
byte[] b;
using (Stream stream = File1.PostedFile.InputStream)
{
b = new byte[File1.PostedFile.ContentLength];
stream.Read(b, 0, b.Length);
}
}You will get the byte array. Update this to the database.
|
|
|
|
|
I was told storing images in databases isn't 'neat', and takes 'a lot of time' to work with (load tables etc.). Instead I store images on the harddrive and keep the locations stored in the database. Just wondering if this is still an 'issue'.
For example, I have a website where users can upload images and use those on the website. What is the best solution, store them in the database, or as told above, store them on the harddisc and keep the image location in the database?
- Does this depend on the amount of visitors your website generates?
- Does this depend on the filesize of your images (high-res versus dithered and rescaled images)?
Not that I have problems storing and using images, just wondering...
|
|
|
|
|
Eduard Keilholz wrote: Does this depend on the amount of visitors your website generates?
- Does this depend on the filesize of your images (high-res versus dithered and rescaled images)?
I think it depends on the resources you have. When your website is hosted on a shared server, you won't get much database space. So keeping images in database will make DB heavy. I have seen performance gain when I kept images in hard drive. Other point is maintainability. When one image has to be replaced, just login through FTP and replace the file. But if it is in database, you need separate user interface to do so.
Also images kept in the database makes DB backups a time consuming process. So thinking all possibilities, I always prefer to keep image path in DB and image in hard drive. What do you say ?
|
|
|
|
|
Erhm, I already kind of agreed didn't I? 
|
|
|
|
|
Good day.
I'm developing my own web control and I'm trying to set the other control as a property of my web control i.e.
<mycontrol:customcontrol id="TestID" formsubmitbutton="btn_SubscribeMe">
I need to access the btn_SubscribeMe from within my control. How can I achieve this?
The code for my control looks like this.
Private _formSubmitButton As WebControl
Public Property FormSubmitButton() As WebControl
Get
Return _formSubmitButton
End Get
Set(ByVal value As WebControl)
_formSubmitButton = value
End Set
End Property
And I get the following error:
Cannot create an object of type 'System.Web.UI.WebControls.WebControl' from its string representation 'btn_SubscribeMe' for the 'FormSubmitButton' property.
Can anyone tell me how I can acheive this?
Thank you very much. C# or VB code welcome.
|
|
|
|
|
Why you want to access button which is present in another control ?
Could you explain what are you trying to achieve
couldn't understand VB
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
I've got a Captcha control on my page along with some other buttons (a search button, amongst other things) on the page. The does the validation whenever a postback occurs and if the validation fails, it renders a new random number that is placed in the session variable. The problem is, I'm using AJAX and whenever a user clicks on the search button, a postback occurs and the generated code for the user gets invalidated, because he hasn't yet entered the captcha code.
What I want to acheive is, something similar to the "controlToValidate" property of the RegularExpressionValidator control. I want to set a property on the captcha control, so that it only does validation when that control is pressed and not some other control.
|
|
|
|
|
OK i think you need to check this.ScriptManager.IsInAsyncPostBack
if it is asynchronous postback then make validations false
else true
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
If i use masterpage in my asp.net application ,how can i call the javascript in the content page?How can i get the document.<formname>.<controlname>.value in the content page?
Please help..
|
|
|
|
|
It is going to be same where have written the javascript function in the Page/ another file
Just pass the Client id of the control to getElementByid method that should work ......
What problem are you facing ?
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Hi,
I have binded companyname and sending as query string but in the recirving side '&' was not taking can u pls help me
krishna
|
|
|
|
|
It's English, and yet I have no idea what you're talking about.
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 )
|
|
|
|
|
As I explained in my last post to you, encode the URL and please stop posting the message repeatedly.
|
|
|
|
|
i m using mail-this-page option in my site , if click on the link my outlook should open with my webpage inside the body of the outlook.
note:
i dont want to use smtp option to send mail
thnx in advance
|
|
|
|
|
You can create a mailto: tag that opens the default mail program. You can't embed Outlook inside your web page, you may be able to prepopulate the email with HTML that renders the way you want it to.
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 )
|
|
|
|
|
Hi All,
i am using ASp.net2.0 , C# .
A dropdownlist control which is filled by dataset i show the name against the respective code. Now name is quite large so i would like to show it in tooltip.
i search in google but did not get appropiate solution.
Please help
Thank you
regards
imran khan
|
|
|
|
|
mohd imran abdul aziz wrote: A dropdownlist control which is filled by dataset i show the name against the respective code. Now name is quite large so i would like to show it in tooltip.
i search in google but did not get appropiate solution.
You cannot do that with ASP.NET DropDownList control. May be your can use custom controls (JavaScript DropDownLists???).
|
|
|
|
|
Is there any option to call internet explorers button from asp.net
|
|
|
|
|
Every day, I wonder why so many people use ASP.NET, but do not understand it. ASP.NET runs on the server. The only code you can run on the client is javascript. What button do you want to push ? You probably can't, but you can do things like go back a page, in javascript.
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 )
|
|
|
|
|
True. Sometimes is just irritating. People don't read books and expect some one to do their work.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Dai naya,
Tarincha sollu, Tareelna tareelanu sollu. IFrame use panni website vachkerra unaka ivalavuna? yathuvuma illatha angaluku yavulo k_ _ irrukum.
Next time while answering mind ur words .
Senthil S
Software Engineer
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
