Search results matching tag 'datasets'

How to identify duplicate value in XML file using ASP.net (c#)?

SudhaYogesh — Mon, 07 Sep 2009 04:00:00 GMT

Hi I have XML file as below. I need to check for duplicate value inside <BaseSku> and if any duplicate found then I need to write to the label of its existance. Innertext of <BaseSku> must be unique for the whole xml file.

From the below file I have 2 value(inner text) of <BaseSku> are same. So how do I write the code to identify these duplicate and write to a label using ASP.net (c#). sample code will be much appreciatable.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<NewDataSet xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ProdSheet>
  <ProductId>851</ProductId>
  <BaseSku>ACCJVC01</BaseSku>
  <Name>JVC GUMY In-Ear Headphone with Colour Cord (Mint Blue)</Name>
  </ProdSheet>
<ProdSheet>
  <ProductId>852</ProductId>
  <BaseSku>ACCJVC01</BaseSku>
  <Name>JVC GUMY In-Ear Headphone with Colour Cord (Black)</Name>
  </ProdSheet>
<ProdSheet>
  <ProductId>853</ProductId>
  <BaseSku>ACCJVCHAF130DE</BaseSku>
  <Name>JVC GUMY In-Ear Headphone with Colour Cord (Orange)</Name>
</ProdSheet>
</NewDataSet>

How to transform XML to wellformed XML using XSLT ?

SudhaYogesh — Fri, 04 Sep 2009 04:00:00 GMT

HI I have the below XML generated from dataset , but some of the elements (columns) missing because of empty value in the database.

So I have to use XSLT to transform the xml to xml to have the emptyelements. Please someone giude how do I start XSLT for the below

XML structure. It is a table about the products and no attributes and other complex stuff involved.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<Name>JVC earphone</Name>

<ShortDescription>Price for 1 .</ShortDescription>

<MainCat>EarPhones</MainCat>

<AddnlCat1>Ipod Accessories</AddnlCat1>

<AddnlCat2>Earphones</AddnlCat2>

<AddnlCat3>Audio Accessories</AddnlCat3>

<MainDescription>Some description of 9000 characters</MainDescription>

<ExtraInfo>Some more information</ExtraInfo>

<Usefulinfo>Useful Information</Usefulinfo>

<ShpPortal>GB/KELKOO/</ShpPortal>

<IsDeleted>false</IsDeleted>

</WebPdts>

<BaseSku>JVCHAFX3</BaseSku>

<Name>JVC In Ear Marsmallow Mouldable Stereo Headphones </Name>

<ShortDescription>JVC In Ear Marsmallow Mouldable Stereo Headphones - Blue, 1 in a Pack, Price for 1 Pack, HA-FX34-AN-E</ShortDescription>

<MainCat>Ipod Accessories and Earphones</MainCat>

<AddnlCat1>Earphones</AddnlCat1>

<MainDescription>JVC In Ear Marsmallow Mouldable Stereo Headphones - Blue, 1 in a Pack, Price for 1 Pack, HA-FX34-AN-E</MainDescription>

<IsDeleted>false</IsDeleted>

</WebPdts>

</NewDataSet>

Problem in Binding dataset with crystal Report 10

JanetDiana — Wed, 08 Jul 2009 04:00:00 GMT

This below code is not working for me

            SqlDataAdapter da;
            DataSet ds;
            if (sqlConn.State == ConnectionState.Closed)
                sqlConn.Open();
            da = new SqlDataAdapter(Query, sqlConn);
            ds = new DataSet();
            da.Fill(ds, "List");

            if (ds.Tables.Count > 0)
            {
                ReportDocument objReportDocument = new ReportDocument();

                String ActualPath = Server.MapPath(".") + Path;

                objReportDocument.Load(ActualPath);

objReportDocument.SetDataSource(ds);

                CrystalReportViewer1.ReportSource = objReportDocument;

                CrystalReportViewer1.RefreshReport();

}

I'm using crystal report 10 now.. Default my reports are created in crystal report 8.

My report is connected correctly. but the data's in the data set is not bind with my report.

I have used Query in my crystal report instead of sp or view.

The default data's in the crystal report is retrived while calling the report through the above code. Data's in my dataset ds is not binded.

Can anybody help me????

Thanks in Advance

crystal report

vivekkumar341 — Tue, 07 Apr 2009 04:00:00 GMT

sir i'm not able to create an instance for the crystal report generated through design i'm able to generate the instance for dataset designed through wizard but not the crystal report. plz help me out do i need any tool to generate it

Strongly Typed Dataset, how to add a custom column?

rareddy — Thu, 19 Mar 2009 04:00:00 GMT

I'm using the dataset tool in VS2005 to retrieve a table from SQL. One of the columns from SQL has data which was encoded using a function in a class. I would like to override this column so that I can decode the value from SQL and return the decoded value in the dataset.

How do I override this column when doing a GET?

Insert into Access Db functions with Error - No value given for one or more required parameters.

razzleb — Tue, 03 Mar 2009 05:00:00 GMT

Hey all,

Have a little problem with my web form application, have really tried everything, noticed there was an abundance of solved technical problems here, so I thought I would post up to see if anyone is able to provide a solution.

This simple web form written in VB.NET has something strange going on. I require the data entered to be inserted into an Access Db (currently has no validation) and it does just that, however even though the data entered is showing up in the Customer table I keep getting the error "No value given for one or more required parameters."

I have checked the parameters over and over again and all seems fine, will provide a few screenshots and the complete page in hope that there is an easy fix for this. Appreciation in advance.

1    <%@ Page Language="VB" Debug="true" >
2    <%@ Import Namespace="System.Data" %>
3    <%@ Import Namespace="System.Data.OleDb" %>
4    <script language="VB" runat="server">
5    Dim Name, Surname, Address1, Address2, Address3, Zip_Code, State, TelNo, Email, Comments As String
6    
7    Sub doInsert(Source as Object, E as EventArgs)
8            Dim MySQL As String = New String("Insert into Customer (Cust_Name, Cust_Surname, Cust_Address1, Cust_Address2, Cust_Address3, Cust_Zip_Code, Cust_State, Cust_TelNo, Cust_Email, Comments) VALUES (@Name, @Surname, @Address1, @Address2, @Address3, @Zip_Code, @State, @TelNo, @Email, @Comments)")
9            Dim myConn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
10            "Data Source=" & Server.MapPath("db\gsb.mdb") & ";")
11   	 
12   	Dim Cmd as New OleDbCommand(MySQL, MyConn)
13           Cmd.Parameters.Add(New OleDbParameter("@Name", frmCust_Name.Text))
14           Cmd.Parameters.Add(New OleDbParameter("@Surname", frmCust_Surname.Text))
15           Cmd.Parameters.Add(New OleDbParameter("@Address1", frmCust_Address1.Text))
16           Cmd.Parameters.Add(New OleDbParameter("@Address2", frmCust_Address2.Text))
17           Cmd.Parameters.Add(New OleDbParameter("@Address3", frmCust_Address3.Text))
18           Cmd.Parameters.Add(New OleDbParameter("@Zip_Code", frmCust_Zip_Code.Text))
19           Cmd.Parameters.Add(New OleDbParameter("@State", frmCust_State.Text))
20           Cmd.Parameters.Add(New OleDbParameter("@TelNo", frmCust_TelNo.Text))
21           Cmd.Parameters.Add(New OleDbParameter("@Email", frmCust_Email.Text))
22           Cmd.Parameters.Add(New OleDbParameter("@Comments", frmComments.Text))
23   	MyConn.Open()
24           Cmd.ExecuteNonQuery()
25   	MyConn.Close()        
26   	label1.visible="true"
27   
28   	BindData()
29   	label1.text = "Your data has been received!"
30   End Sub
31   
32   Sub BindData()
33   	Dim MySQL as string = "Select * from tblCustomer order by CustID desc"
34           Dim myConn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
35            "Data Source=" & Server.MapPath("db\gsb.mdb") & ";")
36   	Dim ds as DataSet=New DataSet()
37           Dim da As New OleDbDataAdapter(MySQL, myConn)
38           da.Fill(ds, "Customer")
39   	MyConn.Close()
40   End Sub
41   
42   Sub cleartextboxes(Source as Object, E as EventArgs)
43   	Dim myForm As Control = Page.FindControl("CustRequest")
44   	Dim ctl As Control
45   	For Each ctl In myForm.Controls
46   		If ctl.GetType().ToString().Equals("System.Web.UI.WebControls.TextBox") Then
47   			CType(ctl, TextBox).Text = ""
48   		End If
49   	Next ctl
50   End Sub
51   </script>
52   
53   
54   <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
55   <html xmlns="http://www.w3.org/1999/xhtml">
56   <head>
57   <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
58   <title>Untitled Document</title>
59   </head>
60   <body>
61   <form id="CustRequest" runat="server">
62   <table width="745" border="0" cellspacing="0" cellpadding="0">
63     <tr>
64       <td width="226"><div align="right">Name
65         <asp:TextBox ID="frmCust_Name" runat="server" />      
66       </div>      </td>
67       <td width="487">&nbsp;</td>
68       <td width="32">&nbsp;</td>
69     </tr>
70     <tr>
71       <td><div align="right">Surname
72         <asp:TextBox ID="frmCust_Surname" runat="server" />      
73       </div>      </td>
74       <td>&nbsp;</td>
75       <td>&nbsp;</td>
76     </tr>
77     <tr>
78       <td>Address 1
79       <asp:textbox id="frmCust_Address1" runat="server" /></td>
80       <td>&nbsp;</td>
81       <td>&nbsp;</td>
82     </tr>
83     <tr>
84       <td>Address 2
85         <asp:textbox id="frmCust_Address2" runat="server" />      </td>
86       <td>&nbsp;</td>
87       <td>&nbsp;</td>
88     </tr>
89     <tr>
90       <td>Address 3
91       <asp:textbox id="frmCust_Address3" runat="server"  /></td>
92       <td>&nbsp;</td>
93       <td>&nbsp;</td>
94     </tr>
95     <tr>
96       <td>State
97         <asp:TextBox id="frmCust_State" runat="server" /></td>
98       <td>&nbsp;</td>
99       <td>&nbsp;</td>
100    </tr>
101    <tr>
102      <td>Zip Code
103        <asp:TextBox id="frmCust_Zip_Code" runat="server" /></td>
104      <td>&nbsp;</td>
105      <td>&nbsp;</td>
106    </tr>
107    <tr>
108      <td>Tel No
109      <asp:textbox id="frmCust_TelNo" runat="server" /></td>
110      <td>&nbsp;</td>
111      <td>&nbsp;</td>
112    </tr>
113    <tr>
114      <td>Email
115                  <asp:textbox id="frmCust_Email" runat="server" /></td>
116      <td>&nbsp;</td>
117      <td>&nbsp;</td>
118    </tr>
119    <tr>
120      <td>Verify Email
121    <!--  <asp:textbox id="Verify_Email" runat="server" /> --></td>
122      <td>&nbsp;</td>
123      <td>&nbsp;</td>
124    </tr>
125    <tr>
126      <td>
127      Comments
128          <asp:textbox id="frmComments" runat="server" />    </td>
129      <td>&nbsp;</td>
130      <td>&nbsp;</td>
131    </tr>
132    <tr>
133      <td><asp:button id="button1" Text="Insert" onclick="doInsert" runat="server" />
134        
135  <asp:Button id="button3" Text="Clear" onclick="cleartextboxes" causesvalidation="false" runat="server" /></td>
136      <td>&nbsp;</td>
137      <td>&nbsp;</td>
138    </tr>
139  </table>
140  <div align="center"><b><i><asp:Label ID="label1"  runat="server" /></i></b></div>
141  </form>
142  
143  
144  </body>
145  </html>

