[microsoft:sql-server] Forum Topics

Hi guys, I am writing some query from winforms. I am getting error with the following query: [CODE] string query = "Select [Doctor Name], Day, DateTime, Med_Sur from Doc_Pat_App where (lower([Patient Name])= '" + name + "') and (DateTime >= GetDate()))";[/CODE] I know that there is no mistake till lower() …

Hai , I have 2 tables 1. [B]Transport_Details [/B]having columns user_id FareStageId StartDate EndDate and 2. [B]Route_Fee [/B]having columns FareStageId monthId fees I need to get a monthwise list by passing monthid. But my problem is that , if start date and enddate of a user are 02-08-2011 and 20-02-2012 …

Hello !! I have a form and some controls as dropdown and textboxes.. The situation is that when the form loads, i want the value in textbox to be incremented, everytime it loads.. This is something i tried.. I get the value '1' everytime !! It shows no sign of …

Hi, Anyone please help me out. Am having a table with field name 'status' with the values 'yes' or 'no'. Really, i wants to change this 'yes' or 'no' status automatically using mssql server. But i don't have an idea to continue on this work. for example, now the value …

hi, I have a form and a button on that form.When the user clicks on the button an MS-Excel sheet is generated from MS-Sql Server 2005 and saved in a particular location.As this generation of excel tkes sometime to complete,what i want to do is i want to show a …

Hi all I have a situation, i have a form that has a datagridview, on form load, it selects the data from sql db, now what i want is when i right click on one row, i should be able to delete that row and it should also get deleted …

Private Sub ComboBox6_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox6.SelectedIndexChanged con = New SqlConnection("Data Source=DEW-D63D9D2D032\SQLEXPRESS;Initial Catalog=system1;Integrated Security=True") con.Open() sql = "Select Faculty_Id From Faculty where Faculty_Name='" + ComboBox6.SelectedItem.ToString() + "'" cmd = New SqlCommand(sql, con) rdr = cmd.ExecuteReader() While (rdr.Read()) fid = rdr.GetInt32(0) End While con.Close() MsgBox(fid) con1 …

Hi, I want to Display My Table Data In Textbox I Have around 20 columns in my Table and I want to display each of that on particular TextBox. How Can I Do this ? I am using SQL Server as Database. Please Give me code for this Thank You

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click strsql = "delete from student_info where Student_No = " & ctrl & "" Dim sqlcmd As New SqlClient.SqlCommand sqlcmd.CommandText = strsql sqlcmd.Connection = sqlconn sqlcmd.ExecuteNonQuery() MsgBox("Student Deleted") Me.fillclasslist() When I try to delete a student in the list …

I am designing a project in asp.net. I one page i have created a gridview having template field as checkbox. When I select any row in gridview using checkbox,that checked row goes to a new gridview on button click. Now what i want to do is to save that new …

Hi Guys, I want create a link for .xls file in sql server like access we can create a linked file. Is it happen in sql server. i have googled this thread but no solution found yet. anybody have any solution... Thanks in advance

Hi Friends I want to set the image to picture box from get sql. I wrote this coding , But Its not Working Properly . [B]byte[] mydata=new byte[0]; mydata=(byte[])dt.Rows[0]["img"]; int arraysize=mydata.GetUpperBound(0); MemoryStream stream = new MemoryStream(mydata,0,arraysize); img.Image = Image.FromStream(stream);[/B] where i wrote wrongly Please tell .. Thanks in Advance :)

I have an intranet using php 5.3.8 on Server 2003 using IIS 6.0 and SQL 2005. I run a command to call a batch file that starts and stops sql server and then calls a stored procedure to delete records from a table Items and then refreshes the records from …

hi, I am working in C# windows application as front end and sql server 05 as back end. I want retrieve image from database. Image,imagenm, image path save in the database. The code given below shows an error message i.e [B]Unable to cast object of type 'System.String' to type 'System.Byte[]'.[/B] …

Hi! I'm new to asp.net.So,I created a simple project to connect it to a database to see whether its working fine. My database contains a table with three fields 1.EmpId 2.EmpName 3.EmpPhoto I created database and entered a row by using SQL SERVER MANAGEMENT STUDIO EXPRESS 2005. I used the …

Guys I have a table with image datatype and I wana insert an image in the image field, for example [CODE=SQL]insert into dbo.Products(ProductID, ProductName, ProductPrice, ProductImage) valeus(144, '8 Gig Lenovo memory Stick', 250.00, 'Image from C:Drive or where ever the image residing')[/CODE] Thanx in advance

