4,457 Topics
 | |
| | hello, i'm doing a searching form, here is my code [CODE] Dim con As New OleDbConnection Dim cmd As New OleDbCommand Dim rd As OleDbDataReader con.ConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Bengkel\Project\db.mdb") cmd.CommandText = "SELECT * from Book where authorName like '%" & textsearch.Text & "%'" cmd.Connection = con con.Open() rd = cmd.ExecuteReader … |
| | Hi every one I'm trying to retrieve UserID (which is autonumber in ms access database) using C# and assign it to string u.I'm totally new to C# and trying to get more skills.... here goes.. string connStr, selectCmd; connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=..\\library.accdb"; selectCmd = "SELECT * FROM users WHERE First_Name … |
 | using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class loginApplicant : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void btnsubmit_Click(object sender, EventArgs e) { // String … |
| | i am trying to get crystal report of my Marks_master Records From Table . I tried Following Code But It is Giving Me Exception As : System.IO.FileNotFoundException was unhandled Message=Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one … |
| | Imports System.Data Imports System.Data.SqlClient Imports System.Configuration Partial Class books Inherits System.Web.UI.Page Dim con As New SqlConnection Dim cmd As New SqlCommand Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load If Not IsPostBack Then BindRatingControl() End If End Sub Protected Sub RatingControlChanged(ByVal sender As Object, ByVal e … |
| | Hi! I'm writing little software just to get some practice in c#. I have listview in form 1 where program displays first name and last name form access database. When admin selects name/surname in listvioew and press show usercard(form2) I have a label in form2 and I want it to … |
 | Need help while working with timer.... I am trying to do the database restoring part.... When the user clicks on the restore database button the progress bar shud be shown and as soon as the restoring is completed the progress bar shud stop and display success msg... Right now I …  |
| | I have always used Excel.interop before but I thought oledb would be simpler because, for this application, I only have to read the data which it can't seem to do. It accesses the file alright because I can't open the file while I am at a breakpoint. It attempts to … |
| | i have a database table and it has some column with duplicate values , and i want to get that column value of the table in a combobox, but i want every value single time not repeatedly ... i tried but it is still giving me all values in the … |
| | When I try debugging this, it comes up with an error on the line "If txtUsername.Text = ds.Tables("AddressBook").Rows(inc).Item(1) Then". It says NullReferenceException was unhandled. Object reference not set to an instance of an object. Public Class MainLogin Dim MaxRows As Integer Dim inc As Integer = 0 Dim con As …  |
| | Error Preview : http://botiman.phc.my/komen.php Warning: file_get_contents() [function.file-get-contents]: Couldn't connect to server in /home/u763744738/public_html/komen.php on line 163 Warning: file_get_contents(https://api.facebook.com/method/stream.addComment?post_id=100000744171962_491171407584327&comment=apapun+statusnya%3F+jempol+iwan+slalu+mampir+di+status+Awang+Ashraf%0A%0A%5B+Jam+%3A+6%3A24+pm+%5D%5B+Minggu+%5D%5B+Tgl+%3A+4%2F11%2F2012+%5D&access_token=AAAFppwP1iJYBAKZAmaHhSyydzDuZBh7B00nIO6YxfrwnutzQycNdso1lnW2raRcGR5c8iDc2hNNZCgssXJ8d6lYPWfjFOAnB62VzGk5MNnoLtmXXzvr) [function.file-get-contents]: failed to open stream: operation failed in /home/u763744738/public_html/komen.php on line 163 Warning: file_get_contents() [function.file-get-contents]: Couldn't connect to server in /home/u763744738/public_html/komen.php on line 163 Source Code Is <?php ##############config#################### $bot['like'] = true; …  |
| | Ok, this is not a question where I am having issues, but seeking an advise from you on JQuery plugin development. We have to agree, there are many JQuery plugins in different categories such as image gallery, form validations, effects and so on. I was about to create a basic …  |
| | Hi All, I have Code on PC1. and Access DB on PC2 . I have shared Folder on PC . And very much able to access from PC1 with full ownership. Now I was trying to connect Msaccess from PC1 using below code. cnn.Provider = "Microsoft.ACe.OLEDB.12.0" cnn.Open "Data Source=\\192.168.0.1\Public\tels.accdb;Persist Security … |
| | I am making a maze that consists of 48 nodes and the user needs to start in A1 and make there way to H6. The maze is created by reading a file, each line in the file looks something like A1 A2 B1 - - - where A1 is the … |
| | Public Class txtSurname Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cn As OleDb.OleDbConnection 'Dim con As OleDb.OleDbConnection Dim dbProvider As String Dim dbSource As String Dim DS As New DataSet Dim DA As OleDb.OleDbDataAdapter Dim sql As String dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" dbSource = "Data … |
| | So here is my problem. My program's goal is to to find the shortest path for a maze in a text file. User inputs a string and then the string goes through a function that reads the file into a 2d array. My problem is that I'm seperating the sources …  |
| | i got error when making this code. Here is i attach my code and tables: My Tables are =============================== **PRODUCT** **TR_RECEIVE_PRODUCT** >ID_PRODUCT >ID_RECEIVE_PRODUCT >NAME >ID_PRODUCT >CURRENT_STOCK >DATE_IN >STOCK_IN ==================================== ============================================================================= Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click Dim cmd As New SqlCommand Dim connectionString As … |
| | Imports System.Data Imports System.Data.SqlClient Partial Class test Inherits System.Web.UI.Page Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim txtName As String = TextName.Text Dim txtcomment As String = TextComment.Text Dim txtemail As String = TextEmail.Text Dim con As SqlConnection Dim cmd As SqlCommand con.ConnectionString = "SqlData Source=(LocalDB)\v11.0;AttachDbFilename=App_Data\library.mdf; Integrated … |
| | Here is a very tiny program(3 files) has embedded with Smarty template engine. Anyone knows how to remove Smarty completely? I konw the procedure to remove Smarty but failed to rewrite the code into pure PHP. Complete source files as in attachment. **CLICK HERE!!**~~~ http://www6.mimima.com/link.php?ref=FGHkNoDtmB *****************index.php <?php require("comm/Smarty.class.php"); require_once("get_data.php"); require_once("books.php"); … |
| | Hi, I am trying to copy all contents from one directory over to another directory. This is the code I have so far: [CODE] #include <dirent.h> #include <errno.h> #include <fcntl.h> #include <pthread.h> #include <stdio.h> #include <stdlib.h> #include <string.h> #include <sys/stat.h> #define MAXNAME 80 #define R_FLAGS O_RDONLY #define W_FLAGS (O_WRONLY | … |
| | Hi All, Sorry if this isn't the appropriate place to put this question, but I'm new to the forums. My issue relates to ASP and a DSN-less connection. I have a website, which was built quite a while ago using DSN connections to an Access database, which ran on a … |
 | Hi, I need a little help here. I'm Using vs 2005 with ms access 2003 database and finding myself how to get rid of this error "Syntax Error on UPDATE Statement" can you take a look at my codes below and tell me what's wrong? Thank you. Public Class Transactions … |
| | Hi,I have problem on my code,it will not insert to the database can you pease help me on this.Thank you in advance. Imports System.Data.SqlClient Imports System.Data Public Class Form1 Private m_con As New SqlConnection Private m_DA As SqlDataAdapter Private m_CB As SqlCommandBuilder Private m_dataTable As New DataTable Private m_rowPosition As … |
| | Friend Sub Inventory_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load 'Connect to database dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" dbSource = "Data Source= C:/Inventory.mdb" con.ConnectionString = dbProvider & dbSource 'Open database connection con.Open() MsgBox("Inventory is opened now") 'Import the data on tables sql = "SELECT * FROM Brands" sql1 = "SELECT * FROM … |
| | AoA I am Inserting Data From DataGridview to Sql2005.It Insert Perfectely. The Problem is that when i insert record it alway insert 0 row with my other rows The Code is below try { string con = "Data Source = FLOWER-PC;Database = MYFIRSTDATABASE;Integrated Security = True"; SqlConnection cn = new … |
| | I'm pretty nee to all this stuff, I have no problems reading from the database but writing new records and updating fields etc is proving to be quite difficult. The following code is just meant to create a new record in a table, I started the field count at [2] … |
| | 'Inline Code Example HereHello i'm having this error message when adding to multiple table: '"The DataAdapter.SelectCommand property needs to be initialized." 'I need to have my data saved into both table(tblStudentInfo, tblPayment) when btnFinish clicked. Please 'help, i'm working on this for days and haven't had any luck. 'For reference … |
| | I use following codes in my project. Dim cnCheck As ADODB.Connection Set cnCheck = New ADODB.Connection Dim rsCheck As ADODB.Recordset Set rsCheck = New ADODB.Recordset cnCheck.Open "provider = microsoft.jet.oledb.4.0;persist security info=false;data source = " & App.Path & "\MyDatabaseNameHere.mdb" cnCheck.CursorLocation = adUseClient rsCheck.Open "SELECT * FROM yourtablenamehere WHERE id=" & txtid.text … |
 | I'm looking for some key works which could sum up the below. I'm going to purchase a book or a few books to help me understand these areas. Would anyone be able to suggest books or a book on this topic. The topic is: I want to understand more about … |
| | i have a page (APPLYforJOB.aspx), now if an registered user ahs signed in and clicked on APPLY for job Button then he will be promoted to page to fill his info but if he is hasn't logged in then he will be redirected to LOGIN.aspx page, I did it successfully …  |
| | Hi, I have a stored procedure that will display an activity if the user enters the correct appref. This stored proceudre works fine on SQL management. However when i bind it to the gridview on my page it doesn't work on the internet, keep getting the error. Cannot open database … |
| | i wanted to know the code for putting values from comboxes into Datagridview but i tried but im getting coversion exception.. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim conn As New SqlConnection("Data Source=.\SQLEXPRESS;Initial Catalog=grade;Integrated Security=True;Pooling=False") Dim cmd As SqlCommand If ComboClass.SelectedItem <> "" Or … |
| | I want to create a word processor. It seems like a useful project because I have strong feelings about how modern big word processors like MS Word and Open Office don't do things right, so my solution is to make one with more modest features but with the huge advantage …  |
| | *.cs page code* using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class advertisementSubmission : System.Web.UI.Page { protected String EmplyrSession; protected int userId; protected void Page_Load(object sender, EventArgs e) { EmplyrSession … |
| | I'm in an introductory CS course and our task is to build the best ideal boggle board (one that would get you the most points). We are allowed to use arrays, c-strings, and reference parameters (no structs/pointers since we are just starting to learn about those). Step one: I built … |
| | Hi I am working on a project where i am using open source files. I am getting error ' Starting a second message loop on a single thread is not valid operation'. First I changed Application.Run to Form.ShowDialog but still I am having same issue. Other thread (Application.Run) is in … |
 | IE9 is on the horizon, and there has been plenty said about it. But what about its web development aspects? In this article I look at its web developer tools, and decide whether I'll start using it in my own web development. Like most web developers, I abandoned IE several … |
| | Below is the java source code where I am trying to read a file and want to display its content on an applet which is opened through a html page. The problem is that when I try to open the applet through appletviewer there is not problem the data is …  |
| | I'm making an Android maze game. Currently, I'm using the UP/DOWN/LEFT/RIGHT button from the emulator. I would like to add the motion sensor to move the ball. How do I use the motion sensors? Is there any open source to control the ball? http://images.plurk.com/4OmXYw7VZ76FYg2eufH4Bz.jpg package com.chrischu.inclassassignment_3; //import com.chrischu.mazegame.R; import android.annotation.SuppressLint; …  |
| | Hello all. My wife and I are getting ready to purchase an established business in the organic coffee industry. After 5 weeks of working in this business hands on, we have identified the need for a POS solution that would interface the business's website to take orders based on daily … |
| | I'm using a MSHFlexGrid (fgdVehicle) to input data from a database ( via a recordset (rsVehicle) ). You can either enter the data into the database in two ways : 1. From the database application 2. From a form. The problem is present in the second method. There are specific …  |
| | Hello everyone, I have a problem, i am unsure how to read the data from my Access Database into my vb.net form. I did some searching but i didn't manage to find anything useful so i would appreciate any pointers. Here is the code from frmAddNewCandidate i am using that … |
| | I have a custom class that consists of patient data. I am pulling data from three different sql tables and combining it into a list of patients. If the patient doesn't exist in the last table then I am inserting the patient into that table. From this last table, I … |
| | am using asp.net 3.5(c#) + sql server 200 DB, doing this GIVES me an error , *Error:The multi-part identifier "email@yahoo.com" could not be bound* why ??? using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; … |
| | Hi friends! I'm looking for an easy way to enable a user of my app to print the contet of a GridView.However, I think an easy way will be to convert it into a Crystal Report or pdf (many people say to pdf is terrible), so, I'd like to convert … |
 | MVC is something being sugested to us for use in vb .net (by someone who doesnt use vb.net, uses php etc.) i did research on it, and it seems to be more of an asp .net tool and not so much a vb .net tool.. for asp it states: You … |
 | Hi, Need a little bit more help. This isn't really my best area so please don't get angry if you feel I've asked for too much help? Coding a website for a GSP, still, and they want the bottom part for "Why PlugPayPlay" to have text which switches depending on … |
| | Mind guys if you could help me on creating this program(regards with file handling). starting with this: for instance. i have a .txt file that contains these: lexeme token main - Identifier ( - Open Parenthesis ) - Close Parenthesis { - Open Curly Bracket printf - Keyword ( - …  |
| | Dim conn As New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = e:\wms\wms\wms.mdb") conn.Open() Dim userDetailsAdapter As New OleDbDataAdapter("select * from daily_trans", conn) Dim userDetailsTable As New DataTable userDetailsAdapter.Fill(userDetailsTable) Dim returnRows() As System.Data.DataRow = Nothing returnRows = userDetailsTable.Select("cons = " & TextLine) If returnRows Is Nothing Then MsgBox("Can be saved") Else MsgBox("Primary Key") End If … |
 | Hi. I'm fairly new to VB.NET programming, and i'm currently developing an application for the sake of experience. What i know about Visual Basic programming might be considered dangerous, but none the less, i'm trying. I'm having difficulty getting past the idea of how to update a record in a … |
The End.