[microsoft:sql-server] Forum Topics

hello! i have shifted my application from mssql server 2000 to mssql server 2005 , now the prob is the command object is not returning the recordset if command text is stored procedure , here is my code please check it and guide me through errors . [ICODE] dim cmdsp …

I'm having some issues with this code: [CODE] Imports System.Data.SqlClient Public Class loginForm Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load '--Connection string to POS database Dim loginFormConnection As New SqlConnection("SERVER = localhost\SQLExpress; DATABASE = POS; INTEGRATED SECURITY = true;") '--Check to see if Windows Point …

I have a combo box which help me select SQL servers in my local computer, but now I want it to be able to select just any connected servers (like remote servers) as possible, how could I solve it??? [CODE] Sub server(ByVal str As String) con = New SqlConnection("Data Source=" …

Basically I have a trigger that is fired off whenever a workorder is reopened to close it again. The trigger works perfectly but I want to track the workorders where there is an attempt to reopen it. so basically if workorderid 8 is attempted to open again I want to …

i have two tables in my sql database one is "vendor" and other "purchase_order" they both have one common attribute "vendor_name" my problem is that i want vendor name in my "purchase_order" table to be same as that in "vendor" table but vendor_name is not a primary key in "vendor" …

hi Guys, i have several clients on a LAN network, these clients all have access to a particular sql server. i want to write an application that allows any client on the network to send one or more messages to another client on the network providing that both clients have …

I'm trying to create a webpage that will allow the user to input a vendor number(text box) and if the number exists populate the form with vendor name, phone and state using a stored procedures. Below you will find the stored procedures and after it my webpage. Stored Procedures: SELECT …

hi i am using asp.net with c# i get this problem when i try to enter date grater than 12 "String was not recognized as a valid DateTime." i am using sql server 2005. In the table field is in datetime format.In the procedure its is also taking as datetime.and …

Hi there I was wondering if their is anyone who can convert this statement from 'INSERT' to 'UPDATE' as I cannot seem to do is. Code can be seen below: [CODE]public static void COUNT2( ) { try { ResultSet res = stmt.executeQuery("INSERT INTO TABLE2 (VIDEOID,VIDEONAME,DIRECTOR,RATING,PLAYCOUNT) SELECT VIDEOID,VIDEONAME,DIRECTOR,RATING,PLAYCOUNT FROM TABLE1" ); …

package com.batch; import java.sql.*; import java.text.SimpleDateFormat; import java.util.ArrayList; import DBConnection.DBConnect; public class Batch { @SuppressWarnings({ "unchecked", "rawtypes" }) public ArrayList BatchAction(String ik) { Connection conn = null; Statement st = null; ResultSet rs; ResultSet rs1; ArrayList al = new ArrayList(); conn = DBConnect.getConnection(); final SimpleDateFormat monthDayYearformatter = new SimpleDateFormat( "dd …

Do anyone could tell me how to display the date from the sql to a jtable?

Hi, I am having problems with deleting part of a record. The record has approximately 15 different fields, and I only wish to delete 3 of them using the following piece of SQL coding: DELETE [PMID 1], [PMName 1], [Price 1] FROM Subscriptions WHERE [Customer ID]="001" The code works absolutely …

I have to create a stored procedure that will view data from a table. The user will audit the data, with paid dates. The user comes back to the view report, check/select all lines that have the same paid dates to change. The user will enter the paid date, then …

Hi all, I am fresher in asp.net. I have entered values in text box. when i clik OK button, values of text box should be displayed in Grid View.after that if i click on save button the values in grid view should store in sql server(backend),also insert, update ,delete operations …

String sQueryShow = "SELECT SUM(pf5_showplaylists.runningtime) FROM pf5_showplaylists WHERE pf5_showplaylists.showID = " + ShowID + ";"; HOW CAN I GET THE RESULT OF THIS SQL STATEMENT INTO A VARIABLE SO COULD DISPLAY THE OUTPUT IN A MESSAGE BOX? (URGENT, REALLY URGENT..)

i create an applicaton in c# now i want to make a 1 clicksetup file that includes windows installer,ms sql server 2005 and ,netframewok. Sql server should be automatically configured to sql server authentication mode with a new user name raj and password 123. Plz help me guys

[QUOTE]I'm trying to list user who was used their 80% of allowed quote on SQL Plus Can you run [B]dirquota quota list [/B]command on SQL PLUS? Any help will be much appreciated!! Thanks :)[/QUOTE] [CODE]dirquota quota list/minused: 80%[/CODE]

Hello all, I am new to python and working on a school project to import an SQL query with python and have it print out results then save them to a file location. This is what I have so far and wanted to know what I am missing or if …

Hi Friends!! I am coming across this problem that whenever I am trying to retrieve the data in a dataset Through database, it is taking around 10 min to get the data no the localhost. And when I am running the same code on the live server it doesnot take …

am using vb.net and sql database. My tables are as follows: Details: Details_ID (PK) Address_1 Address_2 City Postcode Country Email And Customers: Cust_ID Customer_Name Notes Details_ID(FK) When i insert data, it fills in the tables but the Details_ID comes as Null. I need the Details ID to correspond with the …

My sms gateway save message data in log(MSSQL) in Hex code, like this: 0046003A0062006F006B0040007700650062006D0065006400690061002E0070006C These are Unicode message (16 bits per characters) Each 4 characters is AsciiHex representation of a character (in hex): For example: “0046” = 46hex = ‘F’ “003A” = 3Ahex = ‘:’ how can I convert this …

I am working with a database application and am currently having a problem in joining the tables.. Table 1 : Materials -- Columns (item_code PK,item_name,p_rate,n_rate) Table 2 : Projects -- Columns (proj_id PK,proj_name,etc,etc) Table 3 : Proj_Mat -- Columns (id PK,item_code FK,proj_id FK,qty) Here Proj_Mat works as the bridge table.. …

Hi, Any one please help me out. Server: In Windows 2008, am having the database file (*.bak ) in the following locations [CODE][B]C:\program files\Microsoft Sql server\backup\test.bak[/B][/CODE] I needs to copy, the [B]test.bak[/B] file in my local machine (windows xp) in the following path[B][CODE] C:\backup[/CODE][/B] Using batch script, i needs to …

I am getting data from sql 2008 using stored proc in crystal report in vs2008.But when I try to add stored proc in wizard for crystalreport it gives me error.it shows oledb activex designer error.

Hi, How do I design a table column named UpdateDate that will give the default date and time upon inserting a record into the table I'm using Enterprise Manager in MSSQL Many Thanks

Hi everyone, Its weird. Only UPDATE sql statement cannot process and others like INSERT, select can work.. i used UPDATE sql statement in c# but the record that i wanted to update isnt update at all.. here my code.. i am using ms access [CODE] OleDbConnection connDBString = objDB.GetDatabaseConnection; connDBString.Open(); …

i have a combobox i want to show all the student name in it , i am using mssql database , and when we select student a textbox will show the rollno of that student , please help me

hi friend's i have a problem in reporting according to the date i have to save the date in a navarchar format in sql table but i dont know how to define my date and how can i make a Reporting period based on pleasee help meeeee pleasssssssssssssssssssss:(

So now that im using excel 2010 and saving data in .xlsx format, I have a problem doing something very simple, like reading the file and trying to run a simple sql command on it... [CODE]SqlConnection con = new SqlConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Download Report Sheets\Schedule List\SoftwareDownload_OS732_20120306.xlsx;Extended Properties=Excel 12.0 Xml;HDR=YES"); SqlDataAdapter da = …

Well something is missing of me (again :P) and I need some help.. I am trying to get files for my database and load it into comboBox. But for some reason I get systax error.. As I mention into other post I am not familliar with VB so please check …

Hi all, SQL definitely is not my area of expertise, so I need help with something. Suppose I have 3 tables (I'll try and keep this is as simple as possible): - User (with UserID). There are 13,000 records - Status (StatusID as the PK). There are 10 records - …

I have developed following web service in vs2008 but cannot resolve th following error System.Data.SqlClient.SqlException: Arithmetic overflow error converting varchar to data type numeric. here is my web service code using System; using System.Linq; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Xml.Linq; using System.Data.SqlClient; using System.Data; using System.Configuration; [WebService(Namespace = …

I have made a web service to insert product details the web method is as follows [code] using System; using System.Linq; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Xml.Linq; using System.Data.SqlClient; using System.Data; using System.Configuration; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] // …

Hi everyone; I am working on a windows form project on VB.NET and am required to take the user submitted text from the textboxes on the form, to a networked database. I am guessing using an SQL database, so how would I set this up and implement all of this? …

i want to populate a listbox from a sql database and foll is the code i encountered error with: Dim con As SqlConnection Dim cmd As SqlCommand Dim lrd As SqlDataReader Dim dsitemlist As New DataSet con = New SqlConnection("Data Source=DHAVAL-PC\SQLEXPRESS;Initial Catalog=final;Integrated Security=True") con.Open() 'cmd = New SqlCommand("select Stud_RollNo from …

is it possible to create a view with a primary key.. if so... how can i do that using a query of t sql.. anyone.. help..:?:

I have a strange issue going on here. I have a button named btnLookUp that when clicked performs a search in a SQL database using an ID that is input into a textbox named txtIdNbr. I have data in all rows of the database and have verified it more than …

I have two forms; I'll call them frmReturn and frmReturnItem. FrmReturn is bound to data in a SQL table; data entered in frmReturnItem is stored as a child table in SQL. In the database, there is a one-->many between Return and ReturnItem. frmReturnItem can be opened only from frmReturn. frmReturn …

Hi! Please help me with my search functionality...searching using textbox and retrieving the data into a listview. here is my code: [CODE]openrstJCcaseInfo "select * from JCcaseInfo" If Not rstJCcaseInfo.EOF Then caseinfo.ListItems.Clear Dim m With rstJCcaseInfo While .EOF = False If LCase(txtsearch.Text) = LCase(rstJCcaseInfo.Fields("CaseTitle").Value) Then Set ls = caseinfo.ListItems.Add(, , rstJCcaseInfo.Fields("CaseStatus").Value) …

I sence victory been battling the this code for 2 days now. the code i have generated is [CODE] strsql = "delete from cg_security_user_right where user_id= " & TextBox1.Text & " role_id=" & TextBox2.Text & ""[/CODE] it comes up with this error Syntax error (missing operator) in query expression 'user_id= …

I start my project in vb.net backend is sql server i have completed my design now i start my coding but i am confused for connectivity code whether i used dataset or datable which is good? please give me best connection code for retriving,updating and deleting data from database..

Hi , i have problem i have made C# Application using SQL SERVER 2008 R2 I want to make deployment to setup my application with database One setup File to install my application without manually setup SQL SERVER 2008 R2 _____________ i have read many articles but didn't get _________________ …

I made pages for login and register. I use WSAT for giving privilegies to users. I split them into two groups: Admin and Users. When the administarator login into application, he is redirected to ADMINpage. there I want to set gridwiev with informations for users. ID and USERNAME and rights …

Hello Every one can any body help me how to start with ssrs(sql serevr reporting service ??how to isntall and configure it.. I have SQL server 2005 installed on my machine.. Thnaks

Hello friends, hope you guys are dong well. problem again and really looking up to my expert friends here. I'm new and trying to write Edit code in VB.NET. the problem is [B]Select * From Application Where Sl_No='" + txteditno.Text + "'", con) [/B]is not displaying and record although it …

please help me on my school project it is called "faculty evaluation system" my project is used to evaluate faculty members,i will use the following softwares, visual basic 2008 editon, ms sql server 2000, and crystal reports, what i want to do is their will be a question and it …

hi every one i have a customer and booking data sets on my form. customer id is a foreign key in booking table .but when i click delete button. it gives me an error The DELETE statement conflicted with the REFERENCE constraint "FK_Booking_Customer". The conflict occurred in database "photoshoot", table …

hi every 1 i am trying to copy stored Employee id and i want to show it on a customer registration form. Basically i want to show which employee severd which customer. below is my code could you plz check or modify it thanks Dim Con As New SqlConnection Dim …

Does anybody if something like this exists? I am trying to write a small program to plan appointments. And have a overview of them in some sort of calendar(not the mini calendar which you can get from the VB control). Found some website who offer such controls, but honestly $1k …

[code]using System; using System.Linq; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Xml.Linq; using System.Data.SqlClient; using System.Data; using System.Configuration; [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. // [System.Web.Script.Services.ScriptService] public class Service : System.Web.Services.WebService { …