4,457 Topics
 | |
| | I have a problem with retrieving data from access databse. I make the connection and retrieve the data no problem. But when the data changes from another use of the database, I cannot get the new changed data without reloading the complete programme. Even repeating the load functions does not … |
 | I'm trying to read and return info from an SQL database. To ensure you have the details, here's the basic info: The database is called "DataDesignSolution" The table is called "INVENTORY" I'm trying to read the columns "INV-PART-NUMBER" and "INV-DESCRIPTION". I've written the following code hoping to SEARCH through the … |
| | here is may code the error is .ExecuteNonQuery() thx for helping Imports System.Data.OleDb Public Class registration Private Sub registration_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim connectionstring As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|datadirectory|\db1.accdb; persist security info = false" conn.ConnectionString = connectionstring If conn.State = ConnectionState.Closed Then MsgBox("open") Else …  |
| | I am struggling to create a Windows virtual display driver. ***What I want***: A driver that I can register as a service, so that I can add a virtual mointor to a windows computer when my program starts, i.e. the computer shows that there are two monitors attached, but there … |
| | I know that there are plenty of open source implemenations of AVL trees out there but I was wondering if it is possible to have a AVL that has repeat entries. I want to use one so I can search records by various fields. Eg I would have one for … |
| | Greetings, My name is Micah, I live in the US and I am a recent graduate in the field of Computer Science. I have experience in C++, C# and Java but only basic console programs and minor OOP. I have a little database administration experience. I currently work in the …  |
 | Hello Guys .. I want to understant how to share my Database to the other Computer USing IP address.. Anyone can show me the code for connection.. This is my Code, acd.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\POS.mdb;Persist Security Info=False" acd.CursorLocation = adUseClient where can i put the ip in …  |
| | Hi Guys... Putting together a Tiny little app which shows VPN Details for use 'In-House' but for some strange reason my DataSet won't fill? Can anyone spot the mistake? :S private void Form1_Load(object sender, EventArgs e) { //XML Load of Document. This loads the XML Document and the value of … |
| | Basically, I am wanting to get the last userID which is submitted when the user enters their details and clicks the submit button. I have searched the internet and have made changes but still don't understand where i'm going wrong. I used the MAX statement to show the last user …  |
| | There used to be an open source initiative called sla2pdf which used a python script to convert Scribus sla files to pdf. Unfortunately downloading the programs from https://code.google.com/p/sla2pdf/ is no longer possible. Is there anyone who knows where to find the programs and preferably some documentation ? Many thanks, P |
| | This code creates XML File Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim connetionString As String Dim connection As SqlConnection Dim adapter As SqlDataAdapter Dim ds As New DataSet Dim sql As String connetionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Danial\documents\visual studio 2010\Projects\ESI_PF_Payroll_V1\ESI_PF_Payroll_V1\Pay.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" connection = New … |
 | I'm trying to populate a dataset from an excel sheet but I keep getting a "could not find installable ISAM" error. (In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.) on the adapter.Fill line. Already tried changing …  |
 | I have a code here which will add the data in the system and also if it find a data that exist in the system a message box will appear if the user want to overwrite the data. here is the code Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source='" & … |
| | I am having an issue implementing the Breadth First Search, Im trying to find the shortest distance between the source city and the destination city. Here is what I have so far, Im stuck and dont know what to do about this issue. #include <iostream> #include <string> #include <fstream> #include … |
 | help me i want get data from combobox into single datagridview forecasting i have 3 table table 1 = Jenis with 3 column = IDPemakaian,JenisData, JenisPelanggan table 2 = Periode with 6 column = Nomor, IDPemakaian, JenisData, Periode, Tahun, Jumlah table 3 = Pelanggan with 6 column = Nomor, IDPemakaian, … |
