[microsoft:sql-server] Forum Topics

I want to ask how to pass the '30','31','32' to SQL WHERE IN clause For example EXEC SQL DECLARE abcd CURSOR FOR SELECT Consignment FROM Transaction WHERE order_type IN (:dest) where dest will hold the value '30','31','32'. I have tried as above example but it is not working SQL did …

I am getting an error message with my dapper code below. Any ideas? Thanks! Error 5 Cannot implicitly convert type 'Data.EmailAddresses' to 'System.Collections.Generic.List<Data.EmailAddresses> **1. Data coming from sql query** StudentId Gender EmailAddress 123456 Female maryjoe@gmail.com 123456 Female mary.joe@mycollege.edu 123456 Female mj@hotmail.com **2. Classes** public class Student { public string StudentId …

Hi There, here is a form from my VS2013C Project  As you can see, there are 9 labels that need filling. My Question is, can I load the dataset with 9 different select statements from the same Table, and then fill the 9 labels with the correct data.? …

Hi I have below code to save pdf file in sql. but getting error **"Cannot Bulk Load. The File "D:\xyz.pdf" does not exist."** Private Sub ButBouncePdfAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButBouncePdfAdd.Click Try If TxtRefNo.Text <> "" Then OpenFileDialog1.InitialDirectory = "d:\" OpenFileDialog1.Title = "Select PDF File" OpenFileDialog1.Filter …

Hello everyone. I am modeling a simple dictionary application using the presentation-business logic-data layer pattern. I already have the design but am not sure it is correct: My presentatioon layer is a simple GUI where users insert their queries. They have a form for entering new words and their definitiom …

Hi. Im having some problems to understand how to make search in SQL database actually I use this code DV.RowFilter = String.Format("name Like '%{0}%'", TextBox1.Text) DataGridView1.DataSource = DV and it work, but Im trying to show in a datagrid view results from the table but searched by 2 or more …

hi everyone. I have this code to retrieve image from sql server using asp.net with vb, the problem is the image cannot display in the web page and I don't know what is the problem can you please help me.` Imports System.Data.SqlClient Imports System.IO Imports System.Drawing Public Class _Default Inherits …

I am new to sql server .I have recently downloaded Sqlserver 2008 and connected from vb.net . I am trying to create dynamic tables with two columns such as name,amount by passing table names from text box . CREATE TABLE " & TblName & "( [Name] TEXT(10), [Amount] TEXT(6))] table1 …

am trying to find out what is wrong with my sql statement below, i get the following error: "The multi-part identifier "P1Totals.StudentTotals" could not be bound" what am i doing wrong? UPDATE StudentRegistration SET Year ='2016', Term = 'Term 1' where P1Totals.StudentTotals >='300' and P1Totals.StudentTotals <='400'

for example. name of field: f1 = "field1", f2 = "field2", f3 = "field3", f4 = "field4" how can I update the value of f2 and f3 without changing the value of f1 and f4. f2 = "new field2", f2 = "new field3" the new value of fields are. f1 …

Here's my scenario: I have been trying to re-establish mirroring on my SQL Server 2008 R2 instance since a VMWare outage took it down a few months ago. Here are the servers I'm using: Primary- prodDB.mydomain.com, on DataCenter1 Mirror- recoveryDB.mydomain.com, on DataCenter2 Witness- testDB.mydomain.com, on DataCenter2 DataCenter1 and DataCenter2 are …

I called one sql table "CarDetails" in more than two jsp's and i want to when from 1.jsp are updated "CarDetails" table then at that time update kendo grid from 2.jsp. thank you.

Hi , i need some help in completing a small task . " How to insert,update,delete record in data grid view using inline i.e (suppose if we update a record in the data grid then after click on the next row the data which is updated should be save directly …

My apologies for posting Teradata question on MS SQL thread due to there not being one for TD. I am trying to get last 3 months of data but running across an error using month(current date - interval '3' month) because it uses current date to determine previous months and …

