.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

End user linking many to many relationship - how to setup process in FormView / GridView / other?

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :ASP.Net
 

Having a serious brain fart and can't seem to think of a way to handle the following:

Our business has 17 stores who all perform a nightly reconciliation comparing physical totals to our point of sale z-out reports.  They enter the data into a DailyReconciliation table.  This is all done by store management.  Then at our corporate office our asst controller takes each days receipt totals for cash, electronic check, Amex, and all other Credit cards for every store and compares them to the bank statement lines.  We are attempting to move to a manage exceptions approach in order to save time.  She's barely able to keep up with work load and we are looking at adding 6 new stores by the end of the year.  I've written SSIS package to upload the bank statements to a BankStatement table and perform a link to the receipt id from the DailyReconciliation table where the amounts match in dollar and transaction type and fall within an acceptable date range difference.  It's all working beautifully EXCEPT that sometimes the Amex totals on the bank statement include multiple days totals for a particular store.  I set all this up under the impression that it was a One to Many relationship (One DailyReconciliation receiptID to Many BankStatement bank_recordID -- in other words 1 store's reconciliation record for a day would include Amex tot


View Complete Post


More Related Resource Links

Many to Many Relationship / Gridview and end user linking process

  

Having a serious brain fart and can't seem to think of a way to handle the following:

Our business has 17 stores who all perform a nightly reconciliation comparing physical totals to our point of sale z-out reports.  They enter the data into a DailyReconciliation table.  This is all done by store management.  Then at our corporate office our asst controller takes each days receipt totals for cash, electronic check, Amex, and all other Credit cards for every store and compares them to the bank statement lines.  We are attempting to move to a manage exceptions approach in order to save time.  She's barely able to keep up with work load and we are looking at adding 6 new stores by the end of the year.  I've written SSIS package to upload the bank statements to a BankStatement table and perform a link to the receipt id from the DailyReconciliation table where the amounts match in dollar and transaction type and fall within an acceptable date range difference.  It's all working beautifully EXCEPT that sometimes the Amex totals on the bank statement include multiple days totals for a particular store.  I set all this up under the impression that it was a One to Many relationship (One DailyReconciliation receiptID to Many BankStatement bank_recordID -- in other words 1 store's reconciliation record for a day would include Amex tot

How to let user edit selected gridview columns, not entire row

  

Hello!-

I've got a gridview I would like to let the user edit a couple of columns.  Seems like everything I'm coming across so far makes the entire row editable.  

Hopefully the solution isn't too complicated.  Can someone point me in the right direction?

 


Data Deployment: Streamline Your Database Setup Process with a Custom Installer

  

Database setup can be a tough and time-consuming process and sometimes fall victim to human error. Microsoft Installer or InstallShield can help, as can your own custom installer. In this article, the author tackles one approach to writing database installers and demonstrates the process with a working code sample.

Alek Davis

MSDN Magazine September 2004


Insert data based on gridview user value on row.. how to

  

Hi..

I have three column comes from database table(Table1) and one column is for entering data for the user let us consider it look like this 

ItemNo ItemName Qty  uservalue

001       A               50       20

002       A               20       5

003       B               50  

004       C               60      10

005       D               40 

006       E               90      15 

........

If its 300 row from database to gridview it will show 50 record with page navigation..

What i need is i need to insert data in to database table which gridview row has user value..

The output of the another table(Table2) will look like this after insert

ItemNo ItemName   uservalue

001       A                    20

002       A                      5  

How to process data AFTER page is completely loaded for the user?

  

I have some logging that has to be done, which are some database update or inserts.

However this logging is of no importance to the user, so I only want to process the data/logs after the page is completed for the user.
As of now, if I process the data while the page is loading, I go from 1.4 to 2.0 speed (server side time processing of code), which is quite a bit comparing it is of no use to the user.

So I want this code only executed after that the page is complete.


I've been checking out Ajax, async pages etc, but the problem is it still gets executed before the page is rendered to the client, which means the client will have to wait longer then it is not being processed.

I've been checking out Threadpool.queueBackgroundWorker, however if I get it correct, this will still be executed before the page is shown to the user, as it has to complete before the prerender.

