[microsoft:sql-server] Forum Topics

Hi, I just figured out how to use the report wizard in visual studio 2008. Now i wish to know how to use the report by using sql queries. pls help :)

hello guys... I read some articles to deploy my web site on IIS 7 which I followed exactly I was told to. Now simple aspx pages are deployed successfuly but web applications that have database with it, are not deployed as expected. For example, I have stored my user name …

Hi people, I have created a form that allows me to search customers from a datagrid table which holds the information from the customers table. I use a textbox to enter the phrase to search for and a search button. I can find the records within the datagrid table but …

Hi to all, I created the following table --------------------------------- create table publisher(name varchar(20), city varchar(20)) --------------------------------- I want to put following constraint, 'name is having unique with city taken only from 'mumbai', 'pune', 'nasik', 'panji''. I know about unique constraints with name. I searched many about constraint with city, but …

I am able to save an image from a picture box into the database of SQL. I used a byte array and filestream to read the image. [CODE]FileStream fs = new FileStream(imagename, FileMode.Open, FileAccess.Read) byte[] picbyte = new byte[fs.Length] fs.Read(picbyte, 0, System.Convert.ToInt32(fs.Length)) fs.Close()[/CODE] For some reason, I can't retrieve the …

Hi, Not sure if my question belongs in an ASP.NET or MSSQL forum.. I have an ASP.NET webpage built in VS2010 with an Input field with the functionality to browse to a network directory, select a text file, read content and upload the data to an MSSQL database table. Nothing …

hi friends, my database names are like that: --name surname date account--- i want to send 5 or more user info send database with form. form.php <input type="text" name="name" size="8" class="auto-style5" style="height: 20px"> <input type="text" name="surname" size="8" class="auto-style5" style="height: 20px"> <input type="text" name="account" size="8" class="auto-style5" style="height: 20px"> <input type="text" name="date" …

I would like some help on this database design I need to have completed by next week. Here's the specs: I'm creating a custom PC builder application. I've been getting stuck on trying to create the database for it. I would like to be able to enter customer details then …

I have the following code in my asp page: [code] Imports System.Data.SqlClient Imports System.Data Partial Class _Default Inherits System.Web.UI.Page Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim dt As DataTable Dim connectionString As String = "Initial Catalog=mdr;Data Source=xxxxx;uid=xxxxx;password=xxxxx" Dim con As New SqlConnection(connectionString) Dim cmd …

How to move data from sql server to excel sheet.

