I am trying to add a string to an SQL statement based on whether an asp:checkbox is checked. Below is what I have, and it isnt working.
I know I could set comm inside the if statement, but I imagine there is a way just to add a variable string to the SQL.
Quote:
string IndCBSQL;
if (iIndividualsCheckBox.Checked)
{
IndCBSQL = "AND CMMaster.CONSTTYPE LIKE 'Individual'";
[code].....
I have a value in string i want to use that value on next page.
How can i access it with previous page property?
Or is there any other way to fetch value store in string variable on next page?
How to display the string data stored in a string[] variable into gridview?
View 9 RepliesI have this string variable:
[Code]....
I want to pass the string MON to the sql query: to replace trunc(sysdate) .
[Code]....
Ok, so it's easy in VB, but I can't figure it out in C#:
SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM tblUsers WHERE username = '" & username & "'", cn);
This throws
CS0019: Operator '&' cannot be applied to operands of type 'string' and 'string'
<img src="http://track.opicle.com/aff_l?offer_id=2193&adv_sub=LEAD_ID" width="1" height="1" />
var x ;
x Should be replace at the place of LEAD_ID
<img src="http://track.opicle.com/aff_l?offer_id=2193&adv_sub=x" width="1" height="1" />
Meas var x will replace at the place of Lead_ID
i have to assign value to bit varibale.so i declared bool variable . i am assigning string value to a bool variable . so i converted to boolean & assigned.Its not converting to bool..How to assign string value to bit variable.?i am getting error.Object reference not set to an instance of an object
[Code]....
I need to convert a string to http url.The way i have to do this is--I have to retriew a value from database and convert it into a sharable http url in Asp.net C#.
View 9 RepliesI want to get div content like text box,label gridview HTML tag into string variable .How to get ?
View 5 RepliesI have a page the retieves transaction data from PayPal. The data is retrieved as a string of text. I need to break down the string and save parts of it to my database. I have justed a plain string in my test to see if my code works. I have converted some working VB code into C# but I am getting the errors when trying to Response.Write the different parts. The Error message says that I am trying to use the string variable before I have assigned a value to it.
[Code]....
i have a master page and one content page. In content page i have a textarea for get value from user. i don't want to make it asp control using add runat = server. without adding runat server i want to get value of textarea in a string variable which is defined in code behind file of my page using c#
In short i want to get value of Html control in code behind file using c#
I am using asp.net and C#. I want to send mail to my user in HTML format, I have the content in HTML format let say like this
<table style="width:100%;">
<tr>
<td style="width:20%; background-color:Blue;"></td>
<td style="width:80%; background-color:Green;"></td>
</tr>
</table>
Now I am unable to assign this to a string variable, so that I could send it as a mail. how can I bind this whole HTML content into a varibale.
I have variable like:
string title = string.empty; My need is that whatever string is passed to it I have to display the content inside a div with in a doublequotes .So I have written something like:
<div>"+ title +@"</div>
But how to add the doublequotes here? So that it will display like :
"How to add doublequotes"
is there a way i can get the role in a string variable using the below commands....
System.Security.Principal.WindowsIdentity wi = System.Security.Principal.WindowsIdentity.GetCurrent();
System.Security.Principal.WindowsPrincipal wp = new System.Security.Principal.WindowsPrincipal(wi);
i need this for
FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(1, // version
UserName.Text, // user name
DateTime.Now, // creation
DateTime.Now.AddMinutes(60),// Expiration
false, // Persistent
role); // User data
as string role= wp.IsInRole();
but this is not right
I have written below code to check for blank value in my textbox but its generating compilation Error.
my code in javascript:
function checkTextboxNotFilled(txtbox) {
var txtb = document.getElementById("<%= " + txtbox + ".ClientID %>");
if (GetFormattedString(txtb.value) == "") {
return true ;
}
else {
return false ;
}
}
error:
'string' does not contain a definition for 'ClientID' and no extension method 'ClientID' accepting a first argument of type 'string' could be found (are you missing a using directive or an assembly reference?)
I am calling it like this : checkTextboxNotFilled("MytextboxName")
it still does not work, the user writes appendix then press OK in Login, nothing happens
here is the login (vb.net)
Partial Class login
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Session("passcode") = TextBox1.Text
Response.Redirect("Default.aspx")
End Sub
End Class
and here is the default page C#
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["passcode"] == "appendix")
{
Response.Write("OK !");
}
else
{
Response.Redirect("login.aspx");
}
}
}
i have the following variable:
[Code]....
I have a column in a table within my SQL database that is specified as a time variable. Not DateTime or Date, but just Time. So, I need to know how to convert a text string into the format that would be accepted for entry in the Time column of a table in SQL. I know how to convert dates, but not time.
View 4 RepliesHow to set colModel property of jqGrid dynamically? I want the grid to show only 3 columns when a customer log's in and 5 column's when admin log's in. How to pass colModel in a string variable in javascript?
View 1 Repliesis it possible to get the result of an action into a string variable
I need something like this:
public ActionResult Do()
{
var s = this.Index().GetStringResult();
...
}
i have two clock times in my DB as varchar datatype.. i loaded it from db as varchar itself. in C# i have assigned this value to a datetime variable.. how can i get the time from the datetime variable without changing it into a string.
View 4 RepliesHow would I take a text box value and use it in the query string on submit? I'd like it to start as this,
/News?favorites=True
and end up something like this after the user enters in a search and clicks search.
/News?query=test&favorites=True
The controller action looks like this
public ActionResult Index(string query,bool favorites)
{
//search code
}
i have 2 ASP pages in first page the user choose the database name and in other page take the database name and change the connection string to other databasehow i can pass a variable from one page to other by button click and how i receive this variable in other page and how to change the connection stringthe connection string is in web.config like this:
<connectionStrings>
<add name="Northwind" connectionString="Provider=sqloledb;Data Source=.;Initial Catalog=Northwind;User Id=sa;Password=sa; Connect Timeout=10"/>
</connectionStrings>
How I can get the content of the web page using asp.net ? I want to store html code of one web site into the string variable how I can do this ? I mean there is web site I need to write a program to get the page and store it into string variable.
View 3 RepliesI need to make an API call to a url giving it a json string in this format (ignore the line numbers, of course):
Code:
1. {
2. "properties": [
3. {
4. "property": "email",
5. "value": "new-email@hubspot.com"
6. },
[Code] ....
I want to create a class with these properties so I can call a method for each record in our database and plug in the email, firstname, etc. I am having trouble with it because of the repetition of "property" each time. In other words, it doesn't fit the mold of this example I found:
Code:
using System;
using System.Web.Script.Serialization;
public class MyDate
{
public int year;
[Code] ....
which produces:
Code:
{
"firstName": "Markoff",
"lastName": "Chaney",
"dateOfBirth": {
"year": 1901,
"month": 4,
"day": 30
}
}