[microsoft:sql-server] Forum Topics

Hi there, I'm a beginner in ASP.NET with VB and I'm stuck on problem with a SQL query. I'd like to ask you for advice what does my page or config file miss. thats how my form looks like [CODE] <form id="form1" runat="server"> <div style="margin: 0 auto; width: 180px;"> <asp:Label …

I can insert into my table by the bindingnavigator and dragging textboxes straight from the DataSet entering them and saving. But I want to insert into the DataBase via code and in order to do this I have used the below code to connect. I use this code to test …

So, I've been trying to get a page to update items in an MS SQL database forever now, trying different methods here and there having nothing working. I finally got one method to work using a datagrid thing, and it's fine for the test table I'm using. But when it …

Hi, Not sure if this is right place to post this, please move if needed. I set up a web form so that the text from a set of text boxes was inserted into a database when you 'submitted' the form Since then I have added some validation to the …

Hello, i want to know the best practice to 1. read an XML file and store it in SQL data base and 2. modify the data base whenever the XML file modified, i created a table on data base on SQL server with columns has the same names like XML …

hi everyone, I am using asp.net 3.5 and sql server 2005. I am accessing data using javascript functions. Now I need to store that data in database. Can anyone help me? Thanks for your help in advance............

Hey guys ........plz can you suggest me any project wic uses simple java and sql and may be connectivity between java and sql I am in 12th standard and want to make a good project related to above items......................

So my problem is : student([COLOR="red"]STUDENT_ID[/COLOR],name,surname) address([COLOR="red"]STUDENT_ID[/COLOR],city,number,state) additional_info([COLOR="red"]STUDENT_ID[/COLOR],what,why,when) [COLOR="Red"]IF STUDENT_ID IS IDENTITY , THEN THE PROBLEM IS EASILY SOLVED BY DECLARING A NEW VARIABLE WITH THE COMMAND SET SCOPE_IDENTITY , BUT IN MY CASE , ID_STUDENT IS FROM TYPE NVARCHAR, BECAUSE THE FORMAT OF THE ID SHOULD BE xxx/yyyy WHICH …

I am developing an application that accesses a SQL database, then displays the customer, order, and store information on various tabs. I wrote am implementing a function that opens a new form displaying the individual invoice. This new form "imports", so to speak the data from the current form by …

Hi everyone, been programming all my life. Did a little VB.NET about 4 years ago, now I'm living in SSIS scripts. I feel fairly fluent in SSIS but in the scripting language my limits are addressing the SQL db or for that matter files as well other than FSO which …

I want to raise an event in C# when any one user make an insert or an update to a certain table in SQL server via my C# program. As there are multiple users using the execution file in various locations, I can not do it using the C# cord …

I am working in windows forms in c#. I have at table in sql server which has a column named AssignedTo. This column is of varchar type and contains more than one value separated by commas. When showing in datagrid, the values are shown easily in a cell. But as …

hi i want to insert a textbox value into one column of a table. bt wht i m getting error as: Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near '{'. the code is [CODE]SqlCommand comm = new SqlCommand("insert into Sample {'email_id'} values("+ TextBox1.Text+")", conn);[/CODE] how should i do it if i dont …

I'm developing a mobile website using vb.net but having set my tools right as I read somewhere, I've having an object reference...null error from the sqladapter line. I'm trying to authenticate by checking the db for username and password and granting or denying access asthe case maybe, here's my code, …

[code=text] CREATE FUNCTION dbo.GetDuration(@FromDt as datetime) returns varchar(255) as BEGIN DECLARE @YRS AS SMALLINT, @MNT AS SMALLINT, @DY AS SMALLINT, @Fvalue varchar(255) SET @YRS = DATEDIFF(YY, @FromDt,GETDATE()) SET @MNT = DATEDIFF(MM, @FromDt,GETDATE()) % 12 SET @DY = DATEDIFF(DD,GETDATE(), DATEADD(MM, (@YRS 12) + @MNT,@FromDt) ) SET @Fvalue = CAST(@YRS AS VARCHAR) …