Hi. Im using VS2008 and SQL Server Management Studio 2008. I want to ask, i have two different table, TableA and TableB in same database, DatabaseX. Both table have two same column, ColumnY but the data are different within this table. Example: TableA, ColumnY : A1, B2, C3, D4 TableB, …

Hi all :) Before i'm starting futher more about my problem. lets me tell a short description about my program. user will choose path ID (retrieve all this data from table TPATH of database SDO) that they want to delete. before the path ID would be delete, it will compare …

hi everyone. I want to retrieve image from sql server database using asp.net with vb, but the image is not display and I don't know what is wrong with my code. please help me. Imports System.Data.SqlClient Imports System.IO Imports System.Drawing Public Class _Default Inherits System.Web.UI.Page Public sqlcon As SqlConnection = …

Hi. I am Sorry that I don't know how to ask question for my Scenario. Thats why I just used "How to update qty into table2 from table1? " This is the scenario of one of my customer Table-1 Subscription Master(News Paper) - Received Subscription CustCode Name Copies date Agent …

I am trying to update Varbinary(Max) column data with Null value. But unable to do so. Error "**Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.**" my code Private Sub ButRemove_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButRemove.Click …

Our Day cares have a program called procaresoftware. We have 2 sites 47 and 35 From what little I know everytime you add a child, parent etc it puts it into an .MBD FILE. Lately the 35 center has been having issues that they cannot save any new customer. They …

Hi I have a timer so that when it goes off it will access the database however it doesn't appear to be working. I've never used timers before so not sure if I've written it correctly. The code for the timer is: public void timer_method() { int heartbeat = Convert.ToInt32(textBox1.Text); …

Hi guys, My application Cannot insert Record into Table more than once. There are 3 textboxes on the form in which the user enters data to be inserted in the table. And a command button holding the code to perform the action. What is happening is, when data is entered …

I built a database structure with codefirst EF from a tutorial but I can't find the database. I've looked in (localdb) and it's not in my local install of SQLServer. Would anybody know where I would need to look to find the database?

