I'm writing a sql query for my database, that goes:
comn.CommandText= "INSERT INTO tb1 VALUES(' " + textbox1.text.tostring() + " ',' " + textbox2.text.tostring() + " ' )";
Which works great until one of the characters in one of the textboxes is ' (apostrophe).
In my website, there is a page called "SMS Log"It contains a GridView, in which there are 5 columns:
1) SMS sent time
2) SMS Text
3) Recipients
4) status
5) Button (view detail) since, "SMS Text" is large and "Recipients" are more than 1.
So Gridview looks very conjusted, also it does not look good.Is there any other control I can use other than Gridview to show above 5 columns in a well organized way.
This seems like a really silly question, but I've had a search around and I can't find anything about this. I've got a DB connection string that I'm creating in my web.config:-
[Code]....
and
[Code]....
but I need this connection to be read only. I've defined all my linq objects with only gets on their properties, and none of my (MVC) repository classes have .SubmitChanges() methods in them so I'm 99% sure the system can't update this DB, but I would also like to set my DB connection to be RO if at all possible. I realise that ideally this should be done at the SQL server end and the user should be made RO, but that (for various reasons, out of my control) can't be done, so I wanted to lock down my connection as the app mustn't write to the DB.
Is there a "readonly" parameter I can apply to the connection string so that it would throw an error or discard the data if any updates were attempted?
Anyone know if it's possible to inner join tables using two different connection strings? I'm using vb.
View 3 RepliesI have a drop down with different domains(domain_id column) and a textbox (TextBoxComment) for comments. What I am trying to do is select the area, input a comment, click the button and have it save to the db. My connection string errors on compile.
[Code]....
I have a similar problem. I have one Dynamic Data Website and a thousand databases - one database for each customer. HTe databases have the same schema.
After the users log in I want the Dynamic Data Website to point to a database that belongs to that user.
or on one sql statement in VS 2008.
How to use two connection strings on one data adapter
On UI Ajax calendar control is used to allow the user Expiry Date as shown below. As this is one of the controls in search, when the Search button is pressed using SQL statement (copied below) data is retrieved from ExpiryDate column of the table. The table creator declared the column type as string and the dates are saved as single digits(Example: 2/2/10 sometimes and sometime as double digits (Example: 02/02/10) I like to know the best practice in retrieving both type of strings from database table. Calendar control
[Code]....
SQL(part of stored proc)
[Code]....
with in button click event stored procedure is called to return search results.
i have an List<String> lstrings which contains a list of strings. If i want to write a linq query on a list<Employees> employees to filter for employees.name in {lstrings} var lquery = (from e in employees where e.Title =="ASP.NET" && e.Name.Contains(lstrings) select e); Im trying to filter the employees using a list of strings which match with the employee.Name
View 5 RepliesI've sucefully created a method to insert values through EF, but i've a question (maybe, a newbie question).
Should i send the values to be inserted as strings to the DAL, and then i create the object there or should i create the object in View Layer and then send him to DAL?
Example 1 (DAL):
[Code]....
Example 1 (View Layer, on a click button for example):
[Code]....
Or should i receive the strings in DAL like this: public bool NoticiasInsert(string tituloPT, string tituloEN, string descricaoPT, string descricaoEN)
Then i create the object cdcModel.noticias and set the fields there with the strings values.
What do you advice me to do? I know that both ways works, but i'm trying to develope with better patterns (i don't know if this is the exacly word, sorry my bad english)
cdcModel.noticias campos = new cdcModel.noticias();
campos.tituloPT = "a";
campos.tituloEN = "b";
campos.descricaoPT = "a";
campos.descricaoEN = "a";
if (DAL.NoticiasInsert(campos)
i want to insert regular, strings in sqldatasource.
in the "sss" i put joe and in the saw i put 'no' and it doesnt work!
<asp:SqlDataSource
ID="sql3"
runat="server"
InsertCommand="insert
into inbox(message,title,sss,to,saw) values(@message,@title,'joe',@to,'no')"
SelectCommand="select
* from inbox"
ProviderName="System.Data.OleDb"
ConnectionString='<%$connectionstrings:
sql %>'>
<InsertParameters>
<asp:Parameter
Type="String"
Name="message"
/>
<asp:Parameter
Type="String"
Name="title"
/>
<asp:Parameter
Type="String"
Name="sss"
/>
<asp:Parameter
Type="String"
name="to"
/>
<asp:Parameter
Type="String"
Name="saw"
/>
i have an entir web page stored in a string variable.I would like to remove all the text between the <head> and </head> tags.How would I do this??
View 2 Replieswe have a AutoGenerateColumns-enabled WmxDataGrid in which we are able to update table rows in a DataBase connected with a SqlDataSource.
Each time we clear a field an empty string is written to the database where we want to write DBNull values.
At the moment we generate the update string via UPDATE... SET.. and the SQL Server function NULLIF(value, '').
Works proper but when I want to add the values to e.NewValues in BeginUpdate event I'm not able to read the values from the auto generated text boxes. How do I do that? Is there an easier way to automatically convert empty strings to NULL values?
I'm pretty sure this is in the wrong forum category, but I couldn't find a relevant category, so here goes!'m looking for a way of highlighting text changes between two sets of content, very similar to how this website's wiki works:For example, if I go to an edit page on the wiki, I can compare two versions and see the difference:[URL]
View 3 Replieshave two strings:
1 string = "stackoverflow"
2 string = "stackoverflow is good"
I want to show: "stackoverflow is good".
"is good" should be highlighted with some background-color..how is it possible to do with c#?
Is there a better way to do "input forms" in WebForms?I always end up with code like this:
Double d = 0; // chuckle inside
if(Double.TryParse(myNumberTextField.Text, out d))
{
myObject.DoubleVal = d;
}
Is there a better way to process free-form "numeric" input.
I found that I don't need to use jQuery or AjaxToolKit to use a textbox with autocomplete instead using the AutoCompleteType() class.However, base in the documentation it says the autocomplete will just trigger after the button was click at first instance, with that
description looks like what I want to do will not be applicable.Is it possible to populate the textbox with a list of strings in page load? so that if I type in a textbox it will give me a complete list of strings already.
I want to display some text with formatting such as bold, italic, colored...
tf1fbidisansiansicpg1252deff0deflang1033{fonttbl{f0fnilfcharset0 Arial;}}
viewkind4uc1pardltrparsl0slmult1lang2057fs32 A fly can happen in 10 seconds. So0 , when you get home, goto 10seconds.com0 to find out how you could fly in 10 seconds this week end.par
lang1033 par
SqlDataSource1.SelectCommand = "select * from [xw] where [CustName] Like '" + TextBox2.Text +
"%'"
How Can I make two textboxt1.text and texbox2.text ?
SqlDataSource.selectCommand = "Select* from [xw] Where [Country]= textbox1.text and [CustName] Like '"+Textbox2.text+"%"
I am using a datasource in the report server where all the reports use that shared datasource while calling the reports from asp.net pages.
Now, as asp.net pages uses the connection string for the databases which is assigned in the web.config file, i want the reports also use the same connection string because you don't need to change on both places( web.config and report server datasource).
How i can make the normal search string to sql server full text search parse, because when we are user enyer search text "how to run windows schedule in C#", in database we have article to to this, but data not returning and sometime is say error in key word and etc.
View 1 RepliesI have a field called IsAdmin in my user database which is a bit and i have used a checkbox for entering its value in my forms...but i get an error
Conversion failed when converting the varchar value 'System.Web.UI.WebControls.CheckBox' to data type bit. How do i sort out this error....and i want IsAdmin to be either 1 or 0 in my database
I have MS SQL Server 2008 and I would like to store formatted text from a rich textbox. Formatted in the sense that I want to store a multiple choice question's formatting, an example would be like this:What is 2 + 2?
4 6 2 8
Then when I retrieve it from the SQL database it saves its formatting.
I have 2 tables A and B. Table A has a text field, fundIDs with comma delimited values like 23,44,55 etc. I would like to select all the records in table B whose ID matches the values in the fundIDs field from only one record in Table A. So, I need a function which first gets 1 table A record and uses the fundIDs field values to query and return all the matching records from Table B. I don't know how to parse and query in sql
[code]....
I have 3 Labels : Label1, Label2, Label3.
I want to add Text on this Labels from database.
I'd like to do it like that:
[Code]....
But it doesnt work (thats just pseudo-code;-)). It is possible to do it like that with value i ?