|
Hi folks,
I want to create a trigger using C# and execute using ExecutenonQuery.I can have TableName on which i've to Create a trigger at Runtime. I need to Create a trigger for both insert and update.Can anyone help me?
Appreciate any help.
Thanks in advance
sri
|
|
|
|
|
You need to generate sql command that creates a trigger in database during runtime programmatically and issue the command using SqlCommand class.
Giorgi Dalakishvili
#region signature
my articles
#endregion
|
|
|
|
|
Hello,
I have a C# application that uses SoapFormatter.Deserialize (Stream) to persist a stored object. It used to work perfectly.
Then I made the application into a managed DLL, and called it from an unmanaged C++ DLL, which was invoked by an unmanaged C++ application:
C++ App => C++ DLL => C# DLL
Now, when I try to deserialize objects that used to work perfectly, I get:
"Parse error, no assembly associated with Xml key ..."
Microsoft documentation is unhelpful for this. Another web site suggested the problem is caused by "... changing the assembly name of your class...", but I haven't changed any name (that I'm aware of).
Does anyone have any insights into what's going on here?
Thanks!
|
|
|
|
|
|
Can anyone tell me if it is possible to programatically select a portion of a datagridview text box column? For example, the standard text box has SelectionStart and SelectionLength properties that can be used to programatically select a portion of its text, but I don't see those properties available with the DataGridViewTextBoxColumn. Am I missing something, or is selecting the entire column/cell my only alternative, even if I only wish to select a portion?
Thank you...
|
|
|
|
|
Hi,
I'm was wondering if LinkedIn has published its open-social APIs.
While searching i came across a article many times stating LinkedIn's founder declaring that these APIs will be publised in next 9 Months. This article was dated June 2007. So i guess by now they should have published it.
But i'm not able to get it any where on the net.
My main purpose is to use the APIs to get the list of contacts for LinkedIn user.
Google has publiehed such APIs.
If any one have any idea about this, please mail me at sunit_82@yahoo.com.
Thanx,
Sunit.
s.a.w.
|
|
|
|
|
There's an email link at the bottom right of this page[^] that seems to be the place to ask for API access
|
|
|
|
|
sunit_82 wrote: please mail me at sunit_82@yahoo.com.
No. That would defeat the purpose of community discussion boards. When an assistance is sent to your private email, only you benefit. When it is posted as a reply, you and posterity benefit from the post which becomes on par a valuable Kb.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
hello
Can somebody use the query analyzer in sql 2005
10x
dghdfghdfghdfghdgh
|
|
|
|
|
|
|
Sorry,
but i need to know how to use the query analyzer in sql 2005
best regards
dghdfghdfghdfghdgh
|
|
|
|
|
You don't have to be sorry!
|
|
|
|
|
Somebody could use SQL Server Management Studio.
|
|
|
|
|
I am quite new to C# and I am having a mental blank day  . I've extracted some data from a database, several of the columns of data are stored in a shortened form. When displaying the data to the user I would like to convert the shortened form to full text. For example 'D' would become 'Decommissioned'.
Currently the data is extracted and displayed from the code below
MySqlDataAdapter da = new MySqlDataAdapter(cmdSQL);
DataSet ds = new DataSet();
da.Fill(ds, "template");
gridGuide.DataSource = ds.Tables["template"];
What is the best way to head now?
Thank you for you help.
|
|
|
|
|
Karlos_V wrote: For example 'D' would become 'Decommissioned'.
Fix your SQL query.
|
|
|
|
|
I would do it within the SQL query but it is a large database and there could be 50 to 60 different conversions for each column within some tables therefore I was thinking it would be better for the server and network that the processing of this was done on the client computers.
|
|
|
|
|
Karlos_V wrote: 50 to 60 different conversions
There is no conversion, simply do:
Select D as 'District' ...
|
|
|
|
|
Sorry if I am being confusing, let me word it in a different way. Ignore that the data has come from a database as I am only interested in it once it is in a dataset within the program.
I have a dataset with a datatable, I would like to change the data held within a column of a table so that any occurences of 'C' now become 'Commissioned', 'L' becomes 'Live' etc.
Is there a quick method of doing this or do I need to go through cell by cell passing it to a function?
|
|
|
|
|
Without knowing more information what you want to do with the "converted" values and other restriction, it's hard to suggest any solution.
For instance,
1. You can have mapping tables and join them in your query.
2. You can have specialized custom control that do the "conversion".
3. If you are displaying them in a combobox, you can make use of the DisplayMember and ValueMember when you bind the property to it.
4. And of cos you can go and change the value yourself in the dataset, which probably is the least efficient way.
|
|
|
|
|
Hi,
I have tried and im successful in transferring a large file say 200mb to from server to client. but the problem is i get 100% CPU usage while the file is transferring.
if i have a file of 200MB, it will have 209715200 bytes; now to send this file, i first made partitions of 4000Bytes. If we take Mode of its total size with 4000, we'll get 3200Bytes remaining, and the rest of it remains 209712000 which is exactly divisible by 4000. What my program do is first it sends the 3200Byte chunk and then the remaining 209712000Bytes. If we divide 209712000 by 4000, we'll get 52428. Which means the loop will run 52428 times in order to send the whole file. And same goes on the server side when it is receiving the file. These loops make my CPU hit 100%. And if i push the whole buffer to the network it says the buffer is full and EXCEPTION. Please tell me a good solution to transfer file without using that much CPU. I'm making a file sharing server, if CPU will hit 100% on one client, i wont be able to support more than two client or even 1.
|
|
|
|
|
|
|
Hi,
I have a directory which contains multiple sub directories.
Inside those sub-directories are zip files protected by a password.
The password for all the zip files (156) are the same.
Is it possible with C# DotNet and the ICSharpZipLib to remove the passwords?
So not unzip it, only remove the passwords....
Any help would be greatly appriciated!
|
|
|
|
|
I see you asked this question in the SharpZipLib forums, that's probably your best bet.
As far as I'm aware, there isn't a way to do this. I think you need to create a new zip without the password.
Life, family, faith: Give me a visit.
From my latest post: "When Constantine severed the Hebrew origins of this faith in Messiah, a new religion was officially created. It is this religion that Orthodox Jews fear their relatives and friends becoming members of."
Judah Himango
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
