473,321 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

ADO question, and willing to pay for expert

Hi Forum,

I'm new to ASP.NET and have a basic question. If someone is willing to lay
it out for me in an easy way to understand, I have a huge list of tasks I'm
willing to pay to get completed... please help.

Quick background... I've got three books on ASP.NET web app development.
If I follow the code, I have no problem manually creating a Connect, and
sending a Command, getting a Data Set and binding and all that good stuff.

BUT, I have Visual Studio .NET and I'm told this is supposed to replace my
need to code all that manually... but I can't seem to figure it out, or find
a clear and consice source. I'm placing DataConnectors, Data Set from the
toolbar... but for the life of me, I can't get that data to bind to a
datagrid. Do I need to code manually after I do some steps through Visual
Studio.

You can see I am quite confused, which is why I'm willing to pay if someone
can really help me out. I have a tight deadline...

So, if you'd please email me directly at mtncity2000 at yahoo dot com and
explain the step by step process of creating a basic query and displaying
results in a datagrid using Visual Studio to it's fullest benefit, perhaps
we can establish a working relationship.

Are you looking for some good clients. My two clients right now are huge
names, and I'll have plenty of miniproject through at least the end of 2005
with them. If you can help me with this one question, than perhaps we can
work together. I don't care where you are located, if you can explain it
clearly, we can work together.

Please help!!!

Thanks for your time

Mark
Nov 21 '05 #1
4 1109
Dump a little code and we'll help you out. The most common reason for no data...if your not getting
any errors is that you are not calling DataBind.
Unlike windows forms; in webforms (aso.net) you have to call

mydatagrid.Databind

after you have set

mydatagrid.datasource = myDataset

such that

With myDataGrid
.Datasource = myDataGrid
.DataBind
End With

hth
Richard

"Mark" <mt*********@yahoo.com> wrote in message news:e$**************@TK2MSFTNGP11.phx.gbl...
Hi Forum,

I'm new to ASP.NET and have a basic question. If someone is willing to lay
it out for me in an easy way to understand, I have a huge list of tasks I'm
willing to pay to get completed... please help.

Quick background... I've got three books on ASP.NET web app development.
If I follow the code, I have no problem manually creating a Connect, and
sending a Command, getting a Data Set and binding and all that good stuff.

BUT, I have Visual Studio .NET and I'm told this is supposed to replace my
need to code all that manually... but I can't seem to figure it out, or find
a clear and consice source. I'm placing DataConnectors, Data Set from the
toolbar... but for the life of me, I can't get that data to bind to a
datagrid. Do I need to code manually after I do some steps through Visual
Studio.

You can see I am quite confused, which is why I'm willing to pay if someone
can really help me out. I have a tight deadline...

So, if you'd please email me directly at mtncity2000 at yahoo dot com and
explain the step by step process of creating a basic query and displaying
results in a datagrid using Visual Studio to it's fullest benefit, perhaps
we can establish a working relationship.

Are you looking for some good clients. My two clients right now are huge
names, and I'll have plenty of miniproject through at least the end of 2005
with them. If you can help me with this one question, than perhaps we can
work together. I don't care where you are located, if you can explain it
clearly, we can work together.

Please help!!!

Thanks for your time

Mark

Nov 21 '05 #2
Mark,
BUT, I have Visual Studio .NET and I'm told this is supposed to replace my
need to code all that manually... but I can't seem to figure it out, or
find
a clear and consice source.
The word "all" is exactly as you should read it in my opinion.

ASPNET Visual Studio .Net is very helpfull. However Visual Studio Net is a
programming tool not a painters tool.

Therefore you will forever have to add code to get a professional
endproduct, how far that is up to you. However when I look how people active
in the ADONET do it, than there are not much who use the designer tools at
the moment to create the dataconnection, the datacommands or the
dataadapter.

However to give you a concrete answer on your question. (And very
interesting for learning how it goes, just push on the + in the
designergenerated code afterwards)

Open a ASPNET new project, open the toolbox. Go in that to Data and drag the
SQLDataadapter (or OleDb) on your form, than a wizard starts who build for
you everything you need to the connections depending how you fill in the
properties. Leave them the first time as default as possible.

Than rightclick on the SQLDataAdapter1 that is generated in the bottom of
your form.
Execute generate dataset, do not change default settings.

Drag than from the webform controls in the toolbox a datagrid on your form,
rightclick on that and open autoformat and choose, than the
propertiesbuilder and fill in the dataset and the datamember by choosing
from the comboboxes that you see.

Go in that same propertiesbuilder to columns and choose "all columns".

