Phasma

Hello, I'm very new to using VB.Net so I found it quite difficult to understand other answers that I searched for. Basically, I have an project to develop where a user can create an account, and log in with it. So far I have : Created a database in ms …

Hi Using VB.NET I created an excel sheet with list of items in dropdownlist. Using the below code With xlWorksheet.Range("A2", "A101").Validation .Add(Type:=Microsoft.Office.Interop.Excel.XlDVType.xlValidateList, AlertStyle:=Microsoft.Office.Interop.Excel.XlDVAlertStyle.xlValidAlertStop, Operator:=Microsoft.Office.Interop.Excel.XlFormatConditionOperator.xlBetween, Formula1:=[COLOR="Red"]"Construct,Testing,Review,Look Ahead Meetings,Process Audit,Process Improvement,Project Monitoring and control,Project Planning,Project Setup,Project Team Management,RCA Activities,Re-Estimation,Review,Review-Rework,Senior Management Reviews, Testing,Testing Rework,Training, Work Product Audit"[/COLOR]) End With But i can able …

i have a form with a listbox. the listbox can be edited (things added/deleted) and when the form is closed i would like the items in the listbox to be saved when the red "x" in the top right corner is clicked any ideas?

Below is the code I have been working on in VB.NET What basically happens is that when the user presses the calculate pay button, a message box is supposed to appear with all of the information in it, however the error comes up with: 'InvalidCastException: Conversion from string "Total pay: …

I sence victory been battling the this code for 2 days now. the code i have generated is [CODE] strsql = "delete from cg_security_user_right where user_id= " & TextBox1.Text & " role_id=" & TextBox2.Text & ""[/CODE] it comes up with this error Syntax error (missing operator) in query expression 'user_id= …

Hello i want to have a txt file on my application final .exe the .txt is located at C:\Users\Timhook\Documents\Visual Studio 2008\Projects\WWTBAM \WWTBAM \bin\Debug\hask.txt thats my project bin\Debug folder will it include the this hask.txt file after publishing the application? thanks

I start my project in vb.net backend is sql server i have completed my design now i start my coding but i am confused for connectivity code whether i used dataset or datable which is good? please give me best connection code for retriving,updating and deleting data from database..

I can Insert table from Old_Table_Database to New_Table_Database with this code. [CODE] Dim cmd5 As New OleDbCommand Dim cmd6 As New OleDbCommand cmd6 = New OleDbCommand("select * from " & "Product ", OldConn) Dim dr6 As OleDbDataReader dr6 = cmd6.ExecuteReader For j As Integer = 0 To dr6.FieldCount - 1 …

Hi, I'm not exactly sure if this is the correct question to be asked but I will tell you what I am attempting. I have an ASCII txt file with data in it. It does not have headers. I am looking for a way to convert this data into an …

I have this code [CODE] Dim replace As String = System.DateTime.Now.AddDays(7).ToString("yyyy-MM-dd")[/CODE] What I'm trying to do is [CODE] Dim replace As String = textbox1.text.AddDays(7).ToString("yyyy-MM-dd")[/CODE] is there a way to use that add days from a text or string value already?

