Search:

Hi All!

I can use the Transfer object to move all data from one table to another, but I need the capability to use where clauses before the actual data transfer takes place. Does anyone know if...

If you are reading from a database then you really need a data access object class and a business logic object class.

I am guessing that the database-table in your parent form is a Datatable. ...

in addition.. you can also do something like below



using System;
using System.Collections.Generic;
using System.Text;

namespace ConsoleApplication2
{

Hey Guys, I need some advice. I am using custom objects with a data access layer and a business object layer that derive from a database. I have multiple tables that have foreign keys so the foreign...

I am curious as to why would you want to go from a generic list of what I possibly may think is a custom object to a datatable?

On another note why could you not just bind a generic list to the...

try separating DataSource into two words like Data Source.

I think you need to to refresh your info.

have you tried to insert an html refresh script on the page?

The single quote is screwing the sql statement up. Take the single quote out and it should run correctly:)

Below is another method:)





-- Exporting SQL Server Table to an excel spreadsheet
-- The columns need to be named first before exporting...

I dont know what compiler came with your book, but here is a free one from microsoft.

C# Express Compiler -> http://msdn.microsoft.com/vstudio/express/visualcsharp/download/default.aspx

Remote...

Add a template field (empty field) to the gridview in the edit properties menu. Then set the rowdatabound property to the below method:)




protected void gridviewcreationintercept(object...

Is excel installed on the web host server?

Here is a link that could get you started in the right direction:)

http://aspalliance.com/509#Page2

Here is a VB.net method that populates a gridview from a sql server database:)




Public Sub PopulateGridView1()
Dim conn As System.Data.SqlClient.SqlConnection = New...

You really should be using the bit datatype and not integer for bits. If the datatype is of bit then a gridview sees bits as checkboxes:)

HTH

Here is a method I created and reuse for executing a stored procedure and retrieving the returned data. The listbox is just for demo :)




/// <summary>
/// Retrieve data from a...

There probably is a better way, but a record line counter would work. For example, record how many lines were last read then get all new lines wrote.

This type of file opens C++ header and class files for me. not sure this will help you, but it may shed some light on what you are trying to accomplish.

Hi friends!

I need some help. How can I change an image's color/texture from a different picture? Example if I had a picture of a box and it was blue to start with and after picking a red image...

Anyone have information on reading the registry remotely?

How to read from access using SQL statements:)




Private Sub ReadUsingSQL()

lv1.Items.Clear()
Dim aConnection As OleDb.OleDbConnection = New...

there are many ways. here is one that executes sql statements(access database)






Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...

Is the sql server setup to use both windows and sql authentication?

how to check:
Open The SQL Server Enterprise Manager
Start menu > Programs > Microsoft SQL Server > Enterprise Manager) ...

inserting the variables into a string array like dglienna posted earlier should work.. Check out the example below.




Open FileName$ For Input As #FileHandle

Do While Not...

You could return true or false depending on if the file exists like below.





private bool CheckFile(string f)
{
if (f.Trim().Length > 0)
{