LennieKuah

Hi Friends, I need your help. Please help me. I am trying to retrieve data from Excel Spreadsheet to fill DataGridView for display prior to updating SQL SERVER using DataGridView Row individually. But the coding is not working as this is the first time I done the coding. this code …

[LEFT]Hey guys. i am trying to insert data from a form to a sql database, but this error keeps coming up. [code]Incorrect syntax near ',' [/code] Here is the code. [code] Dim AddSwimmer_comm As New SqlCommand( _ "INSERT INTO [MasterRecords] ([APASCID], [FullName], [Gender], [DOB], [21m], [25m], [50m], [100m], [4x21m], [4x50m]) …

Hi everyone, I have the current situation, I have get done with the datagridview cellvalidation, but, I need that after the validation get's done, to set different columns values on the same datagridview. [code] If Vacaciones_HistoricoDataGridView.Columns(e.ColumnIndex).Name = "DataGridViewTextBoxColumn7" Then If e.FormattedValue.ToString() > Dias_Asueto Then MsgBox("Los dias correspondientes son " & …

Hi Good Guys, I need your help. Please Help me. I am trying to extra CustomerID, CompanyName, from XML File to Update SQL SERVER using xpath function. Being new to XML I don't know how to do it. Please help me with sample coding so that I can learn the …

Hi Good Guys, I encounter another interesting problem due to my lack of C# knowledge. Please Help me. I am trying to use DATAREADER to fill TEXTBOX controls on the FORM and it's not working because this coding generate error message: [COLOR="Red"] sqlDR = sqlCmd.ExecuteReader(); <---- Error [/COLOR] Error message: …

Hi Good Guys, [B][I]I am learning how to use C#Net2008 to develop Window Application. I was a VB.NET2008 developer. I need your help, Please Help me. [/I][/B]I am encountering 2 problem trying to fill LISTBOX with [COLOR="Red"]DATASET[/COLOR] and [COLOR="red"]CATCH [/COLOR]to display error message. In the LISTBOX dropdown list instead of …

Hello DW!, I am in a beginning stage vb user. I need a small help. I need to create a program, if I entered the "product code" in a text box / search box, it wants to display its full details from database, such as Product code, product name, description …

Hello! I have a project to where I am making a pizza order for customers. My forms consist of a form for the pizza quantity and size (the cost is displayed in a lblDisplay.Text). I also have another form which calculates the cost of beverages. I am now on the …

In a textbox i can see when RETURN is pressed , but when i check on the TAB key it does not work Help me Plzzz. [CODE] Dim handler As KeyEventHandler Private Sub Orderinvoer_Load(ByVal sender As System.Object,ByVal e As System.EventArgs) Handles MyBase.Load AddHandler werkorderTB.KeyDown, handler end sub Private Sub werkorder_KeyDown(ByVal …

Hi There, In VB6 I used ADP to confirm record existence by using this script IF ADO.EOF OR ADO.BOF then ado.addnew End if but in VB.NET 2003, How before using SQL String to Insert the record how do I confirm it's existence in the Table to prevent duplication. Please help …

Hi There, I am developing VB.NET 2003 window application having problem with the FORM KEYDOWN event. Problem with cancelling the keydown event when the data check function return FALSE due to duplicate Debtor ID. How to cancel the KeyDown [CODE][B]Private Sub FrmDebtor_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles …

Hi there, VB.Net 2003 Window Application DataGrid Paging. Need your help The users instead of using Vertical ScrollBar in DataGrid1 they requested for NEXT and PREV buttons for paging the display on DataGrid. I have added the NEXT Button and PREV Button but doesn't know how to create the script …

[B]Hullo there,[/B] [B]C#Net 2003 Window Application [/B] I need your help again. I am trying to loop through the DataGrid rows and confirm that FirstColumn which hold Checkbox is TRUE. If it's TRUE, I need to retrieve the Customer FirstName(2nd Column) and LastName (3rd Column) and transfer the data onto …

Hi there, Please help me. I am having problem trying to include Checkbox in 1st Column in DataGrid for all the Rows. Being a newbie and I am struggling doing it. I need your help.

Hi there, Being a newbie to C#Net 2003, I am having problem trying to retrieve data from a specific clicked row on the DataGrid to display the data on the TextBox on the FORM. This is the structure of the DataGird:- Col0 = CustomerId Col1 = First Name Col2 = …

Hi there, When I add a new row into the DataSet, the first time it works good but after the first time I added another row it's not working instead it generate this error message : "Update requires a valid Insertcommand when passed datarow collection with new rows" This is …

Hi there, Being new to Vb.Net 2003, I need help to determine whether to Create new Record or Update an exisitng record in SQL SERVER table. In VB6 I used this logic to do that but in Vb.Net 2003, I am totally lost at it. Please Help me. Thanks. VB6 …

Hi there, I am having problem trying to retrieve the data from ListView the 2nd time round. It works the first time I clicked on the Line Item and when I clicked on another line item it gave me this error message :- [B][I]"Specific argument ws out of the range …

Hi All, Greetings Friends, I am having problem trying to upgrade Microsoft .Net Framework 1.0 to Frame 1.1. I have completed successful installation of Framework 1.1. But when I loaded up Microsoft Dot Net 2003 HELP to confirm, it's not registering Framework 1.1 on it. I just don't know what …

Scenerio. I am extracting Primary key from Listbox to read against the Products Table in Northwind database to populate the textbox controls. This particular column "UnitPrice" is giving me this error message:- " Cast from string "Display" to type "Interger" is not valid". Can someone point me to the right …