Hi all I have a script to update the value from datagridview to database I do use a button insert ToolStripButton but not working hope people to help thank ! Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load conn = New SqlConnection("") conn.Open() Dim query As [String] = "SELECT * FROM dtaEmployees" da = New SqlDataAdapter(query, conn) Dim cb As New SqlCommandBuilder(da) dt = New DataTable() da.Fill(dt) C1FlexGrid1.DataSource = dt conn.Close() End Sub Private Sub ToolStrip1_ItemClicked(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ToolStripItemClickedEventArgs) Handles ToolStrip1.ItemClicked Select Case e.ClickedItem.Name Case "ToolStripButton1" '---> button insert da.Update(dt) End Select …

Member Avatar
Member Avatar
+0 forum 7

Hi all, I am very new to PHP and MYSQL and have a class assignment I need help with. I am trying to make a page with an HTML form that will update my MYSQL database. You can view my pages online here: [URL="http://baileyjumper.aisites.com/Scripting-Week7/homework4/exercise-five.php"]http://baileyjumper.aisites.com/Scripting-Week7/homework4/exercise-five.php[/URL] I need help with the "Edit" section, if you look online. Here is the code for my Edit page: [CODE=PHP] <?php $hostname = "localhost";//host name $dbname = "baileyjumper_imd203";//database name $username = "baileyjumper_imd";//username you use to login to php my admin $password = "chris4ever";//password you use to login //CONNECTION OBJECT //This Keeps the Connection to the Databade …

Member Avatar
Member Avatar
+0 forum 19

