ADO question, and willing to pay for expert

[Mark]

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

 

[Richard Myers]

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

 

[Cor Ligthert]

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 NY]

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

 

[Cor Ligthert]

Mark,

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

I hope this helps?

Cor