|
in the cell change value event do the following
check the location of the cell
if it is 3/3 check the value of the cell
if 1 then select row 15
else select row 4
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi, I have made a database where I can sort all my mp3's.
When I search for an artist, I can open a song in Windows Media Player just by double-clicking it. My problem is that if I want to play more than 1 song at a time, Windows Media Player removes my "Now playing" list and starts playing the song I only want to ADD to the list.
I have searched for a solution for this and I found some info at this page, http://msdn.microsoft.com/en-us/library/aa386383(VS.85).aspx[^], but it did not solve my problem. I still can't add a song to the "Now playing" list. 
What I want is a command that behaves like when I r.click on a mp3-file in Explorer and choose "Add to Windows Media Player list".
I would be very grateful if anyone can help me with this. I have tried to find a solution for 4-5 hours now and I'm close to giving up...
- Ragnar
|
|
|
|
|
Looking though the file options for WMA files, I found that when you click on a WMA file, Windows uses the following command:
"C:\Program Files\Windows Media Player\wmplayer.exe" /prefetch:5 /Play "%L"
%L is the path to the file/files (I assume). You will have to experiment. Usually %1 indicates the path.
Hope that helps,
Ray
|
|
|
|
|
Thanks for answer, but it did not help me with my problem.
But I got some nice results when I searched with /prefetch that showed me that Winamp could do what I needed, so now I can just do it with
'Winamp /add "songname"'
- R
|
|
|
|
|
I am confused ,
I am delevering thousands of video frames from different movies to my main program.
-BaseClass : 'papa' , handles frames
-Has got a declared class : 'baby' , produces frames
First it thought of raising a event in baby when a new frame arrived.
Papa class could have a handler to handle the frames.
But then it thought : events use a messageque somewhere , mayb no good idea.
Secondly , i thought of calling parent.dowork sub in baby class.
But when i wrote a test project, parent.dowork is a = only 1 % faster.
raise event : 10138 papa.dostuff : 10067
raise event : 10123 papa.dostuff : 10171
raise event : 10154 papa.dostuff : 10143
raise event : 10338 papa.dostuff : 10264
raise event : 10204 papa.dostuff : 10799
raise event : 10729 papa.dostuff : 10720
raise event : 10579 papa.dostuff : 10156
raise event : 10181 papa.dostuff : 10285
raise event : 10918 papa.dostuff : 10752
raise event : 10377 papa.dostuff : 10317
?????? HUH ???????
Jarno Burger
Video Jockey
modified on Sunday, May 17, 2009 9:04 AM
|
|
|
|
|
huh ? what is the question ?
This signature was proudly tested on animals.
|
|
|
|
|
how is this possible , that raising event is as fast a calling the sub in the parent?
Jarno Burger
Video Jockey
|
|
|
|
|
That is because it was written by someone who can't read. You.
|
|
|
|
|
haha 
Jarno Burger
Video Jockey
|
|
|
|
|
hey,
i must say i am letting all my friends run crazy over this world that i am in at this present moment.
Troy
|
|
|
|
|
There wouldn't be that much of a difference. I guess you were thinking that messages sit around in the message pump for a few seconds before they're processed?? Not true...
Having the child directly call a method in the parent class in not a good idea, unless you're using delegates and Invoking. The child should never be tied directly to another class.
|
|
|
|
|
thats cool to know for sure. i was always doubting that. thats why i qualified my question as a easy one. thnx.
Jarno Burger
Video Jockey
|
|
|
|
|
I have a class for MyDataGridView - To control the Enter Key , the below is working fine. But I canot focus to particular row for repeated values.
Actually if the user enters the repeated value, then the control has to move to that particular cell.
-------------------------------------------------
Public Class MyDataGrid
Inherits DataGridView
Protected Overloads Overrides Function ProcessDialogKey(ByVal keyData As Keys) As Boolean
If keyData = Keys.Enter Then
Dim col As Integer = Me.CurrentCell.ColumnIndex
Dim row As Integer = Me.CurrentCell.RowIndex
If Not (row = Me.NewRowIndex) Then
If col = (Me.Columns.Count - 1) Then
col = -1
row += 1
End If
Me.CurrentCell = Me(col + 1, row)
End If
Return True
End If
Return MyBase.ProcessDialogKey(keyData)
End Function
Protected Overloads Overrides Sub OnKeyDown(ByVal e As KeyEventArgs)
If e.KeyData = Keys.Enter Then
Dim col As Integer = Me.CurrentCell.ColumnIndex
Dim row As Integer = Me.CurrentCell.RowIndex
If Not (row = Me.NewRowIndex) Then
If col = (Me.Columns.Count - 1) Then
col = -1
row += 1
End If
Me.CurrentCell = Me(col + 1, row)
End If
e.Handled = True
End If
MyBase.OnKeyDown(e)
End Sub
End Class
----------------------------------------------
with my form
Private Sub MyDataGrid1_CellEndEdit(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles MyDataGrid1.CellEndEdit
If MyDataGrid1.CurrentCell.ColumnIndex = 0 Then
Dim RwNum As Integer = 0
Dim ep_id As String = Space(10)
ep_id = MyDataGrid1.CurrentCell.Value
RwNum = dbndf_52.Find("emp_id", ep_id)
If RwNum > 0 Then
MyDataGrid1.CurrentCell = MyDataGrid1(0, RwNum)
End If
End If
End sub
It's moving to that new row but again, retun to the previous row and moving to next column. This is my problem.
Anybody can help me to repair it? 
Thanks
|
|
|
|
|
Paramu1973 wrote: Actually if the user enters the repeated value, then the control has to move to that particular cell.
Why?? This sounds like a user interface nightmare.
|
|
|
|
|
Hi Dave,
Thanks For Your Comments. From that particular table, field Emp_ID is not a primary key field.
So there is possible to re-enter the same emp_id.Once the user re-enter the emp_id, then we need to focus the
particular emp_id cell.
Is It Possible To Focus To The Different Cell?
Thanks Again
|
|
|
|
|
The users should not be generating their own record keys. That should be left up to the database. I would recommend that you look for duplicate data in the database at the time it's entered, not at the time it's trying to commit to the database.
|
|
|
|
|
Why would you put the focus on an existing ID?? That would just set you up for the user destroying data already existant in the database.
IMHO, users should not be using the DataGridView for entering data. It should be done using a dedicated form or control, seperate from existing data.
|
|
|
|
|
Hi,
Thanks for the kind advice, But as per my opinion, users are interested in Datagridview method. Because, they are able to see their previous entries as like Excel.
And by the way I solved by focusing from Datagirdview editing Control Showing -Keydown. But it took my one-day.
Thanks For Your Kind Reply !!!!
|
|
|
|
|
Hi all,
i am a student from Hong Kong who only know a little bit VB.
i have some questions about Visual Basic 2008.
1. how to import a excel/csv file to axspreadsheet/DataGridView?
2. how to convert csv to dbf/mdf from axspreadsheet/DataGridView? (the csv file is huge , it cannot open from excel directly.)
3. how to compare two DataGridView and output the result to a new DataGridView.
4. how to make a filter function for DataGridview ( function like AutoFilter in the excel)
Anyone can help me ? or suggest a book/reference to me for those question?
Thank you very much.![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
If you "only know a little VB", you're going to find this project impossible. Some of your questions require that you know how to do database operations in VB.NET, along with a decent knowledge of the .NET Framework.
1. Google: "VB.NET import csv file"[^]
2. See #1. You're reading a CSV file line by line, parsing it, then putting the data into a database INSERT query and executing it. Google for "vb.net insert data to Access database[^]".
3. You're not comparing to DataGridViews. DataGridViews would be bound to DataTable objects and showing the data in those objects. You either compare the two DataTable objects, row by row, field by field (this will take a while!), or you have the database do it for you somehow. Exacty how you do this depends on the data and the comparison you want, and what the result your looking for should be.
4. You'll need to look into the DataTable and DataView classes. There is a Filter property that will let you do this.
|
|
|
|
|
Thanks for your reply.
I know it is hard to do this for me. However, i will try my best to finish it.
I decided to find a book and study by Chapter 1.
|
|
|
|
|
coolqer wrote: I decided to find a book and study by Chapter 1.
Fantasic idea! You'd be surprise how many people don't want to learn the basics before trying to write something like an enterprise-class accounting package.
|
|
|
|
|
a book is an excellent idea and there are plenty of articles [^]available for learning as well
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thank you very much~
although it is C#,it still a great simple for me.
|
|
|
|
|
Hello, i am trying to make a POST to my router, i have literaly turned google upside down but to no avail.:S Does anyone give me some help? thankyou
i have the following information:
<b><u>POST</u></b>
http://192.168.1.1:8080/status/editppp.html/PppoE
Request Header
<br />
Host: 192.168.1.1:8080<br />
Authorization: Basic YWp1ZGFtZSE=<br />
Referer: http:
Content-Length: 151
Request Body
EmWeb_ns%3Avim%3A3=%2Fstatus%2Feditppp.html&EmWeb_ns%3Avim%3A8.ImServices.ppp-0.1%3Aenabled=false&EmWeb_ns%3Avim%3A4=ImServices.ppp-0.1.ImChannels.item0
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
