[microsoft:sql-server] Forum Topics

Hi, i am developing an application in C#,i have create database1.mdf by right clicking on my project,add item then creating a database. my intial problem was,i was able to execute query correctly but those modification wasn't reflected in main database finally after lot of surfing i changed copy to output …

I am planning to create a program with some graphical representation of data from SQL database. What language to use to create graphs?

Here's my product table. [id, name, price, description, unit] For example. I want to edit only the name and description. How can I do it in mvc?

Hi everyone, I have been strugling wit the "INSERT INTO" statement. I intend to insert the items that are in a datagridview into An Access Database when a button is clicked. I am using VB.NET 2008 express and Microsoft acces 2007. At first, I tried to use the listview, but …

Hi , i need a sample code for Export data from MS-SQL to Notepad.txt using vb.net in Pipe line format this is my sample table data ID Name Address 1 Meenu Meenuhouse 2 Ammu MeenuHouse 3 Chinnu Meenuhouse i need output like 1|Meenu|Meenuhouse 2|Ammu|Meenuhouse 3|Chinnu|Meenuhouse Can any one help me …

hi. few days ago I open a microsoft azure account and create a virtual machine. download SQL server managment and do everything ready. open TCP port 1433 and my DSN name is btca.cloudapp.net now I cant connect with the database inside it... what to do. Im looking everything but nothing …

hi. few days ago I create a Azure account and create a Virtual machine. download and install SQL server managment, open TCP port 1433. but cant connect to my app.. my DNS is btca.cloudapp.net but cant connect. tried to connect with DSN & IP but nothing happening. any suggestion?

hi. few days ago I create a Azure Account and create a Virtual Machine install SQL server managment. open TCP port 1433. but now I cant connect to my app... my DNS is btca.cloudapp.net but cant connect the code with the database... please help me...

Hello everyone, i have the code below, it works fine but whenever i insert a student number that does not exist in the table, the rest of the textboxes will keep displaying data from the previous existing entry. This happens even when the i delete everything in the student number …

