Search results matching tag 'DataSet'

Sotre the data with out using database

sarathy — Mon, 14 Dec 2009 05:00:00 GMT

Hello friend i want to store the a data(single data),with out storing database any one help with example...

.NET 1.1 Dataset.ReadXml error. Remote server returned an error (503). Server Unavailable.

digimetic — Wed, 09 Dec 2009 05:00:00 GMT

Hi,

I've an old 1.1 app that I'm updating. There's a function in there using the Dataset.ReadXml method where it's just passing in a file name and XmlReadMode.InferSchema.

here's the code:

ds = new DataSet();
ds.ReadXml(@"XML/marketImageDefaults.xml", XmlReadMode.InferSchema);

This has been working for quite some time. Now, the ReadXml method is throwing an exception:

"The remote server returned an error: (503) Server Unavailable."

Funny thing is that there isn't any remote server involved in any of this. The xml file in question is sitting in a subdirectory from where the executable is located. And again, this has been working for quite a while. Also, the xml file hasn't changed, and its contents are preceeded with

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE marketImageDefaults PUBLIC "-//W3C/DTD XHTML 1.0 TRANSITIONAL//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

Any thoughts on why this is happening? Was there some sort of update to security or the framework that now requires some additional setting or something? Many thanks in advance,

- B

Re: Help me on how to Export datagrid data to Excel?

waqas_w — Tue, 08 Dec 2009 05:00:00 GMT

public static void ConvertDstoExcel(DataSet ds ,HttpResponse response)
    {
    
        response.Clear();
        response.Charset = "";
    
        response.ContentType = "application/vnd.ms-excel";
    
        StringWriter stringWrite = new StringWriter();
        HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        
        DataGrid dg = new DataGrid();
        dg.DataSource = ds.Tables[0];
        dg.DataBind();
    
        dg.RenderControl(htmlWrite);
    
        response.Write(stringWrite.ToString());
        response.End();
    }

hope its helpfull

How To Convert A DataSet To CSV

mkamoski — Fri, 04 Dec 2009 05:00:00 GMT

Ever wanted to convert a simple DataSet to a CSV file?

Well, have I have a GEFN method for you!!!

Some code is below.

Here is a link...

http://mkamoski1.wordpress.com/2009/12/04/convert-from-dataset-to-csv/

/// <summary>
/// This will convert the given DataTable to a Csv.
/// </summary>
/// <param name="targetData">This is the data to convert.</param>
/// <returns>This is a Csv list.</returns>
public static string ConvertToCsv(DataTable targetData)
{
	string myCsv = "";

	if (targetData == null)
	{
		throw new System.ApplicationException("The given object, targetData, is null.");
	}

	DataTable myDataTable = targetData.Copy();
	DataSet myDataSet = new DataSet();
	myDataSet.Tables.Add(myDataTable);

	//Call a helper.
	myCsv = Team.Framework.Common.Core.Utility.ConvertToCsv(myDataSet);

	return myCsv;
}

