HTML control - ASP.NET Discussion Boards

insert data from one table to another table (with condition)

Sneha Bisht11-Jul-08 21:13

11-Jul-08 21:13

Hi , i have two table in sql . I have to insert data from Ist table to IInd table . in Ist table there is only two field( id , serial) ,
In IInd table also three field(id , serail1 , serial2)
now i want to insert data from Ist table to IInd table , but in IInd table data has to b entered in particular manner .
Ist table id serial
(1, 001) (2, 002)(3, 003)(4, 004)(5, 005)(6, 006)(7, 007)
(8, 008)(9, 009)(10, 0010)(11, 0011)(12, 0012)(13, 0013)(14, 0014)(15, 0015)(16, 0016)(17, 0017)(18, 0018)(19, 0019)(20, 0020)

this data enterd in IInd table with this manner
(001,002)
(002,003)
(002,003)
(003,005)
(003,006)
(004,007)
(004,008)
(005,009)
(005,0010)
(006,0011)
(006,0012)
(007,0013)
(007,0014)
(008,0015)
(008,0016)
ihis loop worked like that (1>1>2>2>2>3>4>5)

Re: insert data from one table to another table (with condition)

Guffa12-Jul-08 0:55

Guffa

12-Jul-08 0:55

If you just specify how the data should be combined into the second table, it's easy enough to insert it. Example:

insert into SecondTable (serial1, serial2)
select f1.serial, f2.serial
from FirstTable f1
inner join FirstTable f2 on f2.something = f1.something
where f1.something = something and f2.something = something

However, it's not really clear how you mean that the data should be combined into what you show.

Despite everything, the person most likely to be fooling you next is yourself.

problam in nbsp;

Rinki Mukheraji11-Jul-08 21:04

Rinki Mukheraji

11-Jul-08 21:04

I have a excel files in store data. some cells are fill up and some cells are blank. when excel to import grid view and save data base. that time if cell is blank then store the in database but i want to store null value.

how to write a method or function which returns time range values

Rameez Raja11-Jul-08 20:28

Rameez Raja

11-Jul-08 20:28

Hi,

how i write a method or function which returns time range values for example( 8:00 AM to 5:00PM with interval of 15 minutes) becuase i have to add times to each table header cell .

Any help?

Regards

Re: how to write a method or function which returns time range values

Imran Khan Pathan11-Jul-08 20:46

Imran Khan Pathan

11-Jul-08 20:46

rameez Raja wrote:
how i write a method or function which returns time range values for example( 8:00 AM to 5:00PM with interval of 15 minutes) becuase i have to add times to each table header cell .

I did give you an example code. See your previous post.

please don't forget to vote on the post that helped you.

Re: how to write a method or function which returns time range values

Anubhava Dimri13-Jul-08 19:16

Anubhava Dimri

13-Jul-08 19:16

You can write two diffrent function for getting two values

public function get_time_range(BYVAL seta AS Datetime,BYVAL Setb as Datetime) AS Double
{
Dim Diff1,Diff2,Diff3 AS DOUBLE
IF Setb < Seta THEN RETURN 0

Diff1 = DateDiff(DateInterval.Day, Seta.Date, Setb.Date)
Diff2 = DateDiff(DateInterval.Minute, Seta.Minute, Setb.Minute)
Diff3 = DateDiff(DateInterval.Second, Seta.Second, Setb.Second)

Return Diff1 + Diff2/60 + Diff3/60
}

Adding row to the gridview

kimo code11-Jul-08 20:07

kimo code

11-Jul-08 20:07

hi all,
how can i add new row to the gridview without reload the old already created rows,because i have a gridview with 2 templete column one of them are dropdownlist ,when i create new row with the same critera the dropdown list in the first row reload from start and dont have the last selected value
so how can i create new row and the first row keep(stored) the value in it
how can i do that ?
thanks for advice

Kareem Elhosseny

modified on Saturday, July 12, 2008 4:55 AM

HTML control

strawberrysh11-Jul-08 18:49

strawberrysh

11-Jul-08 18:49

Where we can use HTML controls?please give me some example.I think in order form that a customer want to see a preview of her order.is it correct?

Re: HTML control

Imran Khan Pathan11-Jul-08 19:16

Imran Khan Pathan

