Re: Implementing Timer Functionality in Online Test Application - C# Discussion Boards

Backup and restore of mysql through C#

mariamkhaqan23-Jun-09 2:14

mariamkhaqan

23-Jun-09 2:14

Hi can any one tell me how to take backup and restore of mysql through c# using ODBC connection?

regards,

Mariam

Re: Backup and restore of mysql through C#

Manas Bhardwaj23-Jun-09 2:29

Manas Bhardwaj

23-Jun-09 2:29

Like this[^]

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Backup and restore of mysql through C#

mariamkhaqan23-Jun-09 22:48

mariamkhaqan

23-Jun-09 22:48

Thanks but they show backup of microsoft sql server while my query is related to MySQL
regards,

I need to restore my database in C# windows application. I am using sql yog enterprise as database...

santhosh1985april14-Feb-10 23:37

santhosh1985april

14-Feb-10 23:37

do you send me the code

I need to restore my database in C# windows application. I am using sql yog enterprise as database

santhosh1985april14-Feb-10 23:37

santhosh1985april

14-Feb-10 23:37

do you send me the code

Detail View in DatagridView in c#

Zeeshan Ahmed Memon23-Jun-09 1:40

Zeeshan Ahmed Memon

23-Jun-09 1:40

Dear Fellows,

I have an xml file
<subjects>
<publishers name="wrox">
<book>
Beginning c#
</book>

<book>
Beginning ASP.NET WITH C#
</book>
</publishers>

<publishers name="Masters">
<book>
master in c#
</book>

<book>
master ASP.NET WITH C#
</book>
</publishers>
</subjects>

First I only want to display its publishers name in datagridview. When a user press any publisher name he will be able to see name of books in datagridview below the publisher name on which he click.

You can say it as a tree view operations that I want to perform in datagridview.

I need your help to understand this problem that how can I overcome it and how I can solve it. Codes and references will certainly help alot.

I will be thankful to all those who help me.

Thank you.

Regards,
Zeeshan Ahmed.

Implementing Timer Functionality in Online Test Application

jjinagavenkatesh23-Jun-09 1:38

jjinagavenkatesh

23-Jun-09 1:38

I am using Ajax Timer control in my OnlineTest Application.

suppose if exam duration 45 mintes means i am adding 45 minutes to server time and i am subtracting with current server time and i will get 45 minutes with that i am reducing time in the form of seconds

like 45:59,45:58.

I am using ASP.Net 2.0,Ajax1.0, MS Access Database.

but during postback means if i click on "Next" button(next question will appear in the next page)

that time i am not able to maintain time what ever time it has taken during postback again from that i am able to continue again..please could u help me regard in this

this is my aspx page

<asp:UpdatePanel runat="server" ID="uppnlTimer" RenderMode="Inline" UpdateMode="Conditional">

<triggers>

<asp:AsyncPostBackTrigger ControlID="tmrTest" EventName="Tick" />

</triggers>

<contenttemplate>

<asp:Timer ID="tmrTest" runat="server" OnTick="tmrTest_Tick" Interval="1000">

</asp:Timer>

<asp:Label runat="server" ID="lblStartTime" Text="Start Time:" CssClass="lbl" />

<asp:Label runat="server" ID="lblStartTimeValue" CssClass="lblbold" />

<asp:HiddenField ID="hid_Ticker" runat="server" Value="0" />

</contenttemplate>

</asp:UpdatePanel>

this is Code behind code

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataSet dsServerTime = new DataSet();
DataSet dsExamTime = new DataSet();
dsServerTime = objOnlineTestPaperBAL.GetServerTime();

dsExamTime = objOnlineTestPaperBAL.GetServerTimeWithExamDuration(ExamTime);
if (dsServerTime.Tables[0].Rows.Count > 0)
{

string serverTime = dsExamTime.Tables[0].Rows[0]["ExamTime"].ToString();

minutes = Convert.ToInt32(serverTime);

hid_Ticker.Value = new TimeSpan(Hours, minutes, seconds).ToString();

if (Session["time"] != null)
{
string time = (string)Session["time"];
string[] str1 = time.Split(':');
minutes = Convert.ToInt32(str1[1]);
seconds = Convert.ToInt32(str1[2]);
lblStartTimeValue.Text = Convert.ToString(minutes) + " : " + Convert.ToString(seconds);
hid_Ticker.Value = new TimeSpan(Hours, minutes, seconds).ToString();
Session["time"] = hid_Ticker.Value;
}
else
{
lblStartTimeValue.Text = Convert.ToString(minutes) + " : " + Convert.ToString(seconds);
}
}
}
Session["TestStart"] = System.DateTime.Now;

}

please help me regard in this....

Re: Implementing Timer Functionality in Online Test Application

Gary Stafford23-Jun-09 15:39

Gary Stafford

23-Jun-09 15:39

If I understood your question correctly, you do not want to penalize the user for the time it takes the Page to PostBack. Why don't you add an OnClick() event to the Next button to capture the time remaining and send it to a Session variable, first, before calling the next question, etc. Then once the page has posted back you can retrieve the time remaining from the Session variable?

