[microsoft:sql-server] Forum Topics

i have a table for cities and data which has entries in LACS , now i want to copy that table from one database to another, is it possibe ? i googled but couldn't find reliable solution mean i have fear to loss data .s o anybody , plz suggest …

when i use sha 512 on password field then it says k pasword field cannot be empty but when i remove sha512 constraint then it works and with any other hash it also works why ? and plz suggest me some good secrity hash etc to apply on password field

I have an Access database that I upsized with the wizard wishing to continue using Access for the Front End. I want to be able to connect to the SQL database without having each computer setup for the DSN. I added this to the autoexec macro. Function autoexec() On Error …

Hi I have a question, I want to transfer all nodes to a datarow Here is my XML <Employee> <person> <firstName>Jon</firstName> <lastName>Johnson</lastName> <skills>Singing</skills> <skills>Dancing</skills> </person> </Employee> THE HEADER TABLE SHOULD LOOK LIKE THIS WITH RELATION Profile_ID | Firstname | Lastname| 10 | Jon | Johnson | AND THE DETAIL TABLE …

Hi there, I have Page that goes to "sub categorys", but each time I upload a new product the subcategory gets duplicated each time, instead of having one "Vintage" category as I want I have duplicates. My current SQL query string is SELECT DISTINCT Picture, SubCategory, Categorie FROM Table1 WHERE …

I'm wanting to have a few different type of Rights/Roles that a user can be assigned. Since I'm using LDAP for authentication, I have a table setup on an SQL server that has my Rights Groups setup. I want to only show certain content on the site to individuals based …

I have a GridView called GridView1. I want to load it based on a ButtonTest being clicked. When the button is clicked, I need to do a SQL retrieval of data and popuplate the GridView with it. I can write the SQL code to get the data but I wasn't …

i use this Update code to update my record but i get this error msg : Dim con As New SqlConnection con.ConnectionString = My.Settings.TenderingSysConnectionString con.Open() Dim cmd As SqlCommand = con.CreateCommand() cmd.CommandType = CommandType.Text cmd.CommandText = "update BOQDetailEntry set BOQDetailEntry_ID=@BOQDetailEntry_ID, ProjectTenderingNO=@ProjectTenderingNO,BOQSection=@BOQSection,Part=@Part,BOQITEM=@BOQITEM,BOQItemNo=@BOQItemNo,Description=@Description,Unit=@Unit,BOQTY=@BOQTY,ReferenceDrawing=@ReferenceDrawing,ReferenceSpecifications=@ReferenceSpecifications where BOQDetailEntry_ID=@BOQDetailEntry_ID" ' BOQDetailEntry_ID=@BOQDetailEntry_ID cmd.Parameters.Add("@ProjectTenderingNO", SqlDbType.NVarChar, 50) cmd.Parameters.Add("@BOQSection", SqlDbType.NVarChar, …

Im making a program that a person comes localy on the program and make a account offlinly , I want that account have something like a premium on that program -offlinly again lol- for something for 24 hours , I want my accounts to be on the sql server , …

Hi, I have a dynamically generated sql query that is generated in VB6 and then passed on to SQL Server 2005. The query joins(inner join, left join, etc.) multiple tables. If I were to execute that query in Sql Server Management Studio, I would get something like this: TrayID| TrayID …

Please help me. I want to set the identity specification to yes, but all the option is gray out. I could not change it to yes from no. Ĩ̷̊ñ sql server 2008. Thanks

I'm beginner with vb6, i want help to create vb6 application store data in sqlserver8 Could you give me example for windows application?

Hi, I have 2 tables tbl_class & tbl_Divisions. structure: tbl_class tbl_Divisions tbl_class_division ---------- ------------- ------------------- class_Id (pk) division_Id(pk) class_division_id(pk) class_name division_name class_Id(fk) division_Id(fk) In my application I want to select division_Id,division_name by passing more than one class_id. if I pass 3 class_Id's , I want to get only those divisions …

