1,694 Topics

Member Avatar for
Member Avatar for elenizi

Hi i am having problems designing a solution for this problem : I have a form where you can choose the items you wish and type the quantity and then add them to a listview item. The itema are already saved in a database ( i am using sqlite ) …

Member Avatar for JOSheaIV
0
397
Member Avatar for shihab2555

I have created a table named student including column stu_id, stu_name & Blood_group.I created a delete button to delete rows and I used the following code when delete button is pressed.I take input using jtextfield.But this can only delete by taking input in stu_id.But now i also want to delete …

Member Avatar for shihab2555
0
246
Member Avatar for shihab2555

I have created a table named student including column stu_id, stu_name & Blood_group.I created a delete button to delete rows and I used the following code when delete button is pressed.I take input using jtextfield.But this can only delete by taking input in stu_id.But now i also want to delete …

Member Avatar for shihab2555
0
238
Member Avatar for anisha.silva

Hi I have two tables Employee and Job, Employee's prmary key is EID and in Job there is a EID that is a foreign key to Job. job has another column as the status of the employee. first the employee is added to the database and then the job detils …

Member Avatar for AleMonteiro
0
200
Member Avatar for CDRIT

I've inherited a small C# command line program that takes a date and creates several spreadsheets containing data pulled from a microsoft sql server database based on that supplied date and some names hard coded into the program. I'm looking to change the program to pull the data from a …

Member Avatar for riahc3
0
207
Member Avatar for sourabh.asu

Hello, I have the following table, for readability I broke down the after every manager for every case number. The last column is the cumulative sum of the second last column. Value for month should ideally run from 1-3 (Like you see for both the cases for Chicago). But from …

Member Avatar for adam_k
0
610
Member Avatar for hueylouis

Can anyone assist me. I keep getting and error stating that the Column count doesnt match row 1. I have counted all of my fields and referenced all of them but still no dice. $con=mysql_connect($host, $username, $pass); if(!$con) { die("Could Not Connect: ".mysql_error()); } mysql_select_db($db); $CustLName=$_POST['CustLName']; $CustFName=$_POST['CustFName']; $CBR=$_POST['CBR']; $AcctNum=$_POST['AcctNum']; $CustCode=$_POST['CustCode']; …

Member Avatar for doubleN
0
653
Member Avatar for geneh23

Hey everyone, So I'm starting a new thread because my other thread was solved and I had forgotten it was. Anyway, I am creating a forum stite from scratch as a side project and I have a main forum page that "includes" two tables that get data from three different …

Member Avatar for LastMitch
0
143
Member Avatar for khair.ullah

Hello dear ALL I am working with a form in vb.net which have the follwing attribute i.e BOOK TITLE(text box) , CATEGORY NAME(combo box) ,YEAR PUBLISHED(t.box) and SAVE button .the CATEGORY combo pickup data from CATEGORY TABLE on cat_name . on back end (SQL SERVER) there are two tbl i.e …

Member Avatar for khair.ullah
0
209
Member Avatar for aelton

I'm managing a server running Windows Server 2008 R2 for a client and after investigating some high memory usage, I discovered that the Windows Internal Database SQL instance is using over half of the server's RAM. Capping the instance's memory usage is easy, but unfortunately my user account (which is …

Member Avatar for cguan_77
0
315
Member Avatar for hwoarang69

so i now how to write quies and really really easy. its alot easier than being computer programmer. but sql salary are really high and computer programer which is alot harder is lower. why is this. a phd student told me that sql job are really boring. is that true??

Member Avatar for JorgeM
0
503
Member Avatar for hwoarang69

hi trying to get a job where i have to write sql queries. i have writen some queries but i have to do a project. that way i can show the project to other people. any ideas of a sql projects?

Member Avatar for pritaeas
0
131
Member Avatar for geneh23

Hey everyone, So I'm doing a project just for the heck of it. However, I'm stuck on an issue. I want to query the database to select the last comment in the answers table so I can display it on the main forum page under the specified topic. How do …

Member Avatar for LastMitch
0
205
Member Avatar for mmcdonald

Hi all, I have a very nasty issue here where SQL values are changing but I haven't been hacked because the changes are just too abnormal. People vote for their servers and every so often the top few servers values roll back. For example at 03:00 a server has 66 …

Member Avatar for diafol
0
176
Member Avatar for masocha

l need to generate a dynamic PDO update query. l am not sure of the behaviour where we have the same placeholder name in th update and WHERE clause for example UPDATE users SET name = 'Master User' WHERE name = 'Dev User' As you can see placeholder name will …

