VS 2005 SQL Reports – Need to convert 5 character string to datatime
Hey there. I am relatively new to SQL and have a problem. I am building a report that gets a summation of a column called ‘Duration’. The datatype is char(5) e.g. “00:30″ to represent a half hour. I suppose I need to change the datatype to sum it but can’t figure out how to. What [...]

Answer Question   |  March 31, 2012  8:16 PM
SQL, SQL Server, SSRS, Visual Studio 2005, VS 2005

SQL reporting
I am using sql server 2005. I have a report with 2 columns.one for report name and the other for status.I want that when a user clicks on a report’s status column,the corresponding report should be opened. i am using the following code in the navigation tab–>jump to report. =Iif(Fields!SUB_REPORT.Value=”GFM_FX_EXPOSURE$”,”www.google.co.in”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_EXP$”,”GFM_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_MV$”,”GFM_INST_TYPE_MV”, Iif(Fields!SUB_REPORT.Value=”GSS_FX_EXPOSURE$”,”GSS_FX_EXPOSURE”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_EXP$”,”GSS_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_MV$”,”GSS_INST_TYPE_MV”, [...]

Answer Question   |  February 22, 2011  8:07 AM
SQL Reports, SQL Server 2005, SQL Server reporting, Visual Studio 2005

Copy WinForm For Showing Demo Visual Studio 2005
I am Developing VS-2005 application and some time it’s important to copy winform which we are develop and paste it in forums for showing demo to other for discussion problem or write article. So I want to know How can we copy winform and paste it to any forums for showing demo and discussion?.

Answer Question   |  October 10, 2010  12:25 PM
Visual Studio, Visual Studio 2005

Datagridview First Rows Not Consider or Skip
There is some mistake from my previous question hence once again repeat it. My problem is on datagridview i have populate combobox and amount column. and ColumnHeader/RowHeaderVisible property set to false. I have coding as below. private void dataGridView1_RowLeave(object sender, DataGridViewCellEventArgs e)         {             double dd = 1.768901; [...]

Answer Question   |  October 6, 2010  2:42 PM
C#, DataGridView, Visual Studio, Visual Studio 2005, VS 2005

Without Using Script in SSIS
HI!!! how do I alter data in SQL Server table [select, insert and delete] using SSIS Visual Studio without using a T-SQL Script… please help me T_T…. Thx so much…

Answer Question   |  September 27, 2010  2:05 AM
Scripting, SQL Server tables, SQL tables, SSIS, Visual Studio 2005

Visual Studio code help
here is my code: private void Form1_KeyDown(object sender, KeyEventArgs e)         {             if (e.KeyCode == Keys.Tab && e.Shift)              {             }             else if (e.KeyCode == Keys.Back)              {      [...]

Answer Question   |  September 21, 2010  11:25 AM
C#, C# .NET, Visual Studio 2005, VS 2005

Object Sender and EventArgs in Visual Studio 2005
For Knowledge:- Private Void Textbox1_TextChange(Object Sender,EventArgs e) Private is Modifier Void is Returntype Textbox1_TextChange is an Event So what is Object sender,EventArgs e and how does it works? may be i wrong in above case but it’s necessary to understand it better.

Answer Question   |  September 8, 2010  3:11 PM
C#, Visual Studio, Visual Studio 2005, VS 2005

Difference Behaviour of Dispose Method Between Winforms and Textboxes
This question is just for knowledge. Whenever Dispose Method Called for clean Winforms, it’s Finalize and disposed. So my question is why not in TextBox case. It Should same behaviour of dispose method against textbox. Instead of clean/dispose it will remain Invisible. If we have no use than it will have to completly remove during [...]

Answer Question   |  September 7, 2010  12:54 PM
C#, TextBox, Visual Studio, Visual Studio 2005, VS 2005, WinForms

Parameter Date Conversion in SQL 2000
my code is : string sql="insert into dummy(date)values(@date)"; sqlcommand cmd=new sqlcommand(sql,con); cmd.parameters.add("@date",sqldbtype.datetime).values=maskedtextbox1.text text; cmd.executenonquery(); the problem is it's throw and error like  conversion of varchar to date; Note :- my demand to put date in DD/MM/YYYY format. 

Answer Question   |  September 3, 2010  4:22 PM
C#, SQL, SQL 2000, SQL commands, SQL Parameters, SQL Server, String manipulation, Visual Studio 2005

Setfocus on FlowlayoutPanel Controls
after creating the runtime control on panel how to setfocus between controls in FlowlayoutPanel. suppose I have to textbox which is created on dynamically like below layout of controls in FlowLayoutPanel is tbb                                             [...]

Answer Question   |  August 31, 2010  1:21 PM
C#, RunTime, Visual Studio 2005, VS 2005

Access Listbox Without Focusing in WinForms
Is that possible to access ListBox without Focus? I mean as below example I have a TextBox and a ListBox. I wants when cursor in textbox listbox should search the items containing in textbox and do well up and down arrow key. When i press Enter the items which is search by listbox should replace [...]

Answer Question   |  August 27, 2010  3:44 PM
C#, ListBox, Visual Studio, Visual Studio 2005, VS 2005, WinForms

Collection Or Reference Of Multiple Runtime Controls In FLP For Only Specific Controls
I have create two runtime textbox contols in FlowLayOutPanel as below.. One  Textbox Control TextBox tb= new TextBox(); tb.Name="tbox"+i.tostring(); this.FlowLayOutPanel1.Controls.Add(tb); Another Textbox Control TextBox tb= new TextBox(); tb.Name="tbox"+i.tostring(); this.FlowLayOutPanel1.Controls.Add(tb); Now both are ready for runtime. If I have to collect  or reference only “tbox” control without effecting “tbbox” control then How to collect/refrenced. if I [...]

Answer Question   |  August 23, 2010  12:05 PM
C#, TextBox, Visual Studio 2005, VS 2005

Runtime Control Indexing Problems to set the index on control for call it in IF condition
hi, am using c#, vs-2005 am generate runtime controls as below. Textbox tb=new Textbox(); tb.Location=tbpoint; // declare in Class Body tb.Name="tbox" + i.to string(); // i declare in Class Body tbpoint.Y+=30; this.FlowLayoutPanel1.Controls.Add(tb); the above code Ready for runtime other same runtime controls Textbox bb=new Textbox(); bb.Location=tbpointt; // declare in Class Body bb.Name="tboxx" + i.to string(); [...]

Answer Question   |  August 31, 2010  12:59 PM
C#, RunTime, Visual Studio, Visual Studio 2005, VS 2005, Windows XP

designtime gridview
i want to expect datagriedview in desingtime for one table wiit access backend

Answer Question   |  July 30, 2010  7:38 AM
DataGrid, DataGridView, Visual Studio, Visual Studio 2005

Crystal Report 10 error
I am getting this error when I try to pull a crystal report: Property “New Generator” cannot be declared “overrides” because it does not override a property in a base class. When I comment out the errors the report pulls and when I make a change or edit the report or go out of the [...]

Answer Question   |  July 1, 2010  12:32 PM
Crystal Reports 10, Crystal Reports error messages, Visual Studio 2005

Crystal Report: Specified File is not found.
Hi.. I created my website in asp.net.Than I create Virtal directory in IIS. My all pages are running correctly,but when I open Crystal Report.It runs Successful first time but when I running website again than it Crystal report gives the error that specified file is not found. So please help me..How can I solve this [...]

Answer Question   |  June 16, 2010  12:28 PM
ASP.NET 2.0, Crystal Report, IIS, Virtual directory, Visual Studio 2005

HOW TO CONNECT VS2005 TO SQL2005
Dear sir, how to connect vs2005 to sql2005 and which setting do in vs2005 and sql2005    

Answer Question   |  March 29, 2010  3:59 AM
SQL, SQL Server 2005, Visual Studio 2005

CONNECTION VB WITH ACCESS
how to connect visual basic 6 and msaccess 2003 by using connection string

Answer Question   |  August 9, 2010  7:56 AM
Access 2003, VB 6.0, Visual Basic, Visual Studio 2005

Question about Crystal Reports
I am storing my database in the APP_DATA Folder of my application. I added crystal report to my application. I mentioned .SQLEXPRESS as my server. In database drop down i see only these databases -Master, Model, msdb, tempdb My dabase’s name is “Database.mdf” . Why i am not able to see it ? My connection [...]

Answer Question   |  October 23, 2010  9:41 AM
.NET 2.0, Crystal Reports, Crystal Reports 2005, Visual Studio 2005, VS 2005

Error when insertin.g data into SQL table
                I’m using SQL Server 2005 Express edition as the Database and Microsoft VB.NET 2005 as the programming language for my project. At the moment I’m having a problem of inserting data into one of the tables in my database through my VB.NET application. I did successfully inserted data through my [...]

Answer Question   |  September 28, 2009  10:31 AM
Microsoft Visual Studio, SQL Server 2005, SQL Server 2005 Express, SQL Server tables, SQL tables, VB.NET, VB.NET 2005, VB.NET 2005 programming, Visual Studio 2005