- Strength to Increase Rep
- +8
- Strength to Decrease Rep
- -2
- Upvotes Received
- 14
- Posts with Upvotes
- 14
- Upvoting Members
- 10
- Downvotes Received
- 3
- Posts with Downvotes
- 3
- Downvoting Members
- 3
IT Manager
- PC Specs
- IT Manager & Programmer
102 Posted Topics
 | you can try the below DgvStock.DataSource = dt dt.AsEnumerable().Where(Function(r) r.Field(Of Integer)("qty") =0).ToList().ForEach(sub(x) x.Delete())  |
 | You can embed Excel and Word inside vb/c# form. I also suffered alot to get a working a code where I found alot of posts says that web browser can embed excel but that did not work with me Here is my way Add a Form, Button, Panel This will … |
| | There could be some security restriction if you install the access database in `c:\program file\your_folder` or `c:\program file (x86)\your_folder` . If you do, try to to give full access to the folder where your data reside by right click on the folder and press properties >> security tab. |
| | Do this test when you save. msgbox(AccessonbookTableAdapter.Adapter.UpdateCommand.CommandText) Is it empty?  |
| | You are using 2 Tables, reading the row of the first table, then reading all the rows of second table, but you are not using any value from any row in any table In your IF CONDITION you have (IF TEXTBOX.TEXT = STRING), the table rows loop is useless if … |
| | You can use the dataset to hold your table, then dataadapter will handle your table changes and compare the data since the time you load the row from table and when you update the row to check if any other user changed during the time you load the row (that …  |
| | your query will not return the columns name "locid,locname,locadd", it will return 1 column as you put in the query your only column is MAX(locid), and since you didnot specify the a name by using `MAX(locid) as FieldName`, its hard to tell what will be the column name. You are … |
 | Does the information in the Listbox (retreived by SQL Query) is using the same table shown in picture? or there is 2 (table and query)? |
| | Hi I have a dataset created programatically and I want to use this dataset to bind it to Microsoft ReportViewer. I tried the Microsoft ReportViewer with DataSet created at design time and it works well. I have searched a lot and this is the best thing I can find but … |
| | [QUOTE]sqlda.SelectCommand = sqlcmd -- the error is pointing here[/QUOTE] How did you declared sqlda and salcmd? there should be in your declaration Dim sqlda as [B]New[/B] ...... and Dim sqlcmd as [B]New[/B] .... |
| | I know this way which let you choose the char you want to allow to be written in the textbox [CODE=vb.net] 'Textbox KeyPress ' Allow number 0-9 plus backspace, Del + Home + End will be accepted also Dim ValidInputChar = "0123456789." + vbBack If not ValidInputChar.Contains(e.KeyChar) then e.KeyChar=Nothing End … |
| | I clear the table, fill the table and let the bindingsource and binding unchanged, like that [CODE]' Clear the grid mydataset.Tables("payments").Clear ' Fill the grid myDA.Fill(mydataset, "payments") [/CODE] |
| | you can do it like that [CODE]Public Class myclasss Property one As Double Property two As Double Sub test1 one = 12 two = 10 End Sub Sub test2 Dim three As Double = one Dim four As Double = two End Sub End Class[/CODE] |
| | Try this Remove the msgbox() put this line instead [CODE]if cmbAssocID.SelectedValue Is Nothing then Exit Sub[/CODE] |
| | This is really for Beginner like you and me :) [url]http://www.homeandlearn.co.uk/NET/vbNet.html[/url]  |
| | [QUOTE=nokomoli;871168]Hi guys, i am facing problem when i need to create an excel file and insert some data inside. Can anyone help me? i am using vs 2005 and excel 2003.[/QUOTE] Here the way to do it, and you have to explore by your self. [CODE=vb.net]Dim _Ex = New Excel.Application … |
| | Well, Any thing can be done by Foxpro can be done in vb.net also Try this code [code=vbnet] Dim oAccess As Object 'Create Access Database oAccess = CreateObject("Access.Application") oAccess.NewCurrentdatabase("c:\myaccess.mdb") 'Create Table Dim tdf As New DAO.TableDef Dim fld As New DAO.Field Dim db As Object db = oAccess.CurrentDb tdf = … |
| | [code=vb] Dim oWSH Dim cmdDOS As String Set oWSH = CreateObject("WScript.Shell") cmdDOS = "cmd.exe /c " cmdDOS = cmdDOS & "DIR *.*" oWSH.Run cmdDOS, 1 'Change the 1 to 0 if you don't want to see the dos window [/code] |
| | [QUOTE=adatapost;1123991][b]>How insert , Edit and update data in datagrid?[/b] For database operations use ADO.NET data provider classes.[/QUOTE] Is that an answer :P, I thought you will post tutorial video from 5 parts :icon_lol: Just wonaa say Hi to you. :) |
| | I can think of 2 function that could able to help you. #1 Printing by IE #2 Print Any kind of File ' #1 Print By IE [CODE=vbnet] Dim oIE Dim FileName FileName = "c:\myfile.txt" ' or .html or .xml depending on where you stored the data you want to … |
| | Since you are filling statementResult, and updating rows in statementResult and then you are using for each row loop for the same statementResult, why don't you update the datatable? SQLDataAdapter.Update(statementResult) |
| | Hi, Is there a way to comment multiple line of code in vb.net at once? means not inserting ' in front of each line in case i want to comment 20 lines that will be tedious job? TIA Samir Ibrahim  |
| | I believe that you had used SQLClient() and you should use [B]SqlServerCe.SqlCeConnection[/B] Try that. |
| | [QUOTE=vb5prgrmr;867085]Correct me if I am wrong maheshsayani or anyone else, but using a command object used that way will not return a recorset....[/QUOTE] I am sure you know that the result of command.execute is record set. so may be explain your question more? As I did not understand the PO … |
| | There is a lot of useful tutorial, I found this, I suggest you study it, and ask question about problem that my occurs to you. 1- [URL="http://www.codeguru.com/vb/gen/vb_database/adonet/article.php/c15031/"]A Basic ADO.NET Tutorial in Visual Basic.NET[/URL] 2- [URL="http://www.codeguru.com/vb/gen/vb_database/adonet/article.php/c15033/"]A Basic VB.NET ADO.NET Tutorial: Adding, Deleting, and Updating[/URL] Don't forget to download the example. |
 | I like the current design although i am not an old user, I begin using Daniweb as my programming forum since 1 years only, since I was vfp programmer. The design is good to the eyes (my eyes at least) and the navigation is simple. I liked the new rating … |
