[microsoft:sql-server] Forum Topics

web.config ConnectionString My Connection string for an application within iis to connect mssql db looks like this <add key="ConnectionString" value="server=localhost;database=search_parser_2;uid=DOMAIN\Administrator;pwd=password;Connect Timeout=1000000;" /> Yet the application wont get past the login script (where the sql connection is happening i presume). the database name is correct and the server name is correct …

I would like to thank the moderator for helping me with the code while reading row by row data using datatable and sqldata adapter. I am worried about the speed and performance of my code since I am making round trips to the server,every time I am increment the index …

Hi, Does anyone know how to use NHibernate to connect to an SQL Server database? If so, please help me Thanks

hi i want to take single table backup on sql server 2000 how can i take only selected table backup ??

Hello, Firstly, i am not at my computer atm so i will not be able to show you my code (i will post it later). I am creating a program for my dad which is sort of like a stock control program. I have a form with two comboboxes and …

Hi, can i insert data into database by calling a stored procedure and a DataTable object , i mean that if i can send some values using [B]SQLCOMMAND.PARAMETER.ADD(...)[/B] to the SP and the other some values using DataTable that were added to it after inserting a new row to the …

hi, it show me this error Incorrect syntax near the keyword 'Select' to make to clear Employee ID in this case is FK in the table (Attendance detail) and the other thing is i am using Data Grid View from another table(Employee information) to Show the list of the staff …

Hi, I m making a software which calculates the hours worked by each employee per day. This is calculated by the in time and out time of the employee. I have the database which contains the in time n outtime of the employee in sql. Now, My problem is i …

Hello Everybody: Just want to introduce myself. I'm a C# developer with SQL server skill set as well. I do mostly Windows app and trying to get myself into more web development. I'm 50 years and started my computer carrer since 2000 as IT Professional. I play soccer, listen to …

Hi, I installed VC++ with SQL Server 2008, but I cant find SQL Server Management Studio application. Can you talk me why? Installation of all components was good and I can find other components.

I have a C# console program that generates Excel files and writes extracted data from SQL tables into them. Program is scheduled by Windows Scheduler to run periodically. Problem is that when scheduler fires up the program, it goes through the steps and logs that completes successfully. However, no file …

Hello, Can anyone tell me how to get records from SQL server database in j2me. As I want my application to run on Low-configuration device, I cant use servlets. Also help me on writing and reading objects in a file using j2me? Thank you!

My program is used to perform a salami attack on the database Whenever i run the program the compiler display the following message Invalid Cursor state on line 29 [CODE]import java.sql.*; //import java.io.*; class SalamiAttack { String ssql1,ssql2,usql,temp="",buffer=""; Connection conn; Statement st; ResultSet rs1; int index=0; float tempfraud,fraud,zigacc=0; SalamiAttack() { …

Hi I am creating a windows application. I have a button as backup. When the user clicks this button,he/she should be able to take backup of the database. I am a beginner. I dont have any idea about how to do this task. Can anybody tell me how to do …

hi all, what i am trying to achieve is that, using statistics from a data source (may be a SQL DB) i need to create a graph dynamically at runtime, and display that graph on the web page. perhaps it would be a good idea to convert the generated graph …

I need to check the income for a particular department for a certain period of time. My inputs are the two dates between which the income has to be calculated,and the department name,the department name is the primary key for my table I need to show the transactions for the …

I'm a vba and former vb6 developer and I work in the UK, mainly in Access, Excel and sqlServer. I've been learning VB.Net 2005 for a couple of years as a hobby. I've joined the forum because of selfish reasons, yes youre right, I've got a problem. I'll use another …

Hi all, I've uploaded my asp.net site to my ISP. It works fine locally on VWDE 2005, in that I can create users, assign them to roles, and control role access to website folders etc. Obviously this is all with SQL 2005 Express on my PC. When I upload it …

Probably a basic question but... I have an windows application comprising several forms with a SQL Server database in the background. From several of the forms, I keep needing to run the same method, so instead of repeating code in each form, I want to put this (repeated) method in …

I have 2 databases on my computer, managed in the same SQL Management Studio - named [B]DATABASE1[/B] and [B]DATABASE2.[/B] The two databases are different except they have 1 table is the same, this table is called [B]Employee[/B] Because this the content of this table should be the same, how could …

