|
The provider might not have a way or the time to import SQL Express database into SQL Server 2005 Database. The database created by the provider is usually blank and you are required to re-create all the necessary objects through the provided interface
|
|
|
|
|
I'm creating an on-line application that has a submit button. When submit action occurs, the form data is then submitted to a Positional Flat File. The reason why I have to use flat file is because the company that we outsourced for our recruiting database uses flat file text to input into the database. I have no idea how to submit form data to a positional flat file. I have to flat file template with the record lengths. Can anyone help?
|
|
|
|
|
just create a sting of the record length. Then place each item in the string in the respective position. Another option is to pad each item to its max length, they append it to create the record.
You may want to consider creating a simple class that contains each field, then a create method to concatenate the individual fields to the record length.
|
|
|
|
|
Is there code snippets that I can see to help me get started? Any tutorials or examples?
|
|
|
|
|
I explained it clearly enough to get you started. It's pretty much scoped.
|
|
|
|
|
I know that you explained it but I'm an extreme beginner. So I'm going to start with remedial questions. Is there a different forum that is for someone who is as remedial as myself? If not, I have a couple questions:
1. When I hit submit to call the action on my Application.asp page, I need to have a method which is post and my action which is??? That's where I'm lost, When I add a new item in Visual Studio, should it be a vbscript file?, jscript file?, a vb module? That's where I need to begin.
|
|
|
|
|
If you're an extreme beginner programmer, how did you get this assignment in the first place?
Is it homework?
|
|
|
|
|
No, it's an actual project. Our supervisor wanted to have one of us learn .net so I'm starting these classes soon but I have to start the project now. I have the form laid out with the validations, I'm just lost after that. Once the submit button is clicked, I'm lost, I have no idea what to do. I don't want to seem totally clueless so I don't get in trouble, so I'm trying really hard to figure it out. I have the flat file template with how many char lengths for each field. That's why I asked for tutorials or code snippets so I can learn from it. I don't want to frustrate people on this forum, I just need help starting out with this stuff.
|
|
|
|
|
You have EVERYTHING you need. Create string values for each field. Pad them with blanks to get the desired length. Concatenate them to create the record. What else could you possibly need?
string field1;
....
field1.PadRight(fieldlength, " ");
fullrecord = field1 + field2...
Any programmer, that knows ANY programming language can grasp this.
|
|
|
|
|
I don't have a language to grasp, that's the problem chief.
For Example:
Would it start like this:
<%
Dim Field1
Field1=Request.Form("first name")
string field1;
field1.PadRight(fieldlength,"20");
Do I have to declare anything? You have to understand that I'm in Kindergarden with this stuff.
|
|
|
|
|
I don't mean this to be condescending, but you really need an ASP.NET book. There is no reason for Request.Form for this type of application. ASP.NET is event driven. You can create several textboxes for user input and a button. On the OnClick event of the button you do you actions.
(you can also set the MaxLength for each TextBox to the length of corresponding field)
If you're using VB.NET the declaration would be:
Button1_Click(...)
Dim WholeRecord as String
Dim Field1 as String
Dim Field2 as String
...
Field1 = Textbox1.Text
...
WholeRecord = Field1.PadRight( whateverThisFieldLengthIs, " ") + ...
That's basically it as far as creating the record.
Then you have your record to be saved.
|
|
|
|
|
I bought the SAMS teach yourself ASP.NET in 21 days book but there is nothing about submitting form data to a flat file but maybe I need to look harder.
|
|
|
|
|
I think you're worrying about the flat file concept too much. As a rudimentary test, try this:
Get the first 3 field names from the requirement.
In this example, I'll just call them Field1 thru Field3, but you would give them more descriptive names.
On the webform, add 3 textboxes (TextBox1 thru TextBox3).
In each Textbox's MaxLength property, set it to the field length (from the requirement) for this example I used (30,20 and 25, respectively) .
Now add a button and a label to the form (Button1 and Label1).
Double Click on the button to bring up the OnClick event code.
In the Button1_Click event, type the following.
string Field1;
string Field2;
string Field3;
string FlatRecord;
Field1 = TextBox1.Text;
Field2 = TextBox2.Text;
Field3 = TextBox2.Text;
FlatRecord = Field1.PadRight( 30, " ") + Field2.PadRight( 20, " ") + Field3.PadRight( 25, " ");
Label1.Text = FlatRecord;
Now, compile and run the project. Add some text to each textbox, and click the button. The result in Label1 will be a flat file record. There is really nothing to get hung up about.
|
|
|
|
|
That's what I needed, Thanks. I just had to change some code around to declare DIM statements. It showed up in the label. Now how do I make the Flatrecord = a text file on the server? and I have to append to this file? I started reading the book and alot of stuff is making sense now.
|
|
|
|
|
In your book, check out:
Day 13—Reading and Writing Files on the Web Server.
Using Files with ASP.NET. Including External Files. Accessing Files. Isolated Storage.
|
|
|
|
|
What else can I do to learn .net?
|
|
|
|
|
In the application that I'm building, I ask a question in the form and I have a drop down list with yes or no as the values. If the user selects no, I need a validation to occur that says, Sorry but we can't process your application at this time. Can someone help out?
|
|
|
|
|
In your button's OnClick event, just add code to check it.
If (ddlWhatever.SelectedValue = "No") <- or whatever it's VALUE is
Response.ReDirect( your url);
|
|
|
|
|
Say you have Two DropDownLists
DDL1
DDL2
DDL1=Start Year 2005
DDL2=End Year 1999 End Year is Less Than Start Year!
How do you validate if End Year is Less Than Start Year. I already tried the compare validator with the Less Than Operator, it didn't work. Any Suggestions?
|
|
|
|
|
Hi!
I have a parent user control and it has a child user control. In the childs Page_Init function I want to use a variable from the parent.
parent:
Code:
...
protected int a = 21;
...
child:
Code:
...
private void Page_Init( ... )
{
...
//here I want to get a hold of variable a
}
...
How can I do this?
gdfgdfg
|
|
|
|
|
Iterate through the Controls to find it, if it's HasControls property is true.
|
|
|
|
|
Create a property on the child control and set it in the parent at page load or init
ChildUserControl
property ?? MyValue { MyPrivate = value; }
ParentUseControl_OnLoad()
{
Child.MyValue = 21;
}
only two letters away from being an asset
|
|
|
|
|
Hello, I would like to change the color and font in a aspx page when a button or a link is clicked (so it has to be an event triggered by a user). I can’t just use CSS since that’s static and it will be changed forever and not dynamically on the button click event. And I don’t want to use JavaScript because of the browser restrictions that we are running into. So I have to do it on the server side (that is in the button1_click event). Please help me out with that.
Thanks
Tina
|
|
|
|
|
Are we talking about a large amount of text or just a couple of things?
There are several options that I can think of.
You can enclose your text in a normal or tag, only add a 'runat' and 'id' directive. Doing this gives you access to a "Style" property programmatically. For example:
<br />
<p runat='server' id='myPara'> Here is some sample text. </p><br />
<br />
myPara.Style = "color:red; font-family:Arial";<br />
<br />
However, a way that you can still use CSS is to encompass your text in an <asp:label> control. This gives you access to a property called "CssClass". So then in your button click event you can do something like:
<br />
lblMyText.CssClass = "MyCssStyle";<br />
|
|
|
|
|
Hello there, thanks for the quick response. However I'm just changing the color of a particular control like you mentioned. I'm actually going to be changing the entire page's color and font. And that's why I looked at htmlForm element.
HtmlForm frm = new HtmlForm(); Now this has a bunch of properties and methods but bgColor or anyother way of changing the color is not provided. The same thing applies to your other suggestion regarding the styles sheet, since its the entire page I don't know if we associate the class attribute to the whole form. Any ideas???
Thanks
Tina
|
|
|
|