[microsoft:sql-server] Forum Topics

Hai All, I have made a desktop application in Visual studio 2010( vb.net) with sql server 2008 as backend.I have made the setup of the project ,with sql database to be created using installer class and its all working well and fine. but i want to make my application in …

hello, can u help cuz some of sample codes of digital persona sdk is not working when im using digital persona 4000 in win7, do i need to change on its codes ? and how it will be saved to sql database?

Hi All, I started this general discussion because I want to know what kind of standards you all work by with regards to documenting your projects. I've been steadily working on a system at work since last spring that is automating (extracting, transforming, & loading) data flows within my department. …

Hello Everybody, I’m currently working on my end of year project and I got stuck on a very trivial thing. When I’m trying to add a new user to a database (local) I keep getting “Syntax error in INSERT INTO statement" I don’t really see where is the problem so …

hey all please help me about my graduation project i use this code to insert data on the table and i have no error,but nothing will save on the table..so please help me know why !! thank on advance.. -------------------------------- Imports System.Data.SqlClient Public Class Form1 Private Sub Button1_Click(ByVal sender As …

Sub all() connection() Dim see = "Select * from info where Last Name = '" & txtLast.Text & "' and First Name = '" & txtFirst.Text & "'" dcom = New OleDbCommand(see, dcon) dcom.ExecuteScalar() If dcom.ExecuteScalar > 0 Then Dim gather = "Select * from info where Last Name = …

Hi group, If you've seen my posts before on SQL Server stuff you know I'm a "raw rookie" with this. Again, I need some help. I'm going to need SQL to create an order number for me. I've created a datatable with two fields: OrderNoID (key) and OrderNumber. I've already …

I have a table called `DUTY` (columns: `dutyid, dutyname, staffid`) and a table called `STAFF` (columns: `staffid, staffname`) In order to be fair, each of the staff will be auto assigned to each duty entry (record). So what should I do whenever I would like to insert a duty entry, …

Hi , I am using C# to do my projects and I have connected to a MS SQL database file and I am using MS visual studio 2008 standard edition. I need to get all the users first name and the last name and display in a combo box when …

hi, i have a drop down list populated with column names of tbl_student and a text box for searching specific value coresponding to the value selected in drop down list i do not have much knowlewdge about qureies might b m lacking there error is Incorrect syntax near '=' my …

Hi Im working with a project, simple IM for our office... I have a Table in sql with column Status, if a user opens this application, the status column changes from 0 to 1, if it closes this app, the status turn back to 0. On my form load event, …

CAn i use 'waitfor' in t sql in sql server 2012 to wait in terms of days? eg. Wait three says after an event to do something else? Thankx in advance

I am moving from database from Microsoft Access to MS SQL and I have not worked with MSSQL before, can you recommend a good place to get some initial and then follow on training in SQL and MS SQL?

hi i have code to upload files to sql db and then to download, i have upload different type of files images and pdfs when i download file i must spacify the type of file with this code string filepath = @"C:\Downloads\FileName_0.pdf"; the problem is if the downloded file is …

I was able to store the PDF. Now the issue is retreving the correct version of the PDF. I am storing it with the data fields filled in;however, upon retrevial the fields are blank. Dim reader As System.Data.SqlClient.SqlDataReader = Local_Command.ExecuteReader() Dim buffer(100000) As Byte Dim data As Byte() While reader.Read …

Hi, I am currently migrating access programs into vb.net with t-sql database backend. I am having 400000 rows of data that I have to pass into recordset and display it on the grid. In the good old access, the data appears almost immediately. Because access does not wait to load …

I am using gridview to load the data from the database. I have done correctly with databind. But this time i am trying to display data by filling the values of cells in rows... My code is like this:- Public Sub grid_init() dim index_flag as integer = 0 curr_user = …

Dim pdf As String Dim pdfByteArray As Byte() ' Dim lLenPdf As Integer = Len("C:\file.pdf") Dim mypdf(100000)() As Byte Dim numBytes As Long = pdfFile.Length ' Dim data As Byte() = System.IO.File.ReadAllBytes("C:\file.pdf") myInitialBytes.Add(New Byte() {&H0, &H25}) StoredProc….. SQL Connection code…. Dim Local_Connection As New _ Local_Connection.Open() Local_Command.CommandText = "Insertpdf" Local_Command.CommandType …

Hello! I need some help with a stored procedure for insert. I know this might sound stupid but I'm a beginner and I know the answer is there but I just can't find it. I've searched the site but I couldn't find an answer to clear me out ...or maybe …

I am using sqlserver 2012. i want to convert nvarchar value from a table in to an integer. How can i do it? i am using it in a stored procedure. and nvarchar value only contains numbers. What i want to do is to multiple that nvarchar value and assign …

Group, I'm trying to write the commands to update a row within a SQL table. I've written the following: USE DATADESIGNSOLUTIONS SET IDENTITY_INSERT LocationID ON INSERT INTO LOCATIONS_SETUP(LocationID, LocationNumber, LocationName, LocationAddress1, LocationAddress2, LocationAddress3, LocationCity, LocationState, LocationZipCode, LocationZipCodeExt, PhoneNumber, FaxNumber, BillToAnswer, BillToLocation) VALUES(10, 1, 'Traditions in Tile / Buford RDC', '4325 …

I have a table with several columns, the two relevant columns for what I need to do are invoiceNumber and stockNumber. The scenario here is that it's a table of invoice information, so each invoice can have and will most likely have multiple rows in the table which represent each …

Hi iam using sql server 2008 to deal with my DB, i have a column with 'int' data type when i insert number inside that column like "0025648" it return it to me "25648" without zeros why ? and how to solve this problem ? Best Regard IT_Techno

hello friend, can someone help me, i want to learn how to connect my app database from another computer using code, i already try to change connection string = "Data Source=-SERVERNAME-\SQLEXPRESS;Initial Catalog=SmartHome;Integrated Security=True" but its still same, someone please help me, im using win8, microsoft sql server 2008, Visual studio …

I was trying to update an existing data and this error message came up. Does anyone know what this error message means? Fatal error: Uncaught exception 'fSQLException' with message 'MSSQL error ([Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'aaaaaPatient_PK'. Cannot insert duplicate key in object 'dbo.patient'. The …

Hi All, Forgive me if this doesn't come accross clearly. I have a specific data set to get from a website. Most of the data sets that I get from this site have publication dates that I have been able to successfully use for our SSIS ETL processes. However, one …

We use object data sources to access our database and having a problem at the minute, the user enters text and clicks search and the stored proc is pulling so much data back from the database that its taking over a minute in SQL, in Visual Studio the timeout is …

hi im newbie for using sql in vb.net and we have a project to create a registration form where the datas will be saved on sql. for e.g how the textbox1.text will save, edit, delete, or update its value or text to sql? also how to get the datas from …

Hi, Can anyone tell me why datareader is no reading user_id from this code? I debugged and the user_id_select remains 0 and I am getting no errors. Protected Sub btnAddUser_Click(sender As Object, e As EventArgs) Handles btnAddUser.Click Dim conn As New SqlConnection("Data Source=BRIAN-PC\SQLEXPRESS;Initial Catalog=master_db;Integrated Security=True") Dim searchComm As String = …

Hi, Can anyone help me with my CASE statement update on a temp table. In my report I have the following case statement; 'STATUS' = CASE WHEN customer = 'BUS' AND country = 'GB' AND field_1 = 'X' THEN 'UK_BUS' WHEN customer = 'BUS' AND country <> 'GB' AND field_1 …

Hi Guys, I have a problem using the sqlsrv_connect function (in that it's failing!). I have been using mssql_connect on a server with an older verison of PHP where my connect string worked fine. But putting the information into the sqlsrv_connect doesn't let it connect. Here's my code that I …

I have developed delhpi software sql database invlove now want to convert it into web application hwo plz help me iam new in this .

Greetings guys i'm stuck in this problem for 2 days now can you guy tell me the problem? here's the code If errorMsgLbl.Text = "Password match" Then sqlCmd = New SqlCommand("INSERT INTO registered_cust_tbl([customer_fname], [customer_lname], [customer_DoB], [customer_Contact], [customer_Email], " & _ " [customer_Address], [customer_Gender], [customer_Ailments], [customer_Username], [customer_Password], " & _ " …

while ( select AVG(Rate)+2 From HumanResources.EmployeePayHistory) <20 begin update HumanResources.EmployeePayHistory set rate=rate+2 From HumanResources.EmployeePayHistory if(select MAX(Rate)+2 From HumanResources.EmployeePayHistory)>127 break else continue end **I have Execueted this query but I am Not able to know what is this query working ? what is the use of this query ?? it will …

What is the procedure can be used in MS-SQL server 2012 in order to create a workflow as in dynamics CRM? Is there a way. Or what is the alternative? Thnakx in advance.

I have an assignment where i should demonstrate concurrency controls.In order to do that i should work with two sessions in the same database in ms sql server. How can i do that.

i am working through an purchase & sales report.i want to display the purchase report for daily basis using rdlc report how can i do that...can any one help me.....i use date.today to pass in database to fetch the record but how to display that record in report.. sqlcommand=" select …

Hi, I want to copy records of a table say employee into the same table. For Example Table Employee contains 5 records. So i want to insert the same 5 records again into the same table Employee 20 times. I have tried the following Query (which is inserting records in …

Hi to all, As a newbie, I am not able to have the following columns into a datagrid. (see database diagram attached) (I don't want to select ID columns because users may not be able to identify the students). I don't master JOINS . Infact I want to select all …

Hi group, I've been playing with a ListView and I'm struggling to get it to populated with info in a database. I'm hoping you may see something in my code that is creating the error. Dim con As New SqlConnection Dim cmd As New SqlCommand Dim rdr As SqlDataReader = …

Hi group, I'm still learning Visual Basic and SQL. Please overlook my inabilities. I'm writing a module that is meant to write a small amount of data to a database. I've named these fields 'PrinterID', 'PrinterName', 'PrinterNumber', 'PrinterLocation' and 'PrinterAddress'. The user will eventually have 30 or 40 records to …

Hi.. I am trying to create question paper generator application in C# windows application with sql server as back end. Now I need your help to select the questions from database. Ex: User Selection like: Chapter selection from listbox then select 1 mark – 5 question 2 mark -3 questions …

hello, i have a application, with sql database, now i want to backup every week, so i have code a but it gives error: "The process cannot access the file 'C:\Users\yogeishh\Desktop\Restaurant-Stock-Management-System\Restaurant-Stock-Management-System\DataBase\RestaurantStockDataBase.mdf' because it is being used by another process." can anybuddy solve this error?? my code is :: " Private …

"I want Dropdowm autocomplete with binding in SQLServer in asp.net anyone can help me "

I am tring to recreate my oracle database -> sql server 2008. I never used sql server before, so I am using sql server management studio. I could create tables and views. The views I created using sql server management studio GUI has data in it. Now, I tried to …

Hi - I am a pretty remedial visual studio express user. I recently understood how to do cascading comboboxes using the binding sources of the related tables, eg tbl 1 Make, Table 2 model, so as eg only ford models displayed in cbo2 if Ford selected in cbo1 - thanks …

Greetings, I need to know how to make an .exe Windows application with a database. How to attach the database to the application and if the client server does not have a SQL Server what I should do? While you are in the development phase you can specify the connection …

Greetings, I have a table which contains product information called Products contains fields: ProductID, ProductName, and another table called UnitsInStores contains fields: StoreID, ProductID, UnitsNumber, UnitPrice My first question is: Is it better design to put the UnitPrice field within the Products table or to put it within UnitsInStores table …

Group, I've been working for several hours trying to correctly write to a database file. Here are the parameters: Database Name: DATADESIGNSOLUTIONS Table Name: PRINTERMAINT Column Names: PrinterID (primary Key), PrinterName, PrinterNumber, PrinterLocation, PrinterAddress I've been working at this two ways: through the Visual Basic code and through SQL Server …

So I've been thinking about SQL security lately and wanted to see what others are doing. I have been using integrated security (window's authentication), stored procecedures when necessary and have done my best to limit access to tables and those stored procedures with SQL server in conjunction with my application. …