aishapot

Hello, I have a listview wherein when I double click a student another form pops up where i edit the student info. When i click on cancel it goes back to the menu and when i click on the reports i want it to be able to [B]refresh[/B] so that …

Sub filllist() strsql = "select * from tabletest" ListView1.Items.Clear() sqlcmd.CommandText = strsql sqlcmd.Connection = sqlconn sqldr = sqlcmd.ExecuteReader() [B] sqlda.SelectCommand = sqlcmd -- the error is pointing here and it say NullReferenceException was handled then Object reference not set to an instance of an object. How do i solve this? …

Can anyone help me on how to create a video embed box? Like on Youtube, when you click on the share button there, there's the embed box.

Does anyone know how to update multiple images?

I have to save 4 different pictures in my database. NSO, GoodMoral, ReportCard & TOR. Here is my code. [CODE] Sub savepic() Dim str As String = "My connection" Dim con As New SqlClient.SqlConnection con.ConnectionString = str Dim ms As New IO.MemoryStream() nsopic.Image.Save(ms, nsopic.Image.RawFormat) goodmoralpic.Image.Save(ms, goodmoralpic.Image.RawFormat) repcardpic.Image.Save(ms, repcardpic.Image.RawFormat) torpic.Image.Save(ms, torpic.Image.RawFormat) …

I was just wondering if I can retrieve two tables from my database to one form? because i'm trying it but it doesn't seem to be working. just the first table i'm trying to retrieve is working.

How can I count the number of items in the listview. Example scenario. Today, I added students say, 20 students. and tomorrow I added another 15 students, i need to have a breakdown on how many students i have been adding per day. Please help me. Thank you guys!

I want to have an alternative way to increment my student no. the current way I'm doing to is in my database, mssql. there's a property called Identity Seed(201200001 - my studentid format) and Identity Increment (1 - no. of increments). The 2012-is the school year, while the 00001- is …

I have a field in my tables where the guidance counselor would have to type in Notes about the student. For example, Alex is in Grade 1 and he have an offense wherein he pushed his classmate, that note will be saved in the database. And then when he turned …

Hello again! So now i can save the picture in the database, now i have to retrieve it. this is my code for the saving of the picture, [CODE]Dim ms As New MemoryStream() studentpic.Image.Save(ms, studentpic.Image.RawFormat) Dim arrImage() As Byte = ms.GetBuffer ms.Close() Dim strFilename As String = lblfilePath.Text.Substring(lblfilePath.Text.LastIndexOf("\")) Dim cnn …

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?

How can I simply format the contact number in vb.net The format that I want is (123)456-78-95 Thank You.

[CODE]Sub retrievepic() Dim conn As New SqlConnection("data source=.\sqlexpress; integrated security=true; attachdbfilename=|datadirectory|\WAIS.mdf; user instance=true;") Dim cmd As New SqlCommand("select ImageData from ImagesStore where ImageId=@ImageId", conn) cmd.Parameters.AddWithValue("@ImageId", 3) Try conn.Open() PictureBox1.Image = Image.FromStream(New IO.MemoryStream(CType(cmd.ExecuteScalar, Byte()))) Catch ex As Exception MsgBox(ex.Message) Finally conn.Close() End Try End Sub [/CODE] This is my code for …

I need to save pictures in my database, my database is MSSQL as of now, my code for getting the picture is this: Private Sub browsepic_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles browsepic.Click With dialogpic 'Open File Dialog sa toolbox .InitialDirectory = "C:\Users\CAMILLE\Pictures" .Filter = "JPG Files|*.jpg|PNG Files|*.png|GIF …

I'm trying to store a data from the checkbox. when i checked on NSO Birth Certificate it has to be stored into my mssql server. here is my code If nso.Checked = True Then strsql = "insert into student info(Requirements) values ('" & nso.Checked & "')" Dim sqlcmd As New …

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click strsql = "delete from student_info where Student_No = " & ctrl & "" Dim sqlcmd As New SqlClient.SqlCommand sqlcmd.CommandText = strsql sqlcmd.Connection = sqlconn sqlcmd.ExecuteNonQuery() MsgBox("Student Deleted") Me.fillclasslist() When I try to delete a student in the list …

on my project, i have a search textbox and also a listview. What I want to do is when a user type in the search textbox, it will automatically list all of possible results in the listview. For example, if I type letter 'a' in the search textbox, it will …