|
DataReader is readonly, forward only and for connected use. It means that at time you can access all fields for only one record. Then you need is to more forward and read the next and so until you are done with data. For example
OleDbReader dr = command.ExecuteReader();
while(dr.Read())
{
Cosole.WriteLine(dr[0].ToString());
Cosole.WriteLine(dr[1].ToString());
}
If you want to insert something then DataReader wouldn't help you. You need to write another command and execute it.
|
|
|
|
|
how to implement Filter for listbox using textbox in windows application using vb.net
i have a textbox and a listbox in my application
listbox id binded from database..
now when the user enters anything in textbox the items which starts with the text enterd in the listbox should filter and come in the first
(i mean list box is already filled in ascending order,so only the thing is the scroll should move to the starting of the word which is enterd in the textbox
)
how can i achieve this? any idea?..
(same like the index search in microsoft sites)
|
|
|
|
|
Hi,
I see basically three ways to achieve this:
1.
adapt the database query as you type, using a "LIKE '+myInitialText+"%'" clause. That would be easiest.
2.
adapt the items shown in some other way, maybe by copying them to a list, working on the list, and setting the new list as the new datasource
3.
leaving the items as is, however simply not showing some; that takes DrawMode.OwnerDrawVariable, and returning height zero in MeasureItem for the items you want to hide. (I haven't done this yet, but I think it should work).
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
sorry for the noob question, but i really dont know how to parse down the question to get the answer.
what i am looking for is during setup of an installation program in VS2005 (or newer) how can i have a program added to a users right-click menu for specific file types. an example would be an ISO image burner that i have dl'd and when i right click on an ISO image, the program is present for me to choose.
so, how would i add that to my installation package?
many thanks in advance!
oed
|
|
|
|
|
oedipusrex wrote: how can i have a program added to a users right-click menu for specific file types.
I think you need to add your program in the context menu like the way if you right click on a text file "Notepad" application comes as an option.
You can try out the option mentioned here[^] (thoug i did not get a chance to veify ).
I found few products are also available [^]which you can add while packaging your installer and obviously it should permit your budget .
Keep me posted if you need any further help.
|
|
|
|
|
Thanks Arindam, I checked out that first link and I understand what he was talking about, however where in my installation package do I add that information? I get the whole merge module business but where or how does that get edited? I have checked the MSDN but either I do not know what to search for or how to phrase my question or simply not experienced enough (on a 4 level scale, I figure myself to be a level 2 programmer...I can code in c++ and vb and a little win32 and put together a simple install package, but that's it) and MSDN only gives a skeleton outline of the process of creating a merge module.
If I have to code it out directly, then that is fine. I am not asking for a direct step-by-step answer, only to be pointed in the right direction. Thanks a million!
|
|
|
|
|
oedipusrex wrote: package do I add that information?
I think probably you understand that you need to have something registry entry for your application (something like below one)
HKEY_CLASSES_ROOT\<file type>\shell\<display text>\command
Now your point is how to do that?
I think this MSDN article[^] might help you.
Keep me posted if this does not help you.
|
|
|
|
|
|
Is your problem resolved?
Keep me posted on this.
|
|
|
|
|
Dear Developer,
I'm very much concern linq versus stored procedures. can you give an idea where is the best tools to data execution and distribution more faster
TY
|
|
|
|
|
Are you asking how to use stored procedures in Linq to Sql? AFAIK, Entity Framework is replacing Linq to SQL. You should take a look at entity framework rather than learning obsolete framework.
Rolando Y. Puno wrote: where is the best tools to data execution and distribution more faster
What do you mean by that?
IMO, frameworks like Linq to SQL and Entity framework provides a clean abstraction over the data access. It helps you to write maintainable and readable code than giving super fast performance. You get much better performance when you work directly with commands and data readers. My suggestion is to write maintainable code than thinking about performance.
|
|
|
|
|
The SQL generated by EF is sometimes not the best from a performance basis so you may need to use stored procs in conjunction to get the best from it.
only two letters away from being an asset
|
|
|
|
|
Hi I have a service written in Visual C++ 6 that needs to interact with an application written in vb.net. In my service I have used :
<b>DWORD mymsg=RegisterWindowMessage("my_message")</b>
to register a unique custom message.
I then use:
<b>BOOL b=SendNotifyMessage(HWND_BROADCAST,mymsg,NULL,NULL)</b>
to broadcast my message. However, I can't seem to be able to capture this message in the Windowproc function of my vb.net application.
<b>Private Declare Function RegisterWindowMessage Lib "user32" Alias "RegisterWindowMessageA" (ByVal lpString As String) As Integer
Dim mymsg As Integer = RegisterWindowMessage("my_message")
Protected Overrides Sub WndProc(ByRef m As System.Windows.Forms.Message)
if m.Msg=mymsg then
--do something--
end if
end sub</b>
Please help!
P.S.:I need to show a pop up in my .net application when it receives this message. The message values have all registered properly in both applications and are returned to be the same when I print them. Also the SendNotitfyMessage in my service returns a non zero value(supposed to indicate success). What do I do?? What am I doing wrong? Is there something wrong with my message receiving code in vb.net?
|
|
|
|
|
Try changing your WndProc declaration to:
<System.Security.Permissions.PermissionSetAttribute(System.Security.Permissions.SecurityAction.Demand, Name:="FullTrust")> _
Protected Overrides Sub WndProc(ByRef m As Message)
2+2=5 for very large amounts of 2
(always loved that one hehe!)
|
|
|
|
|
Thanks for the suggestion but I tried it and it didn't really work. I don't think it's a security issue. I doubt that.
|
|
|
|
|
Erm I just read your post again and see you are talking about a "service". If you mean a windows system service, then what Mark said is right: you shouldn't be using windows messages to exchange information - follow his advice and use some other form of inter process communications.
2+2=5 for very large amounts of 2
(always loved that one hehe!)
|
|
|
|
|
callousfantom wrote: a service written in Visual C++
A Windows service application? If so, services run in a different desktop
so you may want to use a more suitable IPC mechanism instead of window messages
which don't cross the desktop boundary.
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Are you trying to say that since the service (SYSTEM acct) is running under a different user context than the application, that the messages won't reach the application from the service? Because my application can communicate via messages with my service using its handle.I've already done that. This implies I can only communicate from the app. to the service and not the other way around. Or does it mean that I can only use handles to communicate one-to-one and broadcasting won't work? Neither of the two seem to make sense to me.
As for another way, I could use custom named events but I've already done one way via messages and I thought I could do the same thing in the other direction.
If there's something else you were trying to suggest then I'm sorry I don't think I quite understood you.
|
|
|
|
|
Hi thanks for all the advice. I've managed to take care of it. I had to make the service interactive in order to make my application visible to it and I found no other way of making it visible due to the different user contexts. So you were right
|
|
|
|
|
Greetings.
I'm trying to communicate between desktop PC and Windows CE 5.0 device connected by usb (cradle).
I feel like I'm missing something obvious, because I can't find how to establish connection between them. What namespace to look? I just want simple communication: connect, exchange some data, disconnect. Sockets are more then enough, but what address should I access? The one assigned by usb connection on handheld is not accessible on desktop machine.
Communication should be initiated from desktop PC.
My handheld is running Windows CE 5.0 with .NET Compact Framework 2.0
Please point me to the right direction
--
"My software never has bugs. It just develops random features."
|
|
|
|
|
Maybe take a look at the rapi.dll and see if it does what you need, you need to p/invoke the methodes.
Take a look here
And here
|
|
|
|
|
how to perform calculations in datagridview columns
(adding two columns and result in new column)
can any one suggest me any site
thanks in advance
|
|
|
|
|
Some of the gurus on here will probably have a better idea for this but this is what I would try:
Dim myCol As New DataGridViewColumn ' I think this is the type. My code was an image column<br />
myCol.Name = "colname"<br />
dgvMyGrid.Columns.Insert(1, myCol)
Then you'll need to access the values of the numbers you need to add and the column where the result should go. I do most of my processing in my OnCellFormatting event. And in there, I access the values of the current row's items with something like this:
(sender.Rows(e.RowIndex).Cells(14).Value <br />
Of course, you'll need to know your column's number. And don't forget to account for the one you entered.
Hope this helps.
Denise "Hypermommy" Duggan
|
|
|
|
|
|
Hi
I have made a project and used
tabcontrol of Visual Studio 2005. The problem is that when I run the project and bring the mouse arrow to the tab heading it start blinking/trembling.
Please, reply if anybody can.
Thanks in advance.
|
|
|
|