I have defined a column in a table I have in an SQL database as being a Time variable and not DateTime. How do I convert the time data that I get from my table into a text string using C#?
View 6 Replies
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 Repliesi create a stored procedure that would out the following time format
09 hr(s): 30 min(s)
but i want to convert it to a decimal. (eg 9.50)
I was trying this method:
ALTER procedure [dbo].[timetodecimal] @hms varchar(8)
I am selecting time from dropdownlist. and want to convert it in datetime and store it in database. When I am converting it to Datetime using following statement.
DateTime start_Time = Convert.ToDateTime(start_ts);
but it is showing as : date:12:00:00AM
How would I convert an empty textbox.text to null when updating/inserting using an SqlCommand? I've got this to populate the textbox:
If IsDBNull(dr("data")) Then
TextBox1.Text = ""
Else
TextBox1.Text = dr("data")
End If
Here's the SET of the SqlCommand:
[Code]....
I am working on a website hosted with GoDaddy, SQL Server 2005. I have a table in my SQL Server database with a full-text index. On my website, a user can type in search terms and the terms are then passed to a stored procedure in the database which performs the search. The first search takes about 45 seconds to get results. Subsequent searches return results immediately. I found a description of this problem in a Microsoft knowledgebase article:http://support.microsoft.com/kb/915850/en-usGoDaddy tech support says I need to purchase a dedicated server to make the changes suggested in this article.Surely there is some other solution. Does anyone know how to avoid this delay without changing the server configuration?
View 1 RepliesI got a variable of type System.Drawing.Image and need to convert it to a variable of type byte so I can store the image in the database. Can someone show me how to do that in VB.NET code.
View 2 RepliesI have multiple sqlcommands with about 30 to 50 different parameters added like below: sqlcmd.parameters.add("@var1", sqldbtype.varchar).value = var1 My problem is that I keep hitting the error "Failed to convert String to Int32". Its annoying as I have to go through each and every variable and set it to a static one value, test it, and keep going until I find the offending variable. Is there a easy way of finding out which variable actually caused the error?
View 4 RepliesI have several web forms which use a GridView linked to a DataSource control which is defined at design time as follows:
<cc1:pgsqldatasource
id="dsStates"
runat="server"
connectionstring="<%$ ConnectionStrings:PgSqlConnection %>"
oldvaluesparameterformatstring="Original_{0}"
providername="<%$ ConnectionStrings:PgSqlConnection.ProviderName %>" >
</cc1:pgsqldatasource>
As you can see, the connectionstring parameter is defined to a specific connection string name and I need to be able to set such a parameter to a different value, for example, to a session variable content.
I am storing a custom "Organisation" object as a session variable. One of the properties of the Organisation object is "OrganisationID" (integer). I have a DataSource that requires a parameter value to run, and I want to use a SessionParameter to populate this. In a previous version, I stored the OrganisationID directly as a session variable. In that case, I could easily access it like this:
[Code]....
However, how do I now access the OrganisationID property of an "Organisation" type session variable (called "Organisation")? I have tried this, which does not seem to work: <asp:SessionParameter Name="OrganisationID" SessionField="Organisation.OrganisationID" Type="Int32" />
How could I go about having a client in various time zones select a date and time in their web browser and save it as utc time in my sql database? This date is a date in the future, so whether or not the date is in daylight savings time could change so I'll need to account for that.
The site is a asp.net c# site.
I have a datetime column in my table. It has a value like this for example: 4/27/2010 7:34:00 PM. I would like to display the time part of the column in military time. So this datetime column would appear as: 4/27/2010 19:34
Is this possible?
I have what I think is a weird issue. I send text from one page to another via Session Variable. When page 2 loads, the text box has the session text set, but if the user changes the text and clicks the button, the SQL database is update with the original session text. If I remove the redirect from the page 2 button_Click method, then, the page refreshes with the textbox reverting to the session text and thr SQLDataSource has the session text added to it.
[Code]....
I was wondering if anyone knows of a good login stored procedure that can be freely used and features login limits and so on (basically a good one) With my limited SP knowledge, I've tried to create one myself, I haven't completed it yet as I'm not sure on how to compare the last login attempt time against the current time (it's in the comments).
P.S. I had to write this in notepad.
[Code]....
I'm trying to set the "time" value stored in a date time field, in other words, I want to change the value
05-13-2010 08.47.34
to
05-13-2010 00.00.00
or
05-13-2010 23.59.59
What statement would I use to accomplish this?
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 have Resume .doc or .docx ,Here My requirement is Convert Word files to String (Text) Formate(String []). Without using microsoft.office.interop because s not working in Servers?
View 1 Replies I have a DropDownList with a list of value.
I need in my code USE the value selected by the User in the DropDownList AS INT DataType (numeric).
At the moment I am using this code below (CONVERTING DATATYOES).
Script work just fine.
But I would like to know if exists an alternative way to do it.
[code]....
Is it possible to use a database name as a variable in a SP?I use a separate database for each custromer.I also use a master database that keeps database name, ID, and Password.I then want to generate an SQL select against the appropriate Database based on the userID and password (for an XML REsponse)is this possible?Set @DBName as varchar(50)Select * from @DBName.dbo.tablename where bla bla blaNote: that the actual select is about 150 lines with multiple sub selects
View 3 RepliesI'm trying to change a row in detailsview based on a value in a coloum. Exactly the same as this example but in Detailsview: [URL]
View 3 RepliesI gonna build a custom control that derive from DevExpress.Web.ASPxEditors.ASPxTextBox and add 2 features on top of this base class controls.
1. Convert all input text to uppercase.
2. No allow to input certain special character.
Here, I able to provide 2nd feature but hv no idea how to do for the 1st. Below is my code in the custom control class.
[Code]....
I have a products table with 3 fields name, price and quantity, I need to fill a datatable with those 3 fields and using a foreach build a chain. I build my chain currently using a datagrid with my following code
this code work good.
string item_name;
string amount;
string quantity;
[Code]....
but I like to form my chain directly from datatable, not rely on a datagrid.
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 RepliesWould anyone know how to pass a variable to SqlDataAdapter. Here is my code.
TextBox1.Text = 1
Dim textboxval
As
String
textboxval = TextBox1.Text
connection.Open()Using connection
As
New SqlConnection("Data Source=CHRIS-PCSQLEXPRESS;Initial Catalog=TorGHL;Integrated Security=True")
Dim dapubcb
As
New SqlDataAdapter("SELECT [BarName], [MenuSubId], [Address], [PhoneNo], [BarURL], [Email]
[BarDescription], [Id], [bg_long], [bg_lat] FROM [BarDetails] WHERE [MenuSubId] = texboxval ", connection)
I have an objectDataSource which uses my stored procedure GetNotifications
And my GridView is bound to that objectDataSource
the only problem is that my stored procedure requires the variable @UserName and then returns the values for that username, but I do not know how to pass the variable to the objectDataSource, does anyone know the code for this?
I can get userName from HttpContext.Current.User.Identity.Name but how do I pass that to the objectDataSource?
