Search results matching tag 'DataSourceControl'

DataSourceControl Problem

egraffius — Wed, 18 Mar 2009 04:00:00 GMT

I had this page in my application working, but I requested my host company to move me to a new server where I can have remote DB access. All I should have had to do was change the connection string in the web.config. I am not sure if it is the code or the server. (Same setup: IIS7 .Net3.5 MSSQL 2005) Here is the code and the error page:

***********************************************ASPX***************************************************************
<%@ Page Language="C#" MasterPageFile="~/GNPM.Master" AutoEventWireup="true" CodeFile="ViewQuotes.aspx.cs" Inherits="GNP_Machining.Secure_Admin.WebForm2" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="quote_no"
DataSourceID="ObjectDataSource1">
<Columns>
<asp:TemplateField HeaderText="Quote Number" InsertVisible="False"
SortExpression="quote_no">
<EditItemTemplate>

<asp:Label ID="Label1" runat="server" Text='<%# Eval("quote_no") %>'></asp:Label>
</EditItemTemplate>
<ItemTemplate>
<asp:HyperLink ID="ViewURL" runat="server" NavigateUrl='<%# FormatUrl( (int) Eval("quote_no") ) %>' Text = '<%# Eval("quote_no") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="create_datetime" HeaderText="Date"
SortExpression="create_datetime" />
<asp:BoundField DataField="update_user_id" HeaderText="User"
SortExpression="update_user_id" />
</Columns>
<HeaderStyle BackColor="#355532" ForeColor="White" />
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
DeleteMethod="Delete" InsertMethod="Insert"
OldValuesParameterFormatString="original_{0}" SelectMethod="GetData"
TypeName="Quote_Data_DatasetTableAdapters.Quote_FileTableAdapter"
UpdateMethod="Update">
<DeleteParameters>
<asp:Parameter Name="Original_quote_no" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="user_id" Type="Object" />
<asp:Parameter Name="part_no" Type="String" />
<asp:Parameter Name="qty" Type="Int32" />
<asp:Parameter Name="est_due_date" Type="DateTime" />
<asp:Parameter Name="material_specs" Type="String" />
<asp:Parameter Name="instructions" Type="String" />
<asp:Parameter Name="create_user_id" Type="String" />
<asp:Parameter Name="create_datetime" Type="DateTime" />
<asp:Parameter Name="update_user_id" Type="String" />
<asp:Parameter Name="update_datetime" Type="DateTime" />
<asp:Parameter Name="Original_quote_no" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="user_id" Type="Object" />
<asp:Parameter Name="part_no" Type="String" />
<asp:Parameter Name="qty" Type="Int32" />
<asp:Parameter Name="est_due_date" Type="DateTime" />
<asp:Parameter Name="material_specs" Type="String" />
<asp:Parameter Name="instructions" Type="String" />
<asp:Parameter Name="create_user_id" Type="String" />
<asp:Parameter Name="create_datetime" Type="DateTime" />
<asp:Parameter Name="update_user_id" Type="String" />
<asp:Parameter Name="update_datetime" Type="DateTime" />
</InsertParameters>
</asp:ObjectDataSource>
</asp:Content>

***********************************************CodeBehind*********************************************************
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml.Linq;

namespace GNP_Machining.Secure_Admin

{

public partial class WebForm2 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

SqlDataSource DataSource =(SqlDataSource)Page.FindControl("ObjectDataSource1");

}

protected string FormatUrl(int quote_no)

{

if (quote_no < 1)

throw new ArgumentOutOfRangeException("quote_no");

return "ViewQuoteFiles.aspx?quote_no=" + quote_no;

}

***********************************************Error Page***********************************************************

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]
   Quote_Data_DatasetTableAdapters.Quote_FileTableAdapter.InitConnection() +56
   Quote_Data_DatasetTableAdapters.Quote_FileTableAdapter.InitAdapter() +462
   Quote_Data_DatasetTableAdapters.Quote_FileTableAdapter.GetData() +22

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
   System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +308
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
   System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +480
   System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1960
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
   System.Web.UI.WebControls.GridView.DataBind() +4
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
   System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
   System.Web.UI.Control.EnsureChildControls() +87
   System.Web.UI.Control.PreRenderRecursiveInternal() +50
   System.Web.UI.Control.PreRenderRecursiveInternal() +170
   System.Web.UI.Control.PreRenderRecursiveInternal() +170
   System.Web.UI.Control.PreRenderRecursiveInternal() +170
   System.Web.UI.Control.PreRenderRecursiveInternal() +170
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041

Re: A question regarding my checkbox control within my gridview.

xyz789 — Thu, 12 Jun 2008 04:00:00 GMT

Thank you for responding back. Actually I caught the binding of the ListBox2 right after I sent the message, oops.

