.NET (Core and Framework)

3-Dec-14 19:20

HI,

Thanks...

My Problem is solved...

Re: Ado.net Question

Pete O'Hanlon2-Dec-14 22:00

Pete O'Hanlon

2-Dec-14 22:00

ADO.NET has nothing to do with displaying forms - it's the generic name given to the underlying data access techniques available in .NET. As there are many different ways of displaying forms, depending on what the underlying technology is, could you actually tell us which one you're using to prevent confusion? Is it ASP.NET? What about WinForms? WPF? Silverlight? ASP MVC?

Ado.net

Member 111616252-Dec-14 3:21

2-Dec-14 3:21

Hi,

EveryBody

I want to know that in ado.net how to redirect user to another page???

Thanks in Advance...

Re: Ado.net

ZurdoDev2-Dec-14 3:29

ZurdoDev

2-Dec-14 3:29

Response.Redirect()

http://msdn.microsoft.com/en-us/library/a8wa7sdt%28v=vs.110%29.aspx[^]

There are only 10 types of people in the world, those who understand binary and those who don't.

Re: Ado.net

Kornfeld Eliyahu Peter2-Dec-14 3:38

Kornfeld Eliyahu Peter

2-Dec-14 3:38

ADO.NET? It is a sub-framework for data access and has nothing to do pages redirection (which mostly connected to web)...
For that see this link: http://msdn.microsoft.com/en-us/library/540y83hx(v=vs.100).aspx[^]

Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.

Re: Ado.net

deepankarbhatnagar30-Dec-14 1:37

deepankarbhatnagar

30-Dec-14 1:37

Use Response.Redirect("URPage");

Regarding Ado.net

Member 111616251-Dec-14 17:28

1-Dec-14 17:28

Hi,
Everybody

I want to encrypt password in ado.net form?
Can any one help???
Please...
Thanks in advance...
I am sending my code also.

Code is:-

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace Login_Form
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void btnlogin_Click(object sender, EventArgs e)
{
if (txtuserid.Text == "" || txtpassword.Text == "")
{
MessageBox.Show("Please enter the data");
return;
}
else
{
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Vijaya;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("Select*from User_Data where User_ID='"+txtuserid.Text+"'and Password='"+txtpassword.Text+"'",con);
SqlDataReader dr = cmd.ExecuteReader();
if (!dr.Read())
{
MessageBox.Show("Invalid user_ID and Password");
}
else
{
MessageBox.Show("Valid User");
}
con.Close();
}

}

private void btnexist_Click(object sender, EventArgs e)
{
this.Close();
}

}
}

PIEBALDconsult1-Dec-14 18:07

PIEBALDconsult

1-Dec-14 18:07

Password Storage: How to do it.[^]

Salted Password Hashing - Doing it Right[^]

A Beginner's Tutorial for Understanding and Implementing Password Hashing and Salting[^]

Password Storage: How to do it.[^]

Beginners guide to a secure way of storing passwords[^]

The Art & Science of Storing Passwords[^]

Richard Deeming2-Dec-14 2:34

Richard Deeming

2-Dec-14 2:34

Your code is vulnerable to SQL Injection[^].

NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query.

