|
hi. my question is how can i make a form in vb.net that retrieves the usernames from mysql database of the forum that i have hosted in the www.awardspace.com.
Im new in this things of databases and im building a app that shows all the usernames registered but this part is making my head spin. lol
Sorry for the bad english, im portuguese.
|
|
|
|
|
Well first you will need something to list those in, .NET 1.1 would be a DataGrid, .NET 2.0 will be a DataGridView. You need to create some type of stored procedure or parameterized query that will access the database and return a dataset of names that you will then set as the datasource to the DataGridView and can then call .DataBind.
The good thing about .NET 2.0 is that they make it much more simple that it even needs to be so people can easily create bad code and foster bad habits but if it is just a simple application that will be used internally by yourself you can probably get away with it. Any of the concepts you dont understand can easily be searched for with Google and you will get some greate articles with step by step instructions.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
the connection is my problem, i have no idea how to connect to database, the only tutorials i found in the net is how to connect to mysql database in local computer, but my database is hosted in anothet site, more especific in www.awardspace.com.
|
|
|
|
|
Ahhh, I see. Well then you will need to have access through any security on the site and probably the IP address of the database. When you are remote instead of accessing SQLServer01 you would access 999.999.999.999 or whatever the IP is. As long as you have THAT piece and you have access into the server then everything should be the same.
Just in case you need it - www.connectionstrings.com[^].
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
nice. thanks. 
that help alot, now i just need to figure out to use it. lol my app is cuurently connecting to a access database but that sucks because every time the users use it the program have to upload it via FTP to the server again.
Did you have any example of how to use the connection string?
in any case thanks for the help
Cheers
|
|
|
|
|
Provider=999.999.999.999;Data Source=mydb;User Id=myUsername; Password=myPassword; What is it that you need an example of?
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
well tahnks to the help you give me in the other replys i finally has able do get it.
but now i going to have to host the database in my computer.
the awardspace server does not accept remote connections. i have no other choice but to host in my own pc. thanks for your help
|
|
|
|
|
I wonder if anyone could help me on this problem I am having.
I have an Access 2003 database and using VB.Net 2003
I have a query in Access e.g. myQuery. In this query it has a date field. I want to pass 2 parameters to this field (myDate) e.g. between 01/01/1999 and 30/01/1999.
My query in VB.Net is
"EXECUTE myQuery #01/01/1999#, #30/01/1999#"
For some strange reason it is only picking up the 01/01/1999 value.
The question is,
How can I pass 2 parameters via VB.Net to a field in Access which uses the between date function in a field.
|
|
|
|
|
The standard way to do it is to use an OleDbCommand object, supplying it with the name of the stored procedure, and a couple of OleDbParameter objects.
Dim conn As New OleDbConnection("connection string")
Dim comm As New OleDbCommand("myQuery", conn)
' DateTime takes arguments in Year, Month, Day order.
comm.Parameters.Add("@p1", OleDbType.Date).Value = New DateTime(1999, 1, 1)
comm.Parameters.Add("@p2", OleDbType.Date).Value = New DateTime(1999, 1, 30)
Dim rdr As OleDbDataReader = comm.ExecuteReader()
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks for this information.
Tried it and it worked a treat.
|
|
|
|
|
hi
i want to know how notepad ms word and more similar editor applications opening a text file or wat ever it is in thier application by right click and open or right click and open with option
this i am asking because i want to make my application to open a text file on right click it
pls reply soon
with regards
Balagurunathan.B
|
|
|
|
|
you can use contextmenu in vb.net for right click option.
And add menu items for menu.
Add your code in the clickevents
Sathesh Pandian
|
|
|
|
|
i dont want that one
let us consider this scenario
if u have a c++ code
if u want to see that code u will right click on that and use open with ms word or notepad
like that i want to open
with regards
Balagurunathan.B
|
|
|
|
|
hi i want to make the users who installs the product created by me schould enter some license key provided to him. so wat i have to do.
i dont want user to get connectd into web
i dont have any idea to make users to enter the key given to him while installing
please give me a idea
we can use any cryptography algorithms to generate a key but how to embed it, so user will enter it while installation
if i am correct those things will be related with registry
i dont have any idea pls provide some help
with regards
Balagurunathan.B
with regards
Balagurunathan.B
|
|
|
|
|
You have two options:
1 - you can write a C++ dll which will allow you to require a password from the installer itself
2 - you can write some code inside your app that requires a key to be entered
In both instances, you have two choices:
1 - generate a key that is unique to the machine, which means they'd need to call you in order to finish the install
2 - just put a key in there that's the same for everyone
balakpn wrote: we can use any cryptography algorithms to generate a key but how to embed it, so user will enter it while installation
Obviously, you would 'embedd' it, by writing code that requires the key to be entered.
balakpn wrote: f i am correct those things will be related with registry
The registry is one obvious place to store that the key was already entered, so you don't ask for it again, yes.
One thing you need to know. If your app is VB.NET, a tech savvy user can decompile it, remove the licence code, and recompile. Easier still, they can read your code with a tool like Reflector, and just read how you generate your key, and thus discover it without having to know it in the first place.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
hi i have two tables like want to display based on the date:
eg:
table1:
Id cardDate Intime1 Outtime1
1 12/22/2006 09:00 20:00
2 12/22/2007 09:00 20:00
3 12/22/2006 09:00 13:00
and table 2:
Id leaveDate Intime2 Outtime2
3 12/22/2006 13:00 20:00
4 12/22/2006 09:00 20:00
5 11/11/2006 09:00 20:00
If i select the date 12/22/2006" then it want to display like:
Id Carddate InTime1 Outtime1 Leavedate Intime2 Outtime2
1 12/22/2006 09:00 20:00 null null null
3 12/22/2006 09:00 13:00 12/22/2006 13:00 20:00
4 12/22/2006 09:00 20:00 null null null
I am week in sqlquery,plz hlp me...,
Magi
|
|
|
|
|
SELECT table1.id,cardDate,InTime1,Outtime1,Leavedate,Intime2,Outtime2 FROM table1 INNER JOIN table2 on table1.id=table2.id WHERE cardDate=#12/22/2006#
Tirtha
"A man can ride on your back only when it is bent....."
|
|
|
|
|
No,it willnot work,
Ur query will work,when that two tables have same id...,
If table1 have particular date on some other ids,
then those records willn't display...,
Similarly table2 also have paricular date some other ids those records will not display...,
ex:
table1:
Id cardDate Intime1 Outtime1
1 12/22/2006 09:00 20:00
2 12/22/2007 09:00 20:00
3 12/22/2006 09:00 13:00
7 12/22/2006 09:00 20:00
and table 2:
Id leaveDate Intime2 Outtime2
3 12/22/2006 13:00 20:00
4 12/22/2006 09:00 20:00
5 11/11/2006 09:00 20:00
8 12/22/2006 09:00 20:00
see ur query willn't show id=7 & 8,
and ur query will display table2 all records it willn't check the date condition
and it willn't show at one row when the date will be there in two tables
see my first ques i told output style also..........
Magi
|
|
|
|
|
after connecting vb6 with sql+, i can create normal data reports but how should i create dynamic data reports........
or
i use only one data environment and one form and one data report then how should i create such a report that the value entered in the text box of the form(for example a class in a school like 10th or 12th) then how should it be possible that i can create a report that whatever class is entered in the text box i get the fields of that class from the table of the students in the same data report........
deepak jain
|
|
|
|
|
Hi can you plz advice me how to filter file while upload image through webapplication for example when open dialogue box has open you want to show the file type with *.jpg and *.gif the file dialogue box should not show any other file type.
Magi
|
|
|
|
|
simply set your OpenFileDialog box property like.....
OpenFileDialog.Filter = "JPG Files(*.jpg)|*.jpg|GIF Files(*.gif)|*.gif"
thus Your OpenFileDialog box will not show any other file type.....
Tirtha
"A man can ride on your back only when it is bent....."
|
|
|
|
|
Hey one doubt..........,this command will be use in web application?
it will work in web application?
Magi
|
|
|
|
|
then you can use the Accept method of HTML FileField control for your work.....
MyFileField.Accept="jpeg,gif"
Tirtha
"A man can ride on your back only when it is bent....."
|
|
|
|
|
Hello,
[VS 2005]
Is there a way to manually order the columns in a DataGridView.
My grid is bound to the datasource at run-time. So I can't change the order in the designer.
Is there a method to do that in code?
Many thanks,
Steve
|
|
|
|
|
what do u mean by Ordering of column?? Construct your SQL Query as you like....
are you using SELECT * FROM TableName WHERE.....???
instead use....
SELECT Column1,Column2,...... FROM TableName WHERE ....."
Tirtha
"A man can ride on your back only when it is bent....."
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
