4,457 Topics
 | |
| | what is the problem of my code...when i view it in browser and click the button insert there is an error message saying **"Syntax error in INSERT INTO Statement** Dim myConn As OleDbConnection Dim cmd As OleDbCommand Dim sqlString, BookingDate, CheckInDate, CheckOutDate, RoomNo As String BookingDate = txtBDate.Text CheckInDate = …  |
 | 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 … |
| | 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 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" …  |
| | Someone can tell me where i m doing mistake in order to show Autogenerate Id everytime with increasing of one. string conn = @"Data Source=FARHAD-PC\SQLEXPRESS;Initial Catalog=shop;Integrated Security=True"; myconnection = new SqlConnection(conn); myconnection.Open(); string query_Id = "select * from tblEmployee"; mydataadapter = new SqlDataAdapter(query_Id, myconnection); mydataset = new DataSet(); mydataadapter.Fill(mydataset); try … |
| | Hi Guys I have a script on my linux server.However i am having an issue with php-fpm ...whatever configuration i put , the php pages take time to load.For some configuration , the php files load fast at start and over time they become slow ...after 5-9 hours its 404 … |
| | hi im back with the new problem and the same problem..huhuh first is the same problem which is why does the data is not being inserted to the db..below is my full code for the custhome page 'Imports WindowsApplication1.LoginForm1 Imports System.Data.OleDb Imports System.Text.RegularExpressions Public Class Custhome Private _OrderID As Int32 … |
| | hi friends i am new in vb coding. i have two tables in ms access table 1 containing location column and id and table 2 containing id, name and date1, date 2...date 30 i have made form design in visual basic with "name" label with combo1 that selecting data from … |
 | I am trying to send sms through Way2sms using Perl LWP. The login part is being successful, after which I save the cookies to a local file. The welcome page after being logged in shows a Send SMS link, clicking on which one is redirected to another page with two … |