Then I thought about creating a new thread, and do the processing there, which would not have my page waiting to complete the data/logging.
However when I have 100 or 200 users loading pages at the same time, then that would mean I would be creating 200 threads on those loads, which I doubt will be good for performance. So if I want to solve this, I would have to create my own threadpool and only assign for example a max of 40 threads to it which can pr

Failed to generate a user instance of SQL Server due to failure in starting the Process for the User

  
Could someone help with this please? I'm using VWD 2010 to build a new web site - I tried to add a new database file but it won't do it. I started by clicking on the folder 'App_Data', then right clicking and selecting 'Add new item' - after that I tried to add an SQL Server Database but received this message...  'Failed to generate a user instance of SQL Server due to failure in starting the Process for the User Instance' What does this mean? How do I start the 'Process for the User Instance'?  I imagined all that was done for me at the install stage, when I installed VWD2010, but it appears not.  Thank you for any help at all.    Regards

Errors attempting to process SSAS Cube. I get Either user does not have permission to create a new o

  
Hi All, One of my production server deployed cubes i am not able to process the cube.When i tried to process the cubes i will get an Error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Either the 'NA\gsad478' user does not have permission to create a new object in 'JNJAUSYSVR01', or the object does not exist.  (Microsoft.AnalysisServices)   Over the source server i do have sysadmin access and also  i have added read only role of particular cube. I right click on the database and tried to create new database of SSAS that also thrown with same error. Please help me in this regard.   Thanks, Gangadhar

How to launch EULA.rtf for the end user agreement before the winforms setup project (installer) actu

  
Hi, I am using Setup Project to create installer for my windows applcation. I need to have the user read and accept to the terms in EULA document. So this has to be displayed BEFORE the installer installs the applciaiton. I tried adding the EULA file via Setup Project-> Application Folder -> Add -> File -> EULA.rtf assuming that installer will identify the license file by default and display it before installing the app, but it did not. Please Help.   Thanks

editing gridview in a formview in a formview... yikes.

  
Oh dear - I don't know how it came to this but I could really do with a bit of help.I have a gridview which has editable columns. The gridview lives in a formview, which lives in another formview.Inside one column is an end date. This column has a textbox which gets it's value when I choose a date from a calendar control. However, when I choose a date from the calendar control, the program crashes instead of populating the text box.Here is the page and the selectedIndexChanged sub for the piece of work I'm trying to accomplish...dim rowid as integer Protected Sub Calendar2_SelectionChanged(ByVal sender As Object, ByVal e As System.EventArgs) 'Assign value to textbox from Calendar Dim tmp As FormView = Me.FormView1.FindControl("formview3") Dim tmpgridview As GridView = tmp.FindControl("gridview2") CType(tmpgridview.Rows(rowid).FindControl("textbox3"), TextBox).Text = CType(tmpgridview.Rows(rowid).FindControl("Calendar2"), Calendar).SelectedDate End Sub Gridview2 is inside formview3 inside formview1I have included the whole page below, but the problem area is gridview2<%@ Page Language="VB" MasterPageFile="~/myMasterPage.master" AutoEventWireup="false" CodeFile="user_profile.aspx.vb" Inherits="user_profile" title="View Profile - A

Looking for suggestions or ideas how to setup to capture search criteria and present to user if they

  
Requirements call for the ability to save search values so that they can select them at later times to return the results without having to re-enter the values. They have the ability to search on 4 different types of data (Date, Time and Lat/Long), so they would like to capture what was entered and ONLY if they chose to save those values, it will be saved and next time they login, if they are searching, they can pick an old search and submit it again.   Im thinking that i add a checkbox next to each button, if they check it, it saves the data into a table with there values and username. Next time they login and go tothe search page, if there are any records for them in the table, i present them with a link that displays all the values stored and if they select one, it will run the search again and present them with the results.. does that sound like the right way to handle this request? 

Referencing a linkbutton which is within a formview which is within a gridview template

  
Hello forum.  I have a gridview (gridview1) which contains a formview(formview1) which formview contains a linkbutton(linkbutton1).  I'm trying to  get the linkbutton's click event to redirect to page2 with a querystring value that's the linkbutton's text value. Something like this:   Response.Redirect("~/Page2.aspx" + "?" + "E=" + LinkButton1.Text)How do I reference LinkButton1's text value in code behind so I can pass it to Page2 through the query? Thank you  

