Search results for query: *

Example Got the answer here. Since I had put a test certificate and not an authentic one on the test server, all non-local machine calls were blocked. http://msdn2.microsoft.com/en-us/library/aa730835(vs.80).aspx As long as this is in the client class (mine are shared for testing)...

Thanks for posting tips. Just what I needed! Hi thanks for the posting tips. That exactly what I needed. Sorry, when you said "iterate" and spoke of treeview I had a flashback to the days when I could, without recursion, truly iterate all the nodes in the treeview collection. It was painful...

Try this First set a variable to the type in the webservice that it expects to receive. Then new up an object that points to your web service reference class name Then call the method, just like you would if it were local, and get the result back. Then inspect the result. Dim...

Good to see it working Great you got it to work. Nice to have several choices implementing workarounds to TreeView non binding capability. How did you get the tabs and indents to show in your source code post??? Found an article to get the key back into treeview too...

Debug your webservice from winform You can debug your web service from a winform call into it (assuming net2.0 but net1.1 even easier) 1) Add a winform project to the same solution your webservice is in. Then right-click on the solution choose properties and select "Multiple Setup Projects"...

Maybe use TAG, AfterSelect, and a BindingSource Is BindingSource.Find ok to use in your app? It would return an integer to set the BindingSource.Position with. Don't know if what would affect in your app but could use the tag to store the PK field(if single field). Then of treeview node...

Maybe try this Whats the whole exception.ToString say? There maybe some more in there to help diagnose. 1) you can restart SQL Server also maybe try disabling NamedPipes as one of the network libraries. Open the Sql Server Program group and select Client Network Library, select the NamedPipes...

Sorry, didn't know where the user was going with the request. Looked like they picked up MsAccess code and dropped it in a vb.Net module. I was helping them resolve the CurrentDb line of code in their original post to make it work in VB. And offering them ADOX as an easier(IMHO) alternative to...

Oops, my mistake... correction included Oops, my mistake. I just tested this and it works but I don't think you can actually create a database using DDL. For that you need the ADOX. Dim TheDbName AsString = "C:\YourNewDbNamer.mdb" Dim oConn AsNew ADODB.Connection...

A complete working example Check out this post http://www.vbdotnetforums.com/showthread.php?p=50849#post50849 Note as indicated by others. ADOX is not managed code, neither is ADODB. There is no way to access ADOX without interop. Your code should always strive to be purely managed. Make...

Here is a complete working example: Attached a complete tested example in zip file: It creates a database(mdb file) if it doesn't exists It creates the table if it doesn't exists It creates the columns with autoincrement data types and default values It creates a primary key on the table It...

Looking for a complete working example(asmx, classes, and a test client snippet). I am having trouble and need some expertise. I have external clients (read I have no control and they won't let me help them) to call into a web service running under SSL on IIS. I want to rig the webservice...

Here is a complete working example I only used your child table to accomplish the result USE YOUR_DATABASE GO IF (OBJECT_ID('DELETE_ME') IS NOT NULL) BEGIN DROP TABLE DELETE_ME END GO CREATE TABLE DELETE_ME ( [ID NO] INT, [REV NO] INT, [REQUIREDDATE] SMALLDATETIME ) INSERT INTO DELETE_ME...

Does it look like this now in your code? "UPDATE tblMember SET Firstname ='" & txtFname.Text & "' WHERE memberID ='" & txtMemberID.Text & "')" If so try... "UPDATE tblMember SET Firstname ='" & txtFname.Text & "' WHERE memberID ='" & txtMemberID.Text & "''" Remember, all we did is add single...

Whoops. Lose the last closing parantheses. Sorry I didn't catch that earlier. Your update statement doesn't need the parenthesis. Just UPDATE TABLENAME SET FIELD=VALUE WHERE FIELD=VALUE

A working example Here is an example. It does all the load, insert, update, delete and uses a binding source so text boxes are sync with datagrid. Just change the database path or put mdb on C:\ HTH

ASP WINFORM example view images Google on database image display asp winform ASP page html <IMG SRC="YourAspFile.Asp?ImageId=X"> ASP/winform pagecodebehind Dim oConn AsNew MySqlConnection("server=YOURSERVER;user id=YOURUSER;password=YOURPASSWORD;database=YOURDB; ") Dim oAdapter AsNew...

Two good examples Nice one. Being self taught I do things in little nuggets that build up to the solution. With my style I can run the inner query, make sure its right, then run the next outer query, etc until I get the result I want. At any rate, V-B_New-B, hope you get some useful...

Maybe change connection string? FROM cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='C:\database\axx_ss.mdb'" TO cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\database\axx_ss.mdb; User id=admin;"

You'll need a correlated subquery and derived table 0) Get the max REV NO for each ID 1) Calculate, in correlated subquery, the number of days interval [note the B to A linkage] 2) Wrap in derived and filter for days < 6 SELECT [ID No], THE_MAX, DAYS_DUE FROM ( --get the max for each ID...