| | Not sure if it is the right way but - I read dll created by .net does not need to be registered. - if regsvr32 did not work try regasm [url]http://msdn.microsoft.com/en-us/library/tzat5yw6%28VS.71%29.aspx[/url] |
| | [QUOTE] Any insight into how I can locate a programs path would be immensely helpful.[/QUOTE] [URL="http://samir-ibrahim.spaces.live.com/blog/cns!C20FEEA5B0493048!166.entry?&_c02_vws=1"]Get Add Remove Programs List[/URL] |
| | Since no one jumps in, let me ask you [QUOTE=krajad;1004818]Hi all, Got a real pain of a problem. Im using vb.net to write a dll for third party software (PreS) that has no COM interface but allows functionality to call DLL's. [/QUOTE] do you mean that the dll you are … |
| | [QUOTE]I want to learn VB or VB.net and want to use for my website (ASP.net)[/QUOTE] I would say learn asp.net which is 70% of it vb.net I would add my approval to what Vineeth K has said. in my opinion, Vb.Net is nothing more than "vb6 + Powerful IDE + … |
| | Hi I am unable to list the threads that I solve any more. Can someone show me where you hide this button :) |
 | 1- You had to add this line in top of the form Imports System.Management 2- Add refrence for System.Management |
| | [QUOTE=wallance;1000334] Anyone else done this before? [/QUOTE] I did not work in excel plug-in or know how it works but you can use this to hide the sheet [CODE=vb.net] Imports Excel = Microsoft.Office.Interop.Excel Dim ex As new Excel.Application Dim wb As Excel.Workbook Dim ws As Excel.Worksheet wb = ex.Workbooks.Open("c:\test.xls") ex.Visible … |
| | > After that it'll fire the DataAdapter.Update() method. > `ShugahDA.Update(shugahCustomerDS)` Are you using Binding source? > `this.oleDbUpdateCommand1.CommandText = "UPDATE Customer\r\nSET CustName = ?\r\nWHERE (CustID = ?)" + "";` > `this.ShugahDA.UpdateCommand = this.oleDbUpdateCommand1;` That is not valid commandText, no `\r\n` should exist it should be this.oleDbUpdateCommand1.CommandText = "UPDATE Customer SET CustName …  |
| | I am creating a form that will filter datagridview while typing in a textbox. I came through this error and I would like to know why is occur. [CODE=vb.net] Dim dt As DataTable = Ds_Pos.Employees Dim dv As New DataView(dt) 'findcrit is declared as string public and it contain a … |
| | Use the "New" Keyword Dim frm As New TestInterop.InteropForm1 frm.Show |
| | |
| | [CODE=vb.net]Dim ServerName = "pc_name" Dim AdminUserName = "Administrator" Dim DomainName = "domain_name" Dim AdminPassword = "password" ' Initialize WMI Dim objSWbemLocator As New WbemScripting.SWbemLocator ' Connect to remote PC Dim objSWbemServices = objSWbemLocator.ConnectServer _ (ServerName, "root\cimv2", _ AdminUserName, AdminPassword, _ "MS_409", "ntlmdomain:" + DomainName) Dim Drive,Path,FileName,Ext as String Drive = … |
| | Hi -I have a form where IsMdiContainer = True -I add Split contaner which has 2 panel vertically (panel1 and panel2) -In Panel1 I have buttons where every button should display a form in panel2 I want to display a form in the center of panel2 I had tried the … |
| | What type of movie info you are searching exactly? since you decide to search for movie name why don't you check [url]www.imdb.com[/url] which will give you only movie name to look at despite wikipedia which will give a long list of non movie name. |
| | You can try this (not tested deeply) [CODE=vb.net] Dim SearchIn = Me.TextBox1.Text Dim sb As StringBuilder = New StringBuilder(SearchIn) Me.TextBox1.Text = sb.Replace(vbCrLf + vbCrLf, vbCrLf).ToString [/CODE] |
| | I begin recently large excel automation & manipulation project. and I have vs2008 and office 2007 First, I note that when I use [ICODE]HDR=YES[/ICODE] in the connection string, it ask for ISAM driver so I omit it and my connection string became like this. [ICODE]Dim _xls_loc = "c:\test.xls" Dim _xls_cnn_str … |
| | I had read somewhere that either MySQl or ODBC does not accept named parameter. Let update query be: [CODE=vb.net]Dim cmd As New OdbcCommand("insert into table2(name) values (?)", con) cmd.Parameters.AddWithValue("?", TextBox1.Text) 'PS: I also try it with putting only ? in the insert sql and put a name in the AddWithValue … |
| | As Scott told you, you have to refill the DataSet, but there is another solution also. in case you are using Dataset, I suggest create the the variable that will hold the DataSet as public in a Modlue Add a module to your project, in the module declare the variable … |
| | What do you mean by "its worked for local machine."? You installed Sql server locally on a macine and your code works? how the client suppose to connect (also locally or remotely)? Check if you change the password for the administrator. |
| | I agree with sknake that you can use MSSQL 2005/2008 Express Edition as a server and multiple clients/user can connect to it. You have to take into consideration that in express edition the DB size limit is 4GB and you cannot use it as publisher for replication. For more info. … |
| | In what Line it give this error? Check if you declare the variable for DataReader twice (once as public and once a local in another place) |
| | |
| | [QUOTE=BlkR;957341]Hi guys, Currently I am updating a listview with data in it via clicking on the selected row and displaying that row data onto textboxes and then updating it. What the data has is ID number follow name and QTY. What I want to add to this function is to … |
| | [QUOTE=realone;954610]Pls see my code.Nothing is displaying in the grid [code]Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim connString As String = "Provider=SQLOLEDB;Data Source=MSALAMEEN;uid=sa;pwd=Sa1;Initial Catalog=Biometric" Dim myConnection As OleDbConnection = New OleDbConnection myConnection.ConnectionString = connString Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select ID from bdata", myConnection) … |
The End.