That is not what I wanted to do of course, but my main issue is that I am still unable to get the values I need in ListBox2

I should have explain a little more about the code yesterday. You are right jchandra about the ListBox being equal to SqlDataSource2. I would like to get my values from SqlDataSource2.

The sequel code in SqlDataSource2 is like this "SELECT KEY_ID, FIRST_NAME + ' ' + LAST_NAME AS FULL_NAME WHERE (KEY_ID = @KEYID)"

The ListBox2 is set to this DataSourceID="SqlDataSource2" DataTextField="FULL_NAME" DataValueField="KEY_ID", however I am still unable to see the DataTextField in the listbox.

Here is the revised code from yesterday.

    Protected Sub chkAgent_CheckedChanged1(ByVal sender As Object, ByVal e As System.EventArgs)
        ListBox2.Items.Clear()
        For index As Integer = 0 To gvAgents.Rows.Count - 1
            Dim chk As CheckBox = CType(gvAgents.Rows(index).FindControl("chkAgent"), CheckBox)
            If chk.Checked Then
                Dim keyid As Label = gvAgents.Rows(index).FindControl("lblKeyID")
                SqlDataSource2.SelectParameters("KEYID").DefaultValue = keyid.Text
                ListBox2.Items.Add(New ListItem("FULL_NAME", "KEY_ID"))
            End If

I am not sure that I have the right syntax for ListBox2.Items.Add when using "FULL_NAME" and "KEY_ID". What can I do?

thanks,

xyz789

gridview_rowdatabound update issue

mclead99 — Wed, 04 Jun 2008 04:00:00 GMT

I have a rowdatabound event that generates an automated email. I want to change the value of a checkbox in the row as part of the event, not every row in the table (tried gridview1.rowupdate) and it chnanged all rows in table. I am using VB.net. What is method to change each row as it is databound?

Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
 Dim fname As New Label
 Dim lname As New Label
 Dim repemail As New Label
 Dim completedate As New Label
 Dim address As New Label
 Dim city As New Label
 Dim state As New Label
 Dim zipcode As New Label
 Dim emailaddress As New Label
 Dim homephone As New Label
 Dim cellphone As New Label
 Dim clientno As New Integer
 Dim rowid As New Integer
 Dim cbcp1 As CheckBox = DirectCast(Me.GridView1.FindControl("cp1"), CheckBox)
 If e.Row.RowType = DataControlRowType.DataRow Then
<-------------------------------------------------------------------------------------------would like to change value of checkbox CP1 (column index 6) here prior to assigning email information----------------------->
 fname.Text = e.Row.Cells(0).Text
 lname.Text = e.Row.Cells(1).Text
 repemail.Text = e.Row.Cells(2).Text
 completedate.Text = e.Row.Cells(4).Text
 address.Text = e.Row.Cells(7).Text
 city.Text = e.Row.Cells(8).Text
 state.Text = e.Row.Cells(9).Text
 zipcode.Text = e.Row.Cells(10).Text
 emailaddress.Text = e.Row.Cells(11).Text
 homephone.Text = e.Row.Cells(12).Text
 cellphone.Text = e.Row.Cells(13).Text
 clientno = e.Row.Cells(14).Text
 rowid = GridView1.EditIndex

 Const ToAddress As String = "alm0@mchsi.com"
 '(1) Create the MailMessage instance
 Dim mm As New MailMessage("ReferralUpdate@creditability.org", ToAddress)

 '(2) Assign the MailMessage's properties
 mm.Subject = "CreditAbility Client Referral Update"
 mm.Body = "Just to remind you " + fname.Text + " " + lname.Text _
 & " finished our credit repair program on " + completedate.Text _
 & ". We have provided your client's contact information below." _
 & " " + fname.Text + " " + lname.Text _
 & " " + address.Text _
 & " " + city.Text + ", " + state.Text + " " + zipcode.Text _
 & " Email: " + emailaddress.Text _
 & " Home: " + homephone.Text _
 & " Cell: " + cellphone.Text _
 & " " _
 & "CreditAbility provides this update to referral sources to help you keep in touch with you potential clients!" _
 & " We will be reminding you again about this client in about 60 days" _
 & " CreditAbility" _
 & " 266 Blairs Ferry Road NE, Suite 200" _
 & " Cedar Rapids, Iowa 52402" _
 & " Phone: 888-573-2822"
 mm.IsBodyHtml = True
 mm.Priority = MailPriority.High
 '(3) Create the SmtpClient object
 Dim smtp As New SmtpClient("relay-hosting.secureserver.net")
 '(4) Send the MailMessage (will use the Web.config settings)
 smtp.Send(mm)
 End If
 End Sub

Thanks for your help on tihs.

VB programaticlly grab data from a DB noob

