Re: hash and salt - ASP.NET Discussion Boards

patelash0111-Jul-07 10:21

11-Jul-07 10:21

Hi All,

I am looking for very efficient solution for this problem. Here is my problem description - I have serveral database,
from which I have to pull data (All databases differ in physical design implementation), and insert them in standardized
common database. Let me give you an example

Database - 1
Table - 1
Col_1 - int
Col_2 - text
Col_3 - float

Database - 2
Table - 2
Col_1 - int
Col_2 - int
Col_3 - float
Col_4 - text
Col_5 - text

Common database
col_1 (id) - int
col_2 - int
col_3 - float
col_4 - text

So mapping between database - 1 and common database would be
col_1 --> col_2
col_2 --> col_4
col_3 --> col_3

and between database - 2 and commond database would be
col_1 --> col_2
col_2 --> col_2
col_3 --> col_3
col_4 --> col_4
col_5 --> col_4

How can I achive this? One more thing, this mapping can be changed during runtime.

Thanks,
AP

Re: Mapping database fileds

Paul Conrad13-Jul-07 12:19

Paul Conrad

13-Jul-07 12:19

patelash01 wrote:

How can I achive this?

Just code the mappings you have supplied...

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

hash and salt

boyindie11-Jul-07 8:58

boyindie

11-Jul-07 8:58

Hi
I have been playing around with a password hashing scheme for my application

But i keep getting an error message when it executes the command object

i get the error

Unable to cast object of type 'System.byte[]' to type 'system.inconvertible'

Any suggestions?

Sub CreateAccount(ByVal sender As Object, ByVal e As EventArgs)
Dim literror As New LiteralControl
'1. Create a connection
'Create connection string to pass database, string holds login information to mySQL,
Dim connectionString As String
connectionString = "Server=localhost; ;database=ftp1;"

'Builds .net mysql connection and passes connection string into method
Dim connection As New MySqlConnection(connectionString)
Try
'2. Create a command object for the query
Dim strSQL As String = _
"INSERT INTO Useraccount(Username,Password) " & _
"VALUES(?Username, ?Password)"
Dim objCmd As New MySqlCommand(strSQL, connection)

'3. Create parameters
Dim paramUsername As MySqlParameter
paramUsername = New MySqlParameter("?Username", SqlDbType.VarChar, 25)
paramUsername.Value = txtUsername.Text
objCmd.Parameters.Add(paramUsername)

'Encrypt the password
Dim md5Hasher As New MD5CryptoServiceProvider()

Dim hashedBytes As Byte()
Dim encoder As New UTF8Encoding()

hashedBytes = md5Hasher.ComputeHash(encoder.GetBytes(txtPwd.Text))

Dim paramPwd As MySqlParameter
paramPwd = New MySqlParameter("?Password", SqlDbType.Binary, 16)
paramPwd.Value = hashedBytes
objCmd.Parameters.Add(paramPwd)

'Insert the records into the database
connection.Open()
objCmd.ExecuteReader()
connection.Close()
Catch ex As Exception
literror.Text = ex.Message
MsgBox(ex.Message)

End Try
Response.Redirect("userhome.aspx")

End Sub

BAD USER!

leckey11-Jul-07 9:16

leckey

11-Jul-07 9:16

There is no cross-posting!

______________________
stuff + cats = awesome

Re: hash and salt

Dave Kreskowiak11-Jul-07 9:28

Dave Kreskowiak

11-Jul-07 9:28

So, instead of continuing the thread you started in the VB.NET forum, you decided to spam the ASP.NET forum with the same question? Do you really understand how forums work?

So, did you double check the items I brought up in my previous reply in the VB.NET forum, or did you just ignore them entirely?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: hash and salt

boyindie11-Jul-07 22:38

boyindie

11-Jul-07 22:38

I appologise all I will need to get of this hash and salt, apparently hash and pepper can be good?

Yes i did take account to what you said, and i believe SHA2 is a more secure encryption? and i have now ported my code to that.

