[microsoft:sql-server] Forum Topics

Hey everyone, I am lost on the exception that I have getting thrown at me right now. SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. What I am trying to do on my site, which is Windows Authenticated on an internal network, is capture the users …

[CODE] Dim connectionString As String Dim cnn1 As OleDbConnection Dim cmd1 As OleDbCommand Dim sql1 As String connectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = d:\sprrg\sprrg.mdb" sql1 = "update po_detail set po_number=" & txtPoNo.Text & " where po_number=0;" cnn1 = New OleDbConnection(connectionString) cnn1.Open() cmd1 = New OleDbCommand(sql1, cnn1) cmd1.ExecuteNonQuery() cmd1.Dispose() [/CODE] The table …

Hello people,I hope everyone is well. I am having problems with my connection string. It seems its not detected at all. I am designing a Silverligtht app with a Linq to SQL connection for the data. Here is my code.[CODE] ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["DataConnect"]; string connection = settings.ConnectionString; DataContext dataContext …

Hello, I have a table with clients: id, name, email and the likes I am looking to find all ID's where emails are the same, I tried the following [code]select db_email, db_medlem, count(*) from kunder group by db_email HAVING count(*) > 1;[/code] however this generates an error due to not …

What I am trying to do? update a database field with a richtextboxfield. Please help. I have tried using Dim range1 As New System.Windows.Documents.TextRange(RichTextBox1.Document.ContentStart, RichTextBox1.Document.ContentEnd) but this did not work for me either. [CODE] Dim cnn As SqlConnection Dim connectionString As String connectionString = "Integrated Security=SSPI;Initial Catalog=rploperations;Data Source=" & Environment.MachineName.ToString …

Good day!. I have here a SQL database named Database1 and it has a tables (StudentID, Student name, Age, Gender,) vb.net and i want that if i input a records in vb.net it automatic save to sql database. Help me please.

Hi every 1 i am trying to register an employee but for some reason my record is inserted twice. if i enter all details of employee and when i click save..after that if i chk my employee list i could see same record entered twice.here is my code. Private Sub …

Hi guys well I have successfully got my update query to work correctly. Now I have two tables in my database. What I want to do is when I click my play button not only does it update my column's in my first table but all updates my colunms in …

I know this might be a very simple one, but yet I can't figure that one out! How do I get data from one table that are not in another? Let's say Table ServerA has: IP, User, Password, Table ServerB has: IP, CanConnect. If ServerA has 20 rows and ServerB …

gents please help on the following. I'm creating an small application where I search from the databse table tems and add the result line to a datarow of my datatable "dt", I the set the datagridviewe datatsource to this same dt. My question is: How can I save this dt …

Create procedure [dbo].[usp_read_Data] as begin select EntryDate,[FileName] from tblInfo end

How can I ensure that the stored procedure below is able to use either one or all the parameters to filter records from a table? CREATE PROCEDURE ABC @StartDate datetime = null, @EndDate datetime = null, @UserId varchar(255) = null, @AccNo varchar(255) = null AS BEGIN IF @StartDate IS NULL …