guitarboy8d6 — Thu, 06 Mar 2008 05:00:00 GMT

Hi, I am very new to the .net framework, but I have a lot of experince in php/mysql applications. So this is this is proboly going to seem like a nwebie question.

I am trying to pull a single item out of the database programaticlly, take the value of that item and set it to a varible so I can work with it in other areas.

Here is basically what I have this is on the vb page in a sub

I have the varible MonthlyPrice Defined earlier in the page

Dim connString As String = _
ConfigurationManager.ConnectionStrings("ConnectioString").ConnectionString'Create a SqlConnection instance
Using myConnection As New SqlConnection(connString)'Specify the SQL query
Const sql As String = "SELECT Price FROM Plans Where PlainID='" & PlanId & "'"
'Create a SqlCommand instance
Dim myCommand As New SqlCommand(sql, myConnection)'Get back a DataSet
Dim myDataSet As New DataSet'Create a SqlDataAdapter instance
Dim ReadData As New SqlDataReader(myCommand) 'Bind the DataSet to the GridView
MonthlyPrice = ReadData("Price")'Close the connection
myConnection.Close()End Using

I just want to get the price of the plan where planID is equal to the value of my varible planID. I want to set that equal to MonthlyPrice which is a decimal so I can add it into some calculations and return a value. I don't really want to bind the data to anything but everytime I search google I can't find anything excpet for binding data to grideview and things like that.

I have tried several diffrent approaches that I have found out there but have gotten errors or and things I am not understanding.

I originally was trying to access a datasource I already have defined that is on the aspx page.

<asp:SqlDataSource ID="SQLSelectPlan" runat="server"

ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

SelectCommand="SELECT * FROM [Plans] WHERE ([PlanID] = @PlanID2)">

<asp:FormParameter FormField="grSelectPlan" Name="PlanID2" Type="Int32" />

</SelectParameters>

</asp:SqlDataSource>

Is there a way for me to grab this datasource which works and is tied to a detailed view, take the value in the price collom and stick it in the MonthlyPrice varible on my vb page? That is the approach that seems the most logical to me.

If someone has better way I would really like to know.

Thanks

Adding a GridView and DataSource inside of a Web Custom Control

biznick — Mon, 25 Feb 2008 05:00:00 GMT

I am working on a reusable person search control right now, and I am having trouble figuring out how to add my gridview and datasource through my control.

Below is my RenderContents method. Basically I have two issues. The first, is with a grid view, even after doing RenderControl(), the grid view never appears on my page, or any html to represent it for that matter. The test label however, does render html. The second is with the CSLADataSource (which just inherits DataSourceControl). How do you do a RenderControl() for DataSourceControls (that method does not exist for this).

If anyone could help point me in the right direction to having a datasource and gridview be rendered in a web custom control, I'd appreciate it. Thank you.

protected override void RenderContents(HtmlTextWriter output)
{
 CslaDataSource odsPersons = new CslaDataSource();
 odsPersons.ID = "odsPersons_" + UniqueID;
 odsPersons.TypeAssemblyName = "PersonLookup";
 odsPersons.TypeName = "PersonLookup.PersonList";
 odsPersons.TypeSupportsPaging = true;
 odsPersons.TypeSupportsSorting = true;
 odsPersons.SelectObject += new EventHandler<SelectObjectArgs>(odsPersons_OnSelectObject);

     GridView gvPersons = new GridView();
     gvPersons.DataSourceID = "odsPersons_" + UniqueID;
     gvPersons.AutoGenerateColumns = true;
     gvPersons.AllowPaging = true;
     gvPersons.PageSize = 10;
     gvPersons.EmptyDataText = "Boo, no results!";
     gvPersons.GridLines = GridLines.Both;

Label test = new Label();
 test.Text = "Testing Grid View #5 ";
 test.RenderControl(output);

gvPersons.RenderControl(output);
}

Custom DataSourceControl example

akaKlen — Tue, 24 Jul 2007 04:00:00 GMT

Hi!

While developing my current project I need to create a custom DataSourceControl and I couldn't find good enough info about this in Microsoft's help nor anywhere else. There is something about selecting data in DataSourceView.ExecuteSelect but what about insert and update? About DataSource and DataView interactions?

The best to have would be SqlDataSource source code!

If anybody has a link or an example it'd be appreciated.

Alex

DataSourceControl/DataSourceView Question

DanielSchaffer — Fri, 09 Mar 2007 05:00:00 GMT

I'm creating a custom DataSourceControl/DataSourceView, and I'm having some issues with implementing ExecuteUpdate() and ExecuteDelete(). If the DataSourceView represents a collection of objects, rather than just an object, how do I get which index is supposed to be updated or deleted? I need to be able to do this without the GridView passing any keys. Any suggestions? Thanks :)