Posts by Ramy Mahrous - Page 15

Jerry, I think you mean

//outside event handler
string oldValue = null; 
//inside event handler
textbox.Text = oldValue;
oldValue = textbox.Text;

Add this code in gridview DataBound event handler.

Because it's secured, if it's Shockwave video.

SMO libraries for .net let you query any server programatically.
The hierarchy is:
Server->Databases->Tables, users, stored procedures, etc...
You can read more about SMO in MSDN
Overview SMO: http://msdn.microsoft.com/en-us/library/ms162557.aspx
Creating SMO Programs: http://msdn.microsoft.com/en-us/library/ms162202.aspx

Yes, that only possible solution is to get specific textbox by name or text!

private void undotextbox(object sender, EventArgs e)
{
if(sender is TextBox)
{
switch( ((TextBox)sender).Name )
{
case "":
....
break;
case "":
....
break;
}
}
}

You need to know more about ProgressBar control! that's it.

mmmmm, I'll think in this using C++, give me sometime..

I got confused because they mentioned "my sql statement" I didn't recognize they mean: "their sql statement"

Hey friends!!!! how could you answer their question without looking at their code?!!!! which line they assigned textbox value to Num object?!!!!!

Don't try to update the ID! I believe in the concurrency violation occurs regarding this. did you try this update statement in Access Query GUI?

So, don't use it, and you can run process without showing its GUI to the user!

http://authors.aspalliance.com/aspxtreme/sys/data/DataViewClassRowFilter.aspx

I don't know how HideToolz works, but can you try to get all processes with name "your process name you want to kill" and loop on their IDs and kill them using Process.Kill which in System.Diagnostics

"data type mismatch in criteria expression"

because you should pass integral value.
So, Doesn't MySQL have profile to log the coming connection\transaction like MS SQL? you can check it, or I do recommend you to use MySQL library for .NET which on http://MySQL.org instead of OLE

What about using INNER JOIN on Subjects.Subjects_ID = Visits.Subject_ID and where Visits_ID = (Select Max(Visits_ID) From Visits) haa? simple, isn't it?

So, what happened? exception raises? or it closes the form normally?, I can't admit that MySQL query is correct but it's ANSI-SQL all RDBMS should support it.

To stop it noway else putting it on a specific thread then in some defined cases you kill this thread.

Here you are how to generate rdl Programmatically http://msdn.microsoft.com/en-us/library/aa237432(SQL.80).aspx don't forget to change the OpenConnection and GenerateFields methods to which fits your environment.

You're welcome, you can post your solve. Please mark it as solved because no direct event do this.

It gives error? or what happened exactly please clarify...

Because you didn't assign Num value to TextBox.Text value
you need to modify your code to

Private Sub TxtNum_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TxtNum.TextChanged
Dim Num As Integer
Num = Int.Parse(TxtNum.Text)
If Num > 100 Then
MsgBox("You win a lucky prize")
ElseIf Num < 100 Then
MsgBox("Better luck next time")
End If
End Sub
End Class

Background for what? Desktop or Application form?
Anyway you can dispose the object once you don't need it.

String class helps you in that, just play with string coming to you...

Give me an example, why you need to fire an event when an item added to the ComboBox items. as we can handle it another way

You say it doesn't work in this way

SELECT tblEmailClub.emailclub_id,
tblEmailClub.firstname,
tblEmailClub.lastname,
tblEmailClub.email,
tblSourceHistory.datereg,
tblEmailClub.active,
Distinct (tblEmailClub.address1),
tblEmailClub.address2,
tblEmailClub.city,
tblEmailClub.state,
tblEmailClub.zip,
tblSourceHistory.source FROM tblEmailClub
INNER JOIN tblSourceHistory
ON tblEmailClub.emailclub_id = tblSourceHistory.emailclub_id
WHERE tblSourceHistory.dateReg BETWEEN '3/1/2009' and '4/1/2009'
AND tblSourceHistory.source LIKE '%family.asp%'
ORDER BY tblSourceHistory.datereg asc

Use Distinct keyword

Look, As far I got your scenario, Form2 may have property Number which holds the numbers user enters.
Before closing the Form2 From Form1, read the Form2.Number.

This is the Pseudocode
Directory = GetBinDirectory();
loop Directory.Files(Filtered .mdb)
print File name

Let me know the exception raises, and if you need to generate rdlc on the fly I can guide you to great way to work in such thing

What's the exception?
I believe the problem you've two parameters called 'ID' you should have @OriginalID and @UpdatedID

If you debugged your code you'll know the error. But first thing you should modify this

string cs = "user id=scott;password=tiger";
cn = new OracleConnection(cs);
cn.Open();
// MessageBox.Show("Oracle connection opened sucessfully");
OracleDataAdapter da = null;
OracleCommandBuilder cmb = null;
da = new OracleDataAdapter("select * from dept", cn);
cmb = new OracleCommandBuilder(da);
ds = new DataSet();
da.Fill(ds, "deptx");
Rec_Max = ds.Tables["deptx"].Rows.Count;
NavigateRecords(inc);
cn.Close();
cn.Dispose();

to

if(!Page.IsPostBack)
{
string cs = "user id=scott;password=tiger";
cn = new OracleConnection(cs);
cn.Open();
// MessageBox.Show("Oracle connection opened sucessfully");
OracleDataAdapter da = null;
OracleCommandBuilder cmb = null;
da = new OracleDataAdapter("select * from dept", cn);
cmb = new OracleCommandBuilder(da);
ds = new DataSet();
da.Fill(ds, "deptx");
Rec_Max = ds.Tables["deptx"].Rows.Count;
NavigateRecords(inc);
cn.Close();
cn.Dispose();
}

Print it where or when?!
This is a very abstracted question!!

How did you admit the your control works well? maybe the problem in your control.

Look, the one who can answer this question Dundas Technical Support team, but as I worked with Dundas from time to time, it's not problem of .net, rather Dundas don't support flash movies.

Add reference to this library then, modify this resource's class access modifier from internal to public

Try

formReminder.Show();

instead of

formReminder.ShowDialog();

I think http://www.freedownloadmanager.org/downloads/xmi_software/ helps well...

Does the strong Typed column field names HAVE to match the names in the DataAdaptor?

Try that a lot to know the answer.

I don't know your problem with DataSets, but try to generate someone from SQL Server or Access File, and tell me what you got.

There is no "Export to C# classes" feature in Visual Paradigm?

Save changes to your DataSet and Fill the DataAdapter....

What came to my mind is to through a copy of the layer you draw on in the form, i.e bitmap image into ArrayList for every change through a copy into the ArrayList....
So, your ArrayList should be like that

Oldest
Older
...
Newer
Newest
You can load the bitmap at anytime with playing with ArrayList index

Your user should be administrator to run such type of applications, you don't have to do anything from your side.

Yes, you can but it should be registered

Process p = new Process();
p.StartInfo.FileName = "notepad.exe"; // or "WINWORD.exe";
p.StartInfo.Arguments = "C:\\file.txt";
p.Start();

*Not to mention I used Pubs database and worked on Authors table (address column)

Dear Andresasongko,

select 
REVERSE
(
substring(
	REVERSE(address)
	, 0
	, CHARINDEX(' '
				, REVERSE(address)
				,0
				)
)
)
,address from authors

That's what I tried right now, you can work to perform it better.

So, please mark it as solved :)

Yes, it's on 2008

Right Click on Project->Add->Existing Item->Select the file then on Add button you'll find arrow press on it then Add as Link.

1 year since I was the member of the month March 2008 :)

It works with you?