11-Jul-08 19:16

bbc_sh wrote:
Where we can use HTML controls?please give me some example.I think in order form that a customer want to see a preview of her order.is it correct?

There are no more differece between htmlControl and WebControl.The main defference is that webControls have default runat="server" while htmlControls do not have.
so that htmlControls are not accessible in code behind page but if you set runat="server" property of that control then it work like as webcontrol but with its own property values
Suppose
you use input text and you set runat="server" to it then you can access the value of this control in code behind side by using "Value" property ot "Text" like as textbox

please don't forget to vote on the post that helped you.

How to merge corresponding cells of Table control

Rameez Raja11-Jul-08 18:31

Rameez Raja

11-Jul-08 18:31

Hi, all

how i merge the corresponding cells of table control based upon database startdatetime and enddatetime .

i have added header cells with interval of 15 minutes from 8:00AM to 5:00PM

for example 8:00AM To 9:00AM

iam developing reservtion application .

any help is highly appercaited.

Regards
Rameez

Re: How to merge corresponding cells of Table control

Imran Khan Pathan11-Jul-08 19:04

Imran Khan Pathan

11-Jul-08 19:04

rameez Raja wrote:
i have added header cells with interval of 15 minutes from 8:00AM to 5:00PM

try this code

TimeSpan timeSpan1 = TimeSpan.Parse("5:00");//5:00 AM
            TimeSpan timeSpan2 = TimeSpan.Parse("20:00");// 8:00 PM
            TimeSpan timeSpanDiff = timeSpan2.Subtract(timeSpan1);//hours difference
            int mins = timeSpanDiff.Hours * 60 + timeSpanDiff.Minutes;//total minutes
            int cells = mins / 15;//count number of cells
            string minDiff = "0:15"; //Interval difference
            for (int i = 0; i < cells; i++)
            {
                Response.Write(timeSpan1.ToString() + " - " + timeSpan1.Add(TimeSpan.Parse(minDiff)) + "<br>");
                timeSpan1 = timeSpan1.Add(TimeSpan.Parse(minDiff));
            }</br>

please don't forget to vote on the post that helped you.

Problem with IIS when some one Authenticates

maryam.saboor11-Jul-08 18:24

maryam.saboor

11-Jul-08 18:24

Hi friends,
I have an Authentication part in my website (which is written in .net) in my local system every thing is ok but when I move it to our server, when some one authenticates every thing goes well as he is authenticated and no error is thrown but he is not authenticated and he redirects to login page as he is anonymous! I though may it is because of the server time setting so the cookie is expired but it was not! at last after too much trying I decided to check it on another server and this time it worked correctly!! so I think there is some settings in IIS which cause this problem but as I have searched by now I found nothing! every help or suggestion would be very helpfull,
thanks in advanced.

suggestion is needed

Rameez Raja11-Jul-08 18:11

Rameez Raja

11-Jul-08 18:11

hi

any body who knows names of books regarding MCAD windows application Development Exams Perpartion .

regards

Cannot figure this one out.... SQL datasource & c#

Jacob Dixon11-Jul-08 15:20

Jacob Dixon

11-Jul-08 15:20

Ok here is my code:

string[] info = new string[2];
info[0] = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString();
info[1] = "OPEN";

SqlDataSource sds = new SqlDataSource(ConfigurationManager.ConnectionStrings["HelpDeskConnectionString"].ConnectionString, "Select ID From [Company_Ticket]");
sds.ID = "SqlDataSource1";
this.Controls.Add(sds);

TextBox txt = new TextBox();
txt.ID = "txtTime";
txt.Text = info[0];
txt.Visible = false;
this.Controls.Add(txt);

txt.ID = "txtStatus";
txt.Text = info[1];
txt.Visible = false;
this.Controls.Add(txt);

QueryStringParameter qsp = new QueryStringParameter();
qsp.Name = "AdminName";
qsp.QueryStringField = "Admin";
qsp.Type = TypeCode.String;

ControlParameter cp = new ControlParameter();
cp.ControlID = "TextBox2";
cp.Name = "Issue";
cp.Type = TypeCode.String;
sds.InsertParameters.Add(cp);

cp.ControlID = "TextBox1";
cp.Name = "Company";
cp.Type = TypeCode.String;
sds.InsertParameters.Add(cp);