So I have this simple query that if I run it on sql server management studio it gives me results. Select name, count(*) As thecount from Restaurants group by name I am using codeigniter and a wrapper library for datatables called [ignited datatable](https://github.com/IgnitedDatatables/Ignited-Datatables/wiki/Function-Reference) . I am using it because its …

Hi guys I make program to select data every day automatically by timer every second in c# In sql server 2005 i write the following query ALTER proc [dbo].[JeddahSalesAll] as SELECT ROW_NUMBER() OVER (ORDER BY dbo.[Jeddah-Live$Sales Header].No_) AS [S.N], dbo.[Jeddah-Live$Sales Line].[Document No_] AS 'OrderNo', dbo.[Jeddah-Live$Sales Header].[Bill-to Name] AS 'CustomerNo', dbo.[Jeddah-Live$Sales …

Hello again. as some of you may know Im creating a software based on SQL dataserver, every code I use is good and work and I use this connection string Dim conn As Data.SqlClient.SqlConnection conn = New Data.SqlClient.SqlConnection("Data Source=192.168.0.100,1433;Network Library=DBMSSOCN;Initial Catalog=SS;User ID=Al;Password=altn") But the ip is the other pc (next …

SQL Gurus, help !! I have a table with 3 fields, ID, Answer_5, Answer_6. Answer_5 & Answer_6 both hold a date value, but the fields are defined as string (for other reasons). In Answer_6 it is possible to have the string of 'Now'. I am trying to do a simple …

I have a GridView that is populated with information froma sql table. The first column of the table has a number (0,1,2,etc.) that corresponds to a folder on the network that contains multiple documents. After the table is generated with all the information from the sql table, I want to …

From what I understand a DBMS is a software that manupulates a database. I am developing a retail checkout system which is link to a SQL database. Is that consideres as a DBMS?

hi guys, i have the following code: "select sum(( receiptDetails.retailprice - receiptDetails.purchaseprice)* receiptDetails.itemcount ) + ((customerReceiptDetails.retailPrice -customerReceiptDetails.purchasePrice)* customerReceiptDetails.itemCount) As Total from receiptDetails,customerReceiptDetails " am trying to get the gross profit from the two tables: receiptDetails and customerReceiptDetails. the query works well if both tables have values. i tried to use …

I have a folder that contains x amount of files with different extensions, I need a way to retrieve all the files with the name 0000001 regardless of their extension, i then have to work with these and then retrieve all files with the name 0000002. I know I can …

How to log-in in MVC uing sql server? Any recommendation?

Hello How I can retrive table names from SqlData base I Just connect to DB. and now I want to display all tables name in combobox. how I can do that?? thanks

Hi, Im trying to use a multi column combobox from this thread [Here](http://www.codeproject.com/Articles/8619/Flat-MultiColumn-Combobox-with-Autocomplete) Just wondering if there's a way to show Column header from its datasource (sql) Can't find a property to do this Thanks

I want to ask how to update data in database? I'm using the code as the below. string value1 = TextBox1.Text; string value2 = TextBox2.Text; string value3 = TextBox3.Text; string value4 = TextBox4.Text; string value5 = TextBox5.Text; string strsql = "Update Form Set Name='" + TextBox2.Text + "', Designation='" + …

I have this gigantic query that returns certain data from my MSSQL Database (working perfectly- Courtesy of djjeavons). I want to sort and arrange this data in order. I want if the user selects a range of dates from the form (ex. November 1, 2014 - November 9, 2014), the …

> So basically I just started learning to use Windows forms with c++. I am creating an inventory/point of sale system. I have done the inventory part but now I want to do the sales part but I'm not sure how to go about it. I want to create a …

Hello... Im having a problem with "like operator" on SQL database Im using this code to search on database Dim DV As New DataView(dbDataSet) DV.RowFilter = String.Format("ID Like '%{0}%'", TextBox1.Text) DataGridView1.DataSource = DV and at textbox1 I type 2 in data grid view show all people who have number 2 …

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...

private void btnSearch_Click(object sender, EventArgs e) { if (searchtext.Text == "") { MessageBox.Show("Plese Inter Employee's ID you are searching for"); searchtext.Focus(); } else { OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\Employees.mdb"); OleDbDataAdapter ad = new OleDbDataAdapter("select * from Employee where EmpID=@EmpID", con); ad.SelectCommand.Parameters.Add("@EmpID", OleDbType.Integer); ad.SelectCommand.Parameters["@EmpID"].Value = int.Parse(searchtext.Text); DataSet ds = new …

I need to know how the Recursive Common Table Expression works I have a table called Project table which consists of a collection of projects some of them are parent projects and the other are child projects also the child projects may be parent for other child projects and so …

I just posted an [article](https://www.daniweb.com/software-development/vbnet/threads/493564/windows-10-and-secure-boot) in Hardware & Software -> Microsoft Windows with the title "Windows 10 and Secure Boot". I added a few tags in the Tags field and when I submitted I was told "You do not have permission to create new tag(s): 10". I was told the …

Hi, I have a dgv displaying records from an SQL database. On load, the dgv is filled, the dgv selection cleared and the 'action' buttons set to enabled=false. When the user selects a row (cellclick action) the 'action' buttons are enabled. When the action button is clicked the dgv is …

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

I'm trying to do a simple a database SQL script where I simply need tocreate a database as well as 4 tables within. So far I'm getting a very annoying error that states: There is already an object named 'DEVICE_TYPE' in the database. Why, I don't know? Any help regarding …

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 …

Hi friends, I am using MSSQL Database, it has more than 13246 reconds in a table. I am trying to display it in a table with bootstrap. But i am unable to load my datas. can any please help me how to resolve this my code is below <?php session_start(); …

I am developing a social networking website using a**sp.net mvc** and sql server 2008. I need reference links, sites or reference books which help on knowing what are the best practices, code patterns and best third party tools to integrate and work on. Any suggestions from you people will help …

I HAVE A QUERY THIS IS PRODUCING THIS RESULT. EVERYTHING WORKS FINE BUT WHAT I WANT TO ACHIEVE IS SLIGHTLY DIFFERENT. INSTEAD OF HAVING REPEATING IMPORTERS, I WANT TO GROUP THE IMPORTERS/DISTRIBUTOR SO THAT NOTHING CAN REPEAT AND HAVE ALL THE BALANCES IN THREE SEPARATE COLUMNS. BELOW IS MY TABLE …

Hi , members please tell me how can i control Data Entry in 3 different table with BeginTranaction / Commit /Rollback in vb.net 2008. i am using sql server 2000 at back end and used SqlClient,SqlConnection, ExecNonQuery method. Thanks Zia

SELECT BANK ACCOUNT.*FROM BANK ACCOUNT ORDER BY ACCOUNT NAME What is the missing operator here? In sql statement, pls I need help

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 …

I am calling data from my database but the result is not what I want. Below is my code: Select distinct concat(ImporterDistributor.name, '/', ID.name) as [Distributor_Importer], case when Product_Delivery.Product=1 then isnull(max(Product_Delivery.Opening),0) end as OpeningPMS, case when Product_Delivery.Product=2 then isnull(max(Product_Delivery.Opening),0) end as OpeningAGO, case when Product_Delivery.Product=3 then isnull(max(Product_Delivery.Opening),0) end as OpeningATK …

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 am quite new to SQL but I was wondering how to achieve the following. How do I get specific values that fall in the year 2013 when the date format in the table is looking something like this: 1 94 pH 02-02-2012 11:48 AM 1200001 2 103 pH 09-06-2012 …

I want to know how to achieve the following: I want to convert a varchar to a date format but so far I'm not very successfull... My date (varchar) looks something like this: 02-02-2012 11:48 AM And I want to convert it to the following this: dd-mm-yyyy To be able …

Hello, Code Masters, Here I am again today going to seek help and guidance from you. I have here a manually assigned values to arrays 0 - 19 now my question is, how can I assign values to each array coming from the SQL database? The catch is, it is …

Hey I need some help here i have created a easy login with registration that save the password in plain text but now i want it to be hash and salted but i do not now how i can do this. This is the code for login: try { SqlConnection …

suppose i need to make update the employee as following CREATE PROC UPDATE_EMPLOYEE ( @EmployeeID INT, @EmployeeName NVARCHAR(50) ) AS update Employee set EmployeeName=@EmployeeName where EmployeeID=@EmployeeID Suppose I have two useres A,B A modified or edit using stored procedure above employee no 5000 field EmployeeName B need to modify employee …

How can i count the vote of the voters, i used dropdown tool to choose a candidate, and my database in MS SQL SERVER 2008... please help my in my project....

Hi Im new with this and tryng to learn thru reading any sources in internet, but i have no idea where to find a solution to my problem. Every time i save or update a new entry to my database it working find but when im trying to search the …

I have the following view: ALTER VIEW [dbo].[vw_RelInclusaoGeralCivil] AS SELECT DISTINCT m.Nome AS MunicipioNome, au.Nome UsuarioNome, s.TipoId AS SolicitacaoTipoId FROM Solicitacao s INNER JOIN Unidade u ON s.UnidadeEntregaId = u.Id INNER JOIN Endereco e ON u.EnderecoId = e.Id INNER JOIN [IBGE.Municipio] m ON e.CodMunicipio = m.CodMunicipio INNER JOIN Terminal t …

I worked on a program a few years ago that takes data from a series of text files and loads an Access database. I added to the code from a program started by someone else, so I did not write the imports and declarations. They used an ADODB.recordset, addnew and …

Split pipe delimited into new columns as below : col1 col2 col3 col4 Data|7-8|5 Data 7-8 5 Data|asdsad|sad Data asdsad sad fish|c cx cx xc cc xc cx |ededededeed fish c cx cx xc cc xc cx ededededeed Data|iueroiheqroqer|ewoijewijewd5 Data iueroiheqroqer ewoijewijewd5 tune||5 tune 5 Data|| Data check http://stackoverflow.com/questions/19688863/split-pipe-delimited-into-new-columns