samir_ibrahim

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 + …