|
Thanks for sharing that information with us. It really help us.
|
|
|
|
|
HI,
EveryBody,
I want to ask that how to add,delete,insert,update data
in connected environment in ado.net???
Thanks...
|
|
|
|
|
|
Hello, I need some advice on how it is right to generate a numeric code that appears in my textbox automatically start the window, explain, I'm making an application where the user must enter a repair of an article, so it must give this article a code that will be unique, I would like to ensure that this code remains stored in the database to have a story.
There is a class in C # that do such a thing?
You would use the primary key or is it better to create another field to the code?
You have or know where I can find some examples?
Thank you all for the help.
P.S. I am working in MVVM F. Entity Code First
|
|
|
|
|
Paolo Mazzon wrote: There is a class in C # that do such a thing?
Not unless you write one.
Paolo Mazzon wrote: You would use the primary key or is it better to create another field to the code?
Either way; it's up to you.
Paolo Mazzon wrote: I am working in MVVM F. Entity Code First
You probably shouldn't pick a strategy before you even know what you're doing.
|
|
|
|
|
Thank you for your response, I know myself that I have to write the method, it is precisely because I do not know how to do that I ask for help, at least the discussion forums are used to this I hope not to disturb nessuno.Good Day
|
|
|
|
|
It seems like you could just start with any number, and increment it every time you need a new code. This is simple, and the numbers would all be unique.
|
|
|
|
|
|
HI,
EveryOne
I want to ask a question regarding ado.net because i am little bit confuse???
For example:- Just like in asp.net we can redirect user to another page in the same way can we redirect user to another form in ado.net.For example:-I have a window form
Form1.cs and i want to redirect user to another form
Form2.cs???So can we redirect user?If we can then Please give the code to redirect user to another Window Form???
Thanks in Advance...
|
|
|
|
|
You already got answers? Why repost? Read what others wrote you, stop to think about the meaning of that and improve your question!!!
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
|
HI,
Thanks...
My Problem is solved...
|
|
|
|
|
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?
|
|
|
|
|
Hi,
EveryBody
I want to know that in ado.net how to redirect user to another page???
Thanks in Advance...
|
|
|
|
|
|
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.
|
|
|
|
|
Use Response.Redirect("URPage");
hi
|
|
|
|
|
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();
}
}
}
|
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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...
|
|
|
|
|
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.
|
|
|
|
|
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; }
}
|
|
|
|
|
I have the following PHP code:
$stringToHash = "10123456789"."2014:11:25-15:42:00"."20.00"."826"."sharedsecret";
echo($stringToHash);
$ascii = bin2hex($stringToHash);
echo($ascii);
$sha = sha1($ascii);
echo($sha);
Here is the equivalent C# code:
var stringToHash = "10123456789" + "2014:11:25-15:42:00" + "20.00" + "826" + "sharedsecret";
Console.WriteLine(stringToHash);
var bytes = Encoding.ASCII.GetBytes(stringToHash);
var hexString = BitConverter.ToString(bytes).Replace("-", string.Empty);
Console.WriteLine(hexString);
SHA1 sha = new SHA1CryptoServiceProvider();
var password = sha.ComputeHash(bytes);
var result = BitConverter.ToString(password).ToLower().Replace("-", string.Empty);
Console.WriteLine(result);
var hexStringBytes = Encoding.ASCII.GetBytes(hexString);
var hexStringPassword = sha.ComputeHash(hexStringBytes);
var hexStringResult = BitConverter.ToString(hexStringPassword).ToLower().Replace("-", string.Empty);
Console.WriteLine(hexStringResult);
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
