9,022 Topics
Hey guys! Can someone help me.? I have two tables named Questions and Examination, and two listviews named lstQuestion and lstChosenQuestion. I transfer the value of my lstQuestion to lstChosenQuestion through drag and drop and I already did that. My problem is saving the QuestionNumber equivalent of the transfered value …
Hi , I am a Newbie using SQL server and vb.net in VS2010. I am re-writing an exisitng application which is written in an old programming language. I have a table with invoice records waiting to be assigned an invioce number and invoice date. I have two ways of uupdating …
I'm a very new developer (if you could even call me that), and I'm killing myself here. Essentially here's what I'm trying to do. A user scans a series of documents which are sent through a program that places a .tif or .pdf of each document into a folder on …
Can anyone please help me out in creating an .exe file. I have a database included in my project as a backend. When i publish my application n run tat in my sys it works fine. When the same application is installed on other machine which doesnt contain sql server …
I have two forms and I am running a sql query to provide a set of variables in my first form that I need to pass to my second form. Here is the code that I have: [code] Imports System.Data.SqlClient Public Class Main Dim instForm2 As New Exceptions Public payrollstartdate …
Hi there, How can I use the “EncryptByPassphrase” for a table in ms sql server 2008 r2??? or if i can get a good tutorial appriciate a lot thanxxxx
i had a database with two tables a.table1,b.table2. In a.table1 i had three columns i;e a.col1(primary key),a.col2,a.col3 In b.table2 i had three columns i;e b.col1(foreign key),b.col2,b.col3 I want to delete a row in a.table1,b.table2 whose column names are different...but iam getting error as a.col1 is a primary key... so hw …
Hi, I have a question in MS SQ L enter prise edition. I have writtend an application in Visual studio 2008 standard edition and I am connecting to ms sql sever enterprise edition 2008 r2. When I depoy the application I created and install inanother computer some components relating to …
We installed SQL server 2008 on my workstation for testing SSRS 2008 and its performance over SSRS2005 But for some reason I am not able to access the reports from website or from visual studio 2008 the error I get is “The item '/CPPROD/UnprocessedInventory' cannot be found. (rsItemNotFound)” I think …
I want to UPDATE query instead INSERT INTO using this code help me thanks. [CODE] Dim cmd As New OleDbCommand("INSERT INTO tblPurchase_Order ([Order_Id],[Supplier_Id],[Address],[Project_Id],[dtpDate],[Material_Id],[Material_Name],[Unit],[Quantity],[Unit_Price],[Amount]) VALUES (@Order_Id,@Supplier_Id,@Address,@Project_Id,@dtpDate,@Material_Id,@Material_Name,@Unit,@Quantity,@Unit_Price,@Amount)", conn) cmd.Connection = conn cmd.CommandType = CommandType.Text cmd.Parameters.AddWithValue("@Order_Id", lstItems.Items(i).SubItems(0).Text) cmd.Parameters.AddWithValue("@Supplier_Id", lstItems.Items(i).SubItems(1).Text) cmd.Parameters.AddWithValue("@Address", lstItems.Items(i).SubItems(2).Text) cmd.Parameters.AddWithValue("@Project_Id", lstItems.Items(i).SubItems(3).Text) cmd.Parameters.AddWithValue("@dtpDate", lstItems.Items(i).SubItems(4).Text) cmd.Parameters.AddWithValue("@Material_Id", lstItems.Items(i).SubItems(5).Text) cmd.Parameters.AddWithValue("@Material_Name", lstItems.Items(i).SubItems(6).Text) cmd.Parameters.AddWithValue("@Unit", lstItems.Items(i).SubItems(7).Text) cmd.Parameters.AddWithValue("@Quantity", lstItems.Items(i).SubItems(8).Text) …
hello guys... I have been trying hard to connect to SQL Server using MFC but could not do that. No proper examples I could found. I know this can be done using ADO (ActiveX Data Object with COM) but have been unable to do that. Please can anyone of you …
Hi, i need to convert date format 1/16/2010 10:10:2011 AM to [COLOR="Red"]16/1/[/COLOR]2010 10:10:2011 AM after that i need to put values to database too as datetime datatype. error I am getting : "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. …
hi i have coded for forget password module but getting an error that is attached with... dont know why its hapen....here is code [CODE]string strCon = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlConnection objcon = new SqlConnection(strCon); objcon.Open(); string str1 = "'"+txt_EmpFP_Uname.Text+"'"; string str2 = "'" + txt_EmpFP_OldPass.Text + "'"; String query = "Select * …
Hello, i m looking for the database connectivity in asp.net with sql server 2005 or ms access 2007? please anybody solve my query. thanks in advance, looking for your response.
I want to convert my project into application........ But my program is working with the help of SQL Server through LAN.. I converted it as application software.. And It works well in my system only.. If i install and run it in some other system which doesn't have SQL Server,.Net …
I have a form that shows users data from a sql query. What I want to be able to do is when users make a change, they press a save button, the edited/changed data is saved to a new table and then the window is closed. I've looked for several …
I'm using ASP to dynamically generate an XML file (for an RSS feed) that pulls information from a SQL DB. Users input the data into the DB using a UI that is a straightforward html form. However, there is a textarea field in that form in which most users seem …
how can I select one or more columns from a table by column-index and NOT by columnname? I got the columnIndices of table by using this query SELECT name, colid FROM sys.syscolumns WHERE (id = (SELECT id FROM sys.sysobjects WHERE (name = 'table_name')))
Hi, In my current project we have been inserting quite a few records into the data base, we dint chk abt implementing locks, my client doesnt want any duplicate records for a column in a table, there is no primary key constraint on any of the column for the table …
Hi there, I am creating reports in SQL server business intelligent studio and when I deploy it to the report server the report is shown in only on a half a page. How can I make the report height and the width for the report thanksssss
Hi all, DANIWEB saved me a few months ago, and I'm hoping the community can save me again :) I've found myself in the position of needing to extract a very small portion of data from a vast SQL database. I've got the specific table in question, and have isolated …
How do I change the path for of the restore location in management studio. Whenever I go restore a DB it always prompts me to the damn C drive. Where do I go to change the path?
Hello all. I've had many problems solved for me by daniweb users without ever even joining. Now, though, I've run into a problem that I can't seem to solve. It feels like a very stupid problem that will probably have an easy answer, but alas I have not found it …
Hi I want to generate sequence number in C# window application I have got one link on Google, but I it is not helpful. I want that on click to add button an order sequence number should generate and stored in SQL Database i have written this code but it …
I have a Crystal Report that shows images using a SQL Database with the image paths When viewing the images in a report everything is fine untill you get to a page in the report when the error pops up [B](Request could not be submitted for background processing)[/B]. The image …
Hi I dont have a huge wealth of experince with SQL statements and im struggling; i have two tables table one holds employee data table two holds payent histroy for employee so essentially a 1 to many relationship I would like to list all of the job titles(for which there …
Need to insert byte array value in to a column using bcp bulk copy. Any way?
Hi I need to migrate an application from MS Access to SQL Server (2005), and i'm using the code bellow, but i'm getting an error when the compiler reaches the AddNew instruction. It gives me "Run-time error '3027': Can't update. Database or object is read-only". [code] Dim DBTesteSQL As Database …
i'm using checklistbox, i want to display data from sql database in checklistbox with check when particular id number inputted in textbox. Please Help...I'm new with visual basic... thanks..
I have Database name LoginUser with corresponding fields name such as User, Login and Logout. Im done in inserting data once the user Log to the system. Heres the sample layout once the user tried to log. User................Login............................Logout Abigail.........12/29/2010 3:08:42 PM James..........12/29/2010 3:09:45 PM Abigail.........12/29/2010 3:30:45 PM PROBLEM: 1) I …
Hi, I have to insert fields in a table. I am using VB.net & SQL Server database. The code is: Dim userid As Int32 = Me.classname.UserID Dim strSQLD As String = "Insert into table1 (userid) values (Me.classname.UserID)" userid is of type int While debugging, i can see that variable userid …
does anyone has a sample code or it it possible to fix error in this code I appreciate any advice the error i get : There was an error parsing the query. [ Token line number = 1,Token line offset = 13,Token in error = user ] cmd.ExecuteNonQuery() [code] Imports …
i recently posted a code that i had that i needed assistance for and it was solved it was for displaying all tables in a database.but now i have this code for showing all column names in a table i was in the process of turning it from oledb to …
Hi, I am working on a server which appears to have both MSSQL 2005 and 2008 installed. When I start the management studio, version 2008 opens. I am unable to debug triggers because I am told by the management studio that this feature is not available with MSSQL 2005. What …
i have corrected my conn string i am now using sql connection but now when i run the code it gives me he error Object reference not set to an instance of an object. [CODE] 'I put this code in the load event ListBox1.Items.Add(CType(GetTables().ToString, String)) [/CODE] [CODE] Public Shared Function …
Hi, Need help in creating backup/restore on database using SQL Server 2005 with VB6.0 code when the database is on the network. Please Help. frexyang
Hi guys, Issue is I have a grid view that I need to select certain values from to go into a SQL table. The following is my code from creating the grid though to the select button. [CODE] Partial Class _Default Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal …
hello i am using sql as backend and vb.net as front and in my particular field i want it 2 b autogenerated..bt i dont knw exactly how 2 do it..m a beginner and i need help urgently
Hello friends [CODE]String sql = "SELECT * FROM work.cs_book WHERE bookname = ? AND author = ? AND category = ?";[/CODE] I have writtern above query and where i can search for a book based on bookname author and category. I am using preparedStatements to execute query. However something is …
hi everyone. i have problem with SQL UPDATE command, with Add and Save Record, Delete Record and Search record, it works well, I have this code: for SAVE Command button squery = "": squery = "SELECT * FROM tblEmp WHERE EmpID=" & txtEmpID.Text & "" Call ExecuteCommand With rs .Open …
Please can u tel me how to take backup of database from sql server2005 using vb.net with the help of code
Hi friends, after a long time. i am developing a small tool by using VB.Net. I want to display data in comboboxes from a table which is in an access database. I using SQL query. Its a simple problem , I think the problem is in my COMMAND. I want …
hi. HAPPY NEW YEAR! :) I'm making a system that uses ms access2003 and vb6. My problem is how to search the database with two field names (namely: Lastname, Firstname) and yet I can still search them one by one. Ex. the Lastname field = "Smith" while the Firstname field …
Hi All, I have created a form for a user to create a booking of a meeting room, I need this form to do 3 things. have print functionality update the new booking to a dataset view the current bookings screen I seem to be struggling with the second task, …
Hello, I am Using VB 6.0 . Please Help me to get the codes to Create Backup and Restore in SQL server 7.0. I request Some one to help me at the earliest. Rajesh
Hi I am trying to write a function in which I customize my select statement. But it is not working as i desire... It is as [CODE] declare @column_name nvarchar(10) set @column_name = 'original' select @column_name from data [/CODE] Here original is the name of one of the columns. I …
I have a gridview which will display data from sql database. I need to use a custom delete button that when a checkbox is checked it will delete the row from the database its like the gmail functionality.
Hi I would like to save one table's data to another table. The code that I have wrote is this: [code] con.Open(); string copyData = "INSERT INTO Changes(IP,ServerName,[Type of Server])SELECT IP,Server,Name FROM Server"; cmd = new SqlCommand(copyData, con); int returnValue = cmd.ExecuteNonQuery(); con.Close(); [/code] and it seemed working but when …
Please Make For Us All Codes As File Text "*.txt" To Downloads or As Projects To Downloads Thank You For All Codes tarek-aec *** Thank You ***
i called a method and wrote the code there it throws an error of both datasource and datasource id shouldnot have the same name. [code] public void bindGridView() { ArrayList l=new ArrayList(); string strcon = ConfigurationManager.ConnectionStrings["connection"].ToString(); SqlConnection con = new SqlConnection(strcon); con.Open(); string insertstmt="SELECT * FROM officemaster where deptoffcode='"+TextBox1.Text+"'"; SqlCommand …
The End.