using (SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Vijaya;Integrated Security=True"))
using (SqlCommand cmd = new SqlCommand("Select * from User_Data where User_ID = @UserID and Password = @Password", con))
{
    cmd.Parameters.AddWithValue("@UserID", txtuserid.Text);
    cmd.Parameters.AddWithValue("@Password", txtpassword.Text);
    
    con.Open();
    using (SqlDataReader dr = cmd.ExecuteReader())
    {
        ...
    }
}

Once you've gone through all of your code and fixed that serious security vulnerability, read the links in PIEBALDconsult's answer[^] to find out how you should be storing passwords.
(Hint: Neither "plain-text" nor "encrypted" is the right answer.)

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

ZurdoDev2-Dec-14 2:39

ZurdoDev

2-Dec-14 2:39

Where are you stuck? What is your question?

There are only 10 types of people in the world, those who understand binary and those who don't.

Member 111616252-Dec-14 3:25

2-Dec-14 3:25

Hi,

I want to encrypt password in login_form in ado.net???
When user logon??? And also wnt to know how to redirect user to another page?

Thanks...

MVVM Code First Validate error

ZurdoDev2-Dec-14 3:28

ZurdoDev

2-Dec-14 3:28

Member 11161625 wrote:
I want to encrypt password in login_form in ado.net???

Actually, you don't. You want to use SSL so that the password is sent encrypted automatically. You'll also want to them hash the password they send and compare that to the hashed password in your database. Many examples online if you just google for c# hashing.

Member 11161625 wrote:
And also wnt to know how to redirect user to another page?

Hopefully you are using FormsAuthentication so in that case you use FormsAuthentication.RedirectFromLoginPage(); or if you create your FormsAuthentication Ticket manually you can use regular redirection by using Response.Redirect();

There are only 10 types of people in the world, those who understand binary and those who don't.

Paolo Mazzon30-Nov-14 11:32

sha1 function giving a different result to equivalent .net code

30-Nov-14 11:32

Good evening, I do not know how to implement the validation of my textbox, I know that I have to use the partial classes because I can not use the POCO classes, but I can not find an example, can you help me? These are my entity:

public class Busta
   {

       public string _nomeCliente;
       [Key]
       [Required]
       public int BustaID { get; set; }
       public int NegozioID { get; set; }
       [StringLength(20)]
       public string NomeCliente { get; set; }

       public virtual Negozio Negozio { get; set; }


   }

public class Negozio
    {
        public int NegozioID { get; set; }
        public string RagioneSociale { get; set; }

        public virtual List<Busta> Bustas { get; set; }
    }

JMK-NI26-Nov-14 10:21

JMK-NI

26-Nov-14 10:21

I have the following PHP code:

PHP

$stringToHash = "10123456789"."2014:11:25-15:42:00"."20.00"."826"."sharedsecret";

echo($stringToHash);
// outputs:
// 101234567892014:11:25-15:42:0020.00826sharedsecret

$ascii = bin2hex($stringToHash);

echo($ascii);
// outputs:   
// 3130313233343536373839323031343a31313a32352d31353a34323a303032302e3030383236736861726564736563726574

$sha = sha1($ascii);

echo($sha);
// outputs:
// 847aa9da32c54ed8bb9183007336f5762a62ef20

Here is the equivalent C# code:

var stringToHash = "10123456789" + "2014:11:25-15:42:00" + "20.00" + "826" + "sharedsecret";

Console.WriteLine(stringToHash);
// outputs:
// 101234567892014:11:25-15:42:0020.00826sharedsecret

var bytes = Encoding.ASCII.GetBytes(stringToHash);

var hexString = BitConverter.ToString(bytes).Replace("-", string.Empty);

Console.WriteLine(hexString);
// outputs:
// 3130313233343536373839323031343A31313A32352D31353A34323A303032302E3030383236736861726564736563726574

SHA1 sha = new SHA1CryptoServiceProvider();
var password = sha.ComputeHash(bytes);
var result = BitConverter.ToString(password).ToLower().Replace("-", string.Empty);

Console.WriteLine(result);
// outputs:
// c8069048623d6b98a08454e43e1a02a42cf7d61d

var hexStringBytes = Encoding.ASCII.GetBytes(hexString);
var hexStringPassword = sha.ComputeHash(hexStringBytes);
var hexStringResult = BitConverter.ToString(hexStringPassword).ToLower().Replace("-", string.Empty);

Console.WriteLine(hexStringResult);
// outputs:
// bd857ca08446001f7182fbbbd41e747abe302a87

The first two outputs are the same. The original strings are identical, as are the ASCII hex arrays after conversion, but sha1() in PHP is giving me a different outcome to .net's SHA1CryptoServiceProvider. If I convert that output to a string and hash it again, the result is also different.

In .net, an object has to be in the form of a byte array before you can create an SHA hash from it, and I don't understand what I need to convert to the byte array to produce the same output as the PHP code.

This is problematic as the third party service I am posting to uses the PHP version to verify an object on their end, and my program is written in .net. I could write a middle-man in PHP and relay through that, but I really don't want have to do that.

Any insight into why the two are giving different results? Thanks

Re: sha1 function giving a different result to equivalent .net code

Richard Deeming26-Nov-14 10:45

Richard Deeming

26-Nov-14 10:45

JMK-NI wrote:
$ascii = bin2hex($stringToHash);
$sha = sha1($ascii);

JMK-NI wrote:
var bytes = Encoding.ASCII.GetBytes(stringToHash);
var hexString = BitConverter.ToString(bytes).Replace("-", string.Empty);
var password = sha.ComputeHash(bytes);

You're hashing two different strings. In your PHP code, you're hashing the equivalent of the hexString in your C# code. In C#, you're hashing the original string.

Either change your PHP code to hash the original string:

PHP

$sha = sha1($stringToHash);

or change the C# code to hash the hexString:

var password = sha.ComputeHash(Encoding.ASCII.GetBytes(hexString.ToLower()));

EDIT:
You'll also need to convert the hexString to lower-case before hashing.

PHP: 3130313233343536373839323031343a31313a32352d31353a34323a303032302e3030383236736861726564736563726574
C#:  3130313233343536373839323031343A31313A32352D31353A34323A303032302E3030383236736861726564736563726574

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Problem Saving Data

Paolo Mazzon21-Nov-14 18:54

21-Nov-14 18:54

I can not figure out where I'm wrong place my model:

<pre lang="c#">
public class MainViewModel : ViewModelBase
    {
        /// <summary>
        /// Initializes a new instance of the MainViewModel class.
        /// </summary>
        /// 
         IDataAccessService _serviceProxy;

         ObservableCollection<Busta> _Bustas;

         public ObservableCollection<Busta> BustaOservable
         {
             get { return _Bustas; }
             set
             {
                 _Bustas = value;
                 RaisePropertyChanged("BustaOservable");
             }
         }

         ObservableCollection<Negozio> _Negozios;

         public ObservableCollection<Negozio> NegozioObser

         {
             get { return _Negozios; }
             set
             {
                 _Negozios = value;
                 RaisePropertyChanged("Negozio");
             }
         }

        Busta _Busta;
        public Busta Busta
        {
            get { return _Busta; }
            set
            {
                _Busta = value;
                RaisePropertyChanged("Busta");
            }
        }

        Negozio _Negozio;
        public Negozio NegozioSelezionato
        {
            get { return _Negozio; }
            set
            {
                _Negozio = value;
                RaisePropertyChanged("NegozioSelezionato");
            }
        }

        #region Command Object Declarations
       
        public RelayCommand<Busta> SaveCommand { get; set; }

        

       
        #endregion
        public MainViewModel(IDataAccessService servPxy)
        {
            _serviceProxy = servPxy;
            Busta = new Busta();
            NegozioSelezionato = new Negozio();
             
            SaveCommand = new RelayCommand<Busta>(SalvaBusta);
            NegozioObser = new ObservableCollection<Negozio>();
            
        }
//Metodo Per Salvare La Busta
 void SalvaBusta(Busta Bus)
{
    Bus.NegozioID = NegozioSelezionato.NegozioID;
    Busta.BustaID = _serviceProxy.CreateBusta(Bus);
    if (Busta.BustaID != 0)
    {
        BustaOservable.Add(Busta);
        RaisePropertyChanged("Busta");
    }

       
        }
//Metodo Per Caricare I dati Della Combobox
 public void GetNegozio()
 {
     
     foreach (var item in _serviceProxy.GetNegozio())
     {
         NegozioObser.Add(item);
     }
 }
    }
}

