Data Access and Storage

MSDNSYS.COM

Tag: .NET Framework Data Access and Storage, .NET Development / Home

Data Access and Storage RSS

NAVIGATION

Zip files from database

Hello,I have datatable with this columns-FileName (varchar)-File(byte)I want to put files from that table into zip arhive using SharpZipLib. Explenation:I have a button in my winForm, when user click on it I want to show him a save file dialog (or something) with zip arhive on it........Can ...

0 answers | 409 bytes |

your workaround didn't work in my case

I did a quick search around this forum and around the web but I can't find any helpful information regarding this problem. Currently, I am running a site on asp.net 2.0 within a shared hosting location. Their SQL backend is 2000. I managed to create the db via aspnet_regsql, and then upload ...

14 answers | 732 bytes |

Your problème with the Update

I tried unsuccessfully to do the job according to the book for over 2 month, could sleep, could not do otherthings, finnaly I opted for writing the output to a text file, and at exit the text file is merged into the access data table.The bad point is the database does not reflect the latest ...

1 answers | 8911 bytes |

You help will be appreciated: Connection to DBF free table files

I have an app which runs perfectly OK on Windows 2000 boxes, but it refuses to run on any XP Pro box. It would always give me an error message: "Provider cannot be found. It may not be properly installed". The error occurs on the Conn.Openline shown below. The code is VBScript. I have ...

5 answers | 846 bytes |

You can have strongly-typed DataTables, or you can have nullable columns. Choose one.

I have a SQL Server database containing a table that includes smalldatetime and bit columns. These columns are nullable.I add a DataSet to my project, drag the table from the Database Explorer window to the DataSet designer surface, and in a matter of moments I have a shiny new FooDataTable ...

14 answers | 2087 bytes |

YesRe: Unable to authenticate on sql server 2005

Hi, I have been trying to connect to a "currently local" database using sql authentication, how ever I also get the error:System.Data.SqlClient.SqlException: Cannot open database "ASPNETDB.MDF" requested by the login. The login failed.Login failed for user 'testuser'.I can ...

13 answers | 1136 bytes |

Year function in sql query

I'm trying to add a field in query design SQL EXPRESS as follow SELECT Year([Created_Date]) as exp1 FROM Tablex or SELECT Datepart(year,[Created_Date]) as Years FROM Tablex Table comming from MSAccess I have donne in MSAccess many time without a problem , but I get an error in SQL what wrong , ...

10 answers | 396 bytes |

yadda yadda for Dummies -- getting data into my project.

OK, here's another newbie question. I run a third party app. I've been able to take data from that app, and by "pasting as link" into excel, manipulate the data (yes, "paste as link" was a new discovery for me, so now you get my level of experience). Now I want to do more stuff with this ...

0 answers | 1052 bytes |

xss file

1. What do the letters "x-s-s" stand for in a file extension, e.g. "myFunkyNorthwind.xss"?2. What does an xss file hold?Thank you. ...

3 answers | 248 bytes |

xsi:type infopath

Hi, I have an XML Schema containing inherited complex types, and xs:elements using @type of the top complex type, meaning, any child complex type can be an instance of that element by declaring the complex type name using xsi:type . If I write the xml by hand, and validate against the xml ...

0 answers | 1934 bytes |

XSD/Typed DataSet not loading DB Relations

I've literally had this problem everytime i've tried to use Typed DataSetI have just a default database made in VS, in it i have 2 tables relating to each other.(Lets say Member Table, and Association Table, ie Members would have 1 association, related by PK in Association and FK in Member)i ...

1 answers | 936 bytes |

Xsd.Exe problem or my Xsd?

Im trying to Read an Xsd in a DataSet, like:dsDataSet.ReadXmlSchema(@"\\test2.xsd");But its throwing an exception, likeException: Type 'http://tempuri.net/test/ts:AddressLevelType' is not declared, or is not a simple type. Even throwing the above exception while Trying to convert ...

1 answers | 748 bytes |

xsd Schema, c#, Calculated Column

Is there a way that, when my table has some calculated columns, and i have a tableadapter on it, that i don't have to change the insert and update statments at each time.Now, when i have created my DataTable and my TableAdapter i must change the scripts for insert and update because it still ...

1 answers | 630 bytes |

xpath to extract xsi:tyep

Hi, i've got an xml document which i am reading into memory, ill post the relevant bits. <?xml version="1.0" encoding="utf-8" ?>  <FpML version="1-0" xsi:type="NewTrade" ...

2 answers | 4568 bytes |

XmlReadmMode.Auto vs XmlReadMode.ReadSchema

Hi,When I read a XML file generated with the DataSet designer with XmlReadMode.Auto it works but when I use the ReadSchema option it doesn't.Why is it happening?Thanks....

0 answers | 180 bytes |

QUESTION ON ".NET Framework Data Access and Storage"

MSDN DEVELOPMENT

Home - About Us - Contact - Privacy Statement - Link Exchange - Bookmark - Map.XML - Rss.Xml
1.141