70 Solved Topics
Remove Filter
|
|
I have a project where I need users to be able to save their work, then at a later date select the session/data from their previous work and continue. I have completed all of the coding (and it works) to save the current session under their userid, and populates a … |
|
Hello guys, i've the following table in database : IdCity int CityName nvarchar(20) it has the data like this in it : IdCity CityName 1 Абакан 2 Азов 3 Александров 4 Алексин 5 Альметьевск 6 Анапа when i try to run the following view SELECT IdCity, CityName FROM dbo.City WHERE … |
|
Hi to all! I'm fairly new to using High availability group and i've been having issues with storage space from my Logs drive from my primary server.. I just want to know why is my Log file not shrinking after I do backups(Full) on the primary server.. also, another question.. … |
|
Hello Dear Friends, I need some help to check avilidity of the username on Leave event of a textbox in Database SQL Server, but i cann't get. it code is bellow private void textBox6_Leave(object sender, EventArgs e) { cmd = new SqlCommand("SELECT * FROM usertab WHERE username='"+textBox6.text+"'",con); SqlDataAdapter da = … |
|
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? |
|
Hello! I have written a simple program which connects netbeans with SQL Server database. The program is giving an exception. I am displaying the source code of my program and exception below. Please guide me to solve this problem. public class dbconnection { Connection con = null; public static void … |
|
Group, I'm trying to import an EXCEL table into an SQL Server Table. Although new to SQL, I've done it several times. However for the first time I'm having to import a column that is a date. I'm not sure how the EXCEL column should be formatted so that it … |
|
I'm having some real trouble running some basic queries that I should be able to run easily. I have a table called settings. When I query `SELECT * FROM settings` I get the output: +----+-----------------+--------------------------------+ | ID | key | value | +----+-----------------+--------------------------------+ | 1 | view | default | … |
|
Hello, currently on one of my development servers I have SQL Server 2014 installed, the problem I HAD was that when I executed any of my PHP sites connected to various databases I was getting `SQLSTATE[HY2000][2002] Connection was activily refused...` I fixed that error by forwarding the port through the … |
|
Hi EveryOne, I have a following controls in my vb.net form: txtID txtName btnAddNew btnSave This form will be storing a values to the SQL Database (SQL Server 2005). In the txtID textbox the auto id should be generated when ever user clicks on btnAddNew. The ID should be generated … |
|
Hi, I have recently started working with SQL databases of which I have 0 previous experience. I have added the datasource to my project using the Visual Studio wizard and the DataSet appears in my solution explorer. Everything that I have read thus far has shown connecting to the SQL … |
|
Hi im attempting to copy a php code and get it to work with a script im trying to create and i have come across the error below can anyone tell me whats going off any help would be much appreicated x You have an error in your SQL syntax; … |
|
|
I want to add data to sql databse using vb.net form And I am new to programming :( I get an error message saying "Incorrect syntax near "deatails") Can somebody tell me the reason the following is the code I'm using Imports System.Data Imports System.Data.SqlClient Public Class Customer_Profile Dim con … |
Hi! I'm using Microsoft Visual Studio 2008, Microsoft SQL Server Management Studio. I need help. I cant figure out this if else statement for this condition: ///to check condition either the way ID exist in database ///if not exist then way ID can be delete ///if exist, message box appear … |
|
Hi. Im using VS2008 and SQL Server Management Studio 2008. I want to ask, i have two different table, TableA and TableB in same database, DatabaseX. Both table have two same column, ColumnY but the data are different within this table. Example: TableA, ColumnY : A1, B2, C3, D4 TableB, … |
|
hello everybody...nice to back again i m working on project to calculate measures and numbers and insert data inside datagridview(dgv) from number.text and measure.text but if value of measure.text present in dgv son update number cell with new value + present value problem is how to do so.... i tried … |
|
Someone can help me to find my error: $query=mysqli_query($con," SELECT * FROM item WHERE ITEM = $ITEM ") or die ( mysqli_error($con)); i reciveing this error,i dont know wherer is syntax error. *You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version … |
|
I'm trying to query from two tables but whenever i run my php script i get this error, any help would be highly appreciated Database query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to … |
|
How to log-in in MVC uing sql server? Any recommendation? |
|
Hi, after creating a software with SQL database (my other pc is the data server) this shown up " String or binary data would be truncated. The statement has been terminated " what to do? sometimes it imports the data sometimes it does not... |
|
The database that I'm working for has been suddenly corrupted. Fortunately, I performed a backup on it and save to a backup tape. Therefore, I reinstalled SQL Server and I tried to restore those backup. However, it failed and I suspect that maybe the backup is corrupted too as well. … |
|
how to fix [DBNETLIB] ConnectionOpen(Connect()).]SQL server http://i.gyazo.com/3e7e693141fd157da860907218fbb1a0.png this is UID and password of my SQL server I try to insert but this is the problem I get http://i.gyazo.com/c903e03c7d697b7b8c2c80933e99e376.png and this is at my other pc so had to make pics with my phone. any idea how to fix this? |
|
Hi I am working in weekly Newspaper company. There are 15000 subscriber, subscribed for next 3 to 4 years.Per year 52 weeks and I have to generate issue number based on week(1001......3000) for each subscriber and store into data table. I am using mssql 2012. I have written the Store … |
|
Hello :) I'm trying to create web application. I followed the tutorial given in this site : http://aspsnippets.c...-in-ASPNet.aspx My problem now, after I create a table and the UI. Next step show about stored procedure. What is stored procedure use for? Do I need this even though I had a … |
|
Hi guys, I want to multiply or add the values of two or more cells in a datagridview control in a row and and should also be auto-saved in the database after entering datas in the cell. I am using SQL Server 2008 for my database. Please do take a … |
|
I have the following table User in my database Name(Varchar) DateOfBirth(datetime) Age(int) Name(Varchar) | DateOfBirth(datetime) | Age(int) John | 2014-12-20 23:59:59 | 0 Mary | 2014-12-20 23:59:59 | 1 How can i verify throught javascript if the field DateOfBirth of the table User of the database z is of type … |
|
Alright, so the following has stumpted me and a few others in the office, and we just can't figure it out. I have develope a program that allows us to go out to a specific database and search one of the fields based on specified values. Now that seems all … |
|
Hi There, This comes under a few forums on DaniWeb, so I've guessed and posted it here... I have two computers, both connected to the internet and running Windows 7 (Home Premium + Professional). One is my main one, the other is one I do not use. If I installed … |
|
I'm using: Windows 7 Home Premium 64-bit operating system Netbeans IDE 8.0 WAMP Server 2.5 Here is my issiue. I am attempting to follow the E-commerce tutorial in the Netbeans Java EE & Java Web learning trail (Section 3 "The NetBeans E-commerce Tutorial - Setting up the Development Environment"). In … |
|
i'm not sure what is the syntax error. I try in this source code in dreamweaver, it shows line 8 is a syntax error. $destination = realpath(‘../../app/webroot/uploads/excel/’); App::import(‘Vendor’, ‘php-excel-reader/excel_reader2’); //import statement class UploadsController extends RealTimeAnalysisAppController public function upload() { $destination = realpath(‘../../app/webroot/uploads/excel/’); //Set your upload path here if(isset($_FILES['Upload']['XLS_File'])); $ext = … |
The End.