i created a asp.net form for registration without using login controls and a table for storing information. the passwords in the password column in the table is clearly visible in text form i want it to be in encrypted form.
View 8 RepliesI have a simple .aspx page. Where I need to connect to sql server 2008 and show the records on the page in a gridviewcontrol. It will have Edit button on the gridview control. I am getting some weird message about the connection string.
Error message is:
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.
Exception Details: System.ArgumentException: Keyword not supported: 'initial catalog'.
Web.config file:
Code:
<connectionStrings>
<add name="ConnectionString_SqlServer" connectionString="Data Source=PricingDB;Initial Catalog=DB1;Integrated Security=True;Connect Timeout=300" providerName="System.Data.SqlClient" />
</connectionStrings>
In the .aspx page this is how I am connecting.
Code:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString_SqlServer %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
SelectCommand="select name, value from dbo.Pricing order by name asc"
>
</asp:SqlDataSource>
How to inner join 2 table with primary key by no duplicate data in sqlserver 2008 ?
View 5 RepliesI have table of users with their passwords. Can I just manually encrypt the passwords now till the app is fixes that would make the encrytion process in this program? and if yes how do I do this?
View 1 Replieshow to decrypt and encrypt password in table membership in aspnet databas ?
View 8 RepliesI want to copy data from a table[tblExcel][No.of columns:2] to another table[ev_event] which has 5 columns, 2 columns from the another table, 3 columns from user defined value
[code].....
I have three web forms to insert, read and edit data. I want to display single records on each page. My pages consist of textboxes, listboxes, and images. I currently achieved reading, inserting and editing using a datareader and parameter queries. I'm wondering the best way, to design web forms. Can i use stored procedures. Using stored procedures; is more secure or not, is more stable or not,
View 9 RepliesI was wondering if there is easy solution to this or I'm stuck with following:When updating DB:
dti.Pass = Crypter.Encrypt(dti.Pass);
_db.SubmitChanges();
When selecting from DB:
Data.DbTableItem dti = _db.Single(a=>a.Id == id);
dti.Pass = Crypter.Decrypt(dti.Pass);
Meaning - I am not really into writing repetitive code and this seems like logical thing to be supported by LINQ; so I'm wondering if it is.
There is an existing classic ASP application that uses CAPICOM to encrypt a file's content using a certificate. A new file is created with the encrypted content and put on a location from where another 3rd party web application picks up the file (with encrypted content). They use the certificate to decrypt the encrypted data .
I am re-writing this piece of the software in ASP.Net and have read a bit about the encryption algos in .Net. But I am unable to come to a solution I am aiming for.
My questions:
a.) CAPICOM and .Net encryption? Any resource that has some sort of method mapping between the two?
b.) How to encrypt the content of a file using a certificate's private key? The reason I'm looking for this is this statement
The Sign method creates a digital signature on the content to be signed. A digital signature consists of a hash of the content to be signed that is encrypted by using the private key of the signer.
Source: [URL] ....
How to populate a gridview column, from sqlserver2005 database table.I've tried this:
Response.BinaryWrite((
byte[])dr["_reportattcmt"]);
But this would display data on to page. but how to do it on to gridview coloumn
Is there a quick way to query a database table in c# and push all the results into an arrayList?
View 3 RepliesI am using vs2008, Sqlserver2008.
my table: PostGL having data like thi
AutoIdx TxDate Id AccountLink Description Debit Credit
3 2010-01-22 JL 2 bcb 0 35.09
5 2010-01-28 JL 2 g 3.51 0
select AutoIdx,TxDate,Id,AccountLink,Description,Debit,Credit,(Debit-Credit) as Actual from PostGL where Id='JL' and AccountLink=2
AutoIdx TxDate Id AccountLink Description Debit Credit Actual
3 2010-01-22 JL 2 bcb 0 35.09 -35.09
5 2010-01-28 JL 2 g 3.51 0 3.51
I am trying in view like this
declare @cnt int
declare @i int
set @budget=20
set @cnt= (select COUNT(*) from PostGL where AccountLink=2 )
set @i=1
WHILE (@i<=@cnt )
BEGIN
set @tdebit=??
END
I am taking count the no of rows having AccountLink=2
I need to read all debit,credit and add all debit into totaldebit,all credit into totalcredit independently from table.
then i need to show the totaldiff as Actual.
i need ....totaldiff=totaldebit-totalcredit
i am Using sql server 2005. i want to copy the data of the excel file to the table.
i wrote the query like :
INSERT INTO test(empId,empName,empMailId,empContactNo)
SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C: estExcel.xls',
'SELECT * FROM [Sheet1$]')
got the following error :
SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.
then did this
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO
again am trying the same above query ,now am getting the following error:
Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
i want to copy the data of the excel sheet to the table.
I am doing a project in VS2008 with asp.net,C#. I need to encrypt loginId which is of type Guid. How is this done.
View 3 RepliesI'm teaching myself ASP.net. I'm creating an application that needs to store sensitive data. So, I found the following Blog to encrypt and decrypt data.
[URL]
I'm sure it's my app, but I wanted to make sure I'm not missing anything obvious. For some reason, my app and Encryptor only works when I pass < then 7 characters. If a pass 8, it doesn't commit to the database. If I remove Encryptor, the app will store
I need to add a column name contact id in asp.net memebership table.I get the contact id from the contacts table and i need to pass that contact id in asp.net membership table when user creation event fires.
View 2 RepliesI am in the process of creating my database and I have the pending question of whether I should add a UserID using INT to the membership table. I am not replacing the UserID that is a UniqueIdentifier I am just adding a UserID with INT.
The reason I want to do this is because I have about twelve other tables that uses the UserID column. It will be easy for users to insert data into the other tables and I foresee the tables getting to be millions of rows, by using an UserID INT it will avoid the mass amount of storage from the UniqueIdentifier column.
Now my question is what are my repurcussions of doing this? I've already found out one, and I believe it is my biggest question, if I were to create an insert command in .net how would I grab the UserID INT rather then the UserID UniqueIdentifier to insert it into my tables? For example, I can get the userid this way:
Membership.GetUser("username").ProviderUserKey.ToString();
I am working on the user registration process which uses the asp.net membership provider. When users are registered with the application, the some of the user details(emailID, password, password salt, password question, answer etc) are stored in aspnet_Membership table.
We have a requirement of adding two additional columns in the same table for secondary password question and answer. I see that this table has a lot of dependencies with the membership stored procedures. Kindly let me know how some of the extra columns can be added to this table.
[Code]....
Complete error msg with the trace
[Code]....
Source File: C:UserssharmilaDocumentsVisual Studio 2008WebSitesWebSite16PostJobs.aspx.vb Line: 46 Stack Trace:
[Code]....
Is there a profiler for sqlserver express 2008 R2 I can use? Is there anyway to trace the db commands without a profiler?I'm also using ms web developer 2010 express.
View 1 RepliesHow to handle this error
"An explicit value for the identity column in table 'UserActivation' can only be specified when a column list is used and IDENTITY_INSERT is ON."
1)table student
studentno varchar(50)
hobby1 varchar(40);
hobby2 varchar(40);
hobby3 varchar(40);
2)if record in data database such that
hobby1 hobby2 hobby3 in this maximum is one must be chose
like
here studentno hobby1 hobby2 hobby3
1 cricket null null
2 null hockey null
3 null null tennis
if i want to write function in mysql if i pass the studentno
i want to get the hobby of respective student
like select functionname(1)
your hobby is cricket
like select functionname(2)
your hobby is hockey
ike select functionname(3)
your hobby is tennis
I want to do is create a simple page which allows a user to post data into a data table. It should not allow them to view, update or delete any data.
Is there a good online tutorial which would guide me through how to do this in Visual web developer 2008?
I have connected a db, and can add "SELECT" controls to view forms, but I need to be able to INSERT to the table.
I am wondering what's the easiest way to go about doing this. I am using the user signup form control that comes with .net and they can create user through the application and once they do users see the "members area" of my site.
However, they are only trial members. using my paypal form, once they pay for service, they become a paid member.. so I want to keep track of this in the membership table by having a column in that table: bit registeredUser. Do I have to create my own overriden membership class for this, at first I thought there was already a column like this called isApproved, but seems thats for something else because if its set to false user cannot even login.
Currently I am working in Sql server 2005. I do not know the Sql Server 2000 and Sql Server 2008. what is the difference between Sql server 2005 and 2008?
What is the Difference between Sql Server 2000 and Sql Server 2005