[microsoft:sql-server] Forum Topics

i want to copy data from an access database to a sql database 2008 through coding in vb.net any help ? NB : I WANT ALSO TO CHECK FOR DUPLICATES EACH I SELECT FROM ACCESS TO COPY IN SQL

Hello guys. I developed a simple game in C# on Windows (WFA). Now I want to crate a database with accounts and all stuff. I know to crate this with a SQL Local Database, but I think there should be a host where to put that DB to be accessed …

# Heading Here # how to store the coordinates (points) of a line as x0,y0 ,x1,y1 .....xn,yn in database MS SQL. coding is in c# 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; namespace WindowsFormsApplication6 { { List<Point> points = new List<Point>(); …

Not sure where else to put this, I apologise in advance if its in the wrong place. I'm trying to migrate a program from one server to the next without having to completely re-edit every configuration file. To do this, I need to enable the sql SA account, which I …

I am trying to connect a Crystal report to my database.mdf i.e SQL Server database. When using the wizard At the [I]Database Expert[/I] window after choosing the [I]OLE DB (ADO) [/I]i can not find any server and a database in the drop down menu. how to get that? i have …

I've a problem in getting a record from 3 tables: There are two conditions for getting the records,'project number' and 'current month'.I used this statement to get the records but it results in 3 times the actual record. Any help would be appreciated. "INSERT INTO patempTable SELECT [pay_roll].[project number],[pay_roll].[employee number],[pay_roll].[current …

hi i created login page using php and mssql but i got an error **"Fatal error: Call to undefined function mssql_query() "** **heres my log in code** <form name="log" action="log_action.php" method="post"> Username: <input class="form" type="text" name="name"><br /> Password: <input class="form" type="password" name="ssn"><br /> <input name="submit" type="submit" value="Submit"> </form> **log_in form** …

Hi there, Thank you for accepting me within your community My name is Bernard, I'm a French-speaking Belgian citizen living and working in Thailand since December 2003. I'm not an IT expert. I've been using VBA since Excel supports it (Excel 5-1995?). I work here as a school administrator and …

Good day, I need some advise. I have two database servers(primary & secondary) and both has installed the MS SQL Server 2008 r2. The idea is, the secondary server should setup as standby in case the primary servers down. How do I set it up? thanks in advance.

Please help me to connect my forms I created in Visual Studio 2010 to Sql server 2012.

Hi, Im making a simple program which converts a encrypted text file the upload it to sql CE. This is time in and out logs of every employee. The date is extracted from a machine and downloaded as encrypted file. We managed to decrypt it by getting the equivalent value …

I am importing data from an excel worksheet in to a sql table, one of the columns in the table is set to nvarchar(50), the data i am importing are barcodes, but the problem i am having is the column is changing the data for example the number "5900397732209" is …

I am developing a C# Windows Form Application. Now i am trying to select value from Listbox and load corresponding value in List view using the stored procedure. And this is my stored Procedure: ALTER PROCEDURE [dbo].[spPOExport] @BST_BESTELLUNG INT AS BEGIN SELECT BH.BST_LIEFERANT AS Product Name, BZ.BDT_REFNUMMER AS Unit Price, …

Hello, I am new to C# and i am stuck when i try to fetch the data from SQL Server to Visual studio. I am writing the code as a n-tier application - Data Access, Business logic and the front end. I am fetching data in a disconnected env. I …

