[microsoft:sql-server] Forum Topics

Hi, I need to compare record using sql ce I have this data, can be thousand rows ID Type Date Time 02-0009 I 01/02/2014 8:00 02-0009 O 01/02/2014 18:00 02-0009 O 01/03/2014 18:00 02-0009 I 01/04/2014 8:00 02-0009 O 01/04/2014 18:00 For every date there should be a 'I' and …

i am trying to figure out the syntax to do a SQL inner join from 2 different databases... The sameple code looks like this: select * from database1.dbo.table1 t1 join database2.dbo.table2 t2 on t1.field1 = t2.field2 but I dont know how to refernce the " database1.dbo" and "database2.dbo" parts.. can …

I need to setup SQL Server Express using the command line and also make the installation unattended I tried many command lines however each one of them did not work here is the last one: Setup.exe /ADDCURRENTUSERASSQLADMIN="True" /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVIC" /AGTSVCSTARTUPTYPE="Disabled" /ASBACKUPDIR="Backup" /ASCOLLATION="Latin1_General_CI_AS" /ASCONFIGDIR="Config" /ASDATADIR="Data" /ASLOGDIR="Log" /ASPROVIDERMSOLAP="1" /ASSVCSTARTUPTYPE="Automatic" /ASTEMPDIR="Temp" /BROWSERSVCSTARTUPTYPE="Disabled" …

I'm using MS SQL 2012 - trying to LEFT JOIN 3 Pivots - but am running into issues within a query variable that I'm not sure how to debug. Each Pivot works on it's own - but the actual Joining is causing the issue. Any help is appreciated. First time …

Hi I have database in structure like below Newspaper State1 state2 state3 state4 ABC 1000 5684 5687 246 DEF 879 2547 2578 2357 But I need to the structure like below How can i change this Newspaper State copies ABC State1 1000 ABC State2 5684 ABC State3 5687 ABC State4 …

Hi guys when i search record between two dates it works ok success but you must enter date from and dateto first to to make search i will show what i need from this example I need to search dynamic by 4 textbox 1-datefrom 2-dateto 3-EmployeeNo 4-EmployeeName but search i …

Hi There, This comes under a few forums on DaniWeb, so I've guessed and posted it here... I have two computers, both connected to the internet and running Windows 7 (Home Premium + Professional). One is my main one, the other is one I do not use. If I installed …

