joe_pool_is

You can't get around the fact that you are going to have to create your web service first. After the web service has been created, you can build your web page to interact with the web service. If your web service is public on your server, someone else can use it within their aspx page the same way your aspx page uses the service.

LOL Yes, a compliment. I am expressing jealousy over your cool projects compared to my boring ones.

Jeez, EFileTahi-A. You make my database projects sound extremely boring.

This forum used to be much busier. I don't know what happened to it, though. StackOverflow, perhaps?

That was what I did - perhaps a couple of years ago. Basically, I created a separate project with its own namespace that I could serialize/deserialize from either application. Thanks for the note!

JumpyNET, Looks like you did a great job. Thanks for sharing your findings.

Wow! Finally a thread that isn't SPAM. ...and helpful, too! :) Thanks.

Hey Jib, I did an encryption job about 2 years ago. (see attached) I opened the project, had to update it to VS 2008, and verified it still worked. I don't remember why I did all that I did, but I did not need the DESCryptoServiceProvider class. Feel free to poke around my code. It should still work as is. The security key will be missing when you first run it, but the code will prompt you to create a new one and go from there. Hope it helps. jp2crypt.zip

I can write this quicker using C# (what I'm accustomed to): DataTable GetTable(string sqlSelectStatement, string connectionString) { DataTable table = new DataTable(); SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(con, sqlSelectStatement); cmd.Connection.Open(); SqlDataReader r = cmd.ExecuteReader(); table.Load(r); cmd.Connection.Close(); return table; } The code above has bad form and does zero error checking, though. Once you have the DataTable, you can get the info you want out of it.

Hi Nate, I completely agree! Some companies are very protective of their data, though. Wow. That post was almost 2 years ago! :) I doubt they still need help, though.

There are many examples on Microsoft that show how to do this. Here are two (2): http://msdn.microsoft.com/en-us/library/ms186197(VS.80).aspx http://msdn.microsoft.com/en-us/library/aa288436(VS.71).aspx If you have more specific questions, feel free to respond.

I don't think anyone is interested in downloading your code. Perhaps you could post a simple example of what you want to accomplish. Are you able to connect to your Access database with your OleDbDataConnection settings?

Alternately, you could use something from Adobe that you'd likely need to pay for. Microsoft details what to do about that: http://support.microsoft.com/kb/823241 Sorry for the round-about answer, but I did not understand what you wanted. It sounded like you wanted a way to view PDFs from within the VS IDE.

Here's a nice, free one: http://sourceforge.net/projects/pdfsharp/

That's where it should be. You could be looking at a "Trial Version" limitation. Does anything state what the limitations of the Trial software are?

