I'm trying to use this code to check if the system already exists a field with this value
Dim adap As New MySqlDataAdapter
Dim sqlquery = "SELECT * FROM client WHERE code ='"+ TxtCode.Text +"'"
Dim comand As New MySqlCommand()
comand.Connection = con
comand.CommandText = sqlquery
adap.SelectCommand = comand
Dim data As MySqlDataReader
data = comando2.ExecuteReader()
leitor.Read()
If (data(3).ToString) = code Then
MsgBox("already exists", MsgBoxStyle.Information)
TxtCode.ResetText()
TxtCode.Focus()
Else
Console.WriteLine(insert("INSERT INTO client (name, tel, code) VALUES ('" & name & "', '" & tel & "')"))
con.Close()
End If
public struct Items
{
public string Id;
public string Name;
}
public Items[] _items = null;
if (_items.Contains("Table"))
{
// i need to check the structure and need to return correponding id
}
and am having a list of variables in my structure variable...
i need to search a Name in the structure(_items) and i want to return the Corresponding Id.
how to do this,
what im trying to archive is to load some images from external servers flickr, but i want to re-size the image before rendering, i want to know if there is any way to load that external image check the size and if its too big then with some c# code do the resizing and then send it to the client?
Thx in advance.
Hi,
I'm looking for PHP script samples of websites. I'm just done reading a text book on PHP and I want to check out some of the various implementations.
Thanks
I have to make a process in Oracle/PLSQL.....i have to verify that the interval of time between start_date and end_date from a new row that i create must not intersect other start_dates and end_dates from other rows.
Now I need to check each row for that condition and if it doesn't correspond the repetitive instruction should stop and after that to display a message such as "The interval of time given is not correct".
I don't know how to make repetitive instructions in Oracle/PLSQL and I would appreciate if you would help me.
Is there a way to check in VS how much time did I spend on particular project? It's just I feel that I'm not working fast enough and seeing the actual time I spent would probably kick me in my ass and maybe I would speed up a bit.
Thanks.
I was wondering if its possible to have some kind of SQL error reporting that sends me an email that includes the error and the website that it's been found on.
I'd like to take this precaution because of hosting multiple drupal systems.
There is a PHP error variant:
http://drupal.org/project/php_errors
Hope you guys know a way to become aware of any possible SQL errors by not loggin in to check the error report.
I am setting up a dns lookup form using dns_get_record. I set it up to check the A Record and MX Records of the domain that is input. However, I would like it to also display the IP address of the displayed MX Records. Is this possible?
Is there a easy standards-compliant way to check if a URL string is a valid format? Either through a specific URL-type class or maybe someone could show me how to do a regex validation of it?
Hello, I have set up an array of censored words and I want to check that a user submitted comment doesn't contain any of these words. What is the most efficient way of doing this? All I've come up with so far is splitting the string into an array of words and checking it against the array of censored words, but I've a feeling there's a neater way of doing this.
Dear all,
I wan to read a file and then write using java.nio and return it to servlet.i also want to check whether file has been downloaded or not.plz suggest.
i have
("#sendbid").live("click", function() {
//here will be the ajax
//after success:
("#personaltab").empty();
})
the personaltab is in the original code. the content is created on ajax and then when the user continue i want to check with live and empty the div
not working - i have tried it all!!!
Hey everyone I'm trying to get a List of directories. I'm using FileUtils listFiles().
I want to do something like this: listFiles(File,IOFileFilter,false). My real questions is how I can implement the accept() from the IOFileFilter so I can check if current File is a directory?
Thank you in advance.
All i want to do is to check if the textfield has been changed. if not, i want to highlight the boxes when submit is pressed. how do i do that? seems very simple, but not sure why every other solution is so complicated
i am trying to get checkbox value ,using c#
In grid view the datasource is from oracle
i have added the checkbox but the value is not coming
please help me in checking the value of check box
this is for selecting the candidate if the checkbox is selected the particular candidate name is selected and the candidate names are appended
in a string
Is there a static code analyzer for PHP files? The binary itself can check for syntax errors, but I'm looking for something that does more, like unused variable assignments, arrays that are assigned into without being initialized first, and possibly code style warnings. Open-source programs would be preferred, but we might convince the company to pay for something if it's highly recommended.
Every now and then I have a problem with SVN inside eclipse folder gets locked, I have to check out projects few times update and stuff like that . is there a SVN that I can use to commit files directly from console or windows folders?
Can anyone tell me if its possible to validate a link with php? By validate, I mean check if the link is active and works not just the actual format of the link.
In report preview, if i want see the data only in even pages or odd pages or if i want check the even pages only. Is it possible or not? If it's possible could u plz tell me how to do that?
I need to get all reports made in last 24h, table has CreatedDate column, so I need to check in database that report was created in last 24h. I know I can use getdate() to get current date, but how can I minus 24h from that attrbiute and then compare that date with CretedDate?