Failed to generate a user instance of SQL Server due to a failure in starting the process for the us

  
Hello,Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed. I'm using SQLServer2005 and VWD2010. Did the following below but to no avail. 1.) I have set SQL SERVER (SQLEXPRESS) built-in account to "Local System" at SQL Server Configuration Manager. Restart.  2.) Couldn't find the folder "SQLEXPRESS" at Vista c://Users/[username]/appdata/local/microsoft/microsoft sql server. Is there anything else I miss before doing my last resort? FORMAT my pc and hope it will work the next time.I'm using SQLServer2005 and VWD2010. I Did the following below but to no avail.1.) I have set SQL SERVER (SQLEXPRESS) built-in account to "Local System" at SQL Server Configuration Manager. Restart. 2.) Couldn't find the folder "SQLEXPRESS" at Vista c://Users/[username]/appdata/local/microsoft/microsoft sql server.Is there anything else I miss before doing my last resort? FORMAT my pc and hope it will work the next time.Thank You,-imperialx

Adding user names when updating gridView

  
Hi All,May be this is a begineers question, could someone help on this please?I'm using a windwos authentication via intranet. I'm able to display the username in a label control on a page load event (which is very simple). I'm not storing this data anywhere in the table (MS SQL). I have all my data in a table and I'm using a gridview to diplay them. I'm using a button control to update all the rows in the gridview. I wanted to update three columns in the gridview (1. Tickbox, 2.Datetime Stamp and 3.UserId).I've created a query in the dataset, through which i can update the Tickbox and DateTime stamp using now() function. But I'm not sure how to update the UserID field with the UserName (which inturn updates all the three fields in the gridview when the button is pressed.

Put outer-gridview in non-Edit mode when user edits inner-Gridview

  
using vb.net/asp.net 2005.(sorry last post I had the grids reversed, what I meant to say is this:I have an outer gridview I'll called "Outer" and an inner-gridview inside that I'll call "inner".There are times when the user will put Outer into edit mode and then put Inner into edit mode and change a value in Inner.  The user is not supposed to be able to do that.So when the user wants to edit Inner I need to change the edit mode of Outer so that Outer is Not editable.   EX: I want to do something like this but not sure in which event of outer to do it:'event fired when user puts inner gridview into edit mode Protected Sub Inner_RowEditing(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewEditEventArgs) Handles Inner.RowEditing 'put outer gridview into non-edit mode Outer.EditIndex = -1 End Sub Does anyone know how to do this, is this the right event?  Also I assume I have to rebind the gridview?thanks,MC

GridView crashes when user enters html open "<" or close ">" characters in a textbox

  
My GridView is bound to a sql data source and allows editing of fields. Coding is in C# and JavaScript. Using Visual Studio 2008 in test mode, if I enter a less-than "<" or greater-than ">" character in a GridView textbox an error is immediately thrown upon pressing enter: "Microsoft Visual StudioMirosoft JScript runtime error:Sys.WebForms.PageRequestManagerServerErrorException: An unknown erroroccurred while processing the request on the server. The status dode returnedfrom the server was: 500"When the < or > is entered in production, the page aborts and loads the application start page. I need to be able to catch and replace those characters BEFORE the error is thrown. I've tried hooking OnTextChange code to the textboxes, but the error is thrown as soon as I press enter...the OnTextChange code never runs. Any help will be greatly appreciated.

Custom NEW User Setup

  

I'm having trouble setting up a custom NEW User Screen.  Here is my situation, I have a Request for Access Screen that uses the CreateNewUser Wizard Control.  I want to leave the Question and Answer for this, however I also want a custom NEW User Setup which I build myself to allow the system administrators to setup users, but for this setup I don't want the administrators to have to pick the question and answer for the NEW user, so I would like to bypass this for this setup.  However, my Membership.CreateUser keeps asking for it.  How can I accomplish this?  I've included a copy of my current web.config file.  You will notice a AspNetAdminMemberhip which I use to allow the System Administrators to reset passwords.

<?

<

<

<

<

<

<

<

<

</

</

</

</

<

<

<

<

</

<

<

<

<

xml version

URGENT: Gridview/formview with entitydatasource

  
I'm trying to get a Gridview/formview working but when using entitydatasource,
How is it done with the entity framework?  I want the formview to display the data selected in the gridview for edit and I want to insert new data from the formview to the grid.
 
Any links or help is appreciated. This is urgent!!
 
 

 


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend