Welcome :Guest
Congratulations!!!

Top 5 Contributors of the Month
Imran Ghani
 Post New Web Links

## More Related Resource Links

### merging multiple tables in a single dataset to single table

i have a stored procedure which returns three tables to a dataset ..... now i need to merge all three tables to a single table from d same dataset

like dataset1 has table1 table2 and table3 .... i want all the three tabels to be merged into dataset1 itself .... instead of three diffrent tables so that i can show all three table data in a single datagrid  as a compact data and combination of 3 tables from d single dataset.....

can some1 help me please.....

### Regular Expression to Match in HTML

Here is the kind of text I want to match via a regular Expression

The id="dgSchedule" is always present in the TAG but its location may differ

The table is span over multiple line/contains white spaces/tabs...

I have the regular expression to match the start and end tag respectively over a single line

\<table .*\>

\</table\>

The problem is to match the whole table span over multiple lines

<table cellspacing="0" rules="all" border="1" id="dgSchedule" style="border-style:None;height:100%;width:100%;border-collapse:collapse;">
<tr class="blackbar" align="center" style="background-color:#7FB4DE;font-family:Verdana;font-weight:bold;height:20px;">
<td>From Place</td><td>To Place</td><td>Time</td><td>Bus Type</td>

</tr><tr style="background-color:#DEECF5;">
<td>1</td><td>2</td><td>00:15</td><td>Express</td>
</tr><tr style="background-color:#EFF5FA;">
<td>2</td><td>3</td><td>00:15</td><td>Express</td>
</tr><tr style="background-color:#DEECF5;">

<td>3</td

### HTML Table Disable

I have a HTML Table that I use to place the control in so they display nicely on my Web Form.  I also use the Disable method to keep unwanted users from editing those controls based on their log in information, however I still want the information to be displayed for their review.

The information is displayed for example in the Text Boxes, however when they hit Enter on the form because the table is disabled for some reason the information is lost when I do my update to the SQL Server (the text box shows "")?

Why is it I can see the information on the screen, but the text box shows empty when hitting enter on the form?

Thanks

Mark

### Change grid view from table to other HTML layout

Hi,

You'll have to excuse my ignorance, I'm coming at this from a front-end perspective, and don't really know how to deal with data views in ASP.NET.

Basically, I'm trying to change the layout of some repeated data from a straight table, to something more design-heavy.  It's the same data, just re-organised slightly.  The current ASP.NET code looks like this:

		<table>
<tr>
<td>
<asp:GridView ID="GVMoments" runat="server" AllowPaging="True" AllowSorting="True"
SkinID="GroupSkin" DataKeyNames="moment_id"
DataSourceID="SqlDataEditMoments">
<PagerSettings Mode="NumericFirstLast" PageButtonCount="20" Position="TopAndBottom" />
<RowStyle />
<Columns>
Visible="False" In

### Model Binding the values in an HTML Table back to Controller / Model

Currently, I am working with ASP.NET MVC1 and am still learning about Model Binding and how values from a View are passed back to the Controller / Model. Specifically, I want take an existing Model, create a Table and populate the Rows of the Table, allow the user to edit some fields and pass it back.

In my example, I have a Class called "Ingredient" which has 4 public accessors:  Name, Barcode, Amount, and Unit

<%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage<IEnumerable<MvcACE.DomainModel.Entities.Ingredient>>" %><% using (Html.BeginForm("SubmitOrder","MyController"))       { %><table>            <tr>                <th>Name</th>                <th>Barcode</th>                <th>Amount</th>                <th>Unit</th>            </tr>        <%  if (Model != null)            {                foreach (var item in Model)                { %>            <tr>                <td><%= Html.Encode(item.Name)%></td>                <td><%= Html.Encode(item.Barcode)%></

### blank row in HTML table?

is there any way to inset a couple of blank rows into an html table, or do I need to create a separate <table> with a couple of <br> in between?

### displaying the html table as a pdf document

well the question is simple but i searched all over, found crystal reports found many toolsbut the problem isi cannot use an other tools, or libraries other then the default with vs08 sp1i cannot use crystal reports, as its datasource is dataset or xml none of which is theremy page on users click of button generates a html table and info within using c# code behind (i.e. at runtime) so how to write this stream to browser such that it becomes a valid pdf file?

### SQLCE table column DefaultValues don't show up in XSD Dataset designer