| | I need to input a name in the JMenuItem(employee name) using JOptionPane, I used this statement (JOptionPane.showInputDialog(frame, "Enter Employee Name");) and I try using a string variable but nothings happen. import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.awt.FlowLayout; import java.text.MessageFormat; import javax.swing.table.AbstractTableModel; public class Cs extends JFrame implements ActionListener { …  |
 | I am having trouble with my login and receive this warning 'noOfRows = da.Fill(ds, "tblCustomers");' No value given for one or more required parameters. I want My Login to search my database for the correct pin and account number but my program doesnt seem to work. My code for form1 …  |
| | CODE: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Danial\documents\visual studio 2010\Projects\ESI_PF_Payroll_V1\ESI_PF_Payroll_V1\Pay.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True") Dim adaptor As New SqlDataAdapter Dim dataset As New DataSet con.Open() con.Close() con.Open() cmd = New SqlCommand(str, con) cmd.Connection = con cmd.CommandText = "SELECT Firstname FROM … |
| | Dim conn As New OleDb.OleDbConnection Dim ds As New DataSet Dim dt As New OleDb.OleDbDataAdapter conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\admin\Documents\Visual Studio 2010\Projects\office software\office software\bin\Debug\Office1.accdb;Persist Security Info=False; " Try cmd.Connection = conn conn.Open() cmd.CommandText = "insert into Office Values('" & CInt(TBID.Text) & "','" & TBSupplierName.Text & "', " & TBProductName.Text & "," …  |
| | Hello guys. I'm getting an error as follows: Error I get on the browser:- type Exception report message: descriptionThe server encountered an internal error () that prevented it from fulfilling this request. exception: org.apache.jasper.JasperException: PWC6033: Error in Javac compilation for JSP PWC6199: Generated servlet error: string:///GuestBookView_jsp.java:8: cannot find symbol symbol … |
 | Hi all, can somebody please let me know where I can find a good guide on how to use and especially what's included and what you can accomplish with Open CMS (I believe it's an open source content management system, probably a bit like wordpress)? ALso, if anybody has used … |
 | Hello guys, I'm working on my code vb.net to save data into access database. I'm kinda lost right now. Couldn't find the solution to the error. it highlight on dbcommand.ExecuteNonQuery() as state as the title problem. Here's my code. Appreaciate the help. ` Imports System.Data.OleDb Imports System.String Imports System.Windows.Forms Imports … |
| | Hi i wonder how can i delete my data using access as my database? for example i want to delete Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source='" & ConAccessDatabase & "';") Dim cmd As OleDbCommand cmd = New OleDb.OleDbCommand("delete * from [" & EBU2DB_LOB & "] where Brand ='" & … |
| | Hello, Here is the scenario : I have the follwoing sales return from in my software:  In the from I have tow listview control, the left is Listview and the right is Listview1. I have the following code in procedure : Dim xsprice As String Dim xsprice1 As … |
| | hi frenz please i installed vmware workstation 6.5.0 so that i could use it to run windowserver 2008 amd64 (ISO) image and it prompting this error(windows cannot open the requierd file D:\source\installa.wim. the file may be corrupt or missing. make sure all files required for installation are available, and restart … |
| | Hi, Here is the code I’m trying to execute using MS Access database to return a dataset. And i get the error "No value given for one or more required parameters". Public Class Main_Form Dim conn As New OleDb.OleDbConnection Private Sub btnReset_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles … |
 | So I've FINALLY gotten my code to work but unfortunately my code's sooo messed up that its displaying something else! As you can see in the picture below, the Flex Grid is displaying the data of "Service" http://i213.photobucket.com/albums/cc228/rose_408/receiptform_zps1a66f838.png http://i213.photobucket.com/albums/cc228/rose_408/service_zps5e886a12.png When its actually supposed to show the data of "Receipt Service"! … |
| | Hello i have a problem on connecting my database. i have this kind of code which would get the item in the combobox and use it as my connection Dim ConFunnelLocation As String = "C:\Database\Funnel\" & Form_Funnel_Report.Combo_Funnel_EBU.Text & ".xls" and a table Dim TblFunnelCon As String = Form_Funnel_Report.Combo_Funnel_AM.Text & "$" … |
| | hi Actually i am trying to do a task given by my lead.First in a form i have grid view i have loaded my database content in that and i have a combobox there i have loaded my one column of my table in the combo box .so i have … |
| | Good evening! I'm trying to figure out how to retrieve and display data from MS Access to my project's DataGridView. So far I have the codes to make the options for the CheckedListBox appear. SAMPLE: (Codes for other categories are not included since they're all basically the same) 'view client …  |
| | I've got 2 flex grids in one VB form and I wanna connect both of these Flex Grids to 2 different tables in MS Access. This is how my form looks like: http://i213.photobucket.com/albums/cc228/rose_408/form_zps100c290c.png Here's the code for the service flex grid (FlexService): Private Sub Form_Load() Set conn = New ADODB.Connection … |
| | Hello Every One, When i run my project i get Error "There is no row at position 0", please help. Here is my code: Private Sub PopulateDepartmentHead() 'Fill data in comboBox Dim SqlDataAdapter As OleDbDataAdapter Dim DSet As New DataSet Dim strSelect As String SQLConn.Close() SQLConn.ConnectionString = oFunc.GetConnectionString(sINIFile) 'myConn = … |
 | Hi everybody, this question might be subjective, but I hope you read it thru and help me come to a conclusion. I am an ASP.NET developer. I recently got in contact with a big company that sells products and wants to open an online shopping center. We want to use … |
 | Hello, I am new to Python and have a mission impossible to a beginner, I need to import a specific table from a source code written in LaTex. I tried to start this code in this way : import asciitable from sys import argv def searching_table(table_identifier): with open(fname, "r") as …  |
| | I have two tables Employer Employee Employer Table: I have one field EmployerID (pk Key assigned to it) Employee Table: EmployerID(pk Key assigned to it) IDEmployer(fk key assigned to it,and Allow Nulls:Checked) Now my question is how to relate two tables ,that I will now that who works for who? … |
 | As many of you know, DaniWeb now has an API. It (optionally) uses OAuth 2.0 and it supports both server-side and client-side implementations. The server-side method I have down pat. However, I had to hack together the clientside implementation, and although it works, I'm not sure it's done "correctly". I … |
| | Once I have logged in, the "loggedIn.aspx" page is to display: IP Address: Contact: Date: I am able to get the IP address to display, but really have no clue on how to show both the username and current date. This was a conversion from .asp to c#.net Here is … |
| | Ok, so my form displays an error saying "run time error. could not find installable ISAM." everytime i run it. And its pointing at "conn.Open" part of the code when i run it. heres my code: Dim conn As ADODB.Connection Dim rec As ADODB.Recordset Dim rec1 As ADODB.Recordset Dim rec2 … |
| | hey guys i need help!! i am having problem with add cart...when i puchase and item it comes out this error "Response.Redirect("~/Payment.aspx?total=" + total_price)" bellow are my code. Imports System Imports System.Collections.Generic Imports System.Linq Imports System.Web Imports System.Web.UI Imports System.Web.UI.WebControls Imports System.Data.SqlClient Imports System.Data Partial Public Class Cart Inherits System.Web.UI.Page … |
| | I have a project, I have to do for a university assignment I have to design an operating system “don’t worry I don’t have to do any programming I just have to come up with a proposal and presentation” My question to you all is, are there elements from each …  |
| | Hi how can i pass if my connection is false? i have a code here Dim con As New OleDbConnection Dim dt As New DataTable Dim ds As New DataSet con.ConnectionString = ("provider=Microsoft.Jet.OLEDB.4.0; Data Source='" & ConMonthEndLocation & "';Extended Properties=Excel 8.0;") con.Open() dt.Clear() ds.Tables.Add(dt) With Form_Month_End_Report .ListView_LOB.Columns.Clear() .ListView_LOB.Items.Clear() Dim da …  |
| | Hy all, I'm facing a problem with some data that I need to check and update it's status in my database.I've got a data grid with some info from a table in the database..now for evry entry I send that data to a server server then I get the server … |
| | Hi guys, I've been cracking on with this project for a few days now and had lots of useful pointers to help along the way. I've now hit a little snag where I think I have written the correct update Statement but It seems to error at the last point. …  |
 | We are planning to develop a small embedded product, which will be touch-screen and loaded with few applications which we will develop. Those applications will be contacting a database through wi-fi, and displaying data, and also update the database sometimes. The available flash or ROM memory will be limited, around …  |
| | Hello i'm getting theses to error with my sql code can anyone help me ot at all i'm really lost and can't find much to help where i'm going wrong.Code is below Error 3 The best overloaded method match for 'System.Data.SqlClient.SqlCommandBuilder.SqlCommandBuilder(System.Data.SqlClient.SqlDataAdapter)' has some invalid arguments Error 4 Argument 1: cannot …  |
 | Hi, Please, I am trying to open a details page from the main page item link as follows: Link on the main page: <td><a href=details.php?c_id=<?php echo ".urlencode($c_id)." ?> ><img src="./images/<?php echo $row['cfilename']; ?>" width="90" height="120" alt="" /></a></td> And the details.php page is: <?php $mysqli = new mysqli("localhost", "joseph", " ", … |
| | Hi Guys, The reason for my message was to do with UPDATE and DELETE Statements from within C# when contacting a MDB file. I currently have the INSERT INTO SQL Query working perfectly The Code I used for this is below: else if (radioButton2.Checked == true) { //Creates new versions … |
| | Hi, I seem to be having a problem when attempting to insert a new record into my database through vb.net. From what I can gather, there seems to be an error in the code that the command builder (cBuilder) is creating for me. Here's a copy of the code for … |
| | Hi guys, I am building a program which has 5 forms, 1 mainmenuform with 4 buttons and each of them buttons have a form corrisponding to that button and this program is connected to my access database. The problem I have is I've put all my code into my first … |
| | Public Class LoginForm1 Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click Dim con As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\ahamdi2\Documents\Visual Studio 2008\Projects\sistemPengesanan\sistemPengesanan\admin.mdf;Integrated Security=True;User Instance=True") Dim cmd As New SqlCommand("SELECT * FROM info WHERE username = '" & UsernameTextBox.Text & "' AND [password] = '" & PasswordTextBox.Text & "' ", … |
The End.