[microsoft:sql-server] Forum Topics

I am trying to write a windows application in vb.net to import data from excel to sql server. I got "object not set to an instance of an object" error. The data actually have been inserted into the sql. The following is my code. I have a button when the …

hi When i try to run a program in java to connect sqlserver 2005. Igetting the following error. java.sql.SQLException: No suitable drivers found for jdbc:microsoft:sqlserver://127.0.0.1:1433; DatabaseName=name I added the classpath properly for sqljdbc.jar file in envirnomental variable. But still i getting an error. If anyone knows the solution for this …

"Select * From CashReport where convert(varchar(10),StartDate,101)>=@pStartDate and Convert(varchar(10),EndDate,101)<=@pEndDate and Type = 'I'" [B][COLOR="Red"]Hello! i want to add CUSTOMER NAME in this code how to view each customer datewise report plz help me..[/COLOR][/B]

We use Macola Progression as our ERP at my company. Currently, it runs on the Pervasive.SQL database backend, also known as Btrieve. However, we are converting to MS SQL Server. I am (trying) to perform the conversion. With Pervasive, there is a client installed on each workstation before Macola is …

I have a sql query with that adds numerical values from different table to find total for a shipment. When I execute this query, it works fine for the first record but rest of the records show null value when I know there are records present. SQL pros please take …

[CODE]public List<EventEntity> GetCurrentUpComingEventsByEstate(string estName) { EventDBModelDataContext context = new EventDBModelDataContext(); var res = from e in context.EventEntities where e.estateName==estName && e.eventDate >= DateTime.Now select e; return res.ToList(); } [/CODE] [CODE] [OperationContract] [WebInvoke(Method = "GET", UriTemplate = "GetCurrentUpComingEventsByEstate?estateName={estName}", RequestFormat = WebMessageFormat.Xml, ResponseFormat = WebMessageFormat.Xml)] List<EventEntity> GetCurrentUpComingEventsByEstate(string estName); [/CODE] Hi guys, may …

I'm having problem to update the data into mysql database. for insert new data, it works nicely but if i want to update the existing data, it will hang my pc. even if i debug line by line, it shows like infinite loop. which part has gone wrong? i'm totally …

Hello ! I'm trying to edit and update and cancel in datagrid. Edit and cancel commands are working properly but at UPDATE i m getting this error.(Incorrect syntax near '12'). Please help me. my code is here.. [code] protected void DataGrid1_UpdateCommand(object source, DataGridCommandEventArgs e) { num = Convert.ToInt16(e.Item.Cells[1].Text.ToString()); TextBox t1, …

I have a simple ssis package that grabs data from sql server 2005 then puts that into a flat file and then sends it to my webserver. This package currently just pulls data from one db. I would like it to do this for 10 dbs now therefore creating 10 …

i am having issues with an update query. i normally use SQL 2005 but for this project i am using an access 2007 database please can anyone point me in the right direction, [CODE] Dim con As New OleDb.OleDbConnection Dim cmd As New OleDb.OleDbCommand Try con.ConnectionString = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" & …

Hello everyone, I am making a set of tables that have relational keys associated with them like an order system. Basically I am trying to store the Customer Info, then the order and so on and so forth, but I need to store the "customer" ID in the Order table …

Hi. Can someone help me with my problem? Here is where the error occurs. [CODE] da = New OleDbDataAdapter("SELECT * FROM booklet WHERE booklet_num= '" & txtbkletnum1.Text & "'", con) cb = New OleDbCommandBuilder dt = New DataTable 'this became yellow and error appears as datatype mismatch in criteria expression. …

I successfully installed SQL server compact edition to my computer. But i can not use [I]Imports System.Data.SqlServerCe[/I] with VB.Net. It's shown an error. Please help me....

I'm creating a small program to read from an SQL server, loading result into an array, pivoting the array to my liking and mailing it out to selected members of a group. It's going to be run once a day with Windows schedule. I have the connection, query and mail …

Hi, I'm currently learning C# and I'm currently learning how to do C# and Database's. Does anyone know why it isn't adding the data in the text boxes to the db. Cheers Sam [CODE]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 …