Regards,

Gary

Label issue in Vista

musefan23-Jun-09 1:18

musefan

23-Jun-09 1:18

Hello all,

I have a little problem that I cant seem to understand, maybe someone has come across this before.

Basically I have a panel in a form. The only thing that is in this panel in 1 Label control.

The following properties have been changes:

RightToLeft set to yes
TextAlign set to TopRight
Anchor set to BottomRight
AutoSize set to true
FontStyle set to Bold

The text should say "Email Address:"

This displays in XP fine, however in Vista the text is displayed as ":Email Address"

if I set text to "Email Address:a" then it also displays fine (in both XP and Vista)

Any ideas?

Thanks

Life goes very fast. Tomorrow, today is already yesterday.

Re: Label issue in Vista

Christian Graus23-Jun-09 1:24

Christian Graus

23-Jun-09 1:24

musefan wrote:
RightToLeft set to yes

Why ? Doesn't this seem like it could be the issue ?

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

Re: Label issue in Vista

musefan23-Jun-09 1:30

musefan

23-Jun-09 1:30

Yep

That's the problem. I set that to make sure it auto sizes in the right direction. But I will change it to default now and move the label with code if need be.

Still I would have expected all characters to be reversed thou.

Anyway, Thanks Wink | ;)

Life goes very fast. Tomorrow, today is already yesterday.

What's the best collection

CodingLover23-Jun-09 0:56

CodingLover

23-Jun-09 0:56

Hi all,

I want to do something like this.

A collection, which is not sorted in insertion(added in the next index) and avoid duplicate. Which can I use?

Thanks. Smile | :)

I appreciate your help all the time...
CodingLover Smile | :)

Re: What's the best collection

Christian Graus23-Jun-09 1:01

Christian Graus

23-Jun-09 1:01

There is no set class in .NET. You'd have to add set behaviour to a list, by searching for items and not inserting them if they exist.

Re: What's the best collection

DaveyM6923-Jun-09 1:10

DaveyM69

23-Jun-09 1:10

AFAIK there isn't one. You can always create your own and use new a new Add method - something like

public class MyList<T> : List<T>
{
    public new void Add(T item)
    {
        if (!Contains(item))
            base.Add(item);
    }
}

You'll need to do something similar for AddRange, and keep track of any changing items to make sure they don't create duplicates.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Re: What's the best collection

kb-boxer23-Jun-09 1:53

kb-boxer

23-Jun-09 1:53

There is library available from Wintellect that has unordered set, the one you are looking for. You might try it if you wish.

http://vivekragunathan.spaces.live.com

Programming is an art. Code is a poem

Re: What's the best collection

Rob Philpott23-Jun-09 2:16

Rob Philpott

23-Jun-09 2:16

It's worth remembering that there isn't a one-size-fits all algorithm to do stuff like this. The framework provides a set of general purpose collections and algorithms, but they might not be good enough in specific scenarios.

An unsorted list, which is what I understand you want, is going to be very slow at detecting duplicates. And its going to seriously degrade if you've got lots and lots of things in your collection. It might be worth running two data structures alongside each other to mitigate this.

So, roughly how many things are you going to insert into this? Is memory consumption an issue for you? Can we remove duplicates later on, or does it have to be done on insertion?

Regards,
Rob Philpott.

Re: What's the best collection

Mirko198023-Jun-09 2:17

Mirko1980

23-Jun-09 2:17

If you can use .NET 3.5, there is an HashSet class.
Otherwise, you have to build one, as others have said.

[Message Deleted]

yams251023-Jun-09 0:36

yams2510

23-Jun-09 0:36

[Message Deleted]

Re: WPF.... GRID.... !! am lost

Christian Graus23-Jun-09 0:57

Christian Graus

23-Jun-09 0:57

We have a WPF forum. Try to speak english, 'dat' is not a word, for example.

If your control is data bound using an observable collection, swapping the items in the collection, will swap them in the control.

Re: [Message Deleted]

EliottA23-Jun-09 3:32

EliottA

23-Jun-09 3:32

Try not to delete questions, often people get referenced to these questions. Deleting them is pointless.

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

WinRTP on .NET C# Platform for streaming

ray_ronnaret23-Jun-09 0:09

ray_ronnaret

23-Jun-09 0:09

Please help
I am developing a CISCO IPPhone Solutions, and one of the feature is RTP streaming. As I search on the the web (including on CISCO) there is no any simple exmple how to implement this. However, on codeproject, I found one but seem like not match with my requirment. WinRTP should the correct solution, but I have no idea about it. Can any one englight me please.

Thank for advacned.

MS Chart - Problem to display the records in Range Column Chart

Jegansinna23-Jun-09 0:01

Jegansinna

23-Jun-09 0:01

Dear All,

