9,022 Topics
help friends, i am very new to vb.net and this is my first application. i create the setup project but after installing on another machine, the program cannot read from the sql2005 dbase. What files do i need to add during the compilation? i am sure that is where the …
Hi guys, I'm trying to create an array with the length according to the number of rows in my database. So here is my code. I getting "array out of bound". import java.sql.*; import javax.swing.*; public class prg extends javax.swing.JFrame(){ String nameC = "HDB"; String nameCC = ""; int count=0; …
http://www.daniweb.com/software-development/csharp/threads/202843/take-backup-of-sql-server-database-using-c Error : Back failed for Server I am using smo code from this thread , but it cant backup...
hi friends, i have a problem with using vb.net application, i want to restore my database from my vb.net application so that user clicks the restore button an OpenDialog open which Open the .bak and then restore the database to a state befor backup taken. i try the follwing code …
How does one validate username and password from sql database? I have used parameters in doing validating my database, but have noticed that username and passwords are being accepted when i type it straight out(EG. username= e001 , password=dave@road) , even though they have characters in capital letters(such as username=E001 …
hi every one! I am creating an application in vb.net with sql server 2005 at backend. I have a table PURCHASE Order with 3 colunn i.e PO_Id ,Cus_id and PO_QTY . In front end i have a SAVE button, two TexTbox 'POrder no' , 'Order Qty' and combobox 'cutomer NAME' …
i made the form of search of my project as in screen shot in vb.net the problem is that it shows the record many time of one person i put the sql query this qury = "SELECT p.per_id AS 'Person ID', " & _ "p.per_name AS 'Name', " & _ …
> please help me check this sql statement. it is giving me this error "No value given for one or more required parameters. " cn.Open() Dim cmd As New OleDb.OleDbCommand cmd.Connection = cn cmd.CommandType = CommandType.Text cmd.CommandText = "Update HallTransaction Set status=? where ID=?" cmd.Parameters.Add("@statu", OleDb.OleDbType.VarChar).Value = check cmd.Parameters.Add("@Custid", OleDb.OleDbType.VarChar).Value …
Hello DaniWeb, I have been working on a Maintenance Application. My company builds a specific type of system using specfic types of components. What I need to be able to do is keep track of which component is in which system given a certain event. ComponentType Table: Ident, Type ( …
Using VB.NET 2010 All helps is greatly appreciated! Currently I am parsing through 1,000s of text files each day and inserting them into SQL. I am unsure how to break up the actual pipe delimited data and insert it properly into my database columns so I am doing that through …
**Is this possible to establish connection with sql 2008 R2?** Dear Experts, I am trying to create connection between Sql 2008 R2 and Visual Studio 2010 (I have installed Sql first). Is it essential to work with windows 2007? I have to format my computer because of this, would you …
I can't seem to find an thread that matches my questions so I am starting a new thread... I made an application. I used: VB.net 2010 SAP Crystal Reports Runtime Engine for .NET Framework 4.0 SQL Server Database (.mdf) I don't really know how to setup so I just publish …
I 've a following query that going to use in python api. SELECT n.FIRST_NAME as "NAME", a.STREET_1 as "ST1", a.STREET_2 as "ST2" FROM SCHE.EMPLOEE_NAME n, SCHE.EMPLOYEE_ADDR a WHERE n.eid=a.eid AND n.estatus='ACTIVE' The above query yields the result cursor().execute(sqlQuery) sqlTupleRows=cursor().fetchall(); sqlQueryReturnedDict={}; for sqlTupleRow in sqlTupleRows: columns=cursor().description ...... Here the column names …
Hello, Does anyone know how to connect to a ms sql server from a unix platform Below is the code i found. I've setup the slq server and allowed it to accept remote connection. Port 1433 is open for connection and firewall is configered to allow remote connection. The host …
Hi All, am currently working on a biometrics application to capture the fingerprint of users. I am working with the DigitaPersonal (UareU 450) fingerprint reader. The app works fine at the moment but i need it to be more sophistciated by making it save the fingerprints in sqlserver database instead …
cant save ReturnIDcount in database table . ALTER PROCEDURE [dbo].[Transaction] ( @Patient nvarchar(50), @E_TO nvarchar(50), @R_type int, @User_name nvarchar(50), @ReportType int, @Patient_no int, @Patient_ID_NO numeric(18,0), @ReturnIDcount nvarchar(50) output ) AS BEGIN declare @idcount numeric(18,0) declare @tempid numeric(18,0) set @tempid = 0; declare @idcnt numeric(18,0) select @idcnt =isnull( max(idcount),0) from Transactions …
Hey Guys, I'm working on a practice Project at the moment where I'm recalling user information from a database, placing it into a form with several textBoxes, comboBoxes, etc and then proceeding to update the information in the database when the user clicks save. I understand this is simple, however …
Dear Experts, I am new in asp.net. I have to make a website in asp within 5 months. I have written connection string for sql server 2008 R2. I want to use "default login" but my connection string does not work. <connectionStrings> <add name="donationConnectionString" connectionString="Data Source=COMPAQ-PC\SQLEXPRESS;Initial Catalog=donation;Integrated Security=True" providerName="System.Data.SqlClient" /> …
Can there be a way of connecting a vb 6.0 application to SQL server, how possible is that if am using ADODB?
Hi guys, i have an application that seats on a single webserver that depends on a third party application running mssql, so i use mssql over free tds. now i have to scale this site so i have to think about how to handle the sessions. i ma basically looking …
I wanna just a beginning for my coding. (The application running with VB.NET and SQL server) I did this code and it not shown any error. After this process it is displayed the message "Successfully updated". But data is not update on the table. Please tell me, how to update …
hi am getting the following error when I try open my application. everything was ok and nothing has been installed. it just stopped working one day. Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /ssi/login/profile.asp, line …
i get this msg from sql server when i restore the back up file TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\TenderingSys' is incorrectly formed. SQL Server cannot …
I have created a linked server in ms sql 2005 on server machine A . It links to another database(say D1) located physically on a different server machine B. I have jsp code on Server A which accesses local database on server A. Can I access the remote database D1 …
How to use c sharp properties and after get value save in sql database.
I would like to develop a SQL injection vulnerbility scanner. However, i dont know how to develop it, It is any module in python could help me develop this app? My app requirement User able to input the target URL and apply SQL injection scanning on target URL After that, …
//When i click the update button to update record in database,i get following error : " String or binary data would be truncated. The statement has been terminated." plz help me to solve this problem using System; using System.Collections; using System.Configuration; using System.Web.Configuration; using System.Data; using System.Linq; using System.Web; using …
any1 here can help me how to backup and restore the datbase that im using by just clicking cmdbutton or something like that.
how do i write code 2 enter data from c# 2 ms sql?
Excessive Image Resource Hi So I'm writing a program to clear old images out of some folders. I get the old and new folder paths from XML and then check each image against my database then I move it using MoveFile() if it meets my requirements. The one folder I'm …
hello! i am developing a simple application which will get data from different database like mssql , access , foxpro , and after getting data it will create 4 text files tows.txt , customer.txt , product.text , trasection.txt , prob is this that i am very new to foxpro , …
Hi, I am displaying the values in Datagrid using VB.Net , SQL, i places add button below the grid , i want to add a new row when i click that button, i tried but didnt work can you assist?
Hi, I am writing a Silverlight Bing Maps based application and I am trying to merge two (and more) polygons. The approach I am using at the moment is the following: The geometry for the polygons is stored in a database, and Im writing and reading from it through a …
hello.... 1. how does one link a 2 radiobuttons in c# 2010 to the same column in ms sql 2005 2. what could be the problem when one tries to enter data from texboxes in c# 2010 to ms sql 2005 but its not reflecting? 3. what is the syntax …
HOW DO I DEBUG THE FOLLOWING An explicit value for the identity column in table 'tblApplicant' can only be specified when a column list is used and IDENTITY_INSERT is ON.
Dear Daniweb members. I am having quite a troublesome time here with OleDb. What I am trying to achieve is to allow my users to connect to an uploaded Excel workbook, then to be able to select data from the sheets. I have a query designer in the front end …
The application I am working on uses SQL to store data. Most of the data is fine the way it is, but one of the tables contains information that would be very tempting for some users to alter. My original plans were to have the application check the identity column …
hi, i have records in table like this: id v1 v2 v3 1 587 21 759 2 230 4 495 now i want ouput like below: id v1 v2 1 587 21 2 587 759 3 230 4 4 230 495 i am stuck here don't know what will be …
is it possible to use information input into one screen, then displayed into another screen using sql commands? this is how i am trying to get the information required: String sql = ""; if (cname.getText ().length () != 0) { sql = "SELECT CommonName, ScientificName,Type FROM Animals WHERE CommonName LIKE …
Hi guys just need a little help here. Well I'm done with the code but I can't seem to understand what's wrong with it. I mean when you are done entering your pair of username and password on both forms it's supposed to save the username and password entered on …
Hi Guys, Here is my requirements: I need to pullout records based on datetime fields ranges from 12 am in the morning of 2012/6/4 and 12 am in the morning of 2012/06/05. kindly please check my declare parameter for date if it is correct. Thank you in advance. Data: Declare …
Hello, I am a total noob to web development and am running into some problems. I am trying to search for a specific string, or records that contain a union of strings in a SQL Sever CE database using WebMatrix, and display the results. Ideally, I would like to have …
I need to know if there is any diferences when i create an application that connected with sqlserver for 1 pc or for a local network ?? anyone can help ??
Hello again everyone! I've been away for a while, but I've started working again and have a question I am hoping someone might be able to provide some feedback on. I have a SQL database that has many relationships that utilize surrogate keys. These relationships (some of them) have cascading …
HI. I have a situation where we need to pull data from multiple data sources into one dataset. Once we have the data in one dataset we would like to somehow manage to execute some sort of [complex] select query on the data in order to generate a new DataTable …
hi I am having a challenge with a Fetch statement being used in a stored procedure. I am declaring a cursor and fetching data into a set of variables. The variable types match the column declarations exactly. There is data in the table from which I am fetching. @@FETCH_STATUS is …
sqlBulk.WriteToServer(excelReader); string removeCharacter = "Select Replace('Price', '$ ', '') FROM #temp"; sqlCommand.CommandText = removeCharacter; I'm importing an excel file into sqlserver, I'm trying to remove the $ sign before I import the field into the database. The above code just does nothing $ sign still imports, also no error.
I have a column called pEditDate in the table rc_Pages I need to extract the date for each page so when the users goes to page /example the last edit date shows at the bottom. I try to do is but can't. Using SQL Server Comptact and C#
I have developed a test site in asp.net. While it is in running of the in built webserver it functions fine and am able to access the database (msde). But when i host it on IIS server on the same machine I get the following error whenever the site accesses …
Hi all, I'm newbie in asp. I have a problem to delete the record on sql. I have one form for different users to insert data into sql where every user have are unique id, so it's possible to have multiple record with same unique id, then display the data …
The End.