Hello to all. I am developing software in vb.net for sales invoices. Where i need to import invoice data from excel file to vb.net Grid Data View and then save into access db. I will use db data in future for creating customer invoices. I have code that import excel data into GDV successfully, but i d'nt know how to save data in access db. Access db Name "MyInvoice" and table Name is 'InvoiceData'. Please help me to write correct code. Thank You. Imports System.Data.OleDb Imports System.Data.SqlClient Public Class MainForm Private Sub BtnImpExcelFile_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) …

Member Avatar
+0 forum 0

I have created one table in access with field site,dealer and D_date my data is like as follow site dealer d_date delhi asian 23-10-11 delhi led 24-10-18 so on....... now i want haveing two combobox list of site and dealer in form when i press show button in form i need if todays date is mor then 3 years of d_date then show msg. " out of warranty.... i am using access 207 and vb net basic 2008

Member Avatar
+0 forum 0

Hello. So I had to make this program that: 1. User enters a value (say, ID number) in a textbox, presses search, then the program searches for that particular item on a table and then copies all the row data where that ID number is. 2. Then pastes those copied data on another table in Access, then displays it on a datagrid Thanks. Im new so I haven't made up code yet :(

Member Avatar
+0 forum 0

hello dear experts hello dear user, first of all; many thanks for this great wordpress-plugin. This is just overwhelming. currently i am planning to set up a site: well – We would like to create a dropdown menu that selects jobs from different sites on a WordPress-multisite. Scenario: imagine – when on one site, I can select a site from a dropdown menu and have it populate with that other subsite’s job listings. So there would be a central db where all the jobs are stored ** – i would have three sites:** jobs.mysite.com free-volunteering.mysite.com work-and-travel.mysite.com is this doable – …

Member Avatar
+0 forum 0

in sql server there is a group problem statement: DENSE_RANK() OVER (ORDER BY TABLUONGNV3.HOVATEN) AS STT How to write in sql access issues in groups? I'm not writing well: (Select Count (*) FROM [TABLUONGNV3] as Temp WHERE [Temp].[MANHANVIEN] < [TABLUONGNV3].[MANHANVIEN]) + 1 AS STT SELECT (Select Count (*) FROM [TABLUONGNV3] as Temp WHERE [Temp].[MANHANVIEN] < [TABLUONGNV3].[MANHANVIEN]) + 1 AS STT, TABLUONGNV3.HOVATEN, TABNHANVIEN.IDNV, TABLUONGNV3.MACANV, TABNHANVIENCA.CANV, TABLUONGNV3.N01, TABLUONGNV3.N02, TABLUONGNV3.N03, TABLUONGNV3.N04, TABLUONGNV3.N05, TABLUONGNV3.N06, TABLUONGNV3.N07, TABLUONGNV3.N08, TABLUONGNV3.N09, TABLUONGNV3.N10, TABLUONGNV3.N11, TABLUONGNV3.N12, TABLUONGNV3.N13, TABLUONGNV3.N14, TABLUONGNV3.N15, TABLUONGNV3.N16, TABLUONGNV3.N17, TABLUONGNV3.N18, TABLUONGNV3.N19, TABLUONGNV3.N20, TABLUONGNV3.N21, TABLUONGNV3.N22, TABLUONGNV3.N23, TABLUONGNV3.N24, TABLUONGNV3.N25, TABLUONGNV3.N26, TABLUONGNV3.N27, TABLUONGNV3.N28, TABLUONGNV3.N29, TABLUONGNV3.N30, TABLUONGNV3.N31, TABNHANVIENCA.TIENMOTCA, TABLUONGNV3.TONGLUONG, TABLUONGNV3.PHAT, TABLUONGNV3.TAMUNG, TABLUONGNV3.THUCNHAN, …

Member Avatar
+0 forum 0

I have One Problem in my coding ..I want to upload multiple images in the database in one row with using comma ... for($i=0;$i<count($_FILES['eventpic']['name']);$i++) $pic = $_FILES['eventpic']['name'][$i]; $tmp =$_FILES['eventpic']['tmp_name'][$i]; $location="pics/".$pic; move_uploaded_file($tmp,$location); $q="insert into tbl1(title,tdate,eventpic)values('','','$pic')"; echo $q; through this code i can upload tthe multiple images but not in a single row ....

