DataSource Controls :: Viewing Permissions For Functions?
Apr 6, 2010I'm trying to view a list of uses that have the execute ability on a function, but I cannot find a method to do so.
View 2 RepliesI'm trying to view a list of uses that have the execute ability on a function, but I cannot find a method to do so.
View 2 Replies[Code]....
View 3 RepliesI have created a .edmx for the northwind database. When I run the following statement, the correct number of detail records are retrieved and I can access the detail fields, but how do I access the order header record to view OrderDate, ShipAddress, etc...?
[Code]....
getting the Parameters declared in an sql function in the C# code. We can actually get the parameters from a Stored Procedure by giving SqlCommandBuilder.DeriveParameters
Similarly is there any way to get the Parameters from the SQL Function.
Is it possible to use Exec statement in SQL Functions
like..
[Code]....
I'm trying to create a class, DataCommon, to contain all my SQL Data manipulation functions. I've created a Subroutine called Init that initializes a SQLDataAdapter:
[Code]....
From my other classes I am creating an instance of DataCommon, calling Init, and calling another subroutine in DataCommon that pulls data from SQL and loads the data into my dataset. This part is working great -- no problems at all. I'm loading three different Datatables in the Dataset with no issues.
At this point, I'll perform my various manipulations on the datatables -- add/delete/modify rows -- again with no problems. All of this is creating postbacks...and this is where my problem begins. After I've done all my manipulations to the data and am ready to update my SQL tables, I have to re-initialize my SQLDataAdapter. I thought I could do something like:
[Code]....
But I get the error: Exception inserting Class. Thread was being aborted.
In my initial data load from SQL, each datatable is getting loaded from a single SQL table, so I was hoping to use the autogenerated Update/Insert/Delete statements by the SQLDataAdapter. As a test, as soon as I filled the dataset initially, I added a new row to one of the datatables and used the SQLDataAdapter.Update() method before a postback occurred, and it worked perfectly.
So, with all that being said, I guess my question is, how do I reconnect the table mappings between my SQLDataAdapter and dataset to autogenerate the updates after a postback occurs? I've tried researching this, but I get confused after reading about FillSchema vs TableMappings vs everything else I've read about.
I have a database which contains details of around 1000 people with almost 20 fields.
View 1 RepliesI need to find how many users are viewing the website currently and need to display somewhere in the application.And also how many users are visiting daily and how many visited till date.
View 1 RepliesMy grid doesn't show on the web form when I configure its datasource to access the link table and display data from the receiver table. Both link and receiver tables are associated/linked in the .dml file. Any ideas why the grid doesn't show on the form?
View 9 RepliesHow can we view images using grid view control, when i configure grid view data source selecting images from the database, it shows images in the window when i test query, however after viewing the actual grid in the browser the images doesn't shows. also is it possible to view image size according to my requirement.
View 3 RepliesI have made 3 web controls which need to be accessible between eachother. First control is main control (controlA). Other 2 controls (controlB and controlC) are referenced in controlA. Now i need to access function from controlC and call it in controlB. I tried adding new reference, but it doesnt work the way I want it.
ControlA is main control and it is merely a table to hold other 2 controls in place. I can access both controls from controlA, but since I need to modify controlC due to drop down menu in controlB i can't force controlA to respond to event in controlB every time it occurs and affect controlC. Or can i? :)
So whenever the event (SelectedIndexChanged) of drop down menu occurs in controlB, I need to set up/change controlC. Problem is, I don't know how to call function from controlC. It may sound very simple to solve and i tried to make a new instance of controlC class in controlB my webpage just wouldn't load.
i have a database with several paths looking like the one below
C:S&M Site ProjectNEWSMAASitePhotos2GUY093GUY093-Tulips.jpg..
What i aim to do is load the images into a gallery control (if one exist)the users viewing the images should be able to do either of the following:
-Double click on an image to see it bigger or some large predefined size.(thats the viewing part of it)
-Select those images the want and then extract it as a single PDF file to any location on the user machine.
-print all selected images.
-Remove all selected images from the gallery as well as the image path from the database.
I have an ASP.NET control (a button) in a WebApp. It has an onclick attribute:
onclick="SaveButton_Click"
SaveButton_Click()
is a C# function in the codebehind file. When the user clicks the button, SaveButton_Click() is executed.
What I would like to know is whether there's a way to set up a javascript callback junction. I know how this is done in AJAX, but I'm not sure in ASP.NET (with controls that run on the server) how (or if) this can be done.
I'm looking to add controls dynamically to a table across multiple functions. I'm trying to convert this from a C# app to a web app using asp.net, though this is my first time using asp.net with no web development background. I read the creating tables dynamically in the FAQ but I'm still not sure how to do this.
When pressing the submit button on my form, it will create a table in a place holder. Eventually I would like it to generate urls based on the users input and do this in a function other then the one I created my table in.
In my C# app I was able to add text to a listbox using: lstOutput.Items.Add("Text"); across multiple functions but I'm having trouble doing this with a table.
I understand that my table is a local variable in the submitButton_Click function, but how do I make it global to add rows, cells and controls to it in other functions?
My current code which doesnt work:
[Code]....
I have been researching this issue for a couple of days and have found a lot written about it, but none of what I have found has fixed the problem I am having.
I work for a school system, and my principals are wanting to take a list of the staff members at their school and create staff lists for different activities they perform. I thought I would load the staff into Gridveiw1, and when they select a record have it move over into Gridview2 and "delete" from Gridview1.
I am loading my full staff into a datatable (SQL Server backend), and setting this datatable as my gridview1 datasource. At this point, it loads great, and cosmetically speaking sorts and pages fine. The problem occurs in the codebehind after a Sort or Page change has occurred -- when I select a record and move it over into Gridview2, it is moving the original record that was at that postion on Page 1 instead of the sorted or "new page" record.
So if the initial list comes in as:
Teacher 1
Teacher 2
Teacher 3
The sort button is hit so that the list now starts out like:
Teacher 7
Teacher 13
Teacher 5
If they select "Teacher 13" to be moved over after the sort, instead it is still moving over "Teacher 2" -- the initial teacher in that index before the sort.
The Gridview setup on my aspx page looks like this:
[Code]....
My codebehind:
[Code]....
how can i store image into database and view it in grid view?
View 3 RepliesI am trying to show data on a datalist, but with some caveats.1. WHERE the User Id = the querystring id pass on the url2. WHERE the table 'resume', the 'permissions' column shows as '1'orWHERE the table 'resume' the 'permissions' column contains within it any number from 2-4, any of which matches one or more numbers in the 'permissions' column of the 'contacts' table (but WHERE the 'contacts' table where the url querystring id = column 'myuserid' and the signed in Profile.UserName = the column 'theiruserid'Its complicted, but i dont know how to reference another data table when selecting data from the first table...?
View 5 RepliesIs it possible to use a small .NET page to set folder permissions on some folders on the server where it resides? What is the code or objects that can be used for this? I am on Windows Server 2003.
Basically I want to hit the page with a GET or POST and have it run and check and/or update the permissions on a folder.
I am a windows application developer doing a web application with VB.net and SQL 2008 for the first time.I have developed a web application where users are supposed to view a file after selecting from a listbox. I then pick the users logon ID from windows then store in database and produce statistical reports later. It was working fine on my local machine till i deployed it on server to make it accessible on the intranet. The server OS is Windows 2008 Server and runs IIS. My issues are as follows,1. The application is unable to store the user logon id from the client.2. When more than one user uses the application, then there are errors but one user does not produce errors.
View 1 RepliesScenario: Table Name:Emp ,Columns:id,name,sal
I have a combobox which is populated by id which is there in a database. And two Textboxes Name,Sal to insert Name and Salary of the Employee. I have no problem in inserting the datas to database and viewing all the inserted datas.
I got issue when I tried to view name and salary of the employee when a particular id is selected from combobox and finally clicking on a button to get the name and salary in the textboxes.
string str = ComboBoxName.getSelectedItem();
and a command as :"Select name,sal from Emp where id = +str"
I am viewing a file on my web page
Response.WriteFile(filepath).
In IE, if I view document properties or if I click File - send, the document name is the name of the web page - pdfviewer.pdf. How can I specify the file name, without prompting the user?
I am calling example.exe from asp.net web-page. Example.exe contains Process.Kill(), but I am not able to kill that process whenever Ill run example.exe from asp.net web page. I think i need to set some permissions for killing processes. What permissions must a user have to be able to succesffuly execute a rocess.Kill? Note : it is working when I double clicking on (example.exe), means its killing some processes
View 2 RepliesI am getting following error on uploading my pages on web server. it working file on my local machineRequired permissions cannot be acquired.
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
[Code]....
We have a web application that runs on a WIndows Server 2008 64 bits machine. The app's ApplicationPool is running under the ApplicationPoolIdentity and configured for .net 2 and Classic pipeline mode.
This works fine up to the moment that XmlSerialization requires creation of Serializer assemblies where MEF is being used to create a collection of knowntypes.
To remedy this I was hoping that granting the ApplicationPoolIdentity rights to the ASP.Net Temporary Files directory would be enough, but alas..
What I did was the run the following command from a cmd prompt:
icacls "c:windowsmicrosoft.netframework64v2.0.50727Temporary ASP.NET Files" /grant "IIS AppPoolMyAppPool":(M)
Obviously this did not work, otherwise you would not be reading this :)
Strange thing is that whenever I grant the Users or even more specific, the Authenticated Users Group those permissions, it works. What's weird as well (in my eyes) is that before I started granting access the ApplicationPoolIdentity was already a member of IIS_IUSRS which does have Modify rights for the temporary asp files directory.
And now I'm left wondering why this situation requires Modify rights for the Authenticated Users group. I thought it could be because the apppool account was missing additional rights (googling for this returned some results, so I tried those), but granting the ApplicationPoolIdentity modification rights to the WindowsTemp directory and/or the application directory itself did not fix it.
For now we have a workaround, but I hate that I don't know what is exactly going on here, so I was hoping any of you guys could shed some light on this.
I'm uploading an Excel file and then reading data using oledb connection in asp.net but I'm getting the following error: The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.
Dim ocmd As New OleDbCommand("select * from [Sheet1$]", conn)
Line 12: conn.Open()
Line 13: Dim odr As OleDbDataReader = ocmd.ExecuteReader()
conn.open() line is red highlighted for error.
The excel file is uploaded successfully and present in the folder.