StephanGumpert 30-Apr-13 4:03am View

Using your Idea works a treat to get the DataSet and all accosiated properties etc.

My problem still exsits but.

Say I have 5 Columns in my Table.
The Last 4 are just pure data.
The First is my primary Key with the property of "Do Not Allow Null" set. This column data is AutoGenerated on the SQL database.

My problem is I cant add a row to the Dataset.Table with out that First column value. (it errors complainaing about NULL Values)

But how do I know what to put in that column so as to not produce duplicate data in that column. (remembering that this column is the Primary key Column)

StephanGumpert 27-Apr-13 8:32am View

Thanks for the reply but my problem is more on how I fill the column with data which normally would be filled by the SQL Database on the server side.

Or are you saying that this can be done by this?

StephanGumpert 11-Jun-12 20:36pm View

Deleted

Master Page
<pre lang="HTML"><%@ Page Language="VB" MasterPageFile="~/gmeMaster.master" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_index" Title="Untitled Page" %>
<%@ MasterType VirtualPath="~/gmeMaster.Master" %>

<asp:Content ID="Content1" ContentPlaceHolderID="MainDataFrame" Runat="Server">

</pre>

Code Behind
<pre lang="vb">Imports System
Imports System.Data
Imports System.Configuration
Imports System.Collections
Imports System.Web
Imports System.Web.Security
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.WebControls.WebParts
Imports System.Web.UI.HtmlControls

Partial Class _index
Inherits System.Web.UI.Page

Public Sub New()

End Sub
End Class</pre>

Content Pages DEFAULT.ASPX
<pre lang="HTML"><%@ Master Language="VB" CodeFile="gmeMaster.master.vb" Inherits="gmeMaster" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>XXXX</title>
</head>
<body>
<form id="form1" runat="server">

XYZ

<span>Home</span>
<asp:ContentPlaceHolder id="MainDataFrame" runat="server">

<div class="footer">© 2012 www.XYZ.com. Design by XYZ</div>
</form>
</body>
</html></pre>

Code Behind
<pre lang="vb">Imports System
Imports System.Data
Imports System.Configuration
Imports System.Collections
Imports System.Web
Imports System.Web.Security
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.WebControls.WebParts
Imports System.Web.UI.HtmlControls

Partial Public Class gmeMaster
Inherits System.Web.UI.MasterPage

Public Sub New()

End Sub
End Class</pre>

<pre lang="xml">
<configuration>
<appsettings>
<connectionstrings>
<system.web>

<compilation debug="true" strict="false" explicit="true" targetframework="4.0">

<authentication mode="Windows">

<pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID">
<namespaces>
<clear>
<add namespace="System">
<add namespace="System.Collections">
<add namespace="System.Collections.Generic">
<add namespace="System.Collections.Specialized">
<add namespace="System.Configuration">
<add namespace="System.Text">
<add namespace="System.Text.RegularExpressions">
<add namespace="System.Web">
<add namespace="System.Web.Caching">
<add namespace="System.Web.SessionState">
<add namespace="System.Web.Security">
<add namespace="System.Web.Profile">
<add namespace="System.Web.UI">
<add namespace="System.Web.UI.WebControls">

StephanGumpert 11-Jun-12 20:23pm View

Ok I have dumbed down my pages to almost nothing and I cant seam to get it to work.

I have down loaded an example from this WebSite and it works fine only difference I can see if the C# and I am using VB.

Article 333650 Beginners Tutorial on Master Pages in Asp NET.

Below I have added the snippets from my files. I have a Content Pages Default.aspx and a Master Page.

As I said it works find in VS2010 (Windows 7 64bit) but when I publish to my IIS 7.5 site I get the message:

Handler "PageHandlerFactory-Intergrated" has a bad module "ManagedPipeLineHandler" in it module List.

I'll add the code for the 2 Files below

StephanGumpert 11-Jun-12 19:35pm View

Deleted

Closed For now.

StephanGumpert 11-Jun-12 2:16am View

i think it is an error in my pages as i download a sample from this website and it runs fine.

StephanGumpert 10-Jun-12 19:47pm View

I have checked the Web.Config and it says it is 4.0 and in the Service Provider it says Framework Version is 4.0.30319.1

Snippet from Web.Config

<compilation debug="true" strict="false" explicit="true" targetframework="4.0">
<pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID">

StephanGumpert 21-Nov-11 0:06am View

Yes I have only recently migrated from VB6. (which I must say is fantastic) So normally I would set Width of dialog, then resize controls with in the dialog mathematically to suit. Obviously with Font Size and Resolution changes this doesn't work. Any tips on the best method for this?

StephanGumpert 7-Jul-11 8:31am View

this solution is for a GRIDVIEW not a DATAGRIDVIEW.

StephanGumpert 3-Jul-11 21:37pm View

Seams I solved it by my self.... too quick to ask the question.

I simply need to add the DataPropertyName to each column and bingo all is good.

Stephan

Many Thanks guys.

StephanGumpert 3-Jul-11 21:17pm View

Alan you hit the nail right on the head. Spot on.
I do however have another question.

My extra column dont appear which is good.
The grid now expands to the number of rows that are requred but no data appears in the rows, the rows are blank.

Code Used to add the data as follows:
(Is this correct?)

BindingsSourceObj.DataSource = PartDataSet
BindingsSourceObj.DataMember = PartDataSet.Tables(0).Table

MyDataGridView.DataSource = BindingsSourceObj

As I said If the AutoGenerateColumns = True the Data comes in, but when the AutoGenerateColumns = False rows are there but content is blank.

Stephan

Comments by StephanGumpert (Top 11 by date)

XYZ