|
Does the exact query entered into SQL Server through Query Analyzer return any rows?
|
|
|
|
|
Hi all,
I have a tooltip on a Checkbox. As long as the users don't click on the Checkbox, it's tooltip will displpay. However, once the user has clicked on it, the tooltip won't appear anymore.
Is this fixable?
|
|
|
|
|
Do you want to do this ?
You may then :
private void myCheck_CheckChanged(object sender, eventargs args)
{
this.myCheck.ToolTip = null;
}
------------------------------ "The Soapbox has been so ..."
|
|
|
|
|
1 be sure that your code dose not reset the tooltip from the checkbox.
2 if you are sure delete the checkbox and drag drop it again
Tamimi - Code
|
|
|
|
|
i can't find anywhere an example...i know that in php when used a variable
in Sql Select statement you must put a sign before it like a $ or put between
'' so there must be something in C# too !
Thanks
TheBeginner
|
|
|
|
|
just treat the sql command as you would a String,
ie:if for example you want a variable to define what the select will return the code will be
MyCommand.CommandText = "SELECT " + MyVar.tostring() + " FROM MyDB";
i hope this answers your q
|
|
|
|
|
When you use a SQL parameter, designate the parameter with an "@" symbol. E.g. "Select FirstName, LastName from Contact where ContactID = @contactID"
This is SQL syntax and would apply to any queries against the SQL server database, C#, VB.NET, j#, etc. all would use the same syntax.
Jim Conigliaro
jconigliaro@ieee.org
|
|
|
|
|
This is definitely the preferred method. You'll get data type mismatch exceptions at runtime instead of SQL injection attacks.
|
|
|
|
|
TheBeginner77 wrote: used a variable
in Sql Select statement you must put a sign before it like a $
Read this article about SQL injection attacts.
SQL Injection Attacks and Some Tips on How to Prevent Them[^]
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
|
|
|
|
|
Im not sure if Insert is even the right word in SQL terms, but heres my problem:
I am trying to write files, binary files, into a database using a buffer. I want to add large files into the database in small pieces. I have the code underlying the problem of actually cutting it up. My problem starts when I try to insert it into the database, it just overwrites the previous data instead of appending it.
All help is greatly appriciated!
THANKS!
|
|
|
|
|
It would be very helpful to see the SQL statements you're using.
"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
|
|
|
|
|
Hi,
This is kind of a repost, but not completely.
I want to show a Pitch graph/curve of a wave file. I saw that good results can be made by using AutoCorrelation. I have the autocorrelation function and I also have the FFT function, but I don't know what I should put into the autocorrelation function in order to get a pitch line.
I have a wave file (spoken text), and also have the FFT results of the wave file, how can I extract from this data a nice Pitch curve. The purpose of the pitch line is to show the intonations of the text.
Thanks,
Gidon
|
|
|
|
|
I'm trying to build a simple backup program in C# and want direct disk/partition access to the raw data with longfile name support. I have been looking for documents or source to learn from but I cannot find any. I'm sure I'm just not searching for the right keywords. Can anyone point me in the right direction?
Thanks,
dcoerver
|
|
|
|
|
I'm not absolutly sure what you want because when you're talking about raw access to the disk or a partition you don't have file names.. There is just one big block of data which you have to parse yourself...
However if you just want to read raw data from a partition - it's pretty easy with CreateFile. You can specify this: "\\.\C:" instead of a filename to "open" a partition!
|
|
|
|
|
Can someone show me how to do this in c#?
|
|
|
|
|
hi
in the button_click i wrote these codes :
string src = @"E:\App_Lock\HDCopy.exe";
FileStream finput = new FileStream(src,FileMode.Open);
BinaryReader br = new BinaryReader(finput);
byte[] b = br.ReadBytes((int)finput.Length);
System.AppDomain dom = System.AppDomain.CreateDomain("newDomain");
Assembly assembly = dom.Load(b);//Get Error On this line
assembly.EntryPoint.Invoke(null, null);
but an error occured when i clicked button and show this error :
Additional information: Exception from HRESULT: 0x8013141D
How to solve My problem and run app from byte[]?
|
|
|
|
|
hdv212 wrote: Exception from HRESULT: 0x8013141D
is HD_Copy.exe a Managed C++ mixed-mode assembly? If so, you cant load it from byte[].
|
|
|
|
|
hi
HD_Copy.exe is a setup program and i don't know what is it ..
|
|
|
|
|
How can i make a file(or my code) as a ddl file so that no one can see my code.
Any help please??????????
aLi
|
|
|
|
|
If you mean calling the code, you may mark your code blocks as private or internal, otherwise you mean by diassimlying your code you may use Dotfuscator.
------------------------------ "The Soapbox has been so ..."
|
|
|
|
|
to convert you program to DLL :- from the main menu select
Project -> Properties on the properties dialog change the (output type)combobox to (Class Library) then press ok().
Tamimi - Code
|
|
|
|
|
Hello all,
in my WinForms application there are many forms. I want to apply one Icon file for all forms and for EXE also
How to do this
any suggetions are appriciated
regards
GV Ramana
|
|
|
|
|
For forms :
You can make a base class (say class BaseForm:Form)
Set the icon for this class
And inherit all forms in the project from it..This can also help you applying default styles to all your forms.
|
|
|
|
|
And for the exe itself, set its property from the project properties menu.
------------------------------ "The Soapbox has been so ..."
|
|
|
|
|
UPDATE: This works correctly when I run the BIN directory executable, but not when I run from the debugger.
I have a table adapter with insert method, for testing I use the following in a button click event:
this.classPhotoNamesTableAdapter.Insert(100, 100, 200, 300, 400, "PICNAME");
this.USNTPSDataSet.ClassPhotoNames.AcceptChanges();
If I click the button twice I get a primary key violation, so its valid, but the row is not inserted into the actual db file. Am I missing something?
I also tried this way with the same results:
SqlConnection dataconnection = new SqlConnection();
dataconnection.ConnectionString = global::....USNTPSConnectionString;
dataconnection.Open();
SqlCommand datacommand = new SqlCommand();
datacommand.Connection = dataconnection;
datacommand.CommandText = "INSERT INTO ClassPhotoNames (class_no, x_lower, y_lower, x_upper, y_upper, pic_name) values (100, 200, 300, 400, 500, 'NAMEFIELD')";
datacommand.ExecuteNonQuery();
dataconnection.Close();
datacommand.Dispose();
dataconnection.Dispose();
-- modified at 16:06 Saturday 3rd June, 2006
|
|
|
|