Using Visual Studio 2008 with SQL CE 3.5, I notice that default values in the creation scripts for the database tables are not reflected in the dataset designer XSD file.ÃÂ  For example, the following SQL script creates the non-nullable table column names "Content" with a default value of 'Image':ÃÂ ÃÂ ÃÂ ÃÂ "Content" nchar(20) NOT NULL DEFAULT 'Image',But in the column properties of the dataset designer (XSD) panel, this column correctly shows up as non-nullable, but with a DBnull default value as follows: ÃÂ ÃÂ ÃÂ ÃÂ Name: ContentÃÂ ÃÂ ÃÂ ÃÂ Allow DBnull: FalseÃÂ ÃÂ ÃÂ ÃÂ DefaultValue: <DBnull>Am I missing something somewhere, or is this a VS bug?ÃÂ  Also, how do I get the XSD file to regenerate after schema changes in the database?ÃÂ  Sqlmetal doesn't do it.Thanks,ÃÂ ÃÂ ÃÂ ÃÂ -BGood

### C#: How to add a row to a child table with a DataSet backing?

On the back end I am using XML files, xsd schemas a DataSet(dsThingPrograms) and DataTables. I have a parent ->child table relationship defined through the DataSet designer as such:   things[RFID(pkey), name] programs[ID(pkey/autogen), name, path, thing_RFID(FK references things->RFID)]   In my code I have:   dsThingPrograms.things.AddthingsRow("lala" , "00ffe4" ); dsThingPrograms.things.WriteXml("path\to\things.xml" , System.Data.XmlWriteMode.WriteSchema);   which works fine. However the problem comes when I try to add a row to the Programs table. When I do:   dsThingPrograms.programs.AddprogramsRow("someprog" , "some\path" , <???>);   VS wants me to add a "dsThingPrograms.thingsRow parentthingsRowByFK_things_programs" where the <???> is. I've tried a bunch of things but I could not satisfy that requirement and can't even get the code to compile. What is supposed to go in there to satisfy the FK property?

### Help creating HTML table from dataTable when every nth dataTable row = 1 html table row... C#

Hello, Im trying to create an html table from data that is in a dataTable but Im having trouble coming up with the right logic. Every 3 rows in the dataTable needs to be 1 row in the html table.  Ive tried using foreach through the datatable with a modulus to determin every third dataTable row but i still run into snags because i am building the table using objects rather than using concatenated strings..(example TableRow tr = new TableRow  etc...). I cant add the cells to the rows when the row is only created in an if statement etc. Can someone post a good example in c# of how they would achieve this. The amount of data in the dataTable could change from time to time so the code cant rely on a pre determined size, unless you just need the total rows and columns, that can be dtermined when the dataTable is filled from the sqlDataReader. <table><tr><td>dataTable row 1 values</td><td>ataTable row 2 values</td><td>dataTable row 3 values</td></tr> <tr><td>dataTable row 4 values</td><td>dataTable row 5 values</td><td>dataTable row 6 values</td></tr>   Any help and example would be great. Ive been able to do similar tables in other apps but thats only when I use concatenated text strings to build the html table. Im trying to stay away from that this time

### How to Control each cells width and height of a Table ?

Hi, I want to fix the size of each cells of a table . for that i used Style like this: <td style="width:10px;height:10px"> contents </td> But it seems that there is no any effect of applying these settings.How can  i set its width and height. It seems that it purely depends on the contents of cells. Now, if suppose there are two rows, <tr id='r1'> <td id='d1'> content of size 10px </td> <td id='d2'> content of size 10px </td> </tr> <tr id='r2'> <td id='d3'> Content of size 400px </td> <td id='d4'> content of size 20px </td> </tr>   Then cell of id 'd1' will get a size of 400px ,since its just below cell is of size 400px. I want to fix its size. Is that possible ?

### setting schema as dataset to a table

hiii have an already existing schema (in a xsd file). now i need to prepare a report, so in the rdlc page i take a table. now how can i set the schema as a dataset to the table?(i'm getting an error -- "the table 'table1' is in the report body but the report has no data set.  Data regions are not allowed in reports without datasets.").

### data from html table to datareader to excel

helloi have to collect data from a website which is in table format, i have to put the table row into specific row and colum in excel, can anyone tell me how do i do itfor examplehttp://www.bizrate.com/ratings_guide/merchant_detail__mid--44084.htmlit has rating so how can i put those rating into any kind of database or excel??i want to pass the url and it should scan and filter it.can anyone tell me how this can be done. thnks in advance

### Arrange columns from nested table in a dataset that writes into XML file

Hi

I have 3 related data tables. I added these tables into a dataset and finally write it to a XML file. But the related columns from table 2 and 3 is appended after all the columns from table 1. How can I have something like:
table1->col1
table1->col2
table2->col1
table1->col3
table3->col1
in a dataset that I write to XML instead of
table1->col1
table1->col2
table1->col3
table2->col1
table3->col1

### dataset table adapter commands

hi

how i can disable generation of insert update delete select commands in tableadapter or how i can

remove all of these commands in dataset?

tank u in advance

### Update a table from a dataset

Hello,

I have a data flow task in which I have a dataset containing some rows and now I want to update the rows in a table, not insert them. Is there any way to do that in the task?

Thanks.