|
Hello Everyone,
I have retrieved data in Grid View from wizard.. I have modified 2 fields in Grid View
I need to update the same using update command using table-adapter.
Can anyone help me how to use update command...
Thanks in advance..
|
|
|
|
|
This question has been asked and answered so many times in these forums that it is almost impossible to count.
Use the search box at the top of the page (or use Google) and search on something like tableadapter update.
You will get loads of hits and it is much faster than waiting for an answer from here.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
How can i let the user insert a new values into a combobox inside of datagridview?
I have datagrigview with columns.
One of them contain 5 values that are common and there is a lot of values that the user can insert them by him self.
The problem is that if choose Combobox in the datagrid then the user can only choose the values that been insert to item list of the combobox and if i choose textbox then the user can't pick default values by click, just by writing the full name.
What can i do if i want the user to possibility to choose or to write new values?
|
|
|
|
|
I wrote a Web application by ASP.NET and C#. I need to change date of my server behind about 1 year ago and after that changing date came back. For example, time is 30/09/2009 and when the program runs, time should be 30/09/2008 and after 3sec time comes back 30/09/2009.
I wrote this rule by ASP.NET and C# and that web application work correctly, but for 5 days, that code can't change date of server, although web application worked correctly and could change date by below codes.
Also these codes work and can change date of server when those are written as WIN application and don't return any error, and those are written as WEB application and run in Visual Studio 2008 don't return any error and works correctly, but when those codes are written as WEB application and run in ISS can't change date of server and return "error: 1314", so I be confused!!!
I will be very glad if somebody helps me.
Thank you very much.
<pre> [DllImport("kernel32.dll", SetLastError = true)]
public static extern int SetLocalTime(ref SystemTime lpSystemTime);
[DllImport("kernel32.dll", SetLastError = true)]
private static extern uint GetLastError();
public struct SystemTime
{
public short wYear;
public short wMonth;
public short wDayOfWeek;
public short wDay;
public short wHour;
public short wMinute;
public short wSecond;
public short wMilliseconds;
}
private void ChangeDate()
{
SystemTime systNew = new SystemTime();
systNew.wDay = (short)dateTime.Day;
systNew.wMonth = (short)dateTime.Month;
systNew.wYear = (short)2008;
systNew.wHour = (short)dateTime.Hour;
systNew.wMinute = (short)dateTime.Minute;
systNew.wSecond = (short)dateTime.Second;
SetLocalTime(ref systNew);
uint lastErrCode = GetLastError();
}</pre>
|
|
|
|
|
Hi,
FYI: Error 1314 = A required privilege is not held by the client.
FWIW: As a user of some systems, I would hope other users can't change the system date.
Luc Pattyn
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
Hi
Thanks for your answer, but how can I solve this problem?
my code until 5 days ago ran correctly,but now can't run.
Regards,
|
|
|
|
|
As I said, I hope it is impossible, which implies I don't know if it can be done, let alone how to do it.
Also I don't see why it could be relevant, other than using some software whose license ran out; I wouldn't consider offering any help about this.
Luc Pattyn
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
Pars.Engineer wrote: run in ISS
Wow, ive written some important apps - but running on the ISS is indeed very important. I wonder how changing its system cliock might affect its geo-stationary orbit.
Im guessing that 5 days ago, somebody changed the permissions on the user which is running your web app in IIS. The fix therefore is to find what was changed and change it back.
|
|
|
|
|
Hi,
Thanks for your reply, yes it work correctly until 5 days ago, but now can't change date of server from IIS.
I didn't change any permissions and everyone have all permissions.
How can I solve this problem?
Regards,
|
|
|
|
|
Pars.Engineer wrote: I didn't change any permissions and everyone have all permissions.
Do you control all permissions in your domain? If you have a sysadmin, its likely they may have locked down the user for which the website runs.
|
|
|
|
|
thanks for replay
yes i have full permission on domain and server.
you have no idea for slove this problem?
i am very confused .
Regards,
|
|
|
|
|
|
Hello Everyone,
I am using access db. In database there is 1 table having company and addres as columns.
I have retrieved company in combo box.. What I want is on the selection of company in combo box it should display appropriate address in label..
I have retrieve data in combo box through wizard.
Can anyone please help me in write code..
Thanks in advance..
Chetan
|
|
|
|
|
If your ComboBox is set up properly, the ValueMember property should be the Primary Key for that company. All you then need to do is to pass that as a parameter to a SQL Query to retrieve the address.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
I strongly suggest you buy a book and read/work through a it. As soon as you state you achieved something using a wizard then we know you will probably not understand the answer. You need to get some understanding of programming and data manipulation, not just following the wizards.
Wizards are great for users they are disasters for developers, they allow you to create simplistic solutions with no real knowledge of how it is achieved.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
i have a crystal report program writen in c#, i want to convert numerics to words. i don't know how to do that.
can any one help
|
|
|
|
|
i want to creat a landscape report in my crystal report at desing time, i don't have idea how to start.
|
|
|
|
|
I'm not able to get the body of the mail.
Below is the code snippet:
MAPI.Session oSession = new MAPI.Session();
Object vEmpty = Missing.Value;
oSession.Logon("OutLook1", vEmpty, false, false, false, false, vEmpty);
MAPI.Folder oFolder = (MAPI.Folder)oSession.Inbox;
MAPI.Messages oMsgs = (MAPI.Messages)oFolder.Messages;
MAPI.MessageFilter oFilter = (MAPI.MessageFilter)oMsgs.Filter;
oFilter.Unread = true;
MAPI.Message newMessage = (MAPI.Message)oMsgs.GetFirst(oFilter);
while (newMessage != null)
{
string text = newMessage.Text.ToString();
//text is coming as blank.
newMessage.Unread = false;
newMessage.Update(true, true);
newMessage = (MAPI.Message)oMsgs.GetNext();
}
Thanks,
Nitesh
|
|
|
|
|
I googled for the better part of half an hour, and come up with nothing. Given a win 32 error code, how do I get the corresponding error message? FormatMessage() is what I would've used in C++. I'm assuming this can be done without P/Invoke voodoo.
--
Kein Mitleid Für Die Mehrheit
|
|
|
|
|
|
I already have the error code. I want to translate it into an error message, as stated.
--
Kein Mitleid Für Die Mehrheit
|
|
|
|
|
new Win32Exception(win32ErrorCode).Message
|
|
|
|
|
Hi,
you can use a little P/Invoke to access FormatMessage, this is the code I normally use:
using System.Runtime.InteropServices;
public static string GetSystemMessage(int errorCode) {
int capacity = 512;
int FORMAT_MESSAGE_FROM_SYSTEM = 0x00001000;
StringBuilder sb = new StringBuilder(capacity);
FormatMessage(FORMAT_MESSAGE_FROM_SYSTEM, IntPtr.Zero, errorCode, 0,
sb, sb.Capacity, IntPtr.Zero);
int i = sb.Length;
if (i>0 && sb[i - 1] == 10) i--;
if (i>0 && sb[i - 1] == 13) i--;
sb.Length = i;
return sb.ToString();
}
[DllImport("kernel32.dll")]
public static extern int FormatMessage(int dwFlags, IntPtr lpSource, int dwMessageId,
int dwLanguageId, StringBuilder lpBuffer, int nSize, IntPtr Arguments);
Luc Pattyn
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
Thanks.
I had that one nailed down, but I felt an urge not to use it. Every time I see P/Invoke-stuff, I feel a cold chill running down my spine. 
--
Kein Mitleid Für Die Mehrheit
|
|
|
|
|
I don't know any alternative, some holes in .NET need to be filled with P/Invoking old stuff. I just keep those in a separate class of mine.
Luc Pattyn
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
