|
I am trying to use objectdatasource control binded to a dataset in VS 2005.
I have clicked the Refresh dataset option and in the designer.cs generated code it generates below statement.
how do I retreive the autoincrement coloumn of _ENTITYID from the objectdatasource ?
Also when I run this SQL statement it gives me the last entered row to the table which is cool but
, I could not find it the @_ENTITYID in select parameters and insert parameters while debugging the objectdatasource control.
What should I do ?
____________
exec sp_executesql N'INSERT INTO [LEAD] ([_ENTITYOWNER], [_ENTITYUSER], [_ENTITYMODIFYDATE], [_ENTITYCREATEDATE], [_ENTITYSTATUS], [_NAME], [_ISACTIVE], [_STATE], [_DESCRIPTION], [_CATEGORY], [_SECURITYCODE], [FIRSTNAME], [LASTNAME], [PREFIX], [COMPANYNAME], [INDUSTRY], [TITLE], [ANNUALREVENUE], [NUMBEROFEMPLOYEES], [RATING], [STATUS], [SOURCE], [HOMETEL], [FAXTEL], [MOBILETEL], , [NONSOLICITATIONINDICATOR], [COUNTRYNAME], [CITYNAME], [POSTALCODE], [STREETNAME], [DISTRICTNAME]) VALUES (@_ENTITYOWNER, @_ENTITYUSER, @_ENTITYMODIFYDATE, @_ENTITYCREATEDATE, @_ENTITYSTATUS, @_NAME, @_ISACTIVE, @_STATE, @_DESCRIPTION, @_CATEGORY, @_SECURITYCODE, @FIRSTNAME, @LASTNAME, @PREFIX, @COMPANYNAME, @INDUSTRY, @TITLE, @ANNUALREVENUE, @NUMBEROFEMPLOYEES, @RATING, @STATUS, @SOURCE, @HOMETEL, @FAXTEL, @MOBILETEL, @EMAIL, @NONSOLICITATIONINDICATOR, @COUNTRYNAME, @CITYNAME, @POSTALCODE, @STREETNAME, @DISTRICTNAME);
SELECT _ENTITYID, _ENTITYOWNER, _ENTITYUSER, _ENTITYMODIFYDATE, _ENTITYCREATEDATE, _ENTITYSTATUS, _NAME, _ISACTIVE, _STATE, _DESCRIPTION, _CATEGORY, _SECURITYCODE, FIRSTNAME, LASTNAME, PREFIX, COMPANYNAME, INDUSTRY, TITLE, ANNUALREVENUE, NUMBEROFEMPLOYEES, RATING, STATUS, SOURCE, HOMETEL, FAXTEL, MOBILETEL, EMAIL, NONSOLICITATIONINDICATOR, COUNTRYNAME, CITYNAME, POSTALCODE, STREETNAME, DISTRICTNAME FROM LEAD WHERE (_ENTITYID = SCOPE_IDENTITY())', N'@_ENTITYOWNER nvarchar(4000),@_ENTITYUSER nvarchar(4000),@_ENTITYMODIFYDATE datetime,@_ENTITYCREATEDATE datetime,@_ENTITYSTATUS int,@_NAME nvarchar(4000),@_ISACTIVE bit,@_STATE nvarchar(4000),@_DESCRIPTION nvarchar(4000),@_CATEGORY nvarchar(4000),@_SECURITYCODE int,@FIRSTNAME nvarchar(4000),@LASTNAME nvarchar(4000),@PREFIX nvarchar(4000),@COMPANYNAME nvarchar(4000),@INDUSTRY nvarchar(4000),@TITLE nvarchar(4000),@ANNUALREVENUE nvarchar(4000),@NUMBEROFEMPLOYEES nvarchar(4000),@RATING nvarchar(4000),@STATUS nvarchar(4000),@SOURCE nvarchar(4000),@HOMETEL nvarchar(4000),@FAXTEL nvarchar(4000),@MOBILETEL nvarchar(4000),@EMAIL nvarchar(4000),@NONSOLICITATIONINDICATOR nvarchar(4000),@COUNTRYNAME nvarchar(4000),@CITYNAME nvarchar(4000),@POSTALCODE nvarchar(4000),@STREETNAME nvarchar(4000),@DISTRICTNAME nvarchar(4000)', @_ENTITYOWNER = NULL, @_ENTITYUSER = NULL, @_ENTITYMODIFYDATE = NULL, @_ENTITYCREATEDATE = NULL, @_ENTITYSTATUS = NULL, @_NAME = NULL, @_ISACTIVE = NULL, @_STATE = NULL, @_DESCRIPTION = NULL, @_CATEGORY = NULL, @_SECURITYCODE = NULL, @FIRSTNAME = NULL, @LASTNAME = NULL, @PREFIX = NULL, @COMPANYNAME = NULL, @INDUSTRY = NULL, @TITLE = NULL, @ANNUALREVENUE = NULL, @NUMBEROFEMPLOYEES = NULL, @RATING = NULL, @STATUS = NULL, @SOURCE = NULL, @HOMETEL = NULL, @FAXTEL = NULL, @MOBILETEL = NULL, @EMAIL = NULL, @NONSOLICITATIONINDICATOR = NULL, @COUNTRYNAME = NULL, @CITYNAME = NULL, @POSTALCODE = NULL, @STREETNAME = NULL, @DISTRICTNAME = NULL
|
|
|
|
|
I have an application that does some work in the background so I need to show the user some kinda 'processing animation'. How do I make a progressbar that has 5 bars that scrolling left and right throughtout the entire width of the progressbar? This way I can show the user that my app is still working. Any other animation sequences you might know of.
|
|
|
|
|
|
Hi
You might like to use my progress bar: BusyBar[^].
Set Bounce to true.
----------------------------
Be excellent to each other
EasiReports[^] My free reporting component for WinForms.
|
|
|
|
|
Ok I`ll try to explain my problem . ComboBox, places his choice list on top of the other controls, including other panels and so on. The question is - how can I make other custom control maded by myself wich is added to some panel [mPanel.Controls.Add(MyControl);] - to show up on top of the other controls and other panels (like ComboBox choice list), but without separate it from [mPanel.Controls]. Can control actually act like ComboBox list on top of other controls?
|
|
|
|
|
I believe a ComboBox is rendered by the IE browser as a "window" control (as in a Windows Forms' control). Thus, the ComboBox will always appear over everything else. I don't know of any attractive solutions, however.
|
|
|
|
|
Actually I am talking about C# windows form. I have a grid in one panel, other grid in other panel. One of the columns contains comboboxes, ComboBox list, of course appears over the second grid, I want my custom control wich contains some textboxes and other crap show up in similar way. Way I am using - is separate form without close and minimize buttons, but it is not Control added to grid cell, it is separate windows form and it is not good solution, because it shows up in a taskbar and acts like form, but I want to attach it to the grid cell as a normal control 
|
|
|
|
|
hi Oskars!
you can put you custom control on a floating window. this window will be on top of all window, just like the list of the combobox.
try to look at this[^] to have an idea how to make a floating window.
hope that helps!
microsoc 
|
|
|
|
|
Hello,
I am trying to convert this following PHP code to C# for Windows Application, (Not ASP.NET). My intention is to post file attachment to remote server by doing this. I know how to convert base64 in C#, but I dont know which Method of C# do this chunk_split. Can anyone please help !
string chunk_split ( string body [, int chunklen [, string end]] )
This functoin can be used to split a string into smaller chunks which is useful for e.g. converting base64_encode() output to match RFC 2045 semantics. It inserts end (defaults to "\r\n") every chunklen characters (defaults to 76). It returns the new string leaving the original string untouched.
|
|
|
|
|
emran834 wrote: string chunk_split ( string body [, int chunklen [, string end]] )
This functoin can be used to split a string into smaller chunks which is useful for e.g. converting base64_encode() output to match RFC 2045 semantics. It inserts end (defaults to "\r\n") every chunklen characters (defaults to 76). It returns the new string leaving the original string untouched.
What is the problem? From the description its pretty clear what it does, so just implement the same in C#. One way is to use a StringBuilder and inject '\r\n' at every 76 char interval.
|
|
|
|
|
Hi,
thanks for your reply. As I am new in C#, would you please show me the snippet for doing this. !!
Thanks and regards
Emran
|
|
|
|
|
|
I have a windows form application. When the user clicks the pause button, I want to programmatically minimize the window. Does anyone have the snippet for doing this in the 2.0 Framework?
Thanks
|
|
|
|
|
|
Thanks leppie, but I cannot find WindowState in either my instance form or the static Form methods. The closest thing I can find is form.ReflectMessage, but I don't know exactly what the hWnd message would be to do a minimize.
|
|
|
|
|
System.Windows.Forms.Form.WindowState : FormWindowState straight from Reflector.NET
|
|
|
|
|
leppie, I don't doubt you, but in C# Express the Intellisense Forms.Form stops at ReferenceEquals and does not show WindowState at all.
|
|
|
|
|
Its an instance property Unless C# Express is broken or it has changed in .NET 2, it has to be there! 
|
|
|
|
|
I'm not finding it in the instance object either. It is .NE 2 but it is also C# Express which at least limits some of the functionality of the framework. Though I cannot see why they would hide the WindowState property.
|
|
|
|
|
<FONT color=Blue>namespace</FONT> WindowsApplication1
{
<FONT color=Blue>public partial class</FONT> Form1 : Form
{
<FONT color=Blue>public</FONT> Form1<FONT color=DarkBlue>()</FONT>
{
InitializeComponent<FONT color=DarkBlue>()</FONT>;
<FONT color=Blue>this</FONT><FONT color=DarkBlue>.</FONT>WindowState = FormWindowState<FONT color=DarkBlue>.</FONT>Minimized;
}
}
}
|
|
|
|
|
Whew, that did it. Never thought to go into the form code and type this.
Thanks leppie.
|
|
|
|
|
Hi
I am programming in c#.net. I want to insert i record into the SQL Server database. the datetime format in SQL server is mm/dd/yyyy where as in c# its dd/mm/yyyy. therefore when i try to insert dates where the day value is greater then 12 it gives out of range error.
Is there anyway we can change the format (dd/mm/yyyy to mm/dd/yyyy) of the datetime as we insert it into the sql server database.
Deepak Anish
Computer Programmer
Maxumise Fiji Ltd
Suva, Fiji
|
|
|
|
|
Use parameterizes queries, then the date format is not a problem.
If you need to format the date as a string, I suggest that you use the ISO 8601 date format, e.g. yyyy-mm-dd. It's an unambigous date format, so the database can not misinterpret it.
---
b { font-weight: normal; }
|
|
|
|
|
I think you can pass the format via the ToString method.
If all else fails: see my
Article[^]
It's not the best according to readers, but it works .
Coulda, woulda, shoulda doesn't matter if you don't.
|
|
|
|
|
hi
i draw a rectangle in picterebox and i want to rotate it around it's center and i want enable doublebuffering for prevent flicker and get highest quality
for my animation but it doesn't work
the ather problem is when i call g.Dispose(); in timer1_Tick event my app is crash .where does my problem and how to animate my rectangle with
doublebuffering and highest quality without flicker my animation ???
my code here :
Graphics g;
Pen m_pen;
Matrix mat;
int angle;
bool _doBuffer;
public Form1()
{
InitializeComponent();
this.SetStyle(ControlStyles.AllPaintingInWmPaint | ControlStyles.UserPaint | ControlStyles.DoubleBuffer ,true);
this.UpdateStyles();
m_pen = new Pen(Color.Violet,3);
bm = new Bitmap(src);
mat = new Matrix();
angle = 1;
_doBuffer = true;
}
private void button1_Click(object sender, System.EventArgs e)
{
g = pictureBox1.CreateGraphics();
g.DrawImage(bm,20,20,100,100);
timer1.Enabled = true;
timer1.Start();
Invalidate();
}
private Bitmap _backBuffer;
private void timer1_Tick(object sender, System.EventArgs e)
{
if(_backBuffer==null)
{
_backBuffer=new Bitmap(pictureBox1.ClientSize.Width,this.ClientSize.Height);
}
Graphics g=null;
if(_doBuffer)
g=Graphics.FromImage(_backBuffer);
else
g=pictureBox1.CreateGraphics();
g.Clear(Color.White);
g.SmoothingMode = SmoothingMode.AntiAlias;
p = new Point(70,70);
mat.RotateAt(angle,p);
g.Transform = mat;
g.DrawImage(bm,10,10,100,100);
//g.Dispose();
g.DrawImageUnscaled(_backBuffer,10,10,100,100);
Invalidate();
}
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
