I want to retrieve the text as 'Sunday', 'Monday' when the day values is given as an integer such as 1,2,...etc...
Without using swich-case, how do I do this using DayOfWeek enum?
In MySql, how can I retrieve all records since last Monday?
View 2 RepliesI have a textbox AND 3 checkboxes; checkbox1, checkbox2, checkbox3
In textbox we have 1,2,3
If I type in textbox1 = 1,2 then
checkbox1 and checkbox2 will be checked and checkbox3 will remain unchecked.....
How to do this in vb.net
Some ids are pulled out from the XML field of a certain User Profile . Those ids have their text values stored in a SQL table.
What is the best way to map that xml list to the SQL table in order to populate a dropdown list which contains ids from the XML list and text values from the SQL table?
i have assigned few values to 10 dynamically created text fields
eg : string abc = "<input type="text" id="field"+i+" " />";
above string i have displayed in front end thrgh response.write i.e by assigning string abc to viewstate. also i am tryin to genetrate above input fields from database , so i have to make it dynamic in a loop. so when a user updates any of those dynamically created fields i need to retreive those values in a loop
something like this :
field1.text , field2.text ......so on till fieldn.text ....i want to assign these values to array
like :
string[] arr1 = new string[nooffields];
arr1[i] = fieldi.text;
i crate 5 textbox dinamically in the form with this code :
[Code]....
but when i try to find textbox values it dosent work where is my problem?
I've created 3 buttons, first button is to load the values in textboxes added to placeholder. Then button2 is to extract the data from button 1 and display out. Now the 3rd step, I want to edit the values from the textboxes, after edit, how do I grab and display out the new values in label and textboxes?
Code:
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim x As Integer = 1
Dim message As String
[code]....
I had a stored procedure as below. I'm trying to return an integer of differences btw 2 integers. In SQL Server 2008, the stored procedure works just fine, it shows me the value I wanted in @intdiff.
But when I try to retrieve it with my webservice, it only return value 0. My webservice coding as below. Could any1 come accross this before?
Stored Procedure
[Code]....
Web Service
[Code]....
I have integer 363 for example.
Any method to make it 360 or 365?
I have the following stored procedure
[Code]....
MOVE_MOD is defined as a float.
Yet within Dataclasses.designer.cs the function gets added as:
[Code]....
Naturally this is causing some issues as my C# code needs to handle decimal values. If I try to manually change the designer code to use floats, I get the following error
'System.Single' is not a valid return type for a mapped stored procedure method.
i dont understand where is the problem with my code. i need to pass the request_id to another page but it is always passing the integer values as 0. whenever it comes to pass integer values it is passing it as 0 even if i perform conversion of string to int.
[Code]....
I want to convert Label text into Integer datatype. I tried by giving Convert.Int32(Label1.Text) and int.Parse(Label1.Text) but I couldn't do Type casting . I am getting error at runtime. I searched in web I couldn't get the solution.
View 1 RepliesI have a @message parameter in SP, user sends an Integer value in that message. For Ex: @message = 'This is, a Test message 500000 and the message ends.'Now i want to get only that 500000 value from this @message param. There is no delimiters for identifying the integer value and in that param contains only one integer value
create procedure st_test (@message varchar (4000), @result int output)
as
begin
//LOGIC for get the interger value
end
If I want to validate that a text box contains an integer greater than or equal to zero. Do I need to use TWO asp:CompareValidator controls: one with a DataTypeCheck operator and one with a GreaterThanEqual operator?
Or is the datatype operator redundant? Can I just use a single validator with the GreaterThanEqual operator (and the type set to Integer)?
I have a text box in which one is supposed to Enter a number .But if a person enters Text I get errors when parsing to integer.
View 4 Repliesi have textbox it should accept only integer or float values..........
View 1 Repliesi have atable:
STDNo nvarchar(6) //student number primary
CID nvarchar(7) //course ID primary
DNo int //Department Number primary
H1 int allow null // Home work 1
H2 int allow null
H3 int allow null
H4 int allow null
H5 int allow null
Q1 int allow null //Quize 1
Q2 int allow null
Q3 int allow null
Q4 int allow null
Q5 int allow null
HE1 int allow null
HE2 int allow null
FExam int allow null // Final Exam
and stored procedure like this:
ALTER procedure [dbo].[AddMonthlyMarks]
(
@STDNo nvarchar(6),
@CID nvarchar(7),
@Dno int =isnull,
@H1 int,
@H2 int,..........................
the Data key name of grid is STDNo the problem is that the instructor this month will add only homework1(h1) for specific student number or to all students and rest of home works and quezies will not entered (Null), to the next month he will enter home work 2 ,etc... i get an error and i think that the null values for others home works in grid make this error caution: in table i check allow null property,the data type is integer How i can convert this null values to integer?
How do I sort a data table based on a particular column which has integer values in ascending order?
I wrote this:
'Sort the datatable based on sequence id leadtable.DefaultView.Sort ="Id" But it doesnt seem to work Datatble is defined as:
[Code]....
I am getting int values from the stored procedure. But when i bind this datasource with the gridview i am seeing the values being converted into float. i am using Text='<% # Bind("Quantity") %' I wanna that to be displayed as int, with out zero'seg: let the value be 233, when i bind that its getting displayed as 233.00
View 1 RepliesThis is not straight forward to explain but basically i want to only get the current weeks data in a table, i.e. if its say thurs or fri and i run the report i just want to filter from the previous Monday every time.
I dont want to use a parameter because there is another table that i want to see ALL data from way back.
So, if i ran the report today (28th april), the table would show Monday (26th), Tuesday (27th) and today Wed (28th).
I have a text box were people will submit a large amoyunt of text to a field in a database. The text is set out multi line in paragraphs with returns. When the text is saved to the database it saves it as a continuous line of text. how do i save and retrieve it with the returns included.
View 2 RepliesI want to split a string that taking both string and integer values like (Cmp_12). I want to use them in Separately.
View 4 RepliesI'm trying to make a dynamic search page, for a table of 121 fields. It'll start by check boxes to check the fields where to search, and check boxes to check the fields in which the results will be shown in. I'm having an issue with taking back values from the text boxes that I add to the page, and I don't know what is the problem.
[Code]....
How to disable Sunday in asp.net calendar control? I am using C#.
View 1 RepliesI'm using the date picker and I need to know how (or if it's even possible), to select a date, and based on the date, have the actual query use the week the date was in and return all the records from that week (Sunday through Saturday)
Like - if I pick 8/24/2010 - it returns a date range of 8/22 through 8/28 I'd also like to display the date range in the report, somehow