private void button4_Click(object sender, EventArgs e) { { SqlConnection conn = new SqlConnection("Data Source=user-PC;Initial Catalog=URBAN-AUTO-CLINIC;Integrated Security=True;User Instance=False"); SqlDataAdapter adaptor = new SqlDataAdapter(); DataTable table = new DataTable(); DataSet ds = new DataSet(); adaptor.SelectCommand = new SqlCommand("SELECT FirstName,LastName FROM ClientNCar WHERE FirstName ='" +txtFName.Text +"'AND LastName='"+txtLName.Text+"'",conn); adaptor.Fill(ds); ClientSearchDisplay.DataSource = ds.Tables[0]; } …

Hello hi. I am seeing flames with using FILESTREAM in SQL Server 2008! I have a table (Products), in which I wanna store a link to an image stored on disk, under the ProdPicture column. This is what the script looks like: CREATE TABLE PRODUCTS ( ProdID INT PRIMARY KEY, …

-->>Hi everyone,I'm having this problem with updating records in my application my code is: SQL = "UPDATE Ministers SET User_Name='" & txtUser_Name.Text & "',Password='" & txtRetype_Password.Text & "',Prefix='" & cmbPrefix.Text & "',Passport='" & NewPicture_Name & "';" Call dbConnect Conn.Execute SQL Conn.Close Set Conn = Nothing -->>The SQL and Conn variables …

In sql server 2008, i have a store procedure which has insert statement , now i want to insert multiple records at a time into table via EXEC. MY Store Procedure: insert into tblUser(fullname, email, loginID, password, DOB, question, answers,doc,roleid) values (@fullname,@email,@loginID,HASHBYTES('sha512',@password),@dob,@question, @answers, GETDATE(),@roleid ) Now how to insert multiple …

i have this page in hard form and i need to make a table for it in DataBase (Sql Serber 2008), i tried alot but couldn't find any way to make table for it in data base. + i have also user table in DB, so userid should b also …

Hi daniwebians I have created a table in sql server called "report" and it has 3 columns "reportname","reportfile" and "reportflag". the report flag has only two values 1 and 0,if the value is 1 this means the textbox on the form will be enable. I have managed to dispaly the …

Hi guys I'm Indrajeet Roy, and I have a problem with a piece of code I am trying write in VB.net. I am using Visual Studio 2010 as my IDE. The basic idea behind the form and the coding I am trying to do is to create a username, password …

Hey Everyone, I am using the below query to try and group together values by the month of the date selected. the problem is that sometimes CTE2 will not have the same dates as CTE and those values end up omitted. Is there anyway I can just group these on …

guys . please help me how to connect a database in c#. thanks .

i would like to generate reports in c# what code do i require to do this, my database is ms sql compact 3.5

I used the upsize wizard in Access 2010 to split my database with the table being on the SQL server. I entered this in the autoexec (was macro, I converted it) Function autoexec() oConn.Open "Driver={SQL Server};Server=JCPLMSQL01;Database=TestingConnection;Trusted_Connection=yes;" DoCmd.OpenForm "Form1", acNormal, "", "", , acNormal autoexec_Exit: Exit Function End Function I don't …

Hello all. I have a simple quoting system I am developing for a project, and need help with how to query rates. There are two tables, one for zips (with state, county, zip code, and a zip lookup code associated with each zip), and one for rate data (company name, …

The procedure for Insert/update.I use datagridview get and display the data. I get the error message "Procedure or function Updatedata has too many arguments specified." // this is my Procedure ALTER PROCEDURE [dbo].[Updatedata] @item char(30), @uom int,@group int,@orqty int,@avgcons int,@reorder int AS BEGIN SET NOCOUNT ON; IF EXISTS( SELECT * …

i want to execute Store procedure via asp.net code, behind submit button, (SIGNUP) and also for login . how should i run store procedure ? and store procedure is in DB(sql).

Good afternoon. I am trying to import a csv file to a SQL database hosted through GoDaddy. However, I continue to receive an error which states "Line 7 has 24 values (20 expected)". Line 7 in my .csv file only has 20 columns (20 values) and no matter what I …

I have read many articles here, but haven't quite found the solution. I have a SQLEXPRESS database that is used by my VB.NET application. I have packaged and deployed the application via an MSI file and everything works great except I cannot figure out how to include my database file …

Hi All, Ever tried to make a change to a SQL database table only to get a message telling you it is unable to carry out the change as it would have to drop and recreate the table? This is one of these things that you encounter once, correct and …

I need you help in making a query about this table. ------------------------------------ boss # | bet1 | bet2 | bet3 ------------------------------------ LastName |Bet1 |Bet2 | Bet3 11111111 |1 |0 | 1 22222222 |1 |0 | 0 333333 |0 |1 | 1 44444 |0 |1 | 1 i want to count …

i used this code to delete row from datagridview but it dosnt delete the selected row it delete the first row , where is the problem?? Dim sCommand As SqlCommand Dim sAdapter As SqlDataAdapter Dim sBuilder As SqlCommandBuilder Dim sDs As DataSet Dim sTable As DataTable ***** Dim connectionString As …

Hello programmers! My Library Software with DataBase is 99% finished and I have an error. When I click Save or Delete I got error message: **Cannot insert explicit value for identity column in table 'Table1' when IDENTITY_INSERT is set to OFF.** I want to know **HOW** to set IDENTITY_INSERT to …

Friends, I am making Consultantwise patient report application using VB.NET 2005/08, SQL Server 2005/08. this application i am making for reporting purpose only. I have taken 2 datetimepicker(from date & to date) and one listbox to select the consultant name on my .net form. but i am confused where i …

Hi Everybody, I'm sorry if the asnwer is already posted somewhere, I was not able to find it. When I build my solution, I get the following error: 'UserManager.AuthenticateUser(string, string)': not all code paths return a value. Dont know the reason why is this happening. But I have included my …

Hi All, I am trying to use the aspnet_regsql command to add asp.net schema to a database in the app_data folder of my project. I ran this command: aspnet_regsql -A all -C "Data Source=.\SQLEXPRESS;Integrated Security=True;User Instance=True" -d "C:\USERS\ALEX\DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\ASPSLDB\ASPSLDB\APP_DATA\SLDBASP1.MDF" This should add the schema to the database using the …

Hi all, I have a form that is supposed to query a website. I have the following code that first looks at and uses data from an SQL Server db connection: ConnString = "Data Source=SQL2008T1;Initial Catalog=EconAnalysis;Integrated Security=True" SCqryStr = "" SQLConn.ConnectionString = ConnString SQLConn.Open() SQLStr = "SELECT vSeries_Number FROM tblVSeriesList" …

Hi....I want to add plus one in Id...the problem is i have to show after getting id from database...code is mycommand = new SqlCommand(query_Id, myconnection); reader = mycommand.ExecuteReader(); reader.Read(); txtID.Text = reader[0].ToString(); reader.Close(); for example in this case i m getting ID 3 in my text box but i want …

Hello I have an application that connects to sql database my application is multithread. When I run the application it loads top 500k data and stores it in #temp1(connection1), i can browse, search and select data, while my thread is running and storing the other 501 to 1m data in …

Hi all, I have a .NET form where I want to connect to a table and then pass each defined (by query) string from the table into a string within the code. I have created a connection to the database already via Data Sources but I'm unsure about the syntax …

I have looked into Cast and Convert, but I cannot find a way to do this. I need to convert four digits into an hour format. For instance, 0800 would become 8:00 or 1530 would become 15:30. I cannot use functions, I'm using a special form of SQL. Any suggestions? …

Dear experts, I have to contnous transfer data from one sql server to another sql server , but condition is that first sql (database used and inserted by another application) should maintain 3 month data at any time and anohter sql will store all the data transfer from first sql. …

hi all .... I have a problem in window application ..... the problem is that i have completed my project on lab management system(LMS) and now i want to create set up of LMS simply i created the set up but its not working for sql server ......So please if …

Hi, I have a form with two radio buttons (radiobutton1 & radiobutton2) "Male and Female". And i tried to implement it by making function and tried to save the data in database but noe succeed. Can anyone help how can i save the checked radio button data in data base …

Dear All ! I have a table titled Customer_DETAIL I want to check and make sure That there are no other records in the table that have The same CustomerID . The CustomerID are FK's From customer table. How can I check for duplicates so they do not create duplicate …

I got a datgridview. I add 1 more column to get difference of Meter 2 and meter 1. private void Loads() { ConnectionStringSettings conSettings = ConfigurationManager.ConnectionStrings["MyDBConnectionString"]; string name = conSettings.ProviderName; string providerName = conSettings.ProviderName; string ConnectionString = conSettings.ConnectionString; string sql = "SELECT * FROM WaterRecord Order by RecordID DESC"; SqlConnection …

Hey guys! I am building a data base in SQL server and am hoping to get some advice on frontends. The database is going to log and report on employee productivity. We would like to be able to use the frontend's forms to enter date time and project info in …

I have a Thread running sql query how can do i force stop the thread when i dont want to use it anymore. I have a form that loads 100k from sql server i retrieve first the 2k then the thread runs to retrieve the other data i want to …

i have a signup form on my website for user registeration ....... so i want to make it secure , by secure i mean , Password should be encrypted etc etc.....or any other precautions for security i already used hash functions of MS SQL on password field through queries but …

i have binding datagridview with 27 rows , i need to add these row to sqlserver table with other field how i can do that by insert statment???