I have checked Enforce Referential Integrity in my relationship section in my access database.By this way Can I delete child records when I delete the perent record?
View 7 RepliesI am making a form that reads/writes to a table called Contract. Contract has a field called BuyerID, which is used to store the PK of a record in the Organization table, OrganizationID. When I first tried saving my form, I got the following exception:
The record can't be added or changed. Referential integrity rules require a related record in table 'Organization'. The transaction ended in the trigger. The batch has been aborted.
When I choose a value for the field that gets assigned to BuyerID, I don't get an exception. I don't want this field to be required, so I need to remove the referential integrity rule. I thought there must be a foreign key constraint specifying that BuyerID points to Organization.OrganizationID. However, running
[Code]....
shows that the only constraint for BuyerID is a default value of 0. how to remove the referential integrity rule?
I have a WCF service. For security reasons, I need to ensure that all 3 goals of security are attained (Privacy, Integrity and Authentication). We are planning to use x.509 certificate. My question is, Does just using x.509 certificate for message security ensure me of all 3 goals?
I am planning to set up the x.509 certificates as mentioned in following article
For message security use following links
[URL]
[URL]
I'm getting the following error in my event log appears many times each hour, if somebody could shed some light it would be very nice... Also I am running server 2008 web server, this is NOT a webfarm.
- <Event xmlns="[URL]/win/2004/08/events/event">
- <System>
<Provider Name="ASP.NET 4.0.30319.0" />
<EventID Qualifiers="16384">1316</EventID>
<Level>4</Level>
<Task>3</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2010-11-15T19:58:53.000000000Z" />
<EventRecordID>269048</EventRecordID>
<Channel>Application</Channel>
<Computer>MYCOMPUTER</Computer>
<Security />
</System>
- <EventData>
<Data>4009</Data>
<Data>Viewstate verification failed. Reason: The viewstate supplied failed integrity check.</Data>
<Data>11/15/2010 2:58:53 PM</Data>
<Data>11/15/2010 7:58:53 PM</Data>
<Data>c90bc32f744a4478bb63271bd76884a4</Data>
<Data>20406</Data>
<Data>44</Data>
<Data>50203</Data>
<Data>/LM/W3SVC/6/ROOT-1-129342688389277791</Data> .........
I have a MVC project wich uses LINQ to SQL as a data layer.
For example, I have a tables ProductGroups and Products. Product is a child of ProductGroup, so to get name of ProductGroup, in aspx-page I use constuction like Model.ProductGroup.Name.
But when I delete a ProductGroup there is appear a NullReference Exception in presentation page.
While I was using just DataSet and manual SQL-queries, the rows, there was not every joined-element present, simple were not put in query result.
I know that before delete Parent row I have to delete all children rows, it's correct way.
1. Is there a way to ignore rows which has null-elements without manual checking through "IF"?
2. Is there simple way to delete all dependencies without manual enumerating every related tables?
I encrypt and decrypt a string with a private key and following functions. so I encrypt a string with Encrypt function and decrypt the encrypted string with decrypt function. If someone can change the encrypted string and then it decrypts with decrypt function, the decrypted string isn't equal to plain text before encrypting. I want to know how can I check is decrypted string equals to plain text before encrypting?
[code]....
How do I ensure and enforce that all write operations to my MS SQL Server DB are transactions-based?
The reason I want to do this is that the DB contains financial account data and operations that fail halfway through some set of changes should not be able to mess up the database by mistake or by crashing.
The application is written in ASP.NET C#.
Edit:
There is a DAL but it does not (yet) require transactions for changes.We wrote the DAL ourselves. We did not use ORM.
I know how to perform one transaction from ASP.NET.
I want to ensure that all changes are made in transaction form so that if the application throws some exception in the middle, there will be no change to the database.
I want to enforce some calculation to my project, my requirement as follows. I have txtQtyReq,txtQtyyRec,txtQtyShor(All are 3 textboxes) on load all the 3 textbox/columns should show as "0".(QtyShort=QtyReq-QtyRec)I need to calculate/implement this in txtQtyShort column. when i give a value in txtQtyReq as "50" ,it should calculate QtyShort and display as 50.
txtQtyReq txtQtyRec
txtQtyShort(=txtQtyReq-txtQtyRec)
0 0 0
50 0 50
50 20 30
txtQtyReq=Quantity Required
txtQtyRec=Quantity Received
txtQtyShort=Qunatity short
How to enforce logon hours validation
View 10 Repliesfor some SQL queries I know the expected number of rows that must be affected by UPDATE, DELETE or INSERT statements. It could be a number such as 1 or a range such as 0-1 or 1-2 etc.
What is the best way to enforce that this is the number of affected rows and that otherwise an exception is thrown?
Also, can I limit the number of rows affected for UPDATE/DELETE/INSERT to say 1 row and otherwise get an exception?
I'm trying to extend the GridView into a custom/user control "WorklistGridView". And I'm not quite sure how to do it... so here's what I need:Every row needs to have a control (either a boundfield or a templatefield with a label, etc.) that contains the StepID (which is a column returned in the data set).I want to be able to use the WorklistGridView as a base class and extend it to something like "XyzWorklistGridView", where that child class would have a few more controls in the row template.
View 2 RepliesI had no problem with this in Visual Studio 2008 but it seems that VS 2010 is having an issue, and I'm betting it's probably me.I have a solution with an ASP.NET Web Site Project and a few C# projects (BLL, DAL, Tests in NUnit). I have configured the build process for the test project to automatically run NUnit to run the tests. I would like to ensure that the BLL and DAL projects build before the test project so that the tests will run against the latest compiled version (yes, I know I could do this all in one project, but I'm choosing not to -- please bear with me :) )
So, I set the dependencies of the Test project to include the BLL, DAL, and Web Application projects, and the build order shows BLL, DAL, Web Application, and then Tests. However, I noticed that the BLL doesn't actually build when I build the Test project.Any idea what this could be or any option I might be missing to force the other projects to build when I build the Test project?
I have a website running on iis 5.1 with asp.net 2.0. Where in the windows registry can I change the requirtements for some the security features? For example, I do not want to enforce strong passwords and I do not want to use the secret question and answer features.
View 4 RepliesI have a hierarchy in my website project as below:
[CustomControl1 - folder]
- CustomControl1.ascx
- CustomControl1.css
- CustomControl1.js
I load css and js files dynamicaly based on which controls are used on particular page. I am doing it by using following code:
[code]....
where AddLinks method adds HtmlLink controls to Page.Header with href attribute set to coresponding css and/or js file.
I would like to add Interface that would force new controls to have AddLinks method but it is impossible since it is a static method. Because my custom controls inherit from Control class I cannot use abstract class and/or virtual methods either. How can I achieve my goal?
I have a treeview in my .aspx: <asp:TreeView ID="tvDocCatAndType" runat="server" /> Not much else going on in the page -- two <asp:LinkButtons> and one <asp:Label>; the page is a child of a master page, so these controls are within a <asp:Content> control. I populate the treeview in code -- just 3 node levels, including the root node. All nodes have checkboxes, and I initialize all node.Checked to true. I have some Javascript to do the usual check/uncheck up and down the tree as parent and child node checkboxes are toggled.
No matter how many checkboxes I clear in the UI, on postback every single node has node.Checked = true regardless of the state of the checkbox in the UI. This is not the first time I've used a treeview, but I've never had this problem before. I created this page by light adaptation of an earlier project that works fine.
I have an html checkbox that controls a list of checkboxes. I want this checkbox to display in a sorta "null" state where it is neither true nor false.
<HeaderTemplate>
<div style="width:90px">
Toggle:
<input id="chkAll"
onclick="javascript:SelectAllCheckboxes(this);"
runat="server" type="checkbox" />
</div>
</HeaderTemplate>
I am creating a .Net application where I reset users' passwords in Active Directory using "SetPassword" method. With the way this application works I cannot use "CahngePassword"method.Is there a way (a work around) to enforce the password history when using "SetPassword" method and have a warning when the user is trying to reset the password to any the last five passwords?
View 1 RepliesI have a GridView that I was previously populating via an ObjectDataSource, and this code was working perfectly (ie, when the checkbox was checked Checkbox.Checked = true):
CODE BEHIND:
[Code]....
[Code]....
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox ID="chkRDR1" runat="server"/>
</ItemTemplate>
</asp:TemplateField>
=========================================================================================
Dim checkbox As CheckBox = CType(row.FindControl("chkRDR1"), CheckBox)
In the code I have here, I need to set the checkbox state from a database but I dont know the properties:
[Code]....
Is there anything missing in IIS 6.0 that prevents me from (Insert into table) using MS-Access?
Explain: The application works fine under Visual Studio 2008 IDE the insert into table works fine with no error, Also I tested with hosting provider and works fine with no problem. but now I have published the same exact app in a dedicated server windows 2003 with
IIS 6.0 .NET framework 2.0 with latest service pack I gave IIS_WPG write/modify access to the folder where MS-Access database is located and database but at the time of insert an error pop-up. I need to install in the Server or settings in the IIS to recognize my MS-Access db is it some office runtime that I am missing. (BTW I am using OLEDB connection string in my C# )
Using System.Data.OleDb;
I can retrieve data off of it with no problem but when I try to insert is when it fails I thought the problem was Access Rights but I do not think is the case.
Here's a short explanation of my asp.net project.
1) the default page loads, it will read the Windows Login of the user opening the page.
2) I'll check if this login exists in a table stored on the webserver.
In this Access Database, there's a 2nd linked table, pointing to another access table on a network location. Now, I want to read data from this linked table. However, at this moment I receive an error:
"The Microsoft Jet database engine cannot open the file '\<ip><shared-folder>statistics.mdb'. It is already opened exclusively by another user, or you need permission to view its data".
Some extra info:
- The network folder has read and write permissions for everyone
- the user and group permissions on both access files are set to read/modify/administer for the Admin user (on the tables I want to read from)
- IIS authentication on the server is set to "Windows Authentication" (this is needed so I can read the Windows Login from the user). All other authentication modes are disables (like anonymous, ...)
- When the error occurs, no other program or process has access to the statistics.mdb (so, it can't be locked by someone else)
- the web.config files access connection string looks like:
<add name="AccessConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\<IP><shared-folder>statistics.mdb;User Id=admin; Password=;" />
Like I said before, in this statistics.mdb file, there are 2 tables. One normal table, and another linked table (pointing to a network location)
Searching for solutions, I discovered the following:
- if I don't use linked tables, everything works fine (however, I have to use this linked table)
- even if I connect directly to the table in the network I receive the error. So, I'm pretty sure I don't have sufficient rights to read from this table.
I read that not the Admin user is opening the file, but actually a user called ASP.NET. This user doesn't have the correct rights to do this. However, I'm not sure if this is true.
I have some code here in view-page
[Code]....
How can I get checked value from chechboxes above .
I'd like the output checked field wrapped in
[Code]....
What Datatype (if needed) should i create in the model ?
I have a code to link to sql can anyone give me the same code for microsoft access....
try
{
int videoID = Convert.ToInt32(Request.QueryString["ID"]);
SqlConnection conn = new SqlConnection("server=WEBDESIGN-PC;database=Credentials;uid=sa;pwd=Azeem;");
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM videopath WHERE videoID=" + videoID, conn);
SqlDataReader dtr = cmd.ExecuteReader();
dtr.Read();
FlashVideo1.VideoURL = Convert.ToString(dtr["Filepath"]);
Label1.Text = Convert.ToString(dtr["Filename"]);
conn.Close();
}
catch (Exception ex)
{
Label1.Text = Convert.ToString(ex);
}
finally
{
}
I am new here,I have a grid with some checked & unchecked check boxes,& on click button of asp.net i want to add the checked rows to database,so which method will be best ?
View 1 Replies