Hello Everybody, I have used inner join with two tables to join them and tried to calculate the sum of rows. Now the table descriptions are- Table1- agent_business_collection (it stores business collection of an agent of different business packages) Table2 - agent_business_commission (it stores commission of an agent against different …

Hi i have my INSERT and DELETE command working fine my data gets saved to my database to deleted, my problem is my UPDATE command. i have a form which displays 'employee' information the form includes text boxes i.e forname surnam etc and this is where the data is displayed …

Morning I have a question here How do I go about it in Access say if I want to split a line (row) into different lines like these fields? Drug name1 Drug name2 Drug name3 Drug name4 Drug name5 Drug name6 So what I want is to split the Drug …

hi could you please tell me the command to insert values from the dropdown list into sql using c# coding

Imports System.Data Imports System.Data.SqlClient Public Class Form2 Dim myconnection As SqlConnection Dim mycommand As SqlCommand Dim dr As SqlDataReader Dim dr1 As SqlDataReader Dim ra As Integer Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click myconnection = New SqlConnection("server=Pakistan;Initial Catalog=Mumtaz;database=Mumtaz") myconnection.Open() mycommand = New SqlCommand("insert into …

I am exporting a large amount of data from SQL Server 2005 to Excel. Most of the data appears as I want it to- without the exponential notation. Any values [I]smaller [/I]than 0.0001 (i.e. four zeros to the right of the decimal) are displayed as, for example, 7E-05 rather than …

I have a database I am creating with about 50 users over a network. There are about 6 groups of users and these users are spread across 10 branches. I want to block/allow users from particular forms and views. For example I want branch users forms to be filtered by …

I need to have a database of the online flight booking system. May i have some guidance ?

I am looking to DYNAMICALLY use the Edit button under the SqlDatasource to update a GridView. The reason for this is that the data that will be upddated to dynamic table names and tables that are different sizes dependent on what month it is (since different months have different days …

Hello guys help pls i'm trying to populate data from MS Database to list-view [code] string Collect_FULL = "SELECT FirstName, MiddleName, LastName, " + " Gender, DoB, Dependents, Address + ', ' + City + ', ' + State + ', ' + ZipCode AS Address, PhoneNumber, MobileNumber " Status …

hi... actually me wish to have few differences between SQL Server 2005 & 2008, from interview point of view. As I have asked the same question most often. give me the basic difference as well as technical too. Thanks

was using c# to develop some application and wanted to connect my application(windows) with SQL database. using sql 2005 express and visual c# express; but it kept on throughing the following exception while i try to run my app. so help me out "An attempt to attach an auto-named database …

Hello All, Can anybody help me, i am having challenges getting collections value into the database Here is my sample code. but is not working at all rather is crashing the applications Dim collections As New System.Enrolment.CustomerBiometricsCollection() collections = Me.PrintCaptureWizard1.ShowDialog() Dim dbs As New DBClass Dim mee As String mee …

Hi All, I am trying to convert the following access update query into TSQL without any luck: UPDATE tblCattle INNER JOIN tblFarmDetails ON tblCattle.strEartag = tblFarmDetails.EarTagNo SET curMartPrice = tblFarmDetails.MartPric WHERE (curMartPrice=0 Or curMartPrice Is Null); First I tried simply pasting in the query with no luck so below is …

I need to eliminate a record with almost exactly the same data except 1...for example: I have 4 Fields for Employee table: Employee Stat First Name Last Name Employee ID Active James Smith JOS Resigned James Smith JOS For some reason the table I'm querying has these data. How can …

I have a problem I have a long table with many costumers, each costumer have between 70-100 bills how can i get for each one his top 5, all the replies giving me only the top 5 of the first.(MsSQL!) 10X Ofir

I am developing C#-based mobile application and the exception always thrown and catched by my try catch block Exceptin thrown : The database file cannot be found.Check the path to the database [File name = .\MyMobileDB.sdf] the snippet code is [CODE] namespace DeviceApplication4 { public partial class Form1 : Form …

I can produced a small function using JavaScript, which adds a new table row upon a button click, however, I am unsure how to get values into the dropdown menu. Is it possible to obtain the values from a sql database? Any help would be much appreciated. My existing code …

I am developing a web page in PHP, and I would like to provide my users access to Reporting Services reports via this page. I am currently running an instance of Reporting Services 2000. I cannot find any good way to link/render/display the reports directly within the PHP page, instead …

Hello everyone, I currently doing a database project, which is part of my coursework, and I am having some difficulties. So, I am making it in Microsoft Access 2003. In my form, I want have to tabs (Client and Music Store), and I already have 2 tables, for each tab. …

Hi How can i show data in datagrid from sql server database

Hi I Create the tigger when update process happen in database.When the after update process happened ,tigger instert the new record into another table about that table locate in different server.I create linked server also ,once tigger execute it generate the Error message .Below I mention the error Message I …

With the code below data is keyed into a form and inserted into a table called Investors. After it is inserted, I'm trying to [U]redirect back to the same page, passing the InvestorID on the querystring[/U]. Simply showing all of the information I just added, kind of insuring that it …

hello frends i hv a prom with updateting............. in my form............i hv added a datagridview ......... in backend i m using an sql server...............i want to update the changinges made in datagrid view.................data shown in datagridview is from 2 from.......... i m using an join operation.............. so please anybody help …

how can i link form created using vb.net to sql server database. I created a database with sql server 2000 now i want to connect form created in vb.net to sql server database

The site that i'm working on is [url]http://www.perfectbrewingsupply.com[/url]. The site seems to come up properly (after i reset a new user/pw in the config file) but when trying to access the database for zencart, i am still receiving the following error: 0 DB_ERROR_NOT_CONNECTED in: [select * from project_version WHERE project_version_key …

hi i was wondering if anyone could help me i have created a SELECT FROM WHERE query to perform a search here is my code [CODE]SELECT EmployeeID, DepartmentID, Forename, Surname, Role, Email, Telephone, Extension, Mobile, Photo FROM Employees WHERE (Forename = ? or ? = '') and (Surname = ? …

Hi All, I am getting the error "There is already an open DataReader associated with this Command which must be closed first. " [code] protected void Page_Load(object sender, EventArgs e) { nbseapi nbsi = new nbseapi(); Guid guid = new Guid(); if (Request.QueryString["Id"] != null) { string Id = Request.QueryString["Id"]; …

I have a users domain and user id. I would like to retrieve the full user name. The data is coming from a SQL table for display onto an asp.net page. Anyone know how to get the users name for someone other then the user who is using the asp.net …

I have a CSV file where fields are delimited with a comma. The fields of this CSV file contains the attributes of Permanent Survey Marks and I’ve created a GIS python script to convert it to a table that is stored it in our Enterprise GIS Spatial Database (SQL Server). …