Our requirement is a cab has assigned to Pick and Drop the employee for each and every shifts for the selective date. So, we need to show how much distance a cab has travelled, then we need to show that cab has been assigned for Pick/Drop for all the selective date.

As per my Procedure we can get the "Shift Date Time", "Cab No", "Pick/Drop" value, etc....

In Range chart I need to show the "Shift Time" in "X Axis" like "9 AM", "10 AM", "11 AM".....upto Next day "8 AM".
then In "Y Axis" I need to show "Shift Date Time" & "Cab No." which come from table.

In "Y Axis" i can not show the "Shift Date Time", So, I tried to show in "X Axis", but I can show only shift Date not time.
Actually I need to show the shift date in "Y Axis" only.

If any one have the solution, Please reply me.

Thanks in Advance.

Regards,
Jegan.K
9994388922

Jegan

Datagridview [modified]

mjelten22-Jun-09 23:55

mjelten

22-Jun-09 23:55

Hi!

I have ha promblem with adding items to a DataGridViewComboBoxCell. This is what I am doing.

private void SetUpforDataGridView()
{
dataGridViewSearched.ColumnCount = 5;
dataGridViewSearched.ColumnHeadersDefaultCellStyle.BackColor = Color.Navy;
dataGridViewSearched.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
dataGridViewSearched.ColumnHeadersDefaultCellStyle.Font =
new Font(dataGridViewSearched.Font, FontStyle.Bold);

dataGridViewSearched.Name = "Users Searched";
dataGridViewSearched.AutoSizeRowsMode =
DataGridViewAutoSizeRowsMode.DisplayedCellsExceptHeaders;
dataGridViewSearched.ColumnHeadersBorderStyle =
DataGridViewHeaderBorderStyle.Single;
dataGridViewSearched.CellBorderStyle = DataGridViewCellBorderStyle.Single;
dataGridViewSearched.GridColor = Color.Black;
dataGridViewSearched.RowHeadersVisible = false;
dataGridViewSearched.Dock = DockStyle.Fill;

DataGridViewComboBoxColumn dataGridViewcombobox = new DataGridViewComboBoxColumn();

dataGridViewSearched.Columns.Add(dataGridViewcombobox);

dataGridViewSearched.Columns[0].Name = "UserId";
dataGridViewSearched.Columns[1].Name = "Förnamn";
dataGridViewSearched.Columns[2].Name = "Efternamn";
dataGridViewSearched.Columns[3].Name = "Legitimation";
dataGridViewSearched.Columns[4].Name = "Yrkesroll";
dataGridViewSearched.Columns[5].Name = "Enheter";
dataGridViewSearched.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;

dataGridViewSearched.Columns[0].Visible = false;
dataGridViewSearched.Columns[0].DefaultCellStyle.Font =
new Font(dataGridViewSearched.DefaultCellStyle.Font, FontStyle.Italic);

dataGridViewSearched.SelectionMode =
DataGridViewSelectionMode.FullRowSelect;
dataGridViewSearched.MultiSelect = false;
}

And the I am trying to set the table with an object it works fine with the text propertis but not with the DataGridViewComboBoxCell.

public void BindUserList(List<User> userList)
{
dataGridViewSearched.Rows.Clear();
object[] row = new object[5];

foreach (User p in userList)
{
row[0] = p.UserId;
row[1] = p.FirstName;
row[2] = p.LastName;
row[3] = p.MedicalProfession;
row[4] = p.ProfessionalRole;

dataGridViewSearched.Rows.Add(row);

foreach (var unit in p.UnitActivationPeriods)
{
((DataGridViewComboBoxCell)dataGridViewSearched.Rows[dataGridViewSearched.Rows.Count - 1].Cells[5]).Items.Add(unit.ToString());
}
dataGridViewSearched.Rows[dataGridViewSearched.Rows.Count - 1].Tag = p;

}
labelNumberOfUsers.Text = userList.Count.ToString();
dataGridViewSearched.Refresh();
}

Thanks, Mjelten

modified on Tuesday, June 23, 2009 6:51 AM

A better way

Sevententh22-Jun-09 23:44

Sevententh

22-Jun-09 23:44

Is there a better way to code the second foreach...?

bool blnAccepted = false;
IList<Country> ftList = svc.GetCountryList;
IList<County> CountyList = svc.GetCountyList;

                foreach (Country c in ftList)
                {
                    blnAccepted = false;
                    foreach (County ic in CountyList)
                    {
                        if (ic.County == c.County)
                        {
                            blnAccepted = true;
                            break;
                        }
                    }

                    if (blnAccepted)
                    {
//Do work
                    }
                }

Re: A better way

Christian Graus23-Jun-09 1:00

Christian Graus

23-Jun-09 1:00

Yes, I would imagine that creating a map of countries to counties would allow you to do a single lookup. I'm not sure I follow your overall logic, but if you're doing this second loop a lot, a lookup in a hashtable will make it quicker. That's assuming you need to lookup a county for a country. If you just want to see if it exists, then keep a sorted list, so you can perform a search on it, faster than looking through the whole list.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.