[microsoft:sql-server] Forum Topics

Having a problem setting up a login form for my project, here's the code: Imports System Imports System.Data.SqlClient Public Class Login Dim con As SqlConnection Dim cmd As SqlCommand Dim rd As SqlDataReader Private Sub dataopen() con.ConnectionString = "Server=IGNITER-PC\OBEXPRESS;Database=EMS;User ID=sa;Password=au" con.Open() End Sub Private Sub EmsStickyButton1_Click(sender As Object, e As …

I have a database wich i made in SQL server managment studio (Microsoft based). I m curious on how would i export my entire database to a webserver? My application is built in visual studio 2012 with C# (c# complitely). It s a University database without cotaining the student's entity(Table) …

I HAVE A SCANERI THAT THER IS DEFAULT ADMIN IN TABLE AND THIS ADMIN ADD FURHTER SUPERVIOSR,MANAGERS AND SENIOR MANAGERS THEN WHEN ADMIN FIRST TIME LOGIN AND CREATE ACCOUNTS OF SUPERVISOR,MANAGER,DIRECTOR AND HERE IS THE TABLE UserID UserName Password UserTypeID DepID FullName CreateDate DocID Email PhoneNumber DesigID 51 Noreen Fatima …

Hi everyone, pls help me with my problem. I got error (OleDbException was unhandled) (sysntax error in INSERT INTO statement) specifically, the error points out in "int temp = oleDbCmd.ExecuteNonQuery();" And, here's my code: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; …

I have been attempting to crack this nut for several hours now but I cannot figure out what combination of query code is required to achieve the exact results I am looking for. I have two tables: Music and Playlists The fields for Music: ID (Primary), Track_Name, File_Path, Date_Added, Artist, …

We just need the save button to save to a sql database. This is done other than that. it is saying, "Error: No suitable driver found for jdbc:derby:charityDB;create=true" import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; // Event listener import java.text.NumberFormat; import javax.swing.*; // GUI building import java.io.*; import java.sql.*; // JDSB …

Why is stored procedure is better than executing a sql query. What is meant by exeution plan

im making an airline reservation system, now my question is how to do the seat reservation with different flight schedule in one form only. I dont have any idea on how to make it but i already make a form which has a 36 seats. so confusing. do i need …

how do i delete,update,add and sort on a visual studio 2013 which is linked to a SQL server 2012 database?

when using a database in a program would it be better to use SQL server or the built-in option in visual studio?

hello dani, I am using shape sql for datareport without dataenvironment conncetion towards parent-child relation ship table. But doesn't work with error. Because parent fields only accepted in my project. I am attaching my vb 6 project to your kind attention please. Option Explicit Dim con As ADODB.Connection Dim rs …

help. i would like to ask if there's a way to combine 2 data table into 1 table without manually inputting using sql statement. how does the parent child foreign key works? it goes like this: student - table1 : lname, fname, age teacher - table2 : lname, fname, age …

Hi all, I have a Windows 7 64 bit client that is running a 32 bit of software and so needs a 32 bit ODBC connection to the database. I of course ignored the Administrative Tools > ODBC manager because that will open the 64 bit and instead went to …

hi all i have made c# project that use sql database and i want publish this project and make a setup file and include sql server program to the setup .. i meen when the project is setup sql server setup too ..

Hey All i really have an issue that it is really stopping me here so basicly i have a form that i use to add some Address Book data so i have combobox's that is synchronized with each other so @ first i'm populating the combobox with the following function …