I've extracted some data from an SQL server, put it into an array, and want to mail it's content to a group of people. All quite easy, until it comes to presentation in the mail body. When I set it up manually in Excel and do Copy - Paste it …

When I execute the code below I am getting unknown column 'total' in 'field list' error. [CODE] DELIMITER$$ CREATE PROCEDURE setAuthentication(IN uname varchar(12), IN oldpws VARCHAR(12), IN newpws VARCHAR(12), OUT status INT) BEGIN call getAuthentication(uname,oldpws,@total,@pwsval); IF(total=1 AND pwsval IS NOT NULL) THEN UPDATE authentication SET password = newpws WHERE loginId=uname …

I've developed a software using VB.net and SQL server 2005. This is the connection string that used. [CODE]Data Source=MY-PC\SQLEXPRESS;Initial Catalog=studentInformation; Integrated Security=True[/CODE] But now i want to use SQL server compact edition. So what should i change in this connection string?

create table test2 (Roll_ID int ) insert into test2 values(1) insert into test2 values(2) insert into test2 values(3) insert into test2 values(4) insert into test2 values(5) i want output as RollId

I couldnt find a forum for sql so Im going to post here. If Im in the wrong forum then please move me. I have a table with following data Fields: OID, Product, Condition, QTY DATA: 1, Product A, NEW, 60 2, Product A, B, 60 3, Product A, C, …

Heya people, Here's my problem: i have a (for me quite lengthy) piece of SQL code which is automagically generated by my own application. However, when i try to execute it, it gives me an recordSet error ("Either BOF of EOF is true, or the current record has been deleted"). …

I am developing a point of sale program for a project subject. The trouble im having is when i press on the button to add the item from a textbox to a listview i receive an error: See attached Screenshot. my code is: [CODE]Private Sub SalesScreen_Load(ByVal sender As Object, ByVal …

Hey everyone, What i'm doing is building a step through form that will basically store relational keys between databases. I begin by storing Information about the individual asking about the program, I then want to query the table this was stored in to get the Unique ID that is being …

Hai , I have 2 tables 1. [B]Transport_Details[/B] having columns user_id FareStageId StartDate EndDate and 2. [B]Route_Fee[/B] having columns FareStageId monthId fees I need to get a monthwise list by passing monthid. My problem is that , if start date and enddate of a user are 02-08-2011 and 20-02-2012 and …

Hi There; I have a problem during connection to a MS-SQL server. I copy the code there: [url]http://www.webcheatsheet.com/PHP/connect_mssql_database.php[/url] [CODE] <?php $myServer = "localhost"; $myUser = "Murat"; $myDB = "examples"; //Point 1 //connection to the database $dbhandle = mssql_connect($myServer, $myUser) or die("Couldn't connect to SQL Server on $myServer"); //Point 2 //select …

Hello !! I have a windows form having combobox and textbox controls.. I have to generate a part number, consisting of combobox and textbox values included.. I can explain in detail.. This is the code i have used to define a variable "type".. [CODE] If ComboBox1.SelectedIndex = 0 Then type …

Code Warriors, I need to set a value in my SQL database as (1 or 0 ) (true or false) so that when i click a button to insert into the database the column register 1 and when i click the button delete the column register 0. do any warrior …

I have this INSERT [CODE] INSERT INTO BLOBTest (BLOBName, BLOBData) SELECT 'First test file', BulkColumn FROM OPENROWSET( Bulk 'C:\temp\nextup.jpg', SINGLE_BLOB) AS BLOB[/CODE] I want to add id, but it returns a mistake something like: [CODE]INSERT INTO BLOBTest (id , BLOBName, BLOBData) /if write "1," it returns a syntax error/ SELECT …

have been trying to display on my data grip view but is not. i want a situation where by it will display on the datagrip view base on the invoice number, below are the code Private Sub getLastID() Dim oleDBDR As SqlDataReader Dim oleDBCommand As New SqlCommand With oleDBCommand .Connection …

I am trying to do inline SQL Inserts & Updates within my ASP. When I go to the Master Page and validate the SQL I am getting The Multi-part identifier not bound on all of my TextBox and data entry fields on the panel that I am using in the …

I have tried this : [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers left join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] this [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers inner join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] error is : Subquery returned more than 1 …

Hey everyone, I'm fairly new to .Net and I am just starting to write some queries to begin using my database files, and I keep running into these errors. I have stepped through numerous tutorials and reference guides and still cannot seem to get things working properly. Basically I have …

Hi! i want to deselect a few menu items depending on the user! For example the administrator can have access to all the menu items in the form , Manager access to an additional few items and the data entry person to have access only the data entry menu item! …

Hi, I have a datarow retrieved from a datatable. I have a value that exists in some column in the datarow. I want to find which column this value is in. How can I achieve this please? Thanks

Hi, I have a value which I don't know which column this belongs to in the table. So is there a way I get get those rows that contain this value using query? Thanks

This code supposedly generate a web chart but it does not work. How is the correct way to bind data using SQL into web chart. thank you all :) [CODE]Function GetReader() As IDataReader Dim strSQL As String strSQL = " SELECT aa.alert_id, " strSQL = strSQL & " (SELECT alert_value …

