[microsoft:sql-server] Forum Topics

Hi guys please I need your help. I created application in window application of C# with sql server database(.mdf) and when I installed it to the target computer, it is complaining of: unable to install or run the application. The application requires that assembly Microsoft.Synchronization Version 1.0.0.0 be installed in …

hello guys,please i need some help .I have many folders that contains images .I have to store these folders in my database .And then use these images.Please i want an advice to know how to start .it's my first program of that type =( and i'm using Vb.net and Sql …

I'm needing some LINQ expert advice. I am having to convert a SQL stored proceedure over to LINQ. The SQL statement is structured like below: SELECT SUM((Amt) FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID WHERE Table1.Date < endDate GROUP BY Table2.Name How would I group all of the …

Hi, I was just playing around with using a linq query on a dataTable that has information from sql. I was using var q = from Email in dtEmail.AsEnumerable() where Email.Field<string>("Email") == "yay" select Email; But for some reason it will not query the email datatable. And yes, I actually …

How can I filter records from the clock set at right angles In data if I add a column is minute Time from start plus column-minute any help? thanks a lot Imports System.Data.OleDb Public Class Form1 Dim con As OleDbConnection Dim dt As DataTable Dim da As OleDbDataAdapter Dim str …

Please Help me with my problems as follows below : 1 What is the connection string to connect database to vb.net 2 How do i INSERT UPDATE DELETE AND SEARCH records using sql.. 3 How do i start creating a database application using vb.net and sql Thats all... hope you …

hi can u guys help me find what is my error in my line. cmd.CommandText = "SELECT * FROM TblLogin where Username='"+ usr_lgn.Text +"'and Password = '" + pswr_lgn.Text + "'where STAFFSTATUS="+"ACTIVE"+""; im having an error saying incorrect syntax near the word where. thank u

