9,022 Topics
Hello, I built a website on my personal server and everything work fine. But when I uploaded it on the production server there is a problem with the database - the character encoding is wrong so the text is unreadable (users submit greek words). The collation of the tables is …
The issue I am having has to do with not being able to show different OrderDate for the same Unit Unit OrderDate ShipDate ReceiptDate Robot 20160101 20160102 20160103 Robot 20160102 20160103 20160104 Robot 20160103 20160104 20160105 What is happening instead is that it is showing the same OrderDate for all …
Hallo to all, can anyone help me how to display data from the database based on the date from the [COLOR="red"]dtpicker[/COLOR]? In my database I have a column [COLOR="Green"]date [/COLOR]and a column [COLOR="Green"]event[/COLOR], if I click a particular date in the [COLOR="Red"]dtpicker[/COLOR] it should display in the MSFlexGrid the [COLOR="Green"]date …
Why does this perfectly valid link(`http://www.databasejournal.com/features/mssql/article.php/3112381/SQL-Server-Calculating-Running-Totals-Subtotals-and-Grand-Total-Without-a-Cursor.htm`) show up as a broken link in a [post](https://www.daniweb.com/programming/software-development/threads/506824/how-to-get-the-value-from-cells-of-a-datagridview-table#post2212833)?
Validate student id,username if already exist in database table . Using VB.Net 2012 and SQL database on windows10 system. Thanks for your help.this is my first post so thank you for your help guys. Private Sub InsertSutdent() SQL.AddParam("@stud_name", txtFirstname.Text) SQL.AddParam("@stud_lastname", txtlastname.Text) SQL.AddParam("@stud_id", txtStudentId.Text) SQL.AddParam("@stud_username", txtUsername.Text) SQL.AddParam("@stud_course", cbxCourse.Text) SQL.AddParam("@stud_password", txtpassword.Text) SQL.AddParam("@active", …
Not sure if this is the right place for this, if not, please remove. I'm an Admin for a very large SAP landscape which includes variety of DBs. I've been evaluating the Xandria product from syslink ([www.syslinkams.com](http://www.syslinkams.com)) and so far been very impressed. I was wondering if anyone had any …
`Select * from contacts WHERE behavior = 'nice'` [SQL Clause is coming to town.](http://imgur.com/gallery/KvsXO) Not mine, [Little Bobby Tables](https://www.explainxkcd.com/wiki/index.php/Little_Bobby_Tables) almost ruined Christmas.
Sir, I have these PHP codes while($res = sqlsrv_fetch_array($result)) { echo "<tr>"; $sno=$sno+1; echo "<td align='center'>$sno</td>"; echo "<td align='center'>".($res['acc_code'])."</td>"; $partycode=($res['acc_code']); $query1 = "select code,desc1 from master where code='".$partycode."'"; $result1 = sqlsrv_query($con,$query1) or die ("Error". sqlsrv_errors($con)) ; while($res1 = sqlsrv_fetch_array($result1)) { echo "<td align='left' class='color1'>".($res1['desc1'])."</td>"; } echo "<td align='right'>".($res['dr_amount'] != 0 …
Hello All ... Iam Getting An Error With try to excecute the stored procedure . I have Have Sql database , the stored procedure like so : USE [MPRS] GO /****** Object: StoredProcedure [dbo].[Search_Licenses_By_Number] Script Date: 26-Nov-16 8:06:52 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE …
Hello friends. Please help me to solve my problem. I am using sql server 2008. When I try to access it recieve the following error: "Cannot connect to localhost ". So my question is, how to repair sql server? Hopefully someone will be able to help me with this.
I am working on a report that is requesting to count the total number of errors per element in the total row of the report for a given County. When I use the COUNT function it is taking the max value from the number of reads complete column for that …
Hey Guys, I have a question... I want to display data from two different tables into a single datagrid view. Problem is i dnt wana join the tables. pls check this code [code]private void bindgrid() { SqlConnection con = new SqlConnection(connStr); con.Open(); str1 = "Select * from wcl_et "; str2 …
Hi to all! I am using sql server 2008 enterprise edition. My instance name is "saboor-pc/ SQLSERVERENT". I am using this server for many months and i am satisfied but today an unexpected error occured when i clicked on "connect" button in sql server management studio. The error was: "Cannot …
Help me....! Actually I have records about 1000 credit customers, My collection boys go to their door on due date(eg. 15-11-2016) for collection of money. but they have no money to pay,that's why they call my collection boy after 10 day(eg. 26-11-2016). Now, I want the query in Sql. if …
I am working on a table that will hold batch data. The table will have a BatchDate column as a DateTime type. I'm considering adding a column for BatchYear as an integer and BatchPeriod (which could be a week number, a month number or a quarter number) as an integer, …
How to get values from listview and display it to textbox using sql database ? and then i can update the items in listview using a button..then refresh the listview after i click the button... tnx for the help in advance..im just a newbie in vb.net 
[B]Retreving images from sql to datagrid View windows Forms[/B] Hi i have two colums in table, id and image i have stored my images in the Table ImgTB but the problem is while retreving the images. I just get a red cross.It would be great if some one can help …
Hi I am trying to get count based on the select query using prepare. But i am unable to get the count. Please help to fix the issue. **PDO function** public function getDistictCountRows($filname,$tablen,$condition){ echo $sql = "select $filname FROM $this->db_name.$tablen where $condition" ; $query = $this->conn->prepare($sql); try { $query->execute(); }catch(PDOException …
Hello, I have SQL Yog Installed. I wonder if it is an alternative to SQL Server. I do not have to install SQL Server also at the same time right? Please help me understand how to use it. https://www.webyog.com/ Thanks, Davy
Hi, can some one please help? I want to double-click on a "customer name" in form1 datagridview and then see "customer details" of selected customer on form2.. (in ms access it called "linked forms") I use VS2012 (vb.net) and SQL database.. Thanks, Michelle
Hi! I have two tables, I will call them first-half and second-half (of the year) Table: first id jan feb mar apr ----------------------- 2 80 90 70 60 3 50 40 60 30 Table: second id jan feb mar apr ----------------------- 2 50 70 60 90 3 80 60 50 …
Try Dim cn As New SqlConnection("Data Source=MSR\LOCAL;Initial Catalog=Eventena;Integrated Security=True") cn.Open() Using cmd As New SqlClient.SqlCommand("INSERT into BirthdayRegistration where Name='" & TextBox4.Text & "',LastName='" & TextBox2.Text & "',Email='" & TextBox5.Text & "',StreetNo='" & TextBox6.Text & "',Main='" & TextBox7.Text & "',Area='" & TextBox8.Text & "',City='" & ComboBox1.Text & "',State='" & ComboBox2.Text & …
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?
Hi guys, I am trying to fill a datagridview on the form with data from sql server databse based on the name of the company selected in the combo box. But the code i am using gives me an error message saying "The data types text and varchar are incompatible …
Hello everyone, I need to open mdf file but I can't install SQL server. Please advise how to view data in sql mdf file? Thanks in advance, Richard
Hi Everyone, i am new to programming, i am working on a C# windows form application and used sql 2008 for database and crystal report too. now i want to create setup file including database and crystal report too. so how can i do this, please help me too achieve …
currently I have a survey with 10 questions on a html/ php form. I use post data and then have a long insert statment. My code looks something like this. <php? $surveyid = $_POST['surveyid']; $q1 = $_POST['q1']; $q1comments = $_POST['q1comments']; $q2 = $_POST['q2']; $q2comments = $_POST['q2comments']; $q3 = $_POST['q3']; $q3comments …
I am using ms sql and php. What I am trying to do is display all the records that have the same incident number. I can get the first one to load, but im stuck how to get the rest of them. <?php $serverName = "myserver"; $connectionOptions = array("Database"=>"mydb"); $conn …
I m using vb.net with Sqlserver2014.The under mentioned code works fine at the time of save but in update it works only when i update the picture column, If I want to update any other column it gives the Error: "A generic error occurred in GDI+" Can anybody correct my …
I have a query that get the balance for last month and current month balance. I'm using a function inside the view that took more than 30 minutes. May I ask your help guys any idea or approach to speed up the processing or optimize the script it can be …
Hi Guys, i am building an application in VB.Net with sql server for databases. I have a screen on which the items in a table are populated in a datagridview based on the combo box selection. A button to commplete the sale has a code that must subtract the number …
I have Post code column and I want to get 60, 30 and 10% for each area code that I have, but the thing is there is a between statement which makes things a bit complicated. I need 60% from the first postcode then 30% from the second and 10% …
Hiii I want to use select in select clause this is my statement which got an error: [code=sql]Select count(*) as cnt, (select count (answer_q1) from answers where (answer_q1 = 'ضعيف'))as a_q1 FROM Answers[/code] and this is the error: Error in SELECT clause: expression near 'SELECT'. Error in SELECT clause: expression …
Hello to all! I know well how to access database and its tables from sql server in Netbeans, But know I need to access a report from sql server in Netbeans. For example if I have a table named "MyTable" in sql server 2008 and then I ran a query …
I am banging my head again, and appologise if such a qestion has been posted and answered - i searched and could not see any results matching my question. I have a datagridview1 full of data, one column has a date and another a qty. datagridview1 Date Qty 2015-11-05 | …
Hi everyone! I am in major need of some help here and before I go off and write a SP to handle this for me, I though I would ask here for advice first. I am writing a report to display on our asp.net site using the ReportViewer component and …
Hello! I am working in VB.NET 2010 with SQL Server 2014. Using SAP Crystal Reports i want to make a report in Multiple Master Detail Format. Now I Explain in Detail. In Database i have two tables tbl_Voucher_M & tbl_Voucher_D as master & detail table respectively. Each voucher consists of …
Hello everyone! I have been working on my school project and I have encountered problem linking jTable with a table in the sql server.Can anyone please help me regarding it.Please help me with the code on how to link the the table.
I have a SQL Server bank account table which contains ... ID (Identity) Trdate (Date), Description (Varchar), Debit (Money), Credit (Money), Balance (Money) Details (Varchar) I want to list a subset of the transactions between two dates (the period of an Australian Financial year) and the query below works correctly …
Hey new to JDBC SQL DERBY and Java so I don't know why but my Jtable only shows the columns. Here are my codes for my LeaderboardDAO class. public class LeaderboardDAO extends Dao { private static final Logger LOG = LogManager.getLogger(PlayerDAO.class); public static final String TABLE_NAME = "leaderboard"; private static …
Hi .. I have been asked to create a new thread rather than recurrent on old post ([url]http://www.daniweb.com/forums/thread116468-2.html[/url]), hope to get some help here... :) I would like to have a "Extract" button which then open a Save As dialog to save the file from the Database into local pc, …
Good day I have a table which I have already uploaded a list on however I want to return all the records which are duplicated and have a year between 2014 and 2015, i.e if I have a table like this Year IDNumber FirstName Surname Email 2014 8809254 Tom Jackson …
Hi Dw. What is the correct way to write an sql query like this? `"select * from MyTable where username ='username' And password ='Password'"` in vb.net. My problem is that on my database I have some usernames repeated but they differ by their passwords. Each record has a different information. …
Hi! I have two tables. Table 1 - fields are: no, referenceno, date, marine Table 2 - fields are: no, referenceno, controlno, date What I would like to do is to retrieve the field **controlno** from table 2 when field **marine** in table 1 = "Y". Coding: SELECT NO, REFERENCENO, …
Hello Everyone, I am new to c# and am trying to use Open XML to pull data from a SQL server into a spreadsheet. I followed some examples I found online but had to alter them to fit the test scenario I have set up and have run into an …
Hi everyone! So we have a web application that some of our clients use to manage their account. Part of that means they can manage activities that their registered employees do. Right now we have a table that logs all of a customer's employees activities, even if they don't use …
Sorry i dont know how to explain this properly, but what i'm trying to get across is how do i get sql to select a data type (i dont think thats wording it properly, sorry) which only appears once? Thanks ;p
hello to all! I am developing a data warhouse as my final year project. I have made my star schema succesfully. Now i want to make a query interface for end users so that they run their desired queries. But i am unable to understand that what type of interface …
I have a register page that sends activation link to the registered user however when clicking the lick it takes me back to a register page, please assist ASAP. Bellow is my SendActivationEmail methos please Help. private void SendActivationEmail(int userId) { string constr = ConfigurationManager.ConnectionStrings["LoginDBConnectionString"].ConnectionString; string activationCode = Guid.NewGuid().ToString(); using …
The End.