I have a very standard code where I use a CRUD interface on my Database. The issue is that every attempt I made to redraw/update the table with the new data [ $('.table').DataTable().draw(); ] has failed miserably. Here is my targeted code: function manageData(key) { var name = $("#countryName"); var shortDesc = $("#shortDesc"); var longDesc = $("#longDesc"); var editRowID = $("#editRowID"); if (isNotEmpty(name) && isNotEmpty(shortDesc) && isNotEmpty(longDesc)) { $.ajax({ url: 'ajax.php', method: 'POST', dataType: 'text', data: { key: key, name: name.val(), shortDesc: shortDesc.val(), longDesc: longDesc.val(), rowID: editRowID.val() }, success: function (response) { if (response != "success") alert(response); else { $("#country_"+editRowID.val()).html(name.val()); …

Member Avatar
+0 forum 0

Can not create a dvd dl in windows 10 only a dvd or cd since the april 2018 windows update

Member Avatar
Member Avatar
+0 forum 1

Today I tried to install the Windows 10 Fall Creator's Update. It failed with the message ![2017-10-18_161217.png](/attachments/large/3/837de23baab769b190bf69bbceed71ee.png "align-center") I found this peculiar because I don't have that application installed. I **do** have Macrium Reflect (Free) version 6 but certainly not Drive Image 7 (Powerquest). As usual, clicking the Support link took me to a totally unrelated page. Has anyone else had a problem with the update? By the way, clicking the Uninstall button produced ![2017-10-18_163207.png](/attachments/large/3/1a176108f644c78ce93a763939cf7c77.png "align-center")

Member Avatar
Member Avatar
+0 forum 21

Hello Experts Have heard that, Google is preparing for Google Zebra update, to refine social media market? How far is it true? Any ideas ?

Member Avatar
Member Avatar
+0 forum 15

Google algorithm panda and penguin update just because to improve search results. It will helps the user to find right search. Also it helps to get benifit the person who using seo services

Member Avatar
Member Avatar
+0 forum 11

I am a beginner in this field and I have some mistakes in ((codes)) who can tell me what my mistakes. Physical model (1) Employee (SSN, Salary, Phone) CREATE TABLE Employee (SSN integer PRIMRY KEY, Salary integer, phone integer); Department(DNO, dname, Budget, ssn_employee) CREATE TABLE Department(DNO integer, dname varchar(10 )Budget Integer, ssn_employee int, CONSTRAINT pk_Department PRIMARY KEY (DNO) ,FOREIGN KEY (ssn_employee) REFERENCES employee(ssn_employee) ON UPDATE CASCADE ON DELETE SET NULL ); Child(IDChild, Name, Age, ssn_employee) CREATE TABLE Child( IDChild Integer, Name varchar(40), Age Integer, ssn_employee Integer CONSTRAINT pk_Child PRIMARY KEY (IDChild), FOREIGN KEY (ssn_employee) REFERENCES employee(ssn_employee) ON UPDATE CASCADE ON …

Member Avatar
Member Avatar
+0 forum 4

Hello, my code at the minute fetches a record and splits it up into a tuple, this is so each individual element can be displayed in an entry. I am now trying to create a feature which reads what is in the entrybox and updates the record in the database. This is the current code: def Update(self): global Record global Name global TrainerID global Postcode global Age global Gender global Password (Name, TrainerID, Postcode, Age, Gender, Password) = tuple(Record) Name = self.ent_Name.get() TrainerID = self.ent_TrainerID.get() Postcode = self.ent_Postcode.get() Age = self.ent_Age.get() Gender = self.ent_Gender.get() Password = self.ent_Password.get() List = [Name, …

Member Avatar
+0 forum 0

Hi guys, I just got into a little problem.I just deployed an application with backend db access.It works fine on major OSs being used like win7 and XP. But some functionality related to the database doesn't work properly when deployed on win8. I used a code to delete temp table if it exists.This feature completely works on the other OSs.But i don't know why the code is not working on the later OS. Any thought to solve the problem? Public Sub DroptempProject() On Error GoTo ErrorHandler Dim str As String str = "DROP TABLE ptempTable" ExecSQL(str) 'Exit Sub ErrorHandler: If …

Member Avatar
Member Avatar
+0 forum 5

In order to resolve a problem whereby Microsoft keeps updating my video driver (which works) with a newer version that is crippled, I installed the Windows 10 Creator's Update. So far it - Reset driver update back to auto (I had disabled it) - Re-enabled OneDrive (I had disabled that as well) - Re-installed the shitty video driver (screen rotate no longer works) - Disabled my Trend Micro anti-virus - Left me with a Windows.old folder which I am having fun trying to delete I'll post more problems as I find them.

Member Avatar
Member Avatar
+0 forum 11

I have problem updating the mySQL table i have simple loop to display the rows in the table in HTML FORM but when i try to update the row notting happens, no row is updated! here is the code <form action="" method="post"> <?php $sql = "SELECT ID, votemodelName, votemodelImage, modelLink, votes, ip_address FROM vote ORDER BY ID LIMIT 3"; $result = $conn->query($sql); $user_ip = getenv('REMOTE_ADDR'); $geo = unserialize(file_get_contents("http://www.geoplugin.net/php.gp?ip=$user_ip")); if (!$result) { trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $conn->error, E_USER_ERROR); } else if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $ID = $row["ID"]; $votemodelName = $row["votemodelName"]; …

Member Avatar
Member Avatar
+0 forum 12

Am trying to create edit-form but there are some problem which I cant determine by my self. I cant echo inserted record and updating. <?php include("db_con.php"); $edit_reg_no = filter_input(INPUT_GET, 'edit_customer_detail', FILTER_VALIDATE_INT, ['options' => ['default' => NULL]]); if(isset($_POST['update'])){ $update_reg_no = $edit_reg_no; //getting the text data from the fields $d_fname = $_POST["d_fname"]; $d_lname = $_POST["d_lname"]; $customer_name = $_POST["customer_name"]; $mobile = $_POST["mobile"]; $office_tel = $_POST["office_tel"]; $email_fax = $_POST["email_fax"]; $model = $_POST["model"]; $engine = $_POST["engine"]; $vin = $_POST["vin"]; $work_carry = $_POST["work_carry"]; $demage_found = $_POST["demage_found"]; $accessories = $_POST["accessories"]; $car_received = $_POST["car_received"]; $mileage_covered = $_POST["mileage_covered"]; $update = "update customer_details set d_fname='$d_fname', d_lname='$d_lname', customer_name='$customer_name', mobile='$mobile', office_tel='$office_tel', email_fax='$email_fax', …

Member Avatar
Member Avatar
+0 forum 3

I have been having a problem for a few months with the video driver for my Dell laptop. The hardware/driver are from Intel. The driver from 2016-09-29 works just fine. It has a feature that I use regularly to rotate the display via hotkeys - very convenient for document reading. Unfortunately, all later drivers disable this feature. Also unfortunately, Windows Update keeps downloading and installing the latest driver. This means that I have to repeatedly re-install the old driver. Not a big problem but an unnecessary one in my opinion. After several iterations through Intel Support I was told (in …

Member Avatar
Member Avatar
+1 forum 5

Just a question to seasoned PHPers, who have been working with 5- for a while. Has 7 made any difference to the way you code? Are you using any of the new features, and if so, which ones? Are they massive time savers (coding-wise or run-wise) or is it all a bit superficial? Would really like to know. Thanks.

Member Avatar
Member Avatar
+1 forum 4

As it seems to come up often enough I figured I'd throw together a quick snippet outlining basic methods for data manipulation in SQL Server using C#. In all examples the coder will need to substitute their own connection string details and variables. I utilised parameters for 3 of the examples but they can just as easily be replaced by direct references to dynamic controls in your application if desired. The benefit of parameters, however, is that they set the 'type' of the variable being passed and add an additional level of type checking to the app. I'm hoping I …

Member Avatar
Member Avatar
+2 forum 13

Hi hope you can help me. I have studied a lot to make my website using php and mysql and I know how to insert data in a table from a form, how to select and display data on page etc. Lately I got involved with wordpress which is a great CMS. The only problem is so different and is driving me nuts, also because I find no help in the various tutorials online. I have some simple questions. 1)Can you tell me how to insert data into a tablepress table from a form (my site is about hotel booking)-2) …

Member Avatar
+0 forum 0

I had mysql database and had many tables in database. For this problem we need details only about two tables. These tables are customer and guarantor. For each customer had two guarantors. In Customer tables it's primary key is Customer_id In Guarantor table it's primary key is Guarantor_id Then I think you need details about software side. I develop software with vb.net. For new customer it has new customer window. In this form there are two list boxes to select two guarantors. And when select gaurantor from list box, some details like name, address are loaded to this form. Again …

Member Avatar
Member Avatar
+0 forum 5

I inserted data in sql server using asp.net (MVC 5), and its flowing nicely, but my problem is this. I don't want to insert in sql the exist data. How can I do it?

Member Avatar
Member Avatar
+0 forum 11

Hello i have a question about the security of my website, does my website can get hacked somehow if im updating it directly from my database? (ex. images, posts, links...). I have few pages on my website which have PHP code to read info from the database and i do not have any input fields which are availabe to the public. Im asking this question because i cannot make secure system that i can update it from there. if there is other option of doing this please feel free to share and if you need to see the code i …

Member Avatar
Member Avatar
+0 forum 2

hi... im trying to update one of the columns of my table with a multiple data without deleting the previous data.. by the way im using vb.net and mysql... does anyone has an idea? or a codes perhaps. its like, the previous data being inserted will just merge from the new inserted one.

Member Avatar
Member Avatar
+0 forum 2

Using PHP / MySql... I have a transaction table and a record is automatically inserted when someone Initiates a transaction, and then is updated later in the process, based on the recID. I want / need to keep the recIDs filled with completed transactions without any skips in the ID sequence (as created by the auto increment on insert) If someone Voids a transaction without completing it, the record status is set to ‘V’ so it can be reused for the next transaction. My Question: How can I get the recID of a transaction returned to my after doing an …

Member Avatar
Member Avatar
+0 forum 5

Hi, I am new to SQL Server and what I am trying to do is convert my working SELECT Query to an UPDATE Query to update the data from a vb.net datgridview. I have looked for a tool or examples but cant find any information that can point me to the correct path. Select AssetNo [ASSET NO], t2.TYPE [TYPE], t3.Status [STATUS], t13.PURTYPE [PUR TYPE], MAKE [MAKE], t5.Model [MODEL], SerialNO [SERIAL NO], T6.OS [OS], LICENSEKEY [LIC KEY], MEMSIZE [MEM], HDDSIZE [HDD], Owner [OWNER], SVP [SVP], t12.Company [VENDOR], CONTRNO [CONTR NO], LNAME [USER LNAME], FName [USER FNAME], UserNO [USER NO], t9.Site [USER …

Member Avatar
Member Avatar
+0 forum 7

my update is choosing a different column which i don't have in my table. Please i need assistance SQLSTATE[42S22]: Column not found: 1054 Champ 'companyprofiles.id' inconnu dans where clause (SQL: select * from `companyprofiles` where `companyprofiles`.`id` = 2 limit 1) what i have is user_id thus what i need to choose

Member Avatar
Member Avatar
+0 forum 7

Write a program that can be used by a small theater to sell tickets for performances. The theater’s auditorium has 15 rows of seats, with 30 seats in each row. The program should display a screen that shows which seats are available and which are taken. For example, the following screen shows a chart depicting each seat in the theater. Seats that are taken are represented by an * symbol and seats that are available are represented by a # symbol: seats 123456789012345678901234567890 Row 1 ***###***###*########*****#### Row 2 ####****#####***************## Row 3 **######*************#####**## Row 4 **######**************##****** Row 5 ********#####********######### Row 6 …

Member Avatar
Member Avatar
+0 forum 20

Hello All, Is there any provision to ignore the trigger when i update a row in a table. Thanks, Loges

Member Avatar
Member Avatar
+0 forum 2

Hi team, In hibernate one to many relation ship am updating parent setting with child data when am doing session.update(parent) (parent have set with child data) then am committing the its throwing exception saying that Caused by: java.sql.SQLException: ORA-01407: cannot update ("TPIA"."TPIA_TRANSACTION_DATA"."TRX_ID") to NULL.so please help will get appriciate.

Member Avatar
+0 forum 0

I've updated the attendance.sql and the attendance form (index.php) by adding the time in and time out of the attendance. The time in and time out values are still blank even it is assigned in the database. (Lines 65 - 66) And when I tried to update the values (e.g. present and late), it cannot work. (Line 89) Can help me? Download: https://drive.google.com/open?id=0B07_pOHhTox3aEtCZm9TVjVkTlk Inside there is the database table called attendance.sql. You need xampp and you must import the table (attendance.sql) in phpmyadmin.

Member Avatar
Member Avatar
+0 forum 4

I've updated the attendance.sql and the attendance form (index.php), but when I tried to update the values (e.g. present and late), it cannot work. And also, the checkbox says it's all ticked even the values are different (lines 61 - 63 of index.php) Can help me? Download: https://drive.google.com/open?id=0B07_pOHhTox3bTN1Z21HRlR2TEE Inside there is the database table called attendance.sql. You need xampp and you must import the table (attendance.spl) in phpmyadmin.

Member Avatar
Member Avatar
+0 forum 2

I have a pictures website and I want to be able to add impressions to the database when a visitor scroll down the images. Each image viewed equal to 1 impression. This feature can be found in Facebook post impressions. This is what I have come up with so far: $(window).scroll(function(){ index = $(".Picture-1A:eq(3)").offset().top; elementHeight = $(".Picture-1A").height(); if(($(document).scrollTop() >= index) && ($(document).scrollTop() <= index + elementHeight)){ // Do something here } }); Of course I will be using jQuery and Ajax. The example above is my first attempt. I don't know how I can do it for each image. I …

Member Avatar
Member Avatar
+0 forum 1

The End.