Hi I have the following code to insert data into a db int svcTypeID = Convert.ToInt32(comboBox1.SelectedValue); String svcGuid = label2.Text; int heartbeat = Convert.ToInt32(textBox1.Text); String hostname = System.Net.Dns.GetHostName(); Guid gu = new Guid(svcGuid); SqlConnection conn = new SqlConnection(@"Data Source=x\x;Initial Catalog=task_system;Integrated Security=True"); SqlCommand cmd = new SqlCommand("storedProc"); cmd.Connection = conn; cmd.Parameters.AddWithValue("@guid", …

I'm sure there is a really simple solution for this matter, but I have tried all I know without success. I'm trying to modify this working SQL string to yield only the Top 25 results, not all results. "SELECT * FROM" & "data.CSV" & "ORDER BY " & "Elapsed" & …

public partial class Form4 : Form { private OleDbConnection connect = new OleDbConnection(); public Form4() { InitializeComponent(); connect.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Bino Unity\Desktop\user1.accdb;Persist Security Info=False;"; } private void Form4_Load(object sender, EventArgs e) { } private void login_button_Click(object sender, EventArgs e) { connect.Open(); OleDbCommand command = new OleDbCommand(); command.Connection = connect; command.CommandText …

hello everybody...nice to back again i m working on project to calculate measures and numbers and insert data inside datagridview(dgv) from number.text and measure.text but if value of measure.text present in dgv son update number cell with new value + present value problem is how to do so.... i tried …

Can SQL 2005 Run on Windows Server 2012?

Hello ALl, I have found this project online which I would like to do. The link for the project is http://1000projects.org/network-intrusion-detection-system.html#comment-249119. If I am correct, this application if built properly is meant to look at all the packets and store them into SQL server?. I have got many problems before …

hello i'm beginner at programming and i want to connec to my database with PHP PDO with SQL SERVER 2008 R2 the problem at the begining it appears to me an error with this message "could not find driver" after a little searching about this i found how to download …

Hi Guys I am coding as very simple database in VB.net. I have decided to manually code my buttons but for some reason my save button returns with an error. Below is my code for my entire program (I know its not perfect). This is the error i Get: An …

Hi, I have been working on a application that used sqlserver 2008 R2. we had used filestream that was there in 2008 r2. there was a decision to move from 2008 R2 to 2012 express. Now i understand that file table is a new addition to 2012 and will do …

Guys I want to insert a Null dateTime Value into SQL database connected to C# desktop application. I'm using following code. I can insert Null dateTime Value into database, but I am having problem with how to update dateTime picker value and saving it into database.. I'm posting my code …

How to edit and save image to sql server and retrieve back in html.

I am trying to store a value from a selected row from one table into another. My code is as follows. string CustomerID = textBox1.Text; SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ConnectionString); con1.Open(); SqlCommand myCommand = new SqlCommand("Select CustomerID, Name from TableCustomer WHERE (CustomerID like '" + CustomerID+ "')", con1); SqlDataReader rdr …

# Performing Selective Includes in Entity Framework with the Fluent API # When we are using Entity Framework as our data access choice to work with SQL Server then there are some potential pitfalls. One of these pitfalls is doing selective includes. What do I mean by selective includes? To …

Hi, I have a range of *start* and *end* dates return from database in while loop i need to find, how many of them are continuing. The example return data; Array ( [start_date] => 2014-09-22 [end_date] => 2014-09-28 ) Array ( [start_date] => 2014-09-15 [end_date] => 2014-09-21 ) Array ( …

Can any one help me to load SQL server dlls in PHP.ini

Hi . I want to know how pass the data from the datagrid to textbox through query string with only the ID of the selected row being passed as query i.e when I select a particular row all the attributes of that row should be displayed on the textboxes of …

need some assistance. I am currently learning vb.net with sql. I have two textboxes (txtValue and txtText) , a dropdownlist (ddl1) and save button (btnAdd). I insert value to txtValue and txtText (eg: txtValue: A and txtText: Apple). when i click button Add, The value will display in dropdownlist (like …

hi there, Dim queryString As String = "select avg(pumpnum) from petrol_table" Using adapter As New SqlDataAdapter(queryString, connectionString) Dim table As New DataTable adapter.Fill(table) Dim row As DataRow = table.Rows(0) TextBox5.Text = row.ToString as the code stands now, all i get in the textbox is "system.data.datarow" the column called "pumpnum" is …

I am trying to update pdf file to sql but getting error (line 17) as **operator '&' is not defined for types 'string' and '1-dimensional array of byte'** on beow line cmd.CommandText = "UPDATE PDC_CHQ_IN_HAND set PDC_CHQ_IN_HAND.PDF='" & data & "'WHERE PDC_CHQ_IN_HAND.RefNo='" & TxtRefNo.Text & "'" * my code is* …

Hello everyone, Dim SI As String = "" SI = CheckedListBox1.SelectedItem Dim TextcommandSQL As String = "" Dim myCOLUMN As String = "" myCOLUMN = ComboBox1.SelectedItem TextcommandSQL = "SELECT * FROM test_table where " & myCOLUMN & " = " & SI MsgBox(TextcommandSQL) Dim con As New SqlConnection con.ConnectionString = …

I am getting this error while trying to login to my school managment software.It gives error message when i dont write anything in username and password but when i type correct login details it gives this error An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll Additional information: A connection …

Hi , i hv created 2 tables : a Department table with fields Deptname , Deptid and Employee table with Empid , Empname, Salary . I have created a datagrid with fields empname , address , Salary , Deptname and edit and delete command columns . By clicking on edit …

hello, i m working on connecting sqlData with C# form showing data detail on text boxess like ID,name,occupation.and doing the search by entering the ID on textbox then clicking the button to show the details i'm just a beginner in C# so i did the the coding like this and …

Hello, I am trying to learn c# and sql server and I am not sure how should I proceed in the following situation: I have a database with 2 tables: Clients and OrdersFromClients I am trying to make a form with a listbox in which I will display all the …

I want to insert from product (id, name, price). How can I insert it using mvc[c#], mssql manually.