an error with GetChildRows()

shamilal — Wed, 21 Jan 2009 05:00:00 GMT

Hi,

I'm using a dataset with parent/child tables and trying to retrive the childs data using GetChildRows(). I get the following exceptionand don't know how to resolve it:

TransReg is the parent table and TransServices is the child table.

Exception message: GetChildRows requires a row whose Table is TransReg, but the specified row's Table is TransReg.

I'm using the following code:

TransArenaDS MainDS = new TransArenaDS();

TransArenaDS.TransRegDataTable TRdt = new TransArenaDS.TransRegDataTable();

TransArenaDS.TransServicesDataTable TSdt = new TransArenaDS.TransServicesDataTable();

TransRegBLL TmpTransReg = new TransRegBLL();

TransServiceBLL TmpTransServices = new TransServiceBLL();

TRdt = TmpTransReg.GetTransRegData();

TSdt = TmpTransServices.GetServicesDataTable();

MainDS.Tables.Add(TRdt);

MainDS.Tables.Add(TSdt);

DataRelation rel = new DataRelation("TransReg_TransServices", MainDS.TransReg.TransSerialNumColumn, MainDS.TransServices.TransSerialNumColumn );

rel.Nested = true;

MainDS.Relations.Add(rel);

DataRow[] arrRows;