My View:

<pre lang="HTML"><Window x:Class="Prova1.View.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        DataContext="{Binding Main,Source={StaticResource Locator}}"
        Title="MainWindow" Height="429" Width="615" Loaded="Window_Loaded">


    <Grid>
        <TextBox HorizontalAlignment="Left" Height="23" Margin="327,85,0,0" TextWrapping="Wrap" Text="{Binding Busta.BustaID, Mode=TwoWay }" VerticalAlignment="Top" Width="120"/>
        <Label Content="BustaID" HorizontalAlignment="Left" Margin="238,85,0,0" VerticalAlignment="Top"/>
        <Label Content="NegozioId" HorizontalAlignment="Left" Margin="238,116,0,0" VerticalAlignment="Top"/>
        <TextBox HorizontalAlignment="Left" Height="23" Margin="327,142,0,0" TextWrapping="Wrap" Text="{Binding Busta.NomeCliente, Mode=TwoWay}" VerticalAlignment="Top" Width="120"/>
        <Label Content="NomeCliente" HorizontalAlignment="Left" Margin="238,142,0,0" VerticalAlignment="Top"/>
        <Button Content="Salva" HorizontalAlignment="Left" Margin="215,233,0,0" VerticalAlignment="Top" Width="75"
                Command="{Binding SaveCommand}" CommandParameter="{Binding Busta}"/>
       <!-- <TextBox HorizontalAlignment="Left" Height="23" Margin="327,114,0,0" TextWrapping="Wrap" Text="{Binding Busta.NegozioID, Mode=TwoWay}" VerticalAlignment="Top" Width="120"/>-->
        <ComboBox HorizontalAlignment="Left" Margin="327,116,0,0" VerticalAlignment="Top" Width="120" ItemsSource="{Binding NegozioObser}" SelectedItem="{Binding NegozioSelezionato}">
            <ComboBox.ItemTemplate>
                <DataTemplate>
                    <Grid>
                        <TextBlock Text="{Binding RagioneSociale}"></TextBlock>
                    </Grid>
                </DataTemplate>
            </ComboBox.ItemTemplate>
        </ComboBox> 
    </Grid>

