[microsoft:sql-server] Forum Topics

i have a mssql datagridviewer. i only need when user load the form..they must get empty datagrid...data only show when they search any item or add item....i worked on search and add but i am confused on load event ....please help with code

Dear all I am working on a project for my customer . I wrote code to search items from sql using vb.net Now my code working fine.....when I search data using itemid it show me data in all related textboxes but not in datagrid here my code Dim connection As …

SummaryProblem ============= How to get label text from table reference on database based on TableName and FieldName dynamically from database and show on view createEmployee . Details Problem Meaning i need to get label text dynamically from database not static from model SO that Every Time i need to change …

Hi, I Have below table I want all rows with all coloumn from below table where ActCode is 1162828 and sum of DocAmount for DocNo. i.e where the docNo is repeated i want only one row with sum of amount of all repeated rows. ** "Select *, Sum (DocAmount) from …

Hello, I am have been struggling with this and need some help. I am reading and excel sheet and getting the data and trying to search sql server to get the record. IN excel the length is 12 characters and in sql its 30. I am trying a like query …

Previously used winXP operating system running normally (very good) when switching to win7 operating system, this error, read errors from the SQL Server data, what is the error ? http://www.mediafire.com/view/4q5ux6e66ds4avb/ErrorOpenSQL.jpg/file