Hi, When i run the codes i donot get an error, howveer after clicking INsert i get the Syntax error in Insert Into statement error. I do recieve the COnnected MsgBox which then results in the error My code.. Sub connect() Dim acsconn As OleDbConnection = New OleDbConnection _ ("Provider=Microsoft.jet.oledb.4.0;data …

sry guys but i am new to MVC i just want to ask if it is possible to assign a connection string to a particular user from a database (Example) i want to restrict user from selecting a table, which can be done by using SQL Managment studio. This is …

Hello to all, I am calling connection string from app.config string str = ConfigurationManager.ConnectionStrings["Bank"].ConnectionString; SqlConnection con = new SqlConnection(str); my app.config file is <configuration> <connectionStrings> <add name="Bank" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=D:\BankManagement(2)\BankManagement\bin\Debug\BankManagement.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings> </configuration> bt i am getting compilation error: Error 1 A field initializer cannot reference the non-static …

Hi, I am a new programmer of vb.net. My combobox1 has a value of name1, name2, name3, and i want that if the user already choose name1, he/she cant re use that name1 again. and that is autosaved to sql database. help me please!

i am try to systemdate and rem_date compare but error message is "Incorrect Syntax near'='" [CODE] Dim adp As New SqlDataAdapter("select * from reminder", obcon.con) Dim dset As New DataSet adp.Fill(dset) datagridview1.DataSource = dset.Tables(0) obcon.con.Open() Dim cmd As New SqlCommand("select rem_id,rem_hour,rem_min from reminder rem_date=" & Date.Now.Date.ToString & "", obcon.con) MsgBox("select …

Our prof gave us this code Dim sql As String sql = "INSERT INTO OrderDetails" _ & "(orderid,prodid,price,qtyordered,amount,status)VALUES(" _ & "'" & OrderDetail.Orderid & "','" & OrderDetail.Prodid & "'," _ & "'" & OrderDetail.Price & "','" & OrderDetail.Qtyordered & "'," _ & "'" & OrderDetail.Amount & "','open')" I know this …

will someone help me on how to solve this error? The database 'D:\FEB. 29, 2012\WAIS SYSTEM-UPDATED JAN25\WAIS SYSTEM\BIN\DEBUG\WAIS.MDF' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported. Could not open new database 'D:\FEB. 29, 2012\WAIS SYSTEM-UPDATED JAN25\WAIS SYSTEM\BIN\DEBUG\WAIS.MDF'. …

[CODE]insert into po_detail (item_code,qty,item_rate,item_tax) select a.item_code,qty,item_rate,item_tax from mr_detail a,mr_head b where a.mr_no = " & combo_mr_no.Text & " and a.mr_no=b.mr_no""[/CODE] what's the error in the above code ?

My .Net Code [code=c] # connDO.Open(); # SqlCommand comm = new SqlCommand("DOrders.dbo.p_Update", connDO); # comm.CommandType = CommandType.StoredProcedure; # daDirectOrders.UpdateCommand = comm; # # comm.Parameters.Add("@UOrderNumber", SqlDbType.Int, 32, uOrderNumber.ColumnName); # comm.Parameters.Add("@ConfirmationCode", SqlDbType.VarChar, 50, confirmationCode.ColumnName); # comm.Parameters["@ConfirmationCode"].SourceVersion = DataRowVersion.Original; # comm.Parameters.Add("@Carrier", SqlDbType.VarChar, 50, doCarrier.ColumnName); # comm.Parameters.Add("@Tracking", SqlDbType.VarChar, 50, doTracking.ColumnName); # comm.Parameters.Add("@OrderID", SqlDbType.Int, 32, …

hi everyone, I wish to share the mdf file on the network so that other computers can use the file to capture or retrieve the data. Is there any way I can do this on MS SQL SERVER 2005?

Below dynamic query will set StartDate and EndDate to 1st of March to 30th April as UK financial year. DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 …

Hello people,I hope everyone is well. I am having problems with my connection string. It seems its not detected at all. I am designing a Silverligtht app with a Linq to SQL connection for the data. Here is my code.[CODE] ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["DataConnect"]; string connection = settings.ConnectionString; DataContext dataContext …

Hello Guys, I am trying to get the data from two columns of two different tables using Join as combining them as a whole to insert into dropdownlist... The situation is like this: There are two tables named tblPropertyCategory and tblPropertySubCategory.. I have PCName in tblPropertyCategory and PSCName in tblPropertySubCategory.. …

This Code is easy way to load / show data in Datagrid. This Code write in vb.net 2003 and use sqlserver 2000 as database. I use module to connected VB.Net with SqlServer 2000. so the function to connected can be use in every form in this project.

Well, when almost finishing this tutorial: [INDENT][/INDENT][url]http://msdn.microsoft.com/en-us/library/ff677562.aspx[/url] I found a problem on connecting the Add-in to the database, and so the lobInstance can´t be opened: [url]http://i.stack.imgur.com/AFzie.png[/url] This is the error code. (in fact the error message was being popped out when the Excel 2010 client starts, but I commented the …

Hi there, I just bought Dell XPS 15, with 500 GB HDD I have habit of using 3 partitions. One for System, 120 GB 2nd 190 GB 3rd 190 GB But now, there is recovery partition of 13.4 GB, C of almost 200+ GB & Another of again 200+ GB …

Whenever update the values in the text box.. its not submitted and update in database. Thanks and regards Here is my code : namespace sys.System { public partial class spareedit : System.Web.UI.Page { SqlConnection dbCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["sqlServer2"].ConnectionString); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { dbCon.Open(); SqlCommand …

Hi, I recieve the following error message: "java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression'name '" when I run this statement: [CODE] sql = "INSERT INTO empDetail VALUES("; sql += txtName.getText()+ ", "; sql += "'" + txtAddress.getText()+ "', "; sql += "'" + txtSuburb.getText()+ "', …

In Visual Studio 2010, I have a windows forms application frmMain.cs with a ComboBox. From the form itself I can access its value with cmbxYear.SelectedValue. I also have a DataSet.xsd file to bind to an rdlc report to a TableAdapter to present view data. The TableAdapter has a SelectCommand that …

In my application, i have put a question on form closing if the user wants to save the changes?. But right now, i have just put it in default whether they make changes or not. I thought of prompting it on text change.. but the text automatically changes on load …

Hi everybodies! How increase ProductId inside Product_Table when insert a new product according to following approach? Language_Table: Id Code --------- --------- 1 ka 2 en Product_Table: ProductId ------------- 1 2 Product_Translation_Table: TranslationId Title ProductId LanguageId -------------- ------------------- ------------- ------------ 1 Kompiuteruli 1 1 2 Computer 1 2 3 Radio 2 …

I know this has been asked many times before so I apologize but here's the php file that's generating the error on the "if($stmt = $this->conn->prepare($query))" line: [CODE]<?php require_once 'includes/constants.php'; class Mssql { private $conn; function __construct() { $dbServer = DB_SERVER; $dbName = DB_NAME; $conn = new PDO( "sqlsrv:Server=$dbServer;Database=$dbName", NULL, …

Hi guys!I'm currently making a database project and I want to update an access database. I connected the database using this sql command 'select*from word' And I tryied to update the database using this code ds.tables('word').rows(0).item(1)=”cat” Dim cb as new oledb.oledbcommandbuilder(da) da.update(ds,”word”) da is a data adapter ds is a …

Hi all, first post here, please excuse the newbieness!! I am a complete and total beginner to web development in all forms other than mediocre HTML and CSS. Please be gentle and use small words!! :-) I have recently installed Microsoft's Visual Web Developer 2010 Express in order to have …

The problem is that it will show 2 the same result but with different employee fname. How to have something like this . "Employee.employee_id has employee.fname " It will show also lots of result if I will not use distinct. Select distinct TRANSACTION.TRANSACTION_ID ,CUSTOMER.FNAME ,CUSTOMER.LNAME,PET.PNAME,Employee.Emp_ID,Employee.fname,TRANSACTION.DATESTART,TRANSACTION.DATEEND from(TRANSACTION) INNER JOIN CUSTOMER ON …

hi every one i just need some general ideas about a booking system. I have already done login and registration processes. And i am gna have customer registration and booking aswel which i can add,delete or update. its a vb.net application with sql server 2008. Can you give me any …

Aside from sql injection if I sanitize data before querying or sending it to a database are there any issues that needs to be addressed concerning security of a web app? im building an e commerce from scratch as part of a school project using notepad++ and xampp. any recommendations? …

Hello, I recently migrated our ASP.NET application to another server. We copied everything exactly as it is, from ASP.NET files to SQL Database with its stored procedures and everything. Now when we goto the app's root directory, the login page pops up as usual, we login and everything is fine …

Hey guys, I am creating a form that allows a logged in user to enter a new password for their, account, I already have the query set up to update the password, but in my form I have the first input set to take the existing password, which must match …

this is my query for displaying monthly business [CODE]select convert(varchar,dateadd(month,datediff(month,0,inv_date),0),101) as 'months with date format', sum(inv_amount) as 'business' from invoices inner join customers on customers.cust_id =invoices.cust_id where fname+' '+lname='lala fazlani' group by customers.cust_id,dateadd(month,datediff(month,0,inv_date),0) order by customers.cust_id,dateadd(month,datediff(month,0,inv_date),0) [/CODE] So when I execute this command, It gives me this result [url]http://img821.imageshack.us/img821/6492/sqle.jpg[/url] [url]http://img341.imageshack.us/img341/538/chartv.jpg[/url] …

Hi I've got a 2 col drop down list that gets its values from an SQL Server DB Table called List. The field that the drop down list uses is called SurName this would only display the surname for each record in ascending order. I have now extended the drop …

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Services; using System.Data.Common; using System.Data; using System.Data.SqlClient; namespace modalwindow { /// <summary> /// Summary description for WebService1 /// </summary> [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.ComponentModel.ToolboxItem(false)] // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment …

Hi everyone, ALTER TABLE preventiveRecord ADD Verifiedbymanager BIT NOT NULL CONSTRAINT preventive_verify DEFAULT 0 WITH VALUES ALTER TABLE preventiveRecord ADD Verifiedbysupervisor BIT NOT NULL CONSTRAINT preventive_verify DEFAULT 0 WITH VALUES SELECT [ID] ,[Date_Done] ,[Date_Due] ,[SME] ,[Status] ,[History_ID] ,[Remark] ,[Verifiedbysupervisor] ,[Verifiedbymanager] FROM [demo].[dbo].[preventiveRecord] Here is my query : from d in …

Hi, I'm wondering if anyone can help me develop the right sql query. I'm trying to select a "customerNumber" in table 1, but only if it doesn't exist in table2. I tried this [CODE]Select Table1.customerNumber From Table1, table2 Where table1.customerNumber NOT IN (select table2.customerNumber from table2) [/CODE] It isn't right …

Hi.. I'm developing a website for the first time in visual web developer using asp.net and sql sever database. I have designed my pages and master page. I have created my sql server database too. Please could you help me how to connect the database to asp.net master page? Also …

I cant load the image from database please help.. [CODE]strsql = "select top 1 id,shape from table" set rsgetimage = server.CreateObject("adodb.recordset") rsgetimage.open strsql,application("connectionstring") Response.Expires = 0 Response.Buffer = TRUE Response.Clear Response.BinaryWrite(rsgetimage("shape")) Response.ContentType = "image/png" rsgetimage.close [/CODE] it just display an x icon - thanks

Daft subject header, but its early and brain not awake yet! One for the SQL gurus (either that i've missed something here....lol) I want to select rows where there are duplicates of data in some columns, but not others. Where a duplication IS found, i want to return all rows …

Hello guys, I'm currently trying to rework an older project. It uses the Dao interface to connect to a MS-Access database. It now needs to connect to a SQL CE Database using the ADO driver. However, I keep getting the IDispatch error, see below. CJapRecordsets is a class with membervariables …