[microsoft:sql-server] Forum Topics

Hi guys, I've been cracking on with this project for a few days now and had lots of useful pointers to help along the way. I've now hit a little snag where I think I have written the correct update Statement but It seems to error at the last point. …

hi guys. am new to this forum. i need help. pardon my english. i am making a project in c#dotnet on event management. its a window application. am using visual studio 2008 nd for db am using sql server 2005. in thi project following things should be included- 1 - …

Hi Guys, The reason for my message was to do with UPDATE and DELETE Statements from within C# when contacting a MDB file. I currently have the INSERT INTO SQL Query working perfectly The Code I used for this is below: else if (radioButton2.Checked == true) { //Creates new versions …

I want to have the following on SQL Azure: IF EXISTS(SELECT * FROM [sys].[databases] WHERE [name] = db_name() AND [compatibility_level] = 110) BEGIN ALTER PROCEDURE [dbo].[Test] AS BEGIN -- Omitted body containing lots of strings END END or a work-around that does something similar. What follows is what I'm trying …

Hi, I seem to be having a problem when attempting to insert a new record into my database through vb.net. From what I can gather, there seems to be an error in the code that the command builder (cBuilder) is creating for me. Here's a copy of the code for …

Public Class LoginForm1 Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click Dim con As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\ahamdi2\Documents\Visual Studio 2008\Projects\sistemPengesanan\sistemPengesanan\admin.mdf;Integrated Security=True;User Instance=True") Dim cmd As New SqlCommand("SELECT * FROM info WHERE username = '" & UsernameTextBox.Text & "' AND [password] = '" & PasswordTextBox.Text & "' ", …

hi I want to list all tables in sql server compact 3.5 database and total of a specific column (I have a column name "total" in all tables).when i run the code I get no error but it does not work. can some tell me what is wrong with the …

hello daniwebscoders.. can you help me with my project?? i want to save a finger print file to a sql server table and then i also wanted to read it when you tap the finger print reader and it will input a time in :) sry for my grammar

Please I am new to the ADO.NET connected layer. But I have been able to learn how to communicate with my db effectively on the connected layer. But I notice that wen I execute an insert, update or a delete sql. I dont see the changes in the database. I …

