I just want to be able to create a site that will allow users to insert/update/delete information from the site and the information will be recorded on the SQL DB.
Went through couple of Videos and Tutorials, it can't be that complicated?
when i want insert a record i see an error like this
Can't perform Create, Update, or Delete operations on 'Table(MainMenuLink)' because it has no primary key.
with this codes:
MyLinqDataClassesDataContext db = new MyLinqDataClassesDataContext(); MainMenuLink li = new MainMenuLink { Link ="../error/error.aspx", LinkSubject = "subject" }; db.MainMenuLinks.InsertOnSubmit(li); db.SubmitChanges(); ShowLinks();
what is the problem?
my table have a primary key but i dont know why give an error!!!
when i want insert a record i see an error like this Can't perform Create, Update, or Delete operations on 'Table(MainMenuLink)' because it has no primary key. with this codes:
MyLinqDataClassesDataContext db = new MyLinqDataClassesDataContext(); MainMenuLink li = new MainMenuLink { Link = "www.tprogrammer.com", LinkSubject = "subject" }; db.MainMenuLinks.InsertOnSubmit(li); [code]....
I'm trying to create an <asp:Menu> bound to an <asp:SiteMapDataSource>. I have everything implemented but I'm receiving an error stating: "Multiple nodes with the same URL '/Members/LandingPage.aspx' were found. XmlSiteMapProvider requires that sitemap nodes have unique URLs.". Can anyone point me in the right direction to solving this error? The menu structure that I'm trying to create and the Web.sitemap that I'm using are shown below.
I have a Master Page and on the Master Page I have a Site Map. What I would like to do is when a user logs on deending on the users permission I want to hide some of the Nodes on the Site Map.
I have a code that load hierarchy( nodes) into trew view.. by selecting different date, the hierarchy result from SP will show in the treeview..
the problem is even though I select a different date.. the result( node) of previous date is still showing in addition to the new hierarchy result...
it;s like the new result node is appended to existing node.. instead of refreshing the node and showing only the new result. How can I clear out the treeview nodes before adding new nodes from different date?
i am trying to delete app_offline.htm programmatically but the code doesnot even get called as the app_offline does not other pages load. how should i delete the file after the updations have been done in the website. i know that i can delete the file manually but i dont want to do that.
I'm not sure the best place to ask this...not even sure the best way to ask it.
I manage a library website, and there are a number of different database products that can be searched. I'm trying to build a black box application to sit behind the home page. Here's an example of what might get submitted to said application.
See, the idea is that I might be doing various search boxes throughout the site, and I want to keep the actual HTML forms as simple as possible and simply let an ASP.Net application do the rest of the work. For example, figuring out whether or not the search engine using a GET or a POST method, parsing the keywords to determine the best way to render them, and sending the appropriate hidden values.
Probably, most of these databases use GET, so I can simply use a Response.Redirect after creating the query string, but I think some of them might use a POST, and I'm just not certain how I would take the form variables from one page (the home page, say), then essentially turn them into a virtual form on this middle man/black box application, and then programmatically submit that virtual form to another site, such that the user never sees or knows about that intermediate page.
I've seen this:
[URL]
But that isn't what I actually want to do, because I don't want to retrieve the result of the submission through a WebResponse...rather, I want the form to actually send the user to the new site.
I've a listview in which i'm binding data from objectdata source. I have a requirement where i've to allow edit/delete for only certail listviewitem which meets specific requirement. How do i dynamically set that some item can be only be edited not deleted thus only edit button/link should appear and vice-versa.
how would i do my Gridview delete command like a update command?
im using a datasource... and my delete command is like my update command... so i can change the status into "INACTIVE"...
DeleteCommand="UPDATE ACCOUNT_MAINTENANCE SET am_status = 'INACTIVE' WHERE (accmain_no = @accmain_no)"
UpdateCommand="UPDATE [ACCOUNT_MAINTENANCE] SET [account_type] = UPPER(@account_type), [min_deposit] = @min_deposit, [min_capital] = @min_capital WHERE [accmain_no] = @accmain_no"
when i press my delete command at gridview... the status changed into "INACTIVE" but when i refresh or press f5... it automatically update the status into "INACTIVE" also...
I am currently working on a signup sheet for new students. For each new student, we want add their schedule; therefore, I have a drop down list that displays the teachers which update another drop down list that displays the selection of the class the teacher teaches. The problem is that a student may have one or more classes, depending if they are in lower school or in upper school. The question is, how do add another row to the table and make sure it does not disappear when I select a teacher. Using jQuery, I successfully add the row with two new drop down list, but as soon as I select any of the teacher, the update panel refreshes and the new row disappears...
I need to execute a stored procedure which is a simple delete (record) query. Programmaticaly, I want to pass in a parameter "ID1".
Assume I will pass in the ID1 parameter on a delete link click event froma GridView control. What would the code be to execute the existing stored procedure?
ID1 - the parameter and primary key of the source database for the record to be deleted
GridView1 - the GridView control
spDeleteRecord - the stored procedure needing the parameter ID1 and to be executed from C# code
DeleteTableAdapter - an existing TableAdapter for the existing
i'm trying to set my website's culture programmatically, so when a user clicks a button they can change the text on the page from english to spanish. here's my code:
i have a Default.aspx.resx file with a key/value of: lblDisplay.text/English and a Default.aspx.es.resx file with a key/value of: lblDisplay.text/Espanol. i can't get my Label's text to change from "English" to "Spanish". anyone see what i'm doing wrong?
I want to delete location path using parameter textbox .. example : I enter name of location path in the texbox when i click button delete then location path in web config will be remove..
how can I add a dynamic textbox.? I want to add textbox as the user click the add button and then Insert the data from those textboxes in the database.
show give me some codes of creating textbox and recreating them in page load.
I have created firstly ASP.NET MVC 2. and write more functionality. After I create asp.NET Dynamic Data Site. now, when I click on run button in Visual Studio, mvc app. opened in browser as [URL]. and asp.NET Dynamic Data Site as [URL]. but i want to merge this app. in one. can I use asp.NET Dynamic Data Site and asp.NET MVC-2 at the same time?