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'
I have some code that splits a session into strings by a -
My session looks something like this 123-456-789- and I split it like this
Dim MyString As String() = Session("MySession").Split("-"C)
And i've got a some code like this
Dim x as Integer
For x = 0 to MyString - 1
Response.write("Ref: " & MyString(x) & "<br>")
Next
This writes the code like this
Ref: 123
Ref: 456
Ref: 789
Ref:
So it's adding an extra Ref where it shouldn't be because there is no data after the last -
Is there a way to stop this adding in the extra one?
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 having problem in adding the variable into linkedlist.
<div id="one" style="display: block; ">
<asp:ListView ID="ListView1" runat="server" DataSourceID="SqlDataSource1"
GroupItemCount="3" OnItemCommand="ListView1_OnItemCommand">
<EmptyItemTemplate> <td runat="server" /> </EmptyItemTemplate> <ItemTemplate>
<td runat="server" style="">
<asp:Label ID="foodnameLabel" runat="server" Text='<%# Eval("foodname") %>' />
<br /> <asp:Label ID="foodimgLabel" runat="server" Text='<%# Eval("foodimg") %>' />
<br /> <asp:Label ID="priceLabel" runat="server" Text='<%# String.Format("{0:0.00}", Eval("price")) %>' />
<br /> <asp:Label ID="stallidLabel" runat="server" Text='<%# Eval("stallid") %>' Visible="false"/>
<br />
<asp:Button ID="addtocart" runat="server" Text='Add to cart' CommandName="addtocart" CommandArgument='<%# Eval("foodname")+ " " + Eval("price")%>' />
</td> </ItemTemplate> <AlternatingItemTemplate> <td runat="server" style="">
<asp:Label ID="foodnameLabel" runat="server" Text='<%# Eval("foodname") %>' />
<br /> <asp:Label ID="foodimgLabel" runat="server" Text='<%# Eval("foodimg") %>' />
<br /> <asp:Label ID="priceLabel" runat="server" Text='<%# String.Format("{0:0.00}", Eval("price")) %>' />
<br /> <asp:Label ID="stallidLabel" runat="server" Text='<%# Eval("stallid") %>' Visible="false"/>
<br /> <asp:Button ID="addtocart" runat="server" Text='Add to cart' CommandName="addtocart" CommandArgument='<%# Eval("foodname")%>' />
</td> </AlternatingItemTemplate> <EmptyDataTemplate> <table runat="server" style="">
<tr> <td> No data was returned.</td> </tr> </table> </EmptyDataTemplate> <LayoutTemplate>
<table runat="server"> <tr runat="server"> <td runat="server">
<table ID="groupPlaceholderContainer" runat="server" border="0" style="">
<tr ID="groupPlaceholder" runat="server"> </tr> </table> </td> </tr>
<tr runat="server"> <td runat="server" style="">
<asp:DataPager ID="DataPager1" runat="server" PageSize="12">
<Fields> <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowNextPageButton="False" ShowPreviousPageButton="False" />
<asp:NumericPagerField />
<asp:NextPreviousPagerField ButtonType="Button" ShowLastPageButton="True" ShowNextPageButton="False" ShowPreviousPageButton="False" />
</Fields> </asp:DataPager> </td> </tr> </table> </LayoutTemplate> <GroupTemplate>
<tr ID="itemPlaceholderContainer" runat="server">
<td ID="itemPlaceholder" runat="server"> </td> </tr> </GroupTemplate>
</asp:ListView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:foodcourtConnectionString %>" SelectCommand="SELECT [foodname], [foodimg], [price], [stallid] FROM [foodtbl] WHERE ([stallid] = @stallid)"> <SelectParameters>
<asp:QueryStringParameter DefaultValue="1" Name="stallid" QueryStringField="stallid" Type="Decimal" /> </SelectParameters> </asp:SqlDataSource> </div>
How can I add all the variable (foodname, price) into linkedlist when I click addtocart button?
I am creating a static variable and adding to session.This variable has value that is user specific. Now I am getting a problem with this users are complaining that they are getting values that should be another users. It's like a mix up with session. Could this be because of static variable declaration?
View 2 RepliesI 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 textbox where data will be entered by user without any postback. I need to add the data to a variable or any hidden variable or i need to store data from all the controls on th epage in which user entered to a variable this controls in which user enters the data becomes visible on button click i mean a post back happen...
View 1 RepliesI have this string variable:
[Code]....
I want to pass the string MON to the sql query: to replace trunc(sysdate) .
[Code]....
<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 Replies