Hi, When i run the codes i donot get an error, howveer after clicking INsert i get the Syntax error in Insert Into statement error. I do recieve the COnnected MsgBox which then results in the error My code.. Sub connect() Dim acsconn As OleDbConnection = New OleDbConnection _ ("Provider=Microsoft.jet.oledb.4.0;data …

In my application, i have put a question on form closing if the user wants to save the changes?. But right now, i have just put it in default whether they make changes or not. I thought of prompting it on text change.. but the text automatically changes on load …

Hi I am trying to pass the datatable of a search query to another page and bind it to a listbox. The problem is the the listbox just displays system.data.datarowview and no results. I have listed the code below. Thanks First page SQL and session store: [CODE]Protected Sub btnSearch_Click(sender As …

I would like to retrieve the ID number for that row that was just inserted into the database. [CODE]Dim Enrollment As New Enrollments With Enrollment .Student_ID = CInt(lvwStudents.FocusedItem.Text) .Enrollment_Date = CDate(dtpDate.Text) End With EnrollmentBAL.Save(Enrollment) [/CODE] I have this code to save it from the database, what I want to do …

Hi guys!I'm currently making a database project and I want to update an access database. I connected the database using this sql command 'select*from word' And I tryied to update the database using this code ds.tables('word').rows(0).item(1)=”cat” Dim cb as new oledb.oledbcommandbuilder(da) da.update(ds,”word”) da is a data adapter ds is a …

I have a simple vb.net app and I'm trying to update a one row Access table with data from some textboxes. This is a learning exercise for me as I am coming back from not programming for almost 10 years, and know there are lots of other ways to manage …

hello everyone i just wanna ask some help regarding on how to delete all datas in the data grid view from search result. i have a form which search data in specific date and show result in the datagridview, what i want is that when delete button is clicked all …

i had made project on vb.net i have added snap shot of my project.I had created access database now i want to take date as input from the user & from that day i want to print all records & their total for each column. I had already created a …

Load from database to datagridview [CODE]Call ConnectAccess() Dim da As OleDbDataAdapter = New OleDbDataAdapter("SELECT ProductName,Quantity,UnitPrice,Extention, InvNomer,ProductId, InvDetId " _ + " FROM InvoiceDetail where InvNomer ='" & pbInvNomer & "' ", mConn) Dim ds As DataSet = New DataSet() da.Fill(ds, "InvoiceDetail") DGV.DataSource = ds.DefaultViewManager DGV.DataSource = ds.Tables("InvoiceDetail") Me.DGV.Columns(0).HeaderText = "Product …

hello ! look , for example i have 2 textboxes in my vb form, i want that when i press enter key the focus move from 1st textbox to 2nd textbox , i use this code on my every control to move focus [CODE] if e.keychar = chr(keys.enter) then textbox2.focus …

Hi i have the following code. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New OleDbConnection Dim da As New OleDbDataAdapter Dim ds As New DataSet Dim dsnewrow As DataRow Dim cb As New OleDbCommandBuilder(da) Dim a As String con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\DB.mdb;Jet …

hi everybody! i already know how to save in excel using openfiledialog. but what i want to happen is that when i save another file, i want it to be saved in my existing file but in a different sheet. can you guys help me? this is my code for …

hello im working with vb 2010 and ms access as data base, just newbie.im trying to save the loged out date and time to my access table by selecting from tblloghist wherein my column SystemUserID is equal to my textbox SysID(located at my form) then it will save the timelogedout …

Hello everyone, Please can someone help me to debug this error? It has been giving me a huge headache since last night. Anytime I try to add new record into my database, this error message keeps coming up: "Error: INSERT INTO Customer(Cust_ID, Name, Address, Username, Password) VALUE(?,?,?,?,?,?)". I don't know …

hi In my scenario when i press the "Get Book Details " of the Form1 , it will redirect to the Form2 , in the form load of Form2 a datagridview is filled with values along with the checkbox column and the desired rows of all the columns are selected …

please help with my project here it goes... I want the every text in my label to be different color example label text is Visual the color of V is black and the rest will be red and if I press the key i the letter i will be black...

I have an application that needs to know how many excel rows are in a worksheet before they are imported into my application. at the moment I am asking the end user to enter this into a text box, but would like my application to do this can anyone suggest …

so i have a working ish program now, when i add the record it saves and returns the save message box as it should and is viewable in the database where it saves to, but it is not viewable in the text boxes when looking back at the form until …

I have a datatable - 1 of the columns is a double so i read it like this Dim num As Double = Drow(1) I get an error about late binding here (with option strict on) I have tried converting to a double eg Dim num As Double = convert.toDouble(Drow(1)) …

Hello i want to the textbox that when I start to type in names it should be like this [B]Camille Aisha Cordova[/B] How do I do this?