Is it possible to join datasets in asp.net?
101566
Well you can join _tables_ together in such a way. But because the DataRelation object is added to the DataSet's .Relations collection, they do have to be inside the same DataSet.\n\nWhy, out of curiosity, are you using separate DataSets? Even if you are drawing from two different databases, there is nothing that compels you to use separate DatSets at all. Even if you are using a SqlDataAdapter and a SqlCommandBuilder to cause updates and inserts, the DataAdapter's .Update() command accepts DataTable parameters - there's no need to have these be in separate DatSets. \n\nConsider rewriting your code to consolidate the DataSet...
735575
Try this one -\nhttp://www.datapigtechnologies.com/
367046
your question is not quite clear, may be you can explain it to me and i hope i could be a help to you, I been working with Data Reports in VB6 lately, and it works fine with me.
1083678
Question is not clear. \n\nAnyway, If you are using DataGrid or GridView, they have built-in features on ASP.NET. If not, you can impletment this manually using tricks.\n\nPlease explain your requirement with language, platform etc.
618134
u can convert the VB6 file first into a Vb.net file then from Vb.net u can convert to ASP.net file with out any interface but u should run that file in VS2002 or VS2003 they u have the compiler for that....
825721
I doubt it, but if the code is simple enough it just might.  Otherwise you're just wishing for forward compatibility.  Can you switch over to an asp.net1.1 server to test it at home?
825263
2005 is so much better than 1.x.  There are a myriad of new freatures in 2.0.  You can use MasterPages for your website layouts.  There are web parts that would enable a web user to customize a webpage by being able to shift elements around on the page.  The DataGrid was replaced by GridView, which is easier to work with.  You can also use SqlDataSource to populated Data Controls.  The SqlDataSource will save you time so you don't have to write connection code.\n\n2.0 now has local database support.  You can add a database right to your APP_DATA folder, which you'll be able to build and connect to with ease.  You can only access this database from the project you are working in.  If you want to make the database live on a webhost, you have to copy the .mdf or generate script to move it.\n\nClasses now have a keyword called "Partial", which would allow you to have the same class name over many areas.  This is so, if you are working in a team environment, many co-workers can work on their own version of the same class without writing over each others' code.  At compile time, these same files will be compiled together.\n\nThere is just too many things to list on here.  If I were you, I would go to ASP.NET QuickStarts and go from there.  There is a lot of information you can learn from there.\n\nAlso, if you haven't already, download the startkits from ASP.NET.  The starterkits are useful and powerful, and not just some cheesy website example.
652437
http://www.codeproject.com/aspnet/wordapplication.asp
241948
wrox publishing has a book called Begining ASP Databases, you would want the newer .NET version now:\nhttp://search.barnesandnoble.com/BookSearch/isbnInquiry.asp?z=y&isbn=076454375X&itm=1\nI learned with that and a book on SQL server specifically:\nhttp://search.barnesandnoble.com/BookSearch/isbnInquiry.asp?z=y&isbn=1861002319&itm=6\n\nIts a lot of fun, good luck!
1124098
In VS.NET Xpress u can connect with databases using \n1.SqlClient, 2. OleDb, 3. Odbc\nThese classes hav inbuild methods that makes everything simpe and sweet.\n\nFor indepth coverage on these topic visit microsoft's MSDN, Also go thru sqljunkies.com, dotnetjunkies.com\n\nOleDb Code Sample\n************************************************\n\n\nusing System;\nusing System.Data;\nusing System.Data.OleDb;\n\nclass Sample\n{\npublic static void Main()\n{\nOleDbConnection nwindConn = new OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind");\n\nOleDbCommand catCMD = nwindConn.CreateCommand();\ncatCMD.CommandText = "SELECT CategoryID, CategoryName FROM Categories";\n\nnwindConn.Open();\n\nOleDbDataReader myReader = catCMD.ExecuteReader();\n\nwhile (myReader.Read())\n{\nConsole.WriteLine("&#92;t{0}&#92;t{1}", myReader.GetInt32(0), myReader.GetString(1));\n}\n\nmyReader.Close();\nnwindConn.Close();\n}\n}\n\nOdbc Code Sample\n************************************************\nusing System;\nusing System.Data;\nusing System.Data.Odbc;\n\nclass Sample\n{\npublic static void Main()\n{\nOdbcConnection nwindConn = new OdbcConnection("Driver={SQL Server};Server=localhost;" +\n"Trusted_Connection=yes;Database=northwind");\n\nOdbcCommand catCMD = new OdbcCommand("SELECT CategoryID, CategoryName FROM Categories", nwindConn);\n\nnwindConn.Open();\n\nOdbcDataReader myReader = catCMD.ExecuteReader();\n\nwhile (myReader.Read())\n{\nConsole.WriteLine("&#92;t{0}&#92;t{1}", myReader.GetInt32(0), myReader.GetString(1));\n}\n\nmyReader.Close();\nnwindConn.Close();\n}\n}
149620
This question seems to be incomplete. By this u want to add  or update a record to a table or add a table to a database. Dataset usually refers to a collection of data. Moreover, u haven't mentioned which database u r using(like mysql, msaccess) and how do u want to update( by using front end like java, vb.net or just directly by writing sql query).\n\nAny way, if it is a sql query here are some basic syntax,\n\n(Though these are MySQL Syntax, these are standard SQL Queries and can run very well in all databases...)\n\nFor Inserting a record into a table.\n  INSERT INTO table_name (column1, column2,...)\nVALUES (value1, value2,....);\n\nFor Updating a record into a table,\n\nUPDATE [LOW_PRIORITY] [IGNORE] tbl_name\n    SET col_name1=expr1 [, col_name2=expr2 ...]\n    [WHERE where_definition]\n    [ORDER BY ...]\n    [LIMIT row_count]\n\nFor creating table, \nCREATE TABLE table_name\n(\ncolumn_name1 data_type,\ncolumn_name2 data_type,\n.......\n)\n\nIf u have a table, but want to create a copy of the table,\n\nCREATE TABLE new_tbl LIKE orig_tbl;\n\nBasic SQL Tutorial and Mysql Manual can be accessed by the links given in sources.\n\n Moreover, if u want to do any access to database from a front end(like java or C#), then u need to know about JDBC,ODBC concepts and it is dependent on the language also. For that u need to refer the language references.\n\n The link given below is only for mysql, for other databases(like SQL Server, MSAccess, Postgresql, Oracle), u can refer the manual for the detailed explanation with syntax and explanations.\n\n  Sorry devvygirl, my knowledge in VB.NET is very limited.
1080657
If you need to persist data across several different applications, I would suggest persisting the information to the database in the form of a profile. I believe that 2.0 offers this type of functionality almost out of the box.\n\nYou might want to google for .net profiles:\nhttp://www.google.com/search?hl=en&q=.net+2.0+profiles
902494
It is not possible because ASPNET runtime takes care of it, as it is not changed accidently.\nAlso, if u change it the web-application is restarted as u should take a note of this.\n\nEven if, u want to change go with some simple file-handling code.
1066458
You can use the GridView control, implement a templatefield column and inside of that have a new SqlDataSource and GridView control.  Note, that SqlDataSource aren't data binding friendly hense the ugly binding w/ old school DataBinder calls. Psuedo code below. (Yahoo answers hates my code blocks, but you should be able to gather a solution from it).\n\n<asp:GridView id="SomeGridView" runat="server" DataSourceId="CustomersDataSource">\n<Columns><asp:TemplateField><ItemTemplate>\n\nCurrent Customer : <%# Eval("CustomerName") %><br>\n\n<asp:GridView id="CustomerProductsGridView" runat="server" DataSourceId="CustomerProductsDataSource"><Columns>(omitted for example)</Columns></asp:GridView">\n\n<asp:SqlDataSource id="CustomerProductsDataSource" SelectCommand='<%# "select * from Products where CustomerId= " + DataBinder.Eval(Container.DataItem, "CustomerId") %>'></asp:SqlDataSource>\n\n</ItemTemplate></asp:TemplateField></Columns>\n</asp:GridView>\n\n<asp:SqlDataSource id="CustomerDataSource" SelectCommand="select * from Customers"></asp:SqlDataSource>
93034
datamining\nnetworking\ndatabasing
789826
Your probably would have to have SQL, but even that would not be enough. You'd need a log viewer as well.
868100
Sounds like you want to use a database like Filemaker. With a database you can create custom reports that could be used as tests.