asitkk's Q&A profile

• SQL Server query builder

  hi friends  i've one question is it possible to use SMO to replicate "Query Designer" programmatically i want to write a query builder for end users and am wondering which objects in SMO i need to use to achieve what i want. any ideas on this one much appreciated. Thank you very much for your help. Thanks for the reply Michiel. finally we ended up using Report builder that ships with sql reporting services. ...Show All

• SQL Server Cursor, loop or case?

  Just started here, so here's what I got. I would ask the developer, but he's already gone (now I see why;-)) We are trying to pull leads from a table that have not been sold (numbsold), is available, not expired, has no agent Here's an example of a leadtimeframeid - 1= 1month , 2=1-3months 3= 4-5months Here's an example of LeadtypeID 1= sell 2=buy 3=buy/sell He seems to be going through the table and looking for a variation of each.. Such as for leadtimeframe 1, pull leadstypes 1 and 2 and union each on the 3. The result set should be as follows - lead_id,parent_lead_id,lead_type_id, buy_zip_1, buy_zip_2, buy_zip_3 ...Show All

• Visual Basic Queue Class question

  I have multiple queues of data: Queue0 Queue1 Queue2, etc. is there a simple way to refer to these queues like you would with an array Queue(0) Queue(1) Queue(2) , etc. Thanks Yes, there is. Define a array of Queue's like: Dim numberOfQueues As Integer = 4 Dim queues(numberOfQueues) As Queue For i As Integer = 0 To queues.Length queues(i) = New Queue Next ...Show All

• Windows Forms databinding error: object reference not set to an instance of an object in vb.net and mysql

  hi i am using vb.net and mysql database. i m binding the data to the text box. when it is int or string type column then it bind the column to textbox but when i try to bind the date type column to textbox it show following exception : : object reference not set to an instance of an object my code is Dim joinBinding As Binding = New Binding("Text", dsSalary.Tables("tbl_staff_emp_dates"), "sed_join_date") AddHandler joinBinding.Format, AddressOf Me .txtJoinSalary_FormatDate AddHandler joinBinding.Parse, AddressOf Me .txtjoinsalary_ParseDate txtJoinDate.DataBindings.Add(joinBi ...Show All

• SQL Server VB 2005 & Small Business Server & SQL Server

  We have Small Business Server 2003 Premium including SQL 2000 at work. At the recent launch event I got VS 2005 and SQL 2005.  I want to overhaul an Access database with poorly designed tables into a properly normalized SQL Server database. Would I be best off using SQL 2000 that came with SBS 2003 Premium or SQL 2005 express or buy some CAL's and use the SQL 2005 that I got at the launch event. I want to design with the thought that ultimately this data will be accessed by people outside our network and exposed via a web service and to/through a sharepoint site hosted locally or remotely by Microsoft. I'd like ...Show All

• Visual Studio ASP.NET Session has expired, why ?

  Hi, I have an aspx with report inside, in the ide (VWD) I can see the page and the report with data on it. When I deploy the page on the web srv I can see the page but without data on the report, instead I see one error inside the report, the error is: "ASP.NET Session has expired" Exception Details: Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired Maybe ther is something to set in the ObjectDataSource wich I use as datasource of the ReportViewer I don't know any more wath to do, please if somebody had same problem, please help me. Gioking     ...Show All

• Visual Studio Team System Application Designer Error

  I've receive this error from AD. The diagram in now in Lock state. Synchronization for element ResourceType failed. Reason: An error occurred creating the configuration section handler for windows: The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\Config\machine.config line 31) Any Help Thanks I believe this is a known bug in the Beta 2 version, in which config sections of type 'IngoreSectionHandler' cannot be loaded.  This issue has been addressed in subsequent builds.  ...Show All

• Windows Forms ActiveX-Controls and AutoScroll

  Hello, I use a ActiveX-Control in a Form where AutoScroll is true. If the control is scrolled and I click into the control the control jumps back to 0,0. Is this a known bug How I can avoid this Thanks Andreas Hello Mark, thanks for your reply. I have tested it again, but the behaviour of Windows Forms Controls differs from that of ActiveX controls. In both controls I placed a TextBox in the bottom right corner (both controls are Container controls). Then I scrolled to it and set the focus into this TextBox. If I click in an area of my usercontrol where it has no child control, the ActiveX control i ...Show All

• Visual C# Unable to directly access a property of dependent dll in design-time

  Hi, My UserControl fails to render in design-time if it tries to access a property of a member that is defined in a separate dll-file. I know that the missing dll-file exists in the debug/release folder, but in design-time it fails to enter the constructor. Is there a trick to dependent dlls when working in design-time vs runtime (All is ok in runtime) Thanks :-) ...Show All

• Visual Studio Express Editions Using Microsoft.visualbasic.collection type in settings

  I am working on a program where the user would want to save several sets of settings. For example, the settings would be used like variable a = a string, variable b = a font, variable c = a string. The user would want to use a different set depending on his choices for recurring type events. (i.e. A.M. use set 1, noon use set 2, evening use set 3, night use set 4) Each set would only contain it's own values for a,b, and c variables, nothing else. These would be user dependent choices, not my choices, so I cannot hard code in a simple select case type thing. I have played around with a separate program just to understand how to ...Show All

• Microsoft ISV Community Center Forums What version of Team System do EmpowerISV members get?

  Current MSDN Universal subscribers get a free upgrade to their choice of one of the Team editions of Visual Studio 2005 when its released.  What about current EmpowerISV members   And what will future members get   I'm planning on joining the program, but I want to be sure I know what my team will be  getting long-term, especially as it relates to Visual Studio Team System. Hi Tim Do you remember who you spoke to at MSDN   As I've spoken with a number of people who just transfer me around an are clueless when it comes to Empower. Would you be able to PM me with the comfirmation email ...Show All

• SQL Server Open Report Builder and Link to Report Directly?

  Hi, I've created a simple webpart that lists all the reports that a user has created using the Report Builder and next to each line item is an "Edit" link. What I would like to do is open up the Report Builder application and pass a parameter of the report path or something like that so that report builder opens up the report automatically. Is this possible Thanks Tristian http://blogs.msdn.com/bobmeyers/archive/2006/01/24/517083.aspx ...Show All

• Visual C# Network

  Hi, I am start learning to use the System.Net functions build in 2.0. Now I have a simple task I want to complete, I want to be able to send information between different computers in my LAN. More exactly I want to send strings between the computers: - type - name - message What is the best way to do this The best thing to do is to working with a server-computer, I think, because I'm working with more than 4 computers. Please help me with examples. Thanks Ruben, the information you provided is too limited to give you a definite answer. Anyway, if you really only need to send s ...Show All

• Windows Forms System.Windows.Forms.AxHost.InvalidActiveXStateException was unhandled

  I'm getting a AxHost.InvalidActiveXStateException can someone look at this code and see whats up... public partial class Form1 : Form { private object obj = null ; private AxSHDocVw. AxWebBrowser AxWebBrowser2; public Form1() { InitializeComponent(); } private void linkLabel1_LinkClicked( object sender, LinkLabelLinkClickedEventArgs e) { AxWebBrowser2.Navigate( "http://www.newegg.com" , ref obj, ref obj, ref obj, ref obj); } You're calling the Navigate function on the activex from the link label, which points to it being a pr ...Show All

• Windows Forms Casting problem

  Casting problem I am using Visual Basic 2005 Express Edition Beta 2 and am messing about with some code to login to a web service. The problem ONE: I keep getting an error message: System.MissingMemberException The part solution: After searching about, I believe that the answer lies with casting The problem TWO: I don't know how to cast The question: Armed with the following f ...Show All