foreach (DataRow myRow in TRdt.Rows)

{

arrRows = myRow.GetChildRows(rel);

}

Your help will be very appreciated....

thanks ahead

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Cohen Asaf — Wed, 10 Dec 2008 05:00:00 GMT

Hi,

I get this error when calling a Get command from a Dataset like so: Gridview1.DataSource = tableAdapter.GetData(Param.ToString());

The error happens on one stored procedure but not another, both only return data with no ID columns.

I am returning a SQL datetime and two Varchar values that are inserted adn cannot have any nulls or be too long.I have changed all the returned field enable null to true; set the EnforceConstraints to false in the Dataset but to no avail.

Reading all the posts regarding this issue i eventually rebuilt the Dataset (though the DB has never changed) That caused all the calls to the adapter to cause this error and now none of them work.

This is causing me to wonder weather it is worth working with the business model with all the problems.

Assistance would be appreciated.

Hi I need help in Dataset

azwaralam — Mon, 10 Nov 2008 05:00:00 GMT

Hi i m generating Dataset from CSV file and i have to insert this Dataset into Sql Server Table. Sql Server Tables have same columns as in Dataset. How can i Insert Dataset into Sql Server Tables.

Thanks in Advance.

Databind in Datagrid...

prnkrish — Thu, 09 Oct 2008 04:00:00 GMT

HI all,

I would like to do a task in .net. The task is ....I need to bind the

table data into datagrid....without using DB... please help me by giving the

sample....

Thanks in Advance....