Question about Microsoft ASP NET WEB MATRIX (583797)

1 Answer

Asp.Net I have a problem with Asp.Net connectivity. I don't know how to store data in database and access the data from database when needed?I want to use control for connectivity not code. Also send the information about how to use ADROTATOR control in asp.net. Also send the information about how to access the particular textbox's value of one form into another form. How to create the Dynamic Report in Asp.Net?

Posted by on

  • Stephen McGloughlin
    Stephen McGloughlin May 11, 2010

    You need to provide more information and I would suggest splitting up your questions into separate requests. Otherwise it becomes too complex to answer.


    What database do you want to connect to (Access, SQL, MySQL,...?) and what level of ASP.NET experience/expertise do you have so that I can determine how best to answer you.


    There are tutorials that do a terrific job walking you through how to use the adrotator at www.asp.net


    For passing data parameters, you need to specify if you're building a web or desktop application as they have different methods. With a desktop app you can address the .text value by using the form name ahead of the textbox name, such as Form1.textbox1.text. In a web app, you need to pass parameters/values via persistent variables, session variables of cookie data, as appropriate for your application. You can always write the data to a database or disk data file to be read by the next form, but this is usually a last resort solution.


    Again, see www.asp.net for reporting, and please provide some detail to allow someone to answer your questions. It's way too vague.

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Mentor:

    An expert who has written 3 tips or uploaded 2 video tips.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 61 Answers

About the dynamic forms/pages, u can use sessions in asp.net C#, theyre very easy to use and try using commands like server.transfer and respond.redirect in ur code. for the connectivity thigee u asked, :) m sorry my friend u cant get it like a pan cake, u gotta study w3schools odbc connectivity in asp.net tag for this :P

Posted on Feb 08, 2010

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

7 Answers

How to recover MDB file?


You can try to use third party Access file recovery program to recover your lost and corrupted data from .mdb files. For more details about this software:-
Access File Recovery Software

Apr 02, 2014 | Computers & Internet

1 Answer

I want ot link my inventory database to another pc


Create user account for second system in Sql
If u want to get data by code means u need to create
connection to database by using jdbc connection string .
then write a query to acces data.
create statement
pass query to that statement
run query

Statement statement=con.createstatement();
statement.executequery(querystring);

Oct 15, 2009 | Microsoft Designing ASP.NET Applications...

1 Answer

Connection between html and ms access


HTML page is static, means it will not interact with the database. It just shows what has been written to it.

Regarding your question, you have to use server-side scripting i.e. JSP/Servlet, ASP.NET, PHP etc.

To learn more about server-side programming see the below site.
http://en.wikipedia.org/wiki/Server_side_scripting

Sep 21, 2009 | Microsoft Office Standard for PC

1 Answer

Retrieving acess data which is password protected thru VB


You will need to use a connection string. But - before you can configure the string correctly, I'd need to know how the data is stored (Access, SQL, ODBC, etc). You can find examples online. Just know that you are looking for "Connection String." Here's two examples:
1. For MS Access (Jet files):
' Set up the connection string.
m_strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strDestDBPath & ";" & _
"Jet OLEDB:Engine Type=5" ' NOTE: Use Type=5 for Jet 4.x.

2. For SQL database:
g_strADOConn = "Provider=SQLOLEDB;" & _
"Data Source=SERVER_NAME;" & _
"Initial Catalog=DATABASE_NAME;" & _
"User ID=mssql_userid;" & _
"Password=mssql_password;"

Apr 22, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

How to create crystal report in asp.net with vb script code


You can open the Crystal Report (should be installed with Visual Studio first) after you designed your database, then you have to connect the Crystal Report to the right database (the one which you store financial information in your case), then you can create your report easily by putting the desired variables and designs. Then you have to call for that report with a code within visual basic.

Apr 15, 2009 | Computers & Internet

3 Answers

Payroll system in DBMS. I don't know what data is to be taken.


Firstly you need to determine/state whether you are using a database application, such as Access, MtSQL or MS SQL and programming them to do create this application, or are you using a programming development tool such as Visual Studio, ASP.NET, PHP or the like, as the solution and guidance will be different for each.
In terms of the data design, you should store the data necessary to identify each employee uniquely and each data point per employee needed to calculate their payroll. You should then store the generic (applys to all employees) such as tax rates, in separate tables and call on it to calculate wages and other paystub data.
For instance, the employee first and last names and tax ID should be a sufficient unique identifier. Create a table for just employees, their names, tax ID, start date, schedule, pay rate, number of deductions, direct bank payment data, etc., and whatever else you decide you need for each employee. You can calculate their wages by multiplying their rate by their schedule and applying the appropriate tax rate and medical/witholding deductions as you go, so calculated data does not need to be stored and consume database space. 
You'll likely need a separate table for common data such as tax rates, one for deductions/witholdings, one for holidays, one for vacation accrual rates, one for medical rates, etc. This data if common to employees does not need to be stored per individual, as that would cause redundant replication of data. If the employees are on an hourly rate, rather than a set salary/wage, then you'll need a table of worked hours per employee, akin to their timesheet data. If you use a timesheet/timecard, the entering and storing only the totals and keeping the physical timesheet for backup records should suffice.
Once you design and populate your database as suggested above, then it's a relatively-simple task of calculating the computed paystub data and storing the salient resulting datapoints for the record.
Consider a reporting application, such as Crystal Reports, for your printing needs, as its far easier to configure Crystal or similar product to format reports, paystubs, checks, etc., than coding these from scratch.
Hope this helps.

Dec 25, 2008 | Computers & Internet

1 Answer

MS Access and ASP.net application


You probably need to be inserting the value of a text object (ie, a String) , not the object itself. In VB.NET, a String object is an actual, not unlike a Java String object. In "classic" VB, a String object isn't really handled by the interpreter as an object in the C# / Java sense, so it can be referred to directly without resolving the value via a method call. So attempting to insert an object reference into a database field from C# code will probably not work unless the database knows to call toSting() on the object, which I am 99.99999% sure it cannot (depends on the database-- in this case Access, and more particularly, what version you are using, and if there is any .NET framework interoperability).

Calling myString.toString() though returns a String object in C#, so using that is likely not going to work. What you may need to do is return a character array using the 'chars' and 'length' properties of the C# String object.

Finally, after all this, your problem could be a lot simpler: the value(s) you are trying to insert may not be right for the field-- check the length of the values being inserted, etc. Use .trim() to eliminate leading and trailing whitespace, for example. If you post your INSERT statement and an example of the data you are using, I may be able to tell you more. Also, you are in ASP.NET and data transfer from web containers to Access databases is notoriously bedeviled work.

Mar 07, 2008 | Computers & Internet

3 Answers

Connecting html form to Ms-access data base


If, as I suspect, this is for a web form, then it effectively can't be done on a "proper" web server. This is because you cannot install MS Office on an MS server OS (e.g. Server 2003). You need to use MS SQL Server or MySQL instead. If this is for very limited use (i.e. only a few clients at a time), you can use XP running IIS but this is really not a good idea. The sedurity implications don't bear thinking about :) Linking a web page to Access can probably be done using ASP (never even thought of trying it - anyone else here know for sure?) If you are using a Linux web server then it's totally out of the question. Use Webmin or PHPMySQL to set up a MySQL database & PHP to code the linkage between the page and the DB. There are plenty of tools out there that will automate this for you, some of them Open Source and therefore free to acquire.

Sep 26, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

503 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18344 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...