cp.ControlID = "txtTime";
cp.Name = "Started";
cp.Type = TypeCode.DateTime;
sds.InsertParameters.Add(cp);

cp.ControlID = "txtStatus";
cp.Name = "TheStatus";
cp.Type = TypeCode.String;
sds.InsertParameters.Add(cp);

sds.InsertCommand = "INSERT INTO [Company_Ticket] (Admin, Started, Issue, Company, Status) VALUES (@AdminName, @Started, @Issue, @Company, @TheStatus)";
sds.Insert();

Ok here is the error I get:

The variable name '@TheStatus' has already been declared. Variable names must be unique within a query batch or stored procedure.
Must declare the scalar variable "@AdminName".

I don't get it.. I declare TheStatus only once.. and why do I keep getting this about AdminName?

Re: Cannot figure this one out.... SQL datasource & c#

Mike Ellison11-Jul-08 15:31

Mike Ellison

11-Jul-08 15:31

You are only instantiating a ControlParameter once. Create a new instance for each parameter -

 ControlParameter cp = new ControlParameter();
   cp.ControlID = "TextBox2";
   cp.Name = "Issue";
   cp.Type = TypeCode.String;
   sds.InsertParameters.Add(cp);

 cp = new ControlParameter();
   cp.ControlID = "TextBox1";
   cp.Name = "Company";
   cp.Type = TypeCode.String;
   sds.InsertParameters.Add(cp);

etc...

Re: Cannot figure this one out.... SQL datasource & c#

Jacob Dixon12-Jul-08 4:31

Jacob Dixon

12-Jul-08 4:31

WOW I can not believe I didnt notice that.
I have making a v2 for my company for a ticketing software and used the same method in the last one. It worked... because I did use cp = new ControlParameter().
I was combining the two to see if I could figure it out and I over looked that... WOW

Thanks though!

how to close/hide the popup onmouseout event

For_IT11-Jul-08 15:06

For_IT

11-Jul-08 15:06

Hi all,

I have created helptooltip usercontrol and using it on my other controls and pages.

aspx is

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="HelpTooltipButton.ascx.cs" Inherits="Controls.HelpTooltipButton" %>
<asp:ImageButton ID="TooltipButton" runat="server" Height="19px" Width="19px" ImageUrl="~/Images/HelpIcon_sm.gif" />

the code behind is :

protected override void OnPreRender(EventArgs e)
  {
      this.TooltipButton.TabIndex = 1000;
      functionScript = new System.Text.StringBuilder("showPopup('" + Content + "','" + Title + "','" + TooltipButton.ClientID + "');return false;");
      TooltipButton.OnClientClick = functionScript.ToString();
      TooltipButton.CausesValidation = ButtonValidator;
  }

This control is being used in other user controls.

In my main aspx page, I have used multiview control, to use for tabstrip.
when I am on one tab, and if help button is clicked, helptooltip opens.
without closing that tooltip if I move to other tab, the tooltip is still open.

I would like to close that popup when I move from one tab to other.

I tried to use mouseover and mouseout events for the tooltip as:

protected override void OnPreRender(EventArgs e)
      {
          if ((TEAMAppConstants.m_AppMode == TEAMAppConstants.AppMode.AdminPages) && (TEAMAppConstants.SelectedUseCase == TEAMAppConstants.DASHBOARD_STATUS))
          {
              return;
          }
          this.TooltipButton.TabIndex = 1000;
          functionScript = new System.Text.StringBuilder("showPopup('" + Content + "','" + Title + "','" + TooltipButton.ClientID + "');return false;");
//          TooltipButton.OnClientClick = functionScript.ToString();
          TooltipButton.Attributes.Add("onmouseover", functionScript.ToString());
          TooltipButton.Attributes.Add("onmouseout", "hidePopup('" + TooltipButton.ClientID.ToString() + "');");
          TooltipButton.CausesValidation = ButtonValidator;
      }

here, onmouseover tooltip opens, but on mouseout I javascript exception as object not found.

can anyone please suggest me, how can I handle onmouseout event to close the already opened tooltip help?

Many thanks.

Controlling page elements from a .config file

Cyberpulse11-Jul-08 14:10