Hey everyone, I friend and I are trying to work our way through this, and right are having some issues in terms of getting vb.net to connect to an online sql server. We have found lots of resources to connect to local sql servers but nothing about connecting to an …

General Question, no code: I have the daunting task of automating the import of mysql, ms sql and ms access into a central location. I've nailed the microsoft crap using ms sql DTS but even with mysql odbc drivers, cant seem to nail that one. The optional is that I …

Hi, I'm using VB.net express edition with SQL server compact for a project and I need a little help. What I'm trying to do is; I want to set a certain column to true or false automatically based on what value another column has entered. I managed to get this …

I have an add/edit program I've written and I'm trying to find an example of how to test/check an Account Number that a person enters in a textbox to the database(SQL) to make sure it is unique. I've been searching and haven't had any luck. Any Advice? Thanks.

Hello, can you help me convert MS SQL DateTime to miliseconds since 1970? Thanks, Domen

DOH spelt thread name wrong... should be query! This is surely simple... this is the end of my query [CODE]where CCM0300.dbo.Device.tkModel= '72' AND CCM0300.dbo.NumPlan.DNOrPattern like '31455' OR CCM0300.dbo.NumPlan.DNOrPattern like '38600' OR CCM0300.dbo.NumPlan.DNOrPattern like '36305' OR CCM0300.dbo.NumPlan.DNOrPattern like '36805' OR CCM0300.dbo.NumPlan.DNOrPattern like '38285'[/CODE] what this is meant to do is return …

Hi I need to create an SQL to retrieve the max date for each change in stock code. can anyone assist please? I am extremely new to SQl. I used access to get external data but it drags down 60,000 odd lines. i only have 5000 line items so with …

Dear all, I am very new at SQL programming and are using the Microsoft Query to avoid alot of SQL programming, but I am stuck on one thing when I try to filter some data from the database... I want to show all delayed deliveries to our customers... Our Policy …

hi i have a query and i want to use it in remote server when i try to run it in my machine it executes ok. but in remote server it cannot be executed. im connected to the remote server and i can view all the records in the table. …

