|
hendryck wrote: I sorry my english is very bad....
No importa. Mi espan~ol está mucho mas mal.
But, you know the word "café" also exists in English which results in "cybercafé"
Coffee is the drink. A "café" is a place which sells coffee for consumption on the premisis.
|
|
|
|
|
hi there,
has anyone any idea of how i could implement the coverflow (mac) or shift window switching (vista) effect?
i've tried some ideas like quadric or exponential methods but they didn't turn out..... so here i am asking for some advice?
thanks,
andreea
|
|
|
|
|
this is my code. or part of it
{
:
:
this.sqlConnection1.ConnectionString = "workstation id=S6W6Q4;packet size=4096;integrated security=SSPI;data source=S6W6Q" +
"4;persist security info=True;initial catalog=master";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO [\'List For Haj Ballot$\'] ([List For Haj Ballot 2008], F2, F3, F4, F5," +
" F6) VALUES (@Param1, @F2, @F3, @F4, @F5, @F6); SELECT [List For Haj Ballot 2008" +
"], F2, F3, F4, F5, F6 FROM [\'List For Haj Ballot$\']";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param1", System.Data.SqlDbType.Float, 8, "List For Haj Ballot 2008"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@F2", System.Data.SqlDbType.Float, 8, "F2"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@F3", System.Data.SqlDbType.NVarChar, 255, "F3"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@F4", System.Data.SqlDbType.NVarChar, 255, "F4"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@F5", System.Data.SqlDbType.NVarChar, 255, "F5"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@F6", System.Data.SqlDbType.NVarChar, 255, "F6"));
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "\'List For Haj Ballot$\'", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("List For Haj Ballot 2008", "List For Haj Ballot 2008"),
new System.Data.Common.DataColumnMapping("F2", "F2"),
new System.Data.Common.DataColumnMapping("F3", "F3"),
new System.Data.Common.DataColumnMapping("F4", "F4"),
new System.Data.Common.DataColumnMapping("F5", "F5"),
new System.Data.Common.DataColumnMapping("F6", "F6")})});
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.BackColor = System.Drawing.Color.LimeGreen;
this.ClientSize = new System.Drawing.Size(686, 548);
this.Controls.Add(this.label8);
this.Controls.Add(this.textBox5);
this.Controls.Add(this.label7);
this.Controls.Add(this.textBox4);
this.Controls.Add(this.label6);
this.Controls.Add(this.textBox3);
this.Controls.Add(this.label5);
this.Controls.Add(this.button1);
this.Controls.Add(this.pictureBox1);
this.Controls.Add(this.textBox2);
this.Controls.Add(this.textBox1);
this.Controls.Add(this.label3);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Controls.Add(this.label4);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.Fixed3D;
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.Name = "Form1";
this.Text = "APL Haj Ballot System";
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
this.Load += new System.EventHandler(this.Form1_Load);
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
/*try
{
//SqlConnection dataConnection = new SqlConnection();
//dataConnection.ConnectionString = "Integrated Security=true; Initial Catalog=master; Data Source = s6w6q4";
//dataConnection.Open();
//MessageBox.Show("connected");
SqlCommand dataCommand = new SqlCommand();
}
catch(Exception e)
{
Console.WriteLine("An error occurred accessing the database:" + e.Message);
}*/
}
SqlConnection dataConnection = new SqlConnection();
SqlCommand dataCommand = new SqlCommand();
//SqlDataReader sdr = new SqlDataReader();
/*private void button1_Click(object sender, System.EventArgs e)
{
SqlConnection dataConnection = new SqlConnection();
SqlCommand dataCommand = new SqlCommand();
dataCommand.Connection = dataConnection;
dataConnection.ConnectionString = "Integrated Security=true; Initial Catalog=master; Data Source = s6w6q4";
dataConnection.Open();
//dataCommand.Connection = dataConnection;
//dataCommand.CommandText = "SELECT Emp#, Name, Designation, Department, Location FROM master";
dataCommand.CommandText = "select (@Emp#, @Name, @Designation, @Department, @Location)From master";
//textBox1.DataBindings.Add("Text", dataConnection.Database.s6w6q4.master,"s6w6q4.master.Emp#");
SqlDataReader datar = dataCommand.ExecuteReader();
while(datar.Read())
{
int empid = datar.GetInt32(1);
//textBox1.Text = Convert.ToString(empid);
string empname = datar.GetString(2);
string desig = datar.GetString(3);
string dept = datar.GetString(4);
string loc = datar.GetString(5);
}
}*/
private void Form1_Load(object sender, System.EventArgs e)
{
SqlConnection dataConnection = new SqlConnection();
dataConnection.ConnectionString = "Integrated Security=true; Initial Catalog=master; Data Source = s6w6q4";
dataConnection.Open();
MessageBox.Show("Connected");
}
private void button1_Click(object sender, System.EventArgs e)
{
DataTable tbl_master = new DataTable();
dataConnection.ConnectionString = "Integrated Security=true; Initial Catalog=master; Data Source = s6w6q4";
//SqlConnection conn_offers = new SqlConnection("Integrated Security=true; Initial Catalog=master; Data Source = s6w6q4");
SqlDataAdapter da_offers = new SqlDataAdapter("SELECT 1 * FROM tbl_offers master BY NewID()", dataConnection);
da_offers.Fill(tbl_master);
}
}
}
with commented stuff.
i've tried various methods as can be seen, but nothing is helping n the project is due sunday.
this is what i want. a data table, called master, has been connected with my project.
it is a list of employees, and a ballot has to take place for a promotion. if that name would be dismissed, the button would be pressed again to retrieve another name, excluding the one that was chosen before.
i want to display the various attributes of the employee in textboxes. i hav no idea wat is happening anymore, i've been on this project for a week, n i regret i dint come here earlier.
 im very very distressed. pls help me ASAP, pls get that code above right. n tel me how 2 kno if the connection is right.