i am trying to check availability of a room i have the following code: ALTER procedure [dbo].[CheckAvailability] @checkIn datetime, @checkout datetime as Select r.RoomName, RoomNO, [Description],Location, RoomPic, Price from [Room-Type] t , Room r, Booking b where r.TypeNo= t.TypeNo AND r.RoomName Not IN( Select b.CheckinDate from Booking b where ( …

I have an SQL query within ASP.NET, but it only seems to return 1 result rather than filling the list with 4 as it should (as the query itself is correct) Code: List<string> dropItems, dropItems2; using (var dbContext = new DatabaseContext()) { dropItems = dbContext.Database.SqlQuery<String>( String.Format("SELECT locations.Code FROM locations")).ToList(); } …

A Drupal security advisory, [SA-CORE-2014-005](https://www.drupal.org/SA-CORE-2014-005), rather embarrassingly states that: > Drupal 7 includes a database abstraction API to ensure that queries executed against the database are sanitized to prevent SQL injection attacks. A vulnerability in this API allows an attacker to send specially crafted requests resulting in arbitrary SQL execution. …

When one is out of practice easy becomes difficult. In this function I want to count the records with icliente status "pendiente" as criteria so we know if customer has a pending loan, but the function returns 0. What's wrong in the function? Public Function prestamospendientes() MsgBox(Me.txtid.Text) Me.Refresh() Dim prestamopendiente …

hi its me again, i have this scenario where i need to search my datagridview using the textbox i have, i have tried copying other sites but what it gives me is errors, new columns and more errors, my codes goes like this for loading my datas from the database …

A question for VB.NET - Access DB folks here, although some might consider a strictly DB question. Is there an order of operation when a SQL query 'does its' thing' relating to the 'WHERE" clause with multiple parameters? In other words, could you rearrange the elements [filters] of the WHERE …

Hello again, I am creating a Datagridview with 3 columns, product_id, product_name and quantity. but in my database i have 4 columns namely prod_id, prod_name, quantity and item_status. What i want to do is , if my item_status is texted "PHASE OUT" or "INACTIVE", i will skip that row while …

Hello All we want to print datagrid view's 20 records per page, but it seems LIMIT Command is not working and shows error plz can any one help or suggests alternet. this is our coding. ANPSql = "Select * from Table1 limit 0,20" MsgBox(ANPSql) Pth = My.Application.Info.DirectoryPath ANPConn.ConnectionString = "Provider=Microsoft.ace.oledb.12.0; …

how to store the users data in sql database from a asp.net form

Hi to all! I want to learn Vb.net,so i want to know the scope of vb.net. Actually i have a confusion, i heard many people saying that instead of vb.net you should learn C# because there is more demand of C# than Vb.net. is it true? Should i lean vb.net? …

Good day! I just want to ask on how to drop a table. Let say all tables starting with "DailyCashSalesRpt". That means it will drop all tables starting that word. I use this code but it will only delete one specified table name.. How to use this with like? sql …

HI Please help. how to solve this I am using the below code. insert is working fine. but i am having problem in edit session i edit page i can able to display both values from Database. If i am changing the textbox1 value i am not able to get …

Morning all, I have some code which says if a text box is empty show a msgbox asking user to input data into this textfield. i then want only an O.K button to show on the msgbox but then no to continue with the sub. [CODE] If Me.txtLine2Rcon.Text = "" …

Hi Everyone, Fairly new C# coder here. I'm currently writing a small application that will be deployed on several computers, each of which will need to connect to a remote SQL server. I'm wondering what the best way to store a username and password for this would be? Each deployment …

Hello, I have a website. I'm making a cafe management system. It's about to be ready. It can lock computers, unlock them for some time, use username and passwords, but the problem is that I can't make the SQL database on a website. I'm using web, and not LAN because …

can any body help me or give me an sample code on how to create a very simple log in system using php and mssql..tnx in advance.

Greetings I'm using InstallShield for deploying projects and I'm new in using it I need to know how to include some applications and executable files to be installed while installing my application what I mean is that I need to include for example the .NET framework 4.0 so if it …

I have an Access Database on which I have tables with similar structure and columns name columnA and columnB.I can use the below query on tables created design time to get this output. Table | result -------|-------- SELECT "Table1" AS Table, SUM(a) - SUM(b) AS Result FROM table1 UNION SELECT …

I use SQL Server2008 R2. From yesterday, I get a problem to open it. When I try to open it by Microsoft SQL Server Management Studio an error is occurring. And I also get the same error when I call it from vb.Net2010. I am attaching here the error picture. …

I am trying to show data on datagridview but error occurs Form1.vb code is as below Imports System.Data Imports System.Data.Sql Imports System.Data.SqlClient Imports System.Data.SqlClient.SqlDataReader Imports System.String Imports System.Configuration Imports System.ComponentModel Public Class Form1 Dim con As SqlConnection Dim cmd As SqlCommand Dim dr As SqlDataReader Dim da As SqlDataAdapter Public …

I have to pass two values to sp first value is nvarchar and second value is Int in SQL server,but i am not getting values, is my code is correct.Please help me out $query = mssql_init("courseofferedbyprof", $dbhandle); mssql_bind($query,"@facultyID",&$facname,SQLVARCHAR,false,false,50); mssql_bind($query,"@count",&$year,SQLINT2,false,false,50); $result=mssql_execute($query);

Alright, so the following has stumpted me and a few others in the office, and we just can't figure it out. I have develope a program that allows us to go out to a specific database and search one of the fields based on specified values. Now that seems all …

I am now in a problem to prompt user at the first run of my program. The Server is msSql Server 2008 R2 and Plaform vb.Net 2010. At the time of starting, the program starts to search the file, where the ConnectionString is saved. If it get then well else …

Greetings, I'm using InstallShield 2010 premier and I want to hide the SQL login dialog if the specified database is exists. Or hide the Dialog under some conditions I google for hours and indeed I cannot find a useful information especially I'm not an InstallShield expert

I have a problem updating table from datagridview in vb.net to sql server. I have posted the code below. I am importing connectionstring from connection module. It used to be working but I dont know what went wrong and now it isnt. Imports System.Data.SqlClient Public Class frmreportsp Dim cn As …

Greetings I want to optimize a SQL Query. The problem I have a database full of such Queries and I need help for optimizing those Queries the problem with the Query is that it contains dozens of CASE blocks and within those CASE blocks there are calculations the Query results …

I re-post a thread which many others submitted times ago, but never got solutions or good answers! I re-new the challenge :) [url]http://www.daniweb.com/forums/thread226795.html[/url] The last post gives an idea. Another is here [url]http://www.daniweb.com/forums/thread104261.html[/url] I mean: editable dropdown boxes autocomplete function works with a so builded filter: LIKE 'string%' what WE …

Hi if myTable has a column like Col 10 7 3 5 9 4 How can I select three smallest numbers? my resultset should be 3 4 5 I don't prefer the following; with myT as (select col from myTable order by col) select top(3) from myT Any better idea? …

I need some recommendations for the following project Im working on: I have a SQL datbaase on our SQL server that contains all the project information for the company. I want to build a front end form that users can use to search the database and have this form be …

Hi! I want to display a table in the Local Report using SQL Connection. Parameters will be user-defined. Example. sqlSearch = "SELECT * FROM shipment WHERE " & port & " BETWEEN @datePerformedFrom AND @datePerformedTo ORDER BY recno DESC" `@datePerformedFrom` and `@datePerformedTo` will be supplied by the user. Please help …

I have a app, that requires login with SQL server as backend. I have users who are on laptops and not always connected to the network. I want a way to check for the SQL server, and if it does not exist then roll over to local auth for local …

How do I get average of the duration for multiple weeks. Currently I get something like Student Avg completion time Week Year STUDENT 1 0 1 2013 STUDENT 1 5 1 2013 What I want is Student Avg completion time Week Year STUDENT 1 2.5 1 2013 <code> select a.student,avg(a.duration) …

I have a simple sql table with four columns The data types are Athlete nvarchar(30) Mydate date Mytime varchar(8) Session nvarchar(40) Sample Data **Athlete Mydate Mytime Session** Jerry 14/07/2014 00:00:32 200M Jerry 14/07/2014 00:00:31 200M Jerry 16/07/2014 00:00:59 400M Jerry 16/07/2014 00:00:57 400M Jerry 16/07/2014 00:00:58 400M Now what i …

Hello guys, a while back I posted something about what was needed to build an overtime app that stored data permanently on the server (here is the post https://www.daniweb.com/web-development/php/threads/467433/change-content-of-html-page-with-php) and I was told to use PHP. I have to say I've never got around that, but now I'm looking into …

Try DoInsertQuery("If Not Exists(" & _ "SELECT * FROM tblSchoolYear " & _ "WHERE schoolYear = 'SY " & Trim(txtAddSchoolFrom.Text) & "-" & Trim(txtAddSchoolTo.Text) & "')" & _ "INSERT into [tblSchoolYear] ([schoolYear]) VALUES ('SY " & Trim(txtAddSchoolFrom.Text) & "-" & Trim(txtAddSchoolTo.Text) & "')") Catch ex As Exception MsgBox(ex.Message) End Try …

Hi i need to use the below query in PHP to generate PDF but its not displaying what are all the supporting files i need to put for running the below (XML path) query in php,Its running successful in sql but when i put in php its not working can …

I am receiving a Code in sms like "yyyy/mm-digit" (digit increments with every message). so i want to ensure that the code sent by user is exactly in that format otherwise another action. So how ? Here is my code to check but it always execute else block, why ? …

I'll prelude this with I am a novice coder at best and this is mostly a hobby that I would like to do professionally one day, but that day may be 10+ years from now. So for now I tinker and learn here and there. Part of the reason I …

This is writen using vb.net and sqlCe. I'm interested how this could be written in SQL server 2008 and vb.net. Dim rs As SqlCeResultSet = cmd.ExecuteResultSet(ResultSetOptions.Updatable Or ResultSetOptions.Scrollable)

I am trying to calculate days between two dates so that I can find out if they fall in the 30 / 60 / 90 day bracket The calculation I am using is working fine ` DATEDIFF(day, dbo.TblReturnDetails.RcvdDate, { fn NOW() })` what I am trying to do now is …

When i install window form application another machine database not connect ERROR :- Unhandle Exception has occurred in your application. 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 …

i want to import excel file into sql database in window form application c# plz give some easy and right code