/// <summary>
/// This will convert the given DataSet to a Csv.
/// </summary>
/// <param name="targetData">This is the DataSet to convert, at most 1 DataTable.</param>
/// <returns>This is a Csv list.</returns>
public static string ConvertToCsv(DataSet targetData)
{
	string myCsv = "";

	if (targetData == null)
	{
		throw new System.ApplicationException("The given object, targetData, is null.");
	}

	if (targetData.Tables == null)
	{
		throw new System.ApplicationException("The given object, targetData.Tables, is null.");
	}

	const int DefaultRequiredTableCount = 1;

	if (targetData.Tables.Count != DefaultRequiredTableCount)
	{
		throw new System.ApplicationException("ActualTableCount='" + targetData.Tables.Count.ToString() +
			"' must equal RequiredTableCount='" + DefaultRequiredTableCount.ToString() + "'.");
	}

	if (targetData.Tables[0] == null)
	{
		throw new System.ApplicationException("The given object, targetData.Tables[0], is null.");
	}

	if (targetData.Tables[0].Columns == null)
	{
		throw new System.ApplicationException("The given object, targetData.Tables[0].Columns, is null.");
	}

	if (targetData.Tables[0].Rows == null)
	{
		throw new System.ApplicationException("The given object, targetData.Tables[0].Rows, is null.");
	}

	//Get a helper.
	StringBuilder myBuilder = new StringBuilder();

	//Add a row in the Csv that contains the columns-names from the DataTable.

	bool isFirst1 = true;

	foreach (DataColumn myColumnTemp1 in targetData.Tables[0].Columns)
	{
		string myValueTemp1 = "";

		if (isFirst1)
		{
			isFirst1 = false;
		}
		else
		{
			myBuilder.Append(",");
		}

		myBuilder.Append("\"");
		myValueTemp1 = myColumnTemp1.ColumnName;
		myValueTemp1 = myValueTemp1.Replace("\"", "\"\"");
		myBuilder.Append(myColumnTemp1.ColumnName);
		myBuilder.Append("\"");
	}

	//Add a row in the Csv for each row in the DataTable.

	foreach (DataRow myRowTemp in targetData.Tables[0].Rows)
	{
		myBuilder.Append(Environment.NewLine);
		bool isFirst2 = true;

		foreach (DataColumn myColumnTemp2 in targetData.Tables[0].Columns)
		{
			string myValueTemp2 = "";

			if (isFirst2)
			{
				isFirst2 = false;
			}
			else
			{
				myBuilder.Append(",");
			}

			myBuilder.Append("\"");

			if ((myRowTemp[myColumnTemp2.ColumnName].GetType() == typeof(bool)) ||
				(myRowTemp[myColumnTemp2.ColumnName].GetType() == typeof(byte)) ||
				(myRowTemp[myColumnTemp2.ColumnName].GetType() == typeof(char)) ||
				(myRowTemp[myColumnTemp2.ColumnName].GetType() == typeof(decimal)) ||
				(myRowTemp[myColumnTemp2.ColumnName].GetType() == typeof(double)) ||
				(myRowTemp[myColumnTemp2.ColumnName].GetType() == typeof(float)) ||
				(myRowTemp[myColumnTemp2.ColumnName].GetType() == typeof(int)) ||
				(myRowTemp[myColumnTemp2.ColumnName].GetType() == typeof(long)) ||
				(myRowTemp[myColumnTemp2.ColumnName].GetType() == typeof(sbyte)) ||
				(myRowTemp[myColumnTemp2.ColumnName].GetType() == typeof(short)) ||
				(myRowTemp[myColumnTemp2.ColumnName].GetType() == typeof(string)) ||
				(myRowTemp[myColumnTemp2.ColumnName].GetType() == typeof(uint)) ||
				(myRowTemp[myColumnTemp2.ColumnName].GetType() == typeof(ulong)) ||
				(myRowTemp[myColumnTemp2.ColumnName].GetType() == typeof(ushort)))
			{
				myValueTemp2 = myRowTemp[myColumnTemp2.ColumnName].ToString();
				myValueTemp2 = myValueTemp2.Replace("\"", "\"\"");
			}
			else
			{
				myValueTemp2 = "";
			}

			myBuilder.Append(myValueTemp2);
			myBuilder.Append("\"");
		}
	}

	myCsv = myBuilder.ToString();

	return myCsv;
}

HTH.

Thank you.

-- Mark Kamoski

What is Adapter?

worldcopyright — Tue, 17 Nov 2009 05:00:00 GMT

I'm reading a book here and I'm trying to make an example. I need to create a class which provide Business Logic Layer.

The class code looks so:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel;

public class ArticleBLL
{
    [DataObjectMethodAttribute(DataObjectMethodType.Select, true)]
    public DataSet1.ArticlesDataTable GetArticles()
    {
        return Adapter.GetData();
    }

}

It is situated in App_Code/BLL folder.
I have DataSet1.xsd in App_Code/DAL folder

And I have a error on this line

return Adapter.GetData();

How I can make this class working?

XML Addrow with populated DataSet from XSD with Relationship...

GBOgel — Thu, 12 Nov 2009 05:00:00 GMT

Hey,

I'm developing a gallery with XML. First i have made a XSD and populated XML from Xsd. XSD has relationship...

In code need relational Row needed so that's my problem how can i add row instead Category Name

    protected void btnAdd_Click(object sender, EventArgs e)
    {
        Gallery gallery = new Gallery();
        if (File.Exists(Server.MapPath("~/Gallery.xml")))
        {
        gallery.ReadXml(Server.MapPath("~/Gallery.xml"));
        gallery.Tbl_Category.AddTbl_CategoryRow("0", "1");
        }
    }

