|
Hi!
I am facing problem in INSERT statement of SQL 2005 express. Actually I want to save data from one table to another using SQL statement. I want to do something like that, when I will press Create button from DataGride Column. The whole data of that row of that Registration table will insert in some another table like Account. I have tried but I cannot do it. Please help me if anybody can.
|
|
|
|
|
First of all, there's a SQL forum for SQL related questions. Second, you need to provide a lot more information than this - this is too vague. Try to break it down a bit, but you need to do multiple inserts.
|
|
|
|
|
For future reference, there is a SQL Forum on this site. You might have better luck there. 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Hi all,
I am currently working with .Net framework 2.0 with visualstudio 2005.
But now i want to move to .net framework 3.5 with visualstudio 2008.
I am very new to this.so can any one help me how to installation procedure for this.
Quick response will be appreciable
regards..
Y.A.Krishna Prasad
fttyhtrhyfytrytrysetyetytesystryrty
|
|
|
|
|
Download or purchase VS 2008 and the run the setup - then answer some questions about what and where you want things installing. I'm not trying to be funny here, but I really can't see what problem you expect beyond that.
|
|
|
|
|
|
I have been working on a custom DataGridView which will be used in unbound mode. I have had a problem where, if the user edits a cell with text longer than allowed by the database, the text is truncated when it is saved back to the database.
The following OnCellValidating method is my attempt to validate the length of cell text. The idea is that if the new text is longer than allowed by the database, the cell changes its background color, a message is given and the user cannot proceed off the cell until valid data is provided. Here is the code:
1: Protected Overrides Sub OnCellValidating(ByVal e As System.Windows.Forms.DataGridViewCellValidatingEventArgs)
2: Dim Col As DataGridViewColumn = Me.Columns(e.ColumnIndex)
3: Dim FD As FieldDescriptor = TryCast(Col.Tag, FieldDescriptor)
4:
5: If Me.Rows(e.RowIndex).Cells(e.ColumnIndex) IsNot Nothing Then
6: Me.Rows(e.RowIndex).Cells(e.ColumnIndex).Style.BackColor = Col.CellTemplate.Style.BackColor
7: End If
8:
9: If Col.ReadOnly OrElse _
10: (FD.DescriptionRow Is Nothing OrElse FD.DescriptionRow.ColumnMetadata Is Nothing) Then
11: Exit Sub
12: End If
13:
14: Dim CM As DbColumnInfo = FD.DescriptionRow.ColumnMetadata
15: Dim MaxSize As Integer = CM.MaxLength
16: If e.FormattedValue.ToString.Length > MaxSize Then
17: Me.Rows(e.RowIndex).Cells(e.ColumnIndex).Style.BackColor = ColorConstants.MissingData
18: Me.InvalidateCell(e.ColumnIndex, e.RowIndex)
19: ShowMsg(String.Format("This field is limited to {0} characters.", MaxSize), _
20: MsgBoxIcon.Critical, "Text is too long!")
21: e.Cancel = True
22: End If
23: End Sub
The class FieldDescriptor is filled in an earlier phase; its ColumnMetadata property holds a class with the column's metadata such as the varchar size. ShowMsg is a standard interface for providing feedback to the user in various application setups.
The problems I'm having are in trying to set the cell's style property. The change in the background color made in line 17 is never visible, even though I am calling InvalidateCell in the very next line. None of the other invalidate routines work, either. Worse, setting the cell's Style.BackGround property sets CellTemplate.Style.BackColor for the entire column, making my efforts to reset the cell's background to the default color in lines 5-7 pointless. 
Ok, fine, use the ErrorText property. Problem is, if I use e.Cancel = True then the error icon is never rendered, leaving the user with no feedback as to which cell has the error. If I do not set the Cancel property, then error icon is rendered; however, the validation is considered good and the database update (along with the truncation of data) proceeds.
Any suggestions on how to proceed?
|
|
|
|
|
Hi all. I'm developing a solution which is designed to give the end-user a semi-customisable workflow solution where they can define the steps an item need to take through a workflow before it becomes "signed-off". There are several paths which an item can take, and several types of item which may enter the system. It's essentially a bug-tracker system with some bells and whistles on it. I'm wondering if WF is the technology to use. From browsing the documentation it seems as though there's a way to save the state of a workflow and not only that, it's possible to override the default implementation and write my own persistence layer. I'm at the stage where I need to commit to a platform with this, and I'd like some input from anyone who has used, or considered using, this option. Essentially what we're talking about is giving the user a very small subset of the functionality you get with using WF in Visual Studio. They don't need the works, there are fairly small custom parameters. And I need to make this happen fast, like in the next month.
Has anyone out there blooded themselves with a real-world WF project, and have they any input on this?
|
|
|
|
|
|
Hello everyone,
I'm a student of final yr telecom engg. For sometime now, I have been seeking advise/expertise in implementing customized voip applications, which is my project for the final semester.
I plan to develop a voip application which will basically be fielded on a LAN(i.e. no external VOIP provider). This voip network will comprise of a few clients(10 to 20) having either ipphone or analog phones with ATA, enabling voice communication among each other. In addition to this I want to develop a gateway which will be an interface between this network and an external network comprising of hand held radios. This gateway would facilitate voip calls between any client on the network to a hand-held radio operator.
I have a feeling that SIP would be an ideal choice, but I am not able to choose a platform for developing such an application. I have looked into Asterix(trixbox) which was advised to me by some friends...but frankly i am not very comfortable with Linux.
Is there something available in .NET or could any one advise any other platform?
Can anyone provide some help?
|
|
|
|
|
|
Hi,
On my form I have a Business EMail address field. I have a requirement where in the field should not allow any characters which are not valid in the EMail field of the Active Directory (AD).
Is any body aware of the email address regular expression which restricts user to enter any characters which are invalid in the email field of the AD?
Regards,
Vipul Mehta
|
|
|
|
|
A simple Google search [^]would have helped you
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
I need to refresh the hardware device list in the Device Manager instead of doing manual rescan for the hardware changes by right clicking on any of the device and selecting the option for "Scan for hardware changes".
i need to do it using C# code.is there any way to invoke the setupapi.dll to perform the rescanning of all the hardware device in the Device manager list,
I need this because Non-PNP device will not be automatically detected by windows.
thanks and regards
vinayskvs
|
|
|
|
|
|
Thanks for this. It alerted me to the fact that SyncToy 2 has been out for almost a month.
Kevin
|
|
|
|
|
Hi buddies,
My gridview has some data which i want to spool in excel. For that i wrote a code in a button click event like this
protected void imbtnexcel_Click()
{
Response.ContentType = "application/vnd.ms-Excel";
Response.AddHeader("Content-Disposition", "inline;filename=ExcelRPT.xls");
}
im using VS2008.whereas this is working in VS2005
Here the event is getting fired but excel file is not opening.How to acheive this?
T.Balaji
|
|
|
|
|
Hello...
I have a service that basically handles threading. Each generated thread calls a WorkerClass in the Service project that in turn calls a new BaseClass project (dll) to do work. I have a boolean that I set in the WorkerClass which in turn updates the same boolean in the BaseClass project. The boolean simply indicates if the service is running or not running. My threads can take a while to complete (doing file reading, splitting, database reading, inserting, updating...etc...). When the OnStop function is called I want to update the thread in the BaseClass object to set the boolean (bServiceStoped) to true and immediately exit the BaseClass and end the thread. Does anyone know of a way to do this?
thanks...
|
|
|
|
|
|
This column would open a dialogbox when clicked
|
|
|
|
|
|
You can try adding image column from Columns->(Collection Properties)
and on the event of the datagrid click if the clicked column is the image column then you can can call a dialouge box to display.
|
|
|
|
|
What .NET reporting frameworks have you used and liked?
Most people do not like reports but we all know the business world needs them.
I have used ActiveReports for a little while now and noticed a steady decline in their release schedule.
Any suggestions?
|
|
|
|
|
|
SQL Server Reporting Services.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
