|
Hi,
I am a novice in Database programming. I have Open Office database Base installed on my system.
I want to know how to connect/retrieve/update data with this database.
Appreciate any samples/help.
Thanks in advance
D
-- modified at 0:16 Tuesday 25th September, 2007
|
|
|
|
|
Not sure, but this google search on openoffice and c#[^] might be worth looking at.
"Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus
|
|
|
|
|
 i am working on a application using c# and sqlserver
how can i deploy my app so that the sqlserver and database and .net
automatically install on client computer and client does not get any access
on data base
shuaib
|
|
|
|
|
u need to install .net and sql separately..
otherwise the size of your package wiil bhi more than 1GB
and attach your db with sql server through scripts that will run while installing the application
|
|
|
|
|
how can i attach my db with sql server through scripts that will run while installing the application
please give me detailed steps or coding
|
|
|
|
|
hi,
i am new in crystal report
can any body tell me how can i dynamically give value to crystal report text object
monu_khan
|
|
|
|
|
private void button1_Click(object sender, System.EventArgs e)
{
System.Data.OleDb.OleDbDataReader myReader;
string CustomerString;
oleDbConnection1.Open();
myReader=oleDbCommand1.ExecuteReader();//"I get the error here "System.InvalidOperationException:No data exists for the row/column"
//But I just rechecked the data inside the Access database file and data is there.
try
{
//Retrieves the first and last names from Customers and
//concatenates them into a single string
CustomerString=myReader[1].ToString() + " " +
myReader[2].ToString();
//adds the string to the ListBox
listBox1.Items.Add(CustomerString);
}
catch(Exception e1)
{
MessageBox.Show(e1.ToString());
}
myReader.Close();
oleDbConnection1.Close();
}
|
|
|
|
|
T4AMD wrote: But I just rechecked the data inside the Access database file and data is there.
What data ? I mean, where is the code that defines a command to send to your database ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source="F:\Windows\Chapter6Solution\Chapter6Project\The Doughnut Shop.mdb";Mode=Share Deny None;Jet OLEDB:Engine Type=5;Provider="Microsoft.Jet.OLEDB.4.0";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1
This is my code. This project is in .NET Framework 1.1 so this connectionstring is in the Properties retrieving data from Access Database
|
|
|
|
|
That's a connection string repeated over and over. I still don't see any SQL.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I don't see a query string in oleDbCommand1. That might be your problem... Or is the query in the Properties somewheres?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
SELECT * FROM Customers...This query for OleDBCommand1 is actually embedded in the properties
|
|
|
|
|
I know this might be silly, but is there data in the table?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
yeah..there is data in the Access Database
|
|
|
|
|
I want to hide the tree in the report viewer
merwa
|
|
|
|
|
go to the properties section of Crystal Report viewer and enable
displaygrouptree to false
|
|
|
|
|
go to property window and set displaygrouptrees to false
|
|
|
|
|
Hello,
Does anyone have the code to make a timer count up on a label? I think it has something to do with 'parse', but I'm not sure...
thanks, now MS
|
|
|
|
|
Hi , Did you mean This ?
public int x;<br />
<br />
private void Form1_Load(object sender, System.EventArgs e)<br />
{<br />
x = 0;<br />
timer1.Enabled = true;<br />
timer1.Interval = 1000;<br />
}<br />
<br />
private void timer1_Tick(object sender, System.EventArgs e)<br />
{<br />
x++;<br />
label1.Text = x.ToString();<br />
}<br />
I know nothing , I know nothing
|
|
|
|
|
Hang on I'll give it a shot... If it's that simple...
|
|
|
|
|
HOW IS IT THAT SIMPLE??? THANKYOU, BUT LORD!! i LOOKED ALL over the freakin web and found hard stuff, and then there's this... I've benn looking a while now, so thankyou so much!
MasterSharp (not REALLY a master...)
|
|
|
|
|
I have network access to machines on the domain via remote desktop connection. I am trying to see if there is a way using C# to write an application that allows me to logon to the machine in such a way that it would allow me to check if a process is in memory.
Essentially I am trying to automate the process of checking to see if an executable that is supposed to be running is in fact running on 20 or so different machines without having to use Remote Desktop to login and physically inspect them.
Can someone point me in the right direction if it is possible?
|
|
|
|
|
You can use the Process.GetProcesses()[^] method. This method will use the same credentials as the user than runs your C# application. This user would need to have permissions to list processes on the remote box. In addition, there's a problem[^] with listing processes on certian windows boxes.
You can impersonate another user in C# as described here[^].
Take care,
Tom
-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com
|
|
|
|
|
That's cool. I didn't know Process.GetProcesses could get the processes of a remote machine. I thought it was limited to where the exe was run from. "The More You Know..."
|
|
|
|
|
Hi there, I'm a new bie to C# still learning about it. Everything that i've read about the SET and GET method, I don't seem to understand and understand the purpose of its use and when to use it in an application. I was wondering if some one could help me. Any sample code that I've downloaded using this method so I can debug through it to hopefully understand dosen't work. I'm using .net framework 2.0. I've got some of the following code below that i've adapted to test it. I have a web form with a button and label on it when you click on the button :
DEFAULT.ASPX
protected void Button1_Click(object sender, EventArgs e)
{
int i;
prop iage = new prop();
iage.age = 5;
Label1.Text = iage.age;
}
PROP.CS
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
///
/// Summary description for properties
///
public class prop
{
public prop()
{
//
// TODO: Add constructor logic here
//
}
private int age = 0
public int age
{
get
{
return age;
}
set
{
age = value;
}
}
Thankyou
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