</Window>

This is the error that comes out:

System.NullReferenceException verificata
  HResult=-2147467261
  Message=Riferimento a un oggetto non impostato su un'istanza di oggetto.
  Source=Prova1
  StackTrace:
       in Prova1.ViewModel.MainViewModel.SalvaBusta(Busta Bus) in k:\c#\MVVMLight\Prova1\Prova1\ViewModel\MainViewModel.cs:riga 102
  InnerException:

Richard MacCutchan21-Nov-14 21:23

Richard MacCutchan

21-Nov-14 21:23

The message is telling you what the error is and where it occurs. Use your debugger to trap the code and see why your reference item is null.

den2k8822-Nov-14 1:48

den2k88

22-Nov-14 1:48

Just to clarify: please put your environment international settings to English to allow all the users to answer (at least to understand the error message).

It looks you have a pointer not associated with any object, check or add some initialization. The message tells you precisely which line of code is wrong, but we have no explicit line numeration visible.

ADDENDUM:
The line

Busta.BustaID = _serviceProxy.CreateBusta(Bus);

is totally wrong: you are using the name of the class as it if is an OBJECT. You would probably use Bus instead of Busta.

To help you not doing the same mistakes be careful to differentiate consistently between the name of a type (or class or enum) and it's object identifiers, or it is easy to be confused.

Richard MacCutchan22-Nov-14 2:46

Richard MacCutchan

22-Nov-14 2:46

That syntax is perfectly valid (although confusing). OP has declared a property named Busta thus:

Busta _Busta;
public Busta Busta
{
    get { return _Busta; }
    set
    {
        _Busta = value;
        RaisePropertyChanged("Busta");
    }
}

den2k8822-Nov-14 2:58

den2k88

22-Nov-14 2:58

Oh, right, haven't see that.

That's BAD style, very confusing!

Richard MacCutchan22-Nov-14 3:09

Richard MacCutchan

22-Nov-14 3:09

den2k88 wrote:
That's BAD style

I think it's worse than that.

Paolo Mazzon22-Nov-14 6:24

22-Nov-14 6:24

I apologize to everyone for my code confusing because you are a student of 40 years autodidact who does it for a hobby, I'll do a bit of order.The meantime I wanted to show how I did the DB because the property and that nothing is shop and is the property navigation, here they are;

CREATE TABLE [dbo].[Busta] (
    [BustaID]     INT          NOT NULL,
    [NegozioID]   INT          NOT NULL,
    [NomeCliente] VARCHAR (25) NULL,
    PRIMARY KEY CLUSTERED ([BustaID] ASC),
    CONSTRAINT [FK_Busta_Negozio] FOREIGN KEY ([NegozioID]) REFERENCES [dbo].[Negozio] ([NegozioID])
);

CREATE TABLE [dbo].[Negozio] (
    [NegozioID]      INT          NOT NULL,
    [RagioneSociale] VARCHAR (20) NOT NULL,
    PRIMARY KEY CLUSTERED ([NegozioID] ASC)
);

Paolo Mazzon22-Nov-14 19:05