- Here is my XSD and XML;

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Gallery" targetNamespace="http://tempuri.org/Gallery.xsd" xmlns:mstns="http://tempuri.org/Gallery.xsd" xmlns="http://tempuri.org/Gallery.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections />
        <Tables />
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Gallery" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="Gallery" msprop:Generator_DataSetName="Gallery">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Tbl_Picture" msprop:Generator_UserTableName="Tbl_Picture" msprop:Generator_RowDeletedName="Tbl_PictureRowDeleted" msprop:Generator_RowChangedName="Tbl_PictureRowChanged" msprop:Generator_RowClassName="Tbl_PictureRow" msprop:Generator_RowChangingName="Tbl_PictureRowChanging" msprop:Generator_RowEvArgName="Tbl_PictureRowChangeEvent" msprop:Generator_RowEvHandlerName="Tbl_PictureRowChangeEventHandler" msprop:Generator_TableClassName="Tbl_PictureDataTable" msprop:Generator_TableVarName="tableTbl_Picture" msprop:Generator_RowDeletingName="Tbl_PictureRowDeleting" msprop:Generator_TablePropName="Tbl_Picture">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PId" msprop:Generator_UserColumnName="PId" msprop:Generator_ColumnVarNameInTable="columnPId" msprop:Generator_ColumnPropNameInRow="PId" msprop:Generator_ColumnPropNameInTable="PIdColumn" type="xs:string" />
              <xs:element name="PName" msprop:Generator_UserColumnName="PName" msprop:Generator_ColumnVarNameInTable="columnPName" msprop:Generator_ColumnPropNameInRow="PName" msprop:Generator_ColumnPropNameInTable="PNameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="PThumb" msprop:Generator_UserColumnName="PThumb" msprop:Generator_ColumnVarNameInTable="columnPThumb" msprop:Generator_ColumnPropNameInRow="PThumb" msprop:Generator_ColumnPropNameInTable="PThumbColumn" type="xs:string" minOccurs="0" />
              <xs:element name="PComment" msprop:Generator_UserColumnName="PComment" msprop:Generator_ColumnVarNameInTable="columnPComment" msprop:Generator_ColumnPropNameInRow="PComment" msprop:Generator_ColumnPropNameInTable="PCommentColumn" type="xs:string" minOccurs="0" />
              <xs:element name="CatId" msprop:Generator_UserColumnName="CatId" msprop:Generator_ColumnVarNameInTable="columnCatId" msprop:Generator_ColumnPropNameInRow="CatId" msprop:Generator_ColumnPropNameInTable="CatIdColumn" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tbl_Category" msprop:Generator_UserTableName="Tbl_Category" msprop:Generator_RowDeletedName="Tbl_CategoryRowDeleted" msprop:Generator_RowChangedName="Tbl_CategoryRowChanged" msprop:Generator_RowClassName="Tbl_CategoryRow" msprop:Generator_RowChangingName="Tbl_CategoryRowChanging" msprop:Generator_RowEvArgName="Tbl_CategoryRowChangeEvent" msprop:Generator_RowEvHandlerName="Tbl_CategoryRowChangeEventHandler" msprop:Generator_TableClassName="Tbl_CategoryDataTable" msprop:Generator_TableVarName="tableTbl_Category" msprop:Generator_RowDeletingName="Tbl_CategoryRowDeleting" msprop:Generator_TablePropName="Tbl_Category">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CatId" msprop:Generator_UserColumnName="CatId" msprop:Generator_ColumnVarNameInTable="columnCatId" msprop:Generator_ColumnPropNameInRow="CatId" msprop:Generator_ColumnPropNameInTable="CatIdColumn" type="xs:string" />
              <xs:element name="CatName" msprop:Generator_UserColumnName="CatName" msprop:Generator_ColumnVarNameInTable="columnCatName" msprop:Generator_ColumnPropNameInRow="CatName" msprop:Generator_ColumnPropNameInTable="CatNameColumn" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1">
      <xs:selector xpath=".//mstns:Tbl_Picture" />
      <xs:field xpath="mstns:CatId" />
    </xs:unique>
    <xs:unique name="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tbl_Picture" />
      <xs:field xpath="mstns:PId" />
    </xs:unique>
    <xs:unique name="Tbl_Category_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tbl_Category" />
      <xs:field xpath="mstns:CatId" />
    </xs:unique>
    <xs:keyref name="FK_picture_Category" refer="Constraint1" msprop:rel_Generator_UserRelationName="FK_picture_Category" msprop:rel_Generator_RelationVarName="relationFK_picture_Category" msprop:rel_Generator_UserChildTable="Tbl_Category" msprop:rel_Generator_UserParentTable="Tbl_Picture" msprop:rel_Generator_ParentPropName="Tbl_PictureRow" msprop:rel_Generator_ChildPropName="GetTbl_CategoryRows">
      <xs:selector xpath=".//mstns:Tbl_Category" />
      <xs:field xpath="mstns:CatId" />
    </xs:keyref>
  </xs:element>
