Difference between datarow and datarow()?
925097
datarow() is the start of a module, you don't need the () to declare something, unless you're declaring the dr() module as the variable of datarow.\n\nSo  dim dr as datarow() would be declaring the variable dr as the datarow() module, and vice versa.
310994
by using tamplate coulumn\nu can use a button.for detail in datagrid
902027
I have used VB for years and as far as I know, it doesnt have dynamic arrays. VB was not designed to be used like that so it probably doesnt have a syntax for it.
254248
For what you are doing, there is no practical difference.\n\nThere are differences in terms of complex database activities, such as using triggers; changing server variables on the database server; error handling; the nature of the way data is returned, and other very complex, vary narrow semantics.
74599
Decimal is a built-in datatype
768485
I'm not exactly clear on what you're trying to do with the second button, but if you're binding the datagrid from a query, you should be able to set the DataKeyField property of the datagrid to the primary key of your query.  It will then automatically be stored for each row when the datagrid is bound.\n\nYou can then retrieve it by using a line like:\n\n            Dim PID As Integer = Val(source.datakeys(e.Item.ItemIndex))\n\nIf this doesn't help, contact me with the exact error message you're receiving and with more info about what you are using the second button for, and I'll try to help.\n\n- Rich\nhttp://www.IMAgolfer.com
171625
Request.ServerVariables["REMOTE_ADDR"].ToString() \n\n\n"REMOTE_ADDR" is just string. It's built in.
125012
If you know that the column name exists in the table that is used in the query, then possibly the column that you are comparing is a CHAR type of column.  In that case, make sure that you surround the data with single quotes.\n\nSELECT * FROM SomeCharTable WHERE SomeColumn='ABC123'\n\nThe above should work for a column that is a CHAR type column.  It is important to put the single quote (') around the text.  Note, in the example above, "SomeColumn" must be a column that exists in the table "SomeCharTable".
92683
- There is no difference between Data Access Object 3.5 and Data Access Object 3.6.\n- Only a few patches added which cannot be identificed since its internal handling large database.\n- all the best.\n-------------
95688
This can be done without too much trouble. Start by creating a text box on the page, then on the button click event, query the database based on the textbox content, for example if the box will contain a name or fragment of the name, then use this as your command text:\n"SELECT * FROM [table] WHERE [field] LIKE '%" + TextBox1.Text + "%'"\n\nThis query will return anything that starts with, contains, or ends with the text in box 1.  Then you display that data by binding the datatable the contains the new data with your datagrid. \n\nGood Luck!
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>
440046
You store the datasource that you made access into the datagrid..\n\nVery straight forward. Look in the properties panel :)\n\nHope it helped!
999825
textbox1.text = date.today()\nOr\ndateTimePicker1.value = date.today()
767431
you need to cast the value. try this\n\nDouble.parseDouble(someStingValue);\nyou can use the variable as a double then.
225729
do like this.\n<select name=combo1><option value=rs.getString("attribute")>rs.getString("attribute")</option>\n<option value=...>...</option>\n.....\n</select>\nwhere rs is the ResultSet object.\n\nI think this serves your purpose, i think javascript wont solve ur problem, since u have to display the combo with the options that were obtained from the database.
209262
Global variables are self contained in each workbook.  If there are more than one workbook open at the same time then you can pass the variable through.\n\nat the top of your code type:\n\nPublic Const myString = "yourdataVariable"\n   (if your variable is constant)\n\nDim myString as String\n   (if your variable changes)\n\nafter you tyep it in and hit enter there will appear a line break. this will show that all var's above the line are global\n\nIf worse comes to worse you can always open the workbook were you want to variable passed and put it in a cell and then use another variable to pick up its value
1147478
Memory Handling.\nWhatever memory space you occupy by instantiating the objects should be released after your use.\nType Casting should also be taken care.