[microsoft:sql-server] Forum Topics

HI I am very pleased to join this forum I am new to SQL programming , I am facing a challenge our sql server database entry is crossing 1lakh per day,so connection becomes slow.... For this how can i handle the situation!! our databases deals with leads and hits in …

I am working on a VS2010 Winform (not ASP web form). I have a copy of the local database on my computer. In this application, I have 3 forms in my application that need to connect to the same database, but different tables. Right now I am defining my connection …

I am working in sql2000 database as backend and Vb6 as frontend. Its for bank scenario I am trying to display the balance corresponding to particular account number. Do try to help. Following is my code. ************************************* Private Sub Command1_Click() Dim con1 As New ADODB.Connection Dim cmd1 As New ADODB.Command …

Dear Experts, I have a situation , I am sure about the best approach for it. I have a database application that is designed to handle both SQLServer database and Oleddb "Access mdb" database. the issue is that during application start up , the application detects the configuration file and …

ok so , i have a sql query puzzles . say that i have a table "PERSON" with the data look sumthing like this: PERSON Name ID ----------------------- John 12123 Kimberly 33311 Leo 87892 And i have a table score that look sumthing like this: SCORE ID MARKS ------------------------ 12123 …

Hi All, I sware I am loosing the will to live, I have tried to accomplish this by my-self for about 2 weeks now and I am still at square one, I prey someone can help me. I am writing an application for booking conference rooms and I need a …

after i add all the reference on my vb6 project and everything loaded successfully when i press on report button to view the report i face this error msg: Logon failed Details: ADO error code ox80004005 Source: Microsoft OLEDB Provider for SQL Server Description: [DBNETLIB][Connectionopen] sql server doesnt exist or …

I am new to Vb.net and I'me trying to store data to the sql databse using text fields. Everything seems ok but i've tried several connection strings but they wont work.Could somebody give a hand, please? [COLOR=green]Private[/COLOR] [COLOR=green]Sub[/COLOR] btnSubmit_Click([COLOR=green]ByVal[/COLOR] sender [COLOR=green]As[/COLOR] System.Object, [COLOR=green]ByVal[/COLOR] e [COLOR=green]As[/COLOR] System.EventArgs) [COLOR=green]Handles[/COLOR] btnSubmit.Click [COLOR=green]Dim[/COLOR] conn …

I need to retrieve the Date only from Microsoft SQL Server and insert into Listview the code that i used was this SqlCommand cmd4 = new SqlCommand(); SqlConnection cn = new SqlConnection(); cn.ConnectionString = ("Data Source = LOPEZ-PC\\SQLEXPRESS;Initial Catalog=softwareengineering; Integrated security= TRUE"); cmd4.CommandText = "SELECT * FROM [rawinventory] "; cn.Open(); …

Dear Experts, I have a situation , I am sure about the best approach for it. I have a database application that is designed to handle both SQLServer database and Oleddb "Access mdb" database. the issue is that during application start up , the application detects the configuration file and …

I am using visual studio 2008 Professional / vb.net and sql*server Express (9.0) *I am using DAL table adapter logic for db access.* One of my tables needs to have a field changed from smallmoney to decimal (9,2) to accommodate larger values. After making the changes below, I am now …

Hi, I am writing a little app that will have a rich text box that users will be able to write SQL statements and save them to SQL Server table. I would like to validate the SQL statement before saving the string. Because another process picks up the string and …

Hi All, Quick one for you. I have a client that wants to use a webservice to transfer data from a tablet on a network to an SQL database on servers. Am I correct in my thinking, as I am completely new to web services, that I can have a …

Hi All, I am trying to link two database in different servers. Are there any ways I can do this? If this possible, could anyone show me how to do it. I've been googling it a few weeks ago, there are sites that said to use the sp_addlinkedserver but I …

How to call Sql 2000 Stored Procedure from vb6 which take 2 input parameter

I have never used a background worker in vb.net, but from what I have read, I think it will help resolve an issue I am having during runtime. I am executing an sql statement, but it takes a bit to process. I think a background worker could help with this …