Hi. Good day! Hope you could help me through this. I'm having trouble with my customize table sorting in BIDS. i used this formula in group sorting. [CODE] =Switch(Fields!AGE_CAT.Value = "0 - 1", 1, Fields!AGE_CAT.Value = "2 - 4", 2, Fields!AGE_CAT.Value = "5 - 9", 3, Fields!AGE_CAT.Value = "10 - …

Hi friends... I am using Wamp with PHP 5.3 and want to connect with SQL Server 2005 but not successful. I also tried it with PHP 5.2.8 but it still not working. I google it and found some solutions but not successsful yet. Can anyone give me detailed guide (step …

Okay so I am completely new to creating a database, and have been trying to create one in Visual Studio 2010 I found this guide on the web and have been following it pretty successfully till I came to spot that I can't get past (here's the link - [url]http://msdn.microsoft.com/en-us/library/dd193408.aspx[/url]) …

Log In Failed for User '' The user is not associated with a trusted SQL Server connection Well, that's the full title of my problem. I'm working on a C# program that supposedly could access a database run by SQL Server Express. I know the program works, because it works …

Hello all. I'm trying to keep table structures in sync across 2 seperate databases on the same SQL server instance using a DDL trigger on ALTER_TABLE, CREATE_TABLE, DROP_TABLE. Using EVENTDATA() as shown below, I can catch the TSQL that fired the trigger, but I cannot figure out how to execute …

Hi all, I've a very weird problem. Actually I've Sql setups as .iso and from those setups i need to extract binary version of "sqlsrv.exe", but it is not possible for me to install every single version of sql and install and then generate binary version so does any one …

I need to get data between year and period. 1 year have four periods. i.e; year = 2010 period = 1,2,3,4 the problem is on the period part where i could not select second period smaller from the first period. for example, i choose year=2010 to year=2011 and period=4 to …

Hi. I would like to do insert and update database using data from excel file. before i can insert any data into the db, i have to check whether the field is already in the database or not. the primary key is year_id, period_id and stock_code. IMO, to do data …

in table department i've class_id as f.k and in class table class_id as p.k i want to update class_id in department table.. n getting error

Hello.. I want to populate my combobox with the list of banknames available in my database.. I tried doing so but i am getting a blank list.. ie.. shows no value in combobox !! Here is what i tried.. Please help !! [CODE]Private Sub ComboBox4_SelectedIndexChanged(ByVal sender As System.Object, ByVal e …

Hi, I am creating a web application and i am using sqlserver 2005 as back end. I have a page with a radiobuttonlist, a textbox and a submit button. The user needs to select one option and enters values in the textbox. Once he submits the appliation need to insert …

hey guys. i need advice and guidance for a new project i want to start. imagine a company with some subsections that each one has a program and a separate database on sql server 2008 express. what i want to do is unit these apps so that all of them …

Hi all With the following SQL " Dim Query As String = "UPDATE JobName_tbl SET [JobDate]=@NewDATE, JobAddress=@Newaddress Where JobID=@ID" nothing happens nothing gets updated nor do I get an error. But as soon as I remove the [JobDate]=@NewDATE, it works fine. Hope someone can help me with this situation. Here …

Pals, I love this site with a passion. Again now i need to know how i can relate different tables together using SQL database with different field. Thank you for your responses.