Although I am still being hit with the same problem, I checked my field types and lengths and still no joy Frown | :(

with that either

Re: hash and salt

Dave Kreskowiak12-Jul-07 1:41

Dave Kreskowiak

12-Jul-07 1:41

Try converting your byte() array to a Base64 string, then save that to the database.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: hash and salt

Pete O'Hanlon11-Jul-07 10:27

Pete O'Hanlon

11-Jul-07 10:27

The title of the post looks like you want to know about seasoning the drugs you obviously used when you decided to cross post. You've angered Leckey now - that's not a good thing.

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

Re: hash and salt

leckey11-Jul-07 15:00

leckey

11-Jul-07 15:00

______________________
stuff + cats = awesome

Re: hash and salt

Sathesh Sakthivel11-Jul-07 17:58

Sathesh Sakthivel

11-Jul-07 17:58

Regards,

Satips. Rose | [Rose]

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

Chart Refresh Problem

Hyland Computer Systems11-Jul-07 8:10

Hyland Computer Systems

11-Jul-07 8:10

Dear sirs:

I have a simple ASP.NET WebForm; on it are: a combo-box (for months) and a submit button, an SqlDataSource (for chart data), a GridViewControl (interface between sql data source and chart control) and a chart control.

When I select a month from the combo box and hit a button, the proper data is displayed in the chart control. However, when I select another month from the combo box the same data is again displayed.

I made sure to wipe out the double-array that holds the data by instantiating a new instance of it in the constructor of the class in which it resides.

Here's what's interesting: if I click on the browser's "back" button and then the "forward" button; and then hit the "submit" button, the grid displays the proper data for the new month in the drop down combo box.

What is happening? What can I do to make sure the data from the sqldatasource/gridview is synched with the filter-select variable in the combo box?

Thanks in advance,

Rob Hyland

Re: Chart Refresh Problem

Michael Sync11-Jul-07 8:22

Michael Sync

11-Jul-07 8:22

I think that i faced that kind of problems once.
It could be two reasons.

1. You put the databinding function in wrong place.

2. You may need to add some unique keys for getting the latest result. This is the reason probably for you. When I was using SQL Reporting Service in ASP.NET project, I faced the same problem that I was not able to get the latest data for my report even I passed the correct parameter.

Then, the solution was that I add the unique key (eg: timestamp) as paramenter to my report. Whenever I generate the report, i used to pass this timestamp value as a paramenter to report. Then, i got the latest result..

You may read for the problem and solution that I said above in this link. http://michaelsync.net/2007/05/13/tipstricks-aspnet-with-sql-reporting-services/

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: Chart Refresh Problem

Hyland Computer Systems12-Jul-07 5:44

Hyland Computer Systems

12-Jul-07 5:44

Michael:

Thanks for the quick response. If I understand you correctly, what you are implying that I should do is something like the following. Let's say that a portion of my SelectCommand of the SqlDataSource looks like so (this is Oracle P-SQL):

"..... where EXTRACT( MONTH from mh.historydatetime) = :MONTH_ID"

Now, the bind-variable comes from the SelectedIndex of the drop down combo box. What you are saying to do, in essence is something like the following:

"..... where EXTRACT( MONTH from mh.historydatetime) = :MONTH_ID AND :TIMESTAMP_INFO = :SUBMIT_TIME"

That sounds quite difficult. For one: how do I put the timestamp info into a variable? Secondly, what is the logic behind this? As long as a different month is selected from the drop down, it should use the new data, right?

Regards,

Rob

Open New window with some parameter

Sarfaraj Ahmed11-Jul-07 4:59

Sarfaraj Ahmed

11-Jul-07 4:59

Hi Everybody

On my project I have a gridview with a button. When someone click the button then new page will be open with those parameter which is related on gridview

Thanks

Sarfarj Ahmed

Re: Open New window with some parameter

Michael Sync11-Jul-07 8:13

Michael Sync

11-Jul-07 8:13

Sarfaraj Ahmed wrote:
: Open New window with some parameter

<br />
 window.open ("http://www.javascript-coder.com?par1=1&par2=2",<br />
"mywindow","menubar=1,resizable=1,width=350,height=250");

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Changing skins at runtime [modified]

dandy7211-Jul-07 4:19

dandy72

11-Jul-07 4:19

I'm confused.

I'm new to ASP.NET, but already have enough experience with plain old HTML/classic ASP to get by (I'm more of a C/C++ guy trying to expand my horizons).

I have page that performs some database operations, with an asp:label that shows the result either in green or red text to indicate success or failure. I've defined two CSS classes:

.clsMessageSuccess<br />
{<br />
	color: Green;<br />
}<br />
.clsMessageFailure<br />
{<br />
	color: Red;<br />
}

Then at runtime, depending on the result of the database operation, I change my label's CssClass property to either clsMessageSuccess or clsMessageFailure. Works great.

Now I'm trying to revisit this and do things "the ASP.NET way" using themes and skins. I've defined the following in my .skin file:

<asp:Label runat="server" SkinID="sknResultLabelSuccess" ForeColor="Green" /><br />
<asp:Label runat="server" SkinID="sknResultLabelFailure" ForeColor="Red" />

I thought I'd simply be able to replace my label's SkinID property at runtime like I'm currently doing for CssClass. No such luck:

"The 'SkinId' property can only be set in or before the Page_PreInit event for static controls. For dynamic controls, set the property before adding it to the Controls collection."