Member Avatar
+0 forum 0

My data SQL Server is reported this error, How does this error fix you ? SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0x5555aaaa). It occurred during a read of page (1:210768) in database ID 7 at offset 0x00000066ea0000 in file 'G:\Database\MyData.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see …

Member Avatar
+0 forum 0

Hello I am using Crystal report version 11.5.8.826, php version 7.0.10, Apache version 42.4.33 and MySql Version 5.7.14. I have created the sampel rptone.rpt file that contents sample report. I want to load that rptone.rpt file using php. With Crystal report 11.5.8.826, php 7.0.10, apache 42.4.33 and MySql 5.7.14 i have tried to connect/load crystal report file that is .rpt file using COM Object but it gives error $my_report = "report/rptone.rpt"; $COM_Object = "CrystalReports115.ObjectFactory.1"; $objCom = new COM($COM_Object, "localhost", 0, ""); $crapp = $objCom->CreateObject("CrystalDesignRunTime.Application"); $creport = $crapp->OpenReport($my_report, 1); This expected to be open rptone.rpt file that must show the report …

Member Avatar
+0 forum 0

I am having problem in submitting this form when I select "1" on the number of setting in html form. The submit button is working if I select 2 in the number of sitting from html form as it will show all the form fields but when I select 1, submit form is not working. I am new to PHP This is my html form <form name="register" method="POST" action="process.php"> <label>Select Number of Sitting(s)</label> <select name="sitting" id="sitting" class="form-control" onchange="showDiv(this)"> <option value="1">1</option> <option value="2">2</option> </select> <div class="output1" id="div1" name="onesitting"> <label>School Name</label> <input type="text" name="schoolname[]" id="schoolname1" class="form-control" placeholder="School Name" required> <label>Exam Type</label> <select …

Member Avatar
+0 forum 0

Hi i'm Anis. I want to ask how i can attach image from database in FPDF?

Member Avatar
+0 forum 0

I am making a small example of adding, editing, deleting and saving the treeView directory tree into the SQL Server database, what must I design to store in the database and write code ?

Member Avatar
+0 forum 0