hi there, im a beginner really and have just tried to finish a new computer based booking system for my work, im using sql and a database to store the customers and then store bookings too, but im having problems with the customer form, when i run it it kind …

Main Form = Frm_Engineer_Search Sub Form = Frm_Engineers Frm_Engineers populated by Tbl_Engineers I've been trying to link together a textbox with a subform so when a surname is entered into TxtSearch and CmdSearch is click it will run a query/refresh the subform displaying the correct record which correspond to the …

guy i was given a qeustion for my exam that What is the most commonly booked room type for each hotel in London? to this i replied [CODE]SELECT MAX(R.roomno)AS most room selected FROM ROOM.R,HOTEL.H,BOOKING.B GROUP BY roomtype WHERE H.hotelno=B.hotelno AND city='london' [/CODE] my problem is that i dont know if …

hi. I'm trying to make a simple c# program using sqlserver. when i try to save something into database, it gives this error. here's the code. that 15(age value) is the default value on my numericupdown [CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; …

I want to create a SQL login in SQL2005. I tried creating it but it gives me error message [COLOR="Red"]"Create failed for login 'username'. User does not have permissions to perform this actions"[/COLOR] What to do now to create a SQL login in sql 2005

how to get 10 th record from record set using SQL server? there are a lot of code in the internet that can get first 10 results using "TOP" keyword in sql. but i want to get 10th row valus. I'm using VB 2008. please help me.... Regards Pra$ad.

Hi guys, hope you can help. I'm creating a mixture of an employee scheduling system with elements of a Human Resource Management System for small to medium businesses. I ideally want to create a java application with a database backend, which I'm trying to see if I can apply sql …

Hello all, Sorry for asking this newbie question again. But I need to get the server name and all database name on SQL Server. I want to make application, which can switch between server and database quickly. So user can choose server, then input username and password, then the list …

hi all. here's my problem;. I would like to have a macro to export data from an excel file into the database(SQL) for insert and update data purposes. but i'm not sure how to do this.Can someone please show me a code syntax on how to do it?the excel file …

Is it possible to create a stored procedure to delete all records from a table (i.e. DELETE FROM <tablename>), but pass the table name to the procedure as a parameter? My desire is to have only one procedure for deleting multiple tables' records; I would simply pass in the table …

how do i delete all the data which is stored in the sql table???? i want to delete only the data present in one table without dropping the table when i click on the command button in vb6 plz help :(:(:(:( its really urgent

Hi, I am maintaining 100 lakhs record in 1 table often i browse 1 excel from my desktop and import excel into sqlserver.In which there is possibility of same data in that excel that data should be updated in sqlserver and in excel sheet there is possibilty of new data …

I'm new to MS SQL and trying to solve a problem where I need to extract specific data from a remote SQL Server 2005 DB into a local SQL Server 2008 R2 DB. In a Stored Procedure, I'm trying to use Linked Server via Ad Hoc links in the following …

Hi there. I am learning SSAS using Wrox book. I followed the tut in the book to create a project in BIDS (Business Intelligence Studio by Microsoft). Deployed the project in SSAS, which gave success status. However while browsing it in Cube Editors browser pane it gave me error as …

I know this question has been asked dozens of times, but the code I have been looking at has not helped me. So far I have been able to connect to the string and the database from where I need to check the username, but in my page it is …

can any1 say what is the use of cursor?

Hi guys, I am trying to create a table in SQL Server 2005 through simple query which is as follows: [CODE]create table Appointment { Doc_ID numeric(4,0) references Patient(Pat_ID), Pat_ID numeric(4,0) references Doctor(Doc_ID), _Day day, Date datetime, Consultant_Name varchar(40), primary key(Doc_ID,Pat_ID) };[/CODE] but i am getting the error: Msg 102, Level …

Please Help me to solve that i just wana to search Data feilds from SQL Database and to show on different TExtboxes of VB.net forms..... [CODE] Dim Bio As New DataSet Dim Marks As New DataSet Dim Disp As New SqlDataAdapter Dim Dispp As New SqlDataAdapter Dim Bind As New …

hi all. here's my problem;. I would like to have a macro to export data from an excel file into the database(SQL) for insert and update data purposes. but i'm not sure how to do this. can anyone suggest me or give some ideas on how to make it possible? …

As I understand VIEWS - is where the HTML. CONTROLLERS - are the methods controlling views. MODELS - is where the "querying" (SQL) that controllers used? Can I ask for a simple example on how to use this M-V-C? actually the example available didn't help much, just more questions. How …

I have 3 tables: A, B, C. How to insert 100000 rows into table B, while inserting have data is the random data are taken from Table A and C Thanks for help!!!!

Hi, I have a problem with reading a csv file with SQL server UNH+ATOPHOEXEDI+AVLABL' PLD+AII+RE11S' TRV+1+40+DU03+MAN+LCA+20110706:0000:1' ACC+1+SUNNY HILL HTL APTS ?+ POOL 3*:11113+:: PAPHOS+20110706+3:3 STAR++E:1:999' PRC+A:825:3*C:0:1:15+9+5:2475:9:1BDR APT 2/4 INLAND VIEW+2:4++SC: SELF CATERING' TRV+2+40+DU03+MAN+LCA+20110706:0000:7:N:20110713:0000' ACC+2+SUNNY HILL HTL APTS ?+ POOL 3*:11113+:: PAPHOS+20110706+3:3 STAR++E:1:999' PRC+A:4900:3*C:0:1:15+9+5:14700:9:1BDR APT 2/4 INLAND VIEW+2:4++SC: SELF CATERING' . …

Hi! I need some help. Let's say I have 3 tables (t1(id,ds), t2(id,ds) and t3(id,ds)) where the tables don't necessarily have the same id fields. For example: t1 id ds 1 1 2 0 5 7 t2 id ds 8 5 1 2 t3 id ds 9 3 8 5 …

IS this Correct or Please help me to find error, i cant solve that how to see record on my form Dim Slec As New SqlDataAdapter Slec.SelectCommand = New SqlCommand("SELECT Name'=" & txtname.Text & "', CNIC#='" & txtcnic.Text & "', F_Name='" & txtfname.Text & "', College='" & txtdept.Text & "', …

I am trying to connect to a sql database and read from a table to determine if a username is valid upon a user entering in theirs. To just give you a background of the program: 1. The user needs to enter in their username and ID number. I already …

Hi, I currently studying computer science 1st year and I have trouble with practice exercise because I got exam tomorrow can you guys help me Here is my question: I have done some sql query am not sure It correct or not ITEM([U]INO integer[/U], INAME: varchar(10), DEPT: integer, PRICE: float, …

Hi there.! I've been working on our Software Analysis Development project for how many days and sleepless nights, the application is an Online Shopping. I'm using Microsoft Visual Studio 2010 as my environment, then I used C# as language for the site. I used Microsoft SQL 2008 R2 as my …

I am having a hard time figuring out how to delete a row from the datagridview using a datasource that will also delete the row in SQL Database. [CODE] public partial class Form1 : Form { const String sStr = "Server= ************;Database=***; Integrated Security=SSPI"; SqlConnection sConn; SqlDataAdapter daCourse; DataSet ds; …

Hi Morning all, here I've code how to insert data into multiple tables in Sql Server using asp.net C# form but the data unable to enter ang got error, may anyone help fix it form me? because i've tried so many times already but still cannot, there is the code …

i knew every thing about it in couple of days, and when i thought i finished the project (ASP project), i forgot about the deployment part and needed to use the database as local database (SQL server database file) the problem is i cant get the report wizard to connect …

i knew every thing about it in couple of days, and when i thought i finished the project (ASP project), i forgot about the deployment part and needed to use the database as local database (SQL server database file) the problem is i cant get the report wizard to connect …

Procedure is created on SQL server inserting the data from sql server to oracle databse When individually run the query it executed in 10 sec When run through procedure it takes sometime 1.5min and 5min [CODE] CREATE procedure sp_Trade_Book as Begin SET NOCOUNT ON BEGIN TRY --Begin of TRY BLOCK …

Good day to everybody! I just want to know on is there any function/solution in vb6 that offers the best/most fastest way to autocomplete listview when type in a textbox.The data should be from SQL Server using ADO connection...Ive seen this function(I've not tested it yet) from [URL="http://www.vbforums.com/showthread.php?t=438622."]http://www.vbforums.com/showthread.php?t=438622.[/URL] [code=vb] Private …

Hi everyone, so I recently got a position doing web development. Yay. However; web development was not the focus of my schooling and they've hired me with the idea that will learn. In that vein I'm looking for some good online resources or reference books in any of the following …