To do this, create a new DataTable using the format of the DataTables your SQL query returned. DataTable data = new DataTable("CustomTable"); DataColumn dc1 = data.Columns.Add("User", typeof(int)); DataColumn dc2 = data.Columns.Add("Date", typeof(DateTime)); DataColumn dc3 = data.Columns.Add("Value1", typeof(string)); DataColumn dc4 = data.Columns.Add("Value2", typeof(string)); DataColumn dc5 = data.Columns.Add("Value3", typeof(string)); Then, loop through the data your query returned. If you want an item inserted, do that in your code to the new DataTable. foreach (DataRow row in sqlDataTable.Rows) { object objID = row["User"]; if ((objID != null) && (objID != DBNull.Value) { int ID = (int)objID; string val1 = row["Value1"].ToString(); if (!String.IsNullOrEmpty(val1)) { // Add To Table (if not already there) DataRow dr = null; for (int i = 0; (i < data.Rows.Count) && (dr == null); i++) { if (data.Rows[i][dc1].ToString().Equals(val1)) { dr = data.Rows[i]; } } if (dr == null) { dr = data.NewRow(); dr[dc1] = ID; dr[dc2] = val1; data.Rows.Add(dr); } } // Continue on with your other rows } } Finally, display the DataTable in your DataGridView (or whatever you are using): DataGridView1.DataSource = data.DefaultView;

Are you looking for a PDF viewer for your application or a PDF viewer for the VS IDE? Google is often a better place to start a search like this. A basic Google search is HERE.

First, get rid of the double equals (==). That is 'C' syntax. Next, have you tried the logic backwards and using parenthesis? If (MyArray Is Nothing) Then Return End If ' Process your code here

Express (i.e. the Free version) is the only one that can not create a setup project.

I have always turned the row headers off, so I don't know what that funky looking mouse glyph is all about. However, in the code above, it works better if you'll comment out the 'ClearSelection()' line. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'DataGridView1.ClearSelection() For Each row As DataGridViewRow In DataGridView1.Rows If (row.Selected) Then Console.WriteLine("Row {0} was selected", row.Index + 1) row.Selected = False End If Next DataGridView1.Rows.Item(2).Selected = True 'DataGridView1.FirstDisplayedScrollingRowIndex = 2 For Each row As DataGridViewRow In DataGridView1.Rows If (row.Selected) Then Console.WriteLine("Row {0} now selected", row.Index + 1) End If Next End Sub

Like CNET?

Here's some generic code I keep in my base form that all of my child forms inherit from: public static int GetFirstScrollingRowIndex(DataGridView dgv, string cellHeader, string cellText) { try { if ((dgv != null) && !String.IsNullOrEmpty(cellHeader) && !String.IsNullOrEmpty(cellText)) { if (dgv.Columns.Contains(cellHeader)) { for (int rowIndex = 0; rowIndex < dgv.Rows.Count; rowIndex++) { string dgvValue = dgv.Rows[rowIndex].Cells[cellHeader].Value.ToString(); if (cellText == dgvValue) { dgv.Rows[rowIndex].Selected = true; return rowIndex; } } } } } catch (Exception err) { Global.LogError(_CODEFILE + "DataGridView_", err); } return 0; }

Still not completely following you. So, are you trying to close a tab in design view by clicking on the little close button? In design view? One thing I noticed: I did a search on your project using the key phrase "Add View Page", since this is what you use to add a tab. In File esTabControl.vb there is a routine called "esTabControlDesigner" that looks like this: Public Overrides ReadOnly Property Verbs() As System.ComponentModel.Design.DesignerVerbCollection Get Dim v As New DesignerVerbCollection() 'Verb to add buttons If Control.Dock = DockStyle.None Then v.Add(New DesignerVerb("&Dock in Parent", AddressOf OnDockToParent)) Else v.Add(New DesignerVerb("&Undock from Parent", AddressOf OnDockToParent)) End If v.Add(New DesignerVerb("&Add View Page", AddressOf OnAddTabPage)) Return v End Get End Property In the same file, I also found another routine called "" that looks like this: Private Sub OnAddTabPage(ByVal sender As Object, ByVal e As EventArgs) Dim TabPage As esTabPage Dim h As IDesignerHost = DirectCast(GetService(GetType(IDesignerHost)), IDesignerHost) Dim dt As DesignerTransaction Dim c As IComponentChangeService = DirectCast(GetService(GetType(IComponentChangeService)), IComponentChangeService) 'Add a new button to the collection dt = h.CreateTransaction("Add View Page") TabPage = DirectCast(h.CreateComponent(GetType(esTabPage)), esTabPage) TabPage.Dock = DockStyle.Fill c.OnComponentChanging(MyControl, Nothing) Dim indx As Integer = MyControl.TabPages.Add(TabPage) 'button.Index = indx 'MyControl.AddTabButton(button) c.OnComponentChanged(MyControl, Nothing, Nothing, Nothing) dt.Commit() End Sub First, you might want to make sure the text matches on both. One has the ampersand (&) and one does not. Next, you should look into creating a "&Remove View Page" option, so you can remove items at design time as well. Is that what you are trying to accomplish?

I still don't see a reference for "esFramework.WinForms.UI" reference. Well done code, for VB. :) So, what exactly am I looking for? I can get the form to load up, even with the missing reference. It comes up with a form and three (3) custom tabs in a custom tab control. I can click on a tab to select it, and click on a tab's "custom close" button to remove it. How do I duplicate the bug you are experiencing? What serialize routine is not working? (i.e. Form Name and Method Name ...maybe even line number of the creature that does not work)

Missing something for us: Imports esFramework.WinForms.UI It looks like that line is defined for all of your Tab Control pages. What is it supposed to do?