[microsoft:sql-server] Forum Topics

Hi, In C#, i got sql Exception which consists of 2 lines. I need only the 2nd line of that Exception only. Ex: The transaction ended in the trigger. Table Validation failed - Name: x; Condition: m!=0 i need "Table Validation failed - Name: x; Condition: m!=0" only. I have …

hi, Question 1 i am developing a project in C#.Net, and when a form loads data from the SQL client database is added to four combo boxes in the form, i need to change the data in the combo box when the check box is ticked. I wrote a code …

hi, i am doing a project in C#.NET desktop application. how can I make a upload, retrieve functionality in C#.NET desktop application for pdf documents, I am using a sql client for the moment, so i need to upload the file(file path, content, title in to the database) how can …

Hello, everyone..... its not an issue about how to connect to access using odbc since i did it already: [CODE] Imports System.Data.Odbc ...... Dim ODBC_CON As New OdbcConnection("dsn=DBMS Project") Dim ODBC_READ As OdbcDataReader Dim ODBC_COMM As OdbcCommand [/CODE] [CODE]although my problem is the code on how to select/insert/modify or update …

guys I need to populate all the values of a specific column in each rows of my table from my database. The specific column that i need is the "position",I'm using sqldatareader here's my code. I know that I need to use looping statements and the items.add properties of the …

i want to insert multiple int values selected from dropdown in to a single column seperated by a delimiter(,) along with this values there are some other rows too in which some other values are inserted a table has Booking id which contain values like 1 and roomid which contain …

Our employees have an interface to enter their vacation days. The vacation dates are stored in the database as one row per day, minus the weekend days. I'm trying to create a report that will show the starting and ending dates for each employee. Note: Each employee can have muliple …

In my MS SQL 2005 i have given "[B]Windows Authentication[/B]". Now how to connect with NETBEANS?? I means wat to give in User Name and Password fields?? I tried to give my User name and password while login into Windows. But not working. I am getting this error [COLOR="Red"]"the user …

hello everyone i had created 5-6 crystal report in my vb.net project with back end sql server 2005 and i had given my path for crystal report. after this i had creted setup and deployed at customer machine but there it dosn't shows any report instead of it gives an …

code for saving javascripts info in data base whats the procedure rishi waiting for ur reply<EMAIL SNIPPED> sql server 2005 database vb.net

hi, i'm working on windows application and sql serverCE database i write this code: [CODE] private void enregistrerBtn_Click(object sender, EventArgs e) { if (!exist) { SqlCeConnection conn = new SqlCeConnection(); conn.ConnectionString = @" Data source= |DataDirectory|\Database1.sdf"; try { conn.Open(); } catch (Exception ex) { MessageBox.Show(" connexion failure"); } finally { …

Hi again............ I have got something new that........... i was using MS Access as the database with my JAVA Japplet.... In my applet i used JTextArea to display the output ..... The output to display is fetched from the database which is connected using DSNless connection as with connection string... …

hi frndz i m making a project on hospital management in cSharp n in that i have made a form of "patient registration" in that i have taken ten textbox for diff entry.... n i want to coonnect this form with patient detail table in sql in that table i …

hello all, i am new to VB. i am trying to execute SQL Stored procedures from a macro in excel. but i fail to do so. i managed to write a code that imports a table, but not to execute a SP or a function. heres my code: [code] Sub …

I am using Data Reports throug Data Environment, and using Relational Database in MS Access.. I have prepared the query throuh SQL Builder(in data reports) and the query is running OK , but how can I pass parameter in this query to show the results on the data reports..... my …

hi experts i m facing a problem , i m using these code for inserting data, but showing error “[B][U]The Conversion of the char data type to a date time resulted in an out-of-rang date time value . The Statement Has been terminated[/U] [/B] “ Their is "[B]ro_date[/B]" is [B]datetime[/B] …

hi, i'm working on a windows application with database sqlserverCE and my question is how connect to the database without writing where it locates in the connectionstring ( i mean auto connection ). i hope you can help me. thanks.

ok, here's the thing: If I were to create a fileserver website like Microsofts SkyDrive then how should I structure the database? There are incredibly little information about database structure on the internet (web security too) and I've searched a whole lot. Should I create a table for every user …

hi........ can anyone tell me the connection strings to connect JAVA JAPPLET to sql server 2005 database and also the execution of SQL statement in java thanks

I have created a Database with some related tables say Customer and order and they are joined with the CustID i have created the main form and the subform and linked them together. My problem is if i say put in the key where they are joined for the 1st …

setting a keyID in new form, then setting image related to keyID - Null problem Hi I am stuck - I am opening a new (child) form in Add mode Setting this childID, from the parentID from previous form Setting childID back to parent form for later reference. Once the …

Hi All I am trying to query my access DB using a C# windows app and one of the fields is a type date/time. I have set the field to general date but when i run this query it displays the date and time set to 00:00:00. How can i …

[code]<cfquery name="findQtrs" dbtype="query"> SELECT DISTINCT DATEADD(qq, DATEDIFF(qq, 0, event_datestart), 0) as SQtr, DATEADD(qq, DATEDIFF(qq, -1, event_datestart), -1)as EQtr FROM eventData ORDER BY SQtr ASC </cfquery>[/code] when I run the above I get error in syntax of '(' looking for a from. However, when I run that exact query in SQL …

Hi , can anyone help me. I tried to start an SQL Server instance from command line with sqlservr.exe. But on the last line it said "a significant part of sql server process memory has been paged out. this may result in performance degradation". And my instance didn't start. But …

