Comments by Akkywadhwa (Top 40 by date)

Object reference not set to an instance of an object.
System Null Reference Exception

public static int Insert(string query,Dictionary<string,string> parameters)
{
int i=0;
try
{
DBConnection.InitializeConnection(cmd);
foreach (var p in parameters)
{
cmd.Parameters.AddWithValue(p.Key,p.Value);
}
cmd.CommandText = query;
cmd.CommandType = CommandType.Text;
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
i = cmd.ExecuteNonQuery();
}
}
catch (Exception)
{
i = 0;
}
finally
{
if (cmd.Connection.State != ConnectionState.Closed)
{
cmd.Connection.Close();
}
}
return i;
}





query = "INSERT INTO Suppliers ";
query+="(SupName,ConcernedPerson,MobileNum,PostalAddr,Email) ";
query += "VALUES(@Name,@ConcernedPerson,@Mobile,@Postal,@Email)";
var param = new Dictionary<string,string>();
param.Add("@Name", txtSupplier.Text.ToString());
param.Add("@ConcernedPerson", txtConcerned.Text.ToString());
param.Add("@Mobile", txtMobile.Text.ToString());
param.Add("@Postal", txtAddress.Text.ToString());
param.Add("@Email", txtEmail.Text.ToString());
int i= POS.DbOperation.Insert(query, param);
MessageBox.Show(i.ToString());
}
catch(Exception ex)
{
MessageBox.Show(ex+""+ex.InnerException);
}
}



This too doesn't work.
Hritik

Hello Maarten,
I have updated my question. Kindly check this.
Thanks,
Akky

Please consider the improved question.
Thanks for your answer,
Akky

I am trying "select top 10 * from DimCustomer" query and this '10' is taken as pageindex.
It's just named as 'pageindex' but actually its a parameter for limit/
Thanks,
Hritik

Correct...:)

one by one..

The Page Search!!

I have been ordered to do this work in C#.
Akky

Nopes!

How Can i disable the o let navigation keys to move on the lines of the textbox????????

No i am not asking for full design. I am asking for any idea about logic or algorithm.

What do you mean by monodevelop????
Is it normal c#?? yes or no?

5ed!

5ed!

Can you please show any example of line or of the thing u r saying about.
Akky

5ed!!!

I want that code in c# windows application not in asp.net(c#).

Richard getFolders is a static function here which can be called by their class name....

Hi vinod,
I am unable to use it in my windows forms project please explain me that how can I use it with windows forms.
Thanks.

This line " Console.WriteLine("bliisdsdsdszdsafsfdsF");" is a separator please don't consider this.
Akky

Ok....Sergey if u consider this code as incorrect then will you please a code snippet for me to retrieve the contents of the pc and saving it on desktop for both the windows xp and 7.
Akkywadhwa

Yes,Shahin i want you to write a query in sql server 2005 for me.Please help me as soon as it could be possible.
Akky

Thanks Manas,
But can you tell me how can i retrieve one by one table name of the multiple resultset returned by this query.
Example:
I have to retrieve the name of table shown in resultset containing more than 2 rows.
Regards,
Akkywadhwa

Consider 2 tables named name1 and name2 in database xyz.These tables contain time-table schedule of a teacher tells him/her that in which class he/she has to go in the specified 8 period in 6 days.And some of them are free too.Cells are denoting free periods by null values.So, I need to retrieve the tables names that is name1 and name2 by applying query that:

Give me those table names which contain null values in period 3 on day 4.
Please help me out as soon as it could be possible.
Regards,
Akkywadhwa

Consider 2 tables named name1 and name2 in database xyz.These tables contain time-table schedule of a teacher tells him/her that in which class he/she has to go in the specified 8 period in 6 days.And some of them are free too.Cells are denoting free periods by null values.So, I need to retrieve the tables names that is name1 and name2 by applying query that
Give me those table names which contain null values in period 3 on day 4.
Please help me out as soon as it could be possible.
Regards,
Akkywadhwa

I can't specify table name in my query as i have to retrieve it.
Example:
There is a table named akky which has 2nd colums 3rd cell empty then it must return me akky.
Note: Value of column and row is specified by me.
Thanks,
Akkywadhwa

I want to retrieve time from bios not from windows as windows time could be wrong but bios time can't be.

I am new to c# so could you,Please upload a demo project for me. I request you for this.
Regards,
Akkywdhwa

Thanks buddy.I did that with your help.
Regards,
Akkywadhwa

Nelson I want them as you use to see in windows's tilebar and they must show adress in any textbox or other control.
Please see the below link for related image.
link:http://db.tt/BYxDYG9J
Akkywadhwa

Hi Nelson,
Actually I want those buttons to work in the given case.
Case:
Previously 2 textboxes were displayed on screen but now on clicking of a button 2 more textboxes are being displayed and now when i press back button it should come to its previous stage i.e should display 2 textboxes only.
Regards,

Akkywadhwa

Link to that image is:-
http://dl.dropbox.com/u/24842633/IMAGE.PNG

Could you please explain "WM_PAINT" with a demo project?
Regards,
Akkywadhwa

Hi Gparkings,
The solution you gave me was already seen by me and it was quite difficult to implement.So,I request you search any other alternative for that.
Thanks for your help,
Akky