C# Delight

vb.net

2009-11-02T16:27:00.001-08:00

ADO error message

2009-11-02T15:33:00.000-08:00

I found these messages on the internet and really help me to figure out whats the cause of the error.

'Case -2147483647 '~ Not implemented
'Case -2147483646 '~ Ran out of memory
'Case -2147483645 '~ One or more arguments are invalid
'Case -2147483644 '~ No such interface supported
'Case -2147483643 '~ Invalid pointer
'Case -2147483642 '~ Invalid handle
'Case -2147483641 '~ Operation aborted
'Case -2147483640 '~ Unspecified error
'Case -2147483639 '~ General access denied error
'Case -2147483638 '~ The data necessary to complete this operation is not yet available.
'Case -2147467263 '~ Not implemented
'Case -2147467262 '~ No such interface supported
'Case -2147467261 '~ Invalid pointer
'Case -2147467260 '~ Operation aborted
'Case -2147467259 '~ Unspecified error
'Case -2147467258 '~ Thread local storage failure
'Case -2147467257 '~ Get shared memory allocator failure
'Case -2147467256 '~ Get memory allocator failure
'Case -2147467255 '~ Unable to initialize class cache
'Case -2147467254 '~ Unable to initialize RPC services
'Case -2147467253 '~ Cannot set thread local storage channel control
'Case -2147467252 '~ Could not allocate thread local storage channel control
'Case -2147467251 '~ The user supplied memory allocator is unacceptable
'Case -2147467250 '~ The OLE service mutex already exists
'Case -2147467249 '~ The OLE service file mapping already exists
'Case -2147467248 '~ Unable to map view of file for OLE service
'Case -2147467247 '~ Failure attempting to launch OLE service
'Case -2147467246 '~ There was an attempt to call CoInitialize a second time while single threaded
'Case -2147467245 '~ A Remote activation was necessary but was not allowed
'Case -2147467244 '~ A Remote activation was necessary but the server name provided was invalid
'Case -2147467243 '~ The class is configured to run as a security id different from the caller
'Case -2147467242 '~ Use of Ole1 services requiring DDE windows is disabled
'Case -2147467241 '~ A RunAs specification must be \ or simply 0x80004018 -2147467240 The server process could not be started. The pathname may be incorrect.
'Case -2147467239 '~ The server process could not be started as the configured identity. The pathname may be incorrect or unavailable.
'Case -2147467238 '~ The server process could not be started because the configured identity is incorrect. Check the username and password.
'Case -2147467237 '~ The client is not allowed to launch this server.
'Case -2147467236 '~ The service providing this server could not be started.
'Case -2147467235 '~ This computer was unable to communicate with the computer providing the server.
'Case -2147467234 '~ The server did not respond after being launched.
'Case -2147467233 '~ The registration information for this server is inconsistent or incomplete.
'Case -2147467232 '~ The registration information for this interface is inconsistent or incomplete.
'Case -2147467231 '~ The operation attempted is not supported.
'Case -2147418113 '~ Catastrophic failure
'Case -2147024891 '~ General access denied error
'Case -2147024890 '~ Invalid handle
'Case -2147024882 '~ Ran out of memory
'Case -2147024809 '~ One or more arguments are invalid
'Case -2147217920 '~ Invalid accessor
'Case -2147217919 '~ Creating another row would have exceeded the total number of active rows supported by the rowset
'Case -2147217918 '~ Unable to write with a read-only accessor
'Case -2147217917 '~ Given values violate the database schema
'Case -2147217916 '~ Invalid row handle
'Case -2147217915 '~ An object was open
'Case -2147217914 '~ Invalid chapter
'Case -2147217913 '~ A literal value in the command could not be converted to the correct type due to a reason other than data overflow
'Case -2147217912 '~ Invalid binding info
'Case -2147217911 '~ Permission denied
'Case -2147217910 '~ Specified column does not contain bookmarks or chapters
'Case -2147217909 '~ Some cost limits were rejected
'Case -2147217908 '~ No command has been set for the command object
'Case -2147217907 '~ Unable to find a query plan within the given cost limit
'Case -2147217906 '~ Invalid bookmark
'Case -2147217905 '~ Invalid lock mode
'Case -2147217904 '~ No value given for one or more required parameters
'Case -2147217903 '~ Invalid column ID
'Case -2147217902 '~ Invalid ratio
'Case -2147217901 '~ Invalid value
'Case -2147217900 '~ The command contained one or more errors
'Case -2147217899 '~ The executing command cannot be canceled
'Case -2147217898 '~ The provider does not support the specified dialect
'Case -2147217897 '~ A data source with the specified name already exists
'Case -2147217896 '~ The rowset was built over a live data feed and cannot be restarted
'Case -2147217895 '~ No key matching the described characteristics could be found within the current range
'Case -2147217894 '~ Ownership of this tree has been given to the provider
'Case -2147217893 '~ The provider is unable to determine identity for newly inserted rows
'Case -2147217892 '~ No nonzero weights specified for any goals supported, so goal was rejected; current goal was not changed
'Case -2147217891 '~ Requested conversion is not supported
'Case -2147217890 '~ lRowsOffset would position you past either end of the rowset, regardless of the cRows value specified; cRowsObtained is 0
'Case -2147217889 '~ Information was requested for a query, and the query was not set
'Case -2147217888 '~ Provider called a method from IRowsetNotify in the consumer and NT
'Case -2147217887 '~ Errors occurred
'Case -2147217886 '~ A non-NULL controlling IUnknown was specified and the object being created does not support aggregation
'Case -2147217885 '~ A given HROW referred to a hard- or soft- deleted row
'Case -2147217884 '~ The rowset does not support fetching backwards
'Case -2147217883 '~ All HROWs must be released before new ones can be obtained
'Case -2147217882 '~ One of the specified storage flags was not supported
'Case -2147217881 '~ The comparison operator was invalid
'Case -2147217880 '~ The specified status flag was neither DBCOLUMNSTATUS_OK nor DBCOLUMNSTATUS_ISNULL
'Case -2147217879 '~ The rowset cannot scroll backwards
'Case -2147217878 '~ Invalid region handle
'Case -2147217877 '~ The specified set of rows was not contiguous to or overlapping the rows in the specified watch region
'Case -2147217876 '~ A transition from ALL* to MOVE* or EXTEND* was specified
'Case -2147217875 '~ The specified region is not a proper subregion of the region identified by the given watch region handle
'Case -2147217874 '~ The provider does not support multi-statement commands
'Case -2147217873 '~ A specified value violated the integrity constraints for a column or table
'Case -2147217872 '~ The given type name was unrecognized
'Case -2147217871 '~ Execution aborted because a resource limit has been reached; no results have been returned
'Case -2147217870 '~ Cannot clone a command object whose command tree contains a rowset or rowsets
'Case -2147217869 '~ Cannot represent the current tree as text
'Case -2147217868 '~ The specified index already exists
'Case -2147217867 '~ The specified index does not exist
'Case -2147217866 '~ The specified index was in use
'Case -2147217865 '~ The specified table does not exist
'Case -2147217864 '~ The rowset was using optimistic concurrency and the value of a column has been changed since it was last read
'Case -2147217863 '~ Errors were detected during the copy
'Case -2147217862 '~ A specified precision was invalid
'Case -2147217861 '~ A specified scale was invalid
'Case -2147217860 '~ Invalid table ID
'Case -2147217859 '~ A specified type was invalid
'Case -2147217858 '~ A column ID was occurred more than once in the specification
'Case -2147217857 '~ The specified table already exists
'Case -2147217856 '~ The specified table was in use
'Case -2147217855 '~ The specified locale ID was not supported
'Case -2147217854 '~ The specified record number is invalid
'Case -2147217853 '~ Although the bookmark was validly formed, no row could be found to match it
'Case -2147217852 '~ The value of a property was invalid
'Case -2147217851 '~ The rowset was not chaptered
'Case -2147217850 '~ Invalid accessor
'Case -2147217849 '~ Invalid storage flags
'Case -2147217848 '~ By-ref accessors are not supported by this provider
'Case -2147217847 '~ Null accessors are not supported by this provider
'Case -2147217846 '~ The command was not prepared
'Case -2147217845 '~ The specified accessor was not a parameter accessor
'Case -2147217844 '~ The given accessor was write-only
'Case -2147217843 '~ Authentication failed
'Case -2147217842 '~ The change was canceled during notification; no columns are changed
'Case -2147217841 '~ The rowset was single-chaptered and the chapter was not released
'Case -2147217840 '~ Invalid source handle
'Case -2147217839 '~ The provider cannot derive parameter info and SetParameterInfo has not been called
'Case -2147217838 '~ The data source object is already initialized
'Case -2147217837 '~ The provider does not support this method
'Case -2147217836 '~ The number of rows with pending changes has exceeded the set limit
'Case -2147217835 '~ The specified column did not exist
'Case -2147217834 '~ There are pending changes on a row with a reference count of zero
'Case -2147217833 '~ A literal value in the command overflowed the range of the type of the associated column
'Case -2147217832 '~ The supplied HRESULT was invalid
'Case -2147217831 '~ The supplied LookupID was invalid
'Case -2147217830 '~ The supplied DynamicErrorID was invalid
'Case -2147217829 '~ Unable to get visible data for a newly-inserted row that has not yet been updated
'Case -2147217828 '~ Invalid conversion flag
'Case -2147217827 '~ The given parameter name was unrecognized
'Case -2147217826 '~ Multiple storage objects can not be open simultaneously
'Case -2147217825 '~ The requested filter could not be opened
'Case -2147217824 '~ The requested order could not be opened
'Case -2147217823 '~ Bad tuple
'Case -2147217822 '~ Bad coordinate
'Case -2147217821 '~ The given axis was not valid for this Dataset
'Case -2147217820 '~ One or more of the given cell ordinals was invalid
'Case -2147217819 '~ The supplied columnID was invalid
'Case -2147217817 '~ The supplied command does not have a DBID
'Case -2147217816 '~ The supplied DBID already exists
'Case -2147217815 '~ The maximum number of Sessions supported by the provider has already been created. The consumer must release one or more currently held Sessions before obtaining a new Session object
'Case -2147217806 '~ The index ID is invalid
'Case -2147217805 '~ The initialization string does not conform to specification
'Case -2147217804 '~ The OLE DB root enumerator did not return any providers that matched an of the SOURCES_TYPEs requested
'Case -2147217803 '~ The initialization string specifies a provider which does not match the currently active provider.
'Case -2147217802 '~ The specified DBID is invalid
'Case -2147217814 '~ Invalid trustee value
'Case -2147217813 '~ The trustee is not for the current data source
'Case -2147217812 '~ The trustee does not support memberships/ collections
'Case -2147217811 '~ The object is invalid or unknown to the provider
'Case -2147217810 '~ No owner exists for the object
'Case -2147217809 '~ The access entry list supplied is invalid
'Case -2147217808 '~ The trustee supplied as owner is invalid or unknown to the provider
'Case -2147217807 '~ The permission supplied in the access entry list is invalid
'Case -2147217801 '~ The ConstraintType was invalid or not supported by the provider.
'Case -2147217800 '~ The ConstraintType was not CONSTRAINTTYPE_FOREIGNKEY and cForeignKeyColumns was not zero
'Case -2147217799 '~ The Deferrability was invalid or the value was not supported by the provider
'Case -2147217792 '~ The MatchType was invalid or the value was not supported by the provider
'Case -2147217782 '~ The UpdateRule or DeleteRule was invalid or the value was not supported by the provider
'Case -2147217781 '~ The pConstraintID did not exist in the data source
'Case -2147217780 '~ The dwFlags was invalid
'Case -2147217779 '~ The rguidColumnType pointed to a GUID that does not match the object type of this column or this column was not set
'Case -2147217778 '~ The requested URL was out-of-scope
'Case -2147217776 '~ The provider could not drop the object
'Case -2147217775 '~ There is no source row
'Case -2147217774 '~ The OLE DB object represented by this URL is locked by one or more other processes
'Case -2147217773 '~ The client requested an object type that is only valid for a collection
'Case -2147217772 '~ The caller requested write access to a read-only object
'Case -2147217771 '~ The provider could not connect to the server for this object
'Case -2147217770 '~ The provider could not connect to the server for this object
'Case -2147217769 '~ The attempt to bind to the object timed out
'Case -2147217768 '~ The provider was unable to create an object at this URL because an object named by this URL already exists
'Case -2147217767 '~ The provider could not drop the object
'Case -2147217766 '~ The provider was unable to create an object at this URL because the server was out of physical storage

