Click here to Skip to main content
15,881,248 members
Home / Discussions / C#
   

C#

 
GeneralRe: can some one encrypt these codes Pin
OriginalGriff2-Dec-16 8:17
mveOriginalGriff2-Dec-16 8:17 
GeneralRe: can some one encrypt these codes Pin
Gerry Schmitz2-Dec-16 8:36
mveGerry Schmitz2-Dec-16 8:36 
AnswerRe: can some one encrypt these codes Pin
Afzaal Ahmad Zeeshan2-Dec-16 9:40
professionalAfzaal Ahmad Zeeshan2-Dec-16 9:40 
AnswerRe: can some one encrypt these codes Pin
Patrice T5-Dec-16 10:47
mvePatrice T5-Dec-16 10:47 
GeneralRe: can some one encrypt these codes Pin
Member 128824725-Dec-16 16:43
Member 128824725-Dec-16 16:43 
GeneralRe: can some one encrypt these codes Pin
Dave Kreskowiak12-Dec-16 5:02
mveDave Kreskowiak12-Dec-16 5:02 
AnswerRe: can some one encrypt these codes Pin
237415-Dec-16 13:18
237415-Dec-16 13:18 
QuestionHow to Login to my Database from C#? Pin
Member 128803401-Dec-16 19:59
Member 128803401-Dec-16 19:59 
Hello Everyone, I am new to C# and I really need help as I am writing a program for my Client so that he can use the Program to Login to his Database hosted in One.com. I do not know what's going on and what's wrong I have done. Please correct me:

Below is my Complete Source!
/************************

C#
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OleDb;
using MySql.Data.MySqlClient;

namespace IncomeLoops
{
    public partial class Form1 : Form
    {
        MySqlConnection con = new MySqlConnection("Server=flightppl.com.mysql; Database=Removed;Uid=Removed;Pwd=Removed");
        MySqlDataAdapter da;
        DataTable dt = new DataTable();
        int i;
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            con.Open();
            MySqlCommand cmd = con.CreateCommand();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "select * from wp_users where user_login='" + textBox1.Text + "' and user_pass='" + textBox2.Text + "' ";
            cmd.ExecuteNonQuery();
            da = new MySqlDataAdapter(cmd);
            da.Fill(dt);
            i = Convert.ToInt32(dt.Rows.Count.ToString());

            if (i == 0)
            {
                Form2 frm = new Form2();
                frm.Show();
            }
            else
            {
                
            }
            con.Close();
        }
    }
}


*********** /

Please advice me. Many thanks to all your contribution

modified 2-Dec-16 3:21am.

AnswerRe: How to Login to my Database from C#? Pin
Pete O'Hanlon1-Dec-16 21:36
mvePete O'Hanlon1-Dec-16 21:36 
GeneralRe: How to Login to my Database from C#? Pin
Member 128803401-Dec-16 22:15
Member 128803401-Dec-16 22:15 
GeneralRe: How to Login to my Database from C#? Pin
Pete O'Hanlon1-Dec-16 22:28
mvePete O'Hanlon1-Dec-16 22:28 
SuggestionRe: How to Login to my Database from C#? Pin
Richard Deeming2-Dec-16 2:09
mveRichard Deeming2-Dec-16 2:09 
AnswerRe: How to Login to my Database from C#? Pin
Gerry Schmitz2-Dec-16 8:00
mveGerry Schmitz2-Dec-16 8:00 
Questionc#webservice insert into Unity3d Pin
Member 128822191-Dec-16 19:26
Member 128822191-Dec-16 19:26 
AnswerRe: c#webservice insert into Unity3d Pin
Richard MacCutchan1-Dec-16 21:40
mveRichard MacCutchan1-Dec-16 21:40 
QuestionWPF Importing Raw Data From Excel And Want to Retain The Exact Date Format Pin
Mark McArdle1-Dec-16 4:54
Mark McArdle1-Dec-16 4:54 
AnswerRe: WPF Importing Raw Data From Excel And Want to Retain The Exact Date Format Pin
Richard Deeming1-Dec-16 5:33
mveRichard Deeming1-Dec-16 5:33 
GeneralRe: WPF Importing Raw Data From Excel And Want to Retain The Exact Date Format Pin
Mark McArdle1-Dec-16 5:38
Mark McArdle1-Dec-16 5:38 
Questionc# WPF Binding a listbox to another listbox's selected item Pin
Member 1288059530-Nov-16 22:11
Member 1288059530-Nov-16 22:11 
AnswerRe: c# WPF Binding a listbox to another listbox's selected item Pin
Pete O'Hanlon30-Nov-16 23:23
mvePete O'Hanlon30-Nov-16 23:23 
GeneralRe: c# WPF Binding a listbox to another listbox's selected item Pin
Member 128805951-Dec-16 1:46
Member 128805951-Dec-16 1:46 
Questionauto delete file Pin
Member 1287946030-Nov-16 18:41
Member 1287946030-Nov-16 18:41 
AnswerRe: auto delete file Pin
OriginalGriff30-Nov-16 20:10
mveOriginalGriff30-Nov-16 20:10 
AnswerRe: auto delete file Pin
Afzaal Ahmad Zeeshan1-Dec-16 7:20
professionalAfzaal Ahmad Zeeshan1-Dec-16 7:20 
GeneralRe: auto delete file Pin
Eddy Vluggen1-Dec-16 8:27
professionalEddy Vluggen1-Dec-16 8:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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