| | I am working on an online project ...... i have two links on one of the page..... say home page.... having two links One Say Shirts and Other Say Casual Shirts.... So when user click on Shirts he will be shown all Shirts from Shirts Table for men and when … |
| | All, I can't seem to find a good example of how to work with databases in C#. I'm using sqlserver and I can do simple things like insert and retrieve data, but when I am retrieving data I have to refer to the ordinal index values of the columns (reader[0], … |
| | Can you guys please tell me whats wrong on my code. Im trying to get the data of Title, Author, Price, Stock from DB and output it on my textboxes. Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load connstring = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Csrp2_DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" conn.ConnectionString …  |
| | Good day everyone, so here, i have a problem with my repeater control's sql query, what i would really want to happen, is i have a randomized number from 1 to 60, that will tell the database which test question to select, (if it's only one, it's not a problem, …  |
| | protected void button1_Click(object sender, EventArgs e) { SqlConnection con = null; con = new SqlConnection(@"Data Source=(LocalDB)\v11.0 ; AttachDbFilename=C:\Users\Bhawna\Documents\Visual Studio 2012\Projects\WindowsFormsApplication2\WindowsFormsApplication2\Database2.mdf;Integrated Security=True ; User ID=sa ; Password=123"); try { con.Open(); String Sqlquery = (" Insert INTO adb (Studentid) values (@S)"); SqlCommand sqlupdate = new SqlCommand(Sqlquery, con); sqlupdate.Parameters.AddWithValue("@S",Convert.ToInt16(textBox1.Text)); //sqlupdate.Parameters.Add(new SqlParameter("@S", SqlDbType.VarChar, 50)).Value …  |
 | who here like me is interested in augmented reality apps for example like google glass, wikitude, tagwhat, etc... which apps if you do use? and why do you use them. what is it that you like about them? if you had a chance to work on an open source app … |
 | gud day. I have 2 collumn from my database. DateHired ( datarow.item(5)) and EndofContract (datarow.item(6)) on my form i have 2 datetimepicker to record the employees previous jobs, i need to avoid overlapping on the employees recent recorded jobs. e.g if date hired is 01/02/2012 and end of contract is … |
| | please someone help me..im doing my final project and below is my code for the registration form..after i fill up all my form and it will appear a msg box that i can only register once...the data is not being inserted in the database..im using ms access...please2....do help me...i dont …  |
| | Hi everyone, I am now having problem with the First,Previous,Next,Last button to retrieve data. > Public Class DailyExpenses > > Dim connection As New SqlClient.SqlConnection > Dim cmd As New SqlClient.SqlCommand > Dim da As New SqlClient.SqlDataAdapter > Dim ds As New DataSet > Dim i As Integer = 0 … |
| | Hi, I have a simple question On my page I have two text boxes, a button and a label. I have a database DB_rental which contains a table TB_credentials (empID, username, password) User enters the username and password in the textboxes and clicks the button. The application should check the … |
| | Which are the free open source software for e- commerce? Anyone using zencart? |
 | If you are a non coder that wants the easiest book to start with, something very simple, easy to read and short , that can take you step by step in learning the basics of python in a few hours then you may like the book I have created for … |
| | this is my code for the login form using ms access would someone please help me? Everytime I run the program, it usually says connection cannot be used. If I would debug the program it will highlight "rspassword.Open "Select * from table1" I also used a module here Public rs …  |
| | I want the btnLogin_Click event to verify the username/password from the ms access database, if it matches it will take them to a certain page, if not it will give a message that user/password is incorrect try again. I really don't know where to start, can you please help first … |
| | whenever I try to run it I have a compile error in connecting my database this is my code Dim con As Adodb.Recordset Dim conn1 As Adodb.Connection Private Sub mygdb() Set con = New Adodb.Connection con.CursorLocation = adUseClient con.Open "PROVIDER = Microsoft.Jet.OLEDB.4.0;Data Source =" & App.Path & "\enrolment.mdb;" End Sub  |
 | The aim of this tutorial is to save burgeoning self taught developers some of the early pitfalls that lurk on the road to programming enlightenment. It will attempt to do this by distilling the last 50 years of software engineering philosophy into a relatively short single tutorial, applying the concepts … |
| | In this assignment, I am having to insert user information to tables that we have created and I am having this error that keeps on telling me " Code No: 80040e14 Code Message: IDispatch error #3092 Error Source: Microsoft OLE DB Provider for SQL Server Error Description: The name 'Br' … |
| | i want import Excel work sheet into ms acess existing table try { string conn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + filename + ";" + "Extended Properties=Excel 12.0 Xml;"; OleDbConnection con = new OleDbConnection(conn); OleDbCommand cmd = new OleDbCommand(); con.Open(); cmd.CommandText = @"SELECT * INTO [MS Access;Database=" + adb + … |
 | I have been programming in java for 1 year, but I would like to contribute to an open source program. The problem is its to compicated for me to join a open source program. Is there any recommendations you guys have for any open source projects I can join?  |
| | Hi Everyone, I am currently practicing through the NorthWind Example in ASP.NET, when i debug i am greeted with the message "Could not find output table 'ViewCustomer'. Despite linking to the form in the try statement, am i missing something here? I am using a OleDb connection rather than SQL. …  |
 | 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" /> …  |
| | I am working on an online shopping project....... I want to retrive data from database using checkbox...... For Example.... i have an mobbile form..... having all mobile records and have some filters such as search by brand, search by range etc.... let me take example of search by brand ...... … |
| | This is a late greeting from me to this community. i already posted some things here (i missed right directories, i guess i should buy new glasses). Please don't be mad at me for not introducing myself firstly, i'll try to make myself up right away if U have a …  |
| | Hello, I want to use some downloaded fonts in an application I am developing but I am a little confused by the terms of the OFL (Open Font Licence). Is anyone familiar with it? I am just confused by this part: 2) Original or Modified Versions of the Font Software …  |
| | Hello! I'm a beginner developer and I'm currently learning Visual Basic 2008 Express Edition. I'd like create the following program: - search custom selected database - if selected database contains TABLEX and if TABLEX has data in ColumnY and it equals 0 then make some sort of signal/error/report where it's … |
| | I'm creating a program where the user can search items in an access database and results are displayed in a listview. When I click search all items are displayed but when I enter an item in the textbox then search nothing is displayed. This is my code Private Sub cmdProdSearch_Click() …  |
| | 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 … |
 | hi guys, im curious about c++ gui qt , the i searched for it and download QT opensource 4.8.2 (300mb+) for windows i run the installer, then it asked me for MinGw's directory in my pc, then i use the MinGw inside my codeblock, after that it said "Found version … |
 | //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 … |
| | Hi All. I am currently at work on this program and have came accross this error when i debug the code in ASP via Internet Browser it displays the following message on top of the webform "Command text was not set for the command object" I am also having problems … |
| | Hi, I got error "No value given for one or more required parameters" error when executing the following code. I checked the value of the query and it seems correct. Does anyone know why? [CODE]string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Catherine\\Documents\\LearningCSharp.accdb"; OleDbConnection myConnection = new OleDbConnection(connectionString); myConnection.Open(); int employeeNumber = int.Parse(textBox1.Text); string name … |
| | I have been searching for a way to retrieve records from my database. I was able to find and create a function specific to my program, but it wont work. Will someone advise me on how I can go about this task? I catch error in binding source and error … |
| | 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 … |
| | Private Sub DataGridView1_SelectionChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DataGridView1.SelectionChanged Dim con As New SqlClient.SqlConnection("data source=GOLDA2\GOLDA;initial catalog=school;Integrated Security=True") Dim sql As String = "Select * from fees where particulars=" & "'DataGridView1.Rows(0).Cells(1).Value'" & "" Dim dataadapter As New SqlDataAdapter(sql, con) Dim ds As New DataSet() con.Open() dataadapter.Fill(ds, "fees") con.Close() … |
 | Hey guys hello, I am new to programming language. I have some suggestions about **Ditto Clipboard manager**. For that i would like to edit some part of ditto clipboard manager. Can you guys please help me **how can I edit it's source code**. It's available free at here, please [Click … |
 | Hi guys This is a question about C++ setting you dont even need to know about the library I am trying to use. I am coding C++ in VS2010 right now and I am trying to use 'icclib' which was downloaded from http://www.argyllcms.com/icclibsrc.html I made a new project, added an … |
 | 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 … |
| | I am trying to create a "simple" c# windows application for adding data from textboxes to a MS Access database on the local machine. I am new to C# and have not found a good tutorial on how to do this. I have viewed multiple sites and this is my … |
| | Hi, I am having the C application which I want to access a remote Java Web Service; I have looked for open source SOAP libraries for C and found [CSOAP](http://csoap.sourceforge.net/). However, I am having the following questions/problems with it: 1) Is it possible to access Java Web Services using CSOAP? …  |
| | **I am facing some problem in updating ms access with parameters. I succeeded to insert the data in access with parameters. My code for inserting the data is:** Dim dbPath As String = "C:\Users\Abhishek\Documents\ToolDatabase.mdb" Dim connStr As String ="Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data Source=" & dbPath & ";Jet OLEDB:Database Password=agupt80;" Using …  |
The End.