Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • Last Modified:

pulling data from a detailsview

ASP.NET 2.0/VB.NET 2.0 and sql server 05: I have a form that when the user chooses a "unit no" from a drop down list it fills several textboxes on a form. Being that I'm using a sqldatasource I have to do this with a detailsview (or formview). I read the only way to do this. Well, the data that's been populated in these two detailviews needs to be saved to a different database. These detailsview fields are part of a "unit record". I need to know how to pull the data from these detailviews. Each dvonly has one label in it. How is this done?
Am I close???
 
dvWellName.Rows(0).Cells(0).Text  
 
Used like: command.Parameters.Add("@WellName", SqlDbType.VarChar).Value = dvWellName.Rows(0).Cells(0).Text

Open in new window

0
techpr0
Asked:
techpr0
  • 4
  • 4
1 Solution
 
JenniQCommented:
You are pretty close.

Once you populate the dataview it becomes an object you can access.

In your code behind you can access the contents like this:

DataSet ds;
ds.Fill(dvWellName);

ForEach(DataRow dr in ds) {
 // here you can do stuff
    dr["myCOlumnName"];
}

or maybe you coudl do this:

For(int i = 0; i<dvWellName.Items.Count; i++) {
  command.Parameters.Add(dr[i], SqlDbType.VarChar).Value = dr[i]);


At any rate, the solution lies in creating a DATAROW and  DATACOLUMNs, filling them with the contenst of your dataview, and maniuplating. Here is a better code sample:

private void CreateNewDataRow()
{
    // Use the MakeTable function below to create a new table.
    DataTable table;
    table = MakeNamesTable();

    // Once a table has been created, use the
    // NewRow to create a DataRow.
    DataRow row;
    row = table.NewRow();

    // Then add the new row to the collection.
    row["fName"] = "John";
    row["lName"] = "Smith";
    table.Rows.Add(row);

    foreach(DataColumn column in table.Columns)
        Console.WriteLine(column.ColumnName);
    dataGrid1.DataSource=table;
}

private DataTable MakeNamesTable()
{
    // Create a new DataTable titled 'Names.'
    DataTable namesTable = new DataTable("Names");

    // Add three column objects to the table.
    DataColumn idColumn = new  DataColumn();
    idColumn.DataType = System.Type.GetType("System.Int32");
    idColumn.ColumnName = "id";
    idColumn.AutoIncrement = true;
    namesTable.Columns.Add(idColumn);

    DataColumn fNameColumn = new DataColumn();
    fNameColumn.DataType = System.Type.GetType("System.String");
    fNameColumn.ColumnName = "Fname";
    fNameColumn.DefaultValue = "Fname";
    namesTable.Columns.Add(fNameColumn);

    DataColumn lNameColumn = new DataColumn();
    lNameColumn.DataType = System.Type.GetType("System.String");
    lNameColumn.ColumnName = "LName";
    namesTable.Columns.Add(lNameColumn);

    // Create an array for DataColumn objects.
    DataColumn [] keys = new DataColumn [1];
    keys[0] = idColumn;
    namesTable.PrimaryKey = keys;

    // Return the new DataTable.
    return namesTable;
}


-- Jenni

For a better code sample, sen
0
 
techpr0Author Commented:
Jen,
Thanks for your effort but I'm a bit confused. Are you sure you're explaining how to pull a value from a Details View? I don't see a DetailsView listed any where in your explaination. If I'm wrong I apologize but it's just not clear. I have a DetailsView with one label (template field) that gets populated by a sqldatasource that I need to pull the/a value from to save else where. Please help.
0
 
JenniQCommented:
No problem.

What I'm trying to have you do is dump the content of your DetailsView control into a DataTable. That is what the dt.Fill(DetailsView) does.

Onces its in the DataTable, there is a lot more options availble to you.

Hope that makes sense.

0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
techpr0Author Commented:
Ok, yes. Now I do understand. Here's my vb.net version with the parameter.add code added:
Dim ds As DataSet
ds.Fill(dvWellName)

For Eachdr as DataRow dr in ds
          ' here you can do stuff
          command.Parameters.Add("@WellName", SqlDbType.VarChar).Value = dr("Well Name")
Next

When I run I get the error:
Error      1      C:\Inetpub\wwwroot\...\UnitMF.aspx.vb(82): error BC30456: 'Fill' is not a member of 'System.Data.DataSet'.

Is .Fill only a c# function? What can I do to make this work. Your help is appreciated.            
0
 
drypzCommented:
Hi! DataAdapter(SqlClient/OleDb) has the Fill() method not Dataset.
0
 
JenniQCommented:
Sorry its not DataSet its System.Data.DataAdapter. Here is a code sample:

Dim custAdapter As DataAdapter = New DataAdapter()

' add the control's values to the DataAdapter here

Dim dsWellName As DataSet = New DataSet()
custAdapter.Fill(ds)

-- jq
0
 
techpr0Author Commented:
Sorry to be a PITA but could you maybe give me an example of adding the control's values to the DataAdapter.
0
 
JenniQCommented:
techpr0 - I would never call you a PITA :P

You can get the text in each cell of the row by

dvWellName.Rows[i].Cells[j].Text
OR IN VB
dvWellName.Rows(i).Cells(j).Text

So, you could like loop through each row in the dvWellName control, and add it to a datarow in a dataset, then you have this nice dataset that you can do oh so much fun stuff with. YAY!

See how Rows[] is an array? That should be the key to getting what you need...

...erm... what was it again that you were trying to do?

-- jenni
0
 
techpr0Author Commented:
thanks jenni, really i was just wondering about the syntax of adding the control's values to the DataAdapter. but wheather you get back with me or not you certainly earned these points.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now