Update() database from DataSet - C# Discussion Boards

mr jets2-May-07 14:58

2-May-07 14:58

heloo christian ..u are my hero man ..there was awrong with my save code..:

// save the file

string str_Line;
System.IO.FileStream fs = new System.IO.FileStream("c:\\graphics.txt", System.IO.FileMode.OpenOrCreate, System.IO.FileAccess.Write, System.IO.FileShare.ReadWrite);
StreamWriter streamWriter=new StreamWriter(fs);
if(drawwhat==1)
{
for(int j=0;j

Re: Graphics ..with c #

Christian Graus2-May-07 15:28

Christian Graus

2-May-07 15:28

mr jets wrote:
about my open code what should i do to make the program display the file after reading the data from the text..?

Like I said, you need to parse the text and use it to fill your array of points. It really seems to me like you probably need an array of instances of a struct that contains all the data you need to draw different items, I thought I saw you drawing polygons, etc ? But, either way, what ever you store in your array, you need to repopulate. Your drawing code draws based on that array, right ? So how can it draw if you don't populate that array with the data ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

How to get a mini dump?

Super Lloyd2-May-07 13:33

Super Lloyd

2-May-07 13:33

On some client's computer the XmlDocument.Save() fails with some weird internal error such as:

==============
Exception : System.IO.IOException
Message : Unknown error "-1".
Source : mscorlib
Help :
Stack :
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)

at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
at System.Xml.XmlDocument.Save(String filename)
===============

I have reported such a problem to microsft and they just told me they need more information such as a mini dump.
how do I do one?

Re: How to get a mini dump?

Super Lloyd2-May-07 17:20

Super Lloyd

2-May-07 17:20

found it:
http://blogs.msdn.com/greggm/archive/2004/08/14/214725.aspx[^]

Select from another select statement to a repeater

simsen2-May-07 11:28

simsen

2-May-07 11:28

Hi,

I have a big problem, I hope you can help me with.

What I want:
A forum where there is 3 columns Subject, AnswersCount, LastAnswer

I have one table with all the data. And two selects functions, where I on the first, get all Subjects for all questions, and on the second select get the Count for all answers on a specific question (with input quiestionId). Both functions works perfect, when I use them seperatly.

But I have to go through all rows in the first selection to find the Count

What shall I do to that?

The code I have now is:

The Repeater, where I want to put all data into:
<asp:repeater id="repDebatIndlaeg" runat="server">
<headertemplate>

Antal indlæg ialt:
<asp:label id="lblIndlaegIalt" runat="server" text="Label">


Emne	Antal indlæg	Seneste indlæg

<asp:hyperlink id="lnkEmne" runat="server" text="<%# Eval("Overskrift") %>" navigateurl="<%# "~/Debat.aspx?id=" + Eval("DebatId") %>">	<asp:label id="lblAntalIndlaeg" runat="server" text="<%# Eval("DebatNr") %>">	<asp:label id="lblSenesteIndlaeg" runat="server" text="<%# Eval("Dato") %>">

The codebehind:

protected void Page_Load(object sender, EventArgs e)
{
DebatApi debatapi = new DebatApi();

if (!IsPostBack)
{
try
{
DataTable Debat = null;
if (debatapi.GetDebat(ref Debat) == Status.Success)
{
int tael = 0;

for (int i = 0; i < Debat.Rows.Count; i++)
{
tael = Convert.ToInt32(Debat.Rows[i]["DebatId"]);
DataTable DebatCount = null;

if (debatapi.GetCountAnswers(tael, ref DebatCount) == Status.Success)
{

}
}
repDebatIndlaeg.DataSource = Debat.DefaultView;
repDebatIndlaeg.DataBind();
}
}
catch
{
}
}

debatapi.Dispose();
}

What shall I put into here so I can write the output into the repeater:
if (debatapi.GetCountAnswers(tael, ref DebatCount) == Status.Success)
{

}

If it was a label outside an repeater, I would make something like:

lblAntalIndlaeg.Text = Convert.ToInt32(GetKontoplanFuld.Rows[i]["DebatNr"]);

But VS cann't finde the lblAntalIndlaeg Frown | :-(

I hope someone can help me....Im pretty desperat....

Kind regards,
simsen Smile | :)

How can I have my Cursor visiable?

Khoramdin2-May-07 11:26

Khoramdin

2-May-07 11:26

Hello everyone,

I am using Directshow API in Visual C# enviroment. I am using the following code to toggle Full-Screen. My problem is that when I have the Full-Screen mode, my courser disapears! Can someone tell me how I can have my Courser visiable in the Full-Screen mode?

	void ToggleFullScreen()<br />
	{<br />
		if( videoWin == null )<br />
			return;<br />
<br />
		int mode;<br />
		int hr = videoWin.get_FullScreenMode( out mode );<br />
		if( mode == DsHlp.OAFALSE )<br />
		{<br />
			mode = DsHlp.OATRUE;<br />
			hr = videoWin.put_FullScreenMode( mode );<br />
            if (hr >= 0)<br />
            {<br />
                fullScreen = true;<br />
            }<br />
		}<br />
		else<br />
		{<br />
			mode = DsHlp.OAFALSE;<br />
			hr = videoWin.put_FullScreenMode( mode );<br />
            if (hr >= 0)<br />
            {<br />
                fullScreen = false;<br />
            }<br />
			this.TopMost = true;<br />
			this.Refresh();<br />
		}

Thank you very much and have a great day.

Khoramdin

Re: How can I have my Cursor visiable?

AFSEKI7-May-07 5:56

AFSEKI

7-May-07 5:56

1) Before toggling to full screen mode, store a reference to your main window.

2) then handle mouse_move events

3) call Cursor.Draw(..) to draw it on the form as (source code from MSDN Library):

private void DrawCursorsOnForm(Cursor cursor)
{
// If the form's cursor is not the Hand cursor and the
// Current cursor is the Default, Draw the specified
// cursor on the form in normal size and twice normal size.
if(this.Cursor != Cursors.Hand &
Cursor.Current == Cursors.Default)
{
// Draw the cursor stretched.
Graphics graphics = this.CreateGraphics();
Rectangle rectangle = new Rectangle(
new Point(10,10), new Size(cursor.Size.Width * 2,
cursor.Size.Height * 2));
cursor.DrawStretched(graphics, rectangle);

// Draw the cursor in normal size.
rectangle.Location = new Point(
rectangle.Width + rectangle.Location.X,
rectangle.Height + rectangle.Location.Y);
rectangle.Size = cursor.Size;
cursor.Draw(graphics, rectangle);

// Dispose of the cursor.
cursor.Dispose();
}
}

this is the first idea I had after 11 hours of non-stop programming, hope it helps...

Update() database from DataSet

aecordoba2-May-07 10:58

aecordoba

2-May-07 10:58

Hi, there!
I can't Update a table in database after a row is deleted in DataSet.
I delete a row, as following:

DataRow[] usersRows;<br />
usersRows = ContactsDataSet.Users.Select("UserName = '" + userName + "'");<br />
foreach (DataRow userRow in usersRows)<br />
          userRow.Delete();

and I tried to update the database:

DataSetTableAdapters.UsersTableAdapter usersTableAdapter = new    DataSetTableAdapters.UsersTableAdapter();<br />
usersTableAdapter.Update(contactsDataSet.Users);

But the data aren't updated.

Can someone help me?

Thank you in advance.

--
Adrián Córdoba