SQL Server Performance Forum – Threads Archive
Advice is very needed!!!
Hello, experts. Your advice is very needed.Database we use is MSSQL. I should create an application that on front end would have at least two buttons (to input customer name and to give account number). Once customer name is entered, then data (account information and dates) must show up in report form on the screen with ability to sort them. What is the best way to approach it?
I am thinking of creating two procedure (that would except customer name and account number as input parameter correspondently). But I don#%92t know what software I should use in order to create buttons and make them execute the procedures. Please, advise.
Thanks in advance.
What is the language you are going to write the application.
quote:Originally posted by alex
Hello, experts.
Your advice is very needed.
Database we use is MSSQL. I should create an application that on front end would have at least two buttons (to input customer name and to give account number). Once customer name is entered, then data (account information and dates) must show up in report form on the screen with ability to sort them. What is the best way to approach it?
I am thinking of creating two procedure (that would except customer name and account number as input parameter correspondently). But I don#%92t know what software I should use in order to create buttons and make them execute the procedures. Please, advise.
Thanks in advance.
Database we use is MSSQL. I should create an application that on front end would have at least two buttons (to input customer name and to give account number). Once customer name is entered, then data (account information and dates) must show up in report form on the screen with ability to sort them. What is the best way to approach it?
I am thinking of creating two procedure (that would except customer name and account number as input parameter correspondently). But I don#%92t know what software I should use in order to create buttons and make them execute the procedures. Please, advise.
Thanks in advance.
If you are using C# check this,
http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson07.aspx
quote:Originally posted by dineshasanka
What is the language you are going to write the application.
quote:Originally posted by alex
Hello, experts.
Your advice is very needed.
Database we use is MSSQL. I should create an application that on front end would have at least two buttons (to input customer name and to give account number). Once customer name is entered, then data (account information and dates) must show up in report form on the screen with ability to sort them. What is the best way to approach it?
I am thinking of creating two procedure (that would except customer name and account number as input parameter correspondently). But I don#%92t know what software I should use in order to create buttons and make them execute the procedures. Please, advise.
Thanks in advance.
Database we use is MSSQL. I should create an application that on front end would have at least two buttons (to input customer name and to give account number). Once customer name is entered, then data (account information and dates) must show up in report form on the screen with ability to sort them. What is the best way to approach it?
I am thinking of creating two procedure (that would except customer name and account number as input parameter correspondently). But I don#%92t know what software I should use in order to create buttons and make them execute the procedures. Please, advise.
Thanks in advance.
i feel do this in vb as its easy and u can deploy on any machine without any issues.
For reporting u can go for crystal reports and can be used with vb with not much coding.
Look into:
http://www.asp101.com/articles/thanh/pagingclass/default.asp
Thanks for your responds. If I create procedure in MSSQL with parameters can I then somehow execute it by clicking on buttons? Thanks.
As mentioned you need to create the interface and buttons in another language than SQL.
Alex: You don’t seem like you have much development experience. You can do what you are asking quite simply in Visual Studio.NET (or even 6.0) whether its in VB or C#, it doesn’t really matter, the only difference is the Syntax. It would be a very simple windows app (or web app using ASP.NET, but then you have to understand the postback model). Just choose the Windows Application Template when starting VS.NET, drag a button from the toolbox onto the form it gives you, then double click the button and it will create an event handler for the onClick event. You’re also going to need to add an SQLConnection,SQLDataadapter,SQLReader and/or Dataset.
That should get you started, but there are many ways to do what you want. You can create stored procedures on SQL Server and then call them passing in the parameters, or you could hard code the SQL, but I would go the sp route. Just google: VB.NET ADO.NET tutorial if you only have VB6 then google: VB6 ado tutorial (ado is quite different from ADO.NET) Joshua Green
]]>