Hi again guys... I have a little but of an issue with a select statement I cannot seem to fathem out. Below is the code: else if (radioButton3.Checked == true) ; { //Looks at the row Selected in the GridView and then takes the Account Number and Stores in a …

how to code vb.net connection string support to all computers? normally we are puting connction string like this. con = New SqlConnection ("Server=REHAN-PC \SQLEXPRESS;Initial Catalog=library;Integrated Security=true") con.Open() but the thing is when we are going to put this application to another computer we have a trouble. Now what to do? …

Hi Guys, I've just picked up an old projcet I was working on (about 6 months ago) and trying to get my head around my own messy N00b code. I've managed to get the grid views working with links back to the tables and showing data in the correct places. …

Hey guys ineed help on how to install or which is first to install using VS 2008 and MS SQL server & and IDE server management tool for MSSQL 2005

Hello, Here is my code so far: TempCommand.CommandText = "SELECT Lenscode FROM Products WHERE (Lenscode LIKE '%@Input%')" TempCommand.Parameters.AddWithValue("@Input", "5") When using a datareader this does not work. but when the code is like this it works: TempCommand.CommandText = "SELECT Lenscode FROM Products WHERE (Lenscode LIKE '%5%')" So my question is …

declare and assign value to variable at runtime in C# variable names are stored in database(sql server). how can i able to declare varible with these name during runtime. after that assign value... thanks. amit

Good Day All I imported data into a Ms Access 2013 from SQL and all the data is there. I created a Query and also created a report that will use the Query. So the Query returns all the data. There are around 590 000 records that needs to be …

is it true that no. of rows affected by select statement (ado.net) , is always -1. i.e. NO. OF ROWS AFFECTED BY SELECT STATEMENT = -1 ; if it is then why ?

Hi, In a form of 10 checkboxes, i needed to write/read/update those checked state values to and from SQL. Could you please let me know the best of of doing this.Each checkedbox represent one database column with bit type. Thanks. Subhash.

I am inserting values into a database but i get an error, it says the variable name @emp_login has already been declared. How do i resolve this? This is my code `SqlDataReader readerReference = cmd_Reference.ExecuteReader(); SqlCommand cmd_Insert = Connexion_Insert.CreateCommand(); string insert = "INSERT INTO EMP_tracking(emp_login, emp_dom_code, emp_domain,emp_surname") VALUES (@emp_login,@emp_dom_code,@emp_domain,@emp_surname); int …

i am getting error ERROR: The specified string is not in the form required for an e-mail address. but when i pass static email address , it works , why ? protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(connectionString); String command = "select visitorEmailID from tblvisitorSubscriptions"; …

Hi everyone, I need suggestions. A little corporate needs to track its data with 2-3 employees making a daily data entry/updating of few records (20-30). Data must be available to other employees. They want to store data in a SQL Server db that has been already implemented. The whole db …

Hi All I am currently using a Dataset in my program to load data from a SQL database. when i open my form, i am using a Me.Tbl_CustomersTableAdapter.FillBy(Me.MydatabaseDataSet.tbl_Customers, ID) to load the data, which i then bind into the textboxes on the form. I would like to know if there …

hiii, i am executing the following stored procedure but having errors... create procedure check_returns @salesman varchar(10),@RCV10 int,@RCV09 int,@RCV15 int,@GPRS15 int,@RCV20 int,@RCV25FTT int,@RCV25 int,@RCV31 int,@RCV30 int,@RCV35 int,@RCV50 int,@RCV55 int,@SIM int,@VTOPSIM int,@VTOPBAL int,@THREEGSIM int, @ENTRYDATE datetime AS BEGIN if exists(select * from CardsIssued where salesman=@salesman and RCV10>@RCV10 AND RCV09>@RCV09 AND RCV15>@RCV15 AND …

Hello guys, Here is an interesting problem to tackle with. Most of us are familier with SQL Injection. For those who are not Familier here is Short intro to it. When you enter your data into a Login Form, suppose ID and Password, Following code comes into action. "SELECT * …

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace testingdatabase { public partial class Form3 : Form { public Form3() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { new Form1().Show(); this.Close(); } private void text_searchstring_TextChanged(object sender, EventArgs e) …

hiii, i am executing the following stored procedure but having errors... create procedure check_returns @salesman varchar(10),@RCV10 int,@RCV09 int,@RCV15 int,@GPRS15 int,@RCV20 int,@RCV25FTT int,@RCV25 int,@RCV31 int,@RCV30 int,@RCV35 int,@RCV50 int,@RCV55 int,@SIM int,@VTOPSIM int,@VTOPBAL int,@THREEGSIM int, @ENTRYDATE datetime AS BEGIN if exists(select * from CardsIssued where salesman=@salesman and RCV10>@RCV10 AND RCV09>@RCV09 AND RCV15>@RCV15 AND …

hi there.. I just need some help for my loan management system. thus anyone know how can i stored schedule of amortization to the sql serve? is it 1 insert statement is enough to store in database? do this problem need looping. I don't know what code should I need …

hi Im using chart to display data in VS 2010, its working properly with this code... Chart1.Series(0).Name = "Days Used" Chart1.Series(0).Color =Color.Red Chart1.Series(0).XValueMember ="Account Name" Chart1.Series(0).YValueMembers ="Days Used" Chart1.Series(0).IsValueShownAsLabel =True my x&yvaluemembers value came from sql server database. The "Account Name" And "Days Used" are alias of my database column …

hi all. I want to fill the Listview from a mssql database in vb.net but it not show all the data in Listview. I have the followning code. Dim sSQL As String Dim lvwItem As New ListViewItem() sSQL = "SELECT field1, field2, field3 FROM tablenam e " sSQL = sSQL …

SELECT DISTINCT course.course_no, description FROM course, section WHERE location = 'L210' ORDER BY course_no Here is the problem: Give me a list of courses (by course_no and description) that are taught in room L210 But now find out I need to use the JOIN...ON... syntax Need help redoing that with …

I have Two Sql Table. 1st Table name is **Allowence** and Columns are EmpId,Name,Basic Salary,Da,Ca,HRA. 2nd Table name is **Deduction** and columns are EmpId, PF,ESI,Others. I wants to display all these column to a DataGridView. also I want to calculate Gross Salary and display this Gross Salary value to DataGridView. …

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace Dbconnection { public partial class Form1 : Form { public Form1() { InitializeComponent(); } SqlDataAdapter da; SqlConnection con; DataSet ds1; private void Form1_Load(object sender, EventArgs e) { con = new SqlConnection("Data …

Hi people, I would like to learn how to create database applications which store the data entered by multiple users, process the data, and provide the data as requested by the user. Is it possible to write such an application by using Microsoft SQL Server and Microsoft Visual C#? I'm …

Hi I want to know if I can search my database, with the help of a text box. When the search button is clicked, the results is displayed in a list box so that the user then can select the result that suits him and then add that text to …

guys i need ur help i want to insert data directly into the sql table using c# here is my code all that i have been able to do is get the values from the table not insert them i tried to do it this way but apprently there is …

*It's my first time here but the way I see things around here is good * I'm a newbie in VB2010 so please don't judge me too much... HERE is my codes for INSERTING DATA but the problem is I don't know how to use it for SEARCHING Imports System.Data.SqlClient …

No mapping exists from object type System.Windows.Forms.DataGridViewRow to a known managed provider native type. Using conn As New SqlConnection(My.Settings.Smitty) Using cmd As New SqlCommand() With cmd .Connection = conn .CommandText = "Update Repairs set status = @status WHERE RepairNumber = @repairNumber" .Parameters.AddWithValue("@status", "Awaiting Part Installation") .Parameters.AddWithValue("@repairNumber", RepairInventoryDataGridView.Rows(4)) End With conn.Open() …

I am running a script on our production database reffering two tables : our table of users (3700 of them) and the table of quotes that they have made (280000 of them). Quote is the main object in our application, a very large object, for whom many data tables are …

Hello guys, Do anyone know how to write recursive SQL statement for hierarhic output places from next table: id-----place----------idParentPlace 1......World..........Null 2......Europe.........1 3......Mediterranean..2 4......North Europe...2 5......Italy..........3 6......Greece.........3 7......Island.........4 8......Norway.........4 I was looking for alot of tutorials but didn't find anything useful. Any help is the most welcome! Regards, TP

hello experts . . . i've designed a form (two textboxes and one commandbutton) i wanna display id and user(fields of the table). and i display id and user on the basis of the id(inputted through textbox1).And for that i've written following code within command button's click event Private Sub …

Hi, is there another way of hiding or formating column value in asterisk in select statement? im using the command replace SELECT REPLACE([Item].[Price],[Item].[Price], '**********') AS Price From Tablename it works fine, but is there anyway to do this? Instead of replacing/forcing the value to display asterisk, i just need if …

I am making a visual basic project and using MS Sql database as datasource. Now my problem is if I will use the project's .exe file on any other machine which has MS Sql already installed, then will the application will start using the database on its own or do …

Hello everyone am facing an error exception SQLServerException: The TDS protocol stream is not valid Jan 19, 2013 4:21:02 PM com.microsoft.sqlserver.jdbc.TDSReader throwInvalidTDS SEVERE: ConnectionID:18 got unexpected value in TDS response at offset:1508 Jan 19, 2013 4:21:02 PM com.microsoft.sqlserver.jdbc.TDSReader throwInvalidTDS SEVERE: ConnectionID:18 got unexpected value in TDS response at offset:1451 com.microsoft.sqlserver.jdbc.SQLServerException: …

I published my project in vs2010 and im trying to deploy it to other computers. I used this connection string that runs smoothly on my pc. This code tries to retrieve the servername and try to connect to database mysysDatabase. This forcely change the app.config. Private Sub btnOk_Click(ByVal sender As …

Hello Guys, Here is an interesting problem. I have the following code. But it seems like I am missing out something in the process of populating drop down menus with data from database. You guys have a look at it and please give your valuable suggestions. Private Sub Open_Exam() Dim …

hello people, I have the following piece of code. Private Sub SR_No() Dim con As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\VB Applications\PROJECT_1\PROJECT_1\examdb.mdf;Integrated Security=True;User Instance=True") Dim cmd As New SqlCommand("Select MAX(SR_No) from Stud_Master", con) con.Open() Dim dr As SqlDataReader = cmd.ExecuteReader() MessageBox.Show(sr) con.Close() End Sub I wish to fetch SR_No into a variable sr. …

Hi, I've had a look around the forums but I couldn't find a specific answer to my query. I'm following a worksheet I was given from university. We have just started working on SQL and databases and on the worksheet it uses SQL 2008 Server Management Studio. The version I …

Hi Guys, I have a checkboxlist and a function to update the checkboxlist which are found inside of an updatepanel. The update button calls a function which deletes values from a table and uses a sqlbulkcopy to map a the boxes chosen to a sql table. I've stepped through the …

I am using SQL Management Studio Express and Visual Studio 2008. I have this string used for accessing the database for the system I have: Public constring As String = "Driver={SQL Server}; Server=MyName-PC; Database=RBMonDB; uid=; Pwd=;" This string is stuck on one PC. So I thought of creating a generic …

Hi, I let say I use this code to retrieve date from database SELECT Table.Date FROM Table The format is 01/09/2013 (dd/mm/yyyy) How will i format this to get 09-Jan-2013 output then print this format to crystal report? I'm using dataset to connect data to crytal report I just noticed …