[database] Forum Topics

Hi there guys can someone explain to me how I can increment a value within a field in my database each time I execute my query?. As I cannot seem to find a way to do this. Below is my structure for reading + writting to my database if you …

Hi!I'm currently trying to make a language translation tool using vb.net 2008 and access 2007. For that I want to do these... 1.There is a textbox,a command button and two labels in my form and I have a database named 'dbwords.mdb' with one table 'word' and two fields named 'word' …

Hi! I'm having a bad time on learning how to store and retrieve image files on MS Access. This is some sort of uploading profile picture thing in my software. The open file dialog stuff and the storing of image file in the MS Access Database are taken care of …

Basically I'm trying to create an app where it generates random questions and displays them in a dialog box. I've managed to create a dialog box ok but incorporating the sql database full of questions and answers is proving difficult. I've been trying to follow this tutorial and it's the …

Hi I am a senior in business computing and I have a project to hand to my university in order to graduate and I have chosen a student registration system but in order to accomplish that I obviously need a well designed and organized database. here are the tables I …

Remove thread double thread occured

Hi Guys well what I want to do is instead of within my writeString to set my PLAYCOUNT to '16' what I want to do is every time the statement is executed my PLAYCOUNT is increased by 1. Any help you can give would be appreciated: My code is below: …

Hi guys well what I want to do is that when a button is pressed it increases the value in one of my database cells. So my question is how do I do this? As I cannot get this to work. My code so far: Any help would be appreciated …

Hi Members, I am working on Pentaho, I want to add a comment box with RTF(rich text format) feature, that saves the comments in the database. And when the user Login again, he must be able to see all those comments. I have tried it using PHP, and it is …

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) …

Hi. I need to make a system where I can accept input from the audience, and it'll show live on a PowerPoint Slide. I can create the user input system, but I don't know how to make a PowerPoint macro that when run will either: [LIST=1] [*]Retrieve text from a …

Hi guys well I have created a JComboBox that lists all my values from a String. However I want instead of the values for the JComboBox to be in a String the values to be displayed in the JComboBox from my database so if more values are added to the …

hey, I am totoally window person no experience with apple whatsoever except it is a multi-touch mouse that I know say -- if I wanna to learn android, I start with appinventor.com ----- I really wanna to learn write an apps for ipad i.e. business application I want it to …

I have problem with saving entry to mysql.. first entry saved but it doesnt work with second, somehow the save_new button didnt respond at all.. then i use saveandclose button it works or after i restart the pc the save_new button function will do it job for the first entry …

Hi guys well what I'm trying to do is produce a query that only produces the results which will match my director input. I have looked for the correct syntax and cannot seem to find it. Any help would be appreciated Code of my syntax below: [CODE] ResultSet results = …

[CODE]#Region "Imports" Imports System.Data.SqlClient #End Region Public Class frmcuti Private m_Cuti As New Entity_Penggajian.Cuti Private m_GetHari As New GlobalValidasi Private m_CutiA As New BussinessComponents.Cuti Private m_DS As New DataSet Private m_dta As SqlDataAdapter Private datagrid As DataView Private check As Boolean = True Private Sub frmcuti_onEdit(ByVal sender As Object, ByVal …

Hi guys well I have a problem on my JFrame which is once I click on my List all Videos button it displays my data from my MS database which all works well. However as you can see from the png the query results are not aligned up correctly together …

Forgive me if this thread was repost. :( I am a novice in database system for game development. Can Mr./Mrs. (Master) in here give me an example of a saving system for game? or it just use a database?(Like SQL?):idea: Like a feature for "Save the Games" and sometimes the …

Hi guys well my code is below I am trying to set up error checking so that CREATETABLE will only execute when String v and string d are false and when string t is true. I've started the code. Which it works when String v or String d are null …

Hello! Is there a way to hide the password of your database inside the source code? [CODE=vb.net]"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Application.StartupPath & "\Database.accdb; Jet OLEDB:Database Password = [B]MyPassword[/B]"[/CODE] As you can see the password is exposed, increasing the risk for the database to be compromise. Is there anything you can suggest …

Im creating a project where the a blog can be submitted, the date is stored in the database as dd/mm/yy, however im using LINQ to SQL to get the date as well as other information, the problem comes when i want to display the date in a particular layout (similar …

Hi guys I am able to drop my tables that I want but however when I come to trying to drop rows the rows do not delete. I have tried the following which have all produced the same error duplicate key TABLENAME : Any help you can give for a …

Hi guys I have successfully set up my database which through my GUI I am able to create my tables that i wish and insert data into the table. My problem is through that I can only insert one row of data into a table so what would I need …

Hi there well title says it all really. Is it possible instead of creating tables within my database to create the tables within a form in java? . If it is possible how would I go about doing this?. Before you ask yes my database is fully connected to my …

Hi all, I have dropdown in html consisting value country name. Instead of entering country name one by one into the mysql table I want to transfer by php programming . Is it possible ? If so ,any one can suggest....... Thanks in advance. Subrata

I am trying to figure out some web development using ms vwd in C#. I want to link a couple of textual titles to hyperlinks. However, those hyperlinks are stored in a database object's column using ms sql server and so I need to use the oledb commands and iterate …

Hi, I'm creating a form application using vb. I'm still new to this and I'm teaching myself via the internet so please don't be too mean. I wrote my code using queries that I created in visual studio. I don't quite remember how to create an update query and write …

I'm working on a Visual Basic application and would like to have it send its results (either an XML file or database rows) from the application to a database online for processing. I'm more familiar with MySQL/PHP but have no idea where to get started on with this. What I …

Hi all I m trying to filter a sql db with many filter criteria which inert the user in textboxes .. i ve tryed this query [CODE]query = "Select * from T_INCIDENTS1 where IFF (txtPostcode.text is notNull) then Incident_Postcode='" & txtPostcode.Text & "') and iff (txtDMA.text is notNull) then Incident_DMA='" …

Hi everybody, I found an error-based sql injection in my webserver.My database doesn't contain any private info. I want to know if its possible to own my server just by using the info in information_shema. Please tell me because i want to know if i have to fix it.I don't …