2 questions, database acces and datagridview

[ev00l]

Hey, this is my first time posting something on usenet, so plz be kind
and mannered.

Q1:

I made a project where i get some information from a database, and
populate them into a datagridview. How do i decide which column the
rows is sorted by, i know the user can click on the columns to sort,
but how do i decide the initial sorting column?

Q2:

This program of mine, uses data from a mssql express database.
Everything works fine as long as the database is on the localhost.
However, if i try to make a connection to a database stored anywhere
else on the lan, i get an error message. I read in some microsoft blog
that by default mssql didnt allow lan and unc connections. I tried to
globally enable flag 1807, -t 1807, but i still cant acces this
database from anywhere but localhost. Help is very much apreciated.

Thx in advance

Plz feel free to provide constructive critisism on my spelling as
well, as i know it needs a great deal of improvement. Also keep in
mind that i am kinda new to programming

 

[ev00l]

Got another one aswell:

Q3:

Anyway easy way to sort rows in a datagridview by date? Here by i
mean, i have a column labeled date, and alot of rows with DateTime's
made into strings. However if i sort the DataGridView by this column
is doesnt sort the dates out in the right order. Perhaps there is
somekind of build in sortmode for dates, or perhaps someone has an
easy guide how to make this function.

 

[ev00l]

Got another one aswell:

Q3:

Anyway easy way to sort rows in a datagridview by date? Here by i
mean, i have a column labeled date, and alot of rows with DateTime's
made into strings. However if i sort the DataGridView by this column
is doesnt sort the dates out in the right order. Perhaps there is
somekind of build in sortmode for dates, or perhaps someone has an
easy guide how to make this function.

bump