I want to store IP number in a column in db but which column type should I use? Of course I can use string but isn't this a waste of storage space? Can I not store IP nr in another type in db that saves space?
I am developing a asp.net application and i am using SQL Server 2008. I took a IDENTITY column as Record_ID for detail table where i will have trillions of records per year. So just want to ask whats the largest number record id (identity) column can hold and in ASP.NET which data type i should use to handle record id as i am using this id as a reference to update the table data. I don't want to end up being trapped some day.
Any one know any open source user control that is similar to gridtreeview. Basically, I want to show a multi column treeview that when expanded, user can edit certain column values. The columns can have a text box or dropdown etc.
I use this query for my table but it retrives the value for each row. It does not retrieve the size of the column name. I need to know the number of characters occupied in particular column. How do i get this value?
what I need to know is how to show a count of how many users are signed on with a custom sql script, here is what i got that shows total users but not total online
[Code]....
Again this gives a total count but i need a total count of who is online with this setting, and try to keep it in sql statement if possible as i have not yet learned how to use stored procedures.
How to identify the line nr. where the exception has occured and show a piece of code around the exception?I would like to implement a custom exception handler page which would display the stack trace, and I'm looking for the easiest way to accomplish the above. While most of the information is available through the Exception object, the source code information is not available there.
i have a radio button list that on selecting, queries a table and displays data in a textarea. now i'm trying to enhance my code so that the value of the radio button is displayed within the URL. that way i can send users links to content displayed by the radio selection (i.e. articles).
So far i've been able to place the "Article_PK" within the url successfully when the user makes a selection. now i'm just stuck on how to get my databind working again. so basically, i need to read in the value of the "Article_PK" in the url to display the data within the textarea. need someone with some mad coding skills to save the day!
code behind --------
public partial class frm_Articles : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e)[code]......
I have a report which is created using a .rdlc. And populated using a List object. The report when exported to excel has a problem. The numeric colums show up as text and the tooltip in excel says "The number in this cell is formatted as text or preceded by an apostrophe". How can I get the number to show up as numeric?
I'm new to MVC and tries to learn. I will build a small application that checks if I have guessed the right number. How is the correct way of doing this? I can generate a secret number, i'll do that in the model. Is it correct to check if the guessed number and the secret number is a match or not in the model or should I do this in the Control file? How can I count the number of guesses and show previus guesses I have done in the same session?
I have a multiline textbox which can contain only 500 characters. Now i want to show the user the number of characters left as they are typing into the textbox as is the case when we use twitter.
I am using a datatable with different columns. Datatype of each column is Double. Now I want to format that column to Indian positioning number system. e.g(54,36,54,656.00). How can I do this???