Header Table has a trigger for Delete i.e. when a record from Header Table is deleted, all records from LineItem Table having that HId also gets deleted. Every thing works fine till here, now LineItem table also has a trigger for Delete which Updates/Deletes few other tables.
The problem I am facing is if 5 record having HId = 1 gets deleted from LineItem table the LineItem Delete trigger only runs for first record. Why trigger is not working for all the deleted LineItem records?
i made a after delete trigger on a table1 and in this trigger i insert the deleted data in another table name tab2.
when i execute the delete stored procedure of table1 from sql server 2005 then trigger working fine but when i execute delete stored procedure of table1 from c# then it is not working properly.
ALTER Proc [dbo].[Usp_CheckUserLogin] ( @Username varchar(20), @Password varchar(20) ) as begin Declare @RowCount int Declare @RowCount1 int set @RowCount = (select distinct UsrId from UserMast where username=@username COLLATE SQL_Latin1_General_Cp1_CS_AS ) set @RowCount1=(select distinct UsrId from UserMast where [password]=@password COLLATE SQL_Latin1_General_Cp1_CS_AS) if(@RowCount > '0' and @RowCount1 > '0') if (@RowCount=@RowCount1) begin -- select U.UsrId,U.FirstName,U.LastName,U.Email,U.companyId,U.role,R.RoleName from UserMast U join rolemast R on U.Role=R.RoleId -- where usrid=@RowCount select 'success' end if(@RowCount > '0' and @RowCount1 = '0') begin select 'username exist' end if(@RowCount= '0' and @RowCount1 > '0') begin select 'password exist' end if(@RowCount= '0' and @RowCount1 = '0') begin select 'both not exist' end --return @RowCount1 end
my procedure not give me result i think my syntax is not correct
we are running into an issue with our ASP server. If you try to access a password protected page it does a security check and redirects you if you are not logged in, retaining the URL (ie. Members/MemberLogin.aspx?doc=/PodCast/Default.aspx) The vb script places the "/PodCast/Default.aspx" in a variable and holds it until the login process is complete. Once the user types in their username and password it is suppose to do a Response.Redirect(strRedirectURL) and go to the "/PodCast/Default.aspx" but instead it goes to the default.aspx page for logging in successfully.
The kicker is, I know the code is 100% correct becuase it was working on our previous server, but when we pushed all the data onto this server, everything works BUT that piece.
I have 3 gridviews in one of my web page. I have simplified the system structure in the image below(further description will be stated below the image): As shown in the image above, the web site(presentation layer) will work closely with the Business Logic layer(BLL) and Data Access Layer(DLL). ObjectDataSource control will be the middle man to select, update, insert and delete the data in the gridviews. During Select, returned data from the database at DAL will be stored in a datatable and return to BLL and then the website itself.
The data in the returned datatable will be filetered by type using RowFilter method and stored into the 3 dataviews. Each dataview will act as the datasource for the 3 GridViews respectively, and therefore I specified the datasource programatically instead of setting the datasourceid for each gridview.
However, the Update(command button) and Delete(template field) doesn't work, the RowUpdating and RowDeleting event wasn't trigger when I click on the button, but it works if I set the gridviews' datasourceid to the objectdatasource. I couldn't figure out why, hope that someone who have come across the same problem couldn't provide some guidance.
I have a ListBox1 on the Form that I read in the same Directories: "GetS" as in the code below.
Now I select the first index wich is 0 in the listBox with the mouse and press Button1.
What the code below does is to find that specific folder that also contains a .BMP file and a file: File1.txt
So I will first delete the .bmp file and the File1.txt and at last the directory.
My problem is as follows. When I press Button1 the First time, nothing at all was deleted but the second time I press the Button1, the .BMP file and the File1.txt were delete fine.
But the code breaks at this line and says that the directory isnīt empty. But the directory is empty as I can see when open it manually.
So initially my problem is why the .BMP, File1.txt and the directory arenīt deleted at the first press of Button1 ? (ListBox1 has AutoPostBack set to TRUE and everything is put inside an updatepanel)
I have 3 gridviews in one of my web page, each of which will display different data based on the typeid. I have simplified the system structure in the image below(further description will be stated below the image):
As shown in the image above, the web site(presentation layer) will work closely with the Business Logic layer(BLL) and Data Access Layer(DLL). ObjectDataSource control will be the middle man to select, update, insert and delete the data in the gridviews.
During Select, returned data from the database at DAL will be stored in a datatable and return to BLL and then the website itself.
[code]....
However, the Update(command button) and Delete(template field) doesn't work,the RowUpdating and RowDeleting event wasn't trigger when I click on the button, but it works if I set the gridviews' datasourceid to the objectdatasource.
I am trying to create an Abstract class that looks like the following (note that I coded it right inline here so it may not compile):
[Code]....
I want to (in my edmx design) be able to inherit from EntityBase and have each of those 6 columns be added to the physical database table representing the object that inherits it. So, for example, I have a class called Test that would look like this:
[Code]....
That Test class should have its physical data store mapping based on the other "stuff" plus the properties inherited from EntityBase. Thus, the database table for Test needs to also include those 6 columns from EntityBase. However, I'd like for it to be set up in a way so that they get mapped such that in the edmx design (what is that designer called anyway) when an entity inherits from the EntityBase, I don't need to do any further work to propogate those 6 columns over to the underlying database table. Am I making sense in how I am explaining this? how to accomplish this?
On a side note (and this can be answered separately or not at all) assuming this mapping is in place, NHibernate has a concept called an Interceptor. I'd like to add an "interceptor" to the delete function of any entity that is inherited from EntityBase so that it updates DeletedAt with the current time and DeletedBy with the current user and the same would be true for any updates with UpdatedAt/By. With NHibernate, you can test inside of this interceptor whether or not the object is of a certain type (e.g. object is EntityBase). Any ideas on how to get this with EF 4.0?
I have a folder "Admin" having access to administrators role. When someone other than administrators tries to access the pages inside admin folder, it is redirected to login page. My expectation is to display "NoAccess.aspx". Whats wrong with this code? Or is there other meaning to statusCode=403.
I am loading a Usercontrol with another Updatepanel inside of it. Now in this usercontrol, i have a button which is registered as an async postback trigger for the 2nd Updatepanel. However when I click the button, nothing happens. While debugging, it does not even step into the Click event of the Button which sits in the usercontrol of course. The Parent Updatepanel ist set to Updatemode conditional and hildrenAsTriggers="false". The nested UpdatePanel2 is set to Updatemode=Conditional. I just want the Parent Updatepanel to do nothing and the button to fire its event so that I can load some data in the nested updatepanel.
I have develoed a vb.net application for my client. I have been using datareport for that. The Data report get the output from the dataset file with the parameter. Now we need to show the value order by. For this i have added the order by in sql query which is generated by .xsd file. But still the output does like,...................
I have added a new route to Global.asax in order for me to create some nice seo friendly URLs for some news items I am displaying
routes.MapRoute( "News", // Route name "{controller}/{action}/{id}/{title}", // URL with parameters new { controller = "News", action = "Story", id = "", title = "" } // Parameter defaults ); routes.MapRoute{"Default", // Route name "{controller}/{action}/{id}", // URL with parameters new { controller = "Home", action = "Index", id = "" } // Parameter defaults );
The problem I have is that when I now hit my home page I am getting [URL] displayed in my URL rather [URL] which is what I used to get. I think the news route is picking up everything. Has anyone any ideas on what constraint I could put on the news route above so that it only ever processes requests from the news route. I was thinking of doing a reg ex on the title and excluding anything with the '-' character in it but I coud not get that to work
I am using accordin menu in my site, placed in Master Page, It has 4 pane, each pane have multiple links. it was working fine previously. But suddenly it is displaying this error message There is no source code available for the current location.
It's is asking for show assembly. When I clicked on that I got a stopage at the stack
0000001a mov eax,dword ptr [ebp-0Ch]
I am really not sure what does it means. Also, there are several links in accordin menu, after clicking on anyone of the link I am not able to click the other link, might be because of the above reason.
I am trying to use the ASP.NET regularexpressionvalidator to apply a password policy that enforces the following policy:
Password should include at least 6 characters, at least one small letter, at least one Capital letter, at least one number, and at least one special character. Here is the expression:
The strange thing I found is that it works fine except with the following scenario, If I use all the required combination without special character such as Hello123" it finds it as valid password. below is the controls used for testing.
I have developed a ASP.Net Server custom control in C# for 3.5. named "myCheckBoxList" inherited from CheckBoxList web control. Working is very simple. It just works as a two option buttons. I have taken a CheckBoxList which will show two fixed checkboxes always. When I check one checkbox then another will uncheck as vise versa. This control works perfectly only when I have placed only one instance of that control on web page. If I place more than one instance of control then it doesnt works.
I need solution from expert minds from developers as stackoverflow users.
I have created a simple app with a page having a server side form, three fields and a button that submits and performs two operations - 1) adds the form fields to the database table 2) sends an email. Now everything works fine on the web browser on my machine but when I access the app through my mobile, the page does not seem to work. the UI and all are set but the button click functionality doesnt seem to be working and also the label which is set after a successful submit is already visible and showing the "thank you" message. Am i doing something wrong here? I have checked the app on Nokia Smartphone browser, android phone, and iphone simulator.
I have to show some functionality similar to accordion that is of jquery so i made a custom function of jquery to produce the effect. there is a grid view in which there are two div's here is the code.
The second div has style property display none. by default all the div are closed. than i have made a js function that uses the toggle function to perform the action code.
function testToggle(testDiv) { debugger var sntHdnValue = $('#hdnSetFlag').val(); if (sntHdnValue == 1) { $(testDiv).find('div:first').show().attr('isOpen', 'true'); } else { $(testDiv) .parents('table:first') .find('div[isOpen=true]').removeAttr('isOpen').toggle('slow'); $(testDiv).find('div:first').show().attr('isOpen', 'true'); } sntHdnValue++; $('#hdnSetFlag').val(sntHdnValue); }
here i have made use of the hidden field that let's me know that it is the initial state every thing is closed i am adding a custom attr isopen for my identification
1)the current situation is this At load everty thing should be closed. 2)than at a time only single div should be open. this is working fine. The problem is if i click on the same div that i clicked to open than it has two custom attr isopen now it breaks the second case. how to solve it.
dear all, my requiredfieldvalidator is screwing up my ok button in my modalpopup and I dont know why. In otherwords, once I include my requiredfieldvalidator and the user clicks ok in the modalpopup, the ok doesnt get fired. see my code below.
