Ramy Mahrous 401 Postaholic Featured Poster

First you have ID for the row, get the data using the ID, then update the data using the ID... so simple!

Ramy Mahrous 401 Postaholic Featured Poster

blob is binary and I uses this tyoe in my post

Ramy Mahrous 401 Postaholic Featured Poster

You don't have column "UserName"

Ramy Mahrous 401 Postaholic Featured Poster

mmm, I don't know actually but you can comment on this article or ask the author, he may help you.

Ramy Mahrous 401 Postaholic Featured Poster

Create new Job and select your SSIS package and schedule it.

Ramy Mahrous 401 Postaholic Featured Poster

Like you insert or retrieve the data, just change the SQL command, read in OleCommand

Ramy Mahrous 401 Postaholic Featured Poster

I think you can apply this on MS Access http://fci-h.blogspot.com/2008/04/how-to-save-image-in-sql-server.html
at least if you read this post you can do it.

Ramy Mahrous 401 Postaholic Featured Poster

Contact coldFusion technical support.
http://www.adobe.com/products/coldfusion/

Ramy Mahrous 401 Postaholic Featured Poster

Don't generate rdl, design it using SQL Server Reporting Service, return to my previous answers, and know how to send parameters to it, using SetParameters(...)

Ramy Mahrous 401 Postaholic Featured Poster

stuck in what?!

dim img as Image
img = Image.FromStream(new System.IO.MemoryStream(imageAsBytes))
pictureBox.Image = img
Ramy Mahrous 401 Postaholic Featured Poster

You're welcome, I'm happy you solved your problem, please mark it as solved.

Ramy Mahrous 401 Postaholic Featured Poster

What's this?!! I don't understand your question!

Ramy Mahrous 401 Postaholic Featured Poster

Google exists my friend.

Ramy Mahrous 401 Postaholic Featured Poster

ASP.NET forum for web-development questions, here's generic VB.NET forum mainly windows-based application
ASP.NET forum here http://www.daniweb.com/forums/forum18.html

Ramy Mahrous 401 Postaholic Featured Poster

Video, you can use media play component.

Ramy Mahrous 401 Postaholic Featured Poster

if possible give some syntax. its useful for my reference.

As you understand the solution, coding is easier...

Ramy Mahrous 401 Postaholic Featured Poster

From Management->Maintenance plans->Right click on your plan->Subplan schedule..

Ramy Mahrous 401 Postaholic Featured Poster

If you want to show detailed data on GridView based on master data on TreeView, say TreeView holds Car Models and you need when use selects Car Model from TreeView, its details shows in GridView.
You'd have DataSource which takes Car Model as a parameter, and assign GridView.DataSource to it, when user selects node send its name to the DataGrid DataSource to fill it.

Ramy Mahrous 401 Postaholic Featured Poster

Do you know how do get blob as binary (array of bytes) if you can, read this post http://fci-h.blogspot.com/2008/04/how-to-save-image-in-sql-server.html

Ramy Mahrous 401 Postaholic Featured Poster

I think you should add the row\column to the DataTable(The Data Source of the Grid) then bind the Grid again.

Ramy Mahrous 401 Postaholic Featured Poster

I'll answer the subject of the thread, you can read in System.IO.File

Ramy Mahrous 401 Postaholic Featured Poster
//Here you create new MenuItem
//Here you play with some MenuItem properties 
MenuItem.Click+=new System.EventHandler(this.AnyMenuItem_Click);
private void AnyMenuItem_Click(object sender, System.EventArgs e)
{
// your code to get the URL and open it
}
Ramy Mahrous 401 Postaholic Featured Poster

I attached the images, I hope it clarifies...

ddanbe commented: Very intructive! This man knows what he his doing! +4
Ramy Mahrous 401 Postaholic Featured Poster

Look, my friend Danny, they're different
Array of Array == one-to-many, imagine every cell in the above array has all cells in the below array..
I know, I can describe it but I'll draw it for you...

Ramy Mahrous 401 Postaholic Featured Poster

I think ImageList helps

Ramy Mahrous 401 Postaholic Featured Poster

Post your code directly, compressed files are malicious..

