User Profile

adriancs · Jan 1 '16, 03:08 AM

That's right. You should have only one table contains the login credentials.

adriancs · Dec 26 '15, 11:54 AM

Yeah, SQLite is very good for embed and portable database.

adriancs · Dec 23 '15, 11:32 AM

Code:

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        table{
            border-collapse: collapse;
        }
        th, td{
            border: 1px solid black;
            padding: 5px;
        }
    </style>

...

adriancs · Dec 23 '15, 10:59 AM

Code:

int count = flowLayoutPanel1.Controls.Count;
if (count < 2)
    count = 2;
else
    count = count + 1;

for (int i = flowLayoutPanel1.Controls.Count; i < count; i++)
{
    Button btn = new Button();
    flowLayoutPanel1.Controls.Add(btn);
}

adriancs · Dec 23 '15, 10:55 AM

use a prefix, can be anything. but consistent.

For example:

nudBookCount
nudTotalMan
nudTotalDays

or

nmBookCount
nmTotalMan
nmTotalDays

http://www.pharfruminsain.com/teach/...Variables.aspx...

adriancs · Dec 23 '15, 10:52 AM

Code:

string a = "hello123";
var b = a[a.Length - 1];
if (Char.IsNumber(b))
{
    // is number
}
else
{
    // not number
}

adriancs · Dec 23 '15, 10:29 AM

I assumed that the value of dateTimePicker1 .Value is something like this (MM-dd-yyyy):

Code:

12-23-2015

Then you can get the datetime value like this

Code:

string[] sa = dateTimePicker1.Value.Split('-');
int month = Convert.ToInt(sa[0]);
int day = Convert.ToInt(sa[1]);
int year = Convert.ToInt(sa[2]);
DateTime dateTime1 = new DateTime(year, month, day);
string datestr = dateTime1.ToString("yyyy-MM-dd

...

adriancs · Dec 23 '15, 10:22 AM

Code:

public static string Sha512Hash(string input)
{
    byte[] ba = Encoding.UTF8.GetBytes(input);
    SHA512Managed sha5 = new SHA512Managed();
    byte[] ba2 = sha5.ComputeHash(ba);
    sha5 = null;
    return BitConverter.ToString(ba2).Replace("-", string.E

mpty).ToLower() ;
}

adriancs · Dec 23 '15, 04:16 AM

I always able to use master file to keep the menu on top.
There might be some error CSS coding on your page.
Iframe is another thing that can do the trick.

adriancs · Dec 23 '15, 04:12 AM

Code:

select * from member where name like '%word1%word2%word3%';

adriancs · Dec 23 '15, 04:11 AM

Code:

if (inputline.Trim() == "1 2 9")
{
    // do something
}

adriancs · Jan 24 '13, 07:16 AM

Code:

select * 
from `tablename` 
where `record_date` >= "2013-01-01 00:00:00" 
and `record_date` <= "2013-01-31 23:59:59";

adriancs · Jan 16 '13, 01:12 PM

hi boss, manually update it?

Code:

public void UpdateGridView()
{
    con.Open();
    da = new SqlDataAdapter("SELECT * FROM [user]", con);
    DataTable t1 = new DataTable();
    da.Fill(t1);
    dataGridView1.DataSource = t1;
    con.Close();
}

Code:

public void UpdateData()
{
    // Do something Update
    UpdateGridView();
}

Code:

public void InsertData()

...

adriancs · Jan 15 '13, 06:29 AM

assume that table "user" has rows...
I am 100% sure that this code is working with no error.

Code:

con.Open();
da = new SqlDataAdapter("SELECT * FROM [user]", con);
DataTable t1 = new DataTable();
da.Fill(t1);
dataGridView1.DataSource = t1;
con.Close();

You can try to create another form and build only a datagridview.
and prove it.

therefore, there is something wrong...

adriancs · Jan 14 '13, 10:26 AM

you may get help from here:
www.freelance.com...

adriancs · Jan 14 '13, 10:23 AM

use auto-increment int primary key and column data type.
the database will do it for you automatically.

adriancs · Jan 14 '13, 10:20 AM

You can use client/server to send it.
convert the file into byte[] from A (client)
A send the byte[] to B.
B (server) open a port and receives byte[] from A.
B convert byte[] and write it into file.

search tutorial of C# Client/Server in google.

adriancs · Jan 14 '13, 10:14 AM

this.LostFocus +=
this.GotFocus +=

use
ChildForm.Activ ate()
to get focus

when childform gotfocus()
cache or log it
you can store it in a public value, or list

when MainForm gotfocus
look the public value or list to get last focus mdi child form

for example, if the child form is named form2
then
form2.Activate( )

adriancs · Jan 14 '13, 09:55 AM

maybe somewhere else is resetting the datagridview.

adriancs · Jan 14 '13, 09:49 AM

Yes, we know where it stopped.
what is the Error Message? Exception Message?

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment: