Ashok kumar Amara's Q&A profile

• SQL Server Can't Call Stored Procedure in SqlFunction

  There is a SqlFunction in my SQL Server Project: [Microsoft.SqlServer.Server.SqlFunction(DataAccess=DataAccessKind.Read)] public static SqlBoolean GetRelation(SqlGuid ID) { using (SqlConnection conn = new SqlConnection("context connection=true")) { conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM MemberRelation WHERE ID='" + ID + "'", conn); //SqlCommand cmd = new SqlCommand("EXEC GetMemberRelation '" + ID + "'", conn); /*SqlCommand cmd = new SqlCommand("GetMemberRelation", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters ...Show All

• Visual Basic Datagrid Scroll Down Event

  Sup everyone.. I got a datagrid in my form. When it reaches certain number of rows the vertical scroll bar will appear. Im trying to implement a down button, that when clicking on it, the datagrid scrolls down certain number of rows just like if I was clicking on the verticall scroll bar. How can I implement this What event has to be used If DataGrid1.CurrentRowIndex > 0 Then DataGrid1.CurrentRowIndex() -= 1 End If And If DataGrid1.CurrentRowIndex < DataGrid1.DataSource.rows.count - 1 Then DataGrid1.CurrentRowIndex() += 1 End If ...Show All

• Visual Studio Tools for Office Outlook MessageBox hidden when using Word email format

  Hi.  I'm developing a Office Outlook add-in. The problem is that a messagebox in the application's send event is showing up behind the email message. Things to note:    * This only occurs if the email format is set to "Use Microsoft Office Word 2003 to edit e-mail messages".  (If not using Word the message box displays correctly).    * If it's a Yes/No/Cancel messagebox it will only be hidden the first time it is invoked (If you click No or Cancel and cancel the send and then attempt to send the e-mail message again, the messagebox will appear correctly).    * I'm usi ...Show All

• SQL Server Validate by column name

  Hi, I would like to validate a large file using an IS package before importing it into a table using IS. The Validation rules are stored in the database against each column name Question 1. Is there a way I can get the column names of Input (coming from the file) (So I could check them against the validation table) 2. Can I store these rules in memory, may be using an array if so how do i create an array 3. What would be the best way to go abt doing this (I really appreciate any ideas) Appreciate your help... I created a recordset of validate rules and i could use the foreach container to go thr ...Show All

• Visual Studio Express Editions Learning curve verses production

  So here I am for the first time. I've been working with the videos to learn more. It seems that Bob T. even mentioned something about being productive. I am disapointed then if production people are the target audiance. I played with a working model only of VB6 from SAM's publishing about two years ago and am just now getting to learn about this .NET stuff. Great, where were you when I was going to school and just learning to program in BASICA.com. Before that had Dedicated interpreters on the micro back in the days of S100. Anyway, I do like this new IDE and just an FYI for any nonbrave, I did not uninstall anything before loading in V ...Show All

• Windows Forms Different color for each listbox (or CB) item

  Is it possible thx Hi, Would you like to try out with listview control Below is the sample code link. Link: http://www.codeproject.com/cs/miscctrl/FadingListView.asp regards, Bhanu. ...Show All

• .NET Development SqlTransaction: Why is TableAdapter in generated dataSet.Designer.cs protected

  In order to set the Transaction for a SqlCommand I have to get to the SqlCommand - Right But I have not found a way to unprotect the Adapter inside the generated class... Any ideas - workarounds or "Am I evil " ;-) Thanks Peter You both should be using SQL Server stored procedures and using transactions there...not in your page code. Your approach is opening yourself widely for hacks and exceptions. Adamus ...Show All

• Visual Basic Console Application

  Is it possible to get right click menu on the console so users can paste If you right click on the bar along the top of a console window, there is an edit menu, which has a paste option. Otherwise, no. Your console app does not have a message pump to process mouse messages. ...Show All

• Visual Studio XI and VS 2005

  I recently purchased XI developer. What version of the merge modules should I be using to get things working with VS 2005 - the ones that shipped with XI, Visual Studio 2005 or others I didn't install the VS CR version - just kept my XI developer version. I am having problems exporting files from the webviewer. Method 'ISCREditableRTFExportFormatOptions_reserved5' on type 'CrystalDecisions.ReportAppServer.ReportDefModel.EditableRTFExportFormatOptionsClass' from assembly 'CrystalDecisions.ReportAppServer.ReportDefModel, Version=11.0.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' is overriding a method that has been overridden. ...Show All

• Visual Basic Embedded Microsoft Word

  Hi, I have microsoft word document in which there are many pages (including header and footer)... Some of the pages in the documents are empty(no contents in it).. I need to delete those pages and merge the doc.  If the page contains only Header and footer that is considered as empty page. Final document should not contain any pages with empty contents.. Thanks, Satheesh Kumarr C ...Show All

• Visual Basic Help Converting This Code From 6 To .Net Please....

  http://www.vbcity.com/forums/faq.asp fid=7&cat=TreeView%2FListView&#TID20774 Yes you can use ADO as a com object in .net (Why - I'm not sure), however as stated...it is the DataEnvironment Designer that will NOT upgrade. You can create your own component class to replace the designer. ...Show All

• Visual Studio Express Editions web forms in VB 2005 Express?

  Hellow. I created web form in Visual Web Developer 2005 Express edition. Is there any way that i could run that web form from Visual Basic 2005 Express Edition (for example - by clicking the button the web form would open in a web browser). If this is possible please write the example because I am a new VB user without experience. tnx From what I recall and from the documentation microsoft provides about what features are available in each version http://msdn.microsoft.com/vstudio/products/compare/default.aspx VB Express is for windows based development and Web Developer Express is for Web ba ...Show All

• Visual C# Find width of character of a font

  Hello, Problem Faced: I'm working on a code to convert a richtextbox control with its contents to an image, im drawing each character and finding the background color of the character and drawing a filled rectangle at the back. Now my problem is i need to find the width of a character, of that specific font size/style so that i can draw the background exactly as the width of the font, else my background for a single character tends to extend more than the font and there is an overlapping. Conclusion : How do i find the width of a character of which i knw the font size and face. Regards, Dayson Pais help I find this code...maybe it cou ...Show All

• Visual Basic Radio Check Options in Menu Strip?

  First off, I'm completely new to the world of Visual Basic. I took a little break from programming for about 20 years :) What a change... and THANK GAWD! I'm trying to keep current in my studies and am using VB.NET 2005 beta 2 at the moment and training with App Dev's VB .NET course... I've got the basics down, nagivation, understanding of objects, properties, etc... but for the life of me, i can't find what i'm looking for... and what I THOUGHT may have been a slight change in naming of properties... was not the solution to my dilemna... at anyrate... My question is.... Does the 2005 version support the radio check boxes as it did in 2003 ...Show All

• Visual C# DeSerialize a complex XML file

  I am trying to DeSerialize following config.xml file, but the sample code I used from internet does not populate the values of all the elements. Can any one please suggest a code - Best Regards, Pranav < xml version = " 1.0 " > < ConfigData xmlns:xsi = " http://www.w3.org/2001/XMLSchema-instance " xmlns:xsd = " http://www.w3.org/2001/XMLSchema " > < OrgUnit > < SheetName > ABC1 </ SheetName > < UnitID > 123,234 </ UnitID > < Level > 6 </ Level > </ OrgUnit > < OrgUnit > < SheetName > ABC2 </ SheetName &g ...Show All