|
thaks man all working
Athlon 64 3500+, Gigabyte GA-K8NXP-9, 2x512 DDR400 Kingston, Inno3d 6200 PCIe, SS2 B2C2 v2.6, HDD := 450gb, Genius 56k int, NEC DVD-RW и мать его Суньмастер 550.
|
|
|
|
|
My pleasure. Happy coding!
"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty
|
|
|
|
|
I have tried finding my answer here and MSDN and am either searching for the wrong critieria or the answer is right in front of me. I am rather new to ADO.net and believe my problem relates to being completely comfortable with with ADO 1.5. I prefer runtime data access over design time controls.
I am trying to do a simple add record to an Access 2000 database that has four fields. The ID field which is autonumber, the FirstName field, LastName field and a Deleted field which is Yes\No (default = 0). When I try the INSERT command I get an error about the insert command being invalid. Here is a code snippet from my code.
String sDBConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data" +
"Source=D:\\source\\C# Proj\\Test\\AppData.mdb;" +
"Mode=ReadWrite|Share Deny None;Jet OLEDB:Engine " +
"Type=5;Jet OLEDB:Database Locking Mode=1;";
OleDbConnection dbAddConn = new OleDbConnection(sDBConnect);
String sQuery = "INSERT INTO Contact (FirstName,LastName,Delete)
VALUES (\"Papa\",\"Bear\",0)";
OleDbCommand dbCmd = new OleDbCommand(sQuery, dbAddConn);;
dbAddConn.Open();
try
{
dbCmd.ExecuteNonQuery();
}
catch(Exception e)
{
MessageBox.Show(e.ToString(),"Data Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
dbAddConn.Close();
Error happens and ExecuteNonQuery(). Also, what is the easiest way to get the added id number. If there is an easier way to achieve what I am doing, I'd love to here it. Currently I like the old ADO 1.5, I had no problems with it.
Thanks for your assistance.
Leo T. Smith
|
|
|
|
|
Use apostrophes instead of quotes around the strings in the query.
Delete is a reserved word. Rename the field, or if that is not possible, put brackets [] around the name in the query.
---
b { font-weight: normal; }
|
|
|
|
|
hi guys,
need help with this one.. im building a license monitoring application. and part of the system is the module in which the program kills/blocks a certain application from running based on the returned info from the database (license information). so if the company has 5 licenses for a specific app, then 5 should be the max number of concurrent usage, though it can be installed on more than 5 pcs.
so my question is, is it possible for my app to be embedded in the OS, so that i can control the applications being ran based on my license server.. or is there any other way to do it..
i need comments/suggestions/any wild ideas guys.. thnx in advance...
|
|
|
|
|
I think Sony has a nice little rootkit that does this.....
But seriously, if the application is a .NET app, you could make a license provider dll that would talk to the database and determine if it could launch or not. If the main app is a Win32 one, ou could write a small wrapper exe to do the checking that then runs the normal app. One thing to think about when ou are building this type of system is the need for an admin to be able to add a license quickly. Sometimes purchasing a license or a block of licenses could be a slightly slower process. If you had a good way to allow another copy to run (and keep track of that) then users will not feel trapped by their own purchasing dept.
Steve Maier, MCSD MCAD
|
|
|
|
|
thanks for the reply Steve..
yes my application is a c# .net application. what i have now are codes for viewing all the running processes and killing a running process. im new in network programming, i also havnt explored much of the .net class library that's why im having difficulties in trying to implement this.
can i ask you some questions? what is that license provider dll? and what about that wrapper exe? can i put that in my client pcs and embed it in the OS? so that when the client PCs boot, it already has that client application agent running, thus enabling the communication between my server and its clients. And from the server, i can get info about that specific client.tnx
|
|
|
|
|
Sounds like a VERY convoluted solution to a licensing issue.
Why couldn't you just create a license server on a machine and have the client software just ask for and checkout a license? When the client is done, the license is checked back in to the database. The licenses would have to be checked out on a leased basis so you don't end up with permanently checked licenses. The clients would have to renew their lease every so often in order to keep working.
Forget trying to "kill process" and all that crap. It's an unsupportable solution...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I agree with Dave that it sounds too complicated. .NET applications can have a licence provider defined for them. There are a few licensing systems out there that are just for .NET. I was looking at a free one called OpenLicense[^]. The .NET classes allow ou to define our own licensing scheme and if ou wanted it to check a server, it could.
Steve Maier, MCSD MCAD
|
|
|
|
|
I am working on a windows app. I need to create a database during installation but more importantly, I need to know how my application would work on a computer that does not have SQL Server installed . Since it is a stand alone app I am assuming that 99% end-users will not have SQL Server on their computers. Can I create a database if just the SQL Driver is available on client PC? or any other better suggestions?
A code example will really be helpful. Thanks.
|
|
|
|
|
I have worked at places that do this in a couple different ways. You could copy the database files over to the machine and then attach a new database in SQL Server using a sql command. Or you could just generate the sql for the entire database and have that run on installation. In either case you will have to make sure that SQL Server is installed on the target machine. You can put the MSDE installer inside your installer and even SP3 for it too. SQL Srver is not like Access, you need to have the server running on the machine to get at it. For one product of mine, I switched to SQLite because that is accessed just as a file. I get most of the same features that I need and not much overhead.
Steve Maier, MCSD MCAD
|
|
|
|
|
hi friends
My PC(win 2000 pro) has the .Net Framework 1.1 , but not the SDK
and i can not find the GACUTIL.exe
How i can register in the GAC my asemblies ??????
|
|
|
|
|
For most assemblies, you can just drag and drop them into the %windir%\assembly directory through the Explorer shell.
"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty
|
|
|
|
|
Thanks friend
...
that assembly will be a Serviced Component (com+) .... is it ok??????
|
|
|
|
|
Yes and no. It will register the assembly portion, but you still need to register the COM portion. Try looking around your computer for .NET Services Installation Tool (Regsvcs.exe)[^]
"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty
|
|
|
|
|
Is there an easy way to find the bounding rectangle of a TreeNode in a TreeView?
<br />
TreeView treeView;<br />
TreeNode treeNode;<br />
<br />
Rect rect = treeView.GetRectOfNode(someNode);<br />
<br />
Point point = PointInRect(rect);<br />
TreeNode sameNode = treeView.GetNodeAt(point);<br />
<br />
Assert.True(ReferenceEquals(treeNode, sameNode));<br />
Thanks, Amir
|
|
|
|
|
Of course, this is also nice, and perhaps better. If there is no bounding rectangle (because the node is not visible) {-1,-1} is a reasonable reply.
<br />
TreeView treeView;<br />
TreeNode treeNode;<br />
<br />
Rect rect = treeNode.BoundingRect; <br />
<br />
Point point = PointInRect(rect);<br />
TreeNode sameNode = treeView.GetNodeAt(point);<br />
<br />
Assert.True(ReferenceEquals(treeNode, sameNode));<br />
|
|
|
|
|
|
|
I am developing an application using C#, .NET framework 2.0. This is combination of two web services and one desktop executable. Web services are running on Windows Authentication.
I need to send user credentials from UI application (desktop application) to Web service two. Web service two is not directly accessible to UI, it is only accessible through web service 1.
How can I send user credentials to web service 2 through web service 1.
Right now, web service two is not getting authentication, it throws error, 401 – Unauthorized access.
Appreciate your help.
Thanks and regards,
Ashish Basran
|
|
|
|
|
Hi!
I have problems importing Outlook Contacts to a specific folder. This is what my code looks like:
<br />
Outlook.Application objOutlook = new Outlook.ApplicationClass();<br />
NameSpace outlookNS = objOutlook.GetNamespace("MAPI");<br />
MAPIFolder contactFolder = outlookNS.GetDefaultFolder(OlDefaultFolders.olPublicFoldersAllPublicFolders);<br />
<br />
<br />
Outlook.ContactItem objContact =<br />
(Outlook.ContactItem)objOutlook.CreateItem(Outlook.OlItemType.olContactItem); <br />
<br />
objContact.CompanyName = contact.CompanyName;<br />
objContact.SaveAs("testmapp", OlDefaultFolders.olPublicFoldersAllPublicFolders);<br />
What I want to do is to impor contacts to a contactlist under "public folders -> all public folders -> testmapp" in Microsoft Outlook. When i'm running this I get an "invalid arguments"-exception at the last row.
Any ideas how to do this differently?
|
|
|
|
|
Hi.
I have a problem with the danish characters æøå, when i exstract them from my database and put them into a gridview (with the database as datasource) then the characters is fine.
but if i take the result from the gridview and put it into another gridview with a textbox in its footer, then it's all weird.
this is the code that makes trouble:
TextBox txtFood = GridView1.FooterRow.FindControl("txtFood") as TextBox;
txtFood.Text = GridView2.SelectedRow.Cells[0].Text;
if i print GridView2.SelectedRow.Cells[0].Text as this:
Response.Write(GridView2.SelectedRow.Cells[0].Text);
it returns the correct characters (æøå)
so does the textbox if i print it out like this:
TextBox txtFood = GridView1.FooterRow.FindControl("txtFood") as TextBox;
txtFood.Text = GridView2.SelectedRow.Cells[0].Text;
Respomse.Write(txtFood.Text);
So how can it be weird characters like æ ? is it the ASCII code or something? how do i view the æøå correct in the textbox on my webpage ?
|
|
|
|
|
it is all about that textbox viewState data. your controls doesnot take proper encodings to store viewstate data , agressively inspect properties of them and use a html textbox control
Mikail Çetinkaya . The C# DEveloper
|
|
|
|
|
so how do i change the controls so that it can store the viewstate data correctly ?
I code ASP.net and C# in a website, i dont know how to send the data from a gridview to a normal html textbox control.
|
|
|
|
|
try onload manually declaring encoding like Response.encoding="XXXXX"
Mikail Çetinkaya . The C# DEveloper
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