Just struggling through my SQL coursework, and already fallen over the first stubling block :( My case study tells me that i need to put a foreign key from my centre table (parent) to my salesman table (child) on a 1-1 relationship. Trying to add my foreign key, which is …

I have a form which displays related data from three different tables. There is a foreign key between the master table and the two related. Currently I have three stored procedures to return the data based of the return key value from a search. Because I am using DataAdapters to …

Hi friends, I am new to SQL.. I have a table with 200 rows and 100 columns.. I want to extract unique rows from this table such that no two row are more than 60% similar.. this 60% is a variable and would be user defined.. I have attached an …

Hi there I am working in Visual Studio 2005 Pro. I have created a WinForm with access to a SQL database. On the WinForm I have two listboxes, the displays DivisionCode and the other DivisionID both having the same DataSource but different DisplayMembers. They occupy the same space on the …

Hi I am using ASP.NET to upload files that is to be stored in MSSQL Server 2008 as varbinary(MAX). I have issues with opening scanned pdf files once users upload them. The issue is happening very randomly (say 20% of the files cannot be opened .). It seems something is …

ive set up a connection string and whenever the program hits myConnection.ConnectionString, it will appear such an error : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that …

I can't get past this error in my loop through the data reader specifically dr(12). I tried adding .To String but that doesn't seem to work either. Can someone help me with what need to do so it can read even if there is a Null value. My code is …

hi Guy's i got error Object reference not set to an instance of an object and it show me the Highlighted area private void time_in_Click(object sender, EventArgs e) { employee_InformationDataGridView.SelectedCells[0].Style.ForeColor = Color.Green; time_in.Enabled = false; time_out.Enabled = true; DateTime today = DateTime.Today; int i; i = employee_InformationDataGridView.SelectedCells[0].RowIndex; SqlConnection conn = …

I have created a form in which there are various values such as Name, Address, Date of Birth etc. The user is also allowed to select an image in a picture box. I want to insert these values along with the Image into database in appropriate columns. Any help is …

I have converted image to byte array and vice verse, saved it in db and binary file thousands of time, but now i encountered by a really stupid exception: "Parameter is not valid." there is another thing that made the issue more funny. I CAN LOAD THE IMAGES IN ACTIVEREPORT …

Hello I have 2 databases, one is like a backup for the other. So they have identical tables: Alarmi, which has columns: OBJEKT, OPIS, VREDNOST, START, E_A, UPORABNIK I want to compare those two tables and copy only new entries (rows) to the backup database. How can I do that? …

Hi.I am very new to the vb.net programming. Now I am trying to connect the database that is sql server 2005 to the vb.net code so that I can add the data to my database, which is already in the sql server and retrieve the required data from the database. …

Hello, I am developing a mobile application (school project) using a Windows Mobile 6 Professional emulator. This application has a login function that prompts for a password and uses a Data Access Object(DAO) to connect to a SQLServerCE database. This database has a table called User which stores the password. …

Hy Guys, I am having serious problem in uploading database to 123 reg server. I have Windows hosting package which supports ASP.Net andSQl hosting. I have managed to upload website to server and it works fine, the database I have is ASP.Net generated database and I have used Published to …

hii alll, i am working on very simple gridview control.i m able to edit update n cancel bue AS SOON AS I CLICK ON DELETE :I GOT EXCEPTION AS : Object reference not set to an instance of an object. [CODE]protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { GridViewRow row = …

I am developing a website in ASP.net 3.5 where there is a very big database. I have to show data on one single page dynamically changing from the database and that database will contain data of about 4000 pages having text and images. With formatting tags and lot of tags, …

hello pls tell this same code for the MS SQL server data base..

I have this code [code] Public Class Form1 Private connectionstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=c:/testn.mdb" Dim conn As New System.Data.OleDb.OleDbConnection(connectionstring) Dim cmd As New System.Data.OleDb.OleDbCommand Private ssql As String Dim dr As System.Data.OleDb.OleDbDataAdapter Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click conn = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;data source=c:\nikhil\testn.mdb") …

My requirement is that i have two sections Admin and User - [B]Admin[/B]: textbox to add NEWS to MS SQL database. [B]User Home page[/B]: News scroller that reads the news from the database and displays (scrolls right to left) it Both admin and user page is done in [B]ASP[/B]. Please …

Hello, I have downloaded "Microsoft SQL Server JDBC Driver 3.0" and tried sample code. I added "sqljdbc.jar" and "sqljdbc4.jar" in Libraries. But getting error, [COLOR="Red"]java.sql.SQLException: No suitable driver found for jdbc:sqlserver:bug_tracking at java.sql.DriverManager.getConnection(DriverManager.java:602) at java.sql.DriverManager.getConnection(DriverManager.java:185) at Main.main(Main.java:18)[/COLOR] The code is given below : [CODE]import java.sql.*; public class Main { public …

I am having trouble connecting to a sql database. I have vb.net and it came with vs 03. I have doen a varity of simple programs with vb. I have recently added a server with sql 08 and connected with a workgroup. When I use vs to put a sql …

I am developing a software using vb.net and sql server as database.It takes name of my computer as a connection string.when i load this software on other computers it searches the name of my system.how can i define a connection string that automatically takes the name of system on which …

Hi friends.When I try to connect to sql server 2008 from visual studio 2008 an error occurs : "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL …

I'm retrieving immediate next record from database table using empcd(employeecode) [for which code is given below]. I wanna retrieve "next record" details from SQL SERVER 2005 with a Button Click Event but not using "EMPLOYEE ID". (SqlClient.SqlConnection) i want to access database table nextrecord directly using either query or Logic. …

I am creating a sample database and the work is so painful, I really wonder and need assistance to reduce my pain. I would like to create a "lookup Field" which returns the value (string) automatically from another table. Example, I have 2 tables - Department and Employee Department[DepartmentID, DepartmentName] …

So my group and i have been working on a ASP.net website for a tech prep showcase. We currently have connected the MS Sql Database that comes with Visual Web Developer. We are currently having a problem gathering data from the SQL Database and seeing if it is equivalent to …