|
thanks for reply.. anyway..my question is not on the listbox coding..
i have a few questions here..
for that code..
1) i did not declare any connectionstring
2) i did not call any sqlcommand query e.g. "select name from ..."
because if we specify the sqlcommand, will it save time to look for the data that we want instead of doing that in datatable like what i did above..??
why i did not declare the conntectionstring also can work? i did not declare the Using System.sqlclient..
which way is better ?
|
|
|
|
|
1) the connectionString has been stored in Properties.settings.
2) if you were drag and drop the datatable in to your program, SELECT, UPDATE, DELETE, INESRT Command will generate to you automatically...
Depends on the usage in your program, if you will handle all sql command, it should be "faster".
but if the record is not larger than 100,000. I don't think there has too much different. But development time
|
|
|
|
|
thanks.. so which mean the way i did is faster in development time ??
|
|
|
|
|
i has also posted before to other forum.. what they said was the way i did will be slowing down eveyrthing..
|
|
|
|
|
|
Sorry for late reply.
If you want to have a faster development time, you have to use the predefine or auto-gen code for your development, it will slow down the work, but it save in coding.
But if you have time to design a better software structure, it will take time but faster in performance.
It's depends on your choice.
|
|
|
|
|
hi i use the below code to update..
DataTable store = new DataTable();
store = son.Table1;
father.Update(name.Text, ......)
but visual prompt me soemthing weird when i put " , " after name.text
in my Table1 only have "id, name, address" .
why after "," it prompt me update(string name, string address, int Original_ID, string Origianl_name, string Original_address, int ID)
i cant update if i din all those things.. something is wrong with my database.. ? i checked.. it shown only 3 fields
|
|
|
|
|
if your "father" (is it a good variable name?? ) mean SqlDataAdapter, why don't you update the whole dataset or datatable???
and SqlDataAdapter.Update will be execute the UpdateCommand that predefine in the SqlDataAdapter.UpdateCommand, did you set the command correctly??
|
|
|
|
|
do u mean i need to add query for update for my dataset ? i did not set the command.. cos when i put " father. " after the . it shown me the update..
the update already there// ? should i add that query ??
|
|
|
|
|
i try to add the update query at the tableadapter query configuration wizards. it show like this
<br />
UPDATE [Table1] SET [name] = @name, [address] = @address, [phone] = @phone WHERE (([id] = @Original_id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_address = 1 AND [address] IS NULL) OR ([address] = @Original_address)) AND ((@IsNull_phone = 1 AND [phone] IS NULL) OR ([phone] = @Original_phone)));<br />
SELECT id, name, address, phone FROM Table1 WHERE (id = @id)
why not like this
UPDATE [Table1]<br />
SET name = @name, address= @address, phone = @phone<br />
WHERE (Id = @Original_Id); <br />
SELECT Id, name,address,phone FROM [User] WHERE (Id = @Id)
|
|
|
|
|
it's prevent if there has 2 users editing the record, if A has submit the update command, then B SHOULD NOT be update and the program should handle the roll back.
a easy example, if 2 people want to buy a movie ticket online, and they were select for the same seat, if A has submit the data, could B update the DB also??
if the update command is ready, just provide the dataset/datatable to the adapter is fine
in your case, it should be:
father.Update(son);
|
|
|
|
|
|
Hi rameshgoudd,
You already posted around 34 posts in our forum so that you are NOT new anymore. You should check which forum you are in before posting the message. Now, you posted the database-related question in C# forum.
Another thing is that you should search in Google first. Look at this search T-SQL SELECT[^]. You will get what you want in a few second. So, you don't need to wait our replies too.
|
|
|
|
|
Can anyone recommend an image processing library, readily usable from C#? preferably free (even if "crippled"), as I am just toying around at the moment. Specifically, I am looking for:
* resizing + cropping
* color adjustment (brightness, contrast, color space optimizations)
* text overlay
* lossless rotate for jpegs
|
|
|
|
|
I used to use the Paint.NET to edit the images. But I'm not sure whether they make it as a library or combine everything into UI. Anyway, you can take a look their codes and customize the way you want.
|
|
|
|
|
I have a pop up window in my app to search a xml file, when the user clicks on the red 'X' to close the window I just want to turn the window visible = false, so the next time they go to open the window it just sets visible = true (allowing me to access all the functions in the Find class even when the find window is closed). To the problem i am having is that when I do:
void Find_FormClosing(object sender, FormClosingEventArgs e)
{
....
}
it still disposes the form... what event should I be dealing with? How do I do this?
Thanks
|
|
|
|
|
Did you look in the MSDN documentation for what FormClosingEventArgs e is? I'm not trying to be a dick but are you that helpess that you can't do a little research on your own before you start asking questions here? If you did, you would have seen after one second of searching that all you need to do to cancel is e.Cancel = true;
Just doing F1(in case you didn't know this is the built in MSDN library) in the ide on FormClosingEventArgs would bring you to this[^] page. It has the cancel property right there. In the time that it took you to post that question, you could have already found it with a little bit of willingness to try to find the answer yourself. Here is the code, since you are probably too lazy to figure it out yourself.
void Find_FormClosing(object sender, FormClosingEventArgs e)
{
e.Cancel = true;
this.Visible = false;
}
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
thank y... got to lazy to finish that word
modified on Friday, December 07, 2007 12:58:19 PM
|
|
|
|
|
I have need of NPlot within a VBA application I am developing.
There are .NET 1.1 and 2.0 dlls available, and also the C# source code. I have been doing some reading on C# interoperability with COM, but I cannot get my head around it, as my C# and .NET skills are severly lacking.
Is it possible for someone to guide me on how exactly to enable COM interoperability in NPlot, so I can insert an NPlot control inside a VBA form? I'm required to use the .NET 1.1 version, as it is the only framework installed on all PCs at my workplace.
Thank you
|
|
|
|
|
Hi there,
First in the C# source Code (For VS2005), right click in the project select properties and goto Build section on the bottom select "register For COM Interop" (do that for all projects in the solution), now if you Build the Solution in the Debug/Release directory beside the .exe/.dll it will create .tlb files, now you need to register to the GAC, go to Start-->run and write:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\regasm "YourPath"\YourDll.dll /codebase tlb:"YourPath"\YourDll.tlb /verbose
now you can use the CreateObject from VBA to intatiate and you the assembly.
PS. you have to register ALL dlls.
Hope that helped.
Nassos
"Success is the ability to go from one failure to another with no loss of enthusiasm."
Winston Churchill
"Quality means doing it right when no one is looking."
Henry Ford
|
|
|
|
|
I've been trying to find a way to authenticate a user for a little chat application (VOIP, something like Teamspeak) I'm building. I've tried WMI (compatibility issues with older versions of Windows), and some non-managed C++ code. I want to use this as an identification and authentication system, one of which that requires absolutely no passwords. If a user has a unique ID or something on their own computer that I could get that always is the same, even after a format, something that no other person could have, etc. Any ideas on how to go about this other than those stated above?
Why this?
I'm tired of using half baked ban systems (such as that of Ventrilo's) which only rid your server of the users until they change their IP, when I ban someone I want them to be as so, as in never to come back, I realize this is nearly (if not) impossible in this day and age, however there must be some way...
This has to work on Windows machines, preferably without any restrictions as far as Windows versions go.
Thanks for your ideas!
|
|
|
|
|
How about the MAC address of the NIC? They're supposed to be unique (although there are rumours that this isn't always the case), which would mean that anyone being banned from your system would need to get either another computer or NIC to continue abusing it.
"On one of my cards it said I had to find temperatures lower than -8. The numbers I uncovered were -6 and -7 so I thought I had won, and so did the woman in the shop. But when she scanned the card the machine said I hadn't.
"I phoned Camelot and they fobbed me off with some story that -6 is higher - not lower - than -8 but I'm not having it."
-Tina Farrell, a 23 year old thicky from Levenshulme, Manchester.
|
|
|
|
|
I use the MAC address too - this is the function I use. (The third "MacAddress" in the collection is the system's first MAC address, hence the count.)
public static string GetMAC()
{
string returnString = string.Empty;
ManagementObjectSearcher query = null;
ManagementObjectCollection queryCollection = null;
try
{
query = new ManagementObjectSearcher("SELECT * FROM Win32_NetworkAdapterConfiguration");
queryCollection = query.Get();
int count = 0;
foreach (ManagementObject mo in queryCollection)
{
if (!(mo["MacAddress"] == null))
{
count++;
if (count == 3)
{
returnString = mo["MacAddress"].ToString();
mo.Dispose();
break;
}
}
mo.Dispose();
}
queryCollection.Dispose();
query.Dispose();
}
catch
{
}
return returnString;
}
|
|
|
|
|
I found quite an ingenious method to go about this, it may not be the best but it almost guarantees uniqueness, and contains no WMI code. It basically checks a couple system files/folders creation dates and does some work with those.
|
|
|
|
|
Hi,
After many hours of searching, I've managed to get this working using the code below - but I'm wondering if anyone has any suggestions on improving it? I'm sure this is not as efficient as it could be!
Also - how do I go about locking the target file during the read and write?
#region Encryption
class RijndaelEncrypt
{
public static void Encrypt(XmlDocument ThisDocument, string FullPath)
{
MemoryStream ms = new MemoryStream();
ThisDocument.Save(ms);
byte[] xmlArray = ms.ToArray();
RijndaelManaged Rij = new RijndaelManaged();
Rij.Key = ASCIIEncoding.ASCII.GetBytes(Constants.Misc.MyKey);
Rij.IV = ASCIIEncoding.ASCII.GetBytes(Constants.Misc.MyKey);
ICryptoTransform rijEncrypt = Rij.CreateEncryptor();
byte[] encryptedData = rijEncrypt.TransformFinalBlock(xmlArray, 0, xmlArray.Length);
FileStream fsout = new FileStream(FullPath, FileMode.Create);
fsout.Write(encryptedData, 0, encryptedData.Length);
fsout.Close();
}
public static XmlDocument Decrypt(string FullPath)
{
FileStream fsin = new FileStream(FullPath, FileMode.Open, FileAccess.Read);
FileInfo finfo = new FileInfo(FullPath);
BinaryReader br = new BinaryReader(fsin);
byte[] encryptedData = br.ReadBytes((int)finfo.Length);
RijndaelManaged Rij = new RijndaelManaged();
Rij.Key = ASCIIEncoding.ASCII.GetBytes(Constants.Misc.MyKey);
Rij.IV = ASCIIEncoding.ASCII.GetBytes(Constants.Misc.MyKey);
ICryptoTransform rijDecrypt = Rij.CreateDecryptor();
byte[] decryptedData = rijDecrypt.TransformFinalBlock(encryptedData, 0, encryptedData.Length);
XmlDocument ThisDocument = new XmlDocument();
ThisDocument.LoadXml(Encoding.UTF8.GetString(decryptedData));
return ThisDocument;
}
}
#endregion
|
|
|
|
|