|
You would need to use RDA
Refer
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_rda_intro_remote_data_access.asp
Sanjay Sansanwal
www.sansanwal.com
|
|
|
|
|
Hi all,
This is for anyone who has experience with this control or is willing to help
In MSDN, there is a sample of a DataListView class, derived from ListView, that implements a data source for ListView:
http://msdn.microsoft.com/library/en-us/dnadvnet/html/vbnet08262002.asp
Which is great. The problem is this: Let's say I put a DataListView control on my form. Then I perform the following steps to add some columns:
Click on the Columns property and add some columns
Click Ok in the Columns property window when I'm done
(up to here, it's like a normal ListView)
Set the AutoDiscover property to False
Now, I re-open the Columns property window and voila! It's empty! If I look in the code, it DOES create the column objects. When I run the application, I don't see anything, as if no columns are defined. Only if the AutoDiscover property is ON, do I see the columns, data, etc.
Any idea on how to use this bloody control???
Thanks,
/=/=/=/= Sagmam =\=\=\=\
|
|
|
|
|
The control code has a check wherein if AutoDiscover property is set to false then DataListView would take default column names from the datasource. To achieve this, existing columns are deleted
Check:
Public Property AutoDiscover() As Boolean
Get
Return mAutoDiscover
End Get
Set(ByVal Value As Boolean)
If mAutoDiscover = False AndAlso Value = True Then
mAutoDiscover = Value
DoAutoDiscover()
Else
mAutoDiscover = Value
If mAutoDiscover = False Then
mColumns.Clear() ' THIS LINE
End If
End If
End Set
Refer:
Auto-Discovery of Metadata
While it is nice that the end programmer can manually specify the columns to be displayed, along with the data fields to which they are bound, we should also provide a more automated alternative. Ideally, the control should be able to examine the data source and use its metadata to determine all the available data fields. Column headers can then be created for each field so the control can bind to all available fields.
Sanjay Sansanwal
www.sansanwal.com
|
|
|
|
|
Thanks, I've noticed that too, only I wasn't sure why it happens in design time. I also noticed that, unlike ListView, the Designer doesn't add the "MyList.AddRange(...)" statement to the InitializeComponent method. Even if I add it myself, it doesn't help because there's another problem: you cannot have unbound columns within the list (mField = nothing).
So all in all, I wish I had a better way of doing this other than manually build my list view, but I don't. I'm just not so good with Designer-enabled user controls, so I don't know what to change in DataListView in order to make it better for my needs. The best I can do is create a DataListView of my own that is not Designer-enabled.
/=/=/=/= Sagmam =\=\=\=\
|
|
|
|
|
OS: Winxp and Win2003
Visual Basic.NET 2003
MS-SQL Server 2000
hey all
I am a newbie in vb.net but i have managed to build a simple chat server in vb.net using socket and a client connecting to it made in vb6. Some of the code in the server are based on the basic samples that i get from other authors. To give you an idea, the server uses sockets, multi-threading and a database connection to MS-SQL server 2000. the off line messages, contacts lists, current status of the rooms and conference rooms are stored in the database. The client app is already done and it already meets the requirements for connecting into the server, but my server has not been optimized to do its job since i am in the code,debug and learn level, i'm still trying to make it stable. But during my testing of the server it pops an error which i haven't solved for a few weeks now especially if the server is running for a longer period of time. I have searched to a number of sites but i wouldn't give me the exact solution to my problem.
Problem:
1.)Once the server is running more than 24 hours and receives a bunch of chat messages from the client application it tends to slows down its response to the client although im testing it on a single user connection, what i did was only send a test flood of messages , then connect and disconnect a hundred times.
2.)After a hundred of test flood messages to the server and connect/disconnect session from the client, the server pops an exception error such as “operation not allowed on a non-connected sockets” but when i click ok button of the msgbox my client app sees that it is still connected to the server. The client could still send commands such as [user search but not on private and room chatting anymore] .
3.)When the server tries to save a data into the sql server it then gives me another error “the statement has been terminated”.
4.)the problem that i mostly see is during login, private and room chat, saving to database. Other strange behavior of the server is that it can still recieve a search user command and then reply for the result but when i try to do private or room chat, there it pops the error messages again and no reply to the client whatsoever.
Questions
1.)Do you think vb.net can handle more than a hundred concurrent user online or more or maybe thousand?
2.)Do you think its a good choice to have the client built in vb6 and the chat server built in vb.net ? any ideas are welcome
Guys please i really need your help with my problems ! especially on socket and multi-threading. Any comments, suggestion or modification of the code are welcome. I have provided the server code in my site, I've omitted some of the codes and classes, to get you into the direct point, i have posted additional information of my problem in my site and some other screen shot of the error.
my site:http://www.geocities.com/jimmypearly/index.html
Thanks
Jim
PS sorry for my poor english.
-just make it tough
|
|
|
|
|
jimmypearly wrote:
1.)Do you think vb.net can handle more than a hundred concurrent user online or more or maybe thousand?
Yes. It's not the language or the .NET Framework that will be limiting you. It will be the server software licensing (Windows Server that is...) and the design of your chat server.
jimmypearly wrote:
2.)Do you think its a good choice to have the client built in vb6 and the chat server built in vb.net ? any ideas are welcome
You COULD use VB6 but I wouldn't recommend it since it's essentially deprecated. Writing the clinet in VB.NET will give you the most flexibility.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I'm creating a few programs for chat/email purposes. The idea was for there to be no central application and each program connect to the others kinda like in a p2p network (i think). I've not really got any idea how they are going to know what ip to connect to if each time the user connects to the net they get a new ip. I'm using networkstream and tcplistener/client because thats all I know how to use. Any ideas or even pointers towards classes better suited to this would be great.
Thanks
|
|
|
|
|
That's the whole problem of any P2P network: finding peers. There's not a single solution and not a perfect solution. You can try connecting the last peers seen, have a central server for locating peers, or some always-on, highly-reliable peers.
Yes, even I am blogging now!
|
|
|
|
|
i will be grateful if someone can give final year project ideas
|
|
|
|
|
Create a Pocket PC application for taking orders in a restaurant
Sanjay Sansanwal
www.sansanwal.com
|
|
|
|
|
Hi Everyone!
I need a help. I am in proces of development of Instant Messenger and Conferencing Tool. What I need is a support for proxy Server Also.
Like if you are behing Wingate Proxy and you want to Use the option for proxy Setting.
Like in MSN --> Tools --> options --> Connection --->
I want all the feature of this page.
Let me know if any one can help me. I will be really grateful.
Thank and Regards
Irfan Haider Jaffery
Software Engineer
|
|
|
|
|
Here is some code that has proxy settings implemented.
http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=1961&lngWId=10
|
|
|
|
|
I am wanting to create some small apps for Pocket PC. I have VB .NET 2003 Standard. I have installed eMbedded C++, eMbedded C++ SP4, and the CF 1.1 SDK. I still see no option under new project to create a VB porject for Pocket PC 2003. I DO NOT want to do a C++, J++, or ASP project but VB .NET CF app. Can anyone help me? What have I not instaled/configured? Does this only work with the PRO version of VB? I have searched and searched but the hits are overwhelming and generally unrelated to setting up to create apps in VB for Pocket PC.
Thanks for any help,
Glisson
|
|
|
|
|
Glisson wrote:
I still see no option under new project to create a VB porject for Pocket PC 2003
It is called a "Smart Device Application".
Glisson wrote:
Does this only work with the PRO version of VB?
Not sure about that.
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!
|
|
|
|
|
Yeah I remeber seeing that on some boards now but I do not have that option. It's driving me crazy too! I really want to play with that feature!
Glisson
|
|
|
|
|
It's NOT supported on the Standard or Academic Editions. You must have the Professional Edition or better.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanks for clearing that up. Even thought it's not the awnser I was looking for! Man that is a bummer! Looks like I need to start watching E-Bay. I can't justify paying retail for no more then I have planned or am likely to accomplish. LOL
*EDIT* I forgot about the Acedemic versions. I started digging up some more info and according to this site msdn feature comparison, it IS supported by the Acedemic version. Guess it's back to school for me. LOL
http://msdn.microsoft.com/vstudio/productinfo/overview/academic/features/comparison.aspx[^]
Thanks again,
Glisson
|
|
|
|
|
Hi,
I am building a simple windows form which mimics the windows media player.
It user the wmplayer control, and has as transparencykey white.
For some reason the player does not play the video files correctly. I hear
the audio part but the video part is not displayed, except some flickering
iat the start. If i dont have any colors as transparencykey it works fine.
How do I fix this issue?
thanks
|
|
|
|
|
are you using a bitmap or picture loaded as a resource?
If you are then load it as a file instead I have seen this be an issue before.
|
|
|
|
|
I just specified the a png file as the background image of the form. How would I load it as a file?
thanks
|
|
|
|
|
Me.BackgroundImage.FromFile("c:\windows\clouds.png") ' whatever your path and file is.
|
|
|
|
|
The problem exists even if I dont specify a background image.
|
|
|
|
|
|
I am writing a distributed transaction code. My current scenario include a client database(Suppose client- having 4 main database) which can be installed anywhere which would connect to a public database placed at ISP datacentre(Suppose Server- having 2 database[host,transmissionqueue]). this server database is added to client as linked server through vb.net interface. i have a transmission routine which transmitts the data from the client to Server and update client transmit field. If i implement the distributed transaction in this scenrio is there any alternate to MTS . I m using the distributed transaction through vb.net interface using transaction object and setting 'begin distributed transaction' and 'set xact_abort on' and 'SET NOCOUNT ON' and 'SET REMOTE_PROC_TRANSACTIONS ON' options.
Sample code
''Start (Coding in VB.NET/ SQL Server 2000 backend on windows XP)
Public Function TransmitFiles(ByVal filepath As String, ByVal oDtTransmit As DataTable, ByVal iStation As Int16, ByRef TransmitErrorDetails As String) As Int32
Dim myConnection As SqlConnection = New SqlConnection("Data Source=shabbir;Database=AGS_LOGISTICS;UID=sa;pwd=SA;")
myConnection.Open()
Dim myTrans As SqlTransaction = myConnection.BeginTransaction()
Dim myCommand As SqlCommand = myConnection.CreateCommand()
myCommand.Transaction = myTrans
set_OPtions_on_database(myConnection, myTrans)
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')"
myCommand.ExecuteNonQuery()
myCommand.CommandText = "INSERT INTO [192.168.1.181].AGS_TRANSMISSIONQUEUE.DBO.MANIFEST SELECT * FROM MANIFEST WHERE ORIGINSTATIONID=9007 AND TRANSMITTED=1"
myCommand.ExecuteNonQuery()
myTrans.Commit()
myTrans.Dispose()
Console.WriteLine("Both records are written to database.")
Catch e As Exception
myTrans.Rollback()
end try
end sub
''End
Different problems are coming at different time
1- The problem is that transaction object is running fine but its not inserting anything in the database.
2- the executenonquery is returning -1 even where it is returning the correct record affected count without the transaction object for this command.
3-sometimes giving SQL server not found or Access Denied from the front end.
4- Some times SQL log is showing
2004-08-14 07:55:35.46 server Attempting to initialize Distributed Transaction Coordinator.
2004-08-14 07:55:35.53 server Failed to obtain TransactionDispenserInterface: Result
Code = 0x8004d01b
2004-08-14 07:55:35.54 spid3 Starting up database 'master'.
2004-08-14 07:55:36.03 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-08-14 07:55:36.03 spid5 Starting up database 'model'.
2004-08-14 07:55:36.06 server SQL server listening on 192.168.1.190: 1433.
2004-08-14 07:55:36.06 server SQL server listening on 127.0.0.1: 1433.
2004-08-14 07:55:36.06 server SuperSocket Info: Bind failed on TCP port 1433.
2004-08-14 07:55:36.09 spid3 Server name is 'SHABBIR'.
?????Can some body explain what is wrong with my coding or wht setting to made in the system?
* I m using window XP professional and .NEt studio 2003 and MSSQL 8.0
one of my testing server is also the same confing and other testing server is windows2000 server.
Important : will i have to install MTS on each client or server only if i went for Distributed transactions through DCOM and MTS?
Will i face any difficulties regarding the com registration?
Can some body provide some short sample project?
or Can some body provide some Code sample for the transaction class and how to configure in the MTS?
Can some body provide Some helpfull links to clear my concepts and helpfull in implementation and code?
All your help would be highly appreciated.
Regards,
Shabbir
shabbir
|
|
|
|
|
Is your server's IP address changing...
It looks to me like you have a network router/hub, Firewall or Unconfigured Qos service, problem.
Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
0x8004d01b "The transaction manager is unavailable" .
It is possible that DTC is shutting down unexpectedly.
SuperSocket Info: Bind failed on TCP port 1433.
(would not bind if DTC is in a shutDown State)
http://support.microsoft.com/default.aspx?scid=kb;en-us;319578&sd=tech
"Important : will i have to install MTS on each client"
You can use the MTS Explorer to distribute components to a client machine whether or not that client is running MTS. If the client is not running MTS, MTS can generate an executable that will automatically install and configure clients to access remote MTS server applications. The client must support DCOM for this procedure to work.
|
|
|
|