</xs:schema>

------------------------------------------------------------------------------------------------------------------------------

<?xml version="1.0" encoding="utf-8" ?>
<Gallery xmlns="http://tempuri.org/Gallery.xsd">
  <Tbl_Picture>
    <PId></PId>
    <PName></PName>
    <PThumb></PThumb>
    <PComment></PComment>
    <CatId></CatId>
  </Tbl_Picture>
  <Tbl_Category>
    <CatId></CatId>
    <CatName></CatName>
  </Tbl_Category>
  </Gallery>

SqlDataAdapter Update no work

cc75 — Wed, 04 Nov 2009 05:00:00 GMT

Hi guy i've one problem with sqldataadapter. I've one simple web form with 3 txb (no sqldatabuilder, no datagrid ect ect). When i public my page i see the loaded value into my txb but when change value and after push button update the value into database sql no change Any idea? Thx

protected void Page_Load(object sender, EventArgs e)
    {
       if (!IsPostBack)

        {
            String connString = ConfigurationManager
                      .ConnectionStrings["connstr"].ConnectionString;
            SqlConnection conn = new SqlConnection(connString);
            conn.Open();
            string qry = "SELECT Nam, LastName, UserName FROM tblus WHERE Id = @Id";
            SqlDataAdapter da = new SqlDataAdapter(qry, conn);
            da.SelectCommand.Parameters.Add("@Id", SqlDbType.Int);
            da.SelectCommand.Parameters[("@Id")].Value = keyy2.Text;
            DataSet ds = new DataSet();
            da.Fill(ds, "tblus");
            txtname1.Text = (string)ds.Tables[0].Rows[0][0];
            txtlastname1.Text = (string)ds.Tables[0].Rows[0][1];
            myEditor.Content = (string)ds.Tables[0].Rows[0][2];

            conn.Close();

        }
    }
    protected void update_Click(object sender, ImageClickEventArgs e)
    {

String connString = ConfigurationManager
                          .ConnectionStrings["connstr"].ConnectionString;
       SqlConnection conn = new SqlConnection(connString);
       conn.Open();
       string qry2 = "UPDATE tblus SET Nam = @Nam, LastName = @LastName, UserName = @UserName FROM tblus WHERE (Id = @Id)";
       Int32 Idpeople = 1;
   string qry = "UPDATE tblus SET Nam = @Nam, LastName = @LastName, UserName = @UserName FROM tblus WHERE Id = @Id";
       string qry2 = "SELECT Nam, LastName, UserName FROM tblus WHERE Id = @Id";
       DataSet ds = new DataSet();
       SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(qry2, conn);
       SqlParameter myId = mySqlDataAdapter.SelectCommand.Parameters.Add("@Id", SqlDbType.Int, 5, "Id"); ;
       myId.SourceColumn = "Id";
       myId.Value = keyy2.Text;
       mySqlDataAdapter.Fill(ds, "tblus");
       DataTable Table = new DataTable();
       Table = ds.Tables["tblus"];
       mySqlDataAdapter.UpdateCommand = new SqlCommand(qry, conn);
       DataColumnMapping dcmId = new DataColumnMapping("Id", "Idp");
       DataColumnMapping dcmNam = new DataColumnMapping("Nam", "na");
       DataColumnMapping dcmLastName = new DataColumnMapping("LastName", "ls");
       DataColumnMapping dcmUserName = new DataColumnMapping("UserName", "Us");

          DataTableMapping dtmusers = new DataTableMapping("Table", "tblus");
          dtmusers.ColumnMappings.Add(dcmId);
          dtmusers.ColumnMappings.Add(dcmNam);
          dtmusers.ColumnMappings.Add(dcmLastName);
          dtmusers.ColumnMappings.Add(dcmUserName);
          mySqlDataAdapter.TableMappings.Add(dtmusers);

            SqlParameter myParam = mySqlDataAdapter.UpdateCommand.Parameters.Add("@Id", SqlDbType.Int, 5, "Idpeople");
            myParam.SourceColumn = "Id";
            myParam.Value = keyy2.Text;
            myParam.SourceVersion = DataRowVersion.Original;

            SqlParameter myParam1 = mySqlDataAdapter.UpdateCommand.Parameters.Add("@Nam", SqlDbType.VarChar, 50, "Nam");
            myParam.SourceColumn = "Nam";
            myParam.Value = txtname1.Text;
            myParam.SourceVersion = DataRowVersion.Current;

            SqlParameter myParam2 = mySqlDataAdapter.UpdateCommand.Parameters.Add("@LastName", SqlDbType.VarChar, 50, "LastName");
            myParam.SourceColumn = "LastName";
            myParam.Value = txtlastname1.Text;
            myParam.SourceVersion = DataRowVersion.Current;

            SqlParameter myParam3 = mySqlDataAdapter.UpdateCommand.Parameters.Add("@UserName", SqlDbType.VarChar, 50, "UserName");
            myParam.SourceColumn = "UserName";
            myParam.Value = myEditor.Content;
            myParam.SourceVersion = DataRowVersion.Current;

           mySqlDataAdapter.Update(ds);
        conn.Close();
    }
}

