4,457 Topics
 | |
| | Hi I'm writing a site that allows users to download documents securely stored on the network off of the web server. I'm using a com object on the server that we've been using here for ages that fetches the file from the network in a binary stream thus preventing user … |
| | Hello, I am working on my new project and I need to create a table for each user dynamically. In which the user will provide the Table name in the textbox and on pressing Create button a new table gets created in the same MS access database file with the … |
| | Hi. I am doing a C# windows form application and I am using Ms Access for the database. I have a sql query which retrieves data from 2 tables and I am displaying it in a crystal report. The problem I am having is for example i have 4 records …  |
| | hi i want to show my table in afrid view reading from database but i couldint i tried many times can any one help me this is my code: [CODE] <%@ Page Language="JScript" Debug="true" %> <%@ Import Namespace="System" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <%@ Import Namespace="System.Data.sqlClient" … |
| | Hey, I've got my code finished but I need a working exe file but I cant find where it is. The only files I have are the source codes and a sql server compact edition database file whatever that is, which I cant open. Anyone know where I can get … |
| | Hello again guys, I am little bit stuck in this situation and searched everywhere in google but i did'nt find what actually i want.. a problem with autonumber in access database. i have created a database with 4 columns .. deleted primary key slip, cname, nic... the slip column is … |
| | hey i am trying to connect database table with my form in C# Here is my code.... [code] private void btn_quiz_Click(object sender, EventArgs e) { String constr = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\\Documents and Settings\\Zohaib\\My Documents\\Visual Studio 2010\\Projects\\CheckAbility\\Qusetions.accdb"; OleDbConnection conn = new OleDbConnection(constr); conn.Open(); OleDbCommand command = new OleDbCommand("SELECT * FROM Table1", …  |
| | Hi! I have a DataBase and a query (SQL on C#). My table is about airways. So program should find one or some flights with searching them by FLIGHT NUMBER. I have DataGridView with this table. So what should I do with query and DB to get a table (DataGridView) …  |
| | Hello, I am trying this.. [code] Imports System.Data.OleDb Public Class Form1 Dim conn As OleDbConnection Dim cmd As OleDbCommand Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click conn = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0; Data Source=c:\nikhil.mdb") conn.Open() Dim row As DataRowView=ComboBox1.SelectedValue Dim row1 As DataRowView = ComboBox2.SelectedValue Dim row2 …  |
| | Hey, my name is alexandra and i'm actually in a computer programming class right now and my final is coming up. unfortunately, i have barely slid by all year long and haven't really learned much. Our final is coming up and i am in desperate need to pass it :'(. …  |
| | Hey, Basically I have a text box to search data from my SQL DB from, and I want the information to then display in a listview underneath. I have been trying for a while now and still can't get it to work, but on the button click it should display … |
| | Hey so I'm having some problems with vb.net 2008. I need to create a search form where a combobox populates with names then the user clicks a name and the textboxes in the form are filled with the correct data for example txt_Firstname txt_last txt__nameage would all be filled with … |
| | Okay, I created an application that used SQL. It works perfect on the computer that I compiled it on, but, when I release the application it shows an error like: "Cannot open this application, missing components" ... Also, on the computer I compiled it on, it shows the database file … |
| | Can anyone direct me to a free (& good) advertising script that I can use for my community? One that does banner ads, postage stamps, buttons and text links. It'd be even better if it's open source & PHP! Thanks in advance! |
| | how to select a date from calender check that date from database; display those only those data which selected date consist using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.Sql; using System.Data.SqlClient; using System.Configuration; namespace manage_logs { public partial class Time : System.Web.UI.Page … |
| | Hi Can you please let me know if I execute several sql query with one open connection? For example if I have a code like following: [CODE] using System; using System.Data; using Oracle.DataAccess.Client; class OracleCommandSample { static void Main() { string constr = "User Id=scott;Password=tiger;Data Source=oracle"; OracleConnection con = new … |
| | I have been trying for about 6 hours to get this program to work. It's a C++ program for for loops. I am trying to go through a book, but I don't have source code for how this should be. I need to make a program that looks like this … |
| | i have a logs table which have the following fields like username , id , checkintime, checkOuttime and date so i want to select a start date and end date from the calender and then click submit button so it can search data from data base and display data start … |
| | This is my code to save values in MS access...but when i click on save it shows "INSERT INTO STATEMENT error" Plz som1 help!!!! [CODE]Private Sub save_Click() 'Text4.Text = cmbCustID.Text 'Text3.Text = cmbLocation1.Text 'Text5.Text = cboSize1.Text Dim temp As Integer 'On Error GoTo eror blnerror = False myValidation If blnerror …  |
| | [CODE] namespace Test1 { public partial class Form1 : Form { string emp_code = ""; public Form1() { InitializeComponent(); } private void Uploadbutton_Click(object sender, EventArgs e) { openFileDialog1.ShowDialog(); filenametextBox.Text = openFileDialog1.FileName; }//Uploadbutton_Click private void save_to_DBbutton_Click(object sender, EventArgs e) { SqlTransaction transaction = null; string servername = ""; string dbname = … |
| | Help! i cannot access my ms access database i am using to learn web design. I keep getting different error codes depending on the windows webhosting used. The latest i got was : Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]General error Unable to open … |
| | [COLOR="Green"]exception occur i my code is: Violation of PRIMARY KEY constraint 'PK__lib_book__1ADC427003317E3D'. Cannot insert duplicate key in object 'dbo.lib_book_details'. The statement has been terminated. [/COLOR] [CODE]SqlConnection cs = new SqlConnection("Data Source=IRIS-CSG-174;Initial Catalog=library_system;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter(); da.UpdateCommand = new SqlCommand("Update Lib_book_details set book_tag_id=@book_tag_id,book_name=@book_name,book_author_name=@book_author_name where book_category_id=@book_category_id", cs); da.UpdateCommand.Parameters.Add("@book_tag_id", SqlDbType.Int).Value …  |
| | This is a part the extension module im writing for python using c++. ( The complete source is available as an attachment ) [CODE] #include <python2.6/Python.h> #include <iostream> #include <fstream> #include "structmember.h" using namespace std; typedef struct { PyObject_HEAD fstream file; } CppFileObject; static int CppFile_init( CppFileObject *self, PyObject *args … |
| | hi, i'm using crystal report and my question is how to create a crystal report which displays fields from 2 tables. i tried this code but nothing displays in the report [CODE] SqlCeConnection con = new SqlCeConnection(); con.ConnectionString = @" Data source= |DataDirectory|\Database1.sdf"; con.Open(); Database1DataSet ds = new Database1DataSet(); SqlCeParameter … |
 | Hi, I've posted two scripts that I would like to improve. The first one (SparePartsDemo.py) is a little utility that takes a .csv (.txt) data file exported from another application, builds a SQLite database,performs a request to select and sort records and write the results to a sqlite database file, … |
| | I feel guilty about posting again but I need help again and I have tried other sources of help e.g google and asking someone who is familiar with vb.net but still can't find the solution to it. It must be another simple fix but I cant find any reference to … |
| | [CODE] Private Sub AddIngoing_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load loadprodin() End Sub Private Sub loadprodin() Dim i As Integer objCon = New SqlConnection(conStr) Try objCon.Open() obj = objCon.CreateCommand() str = "Select * from product ORDER BY p_code" obj.CommandText = str sda.SelectCommand = obj sda.Fill(ds, "product") dt … |
| | Hi all, First, apology if we created duplicate thread. we try to find relevant topic but no luck to find match and sorry we newbie with ireport but have basic with java. Here is my case. We manage to read ireport generated from jsp file with below code. The report … |
| | i use ms access as database and i dont know why my code not working.. here some of code [CODE]Private Sub btnSimpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSimpan.Click Dim conAccess As OleDb.OleDbConnection conAccess = New OleDb.OleDbConnection conAccess.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" & Application.StartupPath & "\kptm.mdb" conAccess.Open() If txtNamaP.Text …  |
| | Hello, I'm new to c++ and i'm making program to read from numbers from file and calculate average. The numbers in file is like this [CODE]10; 15; 200[/CODE] and my source so far [CODE] #include <iostream> #include <fstream> #include <string> using namespace std; int main () { string line; ifstream … |
| | [COLOR="Red"]Book_Return_form Book_tag_id=textbox1 Member_id=textbox2 Book_return_on=textbox3 Book_due_date=textbox4 Fine=textbox5[/COLOR] In this form when I put book-tag_id the rest items come automatically a/c to database and I hv done all till textbox4(book_due_date). Now problem is with fine(textbox5) Fine is calculated acc to membership_type,there are three types of membership silver,gold,platinum Fines are:silver=30,gold=20,platinum=30 so the calculated … |
| | [B]Book_Return_form[/B] [COLOR="Red"]Book_tag_id=textbox1 Member_id=textbox2 Book_return_on=textbox3 Book_due_date=textbox4 Fine=textbox5[/COLOR] [COLOR="Green"][B]In this form when I put book-tag_id the rest items come automatically a/c to database and I hv done all till textbox4(book_due_date). Now problem is with fine(textbox5) Fine is calculated acc to membership_type,there are three types of membership silver,gold,platinum Fines are:silver=30,gold=20,platinum=30 so the calculated … |
| | Hi..I have a table named tblTask and another one named tblDaily_Task_Schedule. the relationshipis such that a task can have many daily_tasks. the primary key of tblTask is Task and the primary key of tblDaily_Task_Schedule is Daily_Task and its foreign key is Task (from tblTask). Each subtask in the tblDaily_Task_Schedule has … |
| | Hej Guys, I am not a phyton programmer, just on [url]www.luxrender.net[/url] (open source project) we have this annoying problem when we need to dl something the phyton mercury doesnt pass the file size to browser... Can somebody take a helpful look at it? I am sure its just something worng … |
| | Dear Helpful Members of Daniweb, I have been working on several projects to automate work in the company I am working for and have come to the following problem: I have a VBA6 program I have successfully programmed to calculate the costs of our fasteners and anchors, now it is … |
| | [B] m trying to make dll class but in m facing errors in it plzzz help me to resolve the...i really need help!!! my full code is:-[/B] [CODE]namespace selectfinedetails { public class TransactionService { SqlConnection cs; private void OpenConnection() { cs = new SqlConnection(); cs.ConnectionString = "Data Source=IRIS-CSG-174;Initial Catalog=library_system;Integrated Security=True"; … |
| | Hi all, I'm not the best with coding and was wondering if some one can help me out. The page is inserting information into a database but when i added an extra section to insert i get the error [CODE] Could not find stored procedure 'Insert_PublicationsA'. Description: An unhandled exception … |
 | i hav created an application using odbc as data source. the connection to the database uses the following code: dim myconnection as new odbc.odbcConnection("server=192.168.100.84";dsn=cleaners) myconnection.open .. .. the above code does well when i change the ip address to 127.0.0.1 i.e to localhost.but when i use it on a computer …  |
| | [CODE]Option Explicit Private con As New ADODB.Connection Public RS As New ADODB.Recordset Public RS1 As New ADODB.Recordset Public cmd As String Dim ExlObj As New Excel.Application Private Declare Function GetSystemMetrics Lib "user32" (ByVal Index As Long) As Long 'Public Declare Function SetCursorPos Lib "user32" (ByVal X As Long, ByVal Y … |
| | When i click button an I always get an Error that[COLOR="Red"]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes … |
| | Hi, I'm doing the following code to connect to Access Db. The db1.mdb is placed in c:\db1.mdb. It giving me error "couldn't find file" [CODE]using System; using System.Collections.Generic; using System.Linq; using System.Text; using System; using System.Data.OleDb; namespace CustomerDB { class OleDbTest{ public static void Main() { //create the database connection … |
| | I have a program which which enables staff to sign in to the application by checking their username and password in the database, to verify their log in. I have added a field job description in the staff table, and would like to disable buttons on the main menu depending … |
| | Hey! So i just started reading through some Database tuts, because i needed it for a project that i am making. I am using the HomeandLearn tutorial. So i have a database called "AdressBook" and then this code. [CODE]Public Class Form1 Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As … |
| | 2 Days Ago different datatable update i have a big problem yet ihave to present this project on monday my database which i have to present next week. i have tried to play with the codes but still it has failed to retrive and update data. i need a code … |
| | As i click update button data is updated but all the data in the table get with it....(same data in whole table) suggest me what i doing WRONG in it.... [CODE] private void btnUpdate_Click(object sender, EventArgs e) { SqlConnection cs = new SqlConnection("Data Source=IRIS-CSG-174;Initial Catalog=library_system;Integrated Security=True"); SqlDataAdapter da = new … |
| | i want due date comes automatically as by adding after 15 days from date of issue................. [code] private void btnIssueBk_Click(object sender, EventArgs e) { SqlConnection cs = new SqlConnection("Data Source=IRIS-CSG-174;Initial Catalog=library_system;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter(); cs.Open(); da.InsertCommand = new SqlCommand("Insert into Lib_issue_details Values(@book_tag_id,@member_id,@book_issue_on,@book_due_date)", cs); da.InsertCommand.Parameters.Add("@book_tag_id", SqlDbType.VarChar).Value = textBox2.Text; … |
| | Ok so I'm transferring a website for my mom and i got an error in the main page's coding, but I can't figure it out. It said it was in line 3. [CODE] <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-gb" lang="en-gb" > <head> <meta http-equiv="content-type" content="text/html; …  |
| | Hi, i have convert my code from sql to mdb but there is problem when it comes to place i highlight in red it doesn't execute the command reader....it end the application when it reaches [COLOR="Red"]Do While dr.Read[/COLOR]can any1 tel me whats the wrong with my code.....i'm totally blank ! … |
| | Hi Guys, I am trying to make a connection with Oracle 11g which is installed on a server 2008 BUT have problems with the ConnectionString. Could you please let me know how I set a correct connection String while I have parameters like these: Database name: GISData Server Name : … |
| | I have problem with printing Crystalreports from Dataset as a source. I have a Dataset fullfilled with data from query and CrystalRaports doesn't show any data from dataset on the report. Do you haeve any ideas what is the problem. My Code: [CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; … |
The End.