Dataset to Datarow in c#

2009-03-23T12:15:00.000-07:00

dsStyle as my Dataset
row for my Datarow.

Dataset dsStyle = // already assigned some records then i want it to get those data display to the page. also if you want to put it on the option box you can do that also.

results.Append("All Style");
foreach (DataRow row in dsStyle.Tables[0].Rows)
{
results.Append("" + DB.RowField(row, "CATEGORYCODE").ToString() + "");
}

How to remove the last Letter or char in c#

2009-03-18T15:56:00.001-07:00

How to get the Current IP in c#

2009-03-18T14:46:00.000-07:00

string m_currentIP = HttpContext.Current.Request.UserHostAddress;

Hope this help.. :)

Redirection url onclick event using javascript

2009-03-11T15:33:00.000-07:00

You'll just need to have an event onclick and pleace the function redirectURL.

function redirectUrl()
{
window.location = "http://ehamak.blogspot.com";
}

Hope this help..:)

How to get the available fonts style on the server in vb.net

2009-03-11T15:31:00.002-07:00

Get all available fonts on the server.

Private Sub LoadFonts()
Dim installed_fonts As New InstalledFontCollection
Dim font_families() As FontFamily = installed_fonts.Families()

' Display the font families.
For Each font_family As FontFamily In font_families
' font_family.Name & ", "
ddlFontName.Items.Add(font_family.Name)
Next font_family
End Sub

Hope this help you.

How to validate textbox to numeric values only vb.net

2009-03-11T15:31:00.001-07:00

This will validate inputed value on the textbox is not a numeric and set it to empty textbox.

If Not (IsNumeric(Me.txtY.Text)) Then
Me.txtY.Text = String.Empty
Me.txtY.Focus()
End If

Hope this will help you to validate you textbox control.

Show message box in vb.net

2009-03-11T15:29:00.000-07:00

This is just sample messagebox code using vb.net language. I place this in the onclick button and prompt it during save. the code looks like this one.

Dim rstResult As DialogResult

rstResult = MessageBox.Show("Are you sure want to update?", _
"Business Card", _
MessageBoxButtons.YesNo, _
MessageBoxIcon.Question)

If rstResult = DialogResult.Yes Then
// do some action here. is the user selected Yes and nothing is no.
End If

How to split in c#

2009-03-11T14:23:00.002-07:00

private void SplitNo()
{
// string seperated by colons ';'
string items = "1--->;2--->;3--->;4--->;5--->";
string[] collection = new string[4];
// define which character is seperating fields
collection = items.Split(';');

for (int x = 0; x < collection.Length; x++) { Response.Write(collection[x] + "
");
}
}
-----------------------------------------------------------
Sample Output:

1--->
2--->
3--->
4--->
5--->

How to store and retrive cookie in c#

2009-03-11T14:23:00.001-07:00

cookie["Name"] = "Kiko Salva"
cookie.Expires = DateTime.Now.AddYears(1);
Response.Cookies.Add(cookie);

// To retrieve

lblName.Text = "Cookie Created.";
lblName.Text += "New Customer: " + cookie["Name"];

How to remove char and leave number in c#

2009-03-11T14:22:00.001-07:00

Regex.Replace Method

Within a specified input string, replaces strings that match a regular expression pattern with a specified replacement string.

ex.
// assigning value into the string xvalue.
string xvalue = "199 RemoveText";

// removing character and leave numbers
decimal value = (decimal)Regex.Replace(xvalue, @"[\D]", "");

//As the result:
199

How to create a folder and check if exist on the directory in c#

2009-03-11T14:18:00.001-07:00

First i need to create a form with 1 textbox, button and a label in my page. I named the textbox as txtFolderName, button btnCheckandCreate and the label as lblMessage so now, I need to put the event in my button on click.. on the onclick eventon the button i need to put the code.

protected void btnCheckandCreate _Click(object sender, EventArgs e)
{
lblMessage.Text = "";

if (!System.IO.Directory.Exists(@"c:\" + txtFolderName.Text.ToUpper() + ""))
{
System.IO.Directory.CreateDirectory(@"c:\" + txtFolderName.Text.ToUpper() + "");
lblMessage.Text = txtFolderName.Text + " Folder successfully created.";
}
else
{
lblMessage.Text = txtFolderName.Text + " is not available";
}
}

How to get current Page in c#

2009-03-11T14:14:00.000-07:00

Try this one.

string url = Page.Request.Path;

hope this help.

.net codes

2009-02-10T17:49:00.000-08:00

Talk about standard coding, samples , techniques and many more.
watch out for new post.