[microsoft:sql-server] Forum Topics

Hi, I have a need to insert images to the database. I tried it using the following code: [code]if ((file1.PostedFile != null) && (file1.PostedFile.ContentLength > 0)) { // Get the filename. byte[] fileData = null; string fn = System.IO.Path.GetFileName(file1.PostedFile.FileName); try { // Access the file stream and begin the upload. …

Hi, I have 2 questions for concurrent access to a TXT file and Ms Access. I have a TXT file to store user entries (Name and Surname). I also use Ms Access Database to do same thing, storing user entries. If more than 1 user uses my service, will it …

Hello all, I have been tasked with figuring out a way to automate a form letter process that currently is done mostly by hand with a lot of copy/paste. We have letters that need to get sent out based on our internal system. Someone now looks up the items in …

Hi, I am currently developing an application using vb.net 2005 and windows mobile 6 sdk,and sql server ce for my database. I try to connect to the database i created using the following code: I get an identifier expected error pointing the dot[.] .The code is this [INLINECODE] ("Data Source …

hello every body, is there any mechanism in visual studio 2005 and c# to copy the remote server table and update the local database table with that copied table, please guide me in this topic, step by step to accomplish it, if no than please suggest me what i have …

I noticed that my backup of my 2005 sql server didn't work over the weekend. I don't really know where to start as I haven't dealt much with servers. But I can tell you this.... SQL Server agent has a big red circle through it for not working on the …

I have a DateTimePicker and a DataGridView. I want to display records which match the selected date from the DateTimePicker. But I am not able to code the Select statement properly to display matching records. If I am using "Select * from Results", then ALL records are beieing displayed. Can …

I am working in VB 2005. I want user input in textboxes. On user last textbox lost focus all data entered inthe textboxes shold shift to datagridview. User input as many data as he want. when he finish all his enteries. Click on save butto all data of datagridview insert …

I want to write an sql statement in c# where I want to pass a "true" or "false" value basing on some condition... can we pass true to sql statements Ex: [CODE]select * from emp where (empid=1234 and true); select * from emp where (empid=1234 and false); [/CODE] This true …

Help Me, Please..VERY URGENT I have this cenario: I have a form(NewcomplaintForm.vb that will collect informations for ComplaintTable(complaintid, ComplaintType, date, desc, status, recommendation, etc..); ComplainantTable(complainantid, last, first, etc..); OffenderTable(offenderid, last, first, etc..) DutyofficerTable(dutyofficerid, last, first, etc..) and insert data into these tables respectively. when NewComplaint, check for complainant last and …

Hii everybody, i am developing window application in c# and .net and i want to know that how to write a join query for update of local database by the content of remote server database!. Scenario :- Suppose there is one database say softbuyweb at local machine and other database …

Hi, I have a PC thats on a domain. That PC is used to connect to the exchange server and occasionally to an SQL database. However when the machine connects to the database, the application it opens and connects to database, runs extremely slow. There are other PCs that connect …

My server configuration are . SQL Server in Marchine1 - is setting in Mix Mode(SQL Server and Windows Authentication) . IIS Server in Marchine2 - is setting as following Directory Security - > Authentication and access control .Unchecked "Enable anonymous access" .Checked "Intergrated Windows authentication" .Checked "Disest authentication for Windos …

helllo great programmers please how do i export the data i previously have on excel sheet to my published sql database

Hi. I have never used a forum before. I hope that someone can help me. :) I am using VWD 2008 Express edition to build an editable datagrid. My problem is with the Update Function: [ICODE] Sub dgShows_Update(ByVal sender As Object, ByVal e As DataGridCommandEventArgs) 'Determine the value of the …

I'm new to T-SQL and trying to program a simple query: Table1 Location ID Flag Table2 (many to Table1) Location ID Code Select Table1 Location_IDs where the count of Table2's Code=value is 0 Thanks for your help!

I have a small app im working on that allows users to input data into an access database. This data represents incoming and outgoing items. Currently, the user can input all incoming and outgoing transactions, but I haven't been able to set them up to cancel each other. What I …

Hello everyone! I can`t find a solution to the following problem in SQL Server Reporting Services 2005. I created a table which has multiple columns. It can happen, that some columns have the same values for multiple rows, only the most right column has different values. For example Column 1 …

I am using SQL Server Express 2005 as my Database and programming in C# 2005. In one of my Table "Results" I have a field named "ResultDate" of DateTime data type. In my form I have a DateTimePicker. I want to save only one record for a particular date, hence …

Hello reader(s), In table1 i have 3 columns named: emp_id, month, year. First i'm inserting emp_id from a recordset with validation from a text box. Problem is: In the same row i need to insert data of month and year column from individual text box. Code should like: insert into …

Hello I have a VB.NET application that needs to backup a database then restore to a new database in the same Server as I am upgrading an application and I want to retain the existing database. I create a blank database using the following: [code]cmdSA.CommandText = "CREATE DATABASE [newDatabase]" cmdSA.ExecuteNonQuery()[/code] …

Hi. I tried dragged and dropped an SqlDataSource and then click "Configure Data Source". From there i start a new connection and select my server. Under "Select and enter a database name" listbox i can not see anything. So i try to attach a database file "NORTHWND.MDF". When i try …

I'm pretty green at Delphi. I have a program that must call a MS SQL stored procedure before executing the rest of its logic. Here's the code I've written (changes have been made here and there to protect confidentiality): [code=delphi] theProcedure := TStoredProc.Create( NIL ) ; theProcedure.DatabaseName := theTDatabase.DatabaseName ; …

All, Trying to get a date WHERE statement to run to pull all records for the month. What I have is: [code] Dim SQL_Str, DatStr, MonVal MonVal = Get_Month(TargetForm![cboxMON]) DatStr = MonVal & "/*/" & TargetForm![cboxYER] SQL_Str = "SELECT * FROM qryREPrev WHERE ([tim_ted]= like #" & DatStr & "#)" …

Hey! What i am looking for is help on how to work with databases in c#. I have basic knowledge of C# and a pretty good working knowledge of SQL. But I have never learned how to use them together. Can someone point me to a tutorial or something similar …

hi i want to create a trigger for update in mssql. in my trigger i want to know which row was updated how can i achieve this info ?

I have a table in MS SQL DB, the data was recorded with redundancy, is there an easy way to remove all but keep only one, for example: [ICODE]id name age dept --------------------------- 1 alan 20 A 2 william 23 B 2 william 23 B 3 mike 30 C 3 …

Hiii i am creating login form, and all the logic is correct by me but when i run the form it executes and inspite of i am providing the correct username and password i get the same message "Wrong login info is provided". please help me on this topic, thanx …

Hi all, I was thinking of using Triggers to take care of my history tables. Two questions remain: 1) Transaction Scope I handle complex Operations in my DataAccessLayer (C#,ASP.NET) with Transaction Scopes. For example: [code]private void InsertFamily(FamilyDTO) { using (TransactionScope scope = new TransactionScope()) { try { InsertFather(); InsertMother(); InsertBrother(); …

Hi I want to know how to write storedprocedure when search creiteria is Present. Here the query to give the list of "select ID, Salesmennummer , Salesname Commision, Areacode from sales_master Areacode Salesmennummer Salesname Commision 1 1000 Rams 200 2 2000 Johny 1000 I Want to search above list by …

I want to dynamically update and display Label captions using hidden texbox which read from certain SOL DB table column. Am using label1.caption = text1.text Very New to Vb.net 2005

Hi All i have problem in insert statement in which one string returning me value as g's and because of that s is gets separated. and its giving me eroor as Incorrect syntax at s. [code]strSQL = "Insert into HeaderInfo(yAxisLabel , xAxisLabel , zAxisLabel , yAxisUnit , xAxisUnit , zAxisUnit)" …

I'm trying to use VB.NET to insert the data in the current row of my datagrid into a table. I wrote the following code: [CODE] Dim vCustomer, vBulkQty, vItem, vBaseUnit, vEachQty, vEachUnit As String vCustomer = dgCustomers.CurrentRow.Cells(0).Value vItem = dgItems.CurrentRow.Cells(0).Value vBulkQty = dgItems.CurrentRow.Cells(3).Value vBaseUnit = dgItems.CurrentRow.Cells(4).Value vEachQty = dgItems.CurrentRow.Cells(5).Value vEachUnit …

hi, i am trying to create a database driven application using Sql2005 and c#.. i have alittle problem can anyone tell me how to connect to sql database using c# and do simple transactions such as insert update delete and search ...but it shud be fully code based. if possible …

Hi guys, I need some help please. I am new to SSIS. I created a SSIS in BI and when I run it it works fine (All it does is to run a select statement to get data and save it into a flatfile. The server I'm accessing is on …

I can't figure out how to email the password from a sql database I have a formview on my webpage can I pull it from there? or can I pull it directly on my backend code? Using C# I tried + passwordlabel + I tried using findcontrol.formview I can seem …

We have a Windows 2003 Server Standard with SQL 2000 installed in a workgroup called "SUNDANCE". My question is can I somehow have that Windows Server communicate with AD on another Windows 2003 server that is part of a separate domain? I would like to have all connections to the …

Hello people I'm new here (And new to web develepment) and hope to stay for a wile if you let me ;) I am trying to construct a WHERE clause on a grid view of a database table I have on a website I am creating in vwd 2005 express, …

hi i have a table which contains a datetime type column. i want to create a stored procedure that gets a surtain month and year as parameters and returns all the rows with the date column in the month and year range i sent as parameter. for example if i …

I have an SQL2005 table loaded with ICON (image) BLOBs. I need to dynamically add ToolStripMenuItems to my Windows form including the same row Icon from the database table. This is a Plugin system where I pull the plugin file (assembly) names from the database according to the operator's rights …

hi i'm trying to edit gridview rows. the grid columns are template cplumns. i added the commandfield buttons for update. i wrote a rowupdating event: [CODE=asp]MonthTable.Rows[e.RowIndex]["FirstEnter"] = ((TextBox)(MonthGridView.Rows[e.RowIndex].Cells[6].Controls[0])).Text;[/CODE] on runtime i get this error: Unable to cast object of type 'System.Web.UI.LiteralControl' to type 'System.Web.UI.WebControls.TextBox'. what have i done wrong ?

Hi, How to connect to remote server with storedProcesdure sp_addlinkedserver where the server has an instance SQL2005. suppose the servername as 'SrvName\SQL2005'. Also please provide the procedure how to delete a remote server from sysservers table. Thanks, Ukbasak

hello guy, Recently i faced a problem that i have 2 sqldatasource where connect to different server. But the problem is how to combine 2 sqlcommand into one datagrid. eg: [ICODE]1) sql1 = Select ID, Name from Table1 sqldatasource1.selectcommand = sql1 datagrid1.datasource = sqldatasource1 datagrid1.databind[/ICODE] [ICODE]2) sql2 = Select ID, …

I just finished a job interview/exam and I failed. I really don’t know how to implement this problem using an MS SQL. You could check the exact question/problem below: [I] There are two tables, NAMES (ID INT IDENTITY (1,1), NAME VARCHAR(255) ) and RELATIONSHIPS (NAMEID INT, PARENT_NAMEID INT) linked via …

So, I've got a bit of a conundrum that I cannot for the life of me figure out. Here's what I need to do : In column PO_I, look for column ITEM with lowest # in column Seq_I. If column Ship_Q < Qty_Ordered, look for Ship_Qty within ITEM with next …

I am currently using MS SQL 2000 server as backend database for web site (written in php), now plan to switch DB to MS SQL 2008 Express, I have questions about this conversion: 1) Will MSSQL2008 support all sql statement that was written in MSSQL 2000? 2) I know SQL2008 …

Hi I have made a website where it is possible to see the days program on one page, it updates itself so it is only for that day. But now I wan't to be able to insert a picture that changes position according to what time it is. For example …

How to move (or Duplicate) a Microsoft SQL Server Database from One Physical Server to another server (like backup) in vb.net 2.0 ?

Hi I have made a website where it is possible to see the days program on one page, it updates itself so it is only for that day. But now I wan't to be able to insert a picture that changes position according to what time it is. For example …

Can any body tell me how to fetch data from a SQL table using SELECT statement in VC++ (MFC app)