hi there. Could you please help me out? I am a student and I started to learn Delphi to build an application for semestre exam.It is about students evidence. So I have downloaded Delphi from Embarcadero site and I`ve started reading the help manual..I want to use MS SQL Server …

Hi, I have created a databse using sql database "TestingSQL" using microsoft management studio 2012 and created a simple vb application as a tryout. It works well in my pc and i would be able to access remotely as well. But the problem is, it is only works with my …

I found this along my way of trying to learn how to use databases 1."SELECT usname, password FROM userinfo " & 2." WHERE usname = '" & textbox1.Text & "'" & 3." AND [password] = '" & textbox2.Text & "'" I would like to know how I would execute code …

HI, I have a common page (sqlhelper.cs) where i am preparing command and executing execnonquery,... But veracode addressed sql injection flaw 89 in the following code saying issue with parameters. How can skip this verification?. any extra validations i need to put in the following code? Please help. private static …

Salam... I have SQl Database...And i am using visual basic 2010 i have a problem with Null values.When in my database data have some null values then data not showing in my crystal report ...crystal report showing blank..I want '0' when data is null..for example my table name is (meetings …

I have a bunch of insert querys running and some of them fail with a duplciate entry. I want to see a log where it says "Error: Duplicate key" and that tells me the EXACT INSERT query that fails so I can see what keys are duplicated. Thanks

I'm working on an application for a joint-stock company. A joint-stock company is a business entity which is owned by shareholders. Each shareholder owns the portion of the company in proportion to his or her ownership of the company's shares (certificates of ownership). This allows for the unequal ownership of …

I have an identity (auto-increment) column in my mssql table, which is also my primary key. I want to use these numbers on my form, such that when I open that form, the auto-increment id will already be displayed on a textbox (so I wont have to type it in …

Hello how to connect Sql form to save and read information from Ini File?

below is the code which select value from the database and increase it by 2 and update the database with the new value. how do I lock or prevent multiple read and update at the same time? please help Dim query2 As String = "select * from " + usern …

I have a Visual Studio form that is linked to a SQL database table. I am adding a query via a tool strip to search the database and I have the following text boxes the user can enter information into: Client, Project Number, Project Manager, ServerArchived, PaperArchived. The user does …

hi there, i am getting this error while activity monitoring on sql server 2008 R2(SP2) and at the same time all the users application (i.e arround 200 users window user application) connected to the database in this server gets Hang and again starts functioning properly after 1 or 2 mins …

I want to check if txtCRCNum1 is empty or not. If it is empty, then some values from frmComm will get displayed on frmcrc (which I call the default values). If not empty, then it will execute an SQL query which will select data from the value of txtCRCNum1 and …

Hello, I have my password column with varchar(50) datatype. now i have created a new column NewPassword binary(16). I want to convert password varchar data to binary(16) format in NewPassword column. How can i do it? Thanks.

I am trying to add a Mysql Report to Reporting Server. I can call the stored proc and all the info appart from the date will show. So i was wondering if there was a way to do convert the date in mysql

Here is a sample code snippet of logging in a user against a user table in an MSSQL database with password encryption. Scott Knake

Hi guys i want to make database for payroll only but i dont know how to make structure for this suppose i want to calculate payroll every month for employees as following basic salary bonus overtime absence deduction meaning salary = basic salary +bonus+overtime-absence-deduction How i make database (ERD)Diagram for …

Hey guys, I'm not very familiar with asp.net (Doing this in c#) or session cookies for that matter, just the basics. Trying to store a list of items in a session cookie, then when needed, pull those items back out as a list to then use them in a MS …

*hi.. i just want to ask those who know to filtering multiple search using SP. My SP is working and the problem came when i want to call the parameter from my sp.can u check what error with my code* public partial class WebForm3 : System.Web.UI.Page { private string GetConnectionString() …

hi all I have an exercise when I select the value in the combobox will confirm the value on datagridview I wrote a code in combobox of from1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim sQry As String sQry = "SELECT Name FROM dtaStudent" …

public string Data() { string dohvat_podatka = ""; using ( MySqlConnection con = new MySqlConnection("Server=xxx.000webhost.com;Port=3306;Database=xxx;Uid=xxx;password=xxx;")) { con.Open(); using (MySqlCommand cmd = new MySqlCommand("SELECT ime FROM `nastavnik` WHERE prezime=@prezime", con)) { cmd.Parameters.Add(new MySqlParameter("prezime", "Carić")); using (MySqlDataReader dr = cmd.ExecuteReader()) { if (dr.HasRows) { while (dr.Read()) { dohvat_podatka = dr.GetString(0); } } …

COMBINATION_ACIL contains column: id (primary) prodcode [group] alias lastupdate updateby and here is the steps when i import xml to sql DECLARE @COMBINATION_ACIL AS xml SET @COMBINATION_ACIL = ' <Product> <product> <PRODCODE>CADB</PRODCODE> <GROUP>CADB</GROUP> <ALIAS>ADB</ALIAS> </product> <product> <PRODCODE>CI50</PRODCODE> <GROUP>CI50</GROUP> <ALIAS>I50</ALIAS> </product> <product> <PRODCODE>CI80</PRODCODE> <GROUP>CI80</GROUP> <ALIAS>I80</ALIAS> </product> <product> <PRODCODE>HOSBA</PRODCODE> <GROUP>HOSB</GROUP> <ALIAS>HOSBA</ALIAS> </product> …

Hi guys, I'm using a very simple database and dataset and it appears to be working, except I can't actually save any data. Here's what I did: I created an empty database with a corresponding empty dataset. I filled it in with 4 rows of dummy data (ID, name, address, …

Hello, I'm having some trouble with a £ sign, it's being displayed to the user as the <?> question-mark-in-a-black-diamond icon. I have an SQL Server database with a £ in a table. (Collation Latin_General_C1_AS which is analoguous to 8859-1) I have a PHP script which retreives this record without issue …

Hi all, Hi i have got a problem with the system i am creating on VB using Microsft Access. I have this error that keeps coming up when I debug my system. I am trying to add data in the database. I cant seem to find the solution to this …

I would like to know what you as a community think of my code in terms of database connection and SQL statements. How I do it physically. Let me know if there are any improvements I could make and if there are, point me in the direction on what i …

Hi, i have develop an window application using **VB.NET** and** SQL SERVER2008R2**.I have Sql server2008R2 installed on my system containing sql database file.I have my connectionstring in app.config file as:- <appSettings> <add key="mycon" value="Data Source=My-pc;Initial Catalog=MovieCatalog;User ID=sa;Password=pwd123" /> <add key="ClientSettingsProvider.ServiceUri" value="" /> </appSettings> Now what i want to do is …

Hi All, Having a few issues with some DB functions in my code at the moment. This code was developed by another user who kindly helped me out, and I know for sure it was working. The difference being that after having some compatability issues when upgrading to a new …

i need to copy my data from access database to sql database through coding in vb.net , and taking into consideration the duplicates each time i select from access database to copy to sql , any help thx

I'll be completely honest, I haven't googled this very much as I have no idea of how to put it. So a nudge in the right direction will be most appriciated. I have two forms and two tables. The first form has a series of text boxes that collect information …

i am not able to connect to the sql server on my system. SqlConnection^ connection=gcnew SqlConnection(); connection->ConnectionString ="Data Source=blueboy\sqlexpress;Initial Catalog=DCV_DB;Integrated Security=SSPI;Pooling=False"; i got the string from database properties.(i have attached the same in this post) sql service is running. tcp ports are enables too.

Evening All, I'm new here and new to PHP, so please take it easy on me! =] I'm working on a php login script that would allow a user to enter their last name or their username in the username field and their password. Upon submit, check for a record …

Can any guy tell me what is the differnce between a datareader and a dataadapter? Also what are the other method to search data through SQL queries??

how i can import data from access database to my database in sql server , with a check for ducplicate each time i move data i need the code in vb.net any help ?

[code] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click connetionString = ("server=192.9.200.82;database=eKalyan;user id=invite;password=invite") MessageBox.Show("connection established") sql = ("select newuniqueid,newteh_code,newpcate_cd,newplano, pen_nm,rel_cd,pen_fnm,ccate_cd,pan_code,pvillage,ppo_cd,spo_cd,start_qtr,last_qtr,bundle_typ,bundle_no,mo_srno,pen_amt,pen_comm,status,operatorcode from ekalyan.welpen") cnn = New SqlConnection(connetionString) Try cnn.Open() cmdd = New SqlCommand(sql, cnn) cmdd.ExecuteNonQuery() cnn.Close() MsgBox(" ExecuteNonQuery in SqlCommand executed !!") Catch ex As Exception MsgBox("cannot …

Hi, How to use in select statement with where condition comparing a Null value and with value? I have this Statement `Select Col1, Col2, Col3 From Table where DateDeleted` 'Here comes the problem The condition is something like if DateDeleted (which is actually a date) is Null then get records …