|
Hello everybody, I'm pretty Noob in vb.net programming so i require some assistance from you pro's.
Here is the problem: I use MS SQL2000 and VB2003 for my project. In that project i have one table with two datetime columns (Start and Stop). I wrote stored procedure that uses these two columns for filtering data (Select * from table where Start>=@Start and Stop<=@Stop) and i want to use that procedure in my project. What I wish, is if u can help me write code so i can enter datetime parameter in two text boxes and with one click on button to receive filtered data from my database on my datagrid....
|
|
|
|
|
This is not a question well suited for a forum. What you want to do is covered in countless tutorials, examples and articles already.
search "stored procedure in vb.net"[^]
If you have any more specific questions about it once you have tried, that would be a question more suited for a forum.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Hi, I want to design a form in the VB2005(visual studio 2005) to receive data(temperature measurement result) from microcontroller(which is CPLD coolrunner II) after received the data then it will be display the temperature result on the computer screen. First, the data will transmit from CPLD, then it will send by MAX232 to RS232 and then display it on computer screen. I need help, how to make a form and code for the serial
data-in from CPLD. I am using Verilog-HDL for CPLD microcontroller. Can any one help me.
Thanks
|
|
|
|
|
Your description just looks like you need to read data from a serial port. If that's it, then you really don't have to do anything with the microcontroller since it sounds like its already knows what it's supposed to do.
Google results for "vb.net 2005 read serial port"[^].
|
|
|
|
|
Thanks, but one of the problem is that version of VB? I have read many of books, but all talk about VB6 so I am quiet confusing right now. Do you have any related code? Just read a data from the serial port using VB2005.
Cheers
|
|
|
|
|
Hi,
first of all I agree with what Dave said, as far as your code goes, it is not interested
in CPLD or other devices, RS232C is the standard you have chosen.
there are lots of articles about SerialPort class on CodeProject.
If you are in charge, I would recommend you let the PC side send a command to the CPLD
(say "T?") and have the CPLD react on that. Doing so, you don't need any events,
you just do the sequence "port write, wait a few msec, port read" whenever you like.
If your device needs to be in charge, you would need the DataReceived event,
and Control.InvokeRequired and Control.Invoke to update the GUI since DataReceived
event occurs on a different thread.
If some of this is unclear, Google for it. I just gave you all the keywords.
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
|
|
Hi,
I have an Excel spreadsheet with auto filters. This is how I loop through the filtered rows (just to display the rows and columns that are visible after the filter:
Dim rngFilter As Range, rngC As Range, rngJbn As Range
Set rngJbn = Range("A2:R" & Range("R" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeVisible)
For Each rngC In rngJbn
MsgBox rngC.Value
Next
I started displaying data from row 2. Reason is because in the first row there is the dropdowns. As I loop through the columns, I want to be able to check the index of the current cell. I want to do a check on the corresponding cells drop down value. Something like:
If current cell column index = 2 Then
total = ...
End If
Please can someone help me?
Thanks
Brendan
|
|
|
|
|
How would I force it to go to the next row?
Dim rngFilter As Range, rngC As Range, rngJbn As Range
Set rngJbn = Range("A1:R" & Range("R" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeVisible)
For Each rngC In rngJbn
MsgBox rngC.Value
Next
|
|
|
|
|
Does anyone know how can i connect vb.net to MySQL? Please give me an example.
Thanks
Socheat
|
|
|
|
|
Here[^]
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
hi..,
Check This...
** Declaraion
Public MyConnection As New OdbcConnection
Public MyConString As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=localhost;" & _
"DATABASE=amri;" & _
"UID=root;" & _
"PASSWORD=palm;" & _
"OPTION=3;"
Open Data base.
MyConnection.ConnectionString = (MyConString)
MyConnection.Open()
reply for more Info,,......
Thanks
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
Do you anyway to use with ODBCConnection? Because I can not add it to ODBC, MySQL is store on Linux and i use vb.net to connect it.
Thanks
Socheat
|
|
|
|
|
If you were not too lazy to try a simple google search, you'd find there's an entire website dedicated to connecting MySQL to VB, where I'm sure you can find examples of every possible combination you could hope for.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Socheat.Net wrote: Do you anyway to use with ODBCConnection?
Perhaps may sentence readable understand?
Socheat.Net wrote: Because I can not add it to ODBC
ODBC is a database driver, you don't add databases to it.
Socheat.Net wrote: MySQL is store on Linux and i use vb.net to connect it.
Yes? You just got an example on how to connect to a database using ODBC, just change the name from localhost to the name of the server.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Socheat.Net wrote: ODBCConnection
Using ODBC will slow down the application performance as it adds extra layer to the communication (Information from colin). So use MySQLConnector[^], which is ADO.NET library built for communicating with MySQL.
|
|
|
|
|
hi all,
i am creating add-ins in excel 2007 . In my application, i use some form . i want to that if user change the theme/color of excel then this change is also applied on my form.
anybody have idea that how can i perform this task ?
if possible ,then Please provide some code snippet.
thanks
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
I have a table's field that "Date". It contains severial data, some are same.
(Eg. 20/11/07
20/11/07
20/11/07
25/12/07
25/12/07
25/12/07
27/12/07
27/12/07
29/12/07
29/12/07
30/12/07
31/12/07 ,etc...)
20/11/07 is 3 data.
25/12/07 is 3 data.
27/12/07 is 2 data.
29/12/07 is 2 data.
30/12/07 is only one data.
31/12/07 is only one data.
I wanna display the above data onto a ComboBox by desending. I wanna collect only one data for a same many data.
(Eg. 31/12/07
30/12/07
29/12/07
27/12/07
25/12/07
20/11/07
... etc )
Please give me some suggestion for above metter.
|
|
|
|
|
You need to check if a value is in the list already before you add it. IF you're getting data from a SQL source, use the UNIQUE keyword to get unique values.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
hi..,
i am trying to give you 2 suggestion.
1. Try to retrive the unqui date from data base. when you are retriving data from dbase base
user "distinct" keyword in query
Ex: select distinct mydate from mytable.
or
2. use the below logic.
dim innlop,temploop
dim dupflad as boolen=false
combobox1.items.clear
For innlop = 0 To ftp_ds_NT.Tables(0).Rows.Count - 1
dupflad =false
for temploop=0 to combobox1.items.count -1
if ftp_ds_NT.Tables(0).Rows(innlop)(0) )=combobox1.item(temploop)
dupflag=true
end if
next temploop
if dupflag=false then
combobox1.items.add(ftp_ds_NT.Tables(0).Rows(innlop)(0) ))
end if
Next innlop
********* Please Ignore the syntex errors **************
thanks
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
A nested loop is always expensive, and for loops are always nastier to read than for each, but in this case, just combobox1.Items.Contains would work. You could also replace the dupflag variable with a simple continue statement.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
hi...,
So that i can remove one loop., nice ... , i accepted.
Thanks Christian Graus
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
Hi! I've converted a vb6 project to vb.net project, I'm using crescent (IIIrd party control)combo box in this project. The problem is sometimes combo boxes do not display data but actually data is there as seen from Immediate window and by displaying through message box. But sometimes combo boxes do not display the data. I'm not sure what the problem could be? I would like to add that same code in vb6 is running perfectly fine. Have any of you come across such a problem. Any help is appreciated.
Thanks
Don't Quit
modified on Tuesday, March 18, 2008 2:43 AM
|
|
|
|
|
Show us the code that do that
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
This would be a question for the manufacturer of the control library, Sax.net[^]. You may also want to find out if they have an updated control library for .NET Framework applications.
|
|
|
|