Begginnerdev

Change the for statement to say: For Each f As File In FTPDownload.ListDirectory Then reference f. The problem is that you are refrenceing a class ***File*** that has not been instantiated.

After a quick google search I found [this](http://www.vbforums.com/showthread.php?541085-Excel-Printing-thru-VBA-Question).

There are quite a few issues with 2000 > 2007, but with 2003 we only had a few missing controls some forms in an MDE application. We lost small stuff like a drop-down calendar and a text box off of another form. [Here](http://allenbrowne.com/Access2007.html) is a decent article you can read …

[Here](http://www.developerfusion.com/article/3441/creating-a-windows-service-in-vbnet/) is a decent article on Windows services. As for as deployement, does 2013 include ClickOnce?

Would something like this work: FormatNumber(CInt(1000 + 2.6 + 3.5)), 2) Just let the framework do the formatting for you.

You could use a ComboBox control with the autocomplete items filled with your names. Then, as the users type into the box, a drop down will appear with the possible names. (Make use of the comobox's SelectedValueChanged event. For example: Private Sub FillComboBox(ByVal dt As DataTable) Try 'Clear the combobox …

My guess would be this statement: .Rows.Add(table.Rows(i)("frmStudentReg.regno"), table.Rows(i)("nursery.rollno"), table.Rows(i)("nursery.nepali(writing)"), table.Rows(i)("nursery.nepali(oral)"), table.Rows(i)("nursery.maths(writing1)"), table.Rows(i)("nursery.maths(oral)"), table.Rows(i)("nursery.maths(writing2)"), table.Rows(i)("nursery.english(writing)"), table.Rows(i)("nursery.english(oral)"), table.Rows(i)("nursery.physical_edu(oral)"), table.Rows(i)("nursery.creative(oral)")) You need to set column values and I don't think the Rows.Add method allows that. Something like this would work: With DataGridView1 Dim dgvr As New DataGridViewRow 'add cells/values DataGridView1.Rows.Add(dgvr) End With

You will need to retreive items from the database and store them in a DataSet/DataTable or read them with a DataReader. Are you wanting a local version of your data? (For editing and pushing back out to the db) Or are you wanting the application to read data only?

The code: Dim rowcnt As Integer = (dtOrder.Rows.Count - 1) For x = 0 To rowcnt If IsNumeric((dtOrder.Rows(x)(3).ToString)) Then val = CInt(dtOrder.Rows(x)(3).ToString) With fractColumn .ColumnName = "xttl" .Expression = ((dlgNewTop.Dec2Frac(val, 2))) End With End If Next With dtOrder.Columns .Add(fractColumn) End With Will only add the last because that is the …

Your select statement for your datagridview can be edited to order by the column chosen. For example: "SELECT * FROM Table ORDER BY Column4 ASC" Will sort data by column for ascending. For decending just do the opposite: "SELECT * FROM Table ORDER BY Column4 DESC"

The webpage that you see is a click once deployment page giving you a summary of the application and an install button correct? You can turn the page off in the My Project > Deployement > Options > Deployement dialog. See if this fixes your problem.

You will need to look at a reporting solution. Two major solutions exist. [Microsoft Report Viewer](http://msdn.microsoft.com/en-us/library/ms252073.aspx) [Crystal Reports](http://aspalliance.com/215_Creating_Professional_Reports_using_Crystal_Report_for_Visual_StudioNET_Part_1.1)

Copy the files to a directory in the solution of your project. Then include the directory with the publish. When looking at the solution explorer, add a folder. Once you have added and named the folder, right click and click add existing item. Set the filter of the dialog to …

You will have to program on the ComboBox's SelectedIndexChanged event and fire the code then. You will have to retreive the value from the database and post it to the textbox. For example: Private Sub combItems_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles combItems.SelectedIndexChanged Try Query = "SELECT itemStock …

VB.NET doesnt support transparent labels. You will have to draw the text over it using the Graphics.DrawString or some kind of custom control. Microsoft decided that we didn't need this function. >( You can use transparent panels and such, but when you set them to transparent - the label will …

Not quite sure what you plan to acheive with that syntax. If you are trying to format the output, read [this](http://www.codingunit.com/printf-format-specifiers-format-conversions-and-formatted-output).

I think this statement would be the culprit: .numberofstudents = Group.Count() But my LINQ is shoddy at best. :(

Something like: "SELECT MAX(ColumnName) As MaxValue From Table " Then pass that query to a datatable and pull into a textbox Dim da As New SQLDataAdapter("SELECT MAX(ColumnName) As MaxValue From Table ",MySQLConnection) Dim ds As New DataSet da.fill(ds,"Max") If Not IsNothing(ds.Tables("Max")) And ds.Tables("Max").Rows.Count > 0 Then TextBox1.Text = ds.Tables("Max").Rows(0)("MaxValue") End …

You need to look into using forms authentication in asp.net Please read [this](http://msdn.microsoft.com/en-us/library/7t6b43z4(v=vs.100).aspx).

Have you checked the code snipped posted [here](http://social.msdn.microsoft.com/Forums/vstudio/en-US/43f6b81f-4cb7-4e8e-bd29-e3645f200734/highlight-text-inside-a-datagridview-cell)?

You are wanting to save a .csv file or a MySQL proprietary file?

I have had problems with this using SSRS (SQL Server Reporting Services) and it turns out that it is a process that terminates and must be restarted to pull a report. The workaround that I had found is [here](http://www.pawlowski.cz/2011/07/solving-issue-long-starting-report-ssrs-2008/). The first pull starts the process/freezes , and the second pull …

What error is the installation giving you?

127.0.0.1 is not a valid IP address to communicate over the network. It is the home address. You will need the IP address of your host terminal, as pritaeas said. With the satement of you working on this project at a university brings up a few questions. Does the univerisity …

If you know the type of data that is being stored in the datagridviews, just simply declare that type of list: 'If Data is a String Dim myList As New List(Of String) 'If Data is a integer Dim myList As New List(Of Integer) mylist.Add(DataGridView2.Rows(z).Cells(0).Value) mylist.Add(DataGridView1.Rows(i).Cells(0).Value) mylist.Add(DataGridView1.Rows(i).Cells(1).Value) Then enumerate through the …

After a quck google search, I assume that you mean HP Quick Test Professional. I have found [an article](https://groups.google.com/forum/#!topic/mercuryqtp/d1XXaQmTjy8) saying that integration with vb.net is impossible and you should be using vbscript. All of this is severely lacking context. What do you mean by QTP and do you have any …

First off, you never said how you store the student count. We can't see where this is being stored, so we can't fully help you with your desired format. Second off, the String.Format statement is incorrect, you would be passing in PaperNo 5 and would get: 5 : 5 As …

When you say sliding the panel, do you mean in the parent control or the scroll bar of the panel?

You should look at using the ComboBox_SelectedIndexChanged event. This can be handled like so: Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles ComboBox1.SelectedIndexChanged Try TextBox1.Text = ComboBox1.SelectedValue Catch ex As Exception MsgBox(ex.ToString) End Try End Sub

You can try wrapping the columns in IIFs. For example: IFF(IsNothing(DataGridView2.Rows(i).Cells(2).Value.ToString) Or DataGridView2.Rows(i).Cells(2).Value.ToString = String.Empty, String.Empty, DataGridView2.Rows(i).Cells(2).Value.ToString) The IIF qualifies the statement then pulls the value given. In this example would be the equivilent of: IF IsNothing(DataGridView2.Rows(i).Cells(2).Value.ToString)) Or DataGridView2.Rows(i).Cells(2).Value.ToString = String.Empty Then row2 = String.Empty Else row2 = DataGridView2.Rows(i).Cells(2).Value.ToString End …

Are both clients connected to the same database, or are you both working on two different applications?

Simply place the following code in your clear or insert command. MyCheckBox.Checked = False But note that this will fire any CheckChanged event handler for that CheckBox.

You can check per column basis: For example: Dim Found As Boolean For Each r As DataRow In dt.Rows Found = False For i = 0 To dt.Columns.Count If r(i) = "ThisValue" Then Found = True Exit For End If Next If Found Then Exit For Next Also, I have …

It would be easier to do a SELECT with an inner join. Something like: "SELECT SEGDATA.AdminNo, Paperslist.PaperNo InnerJoin SEGDATA on PapersList.Module1 = SEGDATA.ModuleCode" But my SQL is a little lacking I hope this points you in the right direction.

I think you can access the Application directory using: My.Computer.FileSystem.SpecialDirectories Then use the directory you wish. If you are wanting to work with the current user just simply use: My.Computer.FileSystem.SpecialDirectories.CurrentUserApplicationData To save alot of coding.

A quick google search returned a few things. One being permissions the other being [this](http://stackoverflow.com/questions/3985314/msmq-access-to-message-queuing-system-is-denied-when-trying-to-receive-message).

Can you please post the code being used to connect to the database? Also, you might want to read [this](http://stackoverflow.com/questions/14562587/microsoft-ace-oledb-12-0-provider-can-no-longer-open-mdb-under-windows-8) article.

You can parse the last six characters of the string to get the last six. Just parse the selected item, or parse when the item is being inserted into the combobox. For example: Private Sub LoadData(ByVal lstString As List(Of String)) Try For Each s As String In lstString ComboBox1.Items.Add(s) 'You …

Have you verified the logic of the select? I see (1) AND (2) OR (3) OR (4) If this statement gets qualified, you can have a maximum of 3 outcomes. (1) and (2) are true (3) is true (4) is true Is this correct?

Hello my fellow Daniwebies! I have a curious, possibly unique, and odd problem for everyone! We support an ASP.NET application which is using VB.NET for code behind. We use LINQ to SQL and classed object for the data retreival. I have an object called...myObject which is being deleted: Public Shared …

Are you wanting to remove the row from the created table, or from the atomic tables?

If you are storing large amounts of data, which it looks like you are, I suggest a database backend. A table for students, classes and a junction table: tblClasses ID | Class | Comments Auto | VarChar | VarChar tblStudents ID | Name | StudentNumber Auto | VarChar | VarChar …

You will have to set the name of the button, or loop through the forms controls: NT.Name="MyButton1" Or For Each m As MyButton in Me.Controls m.Dispose 'NOTE: m MUST INHERIT CONTROL Next

One question would be - What differs from test data to live data. Does the data format change, or just values?

Some questions before code can be written: Do both gridviews contain the same row count for data? Have you tried reading in from both csv files, concatinating them together for the third gridview? Is it possible that you are placing more controls on the form than are needed? (See question …

Using Dispose() waits for the [garbage collector](http://msdn.microsoft.com/en-us/library/ms973837.aspx) service. You can simply write: cmd = Nothing And the object will be destroyed.

Don't forget to [mark as solved!](http://stackoverflow.com/questions/17484113/obsolete-attribute-ndepend)

There is a (very) old forum post on this exact topic. The (possible) solution can be found [here.](http://www.daniweb.com/software-development/vbnet/threads/59970/how-to-make-app-always-on-top)