DataSource Controls :: SQL Function 'WITH ENCRYPTION'?
May 12, 2010How can I put a SQL Function as 'WITH ENCRYPTION' like you can with a Stored Procedure?
View 2 Replies
Similar Messages:
DataSource Controls :: Algorithm For Simple Encryption And Decryption Of Field In Sql Server 2000?
Jan 2, 2010I have to Encrypt and Decrypt Back the Password field in sql server i have used the pwdencrypt and pwdCompare() but i dont have to compare but i have to display the password back using the Decrypt technique Is there any algorithm which i can use only for encryption and decryption of password field?
View 4 RepliesDataSource Controls :: How To Use Cursor In Recursive Sql Function (scalar-value Function)
Apr 25, 2010how can i use cursor in this function ?
ALTER FUNCTION [dbo].[GetCatIDChilds]
(
@CatID [code].....
Security :: Encryption Algorithm - Encryption Of Data Required In The Coding?
Sep 16, 2010Not sure if I'm posting the question in the right category.
1) I'm working in a project where encryption of data is high priority. Could some one suggest what would be the best encryption method to protect data from being cracked.
I'm using TCP/IP protocol.
2) Is HTTPS totally secured. If I'm using HTTPS, does that mean that there is no encryption of data required in the coding?
Database Encryption Or Application Level Encryption?
Oct 23, 2010When you need to store sensitive data such as CCs or SSNs, do you:1) Build your own encryption routine within the application, define a secret key somewhere in a config file, and then manually encrypt/decrypt data going to the database.2) Push all the problem to the database, using the built in DB capabilities (I think most vendors call it Transparent Database Encryption).What trade-offs have you find for your solution? Does writing your own routine perform poorly when compared to TDE? Is code maintainability, or conversely DB vendor lock-in an issue?
View 3 RepliesDataSource Controls :: How To Program A Search Function
Jan 25, 2010I'm on training in a company and i'm making a web application with an SQL server database..Now I created everything but i need to know how to program a search function..t's the point that when I search to a computer it'll put all the pc's with the matching word into the dropdownlist..Like when you search for "A" I get all the pc's wich has an 'A' in their name, I made everything, in the query builder I made a parameter with the textbox but i need not EXACT the value I typed but verything wich has it in it.
View 6 RepliesDataSource Controls :: Applying A Hash Function In Md5?
Jan 18, 2010I need to create a hash key on my tables for uniqueness and someone mentioned to me about md5. But I have read about checksum and binary sum; would this not serve the same purpose? To ensure no duplicates in a specific field.
How can implement this? do I need to write code in my vb application which populates the tables with stored procedures or can I do this from SQL server 2005 studio express?
DataSource Controls :: How To Complete The GetProfileValues() Function
Jul 8, 2010I have a stored procedure returned a row of data which are written in business layer logics in ASP .net C#. If I bind the data in grid view, I can read the specific cell values from the grid. However, I don't want the grid view visible to the users.
If possible, no data display at all. I only need to save two cell values into variables. how to complete the getProfileValues() function?
[code]....
DataSource Controls :: Scalar Function And Performance?
Apr 6, 2010i am calling a scalar function from a stored procedure. Does using user defined scalar finction has a negative impact on performance.
View 1 RepliesDataSource Controls :: How To Write A Function Or A Storeprocedure
Feb 17, 2010I have a tbale in database tow tables city and Intrest I need to calculate somethign like this
city1*intrest1 + city2*Intrest2 + city3*intreste3
final result I ned to asing in other column
DataSource Controls :: Creat Function In SQL Server?
Feb 19, 2010I want to know if there is a way to create a fuction in SQL Server for the following purpose. I have a select statement that pulls up a list of names from the database based on an ID which is the input parameter for the function. I want to be able to concactinate the values of names got from the query and return a String value.
View 4 RepliesDataSource Controls :: EF4 - Function Imports In ObjectContext
May 19, 2010If I create a new EDMX model and then I import a function, then I can see my function generated in the Designer. If I perform the same process but I add a T4 template (for Self-Tracking Entities) then I loose the function definition, although TT file has code adding a region named "Function Imports". Is this a bug or am I performing something wrong?
View 1 RepliesDataSource Controls :: Derived Table And MIN Function?
Feb 27, 2010I have the following query which returns all appointments for a given date, grouped by client and appointment date. For those clients that have multiple appointments on that date, I get multiple rows, one for each appointment time. I only want the earliest appointment for each client, which would result in only one row per client. If I add the MIN function to SchedTime, I'm forced to put all columns in a GROUP BY clause, which isn't what I want.Can I use a derived table and/or MIN(Schedule.SchedTime) to achieve this? Or is my thinking wrong to begin with?
"SELECT Schedule.ClientId, " +
"ClientData.FirstName, " +
"ClientData.LastName, " +
[code]...
DataSource Controls :: ObjectDataSource Delete Function?
Apr 14, 2010Could you teach me how to make girdview pass my object (with all it properties) to my ObjectDataSource delete method please?So far the object received by the delete method has only the datakey value, other properties are null.From this article indicates that this is default behaviour - ttp://www.manuelabadia.com/blog/PermaLink,guid,c72852ae-1fdd-4934-a715-f565ceaf21cc.aspxBut i need the other properties pass to the delete method too so i can do other thing before I actually delete the record.
View 3 RepliesDataSource Controls :: Return String Value From The Function?
Mar 7, 2010i try to return string value from the function i wrote for getting string value from the table for that i havecommon stored procedure
public string getdata(string str)
{
string datanew;
[code]...
DataSource Controls :: Procedure Or Function Insert_Course_edit2 Has Too Many Arguments Specified
Mar 15, 2010I dont understand why this is occurring, my store pro worked ok before (and i am very sure i am not passing too many arguments to the store pro) but since i have switched to using a "formview"control it has stopped. store pro and ASP.NET with sql data source are shown below. Apologies if the formatting nacks up.
View 3 RepliesDataSource Controls :: Calling Function In Linq Query
Apr 8, 2010I have a problem here.In my database I store member status in 1 and 0, when it come to my gridview I need change 1 and 0 to active and inactive. My company is using Linq, so I must follow. I wrote in this style, I calling a changeToWord() function to change 1 and 0 to active and inactive.
var q=from a in db.members
select new{
mem_name=a.name,
status=ChangeToWords(a.status)
}
It compiles with no error, but when I execute the page, it prompt out a error message to me.
DataSource Controls :: Call Sql User Defined Function?
Feb 13, 2010i have created a function to call username to pass user id as pararameter,
how to call userdefined function in asp.net
here is my function in sql
CREATE FUNCTION getusername
( @userid bigint )
RETURNS table
AS
RETURN (
SELECT login_id
FROM mst_useraccount
WHERE user_key =@userid
)
go
DataSource Controls :: Failed To Work With The RetrieveData() Function ?
Jan 26, 2010I've never used the RetrieveData() function and I don't know much about it.Having failed to work it out myself could someone show me some examples of how I call this method?Here's what I know about it:
1.It hadles the work of contacting the database and creating the DataSet.2. You must import System.Data, System.Data.SqlClient and System.Web.Configuration namespaces in teh web page.3. It can be called in any event handler in the web page code.I've tried typing this method in my page_Load() but I get the squiggly red underline which indicates that it doesn't recognise this method.
DataSource Controls :: Finding Function That Grabs The Inserted Identity Value?
Jan 11, 2010I have a detailsView that I use for Insert. Once a record is Inserted, I need to get the new idenetity value.
Is there some function that grabs the inserted identity value? Or do I need to query it somehow?
By the way, the reason I'm doing this is the user is inserting a record into a 'general' list that is being applied to a 'specific' list - example, an employee can select a vendor from a list, but the vendor isn't listed so the employee adds the vendor in the vedor list and while the new vendor is inserted, the vendor info is also applied to the new order record.
DataSource Controls :: How To Add Condition In Select Statement For Datedifference Function
Mar 5, 2010this is my select Statement.:-
Select (datediff(day,db_TargetDate,getdate())) from tbl_abc
in select statement only i wanted only those record in which datedifference is less than 5.
declaration of variable & then conditional checking is not wanted me because i wanted result is into select statement only & not using print statement.
DataSource Controls :: Stored Procedure And Function Returning Same Shape
Jan 26, 2010I have problem with a stored procedure and function that return the same shape, but as they are different methods LINQ won' t let me cast between the two. Please see code for the two SPROCs below (This is actually simplified to represent the problem, so please don't spend lots of time explaining alternative ways of writing the function/sproc.)
Table Valued Function
"getCategories()"
SELECT categoryName, categoryID FROM categories
SPROC "getUnusedCategories"
SELECT categoryName, categoryID FROM CategoryInstances cI
FROM dbo.SMAN_getCategories(@SiteMANID, @SectionID) c
LEFT JOIN @EntityResultsTable er
DataSource Controls :: How To Declare Scalar Variable @UserName In Function
Jan 14, 2010How do I define @UserName in my function:
[Code]....
I believe "UserName" = Me.User.Identity.Name
but I don't know the proper way to add it to the function.
DataSource Controls :: GridView Update Function Doesn't Work.
Jan 27, 2010 I got a gridview to display the data from the database properly but when I go edit. it give me an error. I searched and change ConflictDetection=CompareAllValues to OverwriteChanges
The error goes away. However the database is still doesn't update. Does anyone had to tweak the gridview function to make it works. Maybe I did something wrong.
DataSource Controls :: How To Pass A Result Set From A Linq.dataquery To Another Sub Or Function
Feb 1, 2010I'm trying to populate a treeview control using linq.
I use the following code
[Code]....
how can I declare c in fillChildren