as u can c, i've made the project so that as soon as the form loads, it tels me that a connection to database has been established. n it does so. but its not retrieving data. if i hav to display the data any other way, i will, but just help me outta this mess!
|
|
|
|
|
n the database is an excel file, btw.
|
|
|
|
|
what type of help you want .tell me
hi friends do somthing different........from other..........
|
|
|
|
|
Wajeeha wrote: HELP HELP URGENTLY!!!!
You might want to stick your head in a crocodile.
|
|
|
|
|
It would seem that you have committed the cardinal sin of demanding help urgently. If you need help urgently then there are various support options you can pay for. If you want help free then you have to wait until some kind volunteer has the time to assist you.
|
|
|
|
|
The best advice I can give you is to start your homework earlier and plan out better what you actually want to do. I find thinking about the task and even following the pseudo-code through on paper often helps to highlight problems in logic.
Maybe you could wait for John Simmons' answer if he sees the desperate request. I'm sure your phrase "n i regret i dint come here earlier." may well be slightly modified once you get his reply.
Also note that the words are "and" not "n", "see" not "c", "you" not "u", "I" not "i".
Your last rambling paragraph does not encourage the reader to continue but merely saps the will of the prospective helper.
I still remember having to write your own code in FORTRAN rather than be a cut and paste merchant being pampered by colour coded Intellisense - ahh proper programming - those were the days 
|
|
|
|
|
Baconbutty wrote: but merely saps the will of the prospective helper
So that's what happened to me!
|
|
|
|
|
idiots like you also mean my post has been puched off the front page
|
|
|
|
|
idiots like you also mean my post has been pushed off the front page
|
|
|
|
|
Expect to fail the course.
|
|
|
|
|
I have a decimal number with a variable amount of digits following the decimal. I need to make the number a whole number and in doing so I need to keep track of how many decimal places there were.
ie change 28.9876 to 289874 and store there were 4 decimal places.
I am currently doing this by converting to a string and checking how many are after the '.'
This seems a poor way to solve this problem, but I am drawing a blank on other approaches. Can anyone offer other more efficient/elegant solutions?
this thing looks like it was written by an epileptic ferret
Dave Kreskowiak
|
|
|
|
|
I'm sure there is an even better way, but...
decimal d = 10.1234;
int dp = (d - decimal.Truncate(d)).ToString().Length - 2;
int val = (int)(d * (decimal)Math.Pow(10, dp));
This method, although still converting it to a string, doesn't 'search' the string for a particular character... just gets its length... which is relatively efficient.
As I said... there will be a better way... what it is I cannot immediately say.
Hope this helps.
Matthew Butler
|
|
|
|
|
For instance
decimal d = 28.9876M;
int[] bits = Decimal.GetBits(d);
int pow = (bits[3] >> 16) & 0xFF;
At the end pow contains 4, i.e. the number of digits after the decimal point.
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
|
|
|
|
|
Appreciate the help
this thing looks like it was written by an epileptic ferret
Dave Kreskowiak
|
|
|
|
|
|
Thanks for the help.
this thing looks like it was written by an epileptic ferret
Dave Kreskowiak
|
|
|
|
|
Hi,
I m working on DNet Remoting to develop trading application to accept bid/ask value from user and broadcast to every connected user.
Process is working smoothly on localhost as well as on LAN.
But it is not working when i host app on static IP based server.Client send bid/ask value to server but does not get updates except client running on server.
Currently i m running server app manually by clicking on server.exe.
I did not get any change if I replace http channel with tcp
Any comment/suggestions r invited. Thanks all.
Client and Server Configuration file are given below.
Server Config File
-----------------------
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<system.runtime.remoting>
<application name="Trading">
<service>
<wellknown mode="Singleton" type="Server.Broadcaster, Server" objectUri="Broadcaster.soap"/>
</service>
<channels>
<channel ref="http" port="16784">
<serverProviders>
<formatter ref="binary" typeFilterLevel="Full"/>
</serverProviders>
<clientProviders>
<formatter ref="binary"/>
</clientProviders>
</channel>
</channels>
</application>
</system.runtime.remoting>
</configuration>
Client Config file
-----------------------
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<system.runtime.remoting>
<application name="EventClient.exe">
<client>
<wellknown type="Common.IBroadcaster, Common" url="http://203.200.95.133:16784/Trading/Broadcaster.soap"/>
</client>
<channels>
<channel ref="http" port="0">
<serverProviders>
<formatter ref="binary" typeFilterLevel="Full"/>
</serverProviders>
<clientProviders>
<formatter ref="binary"/>
</clientProviders>
</channel>
</channels>
</application>
</system.runtime.remoting>
</configuration>
|
|
|
|
|
Make sure port 16784 isn't blocked by your firewall.
|
|
|
|
|
Hi Guys. Maybe somebody here can help me. I'm writing a little app that writes records from a text file to an Excel file. However, I am writing data to two columns, namely A2 and B2. Problem here is that Every record gets appended to the same cell A2 and B2 instead of going onto writing the next record to A3 and B3 etc. Any ideas what I'm doing wrong here?
Code below:
foreach (ReadFile nomread in res)
{
objRange = objSheet.get_Range("A2", System.Reflection.Missing.Value);
objRange.Value2 += nomread.CLIENTSURNAME;
objRange = objSheet.get_Range("B2", System.Reflection.Missing.Value);
objRange.Value2 += nomread.CLIENTFORENAMES;
}
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
Kwagga wrote: objRange = objSheet.get_Range("A2", System.Reflection.Missing.Value);
Kwagga wrote: objRange = objSheet.get_Range("B2", System.Reflection.Missing.Value);
This is what you're doing wrong. You are selecting same cell in loop, so you will get different value from nomread but it will write in same cell.
There are two ways you can write values to excel cell. One is using two dimensional array which would look something like yourArray[2,2] and you would send that to your excel worksheet. But in your code it seems like you don't know the max number or cells you will need. So for something like this you can use Array and Column index to write array.
The code will looks something like this:-
int iR, iC;
iR = 1;
iC = 1;
foreach (ReadFile nomread in res)
{
objSheet.Cells[iR, iC] = nomread.CLIENTSURNAME;
objSheet.Cells[iR, iC+1] = nomread.CLIENTFORENAMES;
iC = 1;
iR++;
}
I haven't tested this code so you may need to make some changes. But the point is you should get an idea from this...
- Stop thinking in terms of limitations and start thinking in terms of possibilities -
|
|
|
|
|
Thanks mate. It doesn't write all the records though. Only writes the last record. I get the jist of it and will see what I can do with what you provided me.
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
Kwagga wrote: It doesn't write all the records though. Only writes the last record. I get the jist of it
What do you mean by it doesn't write all the records??  Can you post the code that you're using now??!
- Stop thinking in terms of limitations and start thinking in terms of possibilities -
|
|
|
|
|
Hi Mate. It works fine. I missed something from your sample.
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