Cyberpulse

11-Jul-08 14:10

Is there a way to create a config file that controls the elements on specific pages. For example I have 2 pages viz. page1.aspx and page2.aspx. I want to have a config file in which I can control the visible property of the textbox controls on both pages.

Something like this:-

<page  id = "page1.aspx">

         <controls>

             <control1 ID = "Textbox1" Visible = "false">

         </controls>

</page>
<page  id = "page2.aspx">

         <controls>

             <control1 ID = "Textbox1" Visible = "true">

         </controls>

</page>

Re: Controlling page elements from a .config file

Mike Ellison11-Jul-08 15:36

Mike Ellison

11-Jul-08 15:36

Well, you could create an HttpModule that reads the config file, identifies the current page, and injects a Load or PreRender event handler to hide or display controls.

Can I ask why you would want to do this? What's wrong with setting the property on the page?

Custom control for FormView?

equalizer70011-Jul-08 8:49

equalizer700

11-Jul-08 8:49

I have a need to enter names and addresses throughout a web application. How can I create a control (C#) that I can include in a FormView control that will allow names and addresses to be entered with the fields bound to a datasource via a Formview Template?

Re: Custom control for FormView?

Paul Conrad11-Jul-08 9:59

Paul Conrad

11-Jul-08 9:59

Do a google search and tons of examples are bound to pop up.

"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

Help - >SQLException

Apr^Ngp11-Jul-08 8:19

Apr^Ngp

11-Jul-08 8:19

My code is

public void Insert()
    {
        string query =
            "INSERT INTO WordTable (Word_ID,Word,Help) " +
            "VALUES (@Word_ID,@Word,@Help)";
        SqlConnection conn = new SqlConnection(cs);
        SqlCommand cmd = new SqlCommand(query, conn);
        cmd.Parameters.Add(new SqlParameter("@Word_ID",this.Word_ID));
        cmd.Parameters.Add(new SqlParameter ("@Word",this.word));
        cmd.Parameters.Add(new SqlParameter ("@Help",this.Help));
        conn.Open();
        cmd.ExecuteScalar();
    }

And the exception is

System.Data.SqlClient.SqlException was unhandled by user code
  Message="String or binary data would be truncated.\r\nThe statement has been terminated."
  Source=".Net SqlClient Data Provider"
  ErrorCode=-2146232060
  Class=16
  LineNumber=1
  Number=8152
  Procedure=""
  Server="\\\\.\\pipe\\F52FA45D-C426-4C\\tsql\\query"
  State=13
  StackTrace:
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteScalar()
       at SQLWord.Insert() in e:\asp.net\hangaro\App_Code\SQLWord.cs:line 48
       at WordList.AddWord(SQLWord w) in e:\asp.net\hangaro\App_Code\WordList.cs:line 52
       at Add_Word.WriteToSQL() in e:\asp.net\hangaro\Add_Word.aspx.cs:line 60
       at Add_Word.Add_Click(Object sender, EventArgs e) in e:\asp.net\hangaro\Add_Word.aspx.cs:line 36
       at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
       at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
       at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
       at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
       at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
  InnerException:

I have checked the values of
this.Word_ID etc...
What shall I do ?

Apurv

Re: Help - >SQLException

ToddHileHoffer11-Jul-08 9:27

ToddHileHoffer

11-Jul-08 9:27

Try executenonquery instead of executescalar.

scalar is for a select statement, it returns the first value of the first row.

I didn't get any requirements for the signature

Getting information from datalist

Jacob Dixon11-Jul-08 7:14

Jacob Dixon

11-Jul-08 7:14

I am trying to change a LinkButton to disabled/enabled:

LinkButton newNext = (LinkButton)DataList1.FindControl("NextHyperLink");
newNext.Enabled = !pdDataSource.IsLastPage;

this will not work.. it returns that newNext is null...

The linkbuttons are in the HeadTemplate of the DataList1??

Re: Getting information from datalist

Parwej Ahamad11-Jul-08 7:26

Parwej Ahamad

11-Jul-08 7:26

Problem is seems like where you are calling Find Control.

Datalist contains more that one items so you will need to provide specific item.

Can post here code that in which you are calling ?

Parwej Ahamad
R & D: REST services with WCF

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.