• Member Avatar
    Miurei

    Created How to export listview to Excel Spreadsheet?

    i have listview named : listview1 and a button to export listview data presented. all i want is to export that data to an excel probably to edit or print …
  • Member Avatar
    Miurei

    Began Watching How to export listview to Excel Spreadsheet?

    i have listview named : listview1 and a button to export listview data presented. all i want is to export that data to an excel probably to edit or print …
  • Member Avatar
    Miurei

    Revoked Solved Status for Login with different usertype Admin and Normal User

    I need help about this, I've been working for this a quiet while... I want to log-in using one login form for both admin and normal user but after log …
  • Member Avatar
    Miurei

    Created How to pass Listview contents to a crystal report for printing?

    How to pass Listview contents to a crystal report for printing purposes using VB net..? i got 1 listview which shows the results of some queries. Now my problem is …
  • Member Avatar
    Miurei

    Began Watching How to pass Listview contents to a crystal report for printing?

    How to pass Listview contents to a crystal report for printing purposes using VB net..? i got 1 listview which shows the results of some queries. Now my problem is …
  • Member Avatar
    Miurei

    Gave Reputation to hericles in Login with different usertype Admin and Normal User

    You only set the sql statement once but at line 17 you're using it as part of an IF statement: `If sql = "SELECT Usertype FROM [db_dole].[dbo].[tbl_user] WHERE Usertype = …
  • Member Avatar
    Miurei

    Marked Solved Status for Login with different usertype Admin and Normal User

    I need help about this, I've been working for this a quiet while... I want to log-in using one login form for both admin and normal user but after log …
  • Member Avatar
    Miurei

    Replied To a Post in Login with different usertype Admin and Normal User

    Thanks for all who tried to answer my query... anyway I solved it already... thanks again. hope you guys will continue to help those individuals out there needing your brilliant …
  • Member Avatar
    Miurei

    Gave Reputation to rproffitt in Login with different usertype Admin and Normal User

    Just a thought. I don't .show the form until I've hidden or shown the objects I want to hide or show. Line 26 would be after the .hide .show items …
  • Member Avatar
    Miurei

    Replied To a Post in Login with different usertype Admin and Normal User

    Here I reprogram it Private Sub ok_Click(sender As Object, e As EventArgs) Handles ok.Click Dim conn As New SqlConnection If TextBox1.Text = "" Or TextBox2.Text = "" Then MessageBox.Show("Please fill …
  • Member Avatar
    Miurei

    Created Login with different usertype Admin and Normal User

    I need help about this, I've been working for this a quiet while... I want to log-in using one login form for both admin and normal user but after log …
  • Member Avatar
    Miurei

    Began Watching Login with different usertype Admin and Normal User

    I need help about this, I've been working for this a quiet while... I want to log-in using one login form for both admin and normal user but after log …
  • Member Avatar
    Miurei

    Began Watching i need to get latest created record based on latest created date

    i need to get record based on maximum created date any body help me date in mysql database structure is varchar. date is 150921141206 any body help me
  • Member Avatar
    Miurei

    Replied To a Post in i need to get latest created record based on latest created date

    here is a sample code: Private Sub mainform_Load(sender As Object, e As EventArgs) Handles MyBase.Load cmd.Connection = conn cmd.CommandText = "SELECT MAX(ColumnName) FROM [db_Name].[dbo].[tbl_Name]" conn.Open() dr = cmd.ExecuteReader() Do While …
  • Member Avatar
    Miurei

    Began Watching Converting VB5 Application

    Hello, I have for a number of years supported a VB5 application which controls customers equipment. We are now going to do some major changes to software because hardware is …
  • Member Avatar
    Miurei

    Replied To a Post in Converting VB5 Application

    Rewriting in newer version, using code from old version and upgrade some feature is better than converting the old system to the latest.
  • Member Avatar
    Miurei

    Began Watching insert into database from vb form

    i want to save data entered into my form into the database but it is telling "column name or number of supplied values does not match table definition" here is …
  • Member Avatar
    Miurei

    Replied To a Post in insert into database from vb form

    Kindly check if the datatype length on your database can handle the number of characters you entered on your textboxes... To avoid such error, go to your textbox properties and …
  • Member Avatar
    Miurei

    Began Watching how to code the edit and delete button if i use this code in my add button.

    i used pcode as my primary key which has a datatype of short text Private Sub RefreshData() If Not conn.state = ConnectionState.Open Then conn.Open() End If Dim DATA1 As New …
  • Member Avatar
    Miurei

    Replied To a Post in how to code the edit and delete button if i use this code in my add button.

    hope this helps, i used to put this on my edit button BUT mine is listview and your is datagrid..... Private Sub edit_Click(sender As Object, e As EventArgs) Handles edit.Click …
  • Member Avatar
    Miurei

    Began Watching Search data with different requirements

    Hi, everyone! I want to make search a student's grade. Each student follows the 10 subjects. I want to make a search of students in certain grades. I made 10 …
  • Member Avatar
    Miurei

    Replied To a Post in Search data with different requirements

    I used this code in getting max number of records in my database hope you got an idea with this: Private Sub mainform_Load(sender As Object, e As EventArgs) Handles MyBase.Load …
  • Member Avatar
    Miurei

    Began Watching Recording database value

    Dear all, I have created project database in msaccessdatabase. It contail ![Msaccess.jpg](/attachments/large/4/a91d2278c08f244b439891bcf7c3b36e.jpg "align-center") form layout as shown in image & i have attached code for reference Imports System Public Class …
  • Member Avatar
    Miurei

    Replied To a Post in Recording database value

    Save button codes: Private Sub save_Click(sender As Object, e As EventArgs) Handles save.Click cmd.Connection = conn cmd.CommandText = "INSERT INTO [databasename].[dbo].[tableName] VALUES ('" & TextBox1.Text & "', '" & TextBox2.Text …
  • Member Avatar
    Miurei

    Began Watching How to update database through gridview

    Hi, I have try to insert edit and delete feature in my gridview app. however, the code is not really work. when I click the edit or delete button it …
  • Member Avatar
    Miurei

    Replied To a Post in How to update database through gridview

    Hi, we got same problem but then found no exact answer and so I switched to listview instead of datagridview. I will just show you how I programmed my edit …
  • Member Avatar
    Miurei

    Began Watching FindBy won't return datarow

    Hello. I have a SQL database called bd with a table called dados. I want to get one row from it. Web.config <add connectionString="Data Source=(local);Initial Catalog=bd;Integrated Security=True" name="bd" providerName="System.Data.SqlClient"/> variable …
  • Member Avatar
    Miurei

    Replied To a Post in FindBy won't return datarow

    Hi nosfa, are you trying to view your data in a listview table or in textboxes? You may use queries attached on your searchbox like: Dim sql = "SELECT UName,Password …
  • Member Avatar
    Miurei

    Began Watching adding record to the database using adodc in vb6

    i need help in adding a new record to the database using adodc in vb6.. i've a command button named add in my form...
  • Member Avatar
    Miurei

    Began Watching User Privledges in VB.NEt

    Hey people hope you are well Could You please help me. I am designing a system which when users login i want the system recoginse who is a admin and …

The End.