|
i want to insert a new row inside my microsoft access database, i do it, but i need it immediately. how?
|
|
|
|
|
Although this is a question to database forum (if there is), I know a little about it so I'll help...
I personally work with database that doesn't stop to work (there are always a few people that can use the database), you should always take that risk! because if some-one inserts a row while you insert a row, you can both edit the same row in the end.
I'll show you the command line for the last inserted row, and then I'm going to show you the better way.
So this is command to get the last row:
Select Top 1 * From tblTable Order By <id-field> DESC
(ofcourse no case-sensetive in here) tblTable = the table
ID-Field = the ID or some other field that increases by time (eg. Date\Time)
Now this is not good because if two people add a row, at the same time, they will, in the end see the same row, the last row inserted, and not their own.
The better way which I prefer is to save the variables from the insert command, and just do a "Where" statement in the select command.
eg: Select * from tblTable Where <field1> = '{0}' And <field2> = '{1}' etc. etc...
Hope I helped... NaNg
|
|
|
|
|
Hi!
Don't know if I understand what you want, but if you need the value of an AutoValue that Access has assigned to a field in your newly-inserted row, you can look for "@@Identity".
Another way could be to create your IDs on your own - use a GUID and you can be sure that it's unique and you have its value before you even insert the row into the database.
Regards,
mav
--
Black holes are the places where god divided by 0...
|
|
|
|
|
Hey all,
I'm getting into WPF development and need advice about what the best tools are for developing in that space. I've tried VS2005 + "Orcas" extensions (namely "Cider") but it's constantly crashing and my simple little test apps crash for unknown reasons. It seems like every time I modify the XAML, the app crashes until I close VS. So, Orcas is on my blacklist. 
XamlPad is really cool, but AFAIK it does not support an associated code-behind for the event handling methods. I want to define behavior as well as layout, but XamlPad doesn't offer that. Please let me know if I'm wrong about this.
So, for those of you who have been developing/playing in WPF (a.k.a. Avalon), what are the best tools that you've found? Please don't tell me that Cider is as good as it currently gets!! 
Thanks,
Josh
|
|
|
|
|
|
Thanks a lot! I'll definitely check that out.
Josh
|
|
|
|
|
Hi
Could someone plz help me?
Im a beginner programmer and I hav gone through the article called "Using Events and Delegates in C#" posted by Graham Harrison on the 21 Oct 2005.
I am havin proplems with coding the Main form or GUI.
I dropped a comboBox on my form and used a string array called invoiceIds with the values{"1","2","3","4"} and populated the comboBox in Form_Load() with these array values.
This is my problem : Now I want a MsgBox to pop up when a different invoiceId is selected from the comboBox. The MsgBox must say what the new invoiceId is and also what the previous invoiceId was.
Its pretty much the same as the article, except the article doesnt explain or show much of the MainForm code.
|
|
|
|
|
You don't have to know much about events to use them.
Select the combobox in the form designer and switch the properties window to show events. Doubleclick in the value field for the event you want to use (probably SelectedIndexChanged in this case), and the form designer will create a method stub for you, and hook it up to the event.
---
b { font-weight: normal; }
|
|
|
|
|
Got it right!
thanks alot for the help
|
|
|
|
|
Hi!
I need HELP!
I tired!
I don't know how to delete folders with 
all subfolders(!!!) and containing files(!!!) on FTP in C#.
I use:
public void Delete()
{
DelFiles(FileList.SelectedItems[0].Tag as FTPfileInfo);
MessageBox.Show("DONE!");
}
void DelFiles(FTPfileInfo directory)
{
ftplib.ChangeDir(directory.FullName);
FTPdirectory dir = ftplib.ListDirectoryDetail();
foreach (FTPfileInfo fi in dir)
{
ftplib.ChangeDir(fi.Path);
if (fi.FileType == FTPfileInfo.DirectoryEntryTypes.File)
{
rm(fi.Filename);
}
else
{
DelFiles(fi);
}
}
}
It's only delete of files.
I need delete all.
Help me please!!!![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
Hello from Ukraine!
|
|
|
|
|
see
ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.NETDEVFX.v20.en/cpref10/html/T_System_Net_WebRequestMethods_Ftp_Members.htm
Hello from Russia
|
|
|
|
|
Where this page?
Please send it to me:
case@me.by
Hello from Ukraine!
|
|
|
|
|
http://msdn2.microsoft.com/en-us/library/system.net.webrequestmethods.ftp_members.aspx
|
|
|
|
|
Here nothing say about recursive folder delete!
Did any can help me?
I am a developer of FileManager ("Hermit").
I will write helper in "About"-"HELPER"
Hello from Ukraine!
|
|
|
|
|
так а что там не понятного? вроде все доступно написано, если в папки есть что-то еще, это чтото еще в аррай по типам папка\файл раскидай, и делить все по очереди. непонятно будет зайди на www.csharp.net.ru все распишут что непонятно.
|
|
|
|
|
|
hmmm... what?
Read this[^]
-- modified at 13:43 Saturday 13th May, 2006
|
|
|
|
|
Hello
I am using .net 2.0 windows application. I am using datagridview. I want to display the data in master and child relation ship. i.e displaying in the form of Expand & Collase mode.
This is straight forward in .NET 1.1 winforms DataGrid.
anybody anysounds
plz help how to do this usng VS 2005.
regards
bhargavi
|
|
|
|
|
|
This is my XML input:
<authentication xmlns="Authentication">
<userid>testUser
<password>password
<mode>2
This is my XML Schema Input:
<xs:schema attributeformdefault="unqualified" elementformdefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:element name="Authentication"> <xs:complextype> <xs:sequence> <xs:element name="UserID" type="xs:string" minoccurs="1"> <xs:element name="Password" type="xs:string" minoccurs="1"> <xs:element name="Mode" type="xs:int" minoccurs="1">
ItsMe
|
|
|
|
|
xmlStream = new FileStream("input.xml", FileMode.Open);
xsdStream = new FileStream("input.xsd", FileMode.Open);
XmlDocument xmlDocument = new XmlDocument();
xmlDocument.Load(xmlStream );
xmlDocument.Schemas.Add(null, XmlReader.Create(xsdStream ));
xmlDocument.Validate(new ValidationEventHandler(this.ValidationHandler));
private void ValidationHandler(object sender, ValidationEventArgs e)
{
}
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook
www.troschuetz.de
|
|
|
|
|
I tried the function but
xmlDocument.Validate(new ValidationEventHandler(this.ValidationHandler));
is not calling the below function.
private void ValidationHandler(object sender, ValidationEventArgs e){// Do something}
Is there anything else to be done to link the eventhandler with the below function
ItsMe
|
|
|
|
|
am i supposed to register the event . if so how to do it
ItsMe
|
|
|
|
|
No, there's nothing more to do. The code works perfectly in my application.
Note that the event handler only gets executed if your xml file is invalid wrt. to the schema.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook
www.troschuetz.de
|
|
|
|
|
Thanks Its working fine
ItsMe
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