Ramy Mahrous 401 Postaholic Featured Poster

It's not SQL Server error!! rather you should post that on ASP.NET forum.

Ramy Mahrous 401 Postaholic Featured Poster
Ramy Mahrous 401 Postaholic Featured Poster

User table has recursive relationship because SuperAdmin, Admin and user (I think you understand me)
There's column in User table links to Type of user (RoleMst) SuperAdmin, Admin, User, etc...

Ramy Mahrous 401 Postaholic Featured Poster

oooh. I thought you did, take your time, best of luck!

Ramy Mahrous 401 Postaholic Featured Poster

Please open another thread and ask there, it's solved one :)

Ramy Mahrous 401 Postaholic Featured Poster

Very great :) please mark this thread as solved.

Ramy Mahrous 401 Postaholic Featured Poster
Ramy Mahrous 401 Postaholic Featured Poster

DateSet.Merge(AnotherDataSet) Read in merging datasets on http://msdn.microsoft.com/en-us/library/4swwh51k.aspx
An example http://aspalliance.com/148

Ramy Mahrous 401 Postaholic Featured Poster

I don't think so, you should implement it yourself!

Ramy Mahrous 401 Postaholic Featured Poster

but it shud be fully code based.

Friend, if you search on MSDN you'll find a lot of articles there. and you can post here specific question say, when you connect on SQL Server your application releases exception lmlmlma, so the question is "what's the error, friends..."
Best of luck with http://msdn.com

Ramy Mahrous 401 Postaholic Featured Poster

First of all your database design isn't correct, or you've another opinion? discuss that with me..
I don't need to waste time in writing SQL Statement on invalid database design, your query isn't hard plus I don't know why you used distinct in your solution as you just need the first time the user took the exam!!

Ramy Mahrous 401 Postaholic Featured Poster

You merge logic or business of your application and the design of the database, you don't need to modify the design if you correctly did it, rather in application check the new friends list in a friend and show them in say news feed to their friends like Facebook

Ramy Mahrous 401 Postaholic Featured Poster

When you create trigger After AS play with columns_updated() function read in http://msdn.microsoft.com/en-us/library/aa258254(SQL.80).aspx

Ramy Mahrous 401 Postaholic Featured Poster

haaaa, give me your tryings friend :)

Ramy Mahrous 401 Postaholic Featured Poster
SELECT Relationships.Parent_NameID AS [level], Names.ID, Names.Name
FROM Relationships FULL OUTER JOIN Names ON Relationships.NameID = Names.ID
Ramy Mahrous 401 Postaholic Featured Poster

There is a lot of reasons... debug your application! and check which operation takes a lot of processing you can run it on another thread!

Ramy Mahrous 401 Postaholic Featured Poster

OK, friend...
You should read in Joins, LevelID (ID of Parent) if you need me to send you the SELECT statement, it's OK; but I see you won't gain any benefits.

Ramy Mahrous 401 Postaholic Featured Poster

I'll share with you and your question would be answered, but give me your approaches, how could you think in this problem

Ramy Mahrous 401 Postaholic Featured Poster

From comboBox properties, select Data Source, Display Member, etc..
Display Member = the column you want to show it to the user.

Ramy Mahrous 401 Postaholic Featured Poster

Create project from LINQ Console Application not Console Application
You'll find some project with prefix "LINQ" added to project types in VS2005 after installing LINQ SDK.
If you can send us snapshot of your VS installed project templates please do.

Ramy Mahrous 401 Postaholic Featured Poster

Database language or Database software?
Database language would be mainly ANSI-SQL and you can use Microsoft Access or Microsoft SQL Server.

Ramy Mahrous 401 Postaholic Featured Poster

In textbox ChangedText event handler you can check on the character the user enters, Char.IsSymbol, Char.IsDigital, you'll make use of Char class.
- If you searched in this forum you'll find a lot of threads talk about that too..
*Show us your effort*

Ramy Mahrous 401 Postaholic Featured Poster

So, you need to read in HAVING

Ramy Mahrous 401 Postaholic Featured Poster

Yes because he doesn't write this code within method!! :) but I was replying in language syntax perspective...