.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Problem aligning two tables

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :ASP.Net

Hi, I'm fairly new to aspx. I'm trying to create two quite similar pages of web form. However, the two tables on the two different pages have different table style and one of them drags across the whole page and the other just occupies half of it. I've tried dragging the table and changing the style, but nothing seems to help. Is there a solution?

View Complete Post

More Related Resource Links

problem seems to be related to grouping by on columns with the same name in different tables


using OLEDB provider IBMDADB2.1

and the following SQL run from ReportBuilder


sect.name as Team,

tasktype.name as TaskType,










The SQL runs fine in a DB2 query tool but when run through ReportBuilder I get

[DB2/LINUXX8664] SQL0119N  An expression starting with "TASKTYPE" specified in a SELECT clause, HAVING clause, or ORDER BY clause is not specified in the GROUP BY clause or it is in a SELECT clause, HAVING clause, or ORDER BY clause with a column function and no GROUP BY clause is specified.  SQLSTATE=42803


Basically the problem seems to be related to grouping by on columns with the same name in different tables.

Anyone know a work around?

Multiple Tables needed for Report Builder Problem


I have 3 tables I need to join: Voucher, Voucher_Detail, and Place
Voucher is related to Voucher_Detail by column voucher_run_id
Voucher has no relationship to Place
Voucher_Detail is related to Place by column place_id

I have solved the one to many relationship problem I was having between Voucher and Voucher_Detail by adding a New Named
Query called LeftOuterJoin.

In my DSV, the Voucher table links to the LeftOuterJoin which links to the Voucher_Detail which links to the Place

When I go into Report Builder, as soon as I select Voucher_Detail ( which is the table that has the most columns I need in the report),
the Voucher table disappears from view.

Not sure what I have missed. Obviously I need access to all 3 tables' data.

Problem with viewing grid with linked tables



My grid doesn't show on the web form when I configure its datasource to access the link table and display data from the receiver table. Both link and receiver tables are associated/linked in the .dml file. Any ideas why the grid doesn't show on the form?



Entity Framework - DB tables problem


I have a problem with the Entity Framework. Everything seems to work (created edmx file, associated with a DB, generated edmx.sql) except that tables in the DB are not created.

As the result during updating the entity container (SaveChanges method) an exception is thrown telling "{"Invalid object name 'dbo.Entity1Set'."}".

Correct me if I am wrong but the editor's operation "Generate Database from Model" should create the edmx.sql file (the file is created) and tables in the DB?

What am I doing wrong? I am using the VS2010 and tried different projects: console app, ASP MVC2; every time the result is the same: tables in the DB are not created.

Gridview update problem with related tables


Hi all,

I have a problem in getting my gridview to update. The datasource gets its data from 2 related tables using the following select statement:

SELECT StudentSubject.StudentID, Students.[1stName], Students.Surname, Students.Grade, StudentSubject.Subject, StudentSubject.GradeOverall, StudentSubject.ReportYear, StudentSubject.ReportSession, StudentSubject.Criteria1Grade, StudentSubject.Criteria2Grade, StudentSubject.Criteria3Grade, StudentSubject.Criteria4Grade, StudentSubject.Criteria5Grade, StudentSubject.Criteria6Grade, StudentSubject.Criteria7Grade, StudentSubject.Criteria8Grade, StudentSubject.Criteria9Grade, StudentSubject.Criteria10Grade, StudentSubject.Comment
FROM (Students INNER JOIN StudentSubject ON Students.StudentID = StudentSubject.StudentID)
WHERE (StudentSubject.Subject = ?) AND (StudentSubject.ReportYear = ?) AND (Students.Grade = ?) AND (StudentSubject.ReportSession = ?)

The ? stem from combo box controls which I use to filter the results

So far so good!

However, when I try to update the data in just one of the tables, nothing happens, no error, just no update. The update statement I'm using is:

UPDATE StudentSubject SET GradeOverall = ?, Criteria1Grade = ?, Criteria8Grade = ?, Criteria7Grade = ?, Criteria6Grade = ?, Criteria5Grade = ?, Criteria4Grade = ?, Criteria3Grade = ?, Criteria2Grade = ?, Criteria

aligning textboxes and labels without using tables or css


Dear all;

I have googled it and there are so many confusing examples out  there. I have the following syntax below in my aspx section

Firstname: &nbsp; <asp: TextBox ID = "txtbox1" runat ="server" vertical-align = "top">

Placeofbirth: &nbsp; <asp:TextBox ID = "txtbox2" runat = 'server" vertical-align = "top">

