|
Are you using .NET 2.0 ? In 2.0, there's a properties section that handles saving and loading app data for you.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
hi Christian Graus,
Yes,i am using .NET 2.0. Can you please give me an simple example or related information link?
Thanks,;)
cocoonwls
|
|
|
|
|
Your app has a properties section, in this you can add a property name and value. I believe that Application.Properties.PropName is how you access them.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
hi,
I found it1 But i have one more question,what is the different between user scope and application scope.Thanks alot!
|
|
|
|
|
The values get stored in my documents. Use scope means each user has their own config. Application scope means the app has values the same for all users.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Further to this.
If you are using C#, expand Properties in Solution Explorer and open Settings.settings. Add your settings here. Access your settings in-code with:
something = Properties.Settings.Default.MySetting
or
something = Properties.Settings.Default["MySetting"];
if you have edited User settings during runtime and wish to save them, call:
Properties.Settings.Default.Save();
User settings:
*Can be changed and saved during runtime.
*Get stored in ...\Documents and Settings\Application Data\<appname>
Application settings:
*Cannot be edited during runtime.
*Get stored in the application folder.
-- modified at 4:30 Tuesday 23rd January, 2007
|
|
|
|
|
Personally I try to keep all needed data in a serializable object.
Then before closing i serialize the object into a string, and store the string in a registry key.
At Loading Registry Key existance an value validity is checked.If that goes ok, deserialization occurs and everything is fine.
To accomplish that i have created some objects with static functions to use in every application.
|
|
|
|
|
Hi All,
I am working with Windows Forms using C#, i have a treeview populated with nodes, child nodes and further subnodes, I need to create a BACK button using which i need to track back the previous node selections on treeview just similar to BACK button on IE.
I appreciate any kind of help through code sample.
Thank you
|
|
|
|
|
You can try it, when click on back button.........
If Not (TreeView.SelectedNode.PrevVisibleNode Is Nothing) Then
TreeView.SelectedNode = TreeView.SelectedNode.PrevVisibleNode
TreeView.Focus()
End If
It helpful for u...................
Keep Smiling !!!
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
Do something like this:
1) Make sure you are using System.Collections;
2) Declare ArrayList history; in your Form derived class (let it be Form1), and treeView1 your TrieView control;
3) Initialize history in Form1_Load(object sender, EventArgs e):
history = new ArrayList();
4) In the private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) handler, write this piece of code:
TreeNode tn = treeView1.SelectedNode;<br />
if (tn != null) history.Add(tn);
5) In the private void YourGoBackButton_Click(object sender, EventArgs e), write this piece of code:
if (history.Count < 2) return;<br />
treeView1.AfterSelect -= new System.Windows.Forms.TreeViewEventHandler(treeView1_AfterSelect);<br />
TreeNode tn = (TreeNode)history[history.Count - 2];<br />
history.RemoveAt(history.Count - 1);<br />
treeView1.SelectedNode = tn;<br />
while (tn != null)<br />
{<br />
tn.Expand();<br />
tn = tn.Parent;<br />
}<br />
treeView1.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(treeView1_AfterSelect);<br />
treeView1.Focus();<br />
Enjoy!
SkyWalker
|
|
|
|
|
It might be simpler to use Stack<T>:
Stack<TreeNode> history = new Stack<TreeNode>();
bool cancelPush = false;
private void button1_Click(object sender, EventArgs e)
{
if (history.Count > 0)
{
cancelPush = true;
treeView1.SelectedNode = history.Pop();
treeView1.Focus();
}
}
private void treeView1_BeforeSelect(object sender, TreeViewCancelEventArgs e)
{
if (!cancelPush)
{
history.Push(treeView1.SelectedNode);
}
else
{
cancelPush = false;
}
}
|
|
|
|
|
i have got another problem
i have got a insert statement using which i update my database in the local system it is happening good in the local system...
now coming to application which is put on the webserver now my database is not updating properly i am getting an exception.
i am using server.mappath("dls.mdb");
dls.mdb is my databse name and server.mappath is returning exactly the path on the remote system (like d:/mywebsite/dls.mdb).
please solve me and let me knwo
|
|
|
|
|
Define "not updating properly" Do you get an error ? Can you select data from this db ? Is the file read only ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
the exception which i get is
System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Details.btnsubmit_Click(Object sender, EventArgs e)
in the webserver
and the file is not read only
|
|
|
|
|
A great way to solve error issues is to google the error message. I found this:
http://support.microsoft.com/default.aspx/kb/830977[^]
In a nutshell:
This problem occurs when a Microsoft Access database file is used as your database source because you must grant write access to both the default worker process identity and the authenticated user.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
thanks a lot dude
i fighting from yesterday
thanks a lot
bye
|
|
|
|
|
our website is being hosted by some other people sir
and now i have changed write permission and i updated on the webserver
still the same problem is coming
do i need to publish my site once again and update all of them or
only the databasse file has to replaced sir
thanking u bye
|
|
|
|
|
Hi to everyone!
I need to get the autonumeric field assigned to a new record, because I want to use it on a different table.
ExecuteNonQuery retrieves the number of affected rows. But how can I get a dataset result of the affected rows, as the one using an ExecuteQuery command?
Thanks for everyones time!
daniel sovino
|
|
|
|
|
You can ask he database for the last created key. Depending on what database you are using, you use different functions:
MySQL: select last_insert_id()
MS SQL: select scope_identity()
Access: select @@identity
---
Year happy = new Year(2007);
|
|
|
|
|
Question.
If the affected Rows are more than 1 do the above statements return one ID or more?
|
|
|
|
|
It only returns the last id.
---
Year happy = new Year(2007);
|
|
|
|
|
The original question said about rows.
The only way I can think except from triggers is to have a column something like just updated. Then query for those and just before finishing set the columns to false.
|
|
|
|
|
Sarafian wrote: The original question said about rows.
Well, you don't always get what you ask for. 
Sarafian wrote: The only way I can think except from triggers is to have a column something like just updated. Then query for those and just before finishing set the columns to false.
An alternative would be to first get the id:s of the records to update, then use them to update the records.
---
Year happy = new Year(2007);
|
|
|
|
|
Ok, but how do I get this done?
I had lots of troubles working with access database and the dataset wizard to store querys (http://forums.microsoft.com/MSDN/showpost.aspx?postid=1121807&siteid=1), so I opted to run my queries with code.
I used one method with the Insert command, and if the result set is higher than 0, I call another method with a Scalar Command, to search for the ID. Then, with the retrieved ID, i call the third method to Insert the record ID on the second table....
The code described below worked well, everyonce in a while (no clue yet why sometimes i'm able to get the ID and sometimes I get 0, probably something going on with the query). So that's why I want a safer way to get this done.
I searched a little bit for "select @@identity" (http://support.microsoft.com/kb/816112), and I found out that it behaves as a Scalar command as well. So in theory, i should just change my query string to get it done.
It doesnt work at all. Does the "select @@identity" statement work only when you handle it on a OleDbDataAdapter.RowUpdated Event?
Thanks for the help!
<br />
<br />
string file = "......";<br />
<br />
private void InsertAudio()<br />
<pre>
<small>
{
OleDbCommand cmd = new OleDbCommand(sql, conexion);
int resultSet;
try
{
conexion.Open();
resultSet = cmd.ExecuteNonQuery();
if (resultSet > 0) SearchIDofCreatedRow();
}
catch (OleDbException ode)
{
MessageBox.Show(ode.ToString(), "Error de Conexion con base de datos");
}
finally {conexion.Close();}
}
</small>
</pre><br />
<br />
<br />
private void SearchIDofCreatedRow()<br />
<pre>
<small>
{
OleDbCommand cmd = new OleDbCommand("SELECT ID FROM audios WHERE file='" + file + "'", conexion);
try
{
conexion.Open();
int ID = Convert.ToInt32(cmd.ExecuteScalar());
AddCategoryList(ID);
}
}
</small>
</pre><br />
<br />
private void AddCategoryList(int ID)<br />
<pre>
<small>
{
}
</small>
</pre> <br />
<br />
daniel sovino
|
|
|
|
|
The @@identity variable is local to the database session, and if you create another connection you get a new database session. You have to get the id using the same database connection that you used to insert the record.
Why do you create a new connection in SearchIDofCreatedRow? When you call it you already have an open connection, pass that along in the call.
---
Year happy = new Year(2007);
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