hey, i am trying to insert multiple checkbox data in my database but having a littlt bit problem. When i am trying to insert checkbox data it inserts only id and nothing else. Here is my full code:- <?php include("config.php"); if(isset($_POST['save'])){ $contact_sms = $_POST['contact_sms']; $check[] = $_POST['check']; $firm_name = $_POST['firm_name']; var_dump($firm_name); $checkbox = $_POST['check']; for($i=0;$i<count($checkbox);$i++){ $bulksms="INSERT INTO bulk_sms (sent_sms,firmname_sms,contact_sms) VALUES('".$checkbox[$i]. "','".$row['firm_name']. "','$contact_sms')"; $smsquery=mysqli_query($conn, $bulksms); } } $sql="SELECT * FROM inventory_details where status ='0' AND role='0' ORDER BY position ASC, role ASC, visiter DESC limit 0,100"; $query=mysqli_query($conn, $sql); ?> <form method="post" action="" id="msform"> <?php $i=0; while($row=mysqli_fetch_assoc($query)){ $id = $row['id']; $firm_name = …

Member Avatar
+0 forum 0

I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset

Member Avatar
+0 forum 0

I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset

Member Avatar
+0 forum 0

Hi, I'm new to php (Yii Framework) and SQL (phpMyAdmin). I have problem to ask. ![Capture11.PNG](/attachments/large/4/1e4d9bf0c9a482a977d0ccb0fa19260e.PNG) Currently the three dropdown menu from different table and each have different id called aircraft_type, aircraft_sn and aircraft_reg. I want to use only one table called aircraft. In this table have all three details and only have one id. What I want to do is, when user choose value from aircraft type, the aircraft serial number and aircraft registration will also automatically fill. Calling value from table aircraft only. So far the code I have is: 1)_form.php (project form) <div class="panel panel-bordered panel-success"> <!-- …

Member Avatar
+0 forum 0

I need to create a database from the messages, coming from the Mobirise website builder's forms. What code should I use? This doesn't work. Could you please help me. $link = mysqli_connect('localhost', 'root', 'password'); if (!$link) { $output = 'Unable to connect to the database server.'; include 'output.html.php'; exit(); }

Member Avatar
+0 forum 0

In Access I want to group and assign data according to conditions with 2 values 0 and 1 (true or false) and with the condition NGAYGIAO>= #01/01/2019# and NGAYGIAO <=# 31/01/2019# me How to write commands ? The data I put in the excel file consists of two sheets: Original data and Result, where Original data is the original data sheet that is the result of the problem I need, when running the access issue, ask you to help me with the problem. http://www.mediafire.com/file/hkkw519bw2k3o9h/baitap_data2.xls/file

Member Avatar
+0 forum 0

I want to calculate the total conditional in the month but remove the records that are not the same month and not the same year, the condition that eliminates the view on the sql access because the result is true or false in the excel file http://www.mediafire.com/file/kq2mr2v6px1uxan/exercise.rar DOANHTHU2: Sum(IIf(Not IsNull([DONGIA]),[SOLUONG]*([DONGIA]/1000000),[SOLUONG]*([DONGIATT]/1000000))) DOANHTHU2: Sum(IIf(Not IsNull([DONGIA]) AND (SELECT COUNT(*) AS DEM FROM HDMUABAN WHERE (((HDMUABAN.HD)='M1101') AND ((HDMUABAN.LOAIHD)='FBAN') AND ((Month([NGAYGIAO]))=1) AND ((Year([NGAYGIAO]))=2019)) GROUP BY HDMUABAN.HD, HDMUABAN.NGAYGIAO, HDMUABAN.LOAIHD) AS NUM <=0,[SOLUONG]*([DONGIA]/1000000),[SOLUONG]*([DONGIATT]/1000000))) TONGDOANHTHU2: IIf(Not IsNull([DOANHTHU2]) And Not IsNull([BSLN]),[DOANHTHU2]+[BSLN],IIf(IsNull([DOANHTHU2]) And Not IsNull([BSLN]),[BSLN],[DOANHTHU2])) My example only removed one record, I designed the problem of removing many records if …

Member Avatar
+0 forum 0

I am using web server as LIGHTTPD....database as sqlite3....And php.. I made my flash memmory of nanopi as readonly(in fstab). while content listing from database to web page it is showing only limed amount of data( for example...in a webpage i am given to list 55 records.but beacuse of this readonly file system it is listing 19 records and no pagination.) How to make readonly filesystem without affecting above

Member Avatar
+0 forum 0

Hi fellas, I hope my first message here comes across more helpful than bothering. I’ve recently launched a WordPress backup plugin - WPvivid Backup/Restore. It contains pretty all basic features that you’ll need to backup/restore you site and is fairly easy to use. And most important, it’s completely free(free update and support). I made it because I realized that there’s still a growing need for the easier and more affordable backup solutions in WordPress community, we hope our plugin can give people a hand. Please check it out at WordPress’ plugin repository: https://wordpress.org/plugins/wpvivid-backuprestore/ Any feedback will be greatly appreciated. Joe

Member Avatar
+0 forum 0

Hello! I have a problem with a MySQL database that I haven’t been able to solve no matter how much I tried, either with internet guides or with free tools. I really don’t want to pay hundreds of dollars to a company so please, if anyone knows of a solution, help me because I’m desperate. I was running XAMPP 7.1.22 where I had said database and I decided to install XAMPP 7.2.10 without backing up the database. After that, the site wasn’t working so I figured the problem was the database. And indeed PHPMyAdmin wouldn’t recognize it. I reinstalled the …

Member Avatar
+0 forum 0

This the code in products <?php require_once("inc/header.php"); require_once("inc/navbar.php"); /* if user is logged in then only allow the user to view the page */ if (!isset($_SESSION['id'])){ echo "<h1 class='text-center text-upper text-bs-primary'>please login to view your cart <a class='text-black' href='login.php'>Login</a></h1>"; exit(); } else{ $user_id = $_SESSION['id']; } $carts = $db->FetchAll("*","cart","user_id='$user_id' AND active='y'","`id` DESC"); if (empty($carts)) { echo "<h1 class='text-center text-bs-primary text-25 text-upper'>your cart is empty <a class='text-black' href='products.php'>Go Shop</a></h1>"; exit(); } ?> <div class="container padding-10"> <div id="cart-container-main"> <div class="text-center text-20 text-bold" id="cart-message"></div> <table class="table"> <th>Product image</th> <th>Product detail</th> <th>Price</th> <th>Tax</th> <th>Subtotal</th> <th>Remove</th> <tr> <?php $cod= 0; $main_subtotal = 0; $main_shipping_charge = …

Member Avatar
+0 forum 0

I want to print the username on jsp page"**success.jsp**" from "**home.jsp**" i have used **hibernate** to save data in table . "home.jsp" <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>Insert title here</title> </head> <body> <center> <h1 ><font color="red">User-Interface</font></h1> <form action=loginServlet method="post"> <table border="1" bordercolor="red" style="border-style: dotted;" cellpadding="5px" cellspacing="10px"> <tr> <td>UserName:</td><td><input type="text" name="username"></td> </tr> <tr> <td>Password:</td><td><input type="password" name="password"></td> </tr> </table> <input type="submit" value="Log-In" > </form> New User?<a href="register.jsp"> Register Here</a> </center> </body> </html> success.jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> …

Member Avatar
+0 forum 0

Hey everyone i am just asking for a little bit off help if thats fine how can i make 11 fetch scripts into 1 script please [database ](https://i.imgur.com/BTGQF1P.png) i like to make this menu to display the coins i know you can do it but i dont know how since am not pro <ul class="nav nav-pills mb-3" id="pills-tab" role="tablist"> <li class="nav-item dropdown"> <a class="nav-link dropdown-toggle" data-toggle="dropdown" href="#" role="button" aria-haspopup="true" aria-expanded="false">Pick a coin</a> <div class="dropdown-menu"> <a class="dropdown-item" id="pills-btc-tab" href="#pills-btc" role="tab" data-toggle="pill" aria-controls="pills-btc"><img src="https://i.imgur.com/h2bZxBg.png" width="23" height="23"> Bitcoin</a> </div> </ul> fetch from mysqli i have btc here but i like to get every …

Member Avatar
+0 forum 0

Hey guys, Myriad Festival is coming to Brisbane next week and heaps of tech experts both local and international will be speaking there! It's my first time going to an event like this and I'm super excited to hear the industry mentors speak so I thought I'd let you all know so you could buy tickets as well if you were interested! Just search Myriad Brisbane for the extended speaker list, too many goodies to name! Hope to see you there :)

Member Avatar
+0 forum 0

Deleting a table data from adminer,It is showing error unable to "unable to open database file"..But command line sqlite3 delete query is working in ubuntu.

Member Avatar
+0 forum 0

Assuming I have file data northwnd.mdf version 2005 I want to convert to file data version 2008 or reverse ?

Member Avatar
+0 forum 0

Hello Everyone

Member Avatar
-1 forum 0

Hi Everyone, Can anybody suggest me. I have mysql with two database operations and production. My operations db have master master syncing on live server . I want to make production's master slave syncing onsame live server . Is it possible. How can do it?. Please help me. Thanks in advance

Member Avatar
+0 forum 0

Hello, I'm trying to edit data from a selected table row by using contextmenu. But when I try to select a row for edting instead the **LAST DATA in a row** will fetch. Table: <div class="container"> <div class="row"> <div class="col-md-12"> <div class="table-responsive"> <table id="ppmpsupplies" class="table table-bordered table-hover" cellspacing="0" width="100%"> <thead> <tr> <th>Code</th> <th>General Description</th> <th>Unit</th> <th>Quantity</th> <th>Estimated Budget</th> <th>Mode of Procurement</th> <th>Actions</th> </tr> </thead> <tbody> <?php foreach($items as $item){?> <tr> <td> <?php echo $item->id;?> </td> <td> <?php echo $item->description;?> </td> <td> <?php echo $item->unit;?> </td> <td> <?php echo $item->quantity;?> </td> <td> <?php echo $item->budget;?> </td> <td> <?php echo $item->mode;?> </td> …

Member Avatar
+0 forum 0

The End.