Hello guys, I'm working on a VB.Net Project. I'm using MS SQL Server as my backend. I can create Purchase/Sales Voucher forms and many more through the VB.Net Database EXpress. Say for example I have created a Purchase Voucher form where the user can enter the vendor info (in TextBox …

Hi guy when i run this Stored procedure it give me message error conversion faild when converting date time from charachter sting stored procedure as following Create proc searchData @StartDate datetime, @EndDate datetime as Declare @SQLQuery as nvarchar(2000) SET @SQLQuery ='SELECT * from Employee Where (1=1)' If (@StartDate is not …

I have table as follows C Common Code 337080.00 15 Jan 2014 14 Jun 2017 Ananth Krishnan ee C Common Code 337080.00 15 Jan 2014 14 Jun 2017 Balaji Srinivasan ee C Common Code 337080.00 15 Jan 2014 14 Jun 2017 Deepa Venkitesh ee C Common Code 337080.00 15 Jan …

Hi guys how are you? I am having tough time extracting data from the ms database. I have three rows. WHat I want to do is the extract data from these three rows and pass to labels and display in the frame. But I'm stuck on the first one. my …

I am exporting data from excel and show it in gridview and when I click submit, it needs to be updated in existing table. Below is my excel data S.No. RequestID Subdivision No Parcel No CUID Status Remarks 1 5 42 55 55 Open Pending I have successfully exported and …

I have a column named Emp_Id and set as primary key (not Auto Incr).I am trying to generate an ID (employee) and save it into a SQL database. The logic goes this way: Generate the id number with a prefix plus the number (i.e. EMP0001). Display it on a textbox …

A report from Hold Security claims that one of the biggest ever online heists has been committed by a Russian crime gang. It would appear that the data theft includes, wait for it, no less than 1.2 billion (yes billion) username and passwords along with around half a billion email …

I want to make a recipe website.In that I had added the add to favourite button.If i click my favourite button the recipe which i clicked will add to favourites.I i re-click it will remove from my favourites.It is controlled by the status field in the favourites table in sql.How …

I’m going to use main report and sub report for showing some details. Main report has InvoiceHeader Part and sub report has invoice detail part. Invoice Header and invoice detail has 2 SPs. SP_InvoiceHeader (Use for main report) ALTER PROCEDURE [dbo].[testSP1] @invnoH as varchar(20) AS BEGIN SELECT * FROM INV_HEADER …

Hi I encounter the above error message while executing import excel data into sql data table. It worked fine in Mssql 2005 x86 and MS Office 2007 x86. But currently we upgraded the system to MSSql 2012 x64 and MS Office 2010 x86. I downloaded the accessdatabaseEngine.exe for MSoffice 2010 …

Hi, > I want to know how to store and retrieve picture path from sql server. Can anyone show me the code please.

I have insert gridview datas into database using checkbox checked. My prob is when datas present in database checkbox should be checked. DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[2] { new DataColumn("adminname"), new DataColumn("projectname") }); for (int i = 0; i <= GridView1.Rows.Count - 1; i++) { GridViewRow row = …

I want to export the excel data and show it in gridview. And I want to update the existing table i sql using Gridview data Below is my code for exporting from Excel protected void btnUpload_Click(object sender, EventArgs e) { //Coneection String by default empty string ConStr = ""; //Extantion …

IQueryable<CustomObject> obj = (from table in db.TableName orderby table.ObjectId descending select new CustomObject { //Properties mapped here }).Skip((pageNumber - 1) * pageSize).Take(pageSize); The above is a stripped down version of the query I am running. It is missing about 10 joins and then just the bulk mapping of the object, …

I had this working earlier but had to tweak the code for some function that will be preformed later on but now I can't get the data to upload to the SQL server. I get error: PDOStatement::errorInfo(): Array ( [0] => 42000 [1] => 1064 [2] => You have an …

Hi my name is vishal i was wondering on how to make my global variable accept values from another table in c# windows forms with sql server 2008? So i am developing an application named:**Mini Project** which has a login form named:**frmLogin**. Given below is **c# code** of **frmLogin**: namespace …

Hi, I am in trouble for getting related product. Any idea to implement it with SQL? For Example: Main Product Name: ABC Shirt B190 Men The sql will show the related product like ABC Shirt B190 Women ABC Shirt B190 Child

I have a connection in a DAL to SQL server. Using this connection I am trying to read the query. I have tried using ExecuteReader() and ExecutreNonQuery() with no luck. Here is my code: private void button1_Click(object sender, EventArgs e) { try{ var cn = new Connection_Handler(); string input = …

select SUBSTRING('hello 世田谷区経堂世田谷区経堂 ',5,10) as Japanese gives output as "o ????????". Is there any way i can get the substring of above string ? Thanks in advance for your help.

Below is my registration page and it is allowing duplicate values in the DB. Could you please help me where am going wrong private void ExecuteInsert(string UserName, string Password) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString); string sql = "INSERT INTO UserMan (UserName, Password) VALUES " + " (@UserName,@Password)"; try { …

I tried to create the database connection SQL Server 2008 R2 Express with ODBC connection using TCP / IP After I try the following error appears : Connection failed : SQLState : '01000 ' SQL Server Error : 10060 [ Microsoft ] [ ODBC SQLServer Driver ] [ TCP / …

This is my first time using dynamic sql. My goal is to populate a datagrid with a stored procedure that uses a incoming parameter that equals a column name in the table. I have 2 problems. 1. I can get each sql statment to execute independently with the correct results. …

Hey guys, having a bit of trouble with a customized eCommerce. The part I want to focus on is the adding of an item to the shopping cart (and the details that go along with each item). Everything works as is with the things I need commented... initial call to …

Hello, I am currently completing a side project. The biggest ideal of it all has to do with a dynamic drop down box. I have heard and seen of the 'auto complete textbox' feature by using ajax/jquery toolkits. That is what I'm looking for, but I was wondering if there …

Hi my name is vishal for past 6 days i have been breaking my head on how to get id(user_id or manager_id) of currently logged in user in my application in c# windows forms with sql server 2008. So i have a application named:Mini Project which has a login form …

Hi I did the stored procedure in mssql 2012. working fine in server. I have an issue that I need the output of my SP into HTML Report Format in aspx.page with Sub and Grand Total I no need GridView Pls advice Maideen My SP SET ANSI_NULLS ON GO SET …

I have created a sql database table country with country name and country code. I have selected only country name in the drop down list. Now I want to insert the country code in the database using button.

Hi my name is vishal for past 6 days i have been breaking my head on how to get id(user_id or manager_id) of currently logged in user in my application in c# windows forms with sql server 2008. So i have a application named:**Mini Project** which has a login form …

Hello, I have field in db table which have real datatype in SQL 2005. I want to convert it into time (HH:MM) format and add to another time. ex: 0.3 (convert it to 00:30) and want to add into 17:45 so i can get 18:15 0.45(convert it to 00:45) and …

any help for deploying sql database while setup c# application

'====================================================================================================== '====================================================================================================== Option Explicit 'For Log ID Public RUNNINGID As String Private Sub butBrand_Click() On Error GoTo ErrorHandler Dim colData As New Collection frmSearch.SQL_Statement = "SELECT ROW_NUMBER () OVER (ORDER BY brand_type_code) AS [NO.] , " & _ "[brand_type_code] AS [Brand Type] , " & _ "[brand_type_name] AS [Brand Name] …

I'm trying to create my own Database and Tables in SQL Server 2005 using VB.NET 2005. I get an error when I try ExecuteNonQuery, which says that the connection is not initialized. I'm not sure if I'm doing any of this right. Any help would be greatly appreciated! Sheryl [code=vb] …

My requirement is to select a supplier name from a Dropdown list(DropDownList_Supplier) and use the value to get Supplier id from the table "[SQS].[dbo].[Services]". I am using the below code and i am not able to get the value in the required field. Public SUPTEXT As String = "SELECT [ID] …

Public Function getSelc() Dim com As New SqlCommand Sqlcon.Close() Sqlcon.Open() Try com = New SqlCommand("EXECUTE regionSelect '" & txtID.EditValue & "','" & txtRegion.EditValue & "','" & _ txtShortN.EditValue & "','" & txtStatus.EditValue & "'", Sqlcon) objDA.SelectCommand = com objDA.Fill(objDSs) '=> could not find stored procedure ( 'but I have it …

Hi guys, Im very new to vb.net. I have this project that I'm working on Just to get more insight and appreciate programming. Now the problem I'm getting now is how to save the picture already selected to my picture box into the database (sql-server) this is my datase: memberID …

Hi Everyone. Background :- Winform App creates database in MSSQL LocalDB & creates tables. Data is imported & analysed then report is created. At any point in the process the user can start a new project & tables are removed to be re-created later as the user progresses through the …

I am trying to insert some values into a database and I have the following SQL: insertString = "INSERT INTO SocialHistory (ExamID, Occupation, SafetyYN, ComputerYN, ComputerHrs) Values('" & CurrentExamID.ToString & "', (SELECT Occupation, SafetyYN, ComputerYN, ComputerHrs FROM SocialHistory WHERE ExamID = '" & LastExamID & "'))" When I execute the …

Hi everyone. I got a situation here. Usually making a T-SQL(using sqlclient) on a server is very simple in vb.net if you have access to a sever. But I got this problem, where in a computer does not have access to that server but need to make a T-SQL on …

hi..can somebody help me? how can i have a conditional join in my statement. i have a parameter to be passed to the SP: @pRemarks my main query: select * from MasterList if @pRemarks='ALL' then my query will be: select * from MasterList inner join tblPositionLists on tblPositionLists.Position = MasterList.Position …

i have some problem plz soloved

i am using asp.net datalist to retrieve text from database field, when i put an integer value like 10 in where clause of select statement then it retrieves data from databse on next page but when i used variable (which is used to store value sent via query string) then …

I'm using InstallShiled 2010 to deploy my application in the prerequisites I added the SQLEXPR_x86_ENU.exe file the SQLEXPR_x64_ENU.exe file I need to choose which one is selected for setup based on the operating system version 32bit or 64 bit could any one tell me how to do this Another question …

Greetings, I'm trying to setup the SQL Server 2008 Express Edition using a command line Setup.exe /QUIET="False"/QUIETSIMPLE="True" But I always got a message saying that QUIET expects a Boolean value and what I'm passing to it is a Boolean value do any one knows what I'm missing