[code] private void btnBackup_Click(object sender, EventArgs e) { Backup bkp = new Backup(); this.Cursor = Cursors.WaitCursor; this.dataGridView1.DataSource = string.Empty; try { string fileName = this.txtFileName.Text; string databaseName = this.ddlDatabase.SelectedItem.ToString(); bkp.Action = BackupActionType.Database; bkp.Database = databaseName; bkp.Devices.AddDevice(fileName, DeviceType.File); bkp.Incremental = chkIncremental.Checked; this.progressBar1.Value = 0; this.progressBar1.Maximum = 100; this.progressBar1.Value = 10; bkp.PercentCompleteNotification …

I am working in C# windows application and SQL I have one problem i.e I want to know that can we search data directly from database. for table we write a queary = Select * from tablename. like that is there is any queary to directly search from entire database …

Hello, I have installed vb .net 2008 express and sql server 2008 express, vb .net 2008 express install (with no option of custom install) sql server compact enu. When I try to create an ado application I see no option for the sql server to insert an ip (like sql …

Hello, I am trying to set a maximum records to "take"-"pool" from an sql server because I get an error out of memory when I try to navigate through all records in a 1.60 gb database, is there any option anywhere that will allow me to specify a max number …

[CODE] Restore res = new Restore(); this.Cursor = Cursors.WaitCursor; this.dataGridView1.DataSource = string.Empty; try { string fileName = this.txtFileName.Text; string databaseName = this.ddlDatabase.SelectedItem.ToString(); res.Database = databaseName; res.Action = RestoreActionType.Database; res.Devices.AddDevice(fileName, DeviceType.File); this.progressBar1.Value = 0; this.progressBar1.Maximum = 100; this.progressBar1.Value = 10; res.PercentCompleteNotification = 10; res.ReplaceDatabase = true; res.PercentComplete += new PercentCompleteEventHandler(ProgressEventHandler); res.SqlRestore(srv); …

Respected Friends Hi I have one table named as 'payroll' with the columns employee_id,employee_name,employee_designation, basicpay,allowances,month,year. This table data as follwoing: employee_id , employee_name, employee_designation, basicpay , allowances , month, year 1 , SAM , MANAGER , 5000 , 1000 , JANUARY , 2011 1 , SAM , MANAGER , 6000 …

hi, Below is my code to delete the transaction. It suppose to delete the data once the transaction but the data remain there....I don't find there is a problem with the code but some how it doesn't work. It capture the data in the table but it returns = 0 …

hi i have 90 textBoxes at my program and i want to insert them for my DataBase (sql) how can i do that? i know that i can to do array like -> TextBox[] arr = {textBox1,texBox2......textBox(n)}; but i dont wanna this way cause that a lot of work. how …

Hey guys, I have written a code that could delete selected row in data grid view. I gives lots of errors. Let me paste my code. [CODE]for (int i = 0; i < dataGridView1.Rows.Count; i++) { DataGridViewRow dr = dataGridView1.Rows[i]; if (dr.Selected == true) { dataGridView1.Rows.RemoveAt(i); cmd.CommandText = "Delete from …

I want to search data from combo box here is the code : [CODE]SqlConnection cn = new SqlConnection(s); cn.Open(); SqlCommand cmd = new SqlCommand(); SqlDataReader rdr; string cd =comboBox1.Text.ToString(); string CommandText = "select * from rto where cd =@cd"; cmd = new SqlCommand(CommandText, cn); cmd.Parameters.Add(new SqlParameter("@cd", System.Data.SqlDbType.VarChar, 20, "cd")); cmd.Parameters["@cd"].Value …

I am getting Error: Jasper Exception for "com.microsoft.jdbc.sqlserver.SQLServerDriver" I have included sqljdbc4.jar in lib folder of tomcat serve bt still getting an error I dont know where to place sqljdbc4.jar...i am getting an error..so plz help me

He guys when i execute this stored procedure by right clicking on it and press execute then entering a value for PW i get a NULL value returned any idea why? [CODE]USE [DR2_Member] GO /****** Object: StoredProcedure [dbo].[up_php] Script Date: 02/26/2011 18:26:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON …

Hey there, i would like to find out how many records have been modified by my quarry. I tried a few things, but none would work. this is my code [CODE] SqlConnection conn = new SqlConnection(); conn.ConnectionString = "server=.\\SQL2008;database=Studentsdb1;Persist Security Info=True;user id=sa;password=1945"; SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; …

Hi all, I'm a newbie when it comes to SQL and I have 2 tables that I need to update. Let's say, for argument's sake that the first table (Products) has an identity column (automatically incremented) with the name of ApplicationValueID. It stores a bunch of data about a product …

Hi everyone, I am getting this error: [CODE]Msg 512, Level 16, State 1, Line 1 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated.[/CODE]please …

hi i have a question in getting values from two table i ave two tables Table1 and Table2. table 1 have data and table 2 may have the same data as table 1 and more. and also table 1 may have the same data and some which is not in …

I have a database designed and implemented using ms sql server 2005. initially, the user has entered the pictures with a very big size because there was not restriction. now when the user is opening the crystal report so it takes alot of time and some time memory full problem …

Hey Guys, I am now loosing my cool over this problem. let me paste my code an then i'll explain my problem. Here's my code : [CODE] if (rn < ds1.Tables["Company"].Rows.Count-1) { rn = rn + 1; textBox1.Text = ds1.Tables["Company"].Rows[rn].ItemArray[0].ToString(); SqlDataAdapter da1 = new SqlDataAdapter("Select C_ID from Company where C_NAME …

Hi to all, I create the following table. create table man(id integer, name varchar(20), city varchar(20), age integer) I want the age, maximum age of person. So, I ran following query, select name, max(age) from man group by name; It shows name of all person in ascending order with their …

hi guys i have an application which adds a patient with his/her own picture.. im doing it in vb.net and my database is stored in sql server 2005.. i have my column for saving the picture.. i have already set it to varbinary(max) my problem is i dont have a …

hi Viewer , i was designed reports while there display the shift record column to row , there is multiple there is multiple record i want display one record into column to Row using sqlserver .. i have query in column to row i donot how to apply in view …

I make a WindowsForm application on visual studio in C# I could connect to my database on sql server but I do not know how to add data in my database from my application in c#

I have a table in which i have a column named "dtCreated" which has got datatype as VARCHAR(50) Now I want records between two dates. I wrote my query as written below [CODE] select * from mytable where dtcreated>=fromdate and dtcreated<=todate [/CODE] This query work fine when fromdate and ToDate …

[CODE] '1 'the function Public Shared Function InsertNewRecord(ByVal myStoredProcedure As String) As Boolean Dim conn As New SqlConnection conn = MyFormz.connec.ConnWeb2() Dim cmdInsert As New SqlCommand Dim sSQL As New String("") Dim iSqlStatus As Integer sSQL = myStoredProcedure cmdInsert.Parameters.Clear() Try With cmdInsert .CommandText = sSQL 'Your sql statement .CommandType = …

I'm using built in function to make Login page. Now I'm want retrieve user password. This is not Run internet. This only run in LAN. so user cannot retrieve password by system. But the company got use Inbit Messenger(Local Lan). therefore, who can teach me to retrieve password because password …

Hi to all, I have nothing idea about how to create relation and solve their queries. I want to relation as follows: ------------------------------------------------------------------- BookAuthor(book, author, earnings) BookReference(book, referenceBook, times) BookReview(book, reviewer, score) BookPublih(book, year, publisher, price, numbar) In these database, each book may have 1 or more authors & each …

In an effort to give back to the community, I'd like to start writing tutorials. I'm just not sure what topics to start with, or what topics are generally needed. I'd rather not duplicate a topic already covered on other tutorial sites, but I know I could put a different …

my deletecommand delete all my rows whenever i delete a row..but when i view it again the other rows still there and the i deleted is actually deleted.. here's my code for da.deletecommand [CODE] da.DeleteCommand = New SqlCommand("Delete from Admission_Record WHERE Patient_ID = @Patient_ID", cs) da.DeleteCommand.Parameters.Add("@Patient_ID", SqlDbType.VarChar).Value = ds.Tables(0).Rows(bs.Position)(0) cs.Open() …

hi everyone i got this error Cannot insert explicit value for identity column in table 'Patients' when IDENTITY_INSERT is set to OFF. i set identity to Yes in sql server 2005..whenever i run my code i get this error message here's part of my code [CODE]Private Function GenerateCaseNumber() As String …

Hi to all, I created the following two table -------------------------------------- create table mail(mid integer primary key, name varchar(20) ) create table phone( pid integer foreign key references mail(email), phone integer) ----------------------------------------- After inserting records on both table, now i want delete perticular record from table say 'delete record of pid=12'. …

Hi, Currently we are using asp.net 3.5 with sql server 2005. We are display the sql server image in to <img> tage.It's diplay in IE 6 lower version,but in IE 6 higher not working.this is actual coding we are using [CODE] Dim myDataReader As SqlDataReader myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection) Do While …

I have a Windows SBS 2008 system. Occasionally, When I look at the daily report it shows that status of updates as unavailable. The status may be fine for up to 2 weeks or I may get this message every day for 4 or 5 then it disappears for a …

please help me! im doing a date comparing project where in i compare the expiration date and the current date i put this on the general [CODE]dim mydate as string[/CODE] then at the formload [CODE]mydate = format(now,"mm/dd/yyyy")[/CODE] and also on my database id format the Expiration field as Date with …

I am receiving an error 'Incorrect syntax near the keyword in Any ideas? [CODE] declare @item varchar(100) declare @stopid varchar(100) set @item in (select itemtypeid from laitemtype where itemtypeid like '88BBA7AD-BD25-E011-94E0-001B214A75A5') set @stopid in (select stopid from lastop where stoptypeid like '7D14FC8C-B184-DD11-9BCC-0014221E87F0') insert into lalocationitemtyperequest (itemtypeid,requestprocesseddate,createddate, stopid) values (@item,getDate(),getDate(),@stopid) [/CODE]

[B]hi guyz..! i want to know da process the to configure sql server on client pc..using odbc...i have install sql server 2000 advance server on windows xp platfrm... i m trying to configuraing frm so long ...bt m failed..! kindly help me regards[/B]

I have an existing database design which I would like to normalize. Essentially, the table causing me problems is one with about 150 columns. The table holds live data for a natural gas well. So, there are columns for the various temperatures, pressures, etc. The data types of these columns …

Could I select a datetime record using date only? I need to show rows containing a particular date. I'm thinking to separate it into two column instead if I couldn't select only date from a datetime.

I'm making a fairly easy to edit and change public dictionary and am working on the viewer hooked to an SQL server. The problem I'm having is, isn't really a problem but I'm looking for a better solution, due to it possibly devolving into a huge mess of sorting a …

Hi to all, I created following table ------------------------------------------------------------------- create table interiors(id integer, name varchar(20), type varchar(20) default 'baby cot', price integer) -------------------------------------------------------------------- but, when i doesn't inserted any value of 'type', by the definition of table, it should take default value. when i fetch all rows by 'select' query, it …

I have two combobox, which is 'names' and 'types' and it's being populated by a dataset. It contains an additional item "-- ALL --" to indicate that all items of a particular field are being shown. I have an SQL select statement to filter the records according to the selected …