Member Avatar for diafol
0
65
Member Avatar for newuser17

Hi, I am new to mobile app development. I would like to know what is the best way to connect to backend, I have a database in sql server 2005, and a web application in C#.NET. Now I would like to have a mobile app of that application. But fairly …

Member Avatar for marcinperlak
0
230
Member Avatar for joslup9

Hello guys, i need a help slightly with this project of my university. my equipment are working with some components, 1. Radius Server - MySQL - OS Linux Ubunto 12.04 or OS Microsoft WindowsServer2008 - SQLServer. 2. Router Linksys Wrt-54g 3. Other Server with certification unit, which we need manage, …

Member Avatar for JorgeM
0
243
Member Avatar for _tincho87

Hi, i have a Sql Server 2008 database, with a table that has around of 2.000.000 registers. The schema of the table is the following: idSpecie (PK, int) | Kingdom | Phylum | Class | Order | Family | Genus | Specie The kingdom, phylum, class, order, family, genus and …

Member Avatar for urtrivedi
0
164
Member Avatar for G_Waddell

Hi, I'm writing a VB.net application that runs off a SQL database. If the application can not connect to the database or the connection has not been set up I'm giving the user the option to create the database on the SQL server instance of their choice I then create …

Member Avatar for G_Waddell
0
343
Member Avatar for OsaMasw

Hello there, I need help to create simple rank system 1st thing I need is how to number the players in my database from 1 to ...... so if I create multipage in each page there is the actual rank for them 2nd : I need to create change indecator …

Member Avatar for OsaMasw
0
158
Member Avatar for Mike Bishop

I am writing a program for a company and would like to limit how many users can use this program at one time. IE if they have a 3 user licence when the 4th user tries to log in it wont let them. I have no idea how to accomplish …

Member Avatar for Reverend Jim
0
91
Member Avatar for HunainHafeez

if i have table in database(sql server) and has 1500 records and i run 2 applications(at same time) that will retrieve 500 records each so how can i do this app1 will retrieve first 500 records app2 will retrieve next 500 records means no over lap SET Transaction Isolation Level …

Member Avatar for HunainHafeez
0
297
Member Avatar for otttt

Hi Thgin i seek is to create a connection (android) to the latest postgresql 9.2 database. Theat is running on a distant server. Can i Do it? Is postgre 9.2 JDBC driver fro andoid out? & little bit distant question. If the prevous is doable. How i an write tet …

Member Avatar for peter_budo
0
169
Member Avatar for Stuugie

Hi all, I have a table called tblCPI that holds approximately 160,000 records that have to do with Canadian CPI. I have created a process that did the initial data load into it and now I need help figuring out how to update it according to date values. For instance, …

Member Avatar for Stuugie
0
189
Member Avatar for ismael ahm@d

i have three db tables products product_id- Name 1 | hairoil 2 | lotion 3 | cream Countries country_id- Name 1 | UAE 2 | France 3 | UK Now i wanna that when select multiple countries for one product from Html form, then in third db table should insert …

Member Avatar for ismael ahm@d
0
9K
Member Avatar for HunainHafeez

i have a login page within asp.net 3.5 (c#) website, and sql server 2008 at backend, i wrote a store procedure to save password in hashed form using SHA1 algo during registration , now during login i want to compare etered passowrd with the one save in db, so i …

Member Avatar for HunainHafeez
0
383
Member Avatar for Mits14

I need help!! What I want is when I add a new teacher, it will search the tblteacher_info. If there is already a record of that teacher, it will just update his/her record. If there is no record of that teacher, it will add his/her info in the tblteacher_info. I …

Member Avatar for Mits14
0
144
Member Avatar for paulnamroud

Hello, I'm building an application with asp.net. And I need to send emails to selected customers. What is the best way to send email ? Is it by using System.Net Class or to send it by using MS Sql Server ? Thank you Paul

Member Avatar for aryanverma
0
370
Member Avatar for HunainHafeez

i want to hash my password to SHA1 algo, in asp.net code and then want to compare it with hashed password in sql 2008 db, for login so how to hash it in asp.net code ?

Member Avatar for HunainHafeez
0
178
Member Avatar for manjeet593

Hello Everyone, ASP.NET (C#) I have problem in retrieving the images from Table created in SQL Server Management Studio. Actually I had uploaded the images into folder in the Application Server on Visual Studio and the path of the images is given in the Table Attribute. Thus I have table …

Member Avatar for JorgeM
0
161

The End.