[microsoft:sql-server] Forum Topics

I thought I had the command correct, but I wanted to make sure since I fail to connect in my app. Here is the connection command I use: New SqlConnection("Server=TestServer;Database=MasterDB;Integrated Security=SSPI") I have verified the server name, DB name, and that the server is using windows authentication. Any help would …

I have a table in SQL sever .How to create a dynamic dropdownlist using the entries in that table in such a manner that i am able to use the corresponding values to that entry that are given in the table?

How to make the connection command in sql and sql query command in different function and then to link them to exequte the query in the web service and to call them in the main function

I want to build a Webservice that on given intervals request data from a SQL-server and update an internal list in the Webservice. The Webservice will be accessed from multiple clients and I don't to access to SQL-server every time the list is requested from the clients. Is this possible …

Hello Everyone, I have designing a desktop application using VB.NET 2008 & SQL Server 2005. In my Application i have a frmUserRegistration to add a user & frmLogin to login to my application. i can add the user details in the database but my password seems to be in characters. …

Hello, I have created a project on "Hospital Management". With Front end is Microsoft Visual studio2008 Windows Application (C#)& Back end is Microsoft SQL server 2008 It's Working Successfully. But the problem is setup is working only on that system where the project is done. If i try to start …

Please someone can help me. I need a function which just returns the number of rows from known table. I tried it like: [CODE] CREATE FUNCTION getRows ( @id int ) RETURNS int AS BEGIN DECLARE @rownums int SELECT Count(*) FROM dbo.MainData where id=@id RETURN @rownums END [/CODE] But it …

Can you discuss the problem that arises when several customers try to make bookings at the same time and devise and how to implement a method to prevent double allocation of seats in a multi-user environment. I am using ASP.NET and Ms sql server 2008.

Hey all, having a little trouble transferring my listview items into a database. I have transfered all of the listview items into a List<> for use during the population of the items in my database here is my dataaccessor class, it contains the reader writer and writer statements generator: [CODE] …

i have installed microsoft sql server 2005 that comes along with vb.net 2008 but after installing i couldn't find any option for ceating table and database can anyone help me

Hi everyone I'm really exhausted with this error I'm using visual studio and I'm trying to build a contact form And all the information should be saved in contact table in the database Would you please help me with this error? I tried a lot to figure what's wrong, but …

hello I am using vb.net 2005 and sql server 2005. i am having problem with datagridview data manipulation. Actually, in master-detail i am displaying data of Master in textboxes and Detail in datagridview. i am using binding source for it. The main problem is that i have to directly enter …

hi everyone am a beginner in jsp side. i am working on a project where the UI is designed in HTML, validation in servlet and i want to store the relevant information in SQL server. I have glass fish server. how can this be done. please guide me

hi, i'm working on a windows application with sql server compact edition3.5 database. i was working with visual csharp 2008 express and now i have installed visual studio 2008 professional edition. the problem is that i can't open my database to see tables, i get this error message" the operation …

Hi I am using two linked server Both have same tables by using sp_tables_ex 'linkedserver name' this I can see list of tables.One Emp table is available in that list but when I try select * from Openquery(linkedserver,'select * from public.Emp') then it show me error like Error message: ----------------------------------------------------------------------------------------- …

Hello all, I'm somewhat new to programming but I had a quick question. I have created a program to take a text file and convert it into a datatable. Unfortunately, however, I seem unable to attach this file to a database. I am getting an invalid object error stating that …

Hi everyone! I am a junior database programmer. I need to know how can I save image in SQL SERVER 2000 by VB.NET? I made a table in SQL SERVER with two fields. One is Id[nvarchar] & another pic[nvarchar]. I got two forms there in VB.NET project. In the first …

I am currently doing a project where i am using C# and databases. I am using visual C# 2008 and i am having issues accessing the tables that i made. So what i have done is that i have a couple of tables, one with students in it, another with …

Hi I am workin with c# VS2008 sql server 2005 I have A database from the kind of "Service-based databa" when i insert new data to my application all the changes are not save. If I insert the data threw my DataPreview(VS) all the data is save. I am working …

How do I make the connection to a SQL database (one to many), with VB.NET?

Hi Guys, I am trying to insert hashtable in databse but one of the key in hashtable is null.Can anyone help me write an exception for this.Or if i can just move to the next key . Thanks a lot [code] private void btnUrdu_Click(object sender, EventArgs e) { SqlConnection cn …

if not exists (select * from sysobjects where name='amrreconAccountsTB') begin execute "create amrreconAccountsTB(acct_id char(2048) NULL)" end; Message from server 'NOCTREPI04' (Msg 156, Severity 15, State 2): error near the keyword 'end'. Can someone please help me and tell me what is the syntax error here?

I have to finish this project for tomorrow-so I'll Appreciate quick reply. I need to do reports in my projects. now I've created Data Environment and all that but in the SQL the only thing that work is if I select the entire table from the database. (like "select * …

Hi folks: Can anyone tell me what I am doing wrong in the coding below: [code] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try Dim ConnectionString As String = "Server=hp;database=library;integrated security=SSPI" MessageBox.Show("Connection established") Dim sql As String = "SELECT snippetID, snippetName, snippetSource, snippetCode FROM snippet …

Hi guys. I'm pretty new to sql and I'm having some trouble with a store procedure. I tried to read about it by searching goggle but all the references i got to the topic contained to complex store procedures for me and my current level :P. Here is my simple …

I'm trying to study ASP and sql server 2005 to create the website.However, I don't know how to create a table having a column to store the image, I have never tried this before, I don't know sql server 2005 has data type of image or not. hmm, the flow …

I have searched and I have searched but I can't find a way to display all instances of SQL Server in a combobox. Any help is greatly appreciated.

i have tobind sql table to dropdownlist using javascript. thanks in advance

i have tobind sql table to dropdownlist using javascript. thanks in advance

Hi, i have a program that connects with an sql database and it works fine with the sql. Now the problem comes when i publish. When i open the published program it gives me an error. An attempt to attach an auto-named database for file ..... A database with the …

I am trying to build an SQL query to compare date in my txtDate box to one in access database for my database search-page. I'm clueless as to which is the best method to do this. Obviously just comparing the textbox value doesn't work. This is my current if-function to …

I m working with web parts in asp.net and I want to save my personal setting into db(sqlerver) how to use these methods or others which are present in sqlprovider 1) SavePersonalizationBlob 2) LoadPersonalizationBlobs etc Waiting and need help help it humble request

Hello everyone. I'm beginner and i trying to make time register system. But i can't insert my datetime to my database.Here's the code that i wrote [code] private void button1_Click(object sender, EventArgs e) { string dt; string dt2; DateTime date = DateTime.Now; DateTime date2 = DateTime.Now; dt = date.ToLongTimeString(); // …

Hi Everyone. I have problems with solving a sql question. There is an assumption: The database of naval ships that took part in World War II is under consideration. The database has the following relations: Classes(class, type, country, numGuns, bore, displacement) Ships(name, class, launched) Battles(name, date) Outcomes(ship, battle, result) Ships …

I want to upload photo on click in VB.NET and want to store it in SQL 2005,also want to retrive it in picture box on another click.

Hi all, I want to make a string like this: [QUOTE]SELECT * FROM "Alexander de Groot"[/QUOTE]. So i can later execute that sql statment. Im only having a problem creating the string. Let me show you: [CODE]string sTableName; char *SqlTableName; sTableName = DBLookupComboBox1->Text.c_str(); SqlTableName = new char[sTableName.size()+ 20]; strcpy(SqlTableName,"SELECT * …

I have been given a report that is generated by running the following query from a macro ( slightly edited to simplify )and I have not had a great deal of experience with Access. The report is grouped by Data.Type and sorted be Data.Date [ICODE][COLOR="Green"] SELECT DISTINCTROW Data.Type, Data.Date, Data.Code, …

hey guys, this is me once again moving around data access. my problem now hide in the import process of an excel file that would be inserted into sql db. the problem is the excel file may be updated or changed and i have to periodically import it and perform …

HI I ama reading text froma file that have word like "you're" and it gives me Unclosed quotation mark before the character string ') error.Can anyone help me with this .Thanks [code] using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; …

i've backup data in text file and it needs to be restore on previous database using vb, is it possible?

Hello everyone, I'm currently working on an automated process which extract user info from AD with csvde, then do some treatments with perl scripts, convert the csv file into xls in order to do some modifications by a specific user in Excel, then convert the xls to csv, format it …

The following is the complete coding for moving data from sql to access, I get an error saying that Microsoft JET Database Engine missing (;) at the end of sql statement!!!! Could you tell me what I am doing wrong? Imports System.Data.OleDb Imports System.Data.SqlClient Public Class frmMain Inherits System.Windows.Forms.Form Private …

I have a php page that displays records from a sql database. Each record is in a repeat region and has a submit form nect to it. The problem is if I submit one of the forms below the first in the list, the first form is validated and the …

Please, try to help with this. I use case statement but for 2 arguments. Down here is the idea of what i want to get: select x case x when x = 'AB' and y like 'CD%' then x= 'CD' when x = 'ZZ' and y like 'CC%' then x= …

Hi, i am getting error Line 1: Incorrect syntax near 'Valuesstuntto'. and its an sql error.Can anyone help me with this thanks. [code] using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; using GermanDict; using SimpleFrenchDict; using System.Web; namespace DicttoData { …

I'm trying to restore previously backup text file into sql server on specified database. Could it be possible using VB.NET? if possible please help me..

i'm using VB.NET AND SQL SERVER AND HAD PROBLEM TO RESTORE PREVIOUSLY BACKUP TEXT FILE.

Hello all, First off I am using VB.net I have a dropdown list in the Item template. I would like the user to select a value and update the database without clicking an update button. Here is the Code for the DDL [CODE]<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2" DataTextField="provider" DataValueField="provider" AutoPostBack="True" AppendDataboundItems="true" …

Hi , I am trying to insert the arraylist to database using sql .I have my code below.Can anyone help me with .My issue is that my insert statement doesnt work. Thanks [code] using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using …

[CODE]SqlConnection con = new SqlConnection(connection string); SqlCommand cmd = new SqlCommand("select bookfile from books where bookfile='....' " , con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { // Is Exist }[/CODE] this code is for check whether a book file is exist in database?