**fetch the record from the datsbase through specified query string ** public void get_student() { if(Request.QueryString["empId"]!=null) { int id = Int32.Parse(Request.QueryString["empId"]); sql = new SqlConnection(con); sql.Open(); string retriew = "select * from emp where emp_id="+id; SqlDataAdapter adapter = new SqlDataAdapter(retriew, sql); adapter.SelectCommand.CommandType = CommandType.Text; hfid.Value = id.ToString(); DataTable dt = …

Im Stuck With Something, Iv Been Searching, And Searching And I Canot Find Any Information On How To Make SQL Database Show The Samething For Everyone, When Updated Of Coarse... I Can Make The DataTable And Put It On A Form But I Cannot Make It To Where I Add …

Hi, I would like to ask a question about returning the column value(s) returned by stored procedure in c#. I have created the code but somehow I encountered an error saying: ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll Additional information: Subquery returned more than 1 value. This …

How to copy a store procedure one to another database in same server I work on a project. I want copy all or single store procedure from old financial year **db_17_18** to new financial year **db_18_19** I want to do it using sql server command. i try it but showing …

Hi all I have a script to update the value from datagridview to database I do use a button insert ToolStripButton but not working hope people to help thank ! Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load conn = New SqlConnection("") conn.Open() Dim query As …

using the following code i get an error from line 5 my error is Fatal error: Uncaught PDOException: SQLSTATE[08001]: [Microsoft][ODBC Driver 11 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [53]. in C:\xampp\htdocs\dailysales\includes\CPeriodOrdersJson.php:5 Stack trace: #0 C:\xampp\htdocs\dailysales\includes\CPeriodOrdersJson.php(5): ->('sqlsrv:Server=F...', 'LocalAdmin', 'CrispyCrackers') #1 {main} thrown in C:\xampp\htdocs\dailysales\includes\CPeriodOrdersJson.php …

I have a couple of SQL databases that i am trying to link results from. My first database is calendar that i need to return the details for today so current date and targets for sales and orders that works my second data base is for orders which i can …

I read several forums questions related to SQL database corruption. As we all know, backup is the best way to repair SQL database. What a user will do when backup copy is also corrupted or updated bacjup is not available? Is DBCC CHECKDB Repair option (Repair_Allow_Data_Loss) safe?

Hi to all! I'm fairly new to using High availability group and i've been having issues with storage space from my Logs drive from my primary server.. I just want to know why is my Log file not shrinking after I do backups(Full) on the primary server.. also, another question.. …

Hi here is code snippet used temprarily on button to debug. This works but i wish to use the 2nd snippet. 1st snippet Dim connString As New SqlConnection connString.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings("sql2008r2_857000_dmcsqlConnectionString").ConnectionString Dim cmd As New SqlCommand("select TOP 1 no from members ORDER BY no DESC", connString) Dim reader As SqlDataReader …

hi! I want to create a procedure which execute given below query using dynamic sql. i am getting some error i.e. "Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'GROUP'." my query which i want to run by procedure is: ;with cte as (select *,t.opening+Recieve+returnback-Issue …

I need to insert an imagen into a SQL Server Database and i need to do it using jsp, but i don't know how to do it. Someone can teach me the best way to do that?

dbconn.Open() s = "Select Max(cheque_no) + 1 As NewValue From tblEntry" Dim cmd As SqlCommand = New SqlCommand(s, dbconn) Dim dr As SqlDataReader = cmd.ExecuteReader() If dr.HasRows Then dr.Read() If IsDBNull(dr("NewValue")) Then empId = 1 Else empId = CInt(dr("NewValue")) + 1 End If Else empId = 1 End If dr.Close() …

automatically duplicate rows in sql server 2008 r2 select query i have two table name 1) tbl_Stock_Journal 2) tbl_Stock_Journal_Details i run a select query with where condition i have 5 data in table1 and in table 2 have 3 data when i run the query result is showing 15 row …

we r trying to insert date from datetime picker into mssqlserver 2005 but it also enter defult time(00:00) with it in database. using we want only date... [CODE]& xyzdtp.value.date &[/CODE]

Hello, One type of SQLIA is UNION Query and I still do not completely understand what is the point. SELECT Name, Address FROM Users WHERE Id=$id by injecting the following- Id value: $id=1 UNION ALL SELECT creditCardNumber,1 FROM CreditCarTable. We will have the following query: - SELECT Name, Address FROM …

SELECT SUM([BTL].dbo.OrderTable.Quantity) AS 'Totalquentity',Count(BTL.dbo.OrderTable.OrderID) as TotalOrder FROM [BTL].dbo.OrderTable JOIN [BTL].dbo.Products ON [BTL].dbo.OrderTable.ProductID=[BTL].dbo.Products.ProductID Left JOIN [BTL].dbo.Brand ON [BTL].dbo.Products.BrandID=[BTL].dbo.Brand.BrandID WHERE [BTL].dbo.OrderTable.EmployeeID='1' Group by [BTL].dbo.Brand.BrandName,[BTL].dbo.Brand.BrandID" I Want to get avg

Hello, I am planning to do my Thesis on SQLIA and now I am trying to understand something about SQLrand. SQLrand - a system for preventing SQLIA against web servers. The main intuition is that by using a randomized SQL query language, specific to a particular CGI application, it is …

I am using a code similar to the one below inside my stored procedure: [CODE]declare @tempVar decimal select @tempVar = amount from tempTable where <<conditions>> IF (CONDITIONAL STATEMENT) BEGIN select @tempVar END [/CODE] now I am supposed to be getting 4.25 something and I get 4, when I can clearly …

This is surprisingly difficult. Consider it a snippet. Deletes all tables from a sql server schema. Useful for those times on your dev machine where you need to tear down all the cruft that has built up on your server due to refactoring of object relationally mapped tables. --Author: Cameron …

Try Dim Adapter As New OleDbDataAdapter Dim Command As New OleDbCommand Dim xFrom As String = dtpFrom.Value.ToString.Substring(0, dtpFrom.Value.ToString.IndexOf(" ")) Dim xTo As String = dtpTo.Value.ToString.Substring(0, dtpTo.Value.ToString.IndexOf(" ")) sqlQuery = MainQuery & " Select TOP 100 LOANS.LoanID," sqlQuery = sqlQuery & " Borrowers.NAME," sqlQuery = sqlQuery & " Barangay.BRGYNAME," sqlQuery = …

Hi I need your help with regards on my trigger in sql server update. Want I wanted to do is to update the existing record in my database and then fire this trigger: USE [DB004] ALTER trigger [dbo].[trg_Updt_Item_Code] ON [DB004].[dbo].[RMIS_Item_Master_Ref] FOR UPDATE AS declare @trgDT as datetime declare @trgUser as …

How can I show the database in a single mode (windows or SQL authentications mode) please help me..... How can I Show the database in a single mode (windows or SQL authentications mode) please help me. I create a project VB.NET 2010 and SQL server 2008r2 , When I login …

I do not post here to send here. When using a shared network drive, win7 does not remember any other computer passwords and when running applications with SQL Server connections win7 does not remember SQL Server's user / pass, SQL Server connection type is ODBC, you know how to fix …

My code checks for duplicate values before a user is allowed to save into the database. Problem has to do with the logic, every new user gets a new ID increment by 1. So user one has an ID1 user two has an ID2 etc. Problem is when l delete …

Hello, l have a table in sql server containing some information such first name,last name, address etc. I want to display the items for a particular row when l search in a textbox. I am running into error messages. Any help here will be appreciated. Here is my code, its …

I read several forums questions related to SQL database corruption. As we all know, backup is the best way to repair SQL database. What a user will do when backup copy is also corrupted or updated bacjup is not available? Is DBCC CHECKDB Repair option (Repair_Allow_Data_Loss) safe?

I need a help about this i have a log in form design Username Password And my database table Username Password Usertype I want that if admin will login admin form will show. While if employee will log in emlpoyee form will show. How to do that in code. Im …

Hello, Can anyone help me check if this SQL Injection Vulnerability Scan is FREE : https://suip.biz/?act=sqlmap And is the report truly shows whether the website is vulnerable to SQL Injection or truly save. This is the report example: ___ __H__ ___ ___["]_____ ___ ___ {1.2.3#stable} |_ -| . ['] | …

Hi, I have a SQL Server (RSQL) and a SSAS Server(RSSAS). RSQL has a linked server to RSSAS, naming [LinkedCube] Here is a screenshot of my Linked Server Properties I use SSMS to connect to RSQL and then run a query that returns data from SSAS using linked server. The …

I am having a table with nvarchar feild in which values are entered like 1 4 8 25 I want a sql query to find the missing sequence of number in the above series... Thanks in advance...

my code is this: Me.Validate() Me.CFTINVENTORYBindingSource.EndEdit() Me.TableAdapterManager.UpdateAll(CFTDataSet) At first I can insert data into the cells and save it... but when i try to edit the same cell with data already saved in it I get this error... sqlcelexception was unhandled There was an error parsing the query. [ Token …

One computer can install multiple versions of Microsoft Visual Studio 2005, 2008, 2010, ... so SQL Server Management Studio can install multiple versions of 2005, 2008, ... the same computer ?

Hi everyone, I have database which has data of past 2 years. I want to get that data for current financial year. [COLOR="Green"](Here financial year is 1st april to 31st of March)[/COLOR] This query returns data for current calender year i.e. [Jan-to-Dec] [COde=sql] SELECT DATENAME(MONTH, DATE) AS MonthName, SUM(NetAMOUNT) AS …

Assuming I have file data northwnd.mdf version 2005 I want to convert to file data version 2008 or reverse ?

i have 3 table i inner join with 3 table and add function but now getting error please help me how to solve the the problem please help me ERROR :Msg 8120, Level 16, State 1, Line 1 Column 'TBL_pur_inv.invno' is invalid in the select list because it is not …

Hello Dear Sir, I am using vb.Net and SQL Server for my project.I stored data into data base.I I wnat to display it into Listbox so how can i do please help me. In table Name varchar(10),Idnvarchar(20),Limi1 INT,Limit2 INT,Limit3 INT,Limit4 INT I can display name in order [email protected]

sqlconnection = new SqlCeConnection(ConnectionString); sqlcommand = new SqlCeCommand(); sqlconnection.Open(); sqlcommand.Connection = sqlconnection; sqlcommand.CommandText = (@"UPDATE ItemStock_Info SET Quantity =@qun WHERE [Item_Number]='"+ textBox1.Text +"'"); sqlcommand.Parameters.Add("@qun", qun);

I have a vb based software which is very old running on sql server 2000. When I tried to take a report, it says "runtime error 9 Subscript is aout of range".where to find this subscript? Please help me out.Thanks in advance

Hi there, I would love to make a list and have a collection of database servers, could you all please help me? It would be nice if you could provide a link to their homepage. If you post, I will update the first post. [list] [*]MySQL ([url="http://www.mysql.org/"]http://www.MySQL.org/[/url]) [*]PostgreSQL [*]Access [*]MSSQL …

The second annual Imperva Hacker Intelligence Initiative report, this one entitled [Monitoring Hacker Forums](http://www.imperva.com/docs/HII_Monitoring_Hacker_Forums_2012.pdf), is out and reveals that the threat surfaces being discussed by the hacker community are very different from those that businesses are spending money on defending against attack.  The Imperva research analysed the content …

can anyone tell me code for if i update one record into database for SrNo while using jsp page & if i want to upadet another data for same SrNo then system have to show alert like " u allready submitted data for same SrNo on jsp page

I am trying to connect to a Microsoft SQL server database using PHP 5.6 and am getting the error "could not find driver". I am initially attempting to use PDO but I could use the procedural version if necessary. I have downloaded the SQL server PHP driver and placed it …