how can i insert a TextBlock control in a Hyperlink in c# coding. similar to
<TextBlock> <Hyperlink>a</Hyperlink></textblock in C#. i'm unable to find content property in Hyperlink. Thanks in advance.
how to create connection using class file in C# for windows application?... how to develop Data access layer... regarding 3-tire architecture using mysql databases
i have an tiny editor web page where my users can use this editor and i am saving the html into my database.
i am having issues saving this html to my database. for example if there is a name with a "'" or if there are other html character "<,","" etc, my code seems to blow up on the insert.
Is there any best practices about taking any arbitrary html and have it persist fully to a db field without worrying about any specific characters.
What is the fastest way to reorder (resort) a table? In MySQL, you can do:
CREATE TABLE table2 LIKE table1;
INSERT INTO table2
SELECT * FROM table1 ORDER BY by name;
DROP TABLE table1;
RENAME TABLE table2 TO table1;
What about PostgreSQL?
Is there a faster way?
Trying to use SubSonic 3.0.0.4's Linq TEmplates. Got everything working. But in the Doc's I'm seeing how I can use aa IRepository to bulk insert, update, delete my db. Thing is - It wasn't included in the download. Is it somewhere else and I simply overlooked it?
I've got a ton of updates going from one "Save" call - so this would be very helpful!
Thanks
I have loaded an Excel worksheet inside a WebBrowser component. Now I need to do some calculation and insert the result of the calculation into a named cell in the active worksheet. Could someone please help me with this.
Thank you.
I'm inserting new rows into a SQLite table, but I don't want to insert duplicate rows.
I also don't want to specify every column in the database if possible.
I don't even know if this is possible.
I should be able to take my values and create a new row with them, but if they duplicate another row they should either overwrite the existing row or do nothing.
I have a list containing a tuples and long integers the list looks like this:
table = [(1L,), (1L,), (1L,), (2L,), (2L,), (2L,), (3L,), (3L,)]
How do i convert the table to look like a formal list?
so the output would be:
table = ['1','1','1','2','2','2','3','3']
For information purposes the data was obtained from a mysql database.
Hi,
I want to make a button and when it's clicked then modal box opens where user have to enter url, click insert and then url is inserted to editor. So far I have added button and opened modal box but how could I get back those values?
Thanks.
What is the correct Syntax to be applied for "@[System::ErrorDescription]" inside the query like "INSERT" ? I am unable to retrieve the correct Error Description inside the table, as the result in the table is showing as "@[System::ErrorDescription]". I am not getting the result !
I want to have automatic backup of some directories on my pendrive whenever I insert a pendrive to my laptop running Ubuntu 10.04. What whould be the simplest solution for that?
I was reading Code Complete 2 and it mentions this:
Many version-control tools wil insert version information into a file. In CVS, for exmple the characters
// $id$
Will Automaticly expand to
// $id: ClassName.java, v 1.1 2004/02/05 00:36:42 ismene Exp $
So now I would like to do something similar with VSS for our SQL scripts
I have been googling around for the answer but can't find it. Is this possible? can someone maybe point me in the right direction?
It is possible with php create a script, and this script insert an appointment in outlook calendar.
I search in internet but... I don't find a solution...
I use php but if it is possible with JavaScript is the same.
Thanks!
I am using PHP and Mysql
I have PHP script in which I rollback all the data in the database such data all the old value be reset to the database if update is done, and all new value gets deleted if new insert has been done.
Now my goal is to perform the same process with files/folders associated with the changes done, I am not able to create an idea for doing the rollback job with the files/folders associated with the Changes.. So can anyone of u help me or direct me to get the best idea?????
Introduction
I have some sort of values that I might want to access several times each page is loaded. I can take two different approaches for accessing them but I'm not sure which one is 'better'. Three already implemented examples are several options for the Language, URI and displaying text that I describe here:
Language
Right now it is configured in this way: lang() is a function that returns different values depending on the argument.
Example: lang("full") returns the current language, "English", while lang() returns the abbreviation of the current language, "en". There are many more options, like lang("select"), lang("selectact"), etc that return different things. The code is too long and irrelevant for the case so if anyone wants it just ask for it.
Url
The $Url array also returns different values depending on the request. The whole array is fully defined in the beginning of the page and used to get shorter but accurate links of the current page.
Example: $Url['full'] would return "http://mypage.org/path/to/file.php?page=1" and $Url['file'] would return "file.php". It's useful for action="" within the forms and many other things. There are more values for $Url['folder'], $Url['file'], etc. Same thing about the code, if wanted, just request it.
Text
[You can skip this section]
There's another array called $Text that is defined in the same way than $Url. The whole array is defined at the beginning, making a mysql call and defining all $Text[$i] for current page with a while loop. I'm not sure if this is more efficient than multiple calls for a single mysql cell.
Example: $Text['54'] returns "This is just a test array!" which this could perfectly be implemented with a function like text(54).
Question
With the 3 examples you can see that I use different methods to do almost the same function (no pun intended), but I'm not sure which one should become the standard one for my code. I could create a function called url() and other called text() to output what I want. I think that working with functions in those cases is better, but I'm not sure why. So I'd really appreciate your opinions and advice.
Should I mix arrays and functions in the way I described or should I just use funcions?
Please, base your answer in this:
The source needs to be readable and reusable by other developers
Resource consumption (processing, time and memory).
The shorter the code the better.
The more you explain the reasons the better.
Thank you
PS, now I know the differences between $Url and $Uri.
hi!
Is there a way to insert only date in a datetime column in sql server without the time?
for example
date (datetime)
===============
12-01-2000
16-02-2000
or i should store this as a varchar and cast it when retriving so that i can convert to whatever form i need.
hi, I have read that after select we use column-names but I have found a statement that was like this:
SELECT 'A' FROM T WHERE A = NULL;
would you lease help me? thanks (A is a column- name here?)
my DBMS is MySQL
I have a load of tables all with the same 2 datetime columns (lastModDate, dateAdded).
I am wondering if I can set up global Insert Update trigger for these tables to set the datetime values. Or if not, what approaches are there?
Any pointers much appreciated
Is there a way to tell how to get a file size that is uploaded to database?
SELECT [ID]
,[File]
FROM [dbo].[Reports]
I would like to be able to tell user the size of File which is VarBinary(max) field in MS SQL 2005/2008. How to do that?
Maybe the only way to do is to create another column and when inserting file i should also insert it's size in additional column?
I used Linq to insert objects into database.But if i used threads to simultanously create 20 object within 1 second, then system will fail to add 20 objects into database.
And I found it is not because of the sql server 's limit. so the only possible is Linq, any one have idea ? How can I create 20 records or more in 1 second within 1 second ?
Hello,
I'm trying to insert in an Access Database, from visual C#. But i got this error: error
What am I doing wrong in code? The values are correct, they comes from the input boxes.
Thanks!
Hi,
I have a template document with a simple macro to insert a file into a document. When i try to load this template file using Application.Addins.Add i am getting an error saying 'Word cannot open this document template'.
wordApplication.AddIns.Add( %template file path%, ref trueObj );
This works fine on some machines.
Also is there any way to make sure that we load the template file as a global Template always.
I have a very simple INSERT statement being executed from a PHP script running on a Linux Apache web server. I can run the query fine from within SQL Management Studio and it normally runs fine from PHP as well. However, every once in awhile I get an error message from my PHP script that the query failed and the mssql_get_last_message() function returns 'The statement has been terminated'.
What sources can cause this message to be returned from MSSQL?
I am trying to learn how to create tags in PHP/MySQL. Does anyone know some good sites that help explain how to go about creating tags?
Tags as in the tags you see when you ask a question in stackoverflow.
I have a load of tables all with the same 2 datetime columns (lastModDate, dateAdded).
I am wondering if I can set up global Insert Update trigger for these tables to set the datetime values. Or if not, what approaches are there?
Any pointers much appreciated