C# :: Using SQLTransaction When Reading Database?
Jul 30, 2012Is it useful to use SqlTransaction and transaction.commit() or rollback when only reading from a database? Have some code here that does that
View 1 Replies
ADVERTISEMENT
C# :: How To Add More Than One Database In A Program
Mar 5, 2014Is it possible to add more than one database in a C# program if so, how?
View 7 Replies View RelatedC++ :: How To Create A Database
Feb 28, 2013I'm trying to make a database that stores the information without overwrite it. I want this program to store the client’s selection in somewhere that doesn't change and also that creates a new storage for the new value any time the client enters a new selection instead of overwriting it. I did something like that in my code but any time the program runs again and the client enters a new selection, the client’s selection is overwritten with the new value. I don’t know if it’s possible to do that (store the client’s selection in somewhere where doesn't change) with C++. I've been reading and I think I can create a database for my program.
THIS IS MY CODE:
#include <iostream>
#include <string>
using namespace std;
// FUNCTIONS
[Code]...
C# :: SQL Database Not Saving?
Oct 5, 2014My program add something in a data base, but after program is closed all data is removed.
conturiSQLDataSet.LoginsRow newUserRow = conturiSQLDataSet.Logins.NewLoginsRow();
...
conturiSQLDataSet.Logins.Rows.Add(newUserRow);
There is a method that program can save all data?
C/C++ :: How To Use Database In Programs
Oct 18, 2014I am trying to experiment with programs and databases. Right now I am trying to set up a database so that my program, which currently just appends its results onto a text file, will instead store each result into a database, because this will make things much easier to access than trying to read specific results from an ever-larger, disorganized text file.
View 2 Replies View RelatedC :: Sorting Structures In Database
Nov 26, 2013A user is supposed to enter student name, id, and grade then sort them by name, id, or grade. I managed to get it to sort by name and id correctly, but not by grade.
Code] .....
#include <string.h>
#include <stdio.h>
struct student{
int student_id;
char name[30];
char grade[15];
[Code] ....
C++ :: Functions Searching A Database
Aug 8, 2013I am trying to write a program to search a library file with the name of a book or author and return the books that match the searched string in some way. For instance, if I search "Develop" it should display Game Development Essentials(Novak) and Developing Games in Java(Brackeen) and tell me that 2 records were found. Currently, it shows all the records regardless of what i search for, even if it is jibberish. Am I missing something in my functions? should I include the code that accesses these functions?
//If the user chooses A or a
int showBooksByAuthor (int count, string name)
{
char choice;
int index = 0;
}
[code]....
C++ :: How To Connect To MySQL Database
Mar 26, 2013I have so far tried MySQL++, ODBC, SimpleDB, and the MySQL C++ Connector. All of them give me a FLOOD of errors in the output. Is there an easy way to connect?
View 7 Replies View RelatedC++ :: Connecting To Database Using Drivers
Apr 8, 2013How to connect my c++ code to any database using drivers.
View 2 Replies View RelatedC++ :: Read Images From Database
May 3, 2013I have a database of images and I want to store paths of all those images to a text file (lets say "images.txt"). I can then use this text file in c++ to extract images one by one by using getline() in a loop.
I don't know how to store image paths to a text file.
C# :: Save Web Page To Database
Apr 10, 2014What is the best way to save a c# web page to database, either sql or oledb both fine. What I am looking to do is save all the data that has been entered into a database then upload this data to a grid view or form view.
The problem is there is a a lot of data on the page. Such as drop down lists, check boxes panels text boxes. I am able to display the text boxes in the database when i enter information into them. this is not working for the other objects. Also there is fixed data in the panels which doesn't require user input but I still want this info saved as it is vital.
In short I want to save the data from a page ive created called DOCare.aspx into a database. then take the data and display it in Forms.aspx a different page, where it will list all the completed forms for the user to modify if needed.
How to do this or links to websites that have information on this?? Dont know if i am wording it wrong but just cant find a way to do this. Everyone ive seen is working with small amounts of data and only text boxes.
C/C++ :: How To Interface Database With ATM Project
Jun 5, 2014I had a project to create an ATM with a database of 100 customers, i wasn't able to interface the real program with the database. I have submitted the project already. Here is the database and the ATM program
#include <stdio.h>
int main(void) {
int account, pin;
[Code]....
C# :: Add / Save Data In Database
Apr 8, 2015I had assign to do a project using c# window form.Now I am doing a smart part of coding which is let the data in textbox and using keypress function with a enter,the data will save in database and show on datagridview.I had searching how to do it online but all of them using mysql or sqlcommand something to do it! But my project is using the code that already done and can access without mysql or sql coding... Using this code to connect and show in datagridview...
using (TMPB_attn_DAL dalObj = new TMPB_attn_DAL())
{
dataGridView1.DataSource = dalObj.GetRecords().Cast<TMPB_attn>().ToList();
dataGridView1.Refresh();
}
This is the function code for me to add data inside database,it can run but just still cant save.
private void txt_proximity_KeyPress(object sender, KeyPressEventArgs e) {
if (e.KeyChar == (char)13) {
if (BusinessLogicLayer.TMS_GET_PROXIMITY_VALID_TO_USE(txt_proximity.Text) == true) {
TMPB_attn row_tmpb_attn = new TMPB_attn();
[code] ....
C# :: Unable To Update MSI Database Using MST
Sep 1, 2014Am trying to update the MSI database via a transforms (MST) file. using below code.
WindowsInstaller.Installer inst = (WindowsInstaller.Installer)new Installer();
Database instDb = inst.OpenDatabase(MSIFile.FullName, WindowsInstaller.MsiOpenDatabaseMode.msiOpenDatabaseModeReadOnly);
instDb.ApplyTransform(MSTpath, MsiTransformError.msiTransformErrorViewTransform);
WindowsInstaller.View view1 = instDb.OpenView("INSERT INTO `Registry`(`Registry`,`Root`,`Key`,`Name`,`Value`,`Component_`) VALUES('" + Registry1 + "', '" + Root + "', '" + Key + "', '" + Name1 + "', '" + Value1 + "', '" + Component + "')");
view1.Execute(null);
view1.Close();
instDb.Commit();
When i try for MSI database before including instDb.ApplyTransform(MSTpath, MsiTransformError.msiTransformErrorViewTransform);
it worked fine for MSI, the values got updated in the MSI database, But i face error in the above line of code.
C# :: Using DateTime Field From SQL Database
Oct 30, 2014I have a DateTime field on a database it looks like this :
2014-10-21 14:34:37.697
I want to use it, as is, in an UPDATE statement something like:
UPDATE PayrollRuns SET IsProcessed = 'True' WHERE Date_Time_Triggered = '2014-10-21 14:34:37.697'
I must have the exact date & time as that uniquely identifies the record.
The problem I'm having is getting it off the database and into an C# variable without it being changed.
I can get it into a string but it changes it becomes:
21/10/2014 14:34:37
I've got it in an object. I've tried:
string date_Time_Triggered = databasesRow["Date_Time_Triggered"].ToString();
//
//and
//
var date_Time_Triggered = databasesRow["Date_Time_Triggered"];
[Code] ....
C# :: Changing Database Values?
Dec 14, 2014I'm working on a project where we access a tiny premade database in order to log into and access another page. I got the log in part working right, but the last part of the project asks me to lock out the account after a certain number of failed attempts. I'm not sure if I need a method to do this or if I can do it right there in the button handler. I tried creating a method to use on the object that was already there, but I'm not sure if that's the right way to go about it. It says it locks the account, but the value in the database never changes, and I don't know why.
//from the login button handler
protected void btnLogin_Click(object sender, EventArgs e) {
bool IsFound = false;
clsDataLayer dl = new clsDataLayer();
IsFound = dl.GetUser(Server.MapPath("~/AddressBook.mdb"), txtUserID.Text, txtPassword.Text);
if (IsFound) {
Response.Redirect("~/frmUpdateAddress.aspx");
[code]....
C/C++ :: SQLite Database To JavaScript
Mar 31, 2015I am trying to figure out how can I get my SQlite database made in C language to Javascript? I know this is possible but do not know where to start?
View 5 Replies View RelatedC/C++ :: How To Connect With Oracle Database
Sep 24, 2012library management system in which c is used as front end and oracle is used as back end in order to retrieve the data. if possible can u send the source code for it.
View 1 Replies View RelatedC++ :: Use Vector Or List For Database System
Jul 28, 2014I am making a console based database system. Because I have to keep inserting, editing , deleting data blocks from my record file I have decided to use either vectors or list to store the all records. From the file I shall read the entire vector/list and work with it to add , remove or edit record and then again write the entire vector/list to the file again. I figured it would stop all the weird things that happen when directly working with the file. Is it an efficient way ?Or is it totally unnecessary ?Is there a better way?
View 2 Replies View RelatedC :: How To Import TXT File Into SQLite3 Database Using API
May 6, 2013Any tutorial to learn?
View 8 Replies View RelatedC :: Book Database - File Output
Feb 7, 2013Book database. I use scanf to store book name,author name and year when is book written. Example:
Code:
scanf(" %[^
]",k[i].bookname);
I have problem when i want to printf all books from database with this:
Code:
for(i=0;i<counter;i++){
fscanf(f,"%s %s %d",k[i].bookname,k[i].author,&k[i].year);
printf("
%d %s %s %d",(i+1),k[i].bookname,k[i].author,k[i].year);} Output:
Number Book name Author name Year
1 King John 0
2 William Shakespeare 1590
How can i fix this?
C :: Linking Data Elements Within A Database
Nov 24, 2013I am writing a contact book program in C that will run in the terminal. I am going to create a file to store the data separately, but have run into a few question areas:
1) It has occurred to me that it might be more efficient to setup the program so that it sorts the contact info by info type rather than by running through an index of the contacts and then linking all of that contact's information to that index. So basically one part of the file would be phone numbers, the other contact names, and so forth with each piece of data linked to another piece within the data file that corresponds to the same contact. Am I wrong to think this is a more efficient way to set up the file?
2)How would you link the data information to other pieces of data corresponding to the same contact in C? My thought is to do it with pointers, but I didn't know if it were possible to have the pointers as I didn't know if the pointer would point "persistently" to the data once the file closed.As I felt this is a more "in general" question, I have chosen to omit my code from this post (especially since there is not much "meat" in it to speak of).
C :: Using Insertion Sort For Sorting Database By Age
Apr 29, 2014I am trying to sort a student database by age,but i am not sure whats wrong i think it has to deal with tmpstudent variable.
Code:
void insertion_sort(StudentDB *db) {
int i;
for (i = 0; i < db->num; ++i) {
int j = i - 1;
int val = db->records[i].age;
[Code] .....
C++ :: Program To Maintain Database - Name And Birthday
Oct 16, 2014Write a program that maintains a database containing data, such as name and birthday, about your friends and relatives. You should be able to enter, remove, modify, or search this data. Initially, you can assume that the names are unique. The program should be able to save the data in a fi le for use later.
Design a class to represent the database and another class to represent the people. Use a binary search tree of people as a data member of the database class. You can enhance this problem by adding an operation that lists everyone who satisfies a given criterion.
For example, you could list people born in a given month. You should also be able to list everyone in the database.
C++ :: Create And Amend Database Using SQL Server?
Nov 1, 2014I'm trying to find a way to create and amend a database using the SQL server. How to do this. I just know it's included with the VS Express package.
View 1 Replies View RelatedC++ :: Linked List Of Student Database
Mar 6, 2013I've remade a program to store student database using linked list. When I try to display the list of student with their information (It displays nothing)
Code:
#include <iostream>
#include <string>
using namespace std;
struct StudentRecord {
[Code] ....
