When I add an AccessDataSource and attempt to configure it, the "Advanced SQL Generation Options" panel opens, but checkboxes "Generate INSERT, UPDATE and DELETE statements" and "Use optimistic concurrency" are sometimes grayed out.It appears that this happens when a table is specified that contains a foreign key, and it also seems that any Update query statement I specify in conjunction with a related databound gridview doesn't "take". What's the story here? Is it not possible to update a database table from a databound gridview control if the underlying table has a foreign key? Or is something else going on?
I have a GridView where I am displaying the students List who ware absent for "ASP.Net Class" If Teacher 1 login then it is displying all the records who ware absent and same for remaining teachers. I want to display those records where TecherId matched..
I wrote query like this :
Select StudName FROM Class where Status LIKE 'ABSENT' AND Teacher Id =?
But every teachers(User) are getting everyone's data....
I am using AccessDataSource and displying in GridView....
I'm using an access database that has an AutoNumber field as the primary key. After adding a record I'd like to retrieve the ID for the record that was just entered, however, I'm not able to figure out how to do this in ASP.NET using standard AccesDataSource and FormView functionality. My goal is to retrieve the ID so that I can then use it to add an additional record in a child / sub table.
I could do it strictly using vb.net and forget about using the InsertCommand for the AccessDataSource and it's built in functionality. However, that would require a complete rewrite of some other items, accomplish this using the standard AccesDataSource functionality.
Below is a sample of something I've tried to do using "Direction='Output'" on one of the ID field for one of Insert paramaters (source: http://www.4guysfromrolla.com/articles/050207-1.aspx). The plan was to then caputre that "output" using the my "_OnInserted" sub procedue. However, apparantly I'm not able to use this with AccessDataSource. Did some research and saw that I'd have to switch to SqlDataSource which I'd rather not do cause all other pages use AccessDataSource and I'm having problems defining my connection string with it.
I have my Access database bound to a Gridview and an able to Edit and Update the Grid as long as all columns are set to ReadOnly=False. If I make one or more columns ReadOnly=True I get the following error on updating: You tried to assign the Null value to a variable that is not a Variant data type How do I get past that problem?
I have a webpage with a gridview on it which is bound to a table in an Access database. So I now drop a dropdownlist on the webpage and when the Choose a Data Source popup appears if I select my Access data source there is nothing in the select a data field for display and select a data field for value fields on this popup. So it appears I have to create another Access data source. But why if I already have an Access data source on the same database? What am I doing wrong?
I am attempting to insert into two tables at once, but it's inserting blank values into the first table, and then correctly inserting the values into the second table. here is my codebehind, I can post the rest of my code if needed.
[code]...
Even when I comment out the second insert command, the first one still inserts null values.
I wish you are having a wonderful day Today I encounter a problem which I am unable to solver yet. have a e-mail subscription area and I am using accessdatasource for that. Also I am inserting the e-mail adress into database with AccessDataSource InsertCommand in aspx page not in codebehind. What I want is that;I want it to first check for the textbox-email value if it exists already or not ! Then if exists, I want to make "LabelOutPut.Text = "Already Exists !"" But if not exists, I want to do on button click that; "AccessDataSource1.Insert() and LabelOutPut.Text = "Subscribed !"
How do you databind from an AccessDataSource to a Label Control on page_load? I know you can use eval, but how do you associate your eval statement with the correct data source control?
I have an accessdatasource linked to MS Db query with three fields (date, SR, & CR).I also have an asp.calendar control on my aspx page.I am trying to figure out what OnDayRender code (or any other code) that I would need in order to change the cell color on the calendar based on the value of SR or CR in the query
I'm trying to display all orders placed and I have a primary accessdatasource control that has a select query to get the customer information and the orderID. I want to use the orderID value from this first query as a parameter for the secondary accessdatasource control that selects the product information of the products in the order. In plain english, I want to:- select product info from product table where orderID = ?(where ? is the orderID value from the first query)
I have tried the <%#Eval("OrderID")%> but I get a "server tag not well formed" error, but I do get results returned when I just type the order ID in, but obviously every result (order) just contains the same product info...
M was creating web page. Then next day when i starts my project again, everything was running properly, but now in all design page the tool of AccessdataSource is not showing in Design page. Though its working but it is not showing in design page. it shows in other system. So due to its invisibility , some times i create four-five datasoure in one page. Same problem also happens in sqldatasource and all other datasource.
System.NotSupportedException was unhandled by user code Message=The data source does not support sorting. Source=namespace StackTrace: at namespace.Admin.ToolkitScriptManager1_AsyncPostBackError(Object sender, AsyncPostBackErrorEventArgs e) in C:projectMaster.cs:line 27 at System.Web.UI.ScriptManager.OnAsyncPostBackError(AsyncPostBackErrorEventArgs e) at System.Web.UI.PageRequestManager.OnPageError(Object sender, EventArgs e) at System.Web.UI.TemplateControl.OnError(EventArgs e) at System.Web.UI.Page.HandleError(Exception e).......
below is my code using for simple gridview and i am only having problem with the sorting and paging is working as expected and i even define the ONSorting event but it still throws me an error: The data source does not support sorting.
namespace mynamespace { public class Product { private int _id; public int Id { get { return _id; } set { _id = value; } } private string _code; public string Code { get { return _code; } set { _code = value; } } private string _name;
I am trying to get the SMTP Server in IIS7 working so I can use the asp:PasswordRecovery component. I have included a screenshot of my SMTP setup in IIS, the SMTP setup in my web.config file, and my asp:PasswordRecovery component code. I have set it up to not require any authentication settings. I basically want to specify whatever email address I want as the "From" attribute (I'm using a series of noreply* addresses for a web app), like the php mail function that lets you put whatever you want in the from argument. What am I missing? Do I need to install anything else? I'm assuming that when people say "you need an SMTP server to send mail", this is what they're talking about.
For some reason, even though in the sitemap, the url is defined as "www.website.com/index.aspx" or "home.aspx", the currentNode.URL always has the domain attached to the URL, creating bad urls like "www.domain.com/www.website.com/index.aspx"
I've tried to figure out where www.domain.com was coming from by search my project and inside of my web.config file, but I can't seem to find it.
I'm trying to configure my Solution to publish multiple web sites to Azure using the 1.3 SDK and I want them to run under one Web Role. I've added the entry to the Sites element as per the CHM file and when I deploy to Azure the Instance starts up. Now for the symptoms:
Browsing to the "Primary" (first site added to the solution) everything works fine.
Browsing to the "Secondary" site throws the following error:
Exception type: ConfigurationErrorsException Exception message: Could not load file or assembly 'System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. (E:approot_WASR_1web.config line 28)
What have I tried so far without success (sigh):
1. I noticed that by default VStudio (2010 Ultimate) did not include the "Secondary" project output in the cspkg file. Setting a project dependency seems to have fixed that problem (or at least I now see it in the output window during the build process).
2. I've set "Copy Local=true" for the System.Web.Mvc on the "Secondary" project still nothing.
3. I have a CName setup for the "Secondary" project and use the hostHeader parameter on the Binding element so I haven't found a good way of testing this local so I'm limited in diagnostic info.
One thought that I had was that both projects now contain a WebRole.cs file, should that be the case in this configuration?
Im learning how to use the SqlMembershipProvider. I want to use my google mail account to send the automatic mail message like for example to recover passwords.
I'm trying to send an email from my website that I've upgraded from .NET 1.1 to 2.0. The 1.1 version set the SmtpServer like this:
System.Web.Mail.SmtpMail.SmtpServer = Current.Application.Item("SMTPServer")It's using the SmtpMail.SmtpServer property from the old 'System.Web.Mail' namespace.
How do I set the SmtpServer without using any classes/properties from the old namespace? I've seen a couple of examples online that set the SmtpServer in the web.config file. Is this the only way? How can you use an application setting in web.config ?
When I am inserting or deleting rows with my database gridview, the page refreshes to show the changes.
I happen to have multiple gridviews on one page, organized within a css/jquery tabbed panel, so that you only see one gridview depending on the tab that is clicked on. I have also setup the page to add a page number to the url based on the tab. For instance, my page url is www.website.com/default.aspx. When I click on a tab it will add a page number like so: www.website.com/default.aspx#2.
The problem is that when there is a page refresh, the web page refreshes the page default.aspx. So if my current url is default.aspx#2, it doesn't show that page when the web site refreshes. It shows default.aspx. how I would make the page return to the current url. When I make a change on a gridview within tab #2 I want the page to refresh and return me to page #2 again.
I have a column in an asp:repeater control that needs to be a hyperlink in which a user can click on it. By clicking on this link it needs to execute a function (this function creates an HTML letter and displays the letter in the browser) in my VB.Net Code-Behind. I'm not sure what kind of control to use that will allow this kind of functionality. Not sure if a Button or an Anchor would be best or even something else. I'm truly perplexed on this.
I'm trying to install a 32-bit ASP.NET application onto a 64-bit IIS server running on Windows Server 2008. This is a clean installation of the operating system with no other applications installed.As a prerequisite for our installation, we run the 32-bit version of aspnet_regiis -iIt fails with the following message: The error indicates that IIS is not installed on the machine. Please install IIS before using this tool.Additionally:IIS is definitely installed. The 64 bit version of aspnet_regiis runs cleanly without warnings.€œEnable 32 bit applications" is set to True in the DefaultAppPool's Advanced Settings. The IIS Metabase and IIS 6 configuration compatibility" component is installed.We have a test VM where this error occurs as well as test VM where both the 32 bit and 64 bit versions of aspnet_regiis run without errors. We've had no luck distinguishing the differences between the two test VMs.We have struggled with this issue for several days to no avail.
When I first published my site, I tested it using my gmail account and worked like a charm first try (a rare feat for me ;) ). Now, I'd like to finish it up by having it send the emails from the account at the host. No joy... I asked the host if I had misunderstood the rather unhelpful info in the control panel and they advised that in my web config I should change:
I am in the begininng stages of designing (or redisigning) a site. I am using VWD Express 2010 and the project is configured for .net 4.0. I am designing it offline so its currently just on my laptop, which is also running sql server express 2008 R2.
When I ran the ASP.Net Configuration tool, it automatically created a database called aspnetdb in the app_data folder where it stores all the user and roll info. How can I use a different database that has the same schema as well as some additional tables of my own. I want to point it to mylocally running sql server.