ORA-00932: inconsistent datatypes error

jaylrob — Thu, 29 Oct 2009 04:00:00 GMT

I have cursors set up to return various count(*) s. Im getting the inconsistent datatype error and not sure why. Snippet of code below. Do I have to define an actual datatype in the cursor or something?

        cmdData = New OracleCommand()
        cmdData.Connection = conn
        Dim parms As OracleParameter() = New OracleParameter(14) {}
        parms(0) = New OracleParameter("Ret1", OracleType.Cursor)
        parms(0).Direction = ParameterDirection.Output
        parms(1) = New OracleParameter("Ret2", OracleType.Cursor)
        parms(1).Direction = ParameterDirection.Output
        ' other parameters 

        cmdData.Parameters.AddRange(parms)
        cmdData.CommandType = CommandType.Text
        cmdData.CommandText = "Begin " & _
        "OPEN :Ret1 FOR " & _
        "select count(*) ...;" & _
        "Open :Ret2 For " & _
        " select count(*) ...;" & _
        "end; "

        Dim _adapter As New OracleDataAdapter(cmdData)
        _adapter.SelectCommand = cmdData

        _adapter.Fill(_ds)

        cmdData.Dispose()
        conn.Close()

Convert XSD Files to DataSet

shlomybsh — Tue, 20 Oct 2009 04:00:00 GMT

I`m working with Business Message Standard (BMS) Part of the GS1 System.
and I get Implementers Packet that Contains the XSD files that required for implementation.

I want To convert This xsd Files into One DataSet.
I tried the CustomTool property. with "MSDataSetGenerator"
I`m getting this error Message:

Custom tool error: Failed to generate code. Unable to convert input xml file content to a DataSet. DataSet cannot instantiate an abstract ComplexType for the node command. DataSet cannot instantiate an abstract ComplexType for the node command. D:\Projects\ConsoleApplication1\ConsoleApplication1\OrderProxy.xsd ...

Is someone here work with GS1 Business Message Standard (BMS) ?
Thanks

datagrid not displayed when there are no data rows?

Jay-B — Mon, 19 Oct 2009 04:00:00 GMT

Any way to bind a couple of datagrids to respective DataSets, but not have one table display if there are no rows?

When the query doesn't match actual data, what I get back is a table with just headers, for obvious reasons.

And if there is a way, can I have bound databound columns and still have it not show up, or would I have to use auto generate?

What I get when I search for this, is a lot of information on dynamically generated table columns. If I just knew the proper terminology, I might be able to do better searches.

Thanks,

Jay