Great. I could understand why, and it looks my approach is plain wrong, but what I don't understand then is how it should be done "properly". I could just forget about the whole skins idead and just change the label's ForeColor property instead of its SkinID (which apparently isn't allowed), but this goes against the very nature of code/styling separation. What if I also wanted to make the text bold? I'm not going to start changing multiple properties every place I'm currently trying to replace the SkinID.

Why not stick with replacing CssStyle? Because my master page uses one .css file, and it's getting quite long. It contains different sections that are only used by specific pages. I want to break that out into multiple .css files and *only* include the required files in the pages that need them. However, the master page is the one containing the head tag (and closes it), so I can't include additional .css files in other aspx files (or if I can, I haven't found out how). Traditionally, in classic ASP, I've been able to include multiple css files without any issue (eg, I have one basic css file that applies to all pages--which I've now put in the master page--and other files that apply only to the page in question). What's the proper way to do this in ASP.NET?

I'm starting to dislike the way ASP.NET does some things. Themes/skin files sound great in theory, but then looking at the HTML generated, I see it takes the attributes defined in skin files and applying them directly as style attributes to individual controls. Awesome. So CSS files made us take styling out of the HTML, but then skins adds them back?

-- modified at 10:24 Wednesday 11th July, 2007

Re: Changing skins at runtime

Michael Sync11-Jul-07 8:10

Michael Sync

11-Jul-07 8:10

Daniel Desormeaux wrote:
so I can't include additional .css files in other aspx files (or if I can, I haven't found out how).

I'm not very sure about this in ASP.NET 2.0 but I know how can be done in ASP.NET 1.1. Just add one public property for getting CSS or Javascript or Meta to BasePage Class..

Please check the following ~ (You may get some idea.)
http://p2p.wrox.com/topic.asp?TOPIC_ID=45085

http://p2p.wrox.com/topic.asp?TOPIC_ID=44971

http://www.codeproject.com/useritems/ASPNET_Dynamic_Styling.asp

http://www.codeproject.com/useritems/dynamicThemes.asp

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: Changing skins at runtime

dandy7212-Jul-07 4:27

dandy72

12-Jul-07 4:27

Interesting links. I'll look into them.

Thanks Michael

Display Multiple Columns in a List Box

kibromg11-Jul-07 4:00

kibromg

11-Jul-07 4:00

Hi All,
I want to bind a list box with three columns from a table.

Could you please advice.

Thanks

Re: Display Multiple Columns in a List Box

Michael Sync11-Jul-07 7:59

Michael Sync

11-Jul-07 7:59

Why do you wanna use "Listbox" instead of "GridView"?

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

GridView

.NET- India 11-Jul-07 3:49

.NET- India

11-Jul-07 3:49

Is Gridview of ASP.NET 2.0 is equivalent of Datagrid 1.1

Thnx in Advance

Re: GridView

Michael Sync11-Jul-07 7:57

Michael Sync

11-Jul-07 7:57

GridView has more advanced features than DataGrid.

Please read this article for comparing GridView and DataGrid (GridView Vs DataGrid).

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Focus and Gridview

.NET- India 11-Jul-07 3:48

.NET- India

11-Jul-07 3:48

Hello Everyone,

Can anybody let me know to through focus/cursor blinking on a text box as
the page get loaded.

i'm using the following command given below as i use in ASP.NET with 1.1
and this piece of code run fine in ASP.NET 1.1 but generating error in ASP.NET 2.0

function myFocus()
{
document.form1.txtName.focus();
}

ERROR:- myFocus() not found

Re: Focus and Gridview

Michael Sync11-Jul-07 7:54

Michael Sync

11-Jul-07 7:54

You are writing this code in Single aspx page or Master page or content page or what?

What you can do is that you can view the sourcecode in browser and find out whether this function still there or not...

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

GridView and DetailsView

Sarfaraj Ahmed11-Jul-07 3:42

Sarfaraj Ahmed

11-Jul-07 3:42

Hi Everybody

.aspx page I used DetailsView and GridView. GridView has three Columns ErrorID, ErrorType and ErrorDate. If I click on ErrorID then DetailsView will show the whole information (Same Page GridView then DetailsView)

Here is my code which is binding GridView1

Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
Dim _AuditLog As AuditLog = New AuditLog()
_AuditLog = CType(e.Row.DataItem, AuditLog)

If (_AuditLog Is Nothing) Then

Else

Dim lblErrorID As Label = e.Row.FindControl("lblErrorID")
Dim lblErrorType As Label = e.Row.FindControl("lblErrorType")
Dim lblErrordate As Label = e.Row.FindControl("lblErrorDate")

lblErrorID.Text = _AuditLog.ErrorID.ToString()
lblErrorType.Text = _AuditLog.ErrorType.ToString()
lblErrordate.Text = _AuditLog.DateStamp.ToString()
End If

End Sub

Now wot should be code for DetailsView. I dont want to write any code inside .aspx file, it will be .vb or .cs

Any help will be greatful for me

Sarfarj Ahmed

Last Visit: 31-Dec-99 18:00 Last Update: 28-Apr-24 12:47

Refresh

ᐊ Prev 1...4638 4639 4640 464146424643 4644 4645 4646 4647 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.