And than you have to add some code
Private Sub Page_Load(ByVal sender As _
System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.SQLConnection1.Open()
Me.SQLDataAdapter1.Fill(Me.DataSet11)
Me.DataGrid1.DataBind()
End Sub

When it is OleDb you have to change SQL for OleDb

Than there should be a page be showed when you push Debug

A point is that samples on MSDN are in my opinion mostly based on Scripting
ASPX.

As far as I remember me, (I have not installed it at the moment) is that
less in this resource kit, so maybe you can try that.

http://msdn.microsoft.com/asp.net/asprk/

Not that it helps you now, but in the next version of VSNet will the
desinger tools for ASPNET be much improved.

I hope this helps a little bit?

Cor
"Mark" <mt*********@yahoo.com>
Hi Forum,

I'm new to ASP.NET and have a basic question. If someone is willing to
lay
it out for me in an easy way to understand, I have a huge list of tasks
I'm
willing to pay to get completed... please help.

Quick background... I've got three books on ASP.NET web app development.
If I follow the code, I have no problem manually creating a Connect, and
sending a Command, getting a Data Set and binding and all that good stuff.

BUT, I have Visual Studio .NET and I'm told this is supposed to replace my
need to code all that manually... but I can't seem to figure it out, or
find
a clear and consice source. I'm placing DataConnectors, Data Set from the
toolbar... but for the life of me, I can't get that data to bind to a
datagrid. Do I need to code manually after I do some steps through Visual
Studio.

You can see I am quite confused, which is why I'm willing to pay if
someone
can really help me out. I have a tight deadline...

So, if you'd please email me directly at mtncity2000 at yahoo dot com and
explain the step by step process of creating a basic query and displaying
results in a datagrid using Visual Studio to it's fullest benefit, perhaps
we can establish a working relationship.

Are you looking for some good clients. My two clients right now are huge
names, and I'll have plenty of miniproject through at least the end of
2005
with them. If you can help me with this one question, than perhaps we can
work together. I don't care where you are located, if you can explain it
clearly, we can work together.

Please help!!!

Thanks for your time

Mark

Nov 21 '05 #3


Cor,

Thanks, your solution was exactly what I needed.

Can you recommend any online resources for implementing auto paging and
sorting in the datagrid? I selected it in properties, but don't see any
code generated for it?

Thanks again,

Mark



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 21 '05 #4
Mark,

Just MSDN in my opinion it is well written there, search for "paging
datagrid"

I hope this helps?

Cor

"Mark NY" <mt*********@yahoo.com>>

Cor,

Thanks, your solution was exactly what I needed.

Can you recommend any online resources for implementing auto paging and
sorting in the datagrid? I selected it in properties, but don't see any
code generated for it?

Thanks again,

Mark



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 21 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
by: Daniel Chartier | last post by:
Hello. I work in the paper industry and we recently had someone (the original author) from within the company make a program for preventive maintenance. However, it had some bugs and we wanted...
21
by: AES/newspost | last post by:
My understanding -- I'm not an expert -- is that on (some? many? all?) standard Internet servers a URL can point to a subdirectory name followed by a backslash, and that links to this URL will...
44
by: lester | last post by:
a pre-beginner's question: what is the pros and cons of .net, compared to ++ I am wondering what can I get if I continue to learn C# after I have learned C --> C++ --> C# ?? I think there...
13
by: Elaine | last post by:
This has to do with self-joins and includes a running balance problem. Is it possible to do this using SQL alone? Amortization schedule -------------------------- Givens: beginning balance,...
62
by: ROSY | last post by:
hello experts plz answer following questions::: thanks in advance. 1. Out of fgets() and gets() which function is safe to use and why? 2. What is a far pointer? where we use it? 3. What does the...
13
by: Ghislain Tanguay | last post by:
I have a compiled vb.net app and I want to give the user a choice to launch it from the start line command and pass it a parameter or not. How can I do that in my code? Is it possible? Ex. :...
16
by: akantrowitz | last post by:
In csharp, what is the correct locking around reading and writing into a hashtable. Note that the reader is not looping through the keys, simply reading an item out with a specific key: If i...
6
by: spibou | last post by:
In page 81 of N1124 in footnote 87 we read: If the value of the expression is represented with greater precision or range than required by the type named by the cast (6.3.1.8), then the cast...
25
by: Rehceb Rotkiv | last post by:
Hello everyone, I'm using Linux since quite a while now and I'm happy to notice that I'm beginning to "know my way round". I can write little bash, sed and awk scripts to help me with my...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.