i have a windows forms with 7 texboxes, i would like to save the input into a sqwl databse , but i am having a bit of problem, this is my code: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New SqlConnection("server = …

Hi Experts I don't have the least idea on how to rank (desc) the following sample ExamScores by CourseID , grouping by Level. Some help needed. gbhs Newbie Level StudentID CourseID CourseName ExamScore ScoreRank A 101 1 Math 11 A 101 2 French 3 A 101 3 English 7 A …

I know that this question is asked a lot but still can't find the correct answer. I have a database on SQL Server 2012 Express Edition, that I need to protect the information and its structure. What's the best way to do it? Is there any way to protect the …

I've written an SQL select statement. I've checked te statement in SQL Server Management Studio Express and it works greate. When I go take the code to my asp page and insert it, I get a generic IIS 500 error. When I take out my variable I'm tyring to use, …

using vb.net and sql query i need to join multiple tables to view in one datagridview control .In each table i need to take only one field and want to dislpay all in the datagridview control...can anyone provide me the apat code for this

Imports System.Data.Sql Imports System.Data.SqlClient Public Class Form1 Dim connetionString As String Dim connection As SqlConnection Dim adapter As New SqlDataAdapter Dim sql As String Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim connetionString As String Dim cnn As SqlConnection connetionString = "Data Source=obeng\obeng;Initial Catalog=mangementsystem;integrated security=true" …

hello i have a table "employers" Employerid int InsuranceNumber varchar(10) Ministry nvarchar(100) Adress nvarchar(250) PostalCode varchar(50) Phone varchar(14) Mobile varchar(14) Email nvarchar(60) UserName nvarchar(50) Password nvarchar(50) ContactPerson nvarchar(250) EntryDate datetime LastUpdateDate datetime IsDeleted bit Active bit and i have created how to insert data using insert stored proc Create procedure …

.i'm dave and i'm working with some receiving and m0nitoring system like.,i develop a system but it is a individual machine or a stand alone system,which means it w0rks only on a single pc,.my problem is i want to convert it to be a client server system which i can …

i am using a store procedure to access field in asp.net View, i am putting db columns in HTML table, it's workign except for one field, 'NetSalary'. It can't be accessed, it says that model doesn't contain it. i tried many ways but couldn't get to work. ALTER PROCEDURE [dbo].[GetMonthlyReport] …

What is the main difference b/w Mysql and Mssql?

i retrieved my values in a default array from sql query ,, bt evn if i have one element in my array m getting a list of items ,, y ? can anyone help me

pls i need someone here to help me with the coding trend am using. this is an example of my code inserting data in to sql server 2008 table... Public Sub insertStocks(ByVal serialNumber As TextBox, ByVal itemcategory As ComboBox, ByVal itemname As TextBox, _ ByVal dateofmanufacture As DateTimePicker, ByVal dateofexpiry …

I am am experience Mainframe programmer, but new to SQL-Server & learning vb.net so I realise that this is probably very basic ... I have a DataTable called MailTypes which contains 2 Columns, the ID & the Name. I have a DataTable called Leagues which contains a lot of Columns, …

I was wondering, how do I make it so users can login. I have an SQL database, I have a VPS, I have a VPS. I just need help setting it up and adding an account.. This is the login form: Public Class Form1 Private Sub FlatToggle1_CheckedChanged(sender As Object) End …

Hi all, I have two tables in a database. Both have columns named "Company Name". I want to compare between these columns for any similarities in their names. For Example : Table1.CompanyName = 2i Ltd /// Table2.CompanyName = 2i Limitied. Thanks Gilbert

i installed PHP version5.4.3 SQL server 2008 IIS7 SQLSRV version3.0 Drupal 7 SQLSTATE[42S02]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'watchdog'. This error occurs right after the following during Drupal 7.26 installation (shown in the error report). It hangs at the start of Install Profile: Installation tasksChoose profile(done)Choose language(done)Verify …

   Hi, I have a below table of Content CUSTOMER ID QUESTIONS ANSWER 1 FirstName John 1 LastName William 1 Country India 1 Zip Code 60000 2 FirstName xxxx 2 LastName yyyy 2 Country US 2 Zip Code 123456 3 OrgName ABC Pvt Ltd 3 …

I have an old access 2.0 database, i converted it in access 2007 but the old code doesn't work.. i heard that it is about DAO and ADO anyone can help me to convert this DAO code to ADO coding.. thank you so much in advance.. Private Sub cmdSave_Click() Dim …

hello everyone, im pretty new in this language (vb.net) so i have difficulties understanding its function, right now i am able to populate my database to datagridview, i've been looking for some related answers. but found no luck. so i decided to post it in here. so i have this …

Error that I get: ERROR [42000] [Microsoft][ODBC Text Driver] Undefined function 'REPLICATE' in expression. Code below: DataTable dt = new DataTable(); string tempPath = @"C:\swd\"; string strConn = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + tempPath + @";Extensions=csv,txt"; string SqlString = "Select RIGHT(REPLICATE('0', 10) + RowNr, 10)," + "RIGHT(REPLICATE('0', 10) + …

Hye dude, Really need help. My problem is I want to insert data from treeview checkboxes into database. Currently im using an array, but when i insert the value it become double. for example, when i click two checkbox. the id insert in database will be two. Can someone help …

how i connect my php pages with sql server 2008, where i use xampp as web server...

See i have two table named Studentmaster-rollno,name,permanentaddress1,permanentzipcode studentacademocdetails-rollno,dptname,status,programid I want to select roll no of a student with permanent address like "chennai" and permannet zipcode=60004 and from second table i have to select dptname,status where status will be like('c','f,,'t','k') I tried a query as follows SELECT t1.rollno,t1.firstname,t1.permanentaddress1,t1.Permanentaddress2 ,t1.Permanentzip, t2.departmentcode, t2.status,t2.programid …

i am calling store procedure from MVC, which returns single record only. SP contains: PROCEDURE [dbo].[GetMonthlyReport] @emplID INT = NULL, @month VARCHAR(50) = NULL AS BEGIN IF (@emplID IS NOT NULL AND @month IS NOT NULL) --If Block begins BEGIN SELECT * FROM MonthlyRecord WHERE Month = @month AND EmplID …

how to create a report with data from duatabase on the same server or different servers, using SQL Server 2000, using the **crystal report 8.5** or **data report of VB6 ** For example I have table A and table B with the same table structure, table A is stored in …

Hi.. i want to get all columns from tbl_class where course_id of tbl_course is equal to course_id of tbl_class more over course_id of tbl_course should be thw one who has semester = 5 brife structure of tables are: tbl_class >class_id >course_id >class_room tbl_course >course_id >semester i have design this kind …

Hi guys, I have worked with PHP and MySQL before and recently I wanted to try and learn ASP.net MVC since some of my friends are using it in the work place. But the most confusing thing about this is, why does all the tutorials out there not mention how …

I have 2 tables in sql , one is called stock and the other stock warning the stock table has columns ' Pid, pdescr,current stock, stock warning' this shows up in datagridview 2nd table(stock warning) has columns 'pdescr, current stock' showing in datagridview in the stock table when the 'current …

this query was working fine but when added OverTime part then it started throwing error: Msg 8117, Level 16, State 1, Line 52 Operand data type varchar is invalid for sum operator. with times as ( SELECT t1.EmplID , t3.EmplName , min(t1.RecTime) AS InTime , max(t2.RecTime) AS [TimeOut] , t4.ShiftId …

Anyone help me to create one form with C# WPF which use LINQ TO SQL with SQL Server. WPF -------------------- Form has 2 textbox and 1 image in WPF txtFirstName txtLastName Image SQL Server Database -------------------- tblEmp EmpID - int Firstname - nvarchar(10) Lastname - nvarchar(10) Image - image, varcharmax …

This query shows emplName,emplID, totalworking time, InTime, OutTime, DateVisited, Overtime for an employee based on his InTime and Outime, that's OK. Now i am trying to modify it to show only emplID, EmplName, Total Working hours(Per month), total overtime (per month). e.g. Empid EmplName TotalWorkingHours TotalOvertime Month 00001 John 77:00 …

i have written this query to show total working time and overtime of an employee on particular date (if he has came) otherwise it doesn't show record for a person if his INTIME and TIMEOUT are empty but i don't want this now, i want if for a particular date …

I created a three layer application with BO (Business Objects), BLL (Business Logic Layer) and DAL (Data Access Layer). I had to do some unit testing using nUnit tool. I've done that like following and works perfectly: SQL Tables: USE [Projekti_TI_1] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO …

Hi Guys, I am planning to create one application that has 3 different Layers (clients) and each Layer has a same copy of an application and multiple users. any suggestions? Example : Application Client1 (has copy1 of application)(has n users) client2 (has copy2 of application)(has n users) client3 (has copy3 …

cmd = new SqlCommand ("select beggining_school, end_school FROM Student,student_weekend,Weekend WHERE Student.ID=student_weekend.studentID AND student_weekend.WeekendID=Weekend.ID ", con); I just want to say that i don't have any problem concerning my code functionality. I would just like the design to be like the above example.That is, I dont'want my whole sql expression to …