DataSource Controls :: Filter SQL Queries Based On The Store ID Associated With A User ID?
Jan 16, 2010
I am planning a project for a pharmacy to enter quality control data to generate reports and graphs with Crystal Reports. There are 20 stores, I need to password protect the entrance page, giving each store their own username and password (just one per store is fine), allowing the store to only access that store's data. Each store will have an associated ID in the MSSQL table.I am using the Membership Provider. I know I need to implement user roles for Managers and Stores levels (Managers can run reports for all stores), I wonder if I can set the default store ID for insert/edit templates after that specific store logs in.Basically, I think I need to filter SQL queries based on the store ID associated with a user ID. I have seen a .NET site that, after logging in, you type in a store id into a textbox, and it gives you access only to that stores data. Something like this would work for my situation.Can anyone explain or show me an example for the best method to accomplish this with C#?
View 2 Replies
Similar Messages:
Oct 20, 2010
I have enabled User Rolls and assigned several Roll names such as 10, 11, 12, etc. I have a SQL Table that contains various fields of information including one named AuthorizedUserRoll, it's nchar(2).
A logged in user should only see the records in Gridview that matches his/her roll.
I'm using Web Forms and VB.
View 1 Replies
Jan 26, 2010
I am currently trying to implement a small class attendance system, where the student names are taken from a database, stored in a List<Student>, and bound to a Repeater control. Each row of the Repeater contains two columns: The first is the student's name, and the remaining column contains a RadioButtonList with three ListItems (Present, Absent, Sick).Now, once the user presses "Submit", I want to be able to store their attendance status based on the user selection. However, after submission, the SelectedIndex is always 0, no matter what option is selected.
View 8 Replies
Jan 26, 2010
I'm trying to conect to the Team Foundation store to get the work items from the user who was authenticated in the TeamFoundationServer but I'm getting all work items from all users. I was expecting to find the "Alias" or "AssignedTo" in the WorkItemCollection and filter the correct user from there but there's no correspondent field, so I think I should change sql query but I don't know how. As far as I've got see the code bellow:
[Code]....
View 3 Replies
Apr 29, 2010
I have a gridview which I am binding through code behind, I want to filter the gridview based on the value given by the user in textbox. It would be great if I'll be able to filter the gridview without any postback.
View 3 Replies
Aug 30, 2012
I have a page that loads a two different files that the user uploaded during page_load. The code is an example I used from the aspsnippets site. The files are stored in a server folder while the location is saved in the database. The code below gets all files in the folder and binds them to a gridview.
Dim filePaths() As String = Directory.GetFiles(Server.MapPath("~/Uploads/2012/emp/"))
Dim files As List(Of ListItem) = New List(Of ListItem)
For Each filePath2 As String In filePaths
files.Add(New ListItem(Path.GetFileName(filePath), filePath))
Next
gvEmp.DataSource = files
gvEmp.DataBind()
What I want to do is to get only one file per user as the fileID along with the location is saved in for every user. I ran a query to get the fileLocation and pass that location stored in the database instead of the current server path but I can't figure out how I would do it.
View 1 Replies
Nov 18, 2010
I have five textboxes(tb1, tb2, ... tb5) on the page, each textbox represent a column in the database table.
I need to search the database table based on the text in the textboxes. User can either enter text in all five textboxes or none.
What's the best way to do a search?
I am thinking for one textbox(tb1), depends on if tb1.text is empty or not, I need to do 2 searches
[Code]....
for two textboxes(tb1 & tb2), depends on if tb1.text and/or tb2.text are empty or not, there are 4 combinations, so I need to do 4 searches
[Code]....
for three textboxes, there are 8 combinations,
Does that mean for five textboxes, I need to do 2 to the power of 5, 32 combinations, 32 if statements?
View 1 Replies
Feb 1, 2010
i've got some problem reading excel files to store into sqlserver database. currently my code has a fileupload control and a button for me to save the excel file into a folder and read the data inside the excel file and write it into the sql database. The code works only if the excel sheet name is Sheet1.xlsx, however i tried upload a diff file named ImportUserFile.xlsx and it gave me the exception below. 'ImportUserFile$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. i have also tried other file names and it seemed only Sheet1.xlsx works.
[Code]....
View 1 Replies
Mar 5, 2010
SELECT 1000000*QuantityNC/Quantity AS PPM FROM [table1] However I need my WHERE clause to do thisI need the above calculation depending on BusUnit, which is linked to PartNumber, which is in the above table. also it has to be by Company (which is selected from a dropdown). And also based on the current month and year.
PartNumber and CompanyName are in [table1]
BusUnitID, PartNumber, SupplierID, are in tblParts
BusUnitID and BusUnit are in tblBusUnits
View 2 Replies
Jun 28, 2010
I need to fire sql queries in my website and get the results from the Database. for example: I will give select * from emp in a text box. It shud return the results for me. DO any of u have a sample/links of such application, through which i will be able to implement in my application share me the links/sources/app if u have any.
View 2 Replies
May 7, 2015
How do each company select customer orders by company username and customerid . The application will be used by many companies for sales, but o don't know How each company can select their customer orders by customerid and company username.
View 1 Replies
Feb 11, 2010
(ie.)C-Chennai
B-Bombay
-Hydrabad
A-Andhra
K-Karnataka
It may comes any order but (cbhak) is constant. i need to bring this in query, i dont want to use any funtionHow can i acheive this result
View 2 Replies
Apr 26, 2010
I get from SQL Server Server Data. I need to use datas form 2 colums of my SQL query for a VB.NET. The VB.NET need 2 values for both colums and produce 1 answer. I what to display the value on the same line instead of the 2 1st values. How can i store the 2 colums wich lot of SQL values on my vb.net script and diplay the result with the other data from the SQL query ?
View 3 Replies
Aug 9, 2010
I have a gridview that I'd like to have changed based on a value selected in a dropdownlist. I'm able to get the aspx page to display the dropdown list (comming from SQL), and when I select a value, the page reloads, but no data show in the griview.
[Code]....
Here is the aspx page:
[Code]....
View 8 Replies
Dec 23, 2015
How to create reporting screen and show it either into gridview or list view?
See below as my report criteria:
Step 1. User will choose either want to display by Depatment or Year?
Step 2. Press Select Button
Step 3. Data will show as per user request.
View 1 Replies
Mar 12, 2013
I have a gridview with id , name ,age, DOJ
if the DOJ will reach the today date that corresponding row can remove from grid automatically but only in grid and not from the database
View 1 Replies
Feb 26, 2010
how to wrote stored procedure for check two queries result this result is same return true value its not same return false value
View 2 Replies
Feb 4, 2010
I know there has to be a way to do this but for some reason I keep getting it wrong. I have one query which pulls all of the cities from a zipcode database like so:
[Code]....
Then I have another which counts the records from a transactions table per city, like so:
[Code]....
Only the zipcode is stored in the transactions table, so the idea here is to get a list off all the distinct cities that reside in the state. Once I have the cities, I want a count for each city as a whole, so I need to go back in and get all of the zipcodes that make up one city, and then count the transactions for those zipcodes. It works using the first query above, looping through them and then executing the second for every pass. But shouldn't there be a way to do it all in one query?
View 4 Replies
Jul 28, 2010
I'm currently working on a FOREX Live Trading project that I'm implementing.
I already have a database that stores the CURRENCY PAIR, BUY/SELL, PRICE AND QTY.
But I have a huge problem.
Scenario that is:
A person BUYS EUR/USD at a PRICE of 1.29900 @ quantity 100,000. (This will be recorded in the database table)
Then he BUYS EUR/USD at a PRICE of 1.29950 @ quantity 100,000. (This will then be recorded in the database also)
Then he decides to SELL his EUR/USD at a PRICE of 1.31000 @ quantity 200,000 all out. (How can I check from the database if he previously had make a transaction of BUY/SELL, so that I can do my necessary calculations for the P/L Statement)
View 3 Replies
Mar 17, 2010
I am having trouble with queries because they are not returning the data needed, and I am having trouble figuring out why because I only am testing with 2 records.First I want a query to return all records for one customer as follows:
[Code]....
There are two records with the customerID of 1, but it only returns one,next I try to return only one record, the AccountPrimary or customer_contacts.IsPrimary, but when I add " AND customer_contacts.IsPrimary = 'True' "at the end of my query it then returns both records, but only one IsPrimary = True and the Other = False. Is it backwards? I also tried another method and it returned 30 of the same record and I only have 2
View 4 Replies
May 11, 2010
I have a database of cars manufacturers and their car models. I want to have buttons above the GridView, each button listing a manufacture. When the button is clicked, the Gridview will filter the data to only show the models by the manufacturer clicked. I don't want to use a listbox or combo box, it has to be 3 rows of individual buttons or links.
I am using VB.net and I was able to do this with the dropdown box, but it is not as clean as having a row of buttons.
View 4 Replies
May 7, 2015
how can set on focus Datalist on Button Click Event for Search show datalist data asp.net?
I want To Show My Dalatist Item When The User Click On Search Button for item Search
View 1 Replies
May 7, 2015
As per ListBox Items a data should show in GridView by using UP and Down arrow keys. I tried by using Oonselectedindexchanged but when a page loads from listbox the cursor become active to inactive.
View 1 Replies
Jul 10, 2012
I have successfully implemented article - "Print only the items which are selected using checkbox in a ASP.Net DataList control"
I would like to add a dropdownlist above the DataList Control to filter the contents of Datalist and then print the items selected using Checkbox in a ASP.NET DataList Control.
View 1 Replies
Jan 24, 2016
I have following situation
1. I have gridview which is bind with sql data source column name industry
2. I have checkbox list which has all industry name,
3. I want to pass checkboxlist selected value to sql data souce to filter data in gridview.
View 1 Replies
