|
The commands were automaticaly generated by Visual Studio 2005 in the moment of insert the DataSet.
--
Adrián Córdoba
|
|
|
|
|
But they're in the original TableAdapter. When you do
DataSetTableAdapters.UsersTableAdapter usersTableAdapter = new DataSetTableAdapters.UsersTableAdapter();
you instantiate a new/uninitialized TableAdapter.
|
|
|
|
|
PIEBALDconsult wrote: You need to set the Commands.
You are right.
Visual Studio 2005 didn't generate the DeleteCommand, seemingly because the Users table in database hasn't a Primary Key.
I added a Primary Key to the table, and when I added this table to the DataSet the DeleteCommand was automaticaly generated.
Thank you very much.
--
Adrián Córdoba
|
|
|
|
|
First off do you have your update command made yet?
I'll I know how to do with DataAdapters is the sql part of them, but if thats what your doing here is an example. It should be kinda the same type of thing.
<cod>
SqlConnection CNN = new SqlConnection("Data Source=(local);Initial Catalog=Northwind;Integrated Security=true");
SqlDataAdapter DA = new SqlDataAdapter();
DataSet DS = new DataSet();
SqlCommand cmdSelect = CNN.CreateCommand();
cmdSelect.CommandText = "Select CustomerID, ContactName, CompanyName From Customers";
// create an Update command
SqlCommand cmdUpdate = CNN.CreateCommand();
cmdUpdate.CommandText = "Update Customers SET CompanyName=@CompanyName, ContactName=@ContactName WHERE CustomerID=@CustomerID";
cmdUpdate.Parameters.Add("@CompanyName",
SqlDbType.NVarChar, 40, "CompanyName");
cmdUpdate.Parameters.Add("@ContactName",
SqlDbType.NVarChar, 30, "ContactName");
cmdUpdate.Parameters.Add("@CustomerID",
SqlDbType.NChar, 5, "CustomerID");
cmdUpdate.Parameters["@CustomerID"].SourceVersion =
DataRowVersion.Original;
// create an Insert command
SqlCommand cmdInsert = CNN.CreateCommand();
cmdInsert.CommandText =
"Insert into customers (customerid, companyname, contactname) Values (@customerid, @companyname, @contactname)";
cmdInsert.Parameters.Add("@customerid",
SqlDbType.NChar, 5, "customerid");
cmdInsert.Parameters.Add("@companyname",
SqlDbType.NVarChar, 40, "companyname");
cmdInsert.Parameters.Add("@contactname",
SqlDbType.NVarChar, 30, "contactname");
cmdInsert.Parameters["@customerid"].SourceVersion =
DataRowVersion.Original;
// create a Delete command
SqlCommand cmdDelete = CNN.CreateCommand();
cmdDelete.CommandText = "Delete from customers Where customerid = @customerid";
cmdDelete.Parameters.Add("@customerid",
SqlDbType.NChar, 5, "customerid");
cmdDelete.Parameters["@customerid"].SourceVersion =
DataRowVersion.Original;
DA.SelectCommand = cmdSelect;
DA.UpdateCommand = cmdUpdate;
DA.InsertCommand = cmdInsert;
DA.DeleteCommand = cmdDelete;
DA.Fill(DS, "Customers");
//then do whatever you want to with modifying it.
//And then just do update like this
DA.Update(DS, "Customers");
Castro
|
|
|
|
|
Hello Friends,
I am a beginner in C# programming, I am trying to build a small home based expense management tool in which i need to login to my acct on different banking websites to get the bills/pay the bills through my tool. I believe this is possible through the web services provided by those banks(if not plz correct me).
My question is how do i find out those web services?
Thanks in advance,
Anitha
|
|
|
|
|
Odds are very high that those web services do not exist. You should ask the banks in question.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
Any other way to do this?
|
|
|
|
|
Not without spending a ton of money, or doing it the very tedious way.
The money would be spent on the access to the banking system and the API's to interact with it. It's not very likely you'll ever get that...
The tedious way is to write code to load and parse the web pages from the banking sites, including code to login to those sites. Like I said, this is VERY tedious work because you'll have to custom write code for each and every website and each and every page to get the information you want. The other big downside to doing this is when, not if, the bank changes their website, you'll have to go back and rewrite your code to parse up the new pages.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
I have searched and searched and have found nothing that will help me. I have a formatted file to send to a printer. I have to do it this way because I can't print straight from the program (AutoCAD) to a printer, so I have to print to a file. I can do this just fine, but I can't see how to copy the .plt files to the printer port.
This is just my thinking (copy the file to the printer through the printer port), if I'm wrong please point me in the right direction.
Thanks in advance.
Tim
|
|
|
|
|
You would be able to just make a console app and use the built in printer class. It should do the trick. I don't know for sure, so sorry.
Castro
|
|
|
|
|
Thanks for the idea. I will see what I can do.
Tim
|
|
|
|
|
Hi,
I want to create an application that plays the sound recorded from the microphone. I succeeded in capturing the sound from the mic using CaptureBuffer....my problem is when using the data from this buffer to play it with SecondaryBuffer.
I'm using a memory stream to get the data from the capture buffer to a stream. When I capture the data from the mic I use the following code.
CaptureData is a byte array.
<br />
memStream.Write(CaptureData, 0, CaptureData.Length);<br />
secBuffer = new SecondaryBuffer(memStream, appDevice);<br />
secBuffer.Play(0, BufferPlayFlags.Default);<br />
When i run my application it gives me System.ArgumentException was unhandled - Value does not fall within the expected range.
Even if I use a different constructor, it always gives me this exception. I think it' because of the device object...This object is instantiated like this:
<br />
appDevice = new Device();<br />
appDevice.SetCooperativeLevel(this, CooperativeLevel.Priority);<br />
If any of you have a suggestion it will be most welcomed because I ran out of ideas.
Thanks.
Do your best to be the best
|
|
|
|
|
Maybe you should use the constructor where you pass in a BufferDescription object to describe the format you're using. This is just a guess, but I think that since you got your stream for a capture buffer that it's not going to have the headers at the beginning that a stream loaded directly from a wave file would have. Thus you need to provide that info with the BufferDescription object.
But don't quote me on that...
|
|
|
|
|
Hi,
I'm developing a web service in which I need to get the sub-directories & files list which reside in the same directory where the Web service is installed.
In other word, in the same directory where I put my Service.asmx, I have a few other files & directories.
Those file & Directories I need to access from within my Web Service Code.
This Web Service will be Deployed in a nother computer, so when I'm building it i have no idea in which directory it will reside.
My question is: How do I gain access to the actual directoy in which my Servive.asmx got installed to, so I could something like: foreach (string directory in Directory.GetDirectories(MyWebServiceDirectory))??
If i use Environment.CurrentDirectory I get the C:\Windows\system32...
If I use Application.StartupPath I get back a reference to an HttpApplicationState object...
Any Help is appreciated.
tnx
Roy Kabiri
|
|
|
|
|
|
Ooops. Probabbly Missed it. tnx.
Roy
|
|
|
|
|
Hello,
I am currently developing a project that has a reference to an outside dll (some utility in another folder). I randomly make changes to this dll and I sometimes forget to update the version. This makes Visual Studio think that there have been no changes to the file since the version number is the same. Is there any way to have visual studio always copy a fresh dll from the source folder even if the version has not changed? I know that I could perform this action in the post-build command box but I am trying to avoid that solution. Thanks for the help!
~Adam
|
|
|
|
|
I have a folder(directory) that I need to add a group to dynamically. I have figured out how to retrieve the group name but now I am trying to figure out how to dynamically add the group to a folders security permissions.
Any suggestions would be helpful as google has proved unfruitful.
Thanks.
_____________________________________________________________________
Our developers never release
code. Rather, it tends to escape, pillaging the countryside all around.
The Enlightenment Project (paraphrased comment)
Visit Me at GISDevCafe
|
|
|
|
|
Hi,
I have to create a C# library that will draw live grayscale images to a specific window handle that was passed by an application (e.g. picturebox1.hwnd in VB6). I don't have any control over the application and the only information given to my library will be the window handle to draw to.
So what C# code would allow me to draw images (from a bit array) very fast to a window handle? Will I have to use Win32 and BitBlt (how?) or is there some managed code that will accomplish this too?
Thanks.
|
|
|
|
|
1) Control c = Control.FromHandle(myHwnd);
using(Graphics g = c.CreateGraphics())
{
g.Draw... what ever you want
}
NOTE: if you are going to many drawing on the control handle which is passed to your function or class which has this drawing function, better to create a Graphics instance "once" and use it over and over again instead of using a "using(Graphics g...)" where a new instance of graphics created and disposed after each drawing.
I would prefer capturing the handle in my Drawer/Painter class's constructor and create a Graphics object there immediately. (This way I suppose the size of the windows whose handle was captured does not change). Otherwise you should use "using(Graphics g = ...)" block
Hope this helps...
|
|
|
|
|
How can I clear out my deletedItem folder in outlook 2003 with c#?
|
|
|
|
|
How can I clear out my "deletedItem" folder when I shut down my outlook 2003 in c#?
|
|
|
|
|
Outlook 2003[^] might be a starting point for you. It has links to various things you can do in C# with Outlook.
|
|
|
|
|
Hi guys
can any body tell me how can i write into app.config file through c# code, when i try to write through configurationmanager so it throws an exception saying that
"configuration is read only" why is that?
how can i do that?
thanks in advance
hello
|
|
|
|
|
The app.config file is just where things start. When you compile your application it becomes Exename.exe.config. You have to use something like this:
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
To access your app config file and make changes to it. If you try to write to it directly you get the readonly error since the application is using it.
Hope that helps.
Ben
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
