[microsoft:sql-server] Forum Topics

In my personal opinion PHP is a great language. I love that it can be written with html and css for style, and database and such quality. But why do PHP deevelopers earn less then other types? PHP helps get the website through sql and helps make it interactive. You …

I need to insert a cobobox value ,date value into database but am not sure if this is the method...i keep getting an exception saying 'Incorrect syntax near '@Numberpassengers'.' private void button1_Click(object sender, EventArgs e) { string c = ""; string s = ""; string d = ""; string t …

Hi i have issue in stored procedure converting data type Destination table dbo.Z_tbl_CirculationCopy_TEMP has numeric data type But source table Z_tbl_Import_temp have VarChar Type If I export data from source, I have error message Msg 8114, Level 16, State 5, Procedure Z_usp_IMPORT_EXCEL_UNPIVOT_1, Line 10 Error converting data type varchar to …

I'm working with a MS SQL database that was done by another developer. Im developing a website that interacts with that database. I need to use a stored procedure called LoginR that takes 3 input parameters (LoginName and Passwords) and returns the NickName in the third value. But also, has …

Have an inbound campaign. Agent gets the phone number from customer and I need to create php code to search that number in a table in Sql, display name, address and insert ANI, date, start time, end time of the call, agent-id and result code. All I know about php …

I have read from different forums, PHP website and Microsoft website how to connect PHP to MS SQL Server but the provided solutions didn't worked for me. If you could help me in this would be greatly appreciated.

I have not completed the code ...but why am i getting error inside while loop saying cannot convert string to int...when i am not converting string to int namespace book { public partial class car : Form { public car() { InitializeComponent(); } void FilCombo() { SqlConnection conn = new …

hello everyone, i have a datagridview filled with a dataset and i want to store all the records it has to new table in database. i added a new column,("pos") to a dataset that fills the datagridview through a query so that it ranks records based on a field (total).my …

Hi guys, is it possible for me to downgrade server . i tried to restore .bak file from 2008 r2 to 2005 but it has a compatibility error./ can anyone could help me on this matter. Thanks in advance .

using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace book { public partial class login : Form { SqlConnection conn; SqlCommand cmd; SqlDataReader reader; public login() { InitializeComponent(); } private void button2_Click(object sender, EventArgs e)//MY login button { string constr = @"Data Source=PRAVEEN\SQLEXPRESS;Initial Catalog=travelbooking;Integrated Security=True"; conn = new SqlConnection(constr); conn.Open(); cmd = …

Hi! My database is in AS/400 DB2 hence, I am using SQL. Here's my line of code for opening a connection. Dim str As String = "User ID=EDITH;Password=EDITH;Data Source=10.0.1.11;Initial Catalog=ictms;Integrated Security=True" Dim conn As SqlConnection = New SqlConnection(str) conn.Open() Now, I wanted to execute a delete query, however, I already …

Hello, I am trying to change a column from "Null" to "1" in the SQL database. I have tried many things but everything has failed so far. I have tried foreach statements: foreach (DataRow dr in dt.Rows) // search whole table { if (dr["ColumnName"] == null) { dr["ColumnName"] = "1"; …

Hello Friend's, step 1: I trying textbox data 1st insert in grid. it's clear but step 2 : Grid data not insert in data base. it's code here protected void btnsavedata_Click(object sender, EventArgs e) { foreach (GridViewRow g1 in gvloan.Rows) { SqlConnection con = new SqlConnection(conString); SqlCommand com = new …

I am trying to insert records in a SQL table from Excel sheet with VBA code. Data contains of a range with all the rows to be inserted. I am using below code for the same. Insert INTO [odbc;Driver={SQL Server};Server=myserver;Database=mydb;Uid=abc;PWD=abc].DPR Select * FROM [TempRange] I am getting error as above. …

I want to import/upload excel files to sql server via cake php, it will occur Undefined variable: ext and Undefined index: the code are shown as below. Is there any mistake in my code? Thanks in advance! <?php App::import('Vendor', 'php-excel-reader/excel_reader2'); class UploadsController extends RealTimeAnalysisAppController { public function upload() { $destination …

Hello everyone I have a windows form application in Visual Studio 2012, with a datagridview. I need to save new data on this datagridview to a SQL database. Could anyone help me with the code or a procedure. The database name is PRISOON, and the table records to be added …

I have vb.net application with SQL server express. Here is my code to save data to database, but itn not working. Here ID is not the primary key. Imports System.Data.SqlClient Imports System.Data Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click Dim cmd As New SqlCommand Dim …

Hi guys I tried to to use inner join on 5 tables it worked but the problem is instead of getting the exact sum values it got doubled. Here's my code cmd = New OleDbCommand("SELECT om_list.invoice_no as invoice_no, om_list.internal_id as internal_id, om_list.customer_id as customer_id, om_list.account_name as account_name, om_list.seller_name as seller_name, …

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

Hi i am trying to display records in access database that have pictures saves binary data i have created typed dataset that populate the crystal report but the problem is the images do not display code is as below i have attached sample report Imports System.Data Imports System.Configuration Imports System.Data.OleDb …

I have vb.net application with MDF-Sql database. I retrieves data from Table in MDF-Sql into datagridview by TableAdaptermanager/binding navifator. Although it displays data but when I want to save by this code, its not working.This code is working in vb.net with OleDb application but not here. Is there any another …

In true Microsoft fashion they have made the download process so counterintuitive that your chances of getting what you want is near impossible. Fortunately someone has created a "simple" [12 step process](http://www.istartedsomething.com/20140616/the-12-step-process-to-download-microsoft-sql-server-express-2014/). For yuks, see also [here](http://www.istartedsomething.com/20121216/downloading-sql-express-2012-from-microsoft-com/). And to see how little things have improved see [Bill Gates Chews Out …

Here's my **formview**.. <asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1" DataKeyNames="recid"> <EditItemTemplate> RECID: <asp:TextBox ID="recid" runat="server" Text='<%# Eval("RECID") %>' ReadOnly="true" /> <br /> SHIPPER: <asp:TextBox ID="shipper" runat="server" Text='<%# Bind("SHIPPER") %>' /> <br /> <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update" /> &nbsp; <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" /> </EditItemTemplate> </asp:FormView> here's my **sqldatasource1** …

**Parse error: syntax error, unexpected T_VARIABLE in this line "$validate_user_information = sqlsrv_query "select * from `userinfo` where `badgenumber` = '"$user_ssn"'";" //Login Page Starts here elseif($_POST["page"] == "users_login") { $user_ssn = trim(strip_tags($_POST['badgenumber'])); $validate_user_information = sqlsrv_query "select * from `userinfo` where `badgenumber` = '"$user_ssn"'"; if(sqlsrv_num_rows($validate_user_information) == 1) { $get_user_information = sqlsrv_fetch_array($validate_user_information); $_SESSION["VALID_USER_ID"] …

I Have Local Hosted My ASP.Net Website By Following Steps 1. Open Visual Studion and Open Website 2. Go to Build Menu and Publish Website 3. I have Published it To C:\Inetpub\wwwroot 4.I have Created Virtual Directory Targetting Published Folder 5.When I am Trying to Run On Web Browser The …

hi i need to show employee attendance based on device logins with employess various information like department,designation,device_person_id,person_id,logid etc..... joining 3 tables i.e dbo.tempdevicelogs,dbo.employee_settings,dbo.persons_profile i tried this one Select Device_Person_id,personal_id,Date1,( cASE WHEN eXISTS( SELECT Device_Person_id FROM tempDeviceLogs AT WHERE T.personal_id=AT.Device_Person_id AND T.date1=AT.logDateTime ) then 'P' Else 'A' End )as Status FROM …

I have a specialization hierarchiy with one parent table and two children. I am in a situation where one column in the child table is a pk, fk, fk and unique. TICKET_NUMBER = pk, fk1, fk2, u1 This is how I have currently tried to create this table but im …

Hi all, I get 'Invalid string or buffer length' exception when trying to do this. String s=resultSet.GetString(1) Exception: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6956) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7113) at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3906) at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5697) at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:353) at sun.jdbc.odbc.JdbcOdbcConnection.buildTypeInfo(JdbcOdbcConnection.java:1503) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:381) at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174) at java.sql.DriverManager.getConnection(DriverManager.java:579) at java.sql.DriverManager.getConnection(DriverManager.java:243) at Controll.Test.sselect(Test.java:72) at …

Hi Everyone, I have been asked to write some ASP that will interface with an MS SQL 2008 R2 database; with the intention of simply reading data from several tables (using SELECT). This is meant to be an easy task, however after delving into ASP .NET today I have quickly …

Hello everyone, Im very new to c++ and dont have very much experience. But Im working on a programm and for that programm I need ms sql connection. Ive already googled much but I couldnt find what I need. Now I would like to ask here if someone know where …

Hi all, i encounter an syntax error "Syntax Error in Insert Into" when i try to run this code... anyone can assist? Thanks! Dim sConnectionString As String sConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=H:\Users\Desktop\EmployeeAway2.xlsx;Extended Properties=""Excel 12.0;HDR=YES;""" Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString) objConn.Open() Dim objCmd As New System.Data.OleDb.OleDbCommand() objCmd.Connection = objConn …

These are my prerequisites software: * Crystal Reports * SQL Server 2008 Express * Windows Installer 4.5 * .net Framework 4 full The problem is Crystal Reports installation is first and it needs Windows Installer 4.5 and the .net 4 Framework. So the order of prerequisites must be like this: …

I NEED TO WRITE A CODE IN VB.NET , THAT LET ME EXPORT DATA FROM ACCESS DATABASE ( THE TABLE ATTACHED AS IMAGE ) AND IMPORT IT INTO SQL SERVER 2008 R2 . **NB : TAKING INTO CONSIDERATION DUPLICATION ** Example : if you see in the image the access …

A warning: I'm very new to databases! Hopefully this will be a pretty simple question. To simplfy my problem, I have a tree of 'meters' that collect data (Let's say electricity meters). I'd normally structure this with objects in a tree, each with a list or some kind of array …

Working with Microsoft Visual Studio 2010 Professional, using C#, with Microsoft SQL Server 2008. I have been tasked with taking an existing application, and making changes so that it can receive multiple languages in its text boxes without needing to configure ahead of time what language is to be used. …

I do not know what seems the problem in my code. I want to add the data to my database (using windows form) but whenever I refresh my database, no updates were observed. Thank you for your help. Here is my code: public void btnSave_Click(object sender, EventArgs e) { string …

Good morning everyone! I haven't been here in a while, but I have a question that I thought someone here might be able to help with. When it comes to accessing data from a SQL server, I know the logistics of getting that data through code, no issues there, but …

I have created a table in sql server, an insert stored procedure, a aspnet webform with 5 text boxes to edit the parameter values, a label to display the output identity value from scope identity and another label to display the inserted or not inserted report from the execution of …

Hi I am trying to upload excel file data thorugh .net uploading code. But i am getting an error message. can any one please help me to resolve this. **Upload.aspx** <%@ Page Language="C#" AutoEventWireup="true" CodeFile="add_residentupload.aspx.cs" Inherits="add_residentupload" %> <table class="table-list"> <tr> <td width="30%">Upload File</td> <td><asp:FileUpload ID="fupUpload" runat="server" /> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" …

Guys, I am trying to learn asp, but I am stuck on this error forever... I managed to display and create new, but I can't delete and update. I was told I had to remove the ' around cid, but it still gave me another erro. can someone please provide …

Hello I have started my first ever VS Web page today and have two pages open in the software: Register1.aspx and Web.config. I am hoping to devise a simple 'new user registration form' with three fields: username, password, and email. When the 'submit' button is clicked, those three fields should …

Well, im a beginner and im having some problems with the code. On the display it shows System.Data.Objects.ObjectQuery 1[System.String]. Im stuck. I will be grateful for your help. private void grdProdukti_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { if (e.ColumnIndex == 1) { int PID = int.Parse( e.FormattedValue.ToString()) ; grdProdukti.CurrentRow.Cells["Produkt"].Value = from tretmanProdukt …

I am trying to establish a connection with sql server but i am not able to do so. Can some one help me out?

I Have one table in sql Date Day Start Time End Time Subject Teacher 2014-06-02 Monday 2:30 PM 04:30 PM Maths Mr.Smith 2014-06-10 Tuesday 2:30 PM 04:30 PM Science Mr.Ayar 2014-06-16 Monday 2:30 PM 04:30 PM Maths Mr.Smith 2014-06-02 Monday 3:30 PM 04:30 PM Maths Mr.Smith I want to make …

Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Stylus T10 1 1 Repair 1 2 Monitor 2 HP 1 2 Repair 3 3 ViewSonic 2 I need to count how many printers, Monitors etc. are …

Hi, I have a data, employee attendance record with following format > 01-0002,I,4/21/2014,07:34:00 01-0002,O,4/21/2014,18:09:00 01-0002,I,4/22/2014,07:47:00 01-0002,O,4/22/2014,18:09:00 01-0002,I,4/23/2014,07:54:00 01-0002,O,4/23/2014,18:07:00 where I is in and O is out The table contains lots of records for this saves records from the start how can i search a record with no In or no …

I have 3 tables --Ticket_Lines (parent), Labour_Items (child), Part_Items (child). Table Ticket_Lines has 2 primary keys (ticket_number & ticket_line_number) I know that you cant have two seperate primary keys in one table so would this mean that ticket_number and ticket_line_number is a composite primary key? if that is correct, is …

how do i insert the textboxes with different data inside of them in one database table i have this code dunno what to do next Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click Dim sql As String Dim totcount As Integer = 0 Dim inc As …

Hi I have the following code that uploads images and other files to an SQL Server DB on GoDaddy via a FileUpload Control on an aspx page. Public Function InsertData(ByVal cmd As SqlCommand) As Boolean Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString Dim con As New SqlConnection(strConnString) cmd.CommandType = CommandType.Text cmd.Connection …

Dear All, I am using ASP.Net with VB.Net Visual Studion 2010 I have a textbox if I write i.e. 654321-1 and immediately it verify from database table that this is already exists in database or not. Suppose on Gmail if we create new email address it immediately verifies from database …