however, the lables makes the textboxes irregularly aligned because some of the labels are longer than each other. How do I created a situation where the textboxes will always be aligned propers and uniformly.

All help is appreciated.


Problem with linked tables


I am linking to some Access 97 tables from SQL Server 2005, however, I have had a lot of problems. These are generally sorted out by restarting the SQL server, but after a while it fails again. (queries to XLS files on the same configuration are fine)

If I go to SQL Server Management studio and check the connection to the Access databases, I get a 'Cannot initialise data source object of OLE DB provider' error message. However, if I go to the provider properties for the Jet provider and deselect 'allow inprocess'. it works. If I reselect it, it fails.

Can anyone help?

Problem with create ActionResults using 2 tables


I have a create actionlink the data that I'm adding belong to table name

One of the fields (name company_Id), is connect to table name company,(one2many
table),  So, if I'm trying to write data that already exist
in the company table , the model is invalid ,

Ne w company name,it is valid, how can write a new data entry and still
use the company table existing data entry

I'm adding my code so mybe my Q. will be more understandable ,


public  interface Irepository
       IEnumerable<company> list1();

       IEnumerable<cosmetic> list();
       cosmetic Get(int id);
       void Create(cosmetic cosmeticToCreate, company conpanyToCreate);
       void Edit(cosmetic cosmeticToEdit);
       void Delete(cosmetic cosmetToDelete);

//the class
 public class CompanyRepository :Irepository
        SR_1Entities _entitiy = new SR_1E

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

Problem to group radio button across gridview rows

In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

Regrading Sharpoint 2010 problem and solutions

We can write your question and problem on this blogger.you get ans.use.

This sharpoint 2010 problem solving threads

Hi friend,

you can use this thread to solving problem and solutions.

Temporary Tables - MS SQL Server

Usage of temporary tables in MS SQL Server is more developer friendly and they are widely used in development. Local temporary tables are visible only in current session while global temporary tables are visible across all sessions.

Temporary tables in SQL Server vs. table variables

When writing T-SQL code, you often need a table in which to store data temporarily when it comes time to execute that code. You have four table options: normal tables, local temporary tables, global temporary tables and table variables. I'll discuss the differences between using temporary tables in SQL Server versus table variables.

Virtual Path Problem


 I get the following error on last line below (working on remote host): 'E:\web\sfcascom\ls_admin/uploads/images/001.JPG' is not a valid virtual path,

Note that the slashes go in different directions

I've tried a number of things but nothing seems to work. Thanks-


Imports System.Drawing
Imports System.Drawing.Drawing2D
Imports System.Drawing.Imaging
Imports System.Web.UI.WebControls

Imports System.Drawing.Imaging.ImageCodecInfo
Partial Class Protected_imageupload
    Inherits System.Web.UI.Page
    Private Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpload.Click
        ' Initialize variables
        Dim sSavePath As String
        Dim sThumbExtension As String
        Dim intThumbWidth As Integer
        Dim intThumbHeight As Integer
        Dim sFilename As String = ""
        ' Set constant values
        'sSavePath = "images/"
        sSavePath = Server.MapPath("~/") + "ls_admin/uploads/images/"

        sThumbExtension = "_thumb"
        intThumbWidth = 160
        intThumbHeight = 120

        ' If file field isn?t empty
        If FilUpload.PostedFile IsNot Nothing Then
            ' Check file size (mustn?t be 0)
            Dim myFile As Http

Strange Photo upload problem


I'm working project it's live on shared hosting

we'er uploading photos to a file on the server everything works fine the photo is resized renamed and sent to the folder

the upload page returns the thumbnail and the full size photo it's there all the photos have to be approved by an admin

twice now after they have been approved they disapear I checked the folder they are not there could there be anywhere

on the server they could get hung up before they go into the folder I have it setup so when you delete the data base entry it deletes the photo from the folder othe than that you need to open the folder and delete the photo this has hapened twice now I tried to recreate it with no luck

thaks for your help in advance

ASP.Net Caching problem ??


I'm having a problem with an asp.net 3.0 application using a gridview to display data.  The problem seems to be that despite a brand new .selectCommand being sent to the sqlDataSource, the gridview starts displaying data from *someone else's* query.  For example, user A is logged in and will be working fine until a few page submissions later when the gridview data starts suddenly showing information that belongs to another user. 

This is my first asp.net application, though I've been working with classic asp and ADO for years so I'm used to sending a SQL string and getting back the results from that string.  Apparently there is a complex caching system which is interferring which I do not at all understand so at this point I just want to stop the server from caching any data whatsoever.  Is this possible?

Any and all help will be much appreciated!!

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend