I want to encrypt email to 6-8 character alphanumeric string in sql server. Is this possible? Thanks

I looked the event viewer. But didn't found any log.

Sir I am using windows 7. I want to get the details of users to have taken the remote of my PC yesterday. Please help. Thanks in advance.

Hi I want to export Datagridview to excel. I have formatted my datagridview such that he negative values are shown as red, some values are bold and other formatting styles are applied. I want when I export it to Excel then it export with same formatted type. Currently I Am using the below function to export. But unable to export with formatting. private void exportAsExcel() { Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application(); // creating new WorkBook within Excel application Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing); // creating new Excelsheet in workbook Microsoft.Office.Interop.Excel._Worksheet worksheet = null; // see the excel sheet behind the program //Funny app.Visible = true; // get the reference of first sheet. By default its name is Sheet1. // store its reference to worksheet try { //Fixed:(Microsoft.Office.Interop.Excel.Worksheet) worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Sheets["Sheet1"]; worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.ActiveSheet; // changing the name of active sheet worksheet.Name = "Sheet1"; // storing header part in Excel for (int i = 1; i < dgvDetails.Columns.Count + 1; i++) { worksheet.Cells[1, i] = dgvDetails.Columns[i - 1].HeaderText; } worksheet.get_Range("A1", "AZ1").Font.Bold = true; worksheet.get_Range("A1", "A" + (dgvDetails.RowCount + 2).ToString()).Font.Bold = true; // storing Each row and column value to excel sheet for (int i = 0; i < dgvDetails.Rows.Count; i++) { for (int j = 0; j < dgvDetails.Columns.Count; j++) { worksheet.Cells[i + 2, j + 1] = dgvDetails.Rows[i].Cells[j].Value.ToString(); } } } catch (System.Exception ex) { } finally { app.Quit(); workbook = null; app = null; } } Thanks in advance

Hi I want to generate alpha numeric no like this: If I say length is 4 it generates like 0001 0002 0003 --- --- --- 9999 A001 A002 --- --- --- A999 B001 --- --- zzzz Please help Thanks in advance

Could you tell me the approach of using 2 queries with a UNION. Or tell me the syntex how to apply union to get the result. Thanks

Hi My sql query result is

Store month sale purchase
A Jan 2000 150

I want my result like

Store month Expense value
A Jan Sale 2000
A Jan Purchase 150

Please help me how to get this result using sql query. Thanks in advance

Hi I want to bind my combobox with data like January 2011 Februry 2011 .. .. .. December 2011 Also If current month is january it also show November 2010 December 2010 else if Current month is Februry it should also show December 2010 Is there any sql query so that I can get this result. Please Help Thanks in advance

I also found this link but here I didn't found the way to get City an states corresponding to that country. I know I can also get list of all country using culture info in c#. But still unable to get list of state or city.

Hi In my c# windows application I have a registration form having dropdown of Country, State and City fields. I want to fill these dropdown from web as I don't want to fill them from database or any hard coded values. Is there any web service which provide the Country, State and City related updates or Is there any other way to Implement this? Please Help.. Thanks in advance

Hi I am using SilverLight. I want to run/execute an exe on server with passing some commandLine when user click on a button. Please help. Thanks in advance

Hi I am working on silverlight I have binded a list box with ItemsSource="{Binding LstStrings, Mode=OneWay}" and inside that I have a button for downloading file from server. Now in binding I have a path of file for download. Please help me how to Implement when user click on download button it start download the file from binding path corresponding in the list from the server. Thanks

i am beginner in silverlight.I am facing one problem at the development time in Vs2008.whenever i am making any new application.first time i am able to see my UI design at the development also but second time it is crashing. and every time it is giving error.plz any one help me. Error is---> Click here to reload the designer Attempted to read or write protected memory. This is often an indication that other memory is corrupt. at MS.Internal.XcpImports.RenderTargetBitmapRenderNative(IntPtr nativePtr, IntPtr element, Int32& dirtyX, Int32& dirtyY, Int32& dirtyWidth, Int32& dirtyHeight) at MS.Internal.XcpImports.RenderTargetBitmapRender(HostingRenderTargetBitmap bitmap, UIElement visual, Int32& dirtyX, Int32& dirtyY, Int32& dirtyWidth, Int32& dirtyHeight) at System.Windows.Interop.HostingRenderTargetBitmap.Render(UIElement visual) at MS.Internal.Silverlight.Host.RuntimeInterop.RenderElementToTargetBitmap(Int32 elementKey, Int32 targetBitmapIdentifier) at MS.Internal.Silverlight.Host.Interop.RenderElementToTargetBitmap(Int32 element, Int32 targetBitmapIdentifier, ISilverlightContentDownloadCallback urlcallback) at MS.Internal.Silverlight.Host.CiderSilverlightImageHost.CiderInternalImage.UpdateBitmap() at MS.Internal.Silverlight.Host.CiderSilverlightImageHost.CiderInternalImage.UpdateTree() at MS.Internal.Silverlight.Host.CiderSilverlightImageHost.CiderInternalImage.MeasureOverride(Size constraint) at System.Windows.FrameworkElement.MeasureCore(Size availableSize) at System.Windows.UIElement.Measure(Size availableSize) at MS.Internal.Silverlight.Host.CiderSilverlightImageHost.MeasureOverride(Size constraint) at System.Windows.FrameworkElement.MeasureCore(Size availableSize) at System.Windows.UIElement.Measure(Size availableSize) at System.Windows.ContextLayoutManager.UpdateLayout() at System.Windows.ContextLayoutManager.UpdateLayoutCallback(Object arg) at System.Windows.Media.MediaContext.InvokeOnRenderCallback.DoWork() at System.Windows.Media.MediaContext.FireInvokeOnRenderCallbacks() at System.Windows.Media.MediaContext.RenderMessageHandlerCore(Object resizedCompositionTarget) at System.Windows.Media.MediaContext.RenderMessageHandler(Object resizedCompositionTarget) at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Boolean isSingleParameter) at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Boolean

<Label.Style> <Style> <Style.Triggers> <DataTrigger Binding="{Binding Path=OrdeDetails.OrderPaymentId}" Value="0"> <Setter Property="Label.Visibility" Value="Collapsed"></Setter> </DataTrigger> </Style.Triggers> </Style> </Label.Style>

hi I am binding label through <Label Content="{Binding Path=OrderDetails.OrderPaymentId}" FontSize="20"> now i want if the value of OrderDetails.OrderPaymentId=0 then the visibility of label become collapsed please help how to do this using style or trigger

But these are paid ones how can I implement these in my wpf window application

Hi I want to generate decimal point automatically while entering in textbox of wpf. Like the decimal point automatically generated while entering amount in ATM machine. Please help thanks in advance.

How to check using wmi

Hi I want to problematically determine if mysql is installed on my machine or not. Please help

Hi I am displaying credit card no in textblock. so I am binding the textblock to show credit card no. Now i want to mask it such a way that it only show last for digits and rest as x like if card no is 2343324533222422 it should show as xxxxxxxxxxxx2422 please help Thanks in advance