Hey everyone, I'm using CTEs to try and get the totals of two different criteria queries that I want to group by Month depending on the associated Inquiry Date. Here is what I have right now; ;With CTE(total, InitDate) as ( SELECT count(Inquiry.ID), Inquiry.Date from Inquiry Inner Join Inquirer on …

Hi All, In a table (dbo.UnquotedContacts) I have few columns from where I am trying to extract few columns. But My crcern is as follows IF the field 'Date_ABC_Updated' is NOT empty AND the field 'subscribed_to_Business_XL' = 'SUB', the contact has an ACTIVE BXL subscription IF the field 'Date_ABC_Updated' is …

I have 82425 data in a table. through a query I fetched 73876 data in a new table. Now I want the data which I have not got from the query. My query is SELECT af.* Into IAGroupNoNGroup FROM ( SELECT Key_out, MAX(Max_FieldValue) Max_FieldValue, ( SELECT TOP 1 Key_in FROM …

In my program, I have a section to insert information about a customer into an Access database. I get the error below at the .ExecuteNonQuery. Message: System.Data.OleDb.OleDbException (0x80004005): Field 'Customer.Business_Phone' cannot be a zero-length string. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& …

HELOO DANI,HP YOUR DOING WELL!I AM NEW TO YOUR SITE...I HAVE A PROJECT THAT NEEDS A FINGERPRINT TO BE COMMUNICATED TO THE ATTENDANCE SYSTEM THAT I HAVE ALREAADY PREPARE I VB 2010,THE PROBLEM IS I NEED TO EITHER STORE FINGERPRINT DETAIL IN DISK OR IN SQL 2005 DATABASE,BUT ALL IN …

Hi all, Anyone know how to create a data base gives the name of the same parameterized? Example in a store procedure, named 'x', which has a parameter, this will do since the create dabase @variable create procedure creadatabase @db_name varchar (10) as create database @db_name go But this variable …

Hello Everyone, I am encountering errors when browsing the web application. When a single user is login, all in all is fine, inserts and updates command execute fine as well as reading the data. When 2 or more users are log, the application displaying random error messages like the pagers, …

hey everybody , i need the help plzz,,, i have an application that developed using vb6 and i have its database that design by sql server , but i dont know how to make it run , when i run the application its give me the following error : Dim …

how to convert vb.net and sql server 2005 into .exe file the exe file can be run in the another system but it cannot be save the data. the connection string can be errored because my computer name and another computer name is different . how to solve this problem. …

I have created a cube in visual studio, when i want to deploy it i get the following error: Error : The project could not be deployed to the 'USER-PC\SQLEXPRESSR2' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service …

Hi can anyone see what the problem is below I am new to c# so not sure why this code does not excute? using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace Eight_Stage { public partial class Form1 : Form …

Hi All, I am new comer in this site. Through Google serach I have found this community. Hope this site is really helpful for the beginers who wants to learn everything However I have written a query and got the result. Now I want to insert the data (what I …

Hello i have a database table | col1 | col2 | col3 | col4 | col5 | | val | val | val | val | val | | val | val | val | val | val | | val | val | val | val | val | …

Hello, i got this error when i click my button save. Error: .Net SqlClient Data Provider: Conversion failed when converting datetime from character string. please help me... this is my save button code: Private Sub btnSimpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSimpan.Click Dim check As Integer Dim …

anyone can help me please! i have a problem in coding... i want to restrict some buttons of my form if the user is not a admin i already tried this code.. sql = "SELECT Position FROM tbllogin WHERE username = "txtUsername.text"" NewDataSet(sql) if .ds.Tables("a").Rows.Count= "Administrator" Then employeeFile.btnDelete.Enabled = True …

i have a problem. i have a table that has one column that should accept one of a set of defined values. i know in MySQL i use the following command to create the table: CREATE TABLE tblstudents ( studentID int( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT, lastName VARCHAR( 20 …

HI All, I'm writing an application in Visual Basic .NET but the application will use a SQL backend. If the user runs the application and the backend database is not set up, I want the user to select a SQL Database Instance, supply an administrator user ID (sa) and Password …

i have made a database in sql+. it has a database. there is a table project. its columns are p_id,p_name,p_manager. i have inserted 5 rows in above table. in d front end in vb6 i have a form . please help me with the code such that my p_id is …

Hello I have a table item1 | Item | Qnty | ProdSched | | a | 1 | 1 | | b | 2 | 1 | | c | 3 | 1 | | a | 4 | 2 | | b | 5 | 2 | | c …

Hello I am using Apache derby embedded database: I have been using a system to display records from the database described in "DisplayInstructorAvailableNowJTable.java". it allows the result set to create a model from a prepared statement. I have only uncovered the tip of the iceberg concerning JTABLE. I am not …

Is ther a fastest way to retrieve data from sql server like the sqlbulkcopy the fastest way to insert large data.?

how do you display information dynamically?

Hi Guys, While i managed to add rows and save them in the grid. I want to know the syntax for Update the data in the grid directly. Thanks Sai private void btnUpdate_Click(object sender, EventArgs e) { string col2 = dg[1, dg.CurrentCell.RowIndex].Selected.ToString(); string col3 = dg[2, dg.CurrentCell.RowIndex].Value.ToString(); string col4 = …

Hi need help i setting up both Adding and Updating datagrid cells in the Save_Click event. Right i used seperate click events for Add_Click and Updating_Click but i want to both of them in the Save_Click event rather than seperately. Thanks in advance Here is my code using System; using …

Hi All, I have intermediate knowledge in VB.Net coding. I have searched the web to find help with my issue but to no avail. I mean I can't find one that is helpful though there are some in Web based applications. I have an urgent issue where I want to …

Hey everyone, I have the following two queries, and want to know why the first one would return a count of 52, but the second would return a count of 51 when technically they should be the same; SELECT count(*) from Inquiry Inner Join NoDecision on Inquiry.ID = NoDecision.InquiryID_fk Inner …

Hello, Can we perform bulk insert for SQL data? I have the complete SQL data in text files. There are multiple tables and the corresponding text files. I tried to do the bulk insert but always got some new error. Please help me to get an answer. My code Imports …

i have this connection string <connectionStrings> <add name="Tendering_Pro" connectionString="Data Source=HABOUSH-PC\SQLEXPRESS;Initial Catalog=TenderingProgram;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings> <system.diagnostics> AND THIS MY CLAAS : Imports System.Data Imports System.Data.SqlClient Imports System.Configuration Public Class BuyNewTender Private conn As SqlConnection Private _MSG As String = "" Private _ProjectTenderingNO As String = "" Private _TenderingNo As String …

is it possible to run mysql and ms sql at one pc ? mean local host ?

I have 3 tables in which one column name is common for all i.e PRNO .I want to write SQL query to select everything from Table1 where PRNO is 500, Table2 where PRNO is 500 , Table3 where PRNO is 500 . “Select * from Tab1,Tab2,Tab3 WHERE PRNO=500” Getting Error …

i am sending parameters to sql server 2008's store procedure but confuse that which way to send parameters mean we got 2 ways , parameters.add(parameter) and 2nd way, parameters.add("@parameter",sqldbtype.datatype).value= value so which one to use and y ?

Hi, i am having problem in updating my database although i can upadate my dataset private void btnSave_Click(object sender, EventArgs e) { DataRow dRow = ds1.Tables["ContainerID"].NewRow(); dRow[1] = textBox1.Text; dRow[2] = textBox2.Text; dRow[3] = textBox3.Text; ds1.Tables["ContainerID"].Rows.Add(dRow); MaxRows = MaxRows + 1; inc = MaxRows - 1; MessageBox.Show("Entry Added"); } but …

In my page, there are 3 drop down menu. Dropdown 1 : for storing car model which retrieved from CarTab in database (SQL) Dropdown 2 : for storing username Dropdown 3 : for storing plate num The function of the all drop down menu, there are related to each other. …

I am tasked with designing a dating site in asp.net with VB using sql server 2005 as the database platform. I have not had a lot of advanced database design experience so I am hoping someone can help me out with this one.... For each user there is a profile …