Our server growth is too fast from 30GB from last month now it reaches into 50GB. Is their a problem in our database? Can this be possible to shrink this database into a minimal Size? Our server is MS SQL server 2000.

hello, please help me on my updatebutton..can you please help me how to use the update statement...i want to save the changes that i made in my textfield...hoping for your positive responds...thanks in advance [CODE]Private Sub cmdupdate_Click() sql = "Update * from merchandise_table where mch_no = '" & m_mchno & …

Hi, I have [code] SessionData sdc = new SessionData(); [/code] And all the properties of sdc are stored in a table in sql server. I want to retrieve the properties of the sdc dynamically. And i know [code] sdc. reader1["xmlname"]= [/code] is a wrong way of doing it. So can …

hi all, i m new to sharepoint pls help - Any idea about the Sharepoint Databse structure ? I am using SqlServer 2005 with .NET, Sharepoint How to access my database? where is connection file in sharepoint ?

Hay, I had a question about a login system that i want to create. I have SQL express 2005 with value's ( business name, passwords e.d. ). This system we use to fill in what we did at the company, and how much time we spend on it. This system …

Hello, I have a little issue getting what I want displayed from a single table. Basically, here is what I am trying to accomplish. I have the following type of table: Place Action B/S Qty Type City Full B 1 View City Partial B 1 View City Partial B 1 …

Hi all! I have two combo boxes: cboRepairCategory (plumbing, landscaping, etc) and cboVendors. I am using Stored Procedures in SQL to store the data from my database and then load them into the combo boxes. The cboRepairCategory will be loaded first. Once the user has selected what type of repair …

hey guys im currently working on a project for college. (USING VB) wat the form im working on does, allows the user to enter an ID of a customer and this then displays the customers details the user can then change the details however they want and update them which …

hi I am facing problem in connection of sql server in asp.net pages Actually there is error when i importing namespace [B]System.Data.Sqlclient[/B] [B] Error is:[/B] The type or namespace name 'sqlclient' does not exist in the namespace 'System.Data' (are you missing an assembly reference?) now i don't idea that what …

Hello, Im having some troubles with strings connecting. [CODE] retezec = "" & Session("jmeno") & ")" & " AND (table1.application_ID = " & txtCisloReklamace.Text Dim ret As String = "SELECT table.data, table.XX, table2.name FROM table INNER JOIN table2 ON table.kod_vyrobku = table2.kod_vyrobku WHERE (table1.some_value= " & retezec & ")"[/CODE] When …

Hello, I'm having problem with a query which is based on fixed-part and all I do is that I'm modifying part after WHERE something.value='... . This whole text is a string which I need to be connected to my query. '113') AND (reklamace.kod_reklamace = '932' ' Error message: Conversion failed …

hello all, im a student and doing a project to automate a process. For which i ve to download files from clients site.. my doubt is can zip files be stored in sql database. if its possible means how can i achieve this.. need help! good day.

Hi guys , I am creating a timekeeping application to keep track of users. In my database I have a table which stores the time a user starts their break and finishes their break. I want to return the total time that the user is on break in minutes to …

I need to fill my gridview with just the records that fall in the date range. The dates come from two calendar controls. If I choose dates where the day is in single figures I get a return, if I choose higher value days I get an error - "Cannot …

I am New TO Programming Am HAving 2 Table One Table Having Coloum ID and NAmeOf Eventt And Other Table Having Coloumn ID and Imagepath I want To Retrive Id related the NAme Of Event and Want To Insert That ID into other Table at the same time i want …

Hi all, I have a c# winform with a SQL Server 2005 backend. When I update my database from textboxes in the form, in one particular table all the nvarchar entries are padded with white space. This doesn't happen for other tables. All the fields that are being padded are …

Hi to all, We use normalization to control the redundancy.. What is the purpose of using Denormalization in sql ? Thank you, Prem

Hey Developers I have made an application that takes data from sql 2005 using a stored procedure and displays them on a datagridview. And then now i have written code to export the data to an excel file using Microsoft Interop and Excel Core Services. When i click on the …

Hello! I'm hoping that you can help me Alter a SQL table to provide a unique constraint over 2 columns. For instance let's say I have a departments table called Dpt_tbl with two columns that I want to be unique Name Location So I want to make sure that you …

hii frndz i m making a project on hospital management in c# n i made a form for doctor detail in which i have taken a picture box n now i want to save the detail of doctor with that picture in sql n also i made a button to …

Hi there, I'm havin a session with value of ID. I need to create a query for GridView to show only values linked with user mentioned in session. So my question is if theres any way how to modify my code which isnt working. [code] <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DbConnStr …

Pls help me , i can not run it correctly with "AddNew, Update, Update, Delete, Cxl" , i have tried many ways but no effect ? My database has 5 tables , i choose one which has 7 columns , the 7th col (name = "ID") is identity number (1/1). …

hi friends...i am developing a small windows application in vb.net using visual studio 2005. i want to design a form where user can enter multiple records.like we want to design a "bill" form where user can create the bill for any no of items.there are 4 colmns in it : …

The Catch section is always executed even if the Try section has been executed. I am trying to send the user to one page if the delete worked properly and a different page if the delete did not work because of relationships between tables: [CODE] Protected Sub btnDeleteBuilding_Click(ByVal sender As …

Hi Folks, I have created a login page that allows user to login to the system. I have a table in database called Users (userid, password, roleid) . When I try to login with proper user id and password the system let me login and redirects to proper page but …

Hello, I am working on a multiuser web page where people log in and do some stuf(database related) What i need is for people to